Delete Unused variation

  • Resolved Vijay

    (@vijayabalaji5)


    5 years, 5 months ago

    Hi,

    I have around 200 products, each with around 50+ variations (color, size)

    I want to remove particular color on some products. So I have went to attributes section (on edit product page) and removed the unwanted color. And it removed the color on product page.

    But still on edit product page, under variation section, I can still see the variation as “Any Color” – https://tinyurl.com/y4ao7efu

    Is there a way to bulk delete unused color?

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Kel C. a11n

    (@kellymetal)

    5 years, 5 months ago

    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:

    Variation enabled
    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!

    Plugin Support abwaita a11n

    (@abwaita)

    5 years, 4 months ago

    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.

    SLV

    (@dwnl)

    5 years ago

    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?

    StevenWoolston

    (@stevenwoolston)

    4 years, 10 months ago

    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.

    Mirko P.

    (@rainfallnixfig)

    4 years, 10 months ago

    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!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Delete Unused variation’ is closed to new replies.