LOOKING FOR PARTNERS 🤝

We're currently looking for partners and distributors in different regions. If you're interested, please feel free to contact us.

Exchange On-Premises Contacts syncs with Shopify Customers

Sync Exchange On-Premises and Shopify Contacts

Learn how to sync your Exchange On-Premises and Shopify contacts using the SyncPenguin platform

Supports company-wide rollout

Free 14-day trial with full support, no credit card required

Many businesses sell through Shopify but still run Microsoft Exchange Server on their own premises for email and contacts. Customer details stay inside the Shopify admin, so support, sales and office staff working in Outlook can't see who is calling or emailing. Contacts collected in Exchange mailboxes, such as wholesale buyers and trade partners, also have to be entered into Shopify by hand. Exporting CSVs and re-importing them is slow and creates duplicates, and the copies go out of date as soon as a customer changes an address or phone number.

How SyncPenguin helps

The Exchange On-Premises Contacts and Shopify Customers connection keeps your store's customer list and your Exchange Server contacts automatically in sync, one-way or two-way. You can send Shopify customers to a personal, shared or public Exchange contact folder, so everyone using Outlook and their phones sees up-to-date names, emails, phone numbers, addresses and notes. You can also create Shopify customers from Exchange contacts in a chosen folder or category. No-code filters, field mapping and custom rules let you decide which customers sync and how tags, categories, phone formats and metafields are transferred. Nothing needs to be installed on your server.

Best suited for: E-commerce store owners using Exchange Server. Customer support and office teams. IT administrators managing on-premises Exchange. Wholesale and B2B sales reps.

Real-world use cases

  • Sync all Shopify customers one-way into an Exchange public folder, so support and office staff can look up shopper emails, phones and shipping addresses directly in Outlook.
  • Sync only Shopify customers tagged "Wholesale" or "VIP" to a sales rep's Exchange contact folder, and add a matching Exchange category automatically with a custom rule.
  • Create Shopify customers from Exchange contacts in the "Trade Accounts" category. Custom rules add the "B2B" tag and reformat phone numbers with the country code, so new accounts are ready to order.
  • Keep a shared Exchange customer folder and Shopify in two-way sync, so address or phone updates entered by staff in Outlook also reach the Shopify customer record.
  • Copy Shopify customer metafields, such as loyalty tier or account number, into the Exchange contact Notes field with a custom rule, so this information is visible in Outlook.
  • During a hybrid Exchange deployment, sync Shopify customers to both the on-premises Exchange public folder and staff's Microsoft 365 mailboxes, so all employees see the same customer list.
  • Keep Shopify customers in two-way sync with HubSpot for marketing, and send HubSpot contacts to an Exchange contact folder so the in-house team has the same customer details in Outlook.
  • Sync Shopify customers to QuickBooks for invoicing and to a shared Exchange folder for the accounting team, so billing contacts stay consistent everywhere.
  • Sync Shopify customers to Exchange and from Exchange to Google Contacts, so staff using Android phones also recognize customer calls.

Key features

Two-Way Sync

New and updated customers flow between Shopify and Exchange in one or both directions. Changes made in either place stay aligned without duplicates.

Shared & Public Folders

Send Shopify customers to an Exchange public folder or shared mailbox, so the whole team sees shopper details in Outlook.

Tags & Categories

Filter by Shopify tags or Exchange categories, and convert one into the other with custom rules to route the right customer groups.

Caller Recognition

Synced customer phone numbers appear in Outlook and on staff smartphones, so you recognize customers when they call.

No-Code Customization

Adjust field mapping, reformat phone numbers, and copy metafields into Exchange notes or other fields without writing code.

Affordable & Scalable

With SyncPenguin you only pay for changes to your data, regardless of how many contacts you have now or will have in the future.

Things to note

  • Shopify only gives access to customer data on the Grow, Advanced and Plus plans, so stores on the Basic plan need to upgrade before syncing.
  • Shopify stores one email and one phone number per customer. When syncing from Exchange, SyncPenguin uses the work email or phone, or otherwise the first one available.
  • Shopify requires unique customer emails and phone numbers. Exchange contacts that would duplicate an existing customer are reported so you can review them.
  • Exchange provides home, work and other address fields, so up to three Shopify addresses can be synced to each Exchange contact.
  • Shopify may reject phone numbers it can't recognize as valid. Custom rules can reformat numbers, for example by adding a country code, before they are sent.
  • Your Exchange Web Services (EWS) endpoint must be reachable from the internet so SyncPenguin can connect to your server.
  • Outlook user-defined custom fields and Exchange contact groups aren't synced. Extra details can be combined into fields like Notes using custom rules.

How to configure the sync?


This guide explains in detail how to create, configure, and start the sync.

If you'd like to start syncing right away, feel free to create an account and set up the sync on your own. Come back to this guide if anything is unclear. You can also contact us with any questions, requests, or feedback.

Step 1. Create a SyncPenguin account

The first step is to create a SyncPenguin account. We offer a free 14-day trial (no credit card required), so you can make sure everything works well before you commit. Follow the link below to create an account.

14-day free trial • no credit card required • quick setup

Step 2. Create the sync

Next, create a sync in the Synchronizations section of the dashboard by clicking the + New sync button. You'll see a wizard page where you need to do the following:

  • Choose Exchange On-Premises Contacts for the first app.
  • Then choose Shopify Customers for the second app.
  • Then select the sync direction.
  • Then click the Create button.

Step 3. Provide access to Exchange On-Premises and Shopify

Now that your sync is created, the next important step is to grant SyncPenguin access to your contact data. You'll see an Account section for each app involved in the sync. Below we explain how to connect and configure each account.

How to connect Exchange On-Premises?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Exchange On-Premises Contacts account connection section will look like this:

Account for Exchange On-Premises Contacts (Example)
Exchange On-Premises Contacts

How to connect Shopify?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Shopify Customers account connection section will look like this:

Account for Shopify Customers (Example)
Shopify Customers

Please make sure both apps are properly connected before starting the contact sync.

DATA SECURITY

If you're concerned about the security of your data, please check out our Security Practices page.

Step 4. Sync settings

In the Sync settings section, you can adjust some of the default settings of your sync:

  • The name of your sync.
  • Sync direction (two-way or one-way).
  • Sync interval (by default, the sync runs every 10 minutes).

Please note that this connection uses webhooks, so syncing will be near real-time in most cases. The syncing interval is used as a fallback in case a webhook was not fired.

Additionally, in Field mappings & rules you can customize how contact data is mapped between the apps, or add filters and custom rules to the sync. This is done using our simple no-code visual interface, which lets you make simple adjustments as well as implement complex custom scenarios.

Supported Exchange On-Premises fields: First name Last name Middle name Display name Title Suffix Company Job title Department Emails Phones Addresses Birthday Website Business website Notes Categories Photo Spouse/partner File as File as format Created date
Supported Shopify fields: First name Last name Note Email Phone Addresses Tags Email marketing status SMS marketing status Custom single-line text fields Custom multi-line text fields Custom URL fields Custom number fields (integer and decimal) Custom true/false fields Custom date fields Custom date and time fields Custom lists of text Custom lists of URLs Custom lists of numbers Custom lists of dates and date-times

Virtually any syncing behavior based on supported fields is possible using the customizations interface.

Learn more about our customization interface.

Sync settings

Step 5. Start the sync

The last step is to start the sync. To do that, click the Start syncing button.

You'll then be offered the following options:

  1. Only sync new data, meaning anything added or updated from now on.
  2. Merge all historic data two-way: take all Exchange On-Premises Contacts and Shopify Customers and merge them together. Any data that already exists in both apps is merged instead of being duplicated.
  3. Merge Exchange On-Premises Contacts into Shopify Customers: take all Exchange On-Premises Contacts and add/merge them into Shopify Customers.
  4. Merge Shopify Customers into Exchange On-Premises Contacts: similar to the previous option but in the opposite direction.
Start sync
We'll be checking every 10 minutes for changes in your data.
What should we do initially with already existing contacts?

Once you've made your choice, click Start syncing. If you choose an initial merge, it'll be queued immediately. Once it's done, we'll check for contact changes at the sync interval you've set and sync them accordingly. Each sync run is shown in the Sync history at the bottom of the sync page.

Learn more

Frequently Asked Questions

Can I sync Shopify customers to Outlook through my on-premises Exchange Server?

Can I create Shopify customers from my Exchange contacts?

Can I sync only some Shopify customers to Exchange?

Do I need to install anything on my Exchange server?

What do I need to connect my Shopify store?

Will syncing create duplicate customers or contacts?

Which Exchange Server versions are supported?