This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
Hey there Zapier comunity! I have been working on this one with a few developers but are yet to find the solution that works and it is a bit tricky but I am confident that someone in here will be amazing and have a work around!
We are about to sell close to two thousand diaries between now and December, we offer our customers to add personalisation where the can have their name embossed on the cover.
Historically I manually entered these into Monday.com and that way I could filter the data and do all of the green diaries first for example, and then mark it as done when the order has been customised then pass that onto the despatch team.
This year I want to have an automation take care of the data entry from shopify into Monday.com as that would save me a lot of time! I have been working with a Zapier expert and another developer but neither of them have been able to have the automation enter the data into Monday.com how I need it to be done.
The main issue I’m running into is that if a customer orders more than one customised diary, Zapier can’t take that shopify data and put it onto two line items in Monday, as the integration on the Monday side doesn’t allow it. We have tried other way with Zapier Looping but it still doesn’t work.
I’m at a loss here and really want this automation to work. Can I have one of your delevlopers take a look into it and possibly work on a solution? Thanks so much!
Columns I need:
1) Order number, 2) Diary chosen line item name, 3) Monograming foil colour, 4) Monogramming text.
Rows, would be additional if they have ordered multiple diaries in the one order.
Below is screen shot of the data Zapier is reading for shopify. Just when you select the data from the drop down options, it combines all of the customisation into one line and it needs to be all sperate.
I have also attached a screenshot of how the properties look when selecting in Zapier, you can see it groups the customisation options together.
The third screenshot is a image of how I want the data to read into monday.
It’s almost like we need to do a excel style formatter code base of if statements, but that is well beyond my abilities and I haven’t had the success i was looking for with hiring two Zapier experts.
Best answer by christina.dView original