Best method for removing orders from the system

[dmlwebal]

Hi

I have a two clients that sell exactly the same products. So as part of the project I can copy one full Joomla Phoca Cart installation across to new hosting, but, I need to remove the Phoca Cart Orders from the destination domain.

Is it safe to run this as a query on the database? or will this create problems?

What is the best method?

David

[Jan]

Hi, you need to run it in database and truncate the table because it includes autoincrement column - id. And if you want to start to count orders from 1, the autoincrement needs to be reset.

And, yes, this is very problematic, because another tables are linked, it is at least the following:



which even needs to be emptied and reset.

Jan

[Shuffle]

Thanks. This info is very helpful for testing.
Perhaps one should not truncate phocacart_order_statuses, if one has definded own content before.

[Jan]

Hi, yes, if you have own order statuses done, it is OK to not remove them.

Jan