How do I copy/paste a table from Excel into Bulk Editor to change the price?

[Alex3251]

When you go into your products, and select multiple products an option pops up at the bottom called, "Bulk Editor". You click it, and now you can edit all the prices in bulk. The problem is if I select all of them, I can press Delete and all the prices will reset to $0.0, however, if I select the entire price column and paste the column from Excel with the new prices, it doesn't do it. 

Just wondering if there is a way of doing it, and if I'm doing it wrong? 

Changing the prices of 100+ items one-by-one might be a bit tedious work. 

Thank you so much everyone! 

[JonasRuseckas]

I'm facing the same problem, but so far I can't find a solution. Anyone knows how to deal with it? Cause that would save bunch of time. Thanks

[Joth]

Same here, I've tried every possible way I can think of and keep hitting the same wall. It would be so helpful if you could just paste from Excel or sheets!

There are Shopify apps that can bulk edit pricing and they have a bunch of handy features but its another monthly cost for something that I only need very occasionally!

[Struder]

Well you can apply the Excel formula or copy-paste from Excel in a bulk editor but you can for sure export the product list from Shopify as csv and then open that csv in Excel to apply the formula and then again import that CSV file to the Shopify