Hello,
is there any way to delete in batch all the orders?
Thanks,
Davide
Using admin side, you can select all and delete.
A little trick : when you display the order adding at end of the url &limit=1000 display 1000 orders.
But 1000 is perhpas to many, &limit=250 is more save
Yes, I know, thanks.
But if I put 250, the system doesn't delete them.
I have about 15.000 orders!
You can use phpmyadmin to truncate the date in the relevant tables:
Ensure you test on a test environment first and take a backup just in case.
If you dont know MYSQL or are not confident DONT DO THIS!!!!
TRUNCATE yourprefix_virtuemart_orders;
TRUNCATE yourprefix_virtuemart_order_calc_rules;
TRUNCATE yourprefix_virtuemart_order_histories;
TRUNCATE yourprefix_virtuemart_order_items;
TRUNCATE yourprefix_virtuemart_order_userinfos;
TRUNCATE yourprefix_virtuemart_invoices;
These tables below may or may not exist so look to see what you have and substitute the relevant names ( depend on what payment and shipping plugins you have)
TRUNCATE yourprefix_virtuemart_payment_plg_paypal;
TRUNCATE yourprefix_virtuemart_payment_plg_standard;
TRUNCATE yourprefix_virtuemart_shipment_plg_weight_countries;
TRUNCATE yourprefix_virtuemart_order_item_histories;
In addition - you will potentially have invoices in the VMfiles directory - these should be "moved"
Hi,
thank you very much!
Thanks! exactly what I was looking for! Thanks!