How to delete old orders from order history?

1. I would like to remove all orders older than 3 years from the order history. How do I do that?

2. How can I calculate the present price of a purchased product in some old order with the same attributes settings as it had when the order was purchased?

3. Is it possible to delete a product after it has been bought? If possible doesn't it make the products_id reference in table orders_products obsolete?

The first two you can do with a SQL program.

nomad

to anser 3.
every time you delete a row from a database that id is no longer in use since MySQL will always add to the last ID.

I'm not sure the posts above are actually answering your questions.

David Bo:

1. I would like to remove all orders older than 3 years from the order history. How do I do that?

2. How can I calculate the present price of a purchased product in some old order with the same attributes settings as it had when the order was purchased?

3. Is it possible to delete a product after it has been bought? If possible doesn't it make the products_id reference in table orders_products obsolete?

1. There is no built-in purge facility in Zen Cart at the present time. If you want to remove old records in large quantities, you'll need to do it manually by direct database access.
   The tables related to order history are listed here:
   http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema#Order_History

2. This is not an easy task, and may actually not be possible after-the-fact, given the current database structure. Your best option for this would be to recreate the order afresh, selecting the specified attributes detailed in the old order's line-item information.

3. Sure, deleting a product from the database can be done quite easily. Granted, as you mentioned, you will be orphaning it from orders, meaning that existing orders won't be able to allow any lookups on the details of the original product.

There are caveats to removing any data from a relational database. Do so at your own risk.