Woocommerce Pulling All Orders from a Customer

Hey guys,

I am trying to build a Zap that that every first of the month will pull all orders made from customers with a particular role to build an account statement report (in google sheet) that will be sent to them every month.

That account statement will show all their order placed in the month like this:

order # : Date : Amount : Status (paid or unpaid)

Is there a way to do this or should I treat all orders individually as soon as they come in with the woocommerce order created trigger?

Thanks for the help.

Page 1 / 1

Hi @TwentyFour

You cannot do that with Zapier as it requires a trigger. You need to treat each order individually as soon as it comes in and then you can use Zapier to Digest the order for each customer and send them what you want

Hi @TwentyFour

Good question.

You’d have to use the WC API: https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-orders

App APIs can be used in Zaps with the Code app or the Webhooks app.

You’d need to get all the Customers, then iterate thru each to get the Orders.

You can use the Schedule app as the Zap trigger.

You can use the Looping app to handle the array of Customers.

NOTE: You may have to apply advanced logic for handling pagination in the API results.

If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts/automation-ace

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded