Export WooCommerce Data to Google Sheets for FREE (Orders, Customers, Products, Subscriptions, etc)

Learn how to export WooCommerce orders, customers, subscriptions, and products to Google Sheets for FREE!

-- LINKS --

Timestamps:
0:00 Intro
2:30 Prepare for export
3:48 Export WooCommerce Orders
20:42 Export WooCommerce Customers
23:55 Export WooCommerce Subscriptions
25:13 Export WooCommerce Products
26:58 Download WooCommerce Orders, Customers, Subscriptions, and Products to CSV or Excel

🔵 RELATED CONTENT

✅
-- DESK SETUP --

#WooCommerceExport

DISCLOSURE: We often review or link to products & services we regularly use and think you might find helpful. Wherever possible we use referral links, which means if you click one of the links in this video or description and make a purchase we may receive a small commission or other compensation.

[sipinkw]

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😊

[justinjuk]

This worked beautifully! Thanks Jason Bourne!

[abd]

It was very helpful, will try it
Thank you 😊

[TrevorSchumann]

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?

[badrmerouane]

very nice explanation, and really useful, thank you

[KrzysztofMucha-tzyv]

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?

[pauartiso]

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

[leomarkconstantino]

There's no option fir woocommerce subscription

[PavanMulpuri]

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

[anotherone]

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

[MKBontwikkeling]

Awesome! Can you do a video on updating orders and especially on splitting up the line item array to different rows?

[bladycivilian]

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.

[henrygarcia]

Can this be updated daily automatically? Is there a trigger for that?

[SamirRifai]

Great video! How can we setup for custom order status?

[profesionalesdelasreformas]

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!

[ZeeshanIqbal]

is there any way to manage inventory and purchases through this?

[bestslopedesigns]

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!

[manuelfunk]

Hi Simon, the scenario to export subscriptions is not available?

[laetitiahughes]

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

[Refri]

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