Handige WooCommerce queries

01-10-2021

Soms wil je wel eens snel alle WooCommerce orders of producten verwijderen. Je kunt onderstaande database queries gebruiken om het proces te versnellen.

Alle orders verwijderen

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 tmp4b0cb3_posts WHERE post_type = 'shop_order' );
DELETE FROM tmp4b0cb3_posts WHERE post_type = 'shop_order';

Alle producten verwijderen

DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM tmp4b0cb3_posts WHERE post_type IN ( 'product', 'product_variation' ));
DELETE FROM tmp4b0cb3_posts WHERE post_type IN ( 'product', 'product_variation' );

Alle prullenbak producten verwijderen

DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM tmp4b0cb3_posts WHERE post_type = 'product' AND post_status = 'trash' );
DELETE FROM tmp4b0cb3_posts WHERE post_type = 'product' AND post_status = 'trash';

Alle coupons verwijderen

DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM tmp4b0cb3_posts WHERE post_type = 'shop_coupon' );
DELETE FROM tmp4b0cb3_posts WHERE post_type = 'shop_coupon';

Alle order notities verwijderen

DELETE FROM wp_commentmeta WHERE comment_id IN ( SELECT ID FROM wp_comments WHERE comment_type = 'order_note' );
DELETE FROM wp_comments WHERE comment_type = 'order_note';