Many suppliers for product, the customer selects the necessary supplier
Locked
Many suppliers for product, the customer selects the necessary supplier
 
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
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]<ml-node%[hidden email]> >>> 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>. >>> >>> >>> >> >> |
smime.p7s (3K)
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
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]<ml-node%[hidden email]> >>>>> 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
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
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]< >>>>>> [hidden email]<ml-node%[hidden email]> >>>>>>> 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
|
|
In reply to this post by Scott Gray-2
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]> 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. -- Best regards, Sergei Biletnikov
Kind regards,
Sergei |
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
In reply to this post by biletnikov
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]<ml-node%[hidden email]> >> 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
|
|
In reply to this post by BJ Freeman
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]< >>>>>>>> [hidden email]<ml-node%[hidden email]> >>>>>>>>> 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
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
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]< >>> [hidden email]<ml-node%[hidden email]> >>>> 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
|
|
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
In reply to this post by Scott Gray-2
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] <[hidden email]> 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. -- Best regards, Sergei Biletnikov
Kind regards,
Sergei |
Re: Many suppliers for product, the customer selects the necessary supplier
|
|
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] < > [hidden email]<ml-node%[hidden email]> >> 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. |
| Free forum by Nabble | Edit this page |