Get Excelify now
Get Excelify now

How to add specific amount to your Shopify Product price in bulk

Add specific amount to Shopify Product price featured 3|1.2 - Export Shopify products to Excel with filters|2 - Update specific Product fields in Shopify in bulk|3 - Shopify import ignore custom columns|4 - Add specififc amount to cell|4.1 - Add specific amount to the whole column|4.2 - Add percent to hte Shopify Product price|4.2 - Add percent to hte Shopify Product price in bulk|4.2 - Add percent to hte Shopify Product price|5 - Import Shopify Product update excel file|Add specific amount to Shopify Product price featured|

Looking for an easy way to add a few dollars or few percents to your Shopify Products? Let’s take a look at how to do it with the Excelify.

1. Export Products

In the Excelify apps Export section, select checkboxes Products with sub-checkbox Inventory / Variants.

You can also apply filters to limit the Products you are exporting, for example, to export only the Products that are in specific Collection.

Select format Excelify: Excel and press the Export button to start the export.1.2 - Export Shopify products to Excel with filters

2. Delete unnecessary columns

Since we do not wish to update any other fields than Variant Price, then we do not need to include all the columns in the file.
You will only need the following columns:

  • ID
  • Handle
  • Variant ID
  • Variant SKU or Variant Barcode
  • Variant Price2 - Update specific Product fields in Shopify in bulk

3. Rename Variant Price column and add a new one

The Excelify app will ignore all columns it does not recognize, so you can rename the current Variant Price column to anything that is not recognized by the app, so you can use it in formulas for new Variant Price.

It helps to always just add the word “Ignore” to the column name since no columns in our template contain this word.3 - Shopify import ignore custom columns

4. Construct the formula

For example, let’s take a look at how to add a specific amount and how to add specific percent.

Add a specific amount:

To add a specific amount, in my case 15, use formula the following in cell F2.

=E2+15

This formula will take the value from cell E2 and add 15 to it.4 - Add specififc amount to cell

Add percent to the amount:

To add a percent, in my case 10%, use formula the following formula in cell F2

=E2+E2*10%

Let’s break down this formula:

=E2+E2*10%

E2 = value in cell E2
E2*10% = 10 percent from the value in cell E2

This formula thus will take the value from the cell E2, then calculate 10 percent from E2 and add both together, returning the value in cell F2 where the formula is located.4.2 - Add percent to hte Shopify Product price

Apply the formula to the whole column

Select cell F2 and double click on the square in the bottom-right corner to apply this formula to the whole column.4.2 - Add percent to hte Shopify Product price in bulk

Other noteworthy formulas

=ROUND(number, num_digits)

Rounds a number to a specified number of digits.

=ROUNDUP (number, num_digits)

Returns a number rounded up to a given number of decimal places. Unlike standard rounding, where numbers less than 5 are rounded down, ROUNDUP always rounds numbers 1-9 up.

=CEILING (number, multiple)

Returns a given number rounded up to a specified multiple. For example, =CEILING(E2,5) could be used to round a price in E2 to the nearest 5 dollars. CEILING always rounds up.

5. Save, import and enjoy.

Now you can save the file. Go back to the Excelify app and import the file in the Import section. The app will analyze the file and count how many Products you are importing.

Press the Import button to start the import.

If you see any Failed items, then after the import has finished, you can download the Import Results file and look into the “Import Comment” column. It will tell why particular Products has failed. Then you can fix that issue and re-import just those failed and fixed rows again.5 - Import Shopify Product update excel file

What to do next?