You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Delete all the orders

Started by m.davide82, May 03, 2018, 22:30:04 PM

Previous topic - Next topic



is there any way to delete in batch all the orders?


Studio 42

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"

Joomla 3.10.11
php 8.0



Thanks! exactly what I was looking for! Thanks!
MGS Creativa - VirtueMart Payment Plugin Experts

Take a look at our downloads section for VirtueMart payment plugins and mouch more!