You may occasionally want to erase thousands of WooCommerce orders, goods, categories, tags, discounts, customers, or custom fields in a single click. We’re going to offer a simple solution with you because Woocommerce made this straightforward operation quite difficult.
Perhaps because your website crashes because it can’t handle so much data at once, or perhaps because you have a tight budget and can’t afford to manually click “delete” 100 or 1000 times.
Need help with your website? Learn more about our web development services
Thanks to the fact that WooCommerce data is kept in the WordPress database, we can quickly bulk delete everything we want by writing a “SQL DELETE statement” and accessing the database. Naturally, as stated in the warnings below, NEVER DO THIS on a live website because I cannot promise there won’t be any negative impacts.
Follow the simple steps below 🙂
Bulk Delete Orders in Woocommerce
- Access your hosting dashboard and access phpMyAdmin
- Select the associated database in the left sidebar and then select SQL within the main menu
- Copy and paste the code below and select Go
DELETE FROM wp_woocommerce_order_itemmeta;DELETE FROM wp_woocommerce_order_items;DELETE FROM wp_comments WHERE comment_type = 'order_note';DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' );DELETE FROM wp_posts WHERE post_type = 'shop_order'; |
That’s it, all Woocommerce orders will be deleted in bulk.
Please contact softdata if you require any help with your WordPress website that runs Woocommerce. We assist thousands of business owners in operating profitable online e-commerce stores in Gloucester, Cheltenham and the rest of the UK.
Digital Marketing Agency in Gloucester and Cheltenham
Softdata is a leading digital agency and AI Services provider based in Gloucester and Cheltenham.About us: Softdata is a premier digital software agency and digital marketing provider, based in Gloucester and Cheltenham. We offer a range of digital services including web design, bespoke software development, SEO, Paid advertising, conversion rate optimisation, web hosting, and AI consultancy services. Our team is dedicated to providing the best solutions tailored to the unique needs of our clients.
If you would like to discuss your needs with a Digital Specialist, we offer a Free Initial Consultation without cost or commitment. Meetings can be held at our offices, via video conference, or by telephone. Our telephone number is 01452 502 508.
Softdata is located at: Softdata Internet Limited, 80 Westgate Street, Gloucester, GL1 2NZ.