Shopify: Import Audiences & Activity Data
Importing your Shopify customers and their activity data into Lytics enables you to run personalized marketing campaigns for your Shopify customers.
Integration Details
- Implementation Type: Server-side.
- Implementation Technique: REST API.
- Frequency: Batch.
- Resulting data: User profiles and raw event data.
This integration utilizes the Shopify APIs to import user data. Once the import is started the job will:
- Import all customers and orders from your Shopify account into the
shopify_usersandshopify_ordersstreams, respectively. - Continue to import any new customers and orders hourly.
Fields
The following fields are included in the default mapping of the shopify_users stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| id | shopify_customer_id unique id | Shopify Customer Id | string |
email unique id | string | ||
| default_address.address1 | address_1 | Address 1 | string |
| default_address.address2 | address_2 | Address 2 | string |
| default_address.city | city | City | string |
| default_address.country, default_address.country_code | country | Country | string |
| first_name | first_name | First Name | string |
| last_name | last_name | Last Name | string |
| phone | phone | Phone Number | string |
| default_address.zip | postal_code | Zip | string |
| accepts_marketing | shopify_accepts_marketing | Shopify Accepts Marketing | string |
| created_at | shopify_created_ts | Shopify Created Time | string |
| last_order_name | shopify_last_order_name | Shopify Name on Last Order | string |
| orders_count | shopify_purchase_ct | Shopify Lifetime Number of Orders | string |
| tax_exempt | shopify_tax_exempt | Shopify Tax Exempt | string |
| tags | shopify_customer_tags | Shopify Tags Attached to the Customer | []string |
| total_spent | shopify_total_spent | Shopify Lifetime Total Spent | string |
| updated_at | shopify_updated_ts | Shopify Updated Time | string |
| default_address.state | state | State | string |
The following fields are included in the default mapping of the shopify_orders stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| order_id | shopify_order_ids unique id | Shopify Order IDs | []string |
email unique id | string | ||
| customer_id | shopify_customer_id unique id | Shopify Customer ID | string |
| created_at | last_purchase_ts | Most Recent Order Time | date |
| discount_codes | shopify_discount_codes | Shopify Discount Codes Used | []string |
| created_at | shopify_first_order_ts | First Order Time | date |
| item_ids | shopify_item_ids | Shopify Item Ids | []string |
| currency | shopify_last_order_currency | Last Order Currency | string |
| total_price | shopify_last_order_price | Last Order Price | string |
| product_ids | shopify_product_ids | Shopify Product Ids Ordered | []string |
| product_names | shopify_product_names | Shopify Product Names Ordered | []string |
| product_titles | shopify_product_titles | Shopify Products Titles Ordered | []string |
| variant_ids | shopify_variant_ids | Shopify Variant Ids | []string |
Configuration
Follow these steps to set up and configure an import of Shopify data into the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select Shopify from the list of providers.
- Select the Import Audiences & Activity Data job type from the list.
- Select the Authorization you would like to use or create a new one.
- Enter a Label to identify this job you are creating in Lytics.
- (Optional) Enter a Description for further context on your job.
- (Optional) Select the Import Customer Metafields to import metafields associated with each Shopify user.
- Select the Keep Updated checkbox to continuously run this import.
- Click Start Import.
