Community,
I have an issue with the Shopping List 'createListReorders' service I was hoping the community could provide some feedback on. When a product is added to the Shopping List (type=SLT_AUTO_REODR) the product and the quantity is correctly added as a shopping list item. However the unit price of the product is NOT added. The 'createListReorders' service then creates the order (according to Shopping list recurrence rules) based on the shopping list items of the shopping list and re-calculates the price of the product at the time the order is created, essentially using the 'current' product price. My issue is I would like the shopping list item to 'save' the unit price of the product at the time the 'customer' adds the shopping list item to the 'Shopping List'. This way if the price is changed in the current product configuration, the 'original' unit price of when the shopping list item was added remains the same for that customers shopping list. The best way I see to accomplish this requirement would be to extend entity 'SHOPPING_LIST_ITEM'; adding UNTI_PRICE. The 'createListReorders' service would then use this price when adding the shopping list item to the order. Has anyone had any experience with this? Is there an alternative solution? Len Shein [hidden email] O: 516.742.7888 x225 O: 732.333.4303 C: 917.882.8515 |
You may as well try using ShoppingListItem.modifiedPrice, you will have to
write one line custom code to set the previous price. On Wed, Jul 10, 2013 at 4:31 PM, Len Shein <[hidden email]> wrote: > Community, > > I have an issue with the Shopping List 'createListReorders' service I was > hoping the community could provide some feedback on. > > When a product is added to the Shopping List (type=SLT_AUTO_REODR) the > product and the quantity is correctly added as a shopping list item. > However the unit price of the product is NOT added. The > 'createListReorders' service then creates the order (according to Shopping > list recurrence rules) based on the shopping list items of the shopping > list > and re-calculates the price of the product at the time the order is > created, > essentially using the 'current' product price. > > > > My issue is I would like the shopping list item to 'save' the unit price of > the product at the time the 'customer' adds the shopping list item to the > 'Shopping List'. This way if the price is changed in the current product > configuration, the 'original' unit price of when the shopping list item was > added remains the same for that customers shopping list. > > > > The best way I see to accomplish this requirement would be to extend entity > 'SHOPPING_LIST_ITEM'; adding UNTI_PRICE. The 'createListReorders' service > would then use this price when adding the shopping list item to the order. > > > > Has anyone had any experience with this? > > Is there an alternative solution? > > > > > > > Len Shein > > [hidden email] > > O: 516.742.7888 x225 > > O: 732.333.4303 > C: 917.882.8515 > > > > -- Regards, Varun Bhansaly |
Hi Len, Agreed with Varun,
A little more detail FYI - 1. When product is added to shopping list : pass following variable in parameters - modifiedPrice(value equals to current price of product.) 2. While creating an order with shopping list items(service - createListReorders), pass shoppingCartItem.modifiedPrice to method "listCart.addOrIncreaseItem", it will created order with given price : Required to modify the code. 3. In this way there will not be requirement to modify the entity. -- Thanks And Regards Sumit Pandit Tata Consultancy Services Cell:- +917503046188 ____________________________________________ ----- Original Message ----- | From: "Varun Bhansaly" <[hidden email]> | To: [hidden email] | Sent: Thursday, July 11, 2013 11:14:31 AM | Subject: Re: Shopping List - Create List reorders | | You may as well try using ShoppingListItem.modifiedPrice, you will | have to | write one line custom code to set the previous price. | | On Wed, Jul 10, 2013 at 4:31 PM, Len Shein <[hidden email]> | wrote: | | > Community, | > | > I have an issue with the Shopping List 'createListReorders' service | > I was | > hoping the community could provide some feedback on. | > | > When a product is added to the Shopping List (type=SLT_AUTO_REODR) | > the | > product and the quantity is correctly added as a shopping list | > item. | > However the unit price of the product is NOT added. The | > 'createListReorders' service then creates the order (according to | > Shopping | > list recurrence rules) based on the shopping list items of the | > shopping | > list | > and re-calculates the price of the product at the time the order is | > created, | > essentially using the 'current' product price. | > | > | > | > My issue is I would like the shopping list item to 'save' the unit | > price of | > the product at the time the 'customer' adds the shopping list item | > to the | > 'Shopping List'. This way if the price is changed in the current | > product | > configuration, the 'original' unit price of when the shopping list | > item was | > added remains the same for that customers shopping list. | > | > | > | > The best way I see to accomplish this requirement would be to | > extend entity | > 'SHOPPING_LIST_ITEM'; adding UNTI_PRICE. The 'createListReorders' | > service | > would then use this price when adding the shopping list item to the | > order. | > | > | > | > Has anyone had any experience with this? | > | > Is there an alternative solution? | > | > | > | > | > | > | > Len Shein | > | > [hidden email] | > | > O: 516.742.7888 x225 | > | > O: 732.333.4303 | > C: 917.882.8515 | > | > | > | > | | | -- | Regards, | Varun Bhansaly | =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you |
Varun, Sumit,
Thanks for responding. I see the issue; I am using Ofbiz 10.04, after reviewing Ofbiz 12.04 entity model I see ShoppingListItem.modifiedPrice has been added. This field serves the same purpose as I was intending to use ShoppingListItem.unitPrice. Agreed SHOPPING_LIST_ITEM.MODIFIED_PRICE will do the trick. Thanks Len -----Original Message----- From: Sumit Pandit [mailto:[hidden email]] Sent: Thursday, July 11, 2013 1:49 AM To: [hidden email] Subject: Re: Shopping List - Create List reorders Hi Len, Agreed with Varun, A little more detail FYI - 1. When product is added to shopping list : pass following variable in parameters - modifiedPrice(value equals to current price of product.) 2. While creating an order with shopping list items(service - createListReorders), pass shoppingCartItem.modifiedPrice to method "listCart.addOrIncreaseItem", it will created order with given price : Required to modify the code. 3. In this way there will not be requirement to modify the entity. -- Thanks And Regards Sumit Pandit Tata Consultancy Services Cell:- +917503046188 ____________________________________________ ----- Original Message ----- | From: "Varun Bhansaly" <[hidden email]> | To: [hidden email] | Sent: Thursday, July 11, 2013 11:14:31 AM | Subject: Re: Shopping List - Create List reorders | | You may as well try using ShoppingListItem.modifiedPrice, you will | have to | write one line custom code to set the previous price. | | On Wed, Jul 10, 2013 at 4:31 PM, Len Shein <[hidden email]> | wrote: | | > Community, | > | > I have an issue with the Shopping List 'createListReorders' service | > I was | > hoping the community could provide some feedback on. | > | > When a product is added to the Shopping List (type=SLT_AUTO_REODR) | > the | > product and the quantity is correctly added as a shopping list | > item. | > However the unit price of the product is NOT added. The | > 'createListReorders' service then creates the order (according to | > Shopping | > list recurrence rules) based on the shopping list items of the | > shopping | > list | > and re-calculates the price of the product at the time the order is | > created, | > essentially using the 'current' product price. | > | > | > | > My issue is I would like the shopping list item to 'save' the unit | > price of | > the product at the time the 'customer' adds the shopping list item | > to the | > 'Shopping List'. This way if the price is changed in the current | > product | > configuration, the 'original' unit price of when the shopping list | > item was | > added remains the same for that customers shopping list. | > | > | > | > The best way I see to accomplish this requirement would be to | > extend entity | > 'SHOPPING_LIST_ITEM'; adding UNTI_PRICE. The 'createListReorders' | > service | > would then use this price when adding the shopping list item to the | > order. | > | > | > | > Has anyone had any experience with this? | > | > Is there an alternative solution? | > | > | > | > | > | > | > Len Shein | > | > [hidden email] | > | > O: 516.742.7888 x225 | > | > O: 732.333.4303 | > C: 917.882.8515 | > | > | > | > | | | -- | Regards, | Varun Bhansaly | =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you |
Free forum by Nabble | Edit this page |