How to Bulk edit Price

New Member
2 0 0

Hi Guys,

I am having trouble to bulk edit price for my products. Due to the exchange rate, I need to add additional 5% to the current pricing. Can anyone let me know how to do that? 

 

Thanks! 

Winn Autosports

0 Likes
Community Manager
Community Manager
211 0 18

Hi, Jiajun!

I’m Melissa, a Shopify Guru. Thanks for posting. Some forum members may chime in with some of the workarounds they may have for bulk price changes and ways in which they use to do this. Here are a few options in how this may be achieved that I can see that may help.

1. You can manually change the price for each item in the admin Bulk Editor: You can see here and here. You can make some general changes here is you already know the new price, it will not add a calculation of a percentage though so that would be a limitation with this option. In this guide you will find a little more detail in how that can be edited. 

2. Another option would be to use a Product CSV in order to make the price bulk edit. It may be possible to do a calculation formula so you can increase all products in the CSV to the percentage needed. 

3. The final option would be the use of a bulk editing app, that will allow you to add the percentage and increase the price in a few clicks. Bulk Product Edit by Hextom or Bulk Editing by Booster Apps would be two apps to check out for the functionality your require. 

Hope this information helps! You can reach out to the Guru team https://docs.shopify.com/support  if you have any questions.

Have a great day!

Melissa | Shopify Guru
  

0 Likes
Tourist
30 0 3

Hi Jiajun,

Just wanted to mention that our app, Bulk Editor by 2can Apps for Shopify can also help you out. You can quickly search for the products you want to edit (or choose all products) and then adjust prices by a percentage.

It also has the ability to edit other fields as well as the capability to update a single field via a CSV edit.

Thanks!

Daniel

Tired of spending hours manually editing products? Check out https://apps.shopify.com/bulk-product-editor
0 Likes
Shopify Partner
285 0 25

Hello, Juajun!

Here is the tutorial, how to bulk update Price and basically any specific field by using Excelify.io app: https://excelify.io/2017/09/06/shopify-product-price-bulk-update/

You can install the app from here: https://apps.shopify.com/excel-export-import

Maris

 

Excelify.io | Bulk Import Export Update Migrate | https://excelify.io
0 Likes
Highlighted
Shopify Partner
285 0 25

Hi, Jiajun!

I am not sure if you are open to another app suggestion, but there is the Excelify app which, among other things, you can also use to bulk change your prices.

Here's the tutorial on how to do that:

https://excelify.io/2017/09/06/shopify-product-price-bulk-update/

You can also set the "Variant Cost" column with the same import to set the cost per item, too.

Excelify.io | Bulk Import Export Update Migrate | https://excelify.io
0 Likes
Tourist
30 0 3

Hi Jiajun,

You could also check out our Bulk Product Editor app (https://apps.shopify.com/bulk-product-editor)

You can use the app to filter for the products you want to change (or choose all of them) and then edit them like this:

Increasing prices in Shopify

You can also round the numbers if you want so they all end in something like '.95'

The app includes a number of free edits per month too so if you just need to make these changes occasionally it won't cost you anything

Best,

Daniel

Tired of spending hours manually editing products? Check out https://apps.shopify.com/bulk-product-editor
0 Likes
New Member
5 0 0

Even if I am a little bit late... I want to suggest my app, "Ahia! - Easy Price Changer". It perfectly fits to the "+5%" necessity of the post because you can specify rules without dealing with a product at a time.

 

ahia-logo.png

 

 

You can find it here: https://apps.shopify.com/ahia-easy-price-changer

 

With Ahia! - Easy Price Changer you can:

  • change prices for ALL the store products without doing it by hand, or change prices for specific collections or products;
  • decide a date to restore the old prices automatically, so you don't have to do it manually;
  • enable the old and new prices comparison, so your customers know that a promotion is going on (when I used it for my store, the conversion rate was better);
  • decide what kind of price change you want to set up (fixed amount or a percentage change);

I am constantly working on releasing new features. Feel free to drop a line to francesco@ahia.store if you need anything!

0 Likes