Skip to content

Instantly share code, notes, and snippets.

@dvdmierden

dvdmierden/woocommerce-clear-products.sql

Created April 18, 2020 10:08
Show Gist options
  • Save dvdmierden/352699ac6de217de37d4e1adeb912feb to your computer and use it in GitHub Desktop.
Save dvdmierden/352699ac6de217de37d4e1adeb912feb to your computer and use it in GitHub Desktop.
Download ZIP
Delete all products from woocommerce
Raw
woocommerce-clear-products.sql
DELETE FROM wp_term_relationships WHERE object_id IN
(SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN
('product','product_variation'));
DELETE FROM wp_posts WHERE post_type IN ('product','product_variation');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment