freezing shopping list pricing

[Dave Tenerowicz]

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
[hidden email]

Office: 303.493.6727
Mobile [phone]
Fax [phone]

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