Remove all product data and product meta

clean-product.sql

-- This SQLs remove products and their meta data on your store
-- SalesGen.io

-- delete product info
DELETE FROM wp_posts WHERE post_type = 'product_variation';
DELETE FROM wp_posts WHERE post_type = 'product';


-- After remove products from posts table, must clear data in postmeta to reduce database size.

-- Delete orphan postmeta
DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts p ON pm.post_id = p.ID
WHERE p.ID IS NULL;