Splio Shopify Connector

📘

Provided by: Splio
Connector type: Source
Third-party system: E-commerce
Required license: "Marketing Automation", "Marketing Automation + CDP" or "Predictive AI (previously TinyClues)"

Overview

Our Shopify App will let you easily sync all data from your Shopify Store (customers, products, locations, orders, refunds and abandoned checkouts) to Splio. For Rewards synchronization with Shopify, please check the Splio Shopify Rewards Apps guide.

Having your Shopify data synchronized into Splio CDP, Marketing Automation and Loyalty opens many possibilities:


Supported features

  • Sync customer, orders, refunds, locations, product catalog, abandoned checkouts
  • Backfill of historical data of your Shopify Store
  • Collect Shopify email and SMS consent
  • Marketing and transactional emails journeys
  • Powerful data transformation
  • Track onsite behavior and anonymous users via the Splio Web tracking
  • Loyalty Web Kit to display your loyalty program with a plug&play SDK (if you have the Loyalty add-on)
  • Checkout Extension for Rewards (if you have the Loyalty add-on)
  • Integration with Shopify PoS

Prerequisites

Before starting the setup of the Splio Shopify App, you will need to:

Pre-requisiteDescription
Access to Splio tenant- You need to have access to your Splio tenant (universe/domain) which will be shared to you by your Splio contact. - You should have an admin or data administrator role on your CDP tenant. This will allow you to set the app through the Connection Hub interface.
Shopify Store- Have an active Shopify store.
- By default you can connect one Shopify store per tenant. If you are interested in connecting multiple stores to one tenant, read this article and feel free to reach out to your Splio contact.
Shopify User permissions- Use a Shopify user with the right roles and permissions:
- Store owners
- Organization owners
- Or any user with the "Manage and install apps and channels" permission

How it works?

Splio connector is working in incremental sync patterns. For any data scopes, new changes are made to your store (creation or updates) changes will be synced within the next minutes. Note that in some cases, it can take up to 15 minutes to see the changes in Splio Customer Platform.

🚧

If you make a major change on your Shopify store by backfilling specific data, please contact us before proceeding. Major updates during run might take longer than an initialisation and can slow down the overall process.

📘

Splio does not support two ways sync for now. If you need to sync marketing consent data or other useful data you need to implement it on your side.

Data Synchronization scopes overview

The Splio Shopify App will synchronize the data from one or several Shopify Stores to Splio CDP and Marketing Automation. If you have several Shopify stores or several data sources, you will probably need Splio CDP (check with your Splio contact to get recommendations based on your specific context).

1.1 Shopify Customers into Splio Contacts

It is essential to keep in mind that based on the value in Shopify of email_marketing_consent and sms_marketing_consent, each Shopify Customer will be subscribed to a dedicated list in Splio. As Splio is considered the primary "source of truth" for list subscriptions and blacklists, Splio's lists subscriptions will only be updated in case of a newer value in Shopify based on the consent_updated_at.

Whenever a customer is deleted in Shopify, it will trigger the contact deletion from Splio.

1.2 Shopify Product Variants into Splio Products

If you are not using Splio CDP, Shopify Product Variant ID is the Splio Product external_id.

Whenever a variant or a product is deleted in Shopify, it will be deleted from Splio in the next data synchronization. To keep your data consistent, we advise you to never delete a variant or a product that has been sold. Instead, you can archive the product to avoid any product deletion in Splio. This way, you can still target contacts based on their purchase of those products in the future.

1.3 Shopify Locations into Splio Stores

If you are using Shopify PoS, the Shopify Locations where customers may order are synched into Splio Stores.

1.4 Shopify Abandoned checkouts, orders and refunds into Splio Orders

Only Abandoned checkouts and Orders that have a Customer are synched into Splio Orders / Purchases.

  • When a checkout is created in Shopify it creates a Splio order with completed as false. This will let you build your abandoned cart campaign.
  • When an order is created in Shopify, it creates an order with completed as true. For now, if an order is updated in Shopify (fulfilled, canceled, refunded...), it will not be updated in Splio.
  • In the context of Shopify Markets, you may have two currencies for each order and you can use them both to personalize your email designs:
    • Shopify shop_money is used in Splio orders total price: this is your store currency
    • Shopify presentment money is used in Splio in custom fields (shp_presentment_money*) to display the amount in the currency your customers have used when ordering.

🚧

Shopify POS only supports a unique currency which is the shop_currency. It does not display the presentment_currency, and therefore oblige to use one unique currency for the Shopify Shop.

📘

Please note that as Shopify send abandoned checkouts as only customers leaving the checkout page (not triggered by the end user), if you have the Marketing Automation + CDP license, you can use our web tracker to sync add_to_cart events.

1.4 Unsubs

If you need to integrate the subscription and unsubs data to your Shopify Store, the integration should be done on your side based on files exports from Splio.