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. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/shopify-inventory-levels.md?ask=