🍏

ProductVariants

How to read this page

The product_variants table also contains properties from the InventoryItems object. This is because each product variant has a 1-1 relationship with an InventoryItem object so it's not necessary to have a dedicated table for InventoryItems As a result, there's an additional column called Parent Object that specifies whether the field is derived from a ProductVariant or an InventoryItem. Both documentation pages are listed below

GraphQL Documentation

Product Variant Schema

Default Field NameParent ObjectDirect from APIDescriptionEditable from Airtable
displayName
ProductVariant
id
ProductVariant
createdAt
ProductVariant
updatedAt
ProductVariant
title
ProductVariant
availableForSale
ProductVariant
price
ProductVariant
compareAtPrice
ProductVariant
image
ProductVariant
productVariant.image.originalSrc
inventoryItem
ProductVariant
JSON in the shape of { "id": productVariant.inventoryItem.id }
inventoryPolicy
ProductVariant
product
ProductVariant
An airtable record link to the related product that will be filled in if the products table is also synced
product.id
ProductVariant
productVariant.product.id
inventoryQuantity
ProductVariant
selectedOptions.1
ProductVariant
the first item in productVariant.selectedItems
selectedOptions.2
ProductVariant
the second item in productVariant.selectedItems
selectedOptions.3
ProductVariant
the third item in productVariant.selectedItems
storefrontId
ProductVariant
sku
ProductVariant
taxable
ProductVariant
fulfillmentService
ProductVariant
JSON in the shape of { "id": productVariant.fulfillmentService.id }
fulfillmentServiceEditable
ProductVariant
JSON of productVariant.fulfillmentServiceEditable with all its properties
weight
ProductVariant
weightUnit
ProductVariant
deliveryProfile
ProductVariant
JSON in the shape of { "id": productVariant.deliveryProfile.id }
requiresShipping
ProductVariant
taxCode
ProductVariant
barcode
ProductVariant
legacyResourceId
ProductVariant
position
ProductVariant
inventoryItem.id
InventoryItem
inventoryItem.id
inventoryItem.createdAt
InventoryItem
inventoryItem.createdAt
inventoryItem.updatedAt
InventoryItem
inventoryItem.updatedAt
inventoryItem.legacyResourceId
InventoryItem
inventoryItem.legacyResourceId
duplicateSkuCount
InventoryItem
inventoryHistoryUrl
InventoryItem
locationsCount
InventoryItem
harmonizedSystemCode
InventoryItem
countryCodeOfOrigin
InventoryItem
provinceCodeOfOrigin
InventoryItem
tracked
InventoryItem
trackedEditable
InventoryItem
unitCost.amount
InventoryItem
inventoryItem.unitCost.amount
unitCost.currencyCode
InventoryItem
inventoryItem.unitCost.currencyCode