Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
Day of the month Day of the year |
| ||||||
Day of the week Week of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Month of the year Month of the year |
| ||||||
Month and day Month and day |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Week of the year (start Sunday) Week of the year |
| ||||||
Year Year such as 2017. |
| ||||||
Year month Year and month. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year week Year and week. |
| ||||||
Average Total Sales Average Total Sales |
| ||||||
Cost of Goods Sold The cost of goods sold for the order in the shop currency. This is the sum of all inventory unit costs for the line items in the order. |
| ||||||
Customer City The customer's city. |
| ||||||
Customer Country The customer's country. |
| ||||||
Customer Country Code The customer's country code. |
| ||||||
Customer Created At The customer's email. |
| ||||||
Customer email The customer's email. |
| ||||||
Customer first name The customer's first name. |
| ||||||
Customer Id A unique identifier for the customer. |
| ||||||
Customer last name The customer's last name. |
| ||||||
Customer Order Count The total order by the customer. |
| ||||||
Customer Total Spend The customer's total spend. |
| ||||||
Discount The total discounts applied to the price of the order in the shop currency. |
| ||||||
Duties The total duties applied to the order in the shop currency. |
| ||||||
Gross sales The sum of all line item prices in the shop currency. |
| ||||||
Inventory Unit Cost The cost of the inventory unit in the shop currency. |
| ||||||
Order items number 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. |
| ||||||
Is Gift card Whether or not the line item is a gift card. |
| ||||||
Line Item ID Get the line item id. |
| ||||||
Number of items of line Get the number of items |
| ||||||
Line Total net sales The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips. |
| ||||||
Line Total sales The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive. |
| ||||||
Line Total tax The sum of all the taxes applied to the order 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. |
| ||||||
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 city code The city, town, or village of the billing address. |
| ||||||
Billing country : The name of the country of the billing address. |
| ||||||
Billing phone The phone number at the billing address. |
| ||||||
Billing province The name of the region (for example, province, state, or prefecture) of the billing address. |
| ||||||
Billing zip code The postal code (for example, zip, postcode, or Eircode) of the billing address. |
| ||||||
Order cancelled at The date and time when the order was canceled. Returns null if the order isn't canceled. |
| ||||||
Channel (App name) The name of the app that created the order, if the order was created by an app. |
| ||||||
Sales Channel The sales channel through which the order was placed, such as Online Store, POS, or Facebook. |
| ||||||
Order closed at The date and time (ISO 8601 format) when the order was closed. Returns null if the order isn't closed. |
| ||||||
Order confirmed Whether inventory has been reserved for the order. |
| ||||||
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. |
| ||||||
Order currency The three-letter code (ISO 4217 format) for the shop currency. |
| ||||||
Order discount code The discount code use at the order level. |
| ||||||
Financial status The status of payments associated with the order. Possible values include: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided. |
| ||||||
Order email The customer's email address. |
| ||||||
Order fulfillment status The order's status in terms of fulfilled line items. |
| ||||||
Order is fully paid The financial status of the order equals to paid. |
| ||||||
Order Id The unique order Id. |
| ||||||
Customer returning Whether the customer is returning or not. |
| ||||||
Order landing page The URL for the page where the buyer landed when they entered the shop. |
| ||||||
Landing site ref The URL of the page where the buyer landed when they entered the shop. |
| ||||||
Order Location The fulfillment location used. |
| ||||||
Marketing Source Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown. |
| ||||||
Marketing Source Type Type of marketing tactic. |
| ||||||
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 referring site The website where the customer clicked a link to the shop. |
| ||||||
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 city code The city, town, or village of the shipping address. |
| ||||||
Shipping country : The name of the country of the shipping address. |
| ||||||
Order shipping instruction Some special shipping instruction provided. |
| ||||||
Shipping method The shipping method used for the order. |
| ||||||
Shipping phone The phone number at the shipping address. |
| ||||||
Shipping province The name of the region (for example, province, state, or prefecture) of the shipping address. |
| ||||||
Shipping zip code The postal code (for example, zip, postcode, or Eircode) of the shipping address. |
| ||||||
Source name The source of the checkout. |
| ||||||
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. |
| ||||||
UTM Content A/B testing and content-targeted ads to differentiate ads or links that point to the same URL. |
| ||||||
UTM medium The ad medium, such as email or cost-per-click (cpc). |
| ||||||
UTM name The name that you give a promotion or campaign to identify it. |
| ||||||
UTM source Identifies a search engine, a newsletter name, or other source. |
| ||||||
UTM term The keywords associated with an ad. |
| ||||||
Total sales The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive. |
| ||||||
Product Created At The date and time (ISO 8601 format) when the product was created. |
| ||||||
Product Id The unique product Id. |
| ||||||
Product Image The first image of the product |
| ||||||
Inventory product quantity The inventory product quantity. |
| ||||||
Product Price The product price. |
| ||||||
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 Variant SKU The product SKU. |
| ||||||
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. |
| ||||||
Variant Product Id The product ID variant. |
| ||||||
Variant Product Title The name of the product variant. |
| ||||||
Product vendor The name of the product's vendor. |
| ||||||
Refund The total amount refunded for the order. |
| ||||||
Return Fee captured as part of a return |
| ||||||
Total Shipping The total shipping price of the order in the shop currency. Must be positive. |
| ||||||
My Shopify Domain Get the original shopify domain. |
| ||||||
Store Name Get the Store Name. |
| ||||||
Store Id Get the Store Id. |
| ||||||
Total tax The sum of all the taxes applied to the order in the shop currency. Must be positive. |
| ||||||
Total New Customer Total New Customer |
| ||||||
Total Returning Customer Total Returning Customer |
|
.svg){kind=logo}