yobarefoot Posted April 14, 2004 Posted April 14, 2004 After doing many mods on osCommerce, my mind became numb. Sometimes I dream with silly php code problems. And yet, I'm so hooked to it! :P A question came up to me...what if order records start piling up in a year...what is best way to safely remove "old" order records out of SQL database? Then whenever I need revisit an old order record, I could view it/print it? Let's say I have 5 years worth of old order records safely pulled out of SQL database, what is quick way to search a record by customer's name or by order number? I know you can export SQL table into SQL format or XLS format... With SQL format...would be ideal for backup...but I wouldn't want to put 5 years of old records back into SQL, mixing with new records just to be able to view an old record... With XLS format...I don't think I would be able to see clean view of order record like you would see on Admin side after clicking 'edit' or 'invoice' button... Any ideas welcome! Thanks!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.