Getting Started

User Guide

Manage Shopify inventory

Updating and tracking Shopify inventory is one of the most common uses of Mixtable. You can bulk update the inventory for a particular products/variants, track how much inventory you have in stock, share inventory information with others, or export your inventory to an Excel file.

Before we show how to store and update Shopify inventory with Mixtable, it's important to explain how Shopify stores inventory. In Shopify inventory quantities are related to variants, not products. This is always the case, even if you haven't added variants to a product as Shopify always auto-creates a variant for every product in its own database. This inventory-variant relationship is important to understand as we set up inventory tracking/updates in Mixtable.

How you set up inventory tracking in Mixtable depends on whether you want to update the inventory for the first variant of a product (i.e., you don't use variants so we are updating the default variant for a product), or whether you want to manage the inventory for multiple variants of a product.

Case 1 - Inventory is managed from a worksheet storing your variants

This is for stores that make use of variants in Shopify. Here are the steps to get your inventory into your worksheets.

  1. Add a Product Variants worksheet if you haven't already
  2. Find a column that is currently empty, and right-click on any cell in that column
  3. Click on the "Edit column settings" option
  4. In the "Column Settings" interface that opens, select the "Inventory" radio button
  5. You will now see a dropdown containing the various inventory locations that you have set up in Shopify. Select the location whose inventory you want to map into the column.
  6. Click on the "Save" button
  7. The "Column Settings" interface will close, and you will see the column populate with each variant's inventory at the selected location
  8. Repeat the steps above for any other locations whose inventory you'd like to map to a column

Case 2 - Inventory is managed from a worksheet storing your products

This is for stores that do not make use of variants in Shopify. In this case you can map inventory to a worksheet holding your products. Here are the steps to get your inventory into your worksheet.

  1. Add a Products worksheet if you haven't already
  2. Find a column that is currently empty, and right-click on any cell in that column
  3. Click on the "Edit column settings" option
  4. In the "Column Settings" interface that opens, select the "Inventory" radio button
  5. You will now see a dropdown containing the various inventory locations that you have set up in Shopify. Select the location whose inventory you want to map into the column.
  6. Click on the "Save" button
  7. The "Column Settings" interface will close, and you will see the column populate with each variant's inventory at the selected location
  8. Repeat the steps above for any other locations whose inventory you'd like to map to a column
© 2020 Intelaria Corporation