Delete All WooCommerce Default Product Variations
WooCommerce has a really nice feature that allows you to define default product variations for your variable products. I have to admit that it’s pretty awesome! But if you’d like to remove all default product variations at once, well that’s a bit complicate, especially when you have many products. There’s no easy way to do it from the administration, and doing it manually would take you a long time.
The only way to proceed is to perform a manual query, you can do it from PhMyAdmin for example. Please make a backup before playing with custom queries, you could mess up your whole site, and I don’t want to be responsible of that ;-) !
Here is the MySQL query to delete ALL default product variations:
DELETE FROM wp_postmeta WHERE meta_key =’_default_attributes’
Pretty simple right? But really useful!
Any suggestions on how getting variations deleted in bulk? Found a suggestion, but that didn’t work.