By all means Scott
Provide him the answer.
Scott Gray sent the following on 9/30/2010 2:16 AM:
On 30/09/2010, at 9:38 PM, BJ Freeman wrote:
anything beyond Out Of The Box is beyond this mailing list.
Huh? Since when is this the case?
This list is exactly where people should come when they want to discuss their
business problems and how OFBiz could help solve them.
I suggest you contact someone on the providers list available from the front
page of ofbiz to help you.
biletnikov sent the following on 9/30/2010 12:17 AM:
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>.
