Skip to content

Instantly share code, notes, and snippets.

@ccurtin

ccurtin/get-duplicate-woocommerce-skus.sql

Created December 23, 2019 17:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ccurtin/4e25cefe31894da7097ec96bb97fc296 to your computer and use it in GitHub Desktop.
Save ccurtin/4e25cefe31894da7097ec96bb97fc296 to your computer and use it in GitHub Desktop.
Download ZIP
Get Dupliate WooCommerce Skus
Raw
get-duplicate-woocommerce-skus.sql
SELECT meta_value
FROM wp_postmeta
WHERE meta_key = '_sku'
AND meta_value != ''
GROUP BY meta_value HAVING COUNT(meta_value) > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment