Introduction

Datasources and destinations

Fields listing for Shopify

Store Id
Get the Store Id.
Field IDstore/store_id
TypeNUMBER
Data Typedimension
Ad Account Name
Get the Ad Account Name.
Field IDstore/name
TypeTEXT
Data Typedimension
My Shopify Domain
Get the original shopify domain.
Field IDstore/myshopify_domain
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Product Id
The unique product Id.
Field IDproduct/id
TypeTEXT
Data Typedimension
Product Price
The product price.
Field IDproduct/price
TypeTEXT
Data Typedimension
Variant Product Id
The product ID variant.
Field IDproduct/variant_id
TypeTEXT
Data Typedimension
Product SKU
The product SKU.
Field IDproduct/sku
TypeTEXT
Data Typedimension
Product Created At
The date and time (ISO 8601 format) when the product was created.
Field IDproduct/created_at
TypeYEAR_MONTH_DAY
Data Typedimension
Product Image
The first image of the product
Field IDproduct/image
TypeTEXT
Data Typedimension
Product Type
A categorization for the product used for filtering and searching products.
Field IDproduct/product_type
TypeTEXT
Data Typedimension
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.
Field IDproduct/published_at
TypeYEAR_MONTH_DAY
Data Typedimension
Product Status
The status of the product.
Field IDproduct/status
TypeTEXT
Data Typedimension
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.
Field IDproduct/tags
TypeTEXT
Data Typedimension
Product Title
The name of the product.
Field IDproduct/title
TypeTEXT
Data Typedimension
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.
Field IDproduct/updated_at
TypeYEAR_MONTH_DAY
Data Typedimension
Product vendor
The name of the product's vendor.
Field IDproduct/vendor
TypeTEXT
Data Typedimension
Inventory product quantity
The inventory product quantity.
Field IDproduct/inventory_quantity
TypeNUMBER
Data Typedimension
Customer Id
A unique identifier for the customer.
Field IDcustomer/id
TypeTEXT
Data Typedimension
Customer first name
The customer's first name.
Field IDcustomer/first_name
TypeTEXT
Data Typedimension
Customer last name
The customer's last name.
Field IDcustomer/last_name
TypeTEXT
Data Typedimension
Customer email
The customer's email.
Field IDcustomer/email
TypeTEXT
Data Typedimension
Customer Total Spend
The customer's total spend.
Field IDcustomer/total_spend
TypeNUMBER
Data Typedimension
Customer Order Count
The total order by the customer.
Field IDcustomer/order_count
TypeNUMBER
Data Typedimension
Customer Created At
The customer's email.
Field IDcustomer/created_at
TypeYEAR_MONTH_DAY
Data Typedimension
Order Id
The unique product Id.
Field IDorder/id
TypeTEXT
Data Typedimension
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.
Field IDorder/name
TypeTEXT
Data Typedimension
Order note
An optional note that a shop owner can attach to the order.
Field IDorder/note
TypeTEXT
Data Typedimension
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.
Field IDorder/tags
TypeTEXT
Data Typedimension
Order closed at
The date and time (ISO 8601 format) when the order was closed. Returns null if the order isn't closed.
Field IDorder/closed_at
TypeYEAR_MONTH_DAY
Data Typedimension
Order cancelled at
The date and time when the order was canceled. Returns null if the order isn't canceled.
Field IDorder/cancelled_at
TypeYEAR_MONTH_DAY
Data Typedimension
Shipping address 1
The street address of the shipping address.
Field IDorder/shipping_address_1
TypeTEXT
Data Typedimension
Shipping address 2
An optional additional field for the street address of the shipping address.
Field IDorder/shipping_address_2
TypeTEXT
Data Typedimension
Shipping phone
The phone number at the shipping address.
Field IDorder/shipping_phone
TypeTEXT
Data Typedimension
Shipping zip code
The postal code (for example, zip, postcode, or Eircode) of the shipping address.
Field IDorder/shipping_zip
TypeTEXT
Data Typedimension
Shipping city code
The city, town, or village of the shipping address.
Field IDorder/shipping_city
TypeTEXT
Data Typedimension
Shipping province
The name of the region (for example, province, state, or prefecture) of the shipping address.
Field IDorder/shipping_province
TypeTEXT
Data Typedimension
Shipping country
: The name of the country of the shipping address.
Field IDorder/shipping_country
TypeTEXT
Data Typedimension
Billing address 1
The street address of the billing address.
Field IDorder/billing_address_1
TypeTEXT
Data Typedimension
Billing address 2
An optional additional field for the street address of the billing address.
Field IDorder/billing_address_2
TypeTEXT
Data Typedimension
Billing phone
The phone number at the billing address.
Field IDorder/billing_phone
TypeTEXT
Data Typedimension
Billing zip code
The postal code (for example, zip, postcode, or Eircode) of the billing address.
Field IDorder/billing_zip
TypeTEXT
Data Typedimension
Billing city code
The city, town, or village of the billing address.
Field IDorder/billing_city
TypeTEXT
Data Typedimension
Billing province
The name of the region (for example, province, state, or prefecture) of the billing address.
Field IDorder/billing_province
TypeTEXT
Data Typedimension
Billing country
: The name of the country of the billing address.
Field IDorder/billing_country
TypeTEXT
Data Typedimension
Source name
The source of the checkout.
Field IDorder/source_name
TypeTEXT
Data Typedimension
Order confirmed
Whether inventory has been reserved for the order.
Field IDorder/confirmed
TypeBOOLEAN
Data Typedimension
Order currency
The three-letter code (ISO 4217 format) for the shop currency.
Field IDorder/currency
TypeTEXT
Data Typedimension
Order email
The customer's email address.
Field IDorder/email
TypeTEXT
Data Typedimension
Order is fully paid
The financial status of the order equals to paid.
Field IDorder/fully_paid
TypeBOOLEAN
Data Typedimension
Order discount code
The discount code use at the order level.
Field IDorder/discount
TypeTEXT
Data Typedimension
Order Location
The fulfillment location used.
Field IDorder/location_name
TypeTEXT
Data Typedimension
Order shipping instruction
Some special shipping instruction provided.
Field IDorder/shipping_description
TypeTEXT
Data Typedimension
Customer returning
Whether the customer is returning or not.
Field IDorder/is_returning_customer
TypeBOOLEAN
Data Typedimension
Order fulfillment status
The order's status in terms of fulfilled line items.
Field IDorder/fulfillment_status
TypeTEXT
Data Typedimension
Order landing page
The URL for the page where the buyer landed when they entered the shop.
Field IDorder/landing_page_url
TypeTEXT
Data Typedimension
Order referring site
The website where the customer clicked a link to the shop.
Field IDorder/referring_site
TypeTEXT
Data Typedimension
UTM Content
A/B testing and content-targeted ads to differentiate ads or links that point to the same URL.
Field IDorder/utm_content
TypeTEXT
Data Typedimension
UTM term
The keywords associated with an ad.
Field IDorder/utm_term
TypeTEXT
Data Typedimension
UTM medium
The ad medium, such as email or cost-per-click (cpc).
Field IDorder/utm_medium
TypeTEXT
Data Typedimension
UTM source
Identifies a search engine, a newsletter name, or other source.
Field IDorder/utm_source
TypeTEXT
Data Typedimension
UTM name
The name that you give a promotion or campaign to identify it.
Field IDorder/utm_name
TypeTEXT
Data Typedimension
Line Item ID
Get the line item id.
Field IDline_item/id
TypeTEXT
Data Typedimension
Is Gift card
Whether or not the line item is a gift card.
Field IDline_item/gift_card
TypeBOOLEAN
Data Typedimension
Number of items
Get the number of items
Field IDitems
TypeNUMBER
Data Typemetric
Discount
The total discounts applied to the price of the order in the shop currency.
Field IDdiscounts
TypeNUMBER
Data Typemetric
Gross sales
The sum of all line item prices in the shop currency.
Field IDgross
TypeNUMBER
Data Typemetric
Total sales
The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.
Field IDprice
TypeNUMBER
Data Typemetric
Total net sales
The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips.
Field IDnet_total
TypeNUMBER
Data Typemetric
Total tax
The sum of all the taxes applied to the order in the shop currency. Must be positive.
Field IDtax
TypeNUMBER
Data Typemetric
Total shipping
The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.
Field IDshipping
TypeNUMBER
Data Typemetric
Number of items of line
Get the number of items
Field IDline_items
TypeNUMBER
Data Typemetric
Line Discount
The total discounts applied to the price of the order in the shop currency.
Field IDline_discounts
TypeNUMBER
Data Typemetric
Line Gross sales
The sum of all line item prices in the shop currency.
Field IDline_gross
TypeNUMBER
Data Typemetric
Line Total sales
The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.
Field IDline_price
TypeNUMBER
Data Typemetric
Line Total net sales
The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips.
Field IDline_net_total
TypeNUMBER
Data Typemetric
Line Total tax
The sum of all the taxes applied to the order in the shop currency. Must be positive.
Field IDline_tax
TypeNUMBER
Data Typemetric
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.
Field IDorder/created_at_ref
TypeYEAR_MONTH_DAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension