Splio Shopify App

📘

Provided by: Splio
Connector type: Source
Third-party system: E-commerce
Available for Splio
• License: Marketing Automation, Marketing Automation + CDP
• Add-ons: Loyalty, Mobile Wallets, Predictive AI, Identity Resolution

Overview

Our Shopify App will let you easily sync all data from your Shopify Store (customers, products, locations, orders, 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:

Prerequisites

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

  • have access to your Splio tenant (universe/domain) which will be shared to you by your Splio contact
  • 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

📘

As Shopify metafields can not have a date type, you should make sure to store dates in ISO 8601 format to be able to use date operators in your Target filters.

🚧

To avoid any desynchronization between Shopify and Splio, make sure to never update Splio data synchronized from Shopify. And never delete Shopify data that is needed in Splio. The setup process will create a field for each Shopify data field that is not synched to a system field. Those custom fields are prefixed with shp_. Never delete or rename such a custom field to avoid breaking the data synchronization process.

Connect your Shopify app from the store

Connect your Shopify store to Splio directly through the connection hub. You will be redirected to the Shopify App Store where you will provide all the authorizations to the Splio Shopify App. Once the connection setup, the first data synchronisation with data init will be launched automatically. Be aware that depending of the size of your data history, this may take a wile.

Data Synchronization scope

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).

Shopify Customers into Splio Contacts

If you are not using Splio CDP, Shopify Customer ID is the key for Splio Contacts (shp_id).

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.

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.

Shopify Locations into Splio Stores

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

Shopify Abandoned checkouts and Orders 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.

📘

If needed, you can request access to a detailed mapping of Shopify fields with Splio through the Contact Us form or your Splio Contact.