CODEWITHSUNDEEP
mysqlwordpresswoocommercephpmyadmin
GazzaC
GazzaC

Reputation: 13

Remove all skus from woocommerce database

We have asked this question before with out success, hope someone can help this time.

We have a site with over 1200 sku's that are wrong and we want to delete them all without affecting the products.

We are running the latest version of WP.

Is there a quicker way to do this via the db in phpmyadmin.

Any help would be great.

Thanks

Upvotes: 0

Views: 2337

Answers (1)

dipmala
dipmala

Reputation: 2011

Just run Update wp_postmeta set meta_value ='' WHERE meta_key = '_sku' in phpmyadmin and it will reset all _sku without affecting the products.

Upvotes: 1

Related Questions