Help with removing materials in Excel - Impulse Theme

[Lonni]

Hi!

I've got a LOT of art prints (around 180) I'm selling (my own artwork) but when the person set up the site he included two types of materials that I don't work with (Metal, Wood). These are offered as options when someone clicks on any type of art. I only need Acrylic and Canvas to show as options.

Is there any way to either easily and completely HIDE the two options I don't have or to remove them? I exported the file so I could work on it through Excel but, unfortunately, I'm disabled due to a brain injury and simply can't figure out how to do it. 

So... if you know of a way to do this, please let me know in simple instructions. 

Thanks for all your help!

I'm including a screenshot of what I see on Excel.

I'm using the Impulse Theme and my website is: TheOnceDeadArtist.com

Lonni

[PaulNewton · Accepted solution]

💣ALWAYS backup product export data to have a backup copy before making any edits 💣

How To: Deleting product variants using a CSV file: https://community.shopify.com/c/shopify-discussions/how-to-deleting-product-variants-using-a-csv-fil... 

Hi @Lonni roughly first make a backup of the product CSV data.

1. In excel select the M column (Option 2 Value)
2. create a filter to show ONLY the unwanted materials: Metal and Wood
3. Then delete all those visible rows that should only be either metal or wood based on the excel-column-filter

The re-import CSV file: Shopify admin > products >  Import. In the dialogs select "Overwrite any current products that have the same handle. Existing values will be used for any missing columns".

https://community.shopify.com/c/shopify-discussions/how-to-deleting-product-variants-using-a-csv-fil... 

[Lonni]

Thank you!!!! That worked!! Thank you, thank you!