Shopify Multiple Orders to Google Sheet Problem
Status: Closed · Asked by ARABIA LUXURY on · 0 views
Dear Pabbly Support,
I'm facing a problem here about syncing orders from my shopify store to google sheet, I set up everything
https://prnt.sc/swQyfXn1zXjG
Everything good for google sheet the data added perfect but when i got two orders or three with same customer it's not creating new rows, so my team have to check the shopify url and we wast time on it.
img1 : https://prnt.sc/CDBmY15X_5SF
img2: https://prnt.sc/x3HCL9sR-4mc
we're using cash on delivery method on our store so we need this option everything need to fetch on google sheet row by row (one order by one row not one row for one customer)
I talk to some developers and they told me i have to ask on this forum
my pabbly subscripction is $19.
THANK YOU
I hope you guys can help me with this problem as soon as possible
Hey @botsloh
Regarding your concern, you can use the Iterator action step which will process all the data to your Google Sheets one by one.
Please check out the following video tutorial for your better understanding on Iterator action step -
hey, nothing can be selected here https://prnt.sc/Q-yn3b3Na1-Q
and i'm using shopify not wocommerce
thank you
Hey @botsloh
Yes, you need to capture the webhook response in advance response by toggling the Simple Response button and then re-capture the webhook response so in that way, you will get the data in JSON format then you can pass that JSON data in the Iterator action step which will further pass all your product/order on by one to your Google Sheets.
Kindly try the Iterator action step in your workflow with the help of the above-mentioned video and try again.
like this but still nothing to select
Hey @botsloh
It seems like you still haven't captured the webhook response in advance response by toggling the Simple Response button.
Please check out the following video tutorial once on how you can capture the webhook response in Advance Response to feed further in the Iterator action step.
it worked buy turning off "simple response"
Thank you so much