New Shopify Certification now available: Liquid Storefronts for Theme Developers

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

Alex3251
Excursionist
23 0 6

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! 

Replies 2 (2)
JonasRuseckas
Visitor
1 0 1

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
Visitor
1 0 0

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!