Storing old orders in web shop
Posted: Mon Aug 29, 2005 1:05 am
I'm currently working on a shop system in which customers creates orders which later is being processed by the shop owner (as usual in shops
).
When an order is processed, it is necessary to store in some way, so old orders can be looked up later.
My question is which way is the best way to store old orders. I could store it in the database with the original relations to the original items ordered, but this won't work as the item price, item description and so on will change over time.
As I see it, there is two opportunities: flat file system or a new database table.
When an order is processed, it is necessary to store in some way, so old orders can be looked up later.
My question is which way is the best way to store old orders. I could store it in the database with the original relations to the original items ordered, but this won't work as the item price, item description and so on will change over time.
As I see it, there is two opportunities: flat file system or a new database table.