We have an interesting challenge with creating Order instances from Shopping Lists( type= Auto Reorder). Our client, currently using a home grown system, has a large number of recurring Orders for which prices are frozen at the initial purchase. They need to continue charging existing customers the price that was in effect at the time of initial purchase - forever. At the same time, if a ShoppingList is created at a later time a different price should be charged for the same product. In addition, in most cases these products are shipped free of charge, but a flat rate shipping charge may be setup - at the order takers discretion so we need to associate a special shipping charge with some shoppingLists and ensure that this shipping charge is used in every Order instance created from that shoppingList.

Here's an example:
In June, Customer A signs up for an automatic monthly shipment for Product A at $30,with free shipping.
They are sent shipments in June, July and August for $30 each
In September, the price changes to $35
A new customer (B) signs up for recurring shipments of the same Product(A) beginning in Sept, and is told he will be charged a $5 shipping charge In September, an Order instance should be created for Customer A, charging him $30. At the same time, an Order instance should be created for Customer B, charging him $40 ($35 for the product, plus a $5 shipping charge)

Is there any way to accommodate this using OfBiz standard functionality? We are considering extending the shoppingList entity to allow users to set an "override price rules" flag, a special unit price and shipping charge value, and modifying the services that add shoppingList items to the cart. But we would prefer not to do this - if we can accommodate this requirement without those intrusive changes.

Any ideas, suggestions or comments would be welcome.

Thanks

--
Dave Tenerowicz
[EMAIL PROTECTED]

Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330

Visit us at http://www.salmonllc.com

Reply via email to