Shopify
## Columns
| Type | Name | Description |
| ---- | ---------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| | is\_deleted | Whether the record has been deleted in the source system. |
| | \_fivetran\_synced | The time when a record was last updated by Fivetran. |
| | created\_timestamp | The date and time when the product was created. |
| | handle | A unique human-friendly string for the product. Automatically generated from the product's title. |
| | product\_id | An unsigned 64-bit integer that's used as a unique identifier for the product. Each id is unique across the Shopify system. No two products will have the same id, even if they're from different shops. |
| | product\_type | A categorization for the product used for filtering and searching products. |
| | published\_timestamp | The date and time (ISO 8601 format) when the product was published. Can be set to null to unpublish the product from the Online Store channel. |
| | published\_scope | Whether the product is published to the Point of Sale channel. |
| | title | The name of the product. |
| | updated\_timestamp | The date and time when the product was last modified. |
| | vendor | The name of the product's vendor. |
| | total\_quantity\_sold | Quantity of the product sold. |
| | subtotal\_sold | Total amount (in shop currency) of the product sold. |
| | quantity\_sold\_net\_refunds | Quantity of the product sold, excluding refunds. |
| | subtotal\_sold\_net\_refunds | Total amount (in shop currency) of the product sold, excluding refunds. |
| | first\_order\_timestamp | The timestamp the product was first ordered. |
| | most\_recent\_order\_timestamp | The timestamp the product was most recently ordered. |
| | source\_relation | The schema or database this record came from, if you are unioning multiple connectors. Null if not. |
| | avg\_quantity\_per\_order\_line | Average quantity per order line with this product. |
| | product\_total\_discount | Total discounts associated with the product. |
| | product\_avg\_discount\_per\_order\_line | Average discount per order line with this product. |
| | product\_total\_tax | Total taxes associated with the product. |
| | product\_avg\_tax\_per\_order\_line | Average taxes per order line with this product. |
| | count\_variants | Count of product variants. |
| | has\_product\_image | If the product has an image. |
| | status | The status of the product. Valid values: - active: The product is ready to sell and is available to customers on the online store, sales channels, and apps. By default, existing products are set to active. - archived: The product is no longer being sold and isn't available to customers on sales channels and apps. - draft: The product isn't ready to sell and is unavailable to customers on sales channels and apps. By default, duplicated and unarchived products are set to draft. |
| | collections | Comma-separated list of collections associated with the product. |
| | tags | Comma-separated list of tags associated with the product. |
---
# 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-products.md?ask=