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.

Note: In Shopify, prices live with Variants, not Products.

• If you use Variants in your store, you’ll change the prices from a worksheet that shows your Variants.
• If you don’t use Variants, Shopify will nevertheless create a single variant for your products. It needs this as variants store prices, SKUs, inventory, and more.

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

Map product prices to a column

In a spreadsheet, create a worksheet that integrates with your Shopify Product Variants.

1. To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the button in the column header to open the selection window to choose the data you want to pull in.
2. In the window that opens, select Shopify data fields. A dropdown menu will appear, prompting you to select the field you’d like to sync. Find and select the Price field. Now, click on the Save button.

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 will load Product Variant information, including price data:

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.

You activate the Bulk number changes tool by clicking on the Bulk tools button in the toolbar. In the dialog that opens, you’ll see a few inputs:

• Column Selector - this is how you choose which column in the currently active worksheet the Bulk Number updater will work on. In your worksheet, select the column mapped to the price you mapped out above.

• 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

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.