Manage and track Shopify inventory with Airtable

Updating your Shopify inventory with Airtable is one of the most common use cases that we see our clients implementing. You can update the inventory for a particular product/variant, track how much inventory you have in stock, share inventory information with vendors, or bulk update Shopify inventory as needed. AirPower gives you a few ways to set this up, ensuring maximum flexibility. This flexibility can come in very handy, especially in cases where you want to share access to your inventory data to others (e.g., warehouse fulfillment) or want to link up the inventory data in Airtable with other systems.

Before we show how to store and update Shopify inventory in Airtable using AirPower, it's important to explain just how Shopify stores inventory quantities. 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 a product in its own database. This inventory-variant relationship is important to understand as we set up inventory tracking/updates in Airtable.

How you configure AirPower to integrate Shopify inventory information with Airtable depends on a) whether you want to have inventory data in a separate table, and b) whether your product and variant information is contained on the same table.

This is the recommended set-up if you have multiple variants per product, and therefore your variants live in their own table. AirPower allows you to set up individual columns to track the inventory quantity at each location where the variant is stored. So, for example, if you have three locations you can track a variant's quantity at each location by modifying the relevant column data for the variant row.

To enable this simply set the table that AirPower should sync inventory data to/from to be the same as the table where you are storing your variants (in the example screenshot below the table name is "Variants"). The moment you do this you will see a new section within the inventory configuration called "Columns Containing Inventory Quantities". Here you can specify the columns that will track a variant's inventory at each location you have. You can create as many columns as you have inventory locations defined in Shopify. You'll need to specify the ID of the Location for each column, the name of the column in your table, as well as whether you want the data to sync from Shopify to Airtable, Airtable to Shopify, or in both directions.

Our Expanded template base for integrating Airtable and Shopify is set up in this manner, with a single column to sync inventory quantity information.

Case 2 - Storing inventory and variant information on products table

This is the recommended set-up if you have only one variant per product, and therefore your variants live on the same table as your products. AirPower allows you to set up individual columns to track the inventory quantity at each location where the variant is stored. So, for example, if you have three locations you can track a variant's quantity at each location by modifying the relevant column data for the variant row.

To enable this simply set the table that AirPower should sync inventory data to/from to be the same as the table where you are storing your products (in the example screenshot below the table name is "Products"). This should also be the same table where you are syncing your variant data. In other words, your inventory, variant, and product configurations should sync to the same table. The moment you do this you will see a new section within the inventory configuration called "Columns Containing Inventory Quantities". Here you can specify the columns that will track a variant's inventory at each location you have. You can create as many columns as you have inventory locations defined in Shopify. You'll need to specify the ID of the Location for each column, the name of the column in your table, as well as whether you want the data to sync from Shopify to Airtable, Airtable to Shopify, or in both directions.

Our Compact template base for integrating Airtable and Shopify is set up in this manner, with a single column to sync inventory quantity information, and inventory, products, and variants living on the same table.

Case 3 - Storing inventory information in its own table

If you'd like to store inventory information on its own table then simply have your inventory configuration section in your AirPower config point to a table that is different from the one where you store your variants. You will have to ensure that this table has a link to your variants table, and each row in the inventory table will store the inventory of a variant at one particular location. This is an advanced set up, so please reach out to our support team if you'd like to have things set up this way, and we'll get everything done for you.`

© 2019 Intelaria Corporation