Shopify
Overview
Shopify is an ecommerce platform that enables you to sell in multiple places including online with your ecommerce store, online marketplaces, social media, and in-person with point of sale.
Integrating Lytics with Shopify allows you to import customer, order, and product data into Lytics so that you can run segmented marketing campaigns and offer relevant recommendations for your Shopify customers.
Authorization
If you haven't already done so, you will need to set up a Shopify custom app before you begin the process described below. To setup a custom app, follow the custom apps documentation. In order for Lytics to import the Shopify customer and order details, the permissions read_orders
, read_customers
and read_products
must be granted to the generated access token. To add these scopes to the API token, navigate to the Configuration tab within your custom app and select Edit to add additional scope permissions within the Shopify Admin API Integration.
To get the access token follow the custom apps authentication instructions on Shopify.
If you are new to creating authorizations in Lytics, see the Authorizations Dashboard documentation for more information.
- Select Shopify from the list of providers.
- Select the Shopify API Token authorization method.
- Enter a Label to identify your authorization.
- (Optional) Enter a Description for further context on your authorization.
- In the Access Token field, enter your Shopify access token.
- Enter your Shopify store Subdomain.
- Click Authorize.
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 Integration
- Implementation Technique: REST API Integration
- Frequency: Batch Integration
- 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_users
andshopify_orders
streams, 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 |
email_marketing_consent.state | shopify_email_marketing_consent | Shopify Accepts Email Marketing | string |
email_marketing_consent.opt_in_level | shopify_email_marketing_consent_opt_in_level | Shopify Email Marketing Opt In Level | interface{} |
email_marketing_consent.consent_updated_at | shopify_email_marketing_consent_updated_ts | Shopify Email Marketing Consent Updated At | string |
sms_marketing_consent.state | shopify_sms_marketing_consent | Shopify Accepts SMS Marketing | string |
sms_marketing_consent.opt_in_level | shopify_sms_marketing_consent_opt_in_level | Shopify SMS Marketing Opt In Level | string |
sms_marketing_consent.consent_updated_at | shopify_sms_marketing_consent_updated_ts | Shopify SMS Marketing Consent Updated At | string |
sms_marketing_consent.consent_collected_from | shopify_sms_marketing_consent_collected_from | Shopify SMS Marketing Consent Collected From | 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 |
shop_name | shopify_shops | Shopify Store Names | []string |
shop_name,total_spent | shopify_shop_ltv | Shopify LifeTime Total Spend by Shop | map[string]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 |
shop_name | shopify_order_shops | Shopify Order Store Names | []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 Data Sources 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.
Import Products
Importing Shopify products allows you to enrich your use of Affinities with product data from your Shopify store. Serve your customers with relevant messaging and product recommendations based on how they have engaged with your brand.
Integration Details
- Implementation Type: Server-side Integration
- Implementation Technique: REST API Integration
- Frequency: Batch Integration
- Resulting data: Content
This import utilizes the Shopify Product API to import user data. Once the import is started the job will:
- Import all products updated after the configured Start Date and up to the configured End Date into the
shopify_products
stream. If no dates are specified in the configuration, all products will be imported. - If Keep Updated is selected, the workflow will import modified products daily.
Fields
The following fields are included in the default mapping of the shopify_products
stream:
Source Field | Lytics Content Field | Description | Type |
---|---|---|---|
variants.created_at | created | Date Created | date |
variants.inventory_quantity | inventory_quantity | Inventory Quantity | number |
variants.price | price | Price | number |
variants.sku | sku | SKU | string |
variants.updated_at | updated | Date Updated | date |
body_html | long_description | string | |
id | shopify_product_id unique id | Shopify Product ID | string |
set(hash(urlmain(url))) | hashedurl unique id | []string | |
set(tags) | shopify_product_tags | []string | |
set(tags) | tags | []string | |
source | source | string | |
title | description | string | |
title | shopify_product_title | string | |
url(image.src) | primary_image | string | |
url(url) | url | string |
Configuration
Follow these steps to set up and configure an import job for Shopify in the Lytics platform. If you are new to creating jobs in Lytics, see the Data Sources documentation for more information.
- Select Shopify from the list of providers.
- Select the Import Products 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.
- In the Start Date input, enter a date in format
yyyy-mm-dd
to begin importing from. - In the End Date input, enter a date in format
yyyy-mm-dd
to import until. - Check the Keep Updated checkbox to import products daily.
- Click Start Export.
Updated about 1 year ago