News:

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

Main Menu

NEED CONFIG BUTTON - CLEAN AND RESET ALL ORDERS

Started by 2dmaster, May 29, 2021, 21:41:06 PM

Previous topic - Next topic

2dmaster

NEED CONFIG BUTTON - CLEAN AND RESET ALL ORDERS
history, all...

pinochico

And delete all orders in custom installation shipping and payment about virtuemart don't know if exist?

Nice idea, but impossible

You have to delete manually in DB and don't forget about order number
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

AH

There is no reset order data because order data also may be stored in additional thirdparty plugin related tables for shipment and payment

Therefore you can do a simple SQL call to clear out the base VM order tables

TRUNCATE YOURPREFIX_virtuemart_invoices;
TRUNCATE YOURPREFIX_virtuemart_orders;
TRUNCATE YOURPREFIX_virtuemart_order_calc_rules;
TRUNCATE YOURPREFIX_virtuemart_order_histories;
TRUNCATE YOURPREFIX_virtuemart_order_items;
TRUNCATE YOURPREFIX_virtuemart_order_item_histories;
TRUNCATE YOURPREFIX_virtuemart_order_userinfos;
TRUNCATE YOURPREFIX_virtuemart_order_item_histories;
TRUNCATE YOURPREFIX_virtuemart_carts;


Then you need to consider all the plugins that may contain order data - here is some I have to clear for testing:

TRUNCATE YOURPREFIX_virtuemart_payment_plg_paypal;
TRUNCATE YOURPREFIX_virtuemart_payment_plg_standard;
TRUNCATE YOURPREFIX_virtuemart_shipment_plg_uk_ship;
TRUNCATE YOURPREFIX_virtuemart_shipment_plg_weight_countries;
TRUNCATE YOURPREFIX_virtuemart_plg_cartsaver;


Then go and delete all the pdf invoices fromwherever they are stored
Regards
A

Joomla 3.10.11
php 8.0