Loading data from your Shopify account.

With Shopify, merchants can build and customize an online store and sell in multiple places, including web, mobile, in person, brick-and-mortar locations, and pop-up shops and across multiple channels from social media to online marketplaces.

This source allows you to easily connect your existing Shopify account to your DCN in order to ingest your customer IDs & their respective traits.

Creating a Shopify Source

You can create a new Shopify source from your DCN by going to the Integrations > Sources section in your navigation menu or by using the CLI and running the following command:

optable-cli source create shopify <name>

In both cases you will be redirected to your browser in order to authenticate & link your Shopify account to your DCN through our integration partner Fivetran. To continue, you will have to click I understand and authorize Fivetran to connect with your Shopify account.

Your Shopify username and password are never shared directly with Fivetran or Optable, they remain private throughout the process.

Next you will have to install the Fivetran app in your Shopify account page, once installed you will be redirected back to the authorization page where you must click "Save & Test". The connection will be completed and you will be redirected to your DCN while data ingestion starts.

Finally, if you created the source using your DCN UI you will be redirected to the sources listing. If you used the CLI, you will be able to close you browser and continue at the command line.

Here is an example of the expected CLI output:

$ optable-cli source create shopify my-example-source
  "id": 1,
  "name": "my-example-source",
  "created_at": "2022-06-08T15:45:00.502717Z",
  "updated_at": "2022-06-08T15:45:03.748793Z",
  "shopify": {},
  "version": {
    "minimum_timestamp": "2022-06-08T15:45:00.502716Z"

What Will You Get?

Currently, email addresses and phone numbers stored in your Shopify customer database will be periodically loaded as identifiers into your DCN along with the subscriber's country, email verification status, marketing opt-in level and order counts.


Email address (personal ID)


Phone number (personal ID)

Accepts marketing

Verified email

Marketing opt-in level

Order count

Last updated