Getting Started

User Guide

Change your Shopify products' prices in bulk

Mixtable's spreadsheet interface makes it trivial to modify 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.

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 Edit Column 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 Edit Column 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.
© 2020 Intelaria Corporation