Shopify
## Columns
| Type | Name | Description |
| ---- | ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| | \_fivetran\_synced | The time when a record was last updated by Fivetran. |
| | fulfillable\_quantity | The amount available to fulfill, calculated as follows: quantity - max(refunded\_quantity, fulfilled\_quantity) - pending\_fulfilled\_quantity - open\_fulfilled\_quantity |
| | fulfillment\_status | How far along an order is in terms line items fulfilled. |
| | is\_gift\_card | Whether the item is a gift card. If true, then the item is not taxed or considered for shipping charges. |
| | grams | The weight of the item in grams. |
| | order\_line\_id | The ID of the line item. |
| | name | The name of the product variant. |
| | order\_id | The ID of the related order. |
| | price | The price of the item before discounts have been applied in the shop currency. |
| | product\_id | The ID of the product that the line item belongs to. Can be null if the original product associated with the order is deleted at a later date. |
| | quantity | The number of items that were purchased. |
| | is\_shipping\_required | Whether the item requires shipping. |
| | sku | The item's SKU (stock keeping unit). |
| | is\_taxable | Whether the item was taxable. |
| | title | The title of the product. |
| | total\_discount | The total amount of the discount allocated to the line item in the shop currency. |
| | variant\_id | The ID of the product variant. |
| | vendor | The name of the item's supplier. |
| | refunded\_quantity | Quantity of the item that has been refunded. |
| | quantity\_net\_refunds | Quantity ordered, excluding refunds. |
| | variant\_barcode | The barcode, UPC, or ISBN number for the product. |
| | variant\_compare\_at\_price | The original price of the item before an adjustment or a sale in shop currency. |
| | 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. |
| | inventory\_item\_id | The unique identifier for the inventory item, which is used in the Inventory API to query for inventory information. |
| | 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\_position | The order of the product variant in the list of product variants. The first position in the list is 1. The position of variants is indicated by the order in which they are listed. |
| | variant\_price | The price of the product variant. |
| | variant\_sku | A unique identifier for the product variant in the shop. Required in order to connect to a FulfillmentService. |
| | variant\_is\_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. |
| | refunded\_subtotal | Subtotal amount of the refund applied to the order line in shop currency. |
| | subtotal\_net\_refunds | Subtotal of the order line with refunds subtracted in shop currency. |
| | image\_id | Image id of the product variant associated with the order line. |
| | source\_relation | The schema or database this record came from, if you are unioning multiple connectors. Null if not. |
| | restock\_types | List of how this refund line item affects inventory levels. |
| | order\_line\_tax | Total taxes for the line item. |
| | index | The index associated with the order. |
| | pre\_tax\_price | The total pre tax price of the order. |
| | 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. |
| | pre\_tax\_price\_set | The pre tax price of the line item in shop currency and presentment currency. |
| | price\_set | The price of the line item in shop and presentment currencies. |
| | total\_discount\_set | The total amount allocated to the line item in the presentment currency. |
| | properties | Line item properties. |
---
# 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-order-lines.md?ask=