My name is Lilith, I'm on the Social Care team at Shopify.
Are you trying to get edit one color for all the products in your store or are you just wanting a faster way to edit your variants other than the bulk editor in your admin?
If you're looking to make edits to all of your products and variants quickly you can definitely export them all into a CSV/spreadsheet in order to make multiple changes much faster. When you've finished your edits, just be sure to overwrite the old products with the new edits when you upload the CSV.
Let me know how you do with the information above! I'm happy to answer any questions you think of as you work on your business.
Thanks for your reply, I'm wanting to change all this sizes for my products. My US sizing is slightly off to the Euro sizing as displayed in that picture. For example a Euro 45 isn't equal to a US 11.5 like I have in my product. It is actually 11. Slight mistakes throughout all the products and want a quick way to edit it rather than individually... if that all makes sense? Would your solution work for that?
@lockycaple I believe it will work well for your case. I've personally used CSVs as a way to edit thousands of variants quickly using Excel and Google Sheets. If you're a beginner with spreadsheets, you'll still find this method to be fairly straightforward.
The other thing you can try is some apps to help you. All of them will be 3rd party apps which means that Shopify didn't create them and are supported by the 3rd party that developed them. However, it doesn't hurt to try some apps if you find that the CSV method is a bit inconvenient in any way.
@lockycaple fantastic! Take your time and use the guides to the best of your abilities. Once you learn this, I guarantee you'll love it and want to use that method more often. Keep me posted and if you need any help with anything along the way!
Hi, @lockycaple! The error message seems to indicate that perhaps the file you saved isn't in CSV format. It's definitely great to use Excel to edit, but when you save the file you'll want to export it as CSV. The file will have a little extension at the end that looks like .csv instead of .xls or .xslx.
I found this guide online on how to export your file in UTF-8 CSV format. That should be able to quickly solve the error you're seeing when importing.