Shopify

Shopify is a commerce platform that allows anyone to easily sell online, at a retail location, and everywhere in between. It's computer software platform and retail point of sale (POS) system.

  • Shopify Plus compatible
  • All key data ingested
  • Sync all historical data
  • Establish the connection in a few clicks
  • Combine your Shopify data with other sources to create a single view of the customer
Shopify
Source

Sync your data from Shopify

All historical data
Daily sync
These are the tables and data you can expect to have replicated in The Data Refinery's standardised schema. This may change over time.
We're making some changes to this connection. Check back later or contact us for information.
Contact Us
Table
Column
Customer
customer_id first_name last_name email phone state
Customer Address
customer_id address_1 address_2 city province zip country phone
Order
order_id customer_id order_name currency created_at total_price total_discounts total_tax financial_status
Order Line
order_line_id product_id variant_id order_id title name sku quantity price pre_tax_price total_discount
Order Line Refund
order_line_id refund_line_id quantity subtotal total_tax
Order Shipping Line
order_id total_shipping
Product
product_id title product_type vendor
Product Variant
variant_id product_id price created_at sku weight weight_unit
Shop
country
Tax Line
order_line_id price
Transaction
transaction_id order_id amount created_at gateway kind status
URL Tag
order_id key value
Destination

Send data to Shopify

For details on how you can use Shopify as a data destination, please contact us.
Contact Us

Related integrations

WooCommerce
PrestaShop
Microsoft Dynamics 365
Salesforce
View all integrations

Ready to unleash the power of your data?

Whether you want to streamline your reporting, create data-driven marketing segmentations, or just want all your data in one place, we'll show you how The Data Refinery can maximise the value of your data.
Book a Demo