How to delete orders in the database (not in production)

[Bfn]

Hello,

Yes I know you’re not supposed to delete orders, but in my case I don’t think there’s another solution:

- I have a production website on PS 1.6 with new orders every day
- I have a staging website on PS 1.7 that I built to replace the 1.6 one. At some point I imported all orders from the production website, and since then I did a bunch of test orders

Now that my 1.7 website is ready, I would like to 1- delete the test orders I made (and test addresses, etc) and 2- import all production data in the staging website.

I can’t just cancel the test orders because there will be conflicts on order ids: say I imported everything up to id #123, then on my staging website ids #124 to #130 will be test orders while on my production website they will be real orders.

 

Is it sufficient to delete the test orders from `ps_order` and then all the related rows with these `id_order`?

Thanks in advance

[Knowband Plugins]

//Is it sufficient to delete the test orders from `ps_order` and then all the related rows with these `id_order`?

=>Yes you can delete the rows from the order and order_detail table, there will be no issue. Also take the backup of the tables before deleting the rows for future purposes.