> For the complete documentation index, see [llms.txt](https://endash-guidance-docs.gitbook.io/cigro-data-templates/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/shopify-inventory-levels.md). # Shopify: Inventory Levels ## Description * Model representing the current status of an inventory level in Shopify. Inventory Levels are unique pairings of inventory items (which have a 1:1 relationship with product variants) and locations. Inventory Level = Inventory item @ a Location. ## Supported Data Sources * Shopify ## Columns | Type | Name | Description | | ---- | --------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | | \_fivetran\_synced | The time when a record was last updated by Fivetran. | | | available\_quantity | The available quantity of an inventory item at the inventory level's associated location. Returns null if the inventory item is not tracked. | | | inventory\_item\_id | The ID of the inventory item associated with the inventory level. | | | location\_id | The ID of the location that the inventory level belongs to. | | | updated\_at | The date and time (ISO 8601 format) when the inventory level was last modified. | | | is\_inventory\_item\_deleted | Boolean representing whether the record was soft-deleted in Shopify. | | | sku | The unique SKU (stock keeping unit) of the inventory item. | | | cost | The unit cost of the inventory item. The shop's default currency is used. | | | province\_code\_of\_origin | The province code (ISO 3166-2 alpha-2) of where the item came from. The province code is only used if the shipping provider for the inventory item is Canada Post. | | | country\_code\_of\_origin | The country code (ISO 3166-1 alpha-2) of where the item came from. | | | is\_shipping\_required | Boolean representing whether a customer needs to provide a shipping address when placing an order containing the inventory item. | | | is\_inventory\_quantity\_tracked | Boolean representing whether inventory levels are tracked for the item. If true, then the inventory quantity changes are tracked by Shopify. | | | inventory\_item\_created\_at | The date and time (ISO 8601 format) when the inventory item was created. | | | inventory\_item\_updated\_at | The date and time (ISO 8601 format) when the inventory item was last modified. | | | is\_location\_deleted | Boolean representing whether the record was soft-deleted in Shopify. | | | is\_location\_active | Boolean representing whether the location is active. If true, then the location can be used to sell products, stock inventory, and fulfill orders. | | | address\_1 | The location's street address. | | | address\_2 | The optional second line of the location's street address. | | | city | The city the location is in. | | | country | The country the location is in (two-letter code). | | | country\_code | The two-letter code (ISO 3166-1 alpha-2 format) corresponding to country the location is in. | | | location\_created\_at | The date and time (ISO 8601 format) when the location was created. | | | is\_legacy\_location | Boolean representing whether this is a fulfillment service location. If true, then the location is a fulfillment service location. If false, then the location was created by the merchant and isn't tied to a fulfillment service. | | | location\_name | The name of the location. | | | phone | The phone number of the location. This value can contain special characters, such as - or +. | | | province | The province, state, or district of the location. | | | province\_code | The province, state, or district code (ISO 3166-2 alpha-2 format) of the location. | | | location\_updated\_at | The date and time (ISO 8601 format) when the location was last updated. | | | zip | The zip or postal code. | | | variant\_barcode | The barcode, UPC, or ISBN number for the product. | | | variant\_created\_at | The date and time (ISO 8601 format) when the product variant was created. | | | variant\_fulfillment\_service | The fulfillment service associated with the product variant. | | | variant\_grams | The weight of the product variant in grams. | | | variant\_id | The unique numeric identifier for the product variant. | | | variant\_image\_id | The unique numeric identifier for a product's image. The image must be associated to the same product as the variant. | | | variant\_inventory\_management | The fulfillment service that tracks the number of items in stock for the product variant. | | | variant\_inventory\_policy | Whether customers are allowed to place an order for the product variant when it's out of stock. | | | variant\_inventory\_quantity | An aggregate of inventory across all locations. To adjust inventory at a specific location, use the InventoryLevel resource. | | | variant\_option\_1 | The custom properties that a shop owner uses to define product variants. You can define three options for a product variant: option1, option2, option3. | | | variant\_option\_2 | The custom properties that a shop owner uses to define product variants. You can define three options for a product variant: option1, option2, option3. | | | variant\_option\_3 | The custom properties that a shop owner uses to define product variants. You can define three options for a product variant: option1, option2, option3. | | | variant\_price | The price of the product variant in shop currency. | | | product\_id | The unique numeric identifier for the product. | | | is\_variant\_taxable | Whether a tax is charged when the product variant is sold. | | | variant\_tax\_code | This parameter applies only to the stores that have the Avalara AvaTax app installed. Specifies the Avalara tax code for the product variant. | | | variant\_title | The title of the product variant. The title field is a concatenation of the option1, option2, and option3 fields. You can only update title indirectly using the option fields. | | | variant\_updated\_at | The date and time when the product variant was last modified. Gets returned in ISO 8601 format. | | | variant\_weight | The weight of the product variant in the unit system specified with weight\_unit. | | | variant\_weight\_unit | The unit of measurement that applies to the product variant's weight. If you don't specify a value for weight\_unit, then the shop's default unit of measurement is applied. Valid values: g, kg, oz, and lb. | | | subtotal\_sold | Total amount (monetary, in shop currency) sold from the inventory level. Includes refunds. | | | quantity\_sold | Total quantity sold from the inventory level. Includes refunds. | | | count\_distinct\_orders | The number of distinct orders placed from this inventory level. | | | count\_distinct\_customers | The number of distinct customers (based on customer\_id) that have placed orders against this inventory level. | | | count\_distinct\_customer\_emails | The number of distinct customer emails that have placed orders against this inventory level. | | | first\_order\_timestamp | The timetamp of the first order against this inventory level. | | | last\_order\_timestamp | The timestamp of the first order against this inventory level. | | | subtotal\_sold\_refunds | The monetary amount (in shop currency) of inventory level goods that have been refunded. | | | quantity\_sold\_refunds | The quantity of inventory level goods that have been refunded. | | | net\_subtotal\_sold | Net monetary amount sold (in shop currency) from the inventory level. Excludes refunds. | | | net\_quantity\_sold | Net quantity sold from this inventory level. Excludes refunds. | | | count\_fulfillment\_pending | Count of currently pending distinct fulfillments for this inventory level. "Pending" = Shopify has created the fulfillment and is waiting for the third-party fulfillment service to transition it to 'open' or 'success'. | | | count\_fulfillment\_open | Count of currently open distinct fulfillments for this inventory level. "Open" = The fulfillment has been acknowledged by the service and is in processing. | | | count\_fulfillment\_success | Count of successful distinct fulfillments for this inventory level. "Success" = The fulfillment was successful. | | | count\_fulfillment\_cancelled | Count of cancelled distinct fulfillments for this inventory level. "Cancelled" = The fulfillment was cancelled. | | | count\_fulfillment\_error | Count of distinct fulfillments for this inventory level that encountered an error. "Error" = There was an error with the fulfillment request. | | | count\_fulfillment\_failure | Count of distinct fulfillments for this inventory level that failed. "Failure" = The fulfillment request failed. | | | source\_relation | The schema or database this record came from if you are making use of the `shopify_union_schemas` or `shopify_union_databases` variables, respectively. Empty string if you are not using either of these variables to union together multiple Shopify connectors. |