Retry scenario to updated metafields when SKU in Shopify doesn't exist yet

How To
1

Hello everyone,

I am new to Make and pretty happy to join this community.
I have a question about a scenario I am building. I am connecting Make to Shopify and every once in a while, I send a CSV which checks the differences with a data structure I have and updates 3 metafields in Shopify. The problem is that sometimes the SKU doesn’t exist in Shopify yet as the SKU creation is done through a different automation system outside of Make. So the CSV with the non-existing SKU would arrive up to 30 minutes earlier than the actual SKU is created in Shopify and the scenario would run but the meta fields in Shopify won’t be updated. So I need to add an option to my scenario where it runs only if the SKU exists (which is already done). Still, at the same time, I would need some wait-and-retry-again module that triggers as soon as the SKU is created in Shopify and adds the metafields to it.
I am attaching an example of the CSV I am sending via a mail webhook and the scenario I’ve created so far.

image
image1769×494 44.8 KB

Thanks a lot in advanced for your help.

blueprint (5).json (33.8 KB)

1-Shopify_Product_Metafield FINAL.csv (14.6 KB)

2

Usually you can use an error handler route and add the Sleep Module + the Retry error handler. However this would pause the whole processing of the other csv lines, so probably not good here.

I believe the only way to tackle this is to set up a webhook or Watch product Updates module to trigger the processing whenever the SKU is added.

1 Like
3

Thanks for your answer!

1 Like