This is driving me nuts for weeks. I need some help with make.com and Shopify and Airtable

Shopify Discussion
1

Hey everybody,

I’ve recorded a video as it’s easier to explain what I like to achieve.

https://app.screencast.com/kocOzlTSoQ5zH

Our Shopify website gives our clients the option to leave their email addresses behind when a product isn’t in stock. We used the integration with Klaviyo in the past, but that was too expensive and did not exactly do what we needed to achieve in a later phase with the data.

We store via a webhook the data of the client in an airtable so we can check if the person is a client or not etc, etc. I have read on the forum that when you create a new product and assign a productID to it, this is different from the ProductID on the front end of the website.

In my airtable, I capture the URL the client is visiting, and all this information is kept in one overview.
I like to create an mechanism, where I can fetch the variant of the product in such way, I can inform the client, when it’s ready again.

I’ve tested all the templates, and even run a python script to extract all the information, but it seems that the Cloudflare CDN is blocking to search the information via Make.com or Zapier.

Your help is more than welcome, as it’s driving me nuts.

2

Hi @SuperBra

First for this you just need custom code which will give you option to fill form when product is out of stock.

Now your issue if the form is Shopify contact form or klaviyo allow to add fields.

Then I can modify the code a bit where you will get the selected variant id.

Let me know your thoughts…

3

Thanks to Mohammed of https://www.debesis.nl, we cracked this solution. And, as always, the solution is hidden in front of you. :S

The issue that this flow needed to be fixed is that when fetching information via Make to shopify and Airtable, Make is missing an ID of the record. By adding this once manually, you can “learn” to use the value, which results in the next step of the flow.

4

How do you solve id of the record?

5

just in case it helps, we plugged our shop to airtable using Syncbase, so you don’t need to build any make triggers or record id retrieval hacks. all our orders, customers etc are in sync on both platform now