Enable Shopify Inventory Tracking For Multiple Products

The Mixtable spreadsheet interface is a great tool for quickly enabling inventory tracking for multiple Shopify products at once and for tracking across multiple locations. There are two ways to accomplish this.

Note: Inventory in Shopify is stored against variants, not against the parent products. So for all the steps below, you need to be working in a Products (with variants) worksheet where each row represents a variant in Shopify. Keep in mind that by default, Shopify always creates a variant for a product.

Option 1 - Simply set inventory for a given variant

If inventory tracking is not currently enabled for one or more of your products, the simplest way to enable this tracking is to set an inventory value for a particular variant at a particular location. When you initiate the sync from Mixtable to Shopify, if inventory tracking is not enabled for the given variant at the given location, Mixtable will automatically turn inventory tracking on, and after that is done, it will set the inventory level to the value you’ve given us.

Option 2 - Set Inventory Management field

The second way to enable inventory tracking to be done by Shopify is to set the inventory management field to have a value of “shopify” for a given variant. If inventory management is set to “shopify”, that instructs Shopify to track inventory for that variant. If the inventory management value is not set to “shopify”, then Shopify will not track inventory for the given variant.

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.