How can I sync customer databases between Airtable and Shopify

How To
,
1

Hi, I work with a non-profit that uses Shopify for their website, donations, and email newsletters. We also have a separate database of potential partners, non-shopify donors, event attendees, volunteers etc, which we use Airtable for. This airtable is populated manually by staff. I would like to sync the information between our Shopify and Airtable, i.e:

  • when a new customer is created on Shopify (either by them donating or subscribing to our newsletter), it creates a new customer record on Airtable.
  • when a new ‘customer’ record is created on Airtable by any of our staff, it creates a new customer on Shopify
  • when an existing customer info is updated on Shopify, it updates the existing customer record on Airtable
  • when an existing Airtable customer record’s info is updated, it updates the same customer’s info on Shopify
  • it shouldn’t be a never ending loop, of course

How do I set this up?

2 Likes
2

Hello @Munira_H,
My answer is not related to an exact instant solution but it’s related to different ways to achieve this.

Don’t get me wrong but if you’re not a regular Make user then I suggest you hire some Make professional who also knows how to use Airtable as well as Shopify API.

This is not a simple thing that you can just do alongside learning.

This needs to set up multiple scenarios on Make which is triggered based on multiple actions. Also, need to set up multiple webhooks on Shopify and Airtable. Which is triggered when some predefined actions are fired from any of the platforms.

The important thing is you need to set up things 2 Way Sync(Both sides).
Which needs to read all the specific events(actions) from both sides.

In conclusion, there are 3 things we need to do if you’re doing these things using Make.

  1. Set up a Database structure and Actions that match both sides. (Basic Step)
  2. Understand the API nature and set up Webhooks on both platforms. (Intermediate Step because it’s working alongside with Step 3)
  3. Set up all operations on Make. (Advanced and Final Step)

Extra resource
If you know how to use shopify Apps then also check if some of the Airtable related apps are enough for you. In that case, there is no need to use Make. But make sure you can afford to pay for those apps and it also gives all the things that you asked for. Otherwise, go with that custom approach.

I hope it helps. :+1: