You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by biletnikov <bi...@gmail.com> on 2010/09/29 20:55:04 UTC
Many suppliers for product, the customer selects the necessary
supplier
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 this message in context: http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719579.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Many suppliers for product, the customer selects the necessary supplier
Posted by Scott Gray <sc...@hotwaxmedia.com>.
On 1/10/2010, at 8:51 AM, BJ Freeman wrote:
> I agree with this.
> However the response that I responded to was they were not using the ofbiz as their ecommerce, but as ERP, which negated both our suggestions, IMHO.
I'm glad your opinion was humble, because it was wrong.
> so I suggested they contact someone on the provider list, which I have seen others suggest as well.
There is no issue with suggesting that ofbiz services providers could help (they undoubtedly could), the only issue is with you saying that "anything beyond Out Of The Box is beyond this mailing list" which is completely untrue.
I don't really want to keep discussing this but you keep replying with things that make me think you don't understand what I'm saying.
> Scott Gray sent the following on 9/30/2010 12:32 PM:
>> On 1/10/2010, at 8:20 AM, BJ Freeman wrote:
>>
>>> not sure you read his responses.
>>
>> I did.
>>
>>> I can see your point and will try to work what he requirement are beyond the scope of this mailing list.
>>
>> From the mailing list page in confluence: "The user list is intended for installation, deployment, custom development and usage related topics."
>> Essentially, if it is related to OFBiz then it is welcome here.
>>
>>> that sound better.
>>>
>>>
>>> =========================
>>> BJ Freeman
>>> Strategic Power Office with Supplier Automation<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>> Systems Integrator-- Glad to Assist
>>>
>>> Chat Y! messenger: bjfr33man
>>>
>>>
>>> Scott Gray sent the following on 9/30/2010 11:50 AM:
>>>> I would suggest looking at the drop ship functionality that is available in OFBiz and customizing it for this situation. The shopping cart has the ability to set a supplierPartyId per ship group and that can probably be leveraged in this situation. What biletnikov is describing is really just drop shipments with the ability for the customer to decide the supplier rather than leaving the system to do it automatically.
>>>>
>>>> But BJ please try and avoid spreading incorrect information, especially when it has the effect of turning people away from the mailing lists.
>>>>
>>>> Regards
>>>> Scott
>>>>
>>>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>>>
>>>>> 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]<
>>>>>>>> ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
>>>>>>>>> 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>.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>
>>
>
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by BJ Freeman <bj...@free-man.net>.
I agree with this.
However the response that I responded to was they were not using the
ofbiz as their ecommerce, but as ERP, which negated both our
suggestions, IMHO.
so I suggested they contact someone on the provider list, which I have
seen others suggest as well.
Scott Gray sent the following on 9/30/2010 12:32 PM:
> On 1/10/2010, at 8:20 AM, BJ Freeman wrote:
>
>> not sure you read his responses.
>
> I did.
>
>> I can see your point and will try to work what he requirement are beyond the scope of this mailing list.
>
> From the mailing list page in confluence: "The user list is intended for installation, deployment, custom development and usage related topics."
> Essentially, if it is related to OFBiz then it is welcome here.
>
>> that sound better.
>>
>>
>> =========================
>> BJ Freeman
>> Strategic Power Office with Supplier Automation<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>> Specialtymarket.com<http://www.specialtymarket.com/>
>> Systems Integrator-- Glad to Assist
>>
>> Chat Y! messenger: bjfr33man
>>
>>
>> Scott Gray sent the following on 9/30/2010 11:50 AM:
>>> I would suggest looking at the drop ship functionality that is available in OFBiz and customizing it for this situation. The shopping cart has the ability to set a supplierPartyId per ship group and that can probably be leveraged in this situation. What biletnikov is describing is really just drop shipments with the ability for the customer to decide the supplier rather than leaving the system to do it automatically.
>>>
>>> But BJ please try and avoid spreading incorrect information, especially when it has the effect of turning people away from the mailing lists.
>>>
>>> Regards
>>> Scott
>>>
>>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>>
>>>> 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]<
>>>>>>> ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
>>>>>>>> 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>.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>
>>
>
Re: Many suppliers for product, the customer selects the necessary supplier
Posted by Scott Gray <sc...@hotwaxmedia.com>.
On 1/10/2010, at 8:20 AM, BJ Freeman wrote:
> not sure you read his responses.
I did.
> I can see your point and will try to work what he requirement are beyond the scope of this mailing list.
From the mailing list page in confluence: "The user list is intended for installation, deployment, custom development and usage related topics."
Essentially, if it is related to OFBiz then it is welcome here.
> that sound better.
>
>
> =========================
> BJ Freeman
> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat Y! messenger: bjfr33man
>
>
> Scott Gray sent the following on 9/30/2010 11:50 AM:
>> I would suggest looking at the drop ship functionality that is available in OFBiz and customizing it for this situation. The shopping cart has the ability to set a supplierPartyId per ship group and that can probably be leveraged in this situation. What biletnikov is describing is really just drop shipments with the ability for the customer to decide the supplier rather than leaving the system to do it automatically.
>>
>> But BJ please try and avoid spreading incorrect information, especially when it has the effect of turning people away from the mailing lists.
>>
>> Regards
>> Scott
>>
>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>
>>> 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]<
>>>>>> ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
>>>>>>> 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>.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>
>>
>
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by BJ Freeman <bj...@free-man.net>.
not sure you read his responses.
I can see your point and will try to work what he requirement are beyond
the scope of this mailing list.
that sound better.
=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Scott Gray sent the following on 9/30/2010 11:50 AM:
> I would suggest looking at the drop ship functionality that is available in OFBiz and customizing it for this situation. The shopping cart has the ability to set a supplierPartyId per ship group and that can probably be leveraged in this situation. What biletnikov is describing is really just drop shipments with the ability for the customer to decide the supplier rather than leaving the system to do it automatically.
>
> But BJ please try and avoid spreading incorrect information, especially when it has the effect of turning people away from the mailing lists.
>
> Regards
> Scott
>
> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>
>> 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]<
>>>>> ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
>>>>>> 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>.
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>
>
Re: Many suppliers for product, the customer selects the necessary supplier
Posted by Scott Gray <sc...@hotwaxmedia.com>.
So there you go, to create a purchase order the system needs a CarrierShipmentMethod record that looks like this one:
https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=CarrierShipmentMethod&shipmentMethodTypeId=NO_SHIPPING&partyId=_NA_&roleTypeId=CARRIER
Regards
Scott
HotWax Media
http://www.hotwaxmedia.com
On 1/10/2010, at 11:46 PM, biletnikov wrote:
>
> Let me demonstrate you what happens if I use
> OrderItemShipGroup.supplierPartyId
>
> Firstly, the system creates the SALES_ORDER and it looks fine (I'm
> debugging). After that, there is a trigger :
>
> <eca service="storeOrder" event="return">
> <condition field-name="orderTypeId" operator="equals"
> value="SALES_ORDER"/>
> <action service="checkCreateDropShipPurchaseOrders" mode="sync"
> run-as-user="system"/>
> </eca>
> and it has begun to create PURCHASE_ORDER
>
> Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
> constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
> constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)) (Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
> constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)))"
> type="org.ofbiz.service.GenericServiceException">org.ofbiz.service.GenericServiceException:
> Could not commit transaction for service [createSalesOrderService] call:
> Roll back error, could not commit transaction, was rolled back instead
> because of: Failure in create operation for entity [OrderItemShipGroup]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
> constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
> constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)) (Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
> constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)))
> at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:546)
> at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219)
> at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> at
> de.alfah.ofbiz.service.test.AlfahOrderProductServiceTest.testCreateOrder(AlfahOrderProductServiceTest.java:30)
> at org.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:137)
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
>
>
>
> On Fri, Oct 1, 2010 at 4:01 AM, Scott Gray-2 [via OFBiz] <
> ml-node+2790029-83301545-170824@n4.nabble.com<ml...@n4.nabble.com>
>> wrote:
>
>> Focus on understanding what the validation errors are telling you, the
>> service that creates the drop ship purchase orders does not use or require a
>> shopping cart for the sales order. Somewhere you have not persisted all the
>> data that ofbiz needs to create the purchase order.
>>
>> Regards
>> Scott
>>
>> On 1/10/2010, at 8:36 AM, biletnikov wrote:
>>
>>>
>>> Thank you for you response.
>>>
>>> I already have the experience of using OrderItemShipGroup.supplierPartyId
>> to
>>> point the necessary supplier for new order creating, so I use
>> "storeOrder"
>>> service for that, unfortunately when I create SALES_ORDER and if the
>>> supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to
>> this
>>> supplier automatically and it faces the validation errors : contact data
>> are
>>> not specified, because they are retrieved from the ShoppingCart, but I do
>>
>>> not use the shopping cart yet. We just develop own service which should
>> be
>>> the mature back-end system and reuse all value things of OFBiz for our
>>> front-end shop.
>>>
>>> On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz] <
>>> [hidden email] <http://user/SendEmail.jtp?type=node&node=2790029&i=0><[hidden
>> email] <http://user/SendEmail.jtp?type=node&node=2790029&i=1>>
>>>> wrote:
>>>
>>>> I would suggest looking at the drop ship functionality that is available
>> in
>>>> OFBiz and customizing it for this situation. The shopping cart has the
>>>> ability to set a supplierPartyId per ship group and that can probably be
>>
>>>> leveraged in this situation. What biletnikov is describing is really
>> just
>>>> drop shipments with the ability for the customer to decide the supplier
>>>> rather than leaving the system to do it automatically.
>>>>
>>>> But BJ please try and avoid spreading incorrect information, especially
>>>> when it has the effect of turning people away from the mailing lists.
>>>>
>>>> Regards
>>>> Scott
>>>>
>>>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>>>
>>>>> 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]<
>>>>>>>> [hidden email] <
>> http://user/SendEmail.jtp?type=node&node=2743575&i=0>
>>>> <[hidden email] <http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
>>
>>>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
>> <
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t&by-user=t&by-user=t>>
>>
>>>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>
>> <
>> http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t&by-user=t&by-user=t>>>.
>>
>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>>
>>>> *smime.p7s* (3K) Download Attachment<
>> http://attachment/2743575/0/smime.p7s>
>>>>
>>>>
>>>> ------------------------------
>>>> View message @
>>>>
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.html<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.html?by-user=t&by-user=t>
>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> 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-tp2719579p2748882.html<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2748882.html?by-user=t&by-user=t>
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>> *smime.p7s* (3K) Download Attachment<http://attachment/2790029/0/smime.p7s>
>>
>>
>> ------------------------------
>> View message @
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2790029.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-tp2719579p2888175.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by biletnikov <bi...@gmail.com>.
Let me demonstrate you what happens if I use
OrderItemShipGroup.supplierPartyId
Firstly, the system creates the SALES_ORDER and it looks fine (I'm
debugging). After that, there is a trigger :
<eca service="storeOrder" event="return">
<condition field-name="orderTypeId" operator="equals"
value="SALES_ORDER"/>
<action service="checkCreateDropShipPurchaseOrders" mode="sync"
run-as-user="system"/>
</eca>
and it has begun to create PURCHASE_ORDER
Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
The statement has been rolled back.)). Rolling back
transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
The statement has been rolled back.)))"
type="org.ofbiz.service.GenericServiceException">org.ofbiz.service.GenericServiceException:
Could not commit transaction for service [createSalesOrderService] call:
Roll back error, could not commit transaction, was rolled back instead
because of: Failure in create operation for entity [OrderItemShipGroup]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
The statement has been rolled back.)). Rolling back
transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key
constraint 'ORDER_ITSG_CSHM' for key (NO_SHIPPING,_NA_,CARRIER).
The statement has been rolled back.)))
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:546)
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219)
at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
at
de.alfah.ofbiz.service.test.AlfahOrderProductServiceTest.testCreateOrder(AlfahOrderProductServiceTest.java:30)
at org.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:137)
at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
at org.ofbiz.base.start.Start.startServer(Start.java:312)
at org.ofbiz.base.start.Start.start(Start.java:316)
at org.ofbiz.base.start.Start.main(Start.java:399)
On Fri, Oct 1, 2010 at 4:01 AM, Scott Gray-2 [via OFBiz] <
ml-node+2790029-83301545-170824@n4.nabble.com<ml...@n4.nabble.com>
> wrote:
> Focus on understanding what the validation errors are telling you, the
> service that creates the drop ship purchase orders does not use or require a
> shopping cart for the sales order. Somewhere you have not persisted all the
> data that ofbiz needs to create the purchase order.
>
> Regards
> Scott
>
> On 1/10/2010, at 8:36 AM, biletnikov wrote:
>
> >
> > Thank you for you response.
> >
> > I already have the experience of using OrderItemShipGroup.supplierPartyId
> to
> > point the necessary supplier for new order creating, so I use
> "storeOrder"
> > service for that, unfortunately when I create SALES_ORDER and if the
> > supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to
> this
> > supplier automatically and it faces the validation errors : contact data
> are
> > not specified, because they are retrieved from the ShoppingCart, but I do
>
> > not use the shopping cart yet. We just develop own service which should
> be
> > the mature back-end system and reuse all value things of OFBiz for our
> > front-end shop.
> >
> > On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz] <
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=2790029&i=0><[hidden
> email] <http://user/SendEmail.jtp?type=node&node=2790029&i=1>>
> >> wrote:
> >
> >> I would suggest looking at the drop ship functionality that is available
> in
> >> OFBiz and customizing it for this situation. The shopping cart has the
> >> ability to set a supplierPartyId per ship group and that can probably be
>
> >> leveraged in this situation. What biletnikov is describing is really
> just
> >> drop shipments with the ability for the customer to decide the supplier
> >> rather than leaving the system to do it automatically.
> >>
> >> But BJ please try and avoid spreading incorrect information, especially
> >> when it has the effect of turning people away from the mailing lists.
> >>
> >> Regards
> >> Scott
> >>
> >> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
> >>
> >>> 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]<
> >>>>>> [hidden email] <
> http://user/SendEmail.jtp?type=node&node=2743575&i=0>
> >> <[hidden email] <http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
>
> >>>>>>> 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<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
> <
> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t&by-user=t&by-user=t>>
>
> >>>>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>
> <
> http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t&by-user=t&by-user=t>>>.
>
> >>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>>
> >>>>
> >>
> >>
> >> *smime.p7s* (3K) Download Attachment<
> http://attachment/2743575/0/smime.p7s>
> >>
> >>
> >> ------------------------------
> >> View message @
> >>
> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.html<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.html?by-user=t&by-user=t>
> >> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>
> >>
> >>
> >>
> >
> >
> > --
> > 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-tp2719579p2748882.html<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2748882.html?by-user=t&by-user=t>
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
> *smime.p7s* (3K) Download Attachment<http://attachment/2790029/0/smime.p7s>
>
>
> ------------------------------
> View message @
> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2790029.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-tp2719579p2888175.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by BJ Freeman <bj...@free-man.net>.
I am aware how the cart is used since it was a set method, it is pretty
clear that it was not referencing a cart from ecommerce.
However that was not what I was talking about.
so I will bow out and let you take this.
Scott Gray sent the following on 9/30/2010 6:38 PM:
> You're not reading the code properly. The cart in this service is a newly created cart for the purpose of creating the drop ship purchase order, it has nothing to do with the sales order.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 1/10/2010, at 2:26 PM, BJ Freeman wrote:
>
>>
>> from checkCreateDropShipPurchaseOrders which is trigger from storeOrder
>>
>> // the shipping address is the one of the customer
>> cart.setShippingContactMechId(shipGroup.getString("contactMechId"));
>>
>> Since the ECA is triggered on return should not the info be gotten from the orderID?
>>
>>
>> Scott Gray sent the following on 9/30/2010 6:00 PM:
>>> Focus on understanding what the validation errors are telling you, the service that creates the drop ship purchase orders does not use or require a shopping cart for the sales order. Somewhere you have not persisted all the data that ofbiz needs to create the purchase order.
>>>
>>> Regards
>>> Scott
>>>
>>> On 1/10/2010, at 8:36 AM, biletnikov wrote:
>>>
>>>>
>>>> Thank you for you response.
>>>>
>>>> I already have the experience of using OrderItemShipGroup.supplierPartyId to
>>>> point the necessary supplier for new order creating, so I use "storeOrder"
>>>> service for that, unfortunately when I create SALES_ORDER and if the
>>>> supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to this
>>>> supplier automatically and it faces the validation errors : contact data are
>>>> not specified, because they are retrieved from the ShoppingCart, but I do
>>>> not use the shopping cart yet. We just develop own service which should be
>>>> the mature back-end system and reuse all value things of OFBiz for our
>>>> front-end shop.
>>>>
>>>> On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz]<
>>>> ml-node+2743575-944428815-170824@n4.nabble.com<ml...@n4.nabble.com>
>>>>> wrote:
>>>>
>>>>> I would suggest looking at the drop ship functionality that is available in
>>>>> OFBiz and customizing it for this situation. The shopping cart has the
>>>>> ability to set a supplierPartyId per ship group and that can probably be
>>>>> leveraged in this situation. What biletnikov is describing is really just
>>>>> drop shipments with the ability for the customer to decide the supplier
>>>>> rather than leaving the system to do it automatically.
>>>>>
>>>>> But BJ please try and avoid spreading incorrect information, especially
>>>>> when it has the effect of turning people away from the mailing lists.
>>>>>
>>>>> Regards
>>>>> Scott
>>>>>
>>>>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>>>>
>>>>>> 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]<
>>>>>>>>> [hidden email]<http://user/SendEmail.jtp?type=node&node=2743575&i=0>
>>>>> <[hidden email]<http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
>>>>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
>>>>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>> *smime.p7s* (3K) Download Attachment<http://attachment/2743575/0/smime.p7s>
>>>>>
>>>>>
>>>>> ------------------------------
>>>>> View message @
>>>>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.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-tp2719579p2748882.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>
Re: Many suppliers for product, the customer selects the necessary supplier
Posted by Scott Gray <sc...@hotwaxmedia.com>.
You're not reading the code properly. The cart in this service is a newly created cart for the purpose of creating the drop ship purchase order, it has nothing to do with the sales order.
Regards
Scott
HotWax Media
http://www.hotwaxmedia.com
On 1/10/2010, at 2:26 PM, BJ Freeman wrote:
>
> from checkCreateDropShipPurchaseOrders which is trigger from storeOrder
>
> // the shipping address is the one of the customer
> cart.setShippingContactMechId(shipGroup.getString("contactMechId"));
>
> Since the ECA is triggered on return should not the info be gotten from the orderID?
>
>
> Scott Gray sent the following on 9/30/2010 6:00 PM:
>> Focus on understanding what the validation errors are telling you, the service that creates the drop ship purchase orders does not use or require a shopping cart for the sales order. Somewhere you have not persisted all the data that ofbiz needs to create the purchase order.
>>
>> Regards
>> Scott
>>
>> On 1/10/2010, at 8:36 AM, biletnikov wrote:
>>
>>>
>>> Thank you for you response.
>>>
>>> I already have the experience of using OrderItemShipGroup.supplierPartyId to
>>> point the necessary supplier for new order creating, so I use "storeOrder"
>>> service for that, unfortunately when I create SALES_ORDER and if the
>>> supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to this
>>> supplier automatically and it faces the validation errors : contact data are
>>> not specified, because they are retrieved from the ShoppingCart, but I do
>>> not use the shopping cart yet. We just develop own service which should be
>>> the mature back-end system and reuse all value things of OFBiz for our
>>> front-end shop.
>>>
>>> On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz]<
>>> ml-node+2743575-944428815-170824@n4.nabble.com<ml...@n4.nabble.com>
>>>> wrote:
>>>
>>>> I would suggest looking at the drop ship functionality that is available in
>>>> OFBiz and customizing it for this situation. The shopping cart has the
>>>> ability to set a supplierPartyId per ship group and that can probably be
>>>> leveraged in this situation. What biletnikov is describing is really just
>>>> drop shipments with the ability for the customer to decide the supplier
>>>> rather than leaving the system to do it automatically.
>>>>
>>>> But BJ please try and avoid spreading incorrect information, especially
>>>> when it has the effect of turning people away from the mailing lists.
>>>>
>>>> Regards
>>>> Scott
>>>>
>>>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>>>
>>>>> 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]<
>>>>>>>> [hidden email]<http://user/SendEmail.jtp?type=node&node=2743575&i=0>
>>>> <[hidden email]<http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
>>>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
>>>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>>
>>>> *smime.p7s* (3K) Download Attachment<http://attachment/2743575/0/smime.p7s>
>>>>
>>>>
>>>> ------------------------------
>>>> View message @
>>>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.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-tp2719579p2748882.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by BJ Freeman <bj...@free-man.net>.
from checkCreateDropShipPurchaseOrders which is trigger from storeOrder
// the shipping address is the one of the
customer
cart.setShippingContactMechId(shipGroup.getString("contactMechId"));
Since the ECA is triggered on return should not the info be gotten from
the orderID?
Scott Gray sent the following on 9/30/2010 6:00 PM:
> Focus on understanding what the validation errors are telling you, the service that creates the drop ship purchase orders does not use or require a shopping cart for the sales order. Somewhere you have not persisted all the data that ofbiz needs to create the purchase order.
>
> Regards
> Scott
>
> On 1/10/2010, at 8:36 AM, biletnikov wrote:
>
>>
>> Thank you for you response.
>>
>> I already have the experience of using OrderItemShipGroup.supplierPartyId to
>> point the necessary supplier for new order creating, so I use "storeOrder"
>> service for that, unfortunately when I create SALES_ORDER and if the
>> supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to this
>> supplier automatically and it faces the validation errors : contact data are
>> not specified, because they are retrieved from the ShoppingCart, but I do
>> not use the shopping cart yet. We just develop own service which should be
>> the mature back-end system and reuse all value things of OFBiz for our
>> front-end shop.
>>
>> On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz]<
>> ml-node+2743575-944428815-170824@n4.nabble.com<ml...@n4.nabble.com>
>>> wrote:
>>
>>> I would suggest looking at the drop ship functionality that is available in
>>> OFBiz and customizing it for this situation. The shopping cart has the
>>> ability to set a supplierPartyId per ship group and that can probably be
>>> leveraged in this situation. What biletnikov is describing is really just
>>> drop shipments with the ability for the customer to decide the supplier
>>> rather than leaving the system to do it automatically.
>>>
>>> But BJ please try and avoid spreading incorrect information, especially
>>> when it has the effect of turning people away from the mailing lists.
>>>
>>> Regards
>>> Scott
>>>
>>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>>
>>>> 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]<
>>>>>>> [hidden email]<http://user/SendEmail.jtp?type=node&node=2743575&i=0>
>>> <[hidden email]<http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
>>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
>>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>
>>>
>>> *smime.p7s* (3K) Download Attachment<http://attachment/2743575/0/smime.p7s>
>>>
>>>
>>> ------------------------------
>>> View message @
>>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.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-tp2719579p2748882.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: Many suppliers for product, the customer selects the necessary supplier
Posted by Scott Gray <sc...@hotwaxmedia.com>.
Focus on understanding what the validation errors are telling you, the service that creates the drop ship purchase orders does not use or require a shopping cart for the sales order. Somewhere you have not persisted all the data that ofbiz needs to create the purchase order.
Regards
Scott
On 1/10/2010, at 8:36 AM, biletnikov wrote:
>
> Thank you for you response.
>
> I already have the experience of using OrderItemShipGroup.supplierPartyId to
> point the necessary supplier for new order creating, so I use "storeOrder"
> service for that, unfortunately when I create SALES_ORDER and if the
> supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to this
> supplier automatically and it faces the validation errors : contact data are
> not specified, because they are retrieved from the ShoppingCart, but I do
> not use the shopping cart yet. We just develop own service which should be
> the mature back-end system and reuse all value things of OFBiz for our
> front-end shop.
>
> On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz] <
> ml-node+2743575-944428815-170824@n4.nabble.com<ml...@n4.nabble.com>
>> wrote:
>
>> I would suggest looking at the drop ship functionality that is available in
>> OFBiz and customizing it for this situation. The shopping cart has the
>> ability to set a supplierPartyId per ship group and that can probably be
>> leveraged in this situation. What biletnikov is describing is really just
>> drop shipments with the ability for the customer to decide the supplier
>> rather than leaving the system to do it automatically.
>>
>> But BJ please try and avoid spreading incorrect information, especially
>> when it has the effect of turning people away from the mailing lists.
>>
>> Regards
>> Scott
>>
>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>
>>> 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]<
>>>>>> [hidden email] <http://user/SendEmail.jtp?type=node&node=2743575&i=0>
>> <[hidden email] <http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>
>>
>>
>> *smime.p7s* (3K) Download Attachment<http://attachment/2743575/0/smime.p7s>
>>
>>
>> ------------------------------
>> View message @
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.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-tp2719579p2748882.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by BJ Freeman <bj...@free-man.net>.
StoreOrder triggers a bunch of ECA that you can find in the
application/order/servicedef folder.
one of those is checkCreateDropShipPurchaseOrders
which is in the orderservices.java.
not having the exact error msg I can't help you much further.
biletnikov sent the following on 9/30/2010 12:36 PM:
>
> Thank you for you response.
>
> I already have the experience of using OrderItemShipGroup.supplierPartyId to
> point the necessary supplier for new order creating, so I use "storeOrder"
> service for that, unfortunately when I create SALES_ORDER and if the
> supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to this
> supplier automatically and it faces the validation errors : contact data are
> not specified, because they are retrieved from the ShoppingCart, but I do
> not use the shopping cart yet. We just develop own service which should be
> the mature back-end system and reuse all value things of OFBiz for our
> front-end shop.
>
> On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz]<
> ml-node+2743575-944428815-170824@n4.nabble.com<ml...@n4.nabble.com>
>> wrote:
>
>> I would suggest looking at the drop ship functionality that is available in
>> OFBiz and customizing it for this situation. The shopping cart has the
>> ability to set a supplierPartyId per ship group and that can probably be
>> leveraged in this situation. What biletnikov is describing is really just
>> drop shipments with the ability for the customer to decide the supplier
>> rather than leaving the system to do it automatically.
>>
>> But BJ please try and avoid spreading incorrect information, especially
>> when it has the effect of turning people away from the mailing lists.
>>
>> Regards
>> Scott
>>
>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>
>>> 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]<
>>>>>> [hidden email]<http://user/SendEmail.jtp?type=node&node=2743575&i=0>
>> <[hidden email]<http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
>>>>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>
>>
>>
>> *smime.p7s* (3K) Download Attachment<http://attachment/2743575/0/smime.p7s>
>>
>>
>> ------------------------------
>> View message @
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.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>.
>>
>>
>>
>
>
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by biletnikov <bi...@gmail.com>.
Thank you for you response.
I already have the experience of using OrderItemShipGroup.supplierPartyId to
point the necessary supplier for new order creating, so I use "storeOrder"
service for that, unfortunately when I create SALES_ORDER and if the
supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to this
supplier automatically and it faces the validation errors : contact data are
not specified, because they are retrieved from the ShoppingCart, but I do
not use the shopping cart yet. We just develop own service which should be
the mature back-end system and reuse all value things of OFBiz for our
front-end shop.
On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz] <
ml-node+2743575-944428815-170824@n4.nabble.com<ml...@n4.nabble.com>
> wrote:
> I would suggest looking at the drop ship functionality that is available in
> OFBiz and customizing it for this situation. The shopping cart has the
> ability to set a supplierPartyId per ship group and that can probably be
> leveraged in this situation. What biletnikov is describing is really just
> drop shipments with the ability for the customer to decide the supplier
> rather than leaving the system to do it automatically.
>
> But BJ please try and avoid spreading incorrect information, especially
> when it has the effect of turning people away from the mailing lists.
>
> Regards
> Scott
>
> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>
> > 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]<
> >>>> [hidden email] <http://user/SendEmail.jtp?type=node&node=2743575&i=0>
> <[hidden email] <http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
> >>>>> 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<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
> >>>>> 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<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>
>
>
> *smime.p7s* (3K) Download Attachment<http://attachment/2743575/0/smime.p7s>
>
>
> ------------------------------
> View message @
> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.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-tp2719579p2748882.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Many suppliers for product, the customer selects the necessary supplier
Posted by Scott Gray <sc...@hotwaxmedia.com>.
I would suggest looking at the drop ship functionality that is available in OFBiz and customizing it for this situation. The shopping cart has the ability to set a supplierPartyId per ship group and that can probably be leveraged in this situation. What biletnikov is describing is really just drop shipments with the ability for the customer to decide the supplier rather than leaving the system to do it automatically.
But BJ please try and avoid spreading incorrect information, especially when it has the effect of turning people away from the mailing lists.
Regards
Scott
On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
> 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]<
>>>> ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
>>>>> 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>.
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by BJ Freeman <bj...@free-man.net>.
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]<
>>> ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
>>>> 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>.
>>>>
>>>>
>>>>
>>>
>>>
>
Re: Many suppliers for product, the customer selects the necessary supplier
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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]<
>> ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
>>> 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>.
>>>
>>>
>>>
>>
>>
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by BJ Freeman <bj...@free-man.net>.
anything beyond Out Of The Box is beyond this mailing list.
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]<
> ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
>> 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>.
>>
>>
>>
>
>
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by biletnikov <bi...@gmail.com>.
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] <
ml-node+2719855-1517121338-170824@n4.nabble.com<ml...@n4.nabble.com>
> 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.
Re: Many suppliers for product, the customer selects the necessary
supplier
Posted by BJ Freeman <bj...@free-man.net>.
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.
>
>
>
>
>
>