Store Id Get the Store Id. |
| ||||||
Ad Account Name Get the Ad Account Name. |
| ||||||
My Shopify Domain Get the original shopify domain. |
| ||||||
Year Year such as 2017. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year month Year and month. |
| ||||||
Year week Year and week. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Month of the year Month of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Month and day Month and day |
| ||||||
Day of the week Week of the year |
| ||||||
Day of the month Day of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Product Id The unique product Id. |
| ||||||
Product Price The product price. |
| ||||||
Variant Product Id The product ID variant. |
| ||||||
Product SKU The product SKU. |
| ||||||
Product Created At The date and time (ISO 8601 format) when the product was created. |
| ||||||
Product Image The first image of the product |
| ||||||
Product Type A categorization for the product used for filtering and searching products. |
| ||||||
Product Published At 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. |
| ||||||
Product Status The status of the product. |
| ||||||
Product Tags A string of comma-separated tags that are used for filtering and search. A product can have up to 250 tags. Each tag can have up to 255 characters. |
| ||||||
Product Title The name of the product. |
| ||||||
Product Updated At The date and time (ISO 8601 format) when the product was last modified. A product's updated_at value can change for different reasons. For example, if an order is placed for a product that has inventory tracking set up, then the inventory adjustment is counted as an update. |
| ||||||
Product vendor The name of the product's vendor. |
| ||||||
Inventory product quantity The inventory product quantity. |
| ||||||
Customer Id A unique identifier for the customer. |
| ||||||
Customer first name The customer's first name. |
| ||||||
Customer last name The customer's last name. |
| ||||||
Customer email The customer's email. |
| ||||||
Customer Total Spend The customer's total spend. |
| ||||||
Customer Order Count The total order by the customer. |
| ||||||
Customer Created At The customer's email. |
| ||||||
Order Id The unique product Id. |
| ||||||
Order 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. This is different from the id property, which is the ID of the order used by the API. This field can also be set by the API to be any string value. |
| ||||||
Order note An optional note that a shop owner can attach to the order. |
| ||||||
Order tags Tags attached to the order, formatted as a string of comma-separated values. Tags are additional short descriptors, commonly used for filtering and searching. Each individual tag is limited to 40 characters in length. |
| ||||||
Order closed at The date and time (ISO 8601 format) when the order was closed. Returns null if the order isn't closed. |
| ||||||
Order cancelled at The date and time when the order was canceled. Returns null if the order isn't canceled. |
| ||||||
Shipping address 1 The street address of the shipping address. |
| ||||||
Shipping address 2 An optional additional field for the street address of the shipping address. |
| ||||||
Shipping phone The phone number at the shipping address. |
| ||||||
Shipping zip code The postal code (for example, zip, postcode, or Eircode) of the shipping address. |
| ||||||
Shipping city code The city, town, or village of the shipping address. |
| ||||||
Shipping province The name of the region (for example, province, state, or prefecture) of the shipping address. |
| ||||||
Shipping country : The name of the country of the shipping address. |
| ||||||
Billing address 1 The street address of the billing address. |
| ||||||
Billing address 2 An optional additional field for the street address of the billing address. |
| ||||||
Billing phone The phone number at the billing address. |
| ||||||
Billing zip code The postal code (for example, zip, postcode, or Eircode) of the billing address. |
| ||||||
Billing city code The city, town, or village of the billing address. |
| ||||||
Billing province The name of the region (for example, province, state, or prefecture) of the billing address. |
| ||||||
Billing country : The name of the country of the billing address. |
| ||||||
Source name The source of the checkout. |
| ||||||
Order confirmed Whether inventory has been reserved for the order. |
| ||||||
Order currency The three-letter code (ISO 4217 format) for the shop currency. |
| ||||||
Order email The customer's email address. |
| ||||||
Order is fully paid The financial status of the order equals to paid. |
| ||||||
Order discount code The discount code use at the order level. |
| ||||||
Order Location The fulfillment location used. |
| ||||||
Order shipping instruction Some special shipping instruction provided. |
| ||||||
Customer returning Whether the customer is returning or not. |
| ||||||
Order fulfillment status The order's status in terms of fulfilled line items. |
| ||||||
Order landing page The URL for the page where the buyer landed when they entered the shop. |
| ||||||
Order referring site The website where the customer clicked a link to the shop. |
| ||||||
UTM Content A/B testing and content-targeted ads to differentiate ads or links that point to the same URL. |
| ||||||
UTM term The keywords associated with an ad. |
| ||||||
UTM medium The ad medium, such as email or cost-per-click (cpc). |
| ||||||
UTM source Identifies a search engine, a newsletter name, or other source. |
| ||||||
UTM name The name that you give a promotion or campaign to identify it. |
| ||||||
Line Item ID Get the line item id. |
| ||||||
Is Gift card Whether or not the line item is a gift card. |
| ||||||
Number of items Get the number of items |
| ||||||
Discount The total discounts applied to the price of the order in the shop currency. |
| ||||||
Gross sales The sum of all line item prices in the shop currency. |
| ||||||
Total sales The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive. |
| ||||||
Total net sales The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips. |
| ||||||
Total tax The sum of all the taxes applied to the order in the shop currency. Must be positive. |
| ||||||
Total shipping The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive. |
| ||||||
Number of items of line Get the number of items |
| ||||||
Line Discount The total discounts applied to the price of the order in the shop currency. |
| ||||||
Line Gross sales The sum of all line item prices in the shop currency. |
| ||||||
Line Total sales The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive. |
| ||||||
Line Total net sales The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips. |
| ||||||
Line Total tax The sum of all the taxes applied to the order in the shop currency. Must be positive. |
| ||||||
Order created at The autogenerated date and time (ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed. |
| ||||||
Extracted Date The date where the extraction take times. |
| ||||||
Platform Name Return the platform name |
|