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.
