Skip to main content

Sync your data from Shopify

Written by Anand
Updated over a week ago

This article will help you understand the data synchronization process that happens to import all of your customer, products and historical order data into our platform. The data synchronization helps you reach customers with personalised messaging, create complex automated workflows and much more !

To ensure a seamless data synchronization process, ensure that Shopify serves as the source of truth. This allows data to properly sync and keeps both platforms updated accurately.

Kickstarting data synchronization is step 1 of the email onboarding while setting up PushOwl Email (powered by Brevo). You can start it by visiting Email on the left navigation of PushOwl dashboard and clicking on the Import data from Shopify button. Post this, pushowl immediately begins to sync all of your data to the Brevo platform. The initial synchronization may take up to a few hours and the full sync depends upon the amount of data you have in shopify. Nevertheless, We recommend to wait for atleast 24 hours.

Ensure that you have configured Shopify as the source of truth to avoid any discrepancies in the imported data.

You can check the status of the sync from the PushOwl dashboard. A status bar on top will keep communicating the status to you.

If you encounter any disruptions, review detailed logs available in the dashboard to diagnose issues. Common steps include verifying Shopify's configuration as the source of truth and addressing incomplete syncs.

PushOwl syncs data of the following entities from your store

  1. Customer

  2. Products

  3. Collections

  4. All Orders

Post the sync, PushOwl also subscribes to shopify's webhooks which keep our platform data updated in real time with your data on shopify.

Onsite Tracking

In addition to your data on shopify, pushowl also enables an onsite tracker on your store to track your store visitor actions. The following actions are tracked

  1. Page Visits

  2. Product View

  3. Cart Interaction events

    1. cart added

    2. cart updated

    3. cart deleted

  4. Order Completed

You can create complex automation workflows using the onsite events tracking.

For example, synced attributes like "Language" can be used to create workflows that send personalized emails to customers based on their preferred language or segment customers into specific lists for targeted campaigns.

Troubleshooting Sync Issues

Troubleshooting may involve:

  • Verifying that Shopify is still configured as the source of truth.

  • Examining dashboard logs to identify errors or incomplete data syncs.

  • Contacting PushOwl support if issues persist for resolution assistance.

What data attributes get synced ?

This section details the data attributes that get synced from shopify to the Brevo platform.

Additionally, you can create custom attributes in Shopify, such as "Language," which can be synced to Brevo. These attributes enable advanced segmentation and automation workflows, enhancing your marketing capabilities.

Customer

Apart from the data attributes listed below, customer's email and sms subscription statuses are also synced. You will only be able to send emails to customers for whom email marketing is marked enabled on shopify.

Custom attributes, such as "Language," can also be created in Shopify and synced to Brevo. These attributes are applicable to all Shopify contacts, ensuring consistent data availability for automation and filtering.

Email subscription status sync to-and-fro between brevo and shopify. If a customer unsubscribes from an email campaign, they will be unsubscribed from email marketing on shopify as well.

Please note that Contacts created on brevo are not synced back to shopify as customers.

Shopify Customer

Brevo Contact

First Name

First Name

Last Name

Last Name

Email

Email

Phone

SMS

ID (Shopify ID)

Customer ID

Currency

Currency

Verified Email

Verified Email

Tags

Tags

State

State

Country

Country

Province

Province

Country Code

Country Code

City

City

Zip

Zip

Created At

Shopify Creation Date

Products

The data attributes synced for products and variants remains mostly the same. To maintain the product -> variant hierarchy, the main product id is synced as parent_id in the brevo platform. For most cases, you should not need to worry about this.

Shopify Product

Brevo Product

Id

Id

Name

title

Image Url

imageUrl

sku

sku

Price

Price

Collections

Products are automatically added to categories during the sync process.

Shopify Collection

Brevo Category

Id

Id

Name

Title

Orders

Shopify Order

Brevo Order

Id

Id

Financial Status

Status

Total Price Set

Amount

Customer Email

Email

Discount Code

Coupons

Line Items

Products

Billing Address

Billing Address

City

City

Country Code V2

Country code

Zip

Post Code

Province

Region

Payment Gateway Names

Payment Method (1st payment gateway from the list)

Custom Attribute Syncing and Automation Use Cases

Integrating Shopify with Brevo allows you to sync custom attributes, such as "Language," enabling efficient list automation and filtering. Follow these steps to create and sync attributes:

  1. Create the Attribute in Shopify: Start by creating the desired attribute (e.g., "Language") in your Shopify account. Ensure the attribute is correctly configured for the data you want to collect.

  2. Sync the Attribute to Brevo: Once the attribute is created in Shopify, it will automatically sync to Brevo if the integration is properly set up. Verify that the attribute appears in Brevo.

  3. Use the Attribute in Brevo: After syncing, you can use the attribute in Brevo to create automated workflows, segment lists, and apply filters for targeted communication.

Use Cases for Automation and Filtering

  • List Membership: Use synced attributes to automatically add contacts to specific lists based on their attributes.

  • Segmentation: Filter contacts in Brevo using Shopify attributes to create targeted campaigns.

  • Personalization: Leverage attributes like "Language" to personalize communication and improve engagement.

Did this answer your question?