Bulk edit/update your Shopify product prices

Mixtable’s spreadsheet interface makes it trivial to change the prices of products in your Shopify store. You can do this by setting prices to a specific value or by using Excel-style formulas. You can also change prices individually or in bulk. Here’s how.

So, depending on which setup you have, follow the steps below.

Map product prices to a column

In a spreadsheet, open a Products (with variants) worksheet, which shows one row for each of your Shopify product variants.

1. To load more Shopify data, click ＋ Shopify data in the header row of an empty column, such as the one right after your last column. You can also choose Column > Add Shopify data… from the menu bar. The field picker opens and asks What should column E show?, with your column's letter in place of E. It lists everything the worksheet can show from Shopify, grouped into sections the way your Shopify admin groups them. Type in the search box at the top, or click a section on the left, to find the field you want.
2. Type Price in the search box, or click Pricing in the list of sections on the left. Click Price, then click Save Column

3. You’ll now see the column populate with the prices for your variants

4. Now, find the variant whose price you’d like to change, and update it to either a value (e.g., 10.99) or by using an Excel-style formula

Optional: Use the Full Product Info template

You can create a spreadsheet from the Full Product Info template, which creates a Products (with variants) worksheet that already includes the Price column:

Update prices using the Bulk number changes tool

There are cases where you need to make the same change, in bulk, to the prices of several products. For example, you need to decrease the price by 10% for Black Friday/Cyber Monday. Or you need to add $1.50 to the price of every product due to a corresponding increase in wholesale prices. This is where the Bulk number changes tool comes in very handy.

The Bulk number changes tool performs mathematical changes, and so it will only update cells that have a number in them. You specify the type of calculation to perform, and the updater will do it for you. If a column has a mix of numbers and text values, only the cells with number values will be updated.

To open the Bulk number changes tool, choose Bulk Edit > Bulk number changes in the menu bar. Or right-click your price column’s letter and choose Bulk number changes…, which opens the tool with that column already chosen. In the Bulk Edit Numbers window that opens, you’ll see a few inputs:

• Select column - this is how you choose which column in the current worksheet the change will work on. Choose the price column you added above. The change applies to every visible row in that column, so filter the worksheet first if you only want to change some prices

• Select operation - this is where you select what type of mathematical operation will be performed on your Shopify prices. The options are:

  • Add - Adds the value you’ve given to every number, e.g., add $1.50 to every price
  • Subtract - Subtracts the value you’ve given from every number
  • Increase by % - Takes each number and increases it by the specified percent, e.g., increase every price by 5%
  • Decrease by % - Takes each number and decreases it by the specified percent
  • Multiply - Multiplies each number by the specified value
  • Divide - Divides each number by the specified value

• Value - The actual value you want to use in the mathematical update

• Preview first 10 rows - if enabled, this will preview the numerical operation on the first 10 visible rows in the active worksheet. This way, you can preview what the output will be before you make it real

• Round results - rounds every result to a whole number, which removes the cents from your prices: 19.99 increased by 10% becomes 22 instead of 21.989. Leave it off for prices with cents. To round prices to the nearest cent, use a formula with ROUND instead, as shown in Increase Shopify prices in bulk

When the preview looks right, click Update Spreadsheet. The changed cells turn light yellow, which means they’re ready to sync but haven’t reached Shopify yet.

Sync the new prices to Shopify

When you are ready, look at the sync control at the top right of the spreadsheet, next to Share. It shows how many edits are waiting, for example Sync 12 changes. Click Preview to review them, then click the Sync button. Mixtable sends the updated price data to Shopify. It may take a few seconds for the changes to appear in your store.