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.

In Shopify prices live with Variants, not Product, and if you make use of Variants in your store you’ll be changing 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 set up you have follow the steps below.

Mapping product prices to a column

Case 1 - Your store makes use of Variants

  1. In a workbook create a worksheet that integrates with your Shopify Product Variants.
  2. Right click on the column header of a column that is not yet mapped to sync to a field. Such columns have a grey background, whereas columns that are set up for data syncing have a light purple background. When you right click you’ll see a context menu show up. Select the Shopify Sync Settings option.
  3. In the window that opens, select the Core Field radio button option. You will see a dropdown show up, prompting you to select the field you’d like to sync. Find and select the Price field. Now, click on the Save button.
  4. You’ll now see the column populate with the prices for your variants.
  5. 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.

Case 2 - Your store does not use Variants

  1. In a workbook create a worksheet that integrates with your Shopify Products.
  2. Right click on the column header of a column that is not yet mapped to sync to a field. Such columns have a grey background, whereas columns that are set up for data syncing have a light purple background. When you right click you’ll see a context menu show up. Select the Shopify Sync Settings option.
  3. In the window that opens, select the Core Field radio button option. You will see a dropdown show up, prompting you to select the field you’d like to sync. Find and select the First Variant - Price field. Now, click on the Save button.
  4. You’ll now see the column populate with the prices for your products. Technically, it’s the price for the only variant your products have, but Mixtable handles it all for you.
  5. Now, find the product 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.

Updates using the Bulk Number updater feature

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 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 updater feature comes in very handy.

The Bulk Number updater performs mathematical changes, and so 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 updater by clicking on its 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. The options are:
    • Add - Adds the value you’ve given to every number
    • Subtract - Subtracts the value you’ve given from every number
    • Increase by % - Takes each number and increases it by the specified percent
    • 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