Thank you for your response. The lead time and inventory levels are not used. We are not going to use PreferenceOrder and Ratingtype, because we do not have preferable or not preferable suppliers. All of them are actual, and different products can have own list of suppliers, but the customer wants to select this supplier of the product before he place it into the shopping cart. And I see that the customer selected SupplierProduct can not be considered for the order (in OrderItem) in the current OFBiz data model. We do not use E-commerce shop, we have own front-end solution, so it means we are finding the way how to handle with product suppliers.
Could you suggest which way is the most easier to customize: - store the Product <-> ProductSupplier like one-to-one relation, if the product has 3 suppliers, it means we create 3 products and add the ProductSupplier for each product, if the OrderItem refers to productId we know which supplier we need - have the Product <-> ProductSupplier one-to-many relation, but add supplierId to the OrderItem. Also, we need a UI possibility in OFBiz to edit order items and we should able to select a new supplier for the OrderItem. we use OFBiz just as ERP, Ordering, Accounty, Party management system. On Thu, Sep 30, 2010 at 12:45 AM, BJ Freeman [via OFBiz] < [email protected]<ml-node%[email protected]> > wrote: > are you planning on supplying the PreferenceOrder and Ratingtype to the > customer. > how about the lead time and inventory levels. > > https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=SupplierProduct > > so every productID can be related to Supplier product. > this is done in the Catalog->product-supplier. > > the one to many for supplier product exists > > https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=Product > > The productID in OrderItem relates to many supplierproducts you enter. > you can automatically pick the SupplierPreferenceOrder (main suppler) or > SupplierRatingtype of that you add that will be the best supplier Rating. > > The selection, currently, of the supplier is done by > SupplierPreferenceOrder. This is set up manually and customization is > necessary to use SupplierRatingtype figure this out by the criteria you > set from the data in SupplierProduct. > > if you put the info in the Product detail page they can select it before > order. that is a customization. > > if you put in the Cart after the orders get more complicated unless you > just want to show what ofbiz current logic selects for the supplier. > this also is a customization. > > > > biletnikov sent the following on 9/29/2010 11:55 AM: > > > > > In our case, we sell products which are provided by different suppliers > and > > the customer has ability to select the most preferable supplier. > > > > We see, that OFBiz data model allows to specify the suppliers for each > > product (SupplierProduct), so a product can have many suppliers ( for > > example, 3 SupplierProduct). > > > > But, how to specify the product and the supplier that customer needs for > the > > order? A customer wants to see the supplier in the order. > > > > The Order entity has OrderItem entities, which relate to Product (via > > productId) and nothing for the supplier. > > > > The solution which we see, is to duplicate Product for each supplier and > > have one - to - one relation between Product and SupplierProduct, in > this > > case we are able to determine the supplier by productId. > > > > Is it the best solution? > > > > Thank you. > > > > > > > > > > > > > > > ------------------------------ > View message @ > http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html > To unsubscribe from Many suppliers for product, the customer selects the > necessary supplier, click > here<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4>. > > > -- Best regards, Sergei Biletnikov -- View this message in context: http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2720287.html Sent from the OFBiz - User mailing list archive at Nabble.com.
