Results 1 to 11 of 11
Sep 29, 2008, 08:55 #1
- Join Date
- Apr 2005
- 3 Post(s)
- 0 Thread(s)
Advice on storing historical order address info
I'm storing data about orders and associated addresses (billing/shipping). Say we associate the address with the order with address_id. The address would also be associated with the customer, so they can select from their list of addresses next time they order.
Say we allow a customer to add a new address to their account for a new order. We create a new address entry and associate it to the new order.
But if we allow the customer to make a small change/correction to their address for future orders. We don't want to just update the existing address entry because we want to know exactly where previous orders were shipped. But if we just create a new address entry, then the customer could have some near-identical addresses on their account - looks a bit messy.
Possibly for adding an address, we add the address entry, and associate it with the customer, and with any subsequent orders for which that address is selected. And for a update of address, add a new entry, and remove the association of the old address from the customer, but then it stays associated with previous orders.
Just wondering if anyone else had come across this situation and how they dealt with it.