Delete trash product by mysql

delete trash product.sql

-- Delete product variants
DELETE FROM wp_posts WHERE post_type = 'product_variation' AND post_parent IN (DELETE FROM wp_posts WHERE post_type = 'product' AND post_status = 'trash');

-- Delete main product
DELETE FROM wp_posts WHERE post_type = 'product' AND post_status = 'trash';

-- clean metapost
DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts p ON pm.post_id = p.ID
WHERE p.ID IS NULL;