Re: how to handle changing prices

Hi!

Fernando wrote:
>
> Hi!
> What's the best design to handle changing prices for products?
> O:-) Different customers will have different discounts, prices may
> change for special offers, etc...
> Changing a price shouldn't affect previous orders of that same
> product, besides, I need to audit those changes.
> Any ideas? O:-)

If a change must not affect previous orders, you'll have to record "historical" data with the order. Simply add a column for the price to the relevant tables of the order.

To audit changes of prices, you might want to use update triggers that record the old and the new price together with date of change and perhaps the user in a separate audit table.

Heinz Received on Mon Feb 28 2000 - 00:00:00 CET