Help with Shopify automation updating metafields

Hello everyone,

I have a problem with 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 help adding 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.
I need this done ASAP please.
Thanks a lot for you help

blueprint (5).json (33.8 KB)
1-Shopify_Product_Metafield FINAL.csv (14.6 KB)

Hi @David_Gutierrez,

I’ve been working a lot with e-commerce brands selling on Shopify and have a good understanding of the Shopify GraphQL API. Happy to jump on a call and check your scenario.

Feel free to schedule a call here: moonira.com or shoot me an email: julius@moonira.com

Best,
Julius

Hi @Juliusforster,

Thanks for your quick answer. As mentioned, I’d need help on the attached scenario on two things.
The first one is to check the function to check the changes of the new CSV vs. the current data base and see if it works properly creating the array with just the new updates.
And the second thing I need is creating (if possible) a wait-and-retry-again module for updating the metafields on those SKUs created in Shopify after the CSV has been sent.
I am attaching my current scenario and an example of the CSV’s sent to it.
Please let me know if you can check everything with this info or you still need to jump on a call and how much would you charge for the job.
Thanks !
1-Shopify_Product_Metafield FINAL.csv (14.6 KB)

Hello @David_Gutierrez , welcome to the make.com community, we are a group of freelancers and would love to work with you on this, you can book a call Here to disscuss the project requirements and you can checkout my upwork profile Here

Hi David,

I am an experienced workflow automation specialist with extensive experience building e-commerce scenarios similar to yours. It would be helpful if you could include your contact email address for communication. Here’s a link to our automation specific webpage - Increase Productivity with Workflow Automation by Siliceous Solutions.

Regards,
Pam.