Please answear my comment!! :) Thank you so much, Simon! What if I want 1 row per item to be exported to my google sheet? Is it possible? So we'd have several rows with the same order id
Thanks so much for the video. For us newbies there were parts that you went through super fast. If you could do a video on just adding line items with the Json. Along with why would you move the clock? That would be so helpful. I do appreciate the video😊
Great video Simon, it has been really helpful!!! Is there any way to check orders, so that if an order is cancelled it is updated on the google sheets? It would be really helpful to do that!! Thanks in advanced and best wishes to your channel
Yeah what you would want to do is set the 1st module in the scenario to be “order updated” as a webhook. Then whenever the order updates the scenario runs and then you can update the row in google sheets to cancelled
I appreciate the video and it is working but I'm unclear on the limit section. Why would you make the limit 1 or 2 or 25 and not just the highest possible number. There must be a reason but I don't understand why?
Finally an elaborative video for this API platform. Thank you. Eased up lot of confusions for me. One question though. why did you choose integromat. have you tried pabbly? or just went with gut feel. Thank you again from Pakistan.
Thanks for watching! I went with Integromat cause I have used in the past and more advanced than Zapier. I have not tried Pabbly. Do you work with Pabbly? Cheers :)
@@simongondeck no I dont. Pabbly has more tutorial videos for such APIs. Hence more dominance on RUclips. Thats why I was bit inclined towards it. Last night I compared zapier, pabbly and integromat. Integromat certainly has the lead for simplicity and pricing. Pabbly has more interfacing paltforms but bit complex.
@@simongondeck But pabbly has 100 items for free then you have to go for the paid version. Simon's main solution was FREE and i think for that this is the best.
Thanks for the big value provided , i have 2 questions : 1- google sheets isn't triggered , I have already old orders on woocommerce, and i did try to make a new order but its still not triggered 2- how could we change the order status on woocommerce based on order status column on google sheets
Hello Simon from Spain, I would have a question: To extract data to sheets of an order but also has a pluging in which the customer exposes the time slot and calendar, what could be done? From Make right now I do not get the possibility. Thank you!
Tengo el mismo inconveniente y no encuentro solución, cómo tomar datos de fecha de reserva que me lo da un plugin? Si pudiste solucionarlo me echas una mano por favor
Hey, Man! Thanks for this. I know this is a year old, and curious if you have a solution for Triggers > Watch Subscriptions (it doesn't exist any more! :( Thoughts? I am looking to update the Parent Order Meta Data...Thanks for this tutorial!
For those looking...Use the New Event trigger for WC, get the webhook URL, and configure it in WC > Settings > Webhooks > Topic: Subscription Created DOPE!
@@bestslopedesigns9429 Glad that was helpful! I also exported the scenario I used originally as a "blueprint". You then can upload this "blueprint" after creating a new scenario in Make as this is a legacy module. Check it out here: simongondeck.com/wp-content/uploads/2023/01/blueprint-export-woocommerce-subscriptions-google-sheets.json
@@simongondeck Is there any tutorial about this? I'm looking for the Watch Subscriptions functionality as well... but do not understand what to do exactly in this case.
Thank you for the video, but I've got the same problem as "studemme", "if there are more product in an order, how could i add all the products and not only the first?" thank you
Thank you so much, Simon! What if I want 1 row per item to be exported to my google sheet? Is it possible? So we'd have several rows with the same order id
Yes for sure thanks for watching! In regards if you want 1 row per item to be exported to your google sheet, this is possible. Setup your scenario in Integromat with 3 modules: WooCommerce, Iterator, and Google Sheets. In the Iterator module add "Line items []". Then, when mapping to your Google Sheet add data from WooCommerce Order and also results from the Iterator module to be added to the row. Does this make sense?
@@simongondeck I'll try this on Monday! Thank you so much! Merry Christmas, Simon! May God bless you and your family! P.S I am doubtful if I'll make it work without step by step since I am new to integromat.
@@Refri1394 Merry Christmas to you and your family too! I just created a new video about how to do this 1 row per item. Check it out here: ruclips.net/video/X8hz_Sg2304/видео.html. If you have not created a Integromat account it would be appreciated if you use my link at simongondeck.com/integromat. Let me know if you have any questions. Cheers!
Hi ! I have the same problem than Shams. It doesn't work, it's not triggering in the sheets. I just get the number one upon the woo icon and not on the sheets module. Can you help me please ?
Do you have any orders on WooCommerce? Or did all your orders already run? Click the 'back' button on the scenario and click the 'history' tab. Do you see anything that ran?
@@simongondeck When I try today, it worked only for the new order, that I had 2 hours ago. I think that it doesn't work for the past orders only. Do you know how to run the past orders too ? Thank you Simon.
@@abc-transition-bas-carbone follow the logic at the 11:25 and 11:50 mark of the video to 14:00 above where you delete the WooCommerce module and then re-add it and then choose all orders (to get past orders too)
Do you have any orders on WooCommerce? Or did all your orders already run? Click the 'back' button on the scenario and click the 'history' tab. Do you see anything that ran?
👉 Check it out: simongondeck.com/integromat/
Please answear my comment!! :)
Thank you so much, Simon! What if I want 1 row per item to be exported to my google sheet? Is it possible? So we'd have several rows with the same order id
@@Refri1394 sure thing! Check out this video: ruclips.net/video/X8hz_Sg2304/видео.htmlsi=pvN6UCEcAN1epBP7
Thanks so much for the video. For us newbies there were parts that you went through super fast.
If you could do a video on just adding line items with the Json. Along with why would you move the clock? That would be so helpful. I do appreciate the video😊
@@user-si8pi3nk3w will try to create new video!
Do you work personally? I have to get some data off my site and lm not having any luck😢@@simongondeck
This worked beautifully! Thanks Jason Bourne!
thank you Justin!
It was very helpful, will try it
Thank you 😊
Great video Simon, it has been really helpful!!! Is there any way to check orders, so that if an order is cancelled it is updated on the google sheets? It would be really helpful to do that!! Thanks in advanced and best wishes to your channel
Yeah what you would want to do is set the 1st module in the scenario to be “order updated” as a webhook. Then whenever the order updates the scenario runs and then you can update the row in google sheets to cancelled
I appreciate the video and it is working but I'm unclear on the limit section. Why would you make the limit 1 or 2 or 25 and not just the highest possible number. There must be a reason but I don't understand why?
I was more so limiting it for the video to show how to map each item in the spreadsheet. Hope that helps!
very nice explanation, and really useful, thank you
Thank you for watching
Finally an elaborative video for this API platform. Thank you. Eased up lot of confusions for me.
One question though. why did you choose integromat. have you tried pabbly? or just went with gut feel.
Thank you again from Pakistan.
Thanks for watching! I went with Integromat cause I have used in the past and more advanced than Zapier. I have not tried Pabbly. Do you work with Pabbly? Cheers :)
@@simongondeck no I dont. Pabbly has more tutorial videos for such APIs. Hence more dominance on RUclips. Thats why I was bit inclined towards it. Last night I compared zapier, pabbly and integromat. Integromat certainly has the lead for simplicity and pricing. Pabbly has more interfacing paltforms but bit complex.
@@bladycivilian got it and good to know! I definitely will check out Pabbly!
@@simongondeck But pabbly has 100 items for free then you have to go for the paid version. Simon's main solution was FREE and i think for that this is the best.
Hi Simon, is it possible to export products with variants?
Is it possible to update changes to existing ones instead of adding rows to the sheet?
Thanks for the big value provided , i have 2 questions :
1- google sheets isn't triggered , I have already old orders on woocommerce, and i did try to make a new order but its still not triggered
2- how could we change the order status on woocommerce based on order status column on google sheets
Awesome! Can you do a video on updating orders and especially on splitting up the line item array to different rows?
Here is video of 1 item per order line: ruclips.net/video/X8hz_Sg2304/видео.html
Hi instead of running the orders from the beginning for export to excel can we schedule to start processing from orders from particular date thanks
Yes you can do this inside of Make
There's no option fir woocommerce subscription
Can this be updated daily automatically? Is there a trigger for that?
Yes you can have the trigger run daily at 8AM by clicking on the "clock" once you make your scenario.
Great video! How can we setup for custom order status?
Just set the first module to “order updated” and then whenever the order is updated you can filter out to specific status
Hello Simon from Spain, I would have a question: To extract data to sheets of an order but also has a pluging in which the customer exposes the time slot and calendar, what could be done? From Make right now I do not get the possibility. Thank you!
Tengo el mismo inconveniente y no encuentro solución, cómo tomar datos de fecha de reserva que me lo da un plugin? Si pudiste solucionarlo me echas una mano por favor
is there any way to manage inventory and purchases through this?
yes that is possible!
Hey, Man! Thanks for this. I know this is a year old, and curious if you have a solution for Triggers > Watch Subscriptions (it doesn't exist any more! :( Thoughts? I am looking to update the Parent Order Meta Data...Thanks for this tutorial!
For those looking...Use the New Event trigger for WC, get the webhook URL, and configure it in WC > Settings > Webhooks > Topic: Subscription Created DOPE!
@@bestslopedesigns9429 Glad that was helpful! I also exported the scenario I used originally as a "blueprint". You then can upload this "blueprint" after creating a new scenario in Make as this is a legacy module. Check it out here: simongondeck.com/wp-content/uploads/2023/01/blueprint-export-woocommerce-subscriptions-google-sheets.json
@@simongondeck Is there any tutorial about this? I'm looking for the Watch Subscriptions functionality as well... but do not understand what to do exactly in this case.
Thank you for the video, but I've got the same problem as "studemme", "if there are more product in an order, how could i add all the products and not only the first?" thank you
check out these videos here: ruclips.net/video/7QP5eeVZrnI/видео.html and ruclips.net/video/X8hz_Sg2304/видео.html
Thank you so much, Simon! What if I want 1 row per item to be exported to my google sheet? Is it possible? So we'd have several rows with the same order id
Yes for sure thanks for watching! In regards if you want 1 row per item to be exported to your google sheet, this is possible. Setup your scenario in Integromat with 3 modules: WooCommerce, Iterator, and Google Sheets. In the Iterator module add "Line items []". Then, when mapping to your Google Sheet add data from WooCommerce Order and also results from the Iterator module to be added to the row. Does this make sense?
Would it be helpful to see a video on this?
@@simongondeck I'll try this on Monday! Thank you so much! Merry Christmas, Simon! May God bless you and your family!
P.S I am doubtful if I'll make it work without step by step since I am new to integromat.
@@Refri1394 Merry Christmas to you and your family too! I just created a new video about how to do this 1 row per item. Check it out here: ruclips.net/video/X8hz_Sg2304/видео.html. If you have not created a Integromat account it would be appreciated if you use my link at simongondeck.com/integromat. Let me know if you have any questions. Cheers!
Hi Simon, the scenario to export subscriptions is not available?
Hey Manuel can you check at the 24-25 minute mark in the video?
@@simongondeck yes, but when I search for "subscriptions" when creating the scenario it does not appear
Hi how long we can use free ?
as long as you want
Hi, how could I add the field "Meta data 2 value"? I am able only to add the "Meta data 1 value" but I need the second, thank you-
Moreover, if there are more product in an order, how could i add all the products and not only the first? :)
Hello, do you know how to trigger abandonned card information for woocommerce so i can export to an excel and then work on it?
Not that I know of
Hi ! I have the same problem than Shams. It doesn't work, it's not triggering in the sheets. I just get the number one upon the woo icon and not on the sheets module. Can you help me please ?
Do you have any orders on WooCommerce? Or did all your orders already run? Click the 'back' button on the scenario and click the 'history' tab. Do you see anything that ran?
@@simongondeck When I try today, it worked only for the new order, that I had 2 hours ago. I think that it doesn't work for the past orders only. Do you know how to run the past orders too ? Thank you Simon.
@@abc-transition-bas-carbone follow the logic at the 11:25 and 11:50 mark of the video to 14:00 above where you delete the WooCommerce module and then re-add it and then choose all orders (to get past orders too)
I am running it but it's not triggering in the sheets. I just get the number one upon the woo icon and not on the sheets module.
Do you have any orders on WooCommerce? Or did all your orders already run? Click the 'back' button on the scenario and click the 'history' tab. Do you see anything that ran?
@@simongondeck Yes I have like 17 orders already before integrating this. Yes I can see one success item
@@simongondeck I re-tried everything from start and it worked now
@@Shamzstud great to hear!