Shopify
## Columns
| Type | Name | Description |
| ---- | ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| | \_fivetran\_synced | The time when a record was last updated by Fivetran. |
| | app\_id | The ID of the app that created the order. |
| | billing\_address\_address\_1 | The street address of the billing address. |
| | billing\_address\_address\_2 | An optional additional field for the street address of the billing address. |
| | billing\_address\_city | The city, town, or village of the billing address. |
| | billing\_address\_company | The company of the person associated with the billing address. |
| | billing\_address\_country | The name of the country of the billing address. |
| | billing\_address\_country\_code | The two-letter code (ISO 3166-1 format) for the country of the billing address. |
| | billing\_address\_first\_name | The first name of the person associated with the payment method. |
| | billing\_address\_last\_name | The last name of the person associated with the payment method. |
| | billing\_address\_latitude | The latitude of the billing address. |
| | billing\_address\_longitude | The longitude of the billing address. |
| | billing\_address\_name | The full name of the person associated with the payment method. |
| | billing\_address\_phone | The phone number at the billing address. |
| | billing\_address\_province | The name of the region (province, state, prefecture, …) of the billing address. |
| | billing\_address\_province\_code | The two-letter abbreviation of the region of the billing address. |
| | billing\_address\_zip | The postal code (zip, postcode, Eircode, …) of the billing address. |
| | browser\_ip | The IP address of the browser used by the customer when they placed the order. |
| | has\_buyer\_accepted\_marketing | Whether the customer consented to receive email updates from the shop. |
| | cancel\_reason | The reason why the order was canceled. |
| | cancelled\_timestamp | The date and time when the order was canceled. |
| | cart\_token | The ID of the cart that's associated with the order. |
| | closed\_timestamp | The date and time when the order was closed (archived). |
| | created\_timestamp | The autogenerated date and time when the order was created in Shopify. |
| | currency | The three-letter code for the shop currency. |
| | customer\_id | The ID of the order's customer. |
| | email | The customer's email address. |
| | financial\_status | The status of payments associated with the order. Can only be set when the order is created |
| | fulfillment\_status | The order's status in terms of fulfilled line items. |
| | order\_id | The ID of the order, used for API purposes. This is different from the order\_number property, which is the ID used by the shop owner and customer. |
| | landing\_site\_base\_url | The URL for the page where the buyer landed when they entered the shop. |
| | location\_id | The ID of the physical location where the order was processed. |
| | name | The order name, generated by combining the order\_number property with the order prefix and suffix that are set in the merchant's general settings. |
| | note | An optional note that a shop owner can attach to the order. |
| | number | The order's position in the shop's count of orders. Numbers are sequential and start at 1. |
| | order\_number | The order 's position in the shop's count of orders starting at 1001. Order numbers are sequential and start at 1001. |
| | processed\_timestamp | The date and time when an order was processed. This value is the date that appears on your orders and that's used in the analytic reports. |
| | referring\_site | The website where the customer clicked a link to the shop. |
| | shipping\_address\_address\_1 | The street address of the shipping address. |
| | shipping\_address\_address\_2 | An optional additional field for the street address of the shipping address. |
| | shipping\_address\_city | The city, town, or village of the shipping address. |
| | shipping\_address\_company | The company of the person associated with the shipping address. |
| | shipping\_address\_country | The name of the country of the shipping address. |
| | shipping\_address\_country\_code | The two-letter code (ISO 3166-1 format) for the country of the shipping address. |
| | shipping\_address\_first\_name | The first name of the person associated with the shipping address. |
| | shipping\_address\_last\_name | The last name of the person associated with the shipping address. |
| | shipping\_address\_latitude | The latitude of the shipping address. |
| | shipping\_address\_longitude | The longitude of the shipping address. |
| | shipping\_address\_name | The full name of the person associated with the payment method. |
| | shipping\_address\_phone | The phone number at the shipping address. |
| | shipping\_address\_province | The name of the region (province, state, prefecture, …) of the shipping address. |
| | shipping\_address\_province\_code | The two-letter abbreviation of the region of the shipping address. |
| | shipping\_address\_zip | The postal code (zip, postcode, Eircode, …) of the shipping address. |
| | source\_name | Where the order originated. Can be set only during order creation, and is not writeable afterwards. |
| | source\_relation | The ID of the order placed on the originating platform. This value doesn't correspond to the Shopify ID that's generated from a completed draft. |
| | subtotal\_price | The price of the order in the shop currency after discounts but before shipping, taxes, and tips. |
| | has\_taxes\_included | Whether taxes are included in the order subtotal. |
| | is\_test\_order | Whether this is a test order. |
| | token | A unique token for the order. |
| | total\_discounts | The total discounts applied to the price of the order in the shop currency. |
| | total\_line\_items\_price | The sum of all line item prices in the shop currency. |
| | total\_price | The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive. |
| | total\_tax | The sum of all the taxes applied to the order in th shop currency. Must be positive. |
| | total\_weight | The sum of all line item weights in grams. |
| | updated\_timestamp | The date and time (ISO 8601 format) when the order was last modified. |
| | user\_id | The ID of the user logged into Shopify POS who processed the order, if applicable. |
| | line\_item\_count | Number of line items included in the order. |
| | customer\_order\_seq\_number | The sequential number of the order as it relates to the customer |
| | new\_vs\_repeat | Whether the order was a new or repeat order for the customer. |
| | shipping\_cost | The shipping cost of the order. |
| | order\_adjustment\_amount | Total adjustment amount applied to the order in shop currency. |
| | order\_adjustment\_tax\_amount | Total tax applied to the adjustment on the order in shop currency. |
| | refund\_subtotal | Total refund amount applied to the order in shop currency. |
| | refund\_total\_tax | Total tax applied to the refund on the order in shop currency. |
| | order\_adjusted\_total | Order total adjusted for refunds and other adjustments. The calculation used for this field is as follows: total price listed on the original order (including shipping costs and discounts) + adjustments + adjustments tax - total refunds - refunds tax The order\_adjusted\_total will equate to the total sales - refunds listed within the transactions table for the order (after currency exchange). |
| | checkout\_token | The checkout token applied to the order. |
| | total\_shipping\_price\_set | The total shipping price set to the order. |
| | order\_total\_shipping\_tax | Total shipping tax attributed to the order. |
| | order\_tags | List of tags associated with the order. |
| | order\_url\_tags | List of url tags associated with the order. |
| | number\_of\_fulfillments | Total fulfillments for the order. |
| | fulfillment\_services | List of fulfillment services for the order. |
| | tracking\_companies | List of tracking companies for the order. |
| | tracking\_numbers | List of tracking numbers for the order. |
| | total\_tip\_received | The sum of all the tips in the order in the shop currency. |
| | checkout\_id | The ID for the checkout. |
| | client\_details\_user\_agent | Details of the browsing client, including software and operating versions. |
| | customer\_locale | The two or three-letter language code, optionally followed by a region modifier. Example values - en, en-CA. |
| | order\_status\_url | The URL pointing to the order status web page, if applicable. |
| | presentment\_currency | The three-letter code (ISO 4217 format) of the currency that the customer used at checkout. For the shop's default currency, see `currency`. |
| | is\_deleted | Boolean representing whether the record was soft-deleted in Shopify. |
| | total\_discounts\_set | The total discounts applied to the price of the order in shop and presentment currencies. |
| | total\_line\_items\_price\_set | The total of all line item prices in shop and presentment currencies. |
| | total\_price\_set | The total price of the order in shop and presentment currencies. |
| | total\_tax\_set | The total tax applied to the order in shop and presentment currencies. |
| | is\_confirmed | Whether the order is confirmed. |
| | shipping\_discount\_amount | The total amount of discount (in shop currency) allocated toward shipping. |
| | percentage\_calc\_discount\_amount | The total amount of discount (in shop currency) allocated via a percentage-based discount |
| | fixed\_amount\_discount\_amount | The total amount of discount (in shop currency) allocated via a fixed-amount discount |
| | count\_discount\_codes\_applied | Distinct discount codes applied on the order |
---
# 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-orders.md?ask=