Delete Unused variation

Hi there,

There is no built-in way to delete all variations with a specific attribute term, but you could export all the products+variations to CSV and remove the variations with that color, then delete all products on the site and do a fresh import of just the products+variations that you want.

Alternatively, you could just disable those variations by exporting your product variations to CSV, and setting the Published column for each variation to 0 (not the variable product, but just the variation). That will cause those variations to be disabled:

Link to image: https://d.pr/i/tjwvIP

There’s documentation for the built-in product import/export functionality here:
https://docs.woocommerce.com/document/product-csv-importer-exporter/

Whichever method you decide to go with, I’d definitely recommend taking a complete backup of the site before getting started: https://docs.woocommerce.com/document/backup-wordpress-content/

I hope that helps!

Hi,

We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above info was helpful!

If you have further questions, please feel free to open a new topic.

Thanks.

Hello,

I have the same problem…
I too have many many products.
For example 1 sofa had 80 fabric variations.
I deleted 40 fabrics from the store.
But those 40 varations are still in that product under ‘any fabric’.

I exported that sofa as an .csv file. So how can i delete those 40 ‘any fabric’ variations via this csv, so i only have the 40 ones which do have a fabric asigned to them?

I tried to delete all information in the ‘head’ column (id:*****) voor those variations i want to delete, but when importing this csv again i get an error, so this doesn’t work.

Can anybody help me?

I found that you can do this via the built-in import facility.

Export all your variations to give you a csv of all variations (you could filter the export to reduce the size of the resulting csv).

Then find the variations you want to remove and paste into a separate spreadsheet and save as csv. Then delete the value in the parent column for all variations in your new csv.

Then import that new csv and make sure you select the checkbox option to update existing variations on the screen where you select the csv upload. Map your columns and import.

This removes the variation from the parent variable product.

Hi @stevenwoolston,

Thanks for replying to this thread that is closed since 2 months but all replies can be helpful for other users as well.

@dwnl if you still need help and the issue is not resolved, please feel free to open a new topic and WooCommerce support staff or other users in the forum we’ll help you out.

Thanks!