WordPress Snippets

delete-duplicate-products-woocommerce.sql

## Delete duplicate WooCommerce products

## (Retains the lowest ID)
## Pro tip: Change to SELECT to test
DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
where post_type = 'product'
group by post_title
having count(*) > 1
) as good_rows 
on good_rows.post_title = bad_rows.post_title
and good_rows.min_id <> bad_rows.id

## (Retains the highest ID)
## Pro tip: Change to SELECT to test
DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MAX(id) as min_id
from wp_posts
where post_type = 'product'
group by post_title
having count(*) > 1
) as good_rows 
on good_rows.post_title = bad_rows.post_title
and good_rows.min_id <> bad_rows.id