Export WooCommerce orders to CSV

WooCommerceIntermediate~10 min

Before you start

A connected store with the WooCommerce integration enabled and its read abilities on.

Sometimes you just need the orders in a spreadsheet: to reconcile against payouts, to hand your accountant a quarter, or to slice the data a way WooCommerce will not. The built-in export plugins want their own setup, and you only need this once in a while. This prompt reads the orders and formats them as CSV text right in the chat, so you copy the block out and paste it into a spreadsheet. No file ever touches your server, because the agent has no way to write one.

The prompt
Build me a CSV of orders. Read only. Pull every order from [1 January] to
[31 March] with status [completed or processing], then read each one for these
columns: order number, date, status, customer name, email, order total, and
currency. Lay it out as proper CSV, one header row then one row per order,
commas between fields and quotes around anything that contains a comma. Just
give me the CSV in a code block so I can copy the whole thing. If any order is
missing a field, leave that cell blank rather than guessing, and tell me
afterwards which ones had gaps.

Why this is safe to run

Both abilities are reads: one lists the orders in your range, the other reads each order for its detail. Neither can change an order, and the agent cannot save a file anywhere, so the “export” is just text it prints for you to copy. That also means the customer data in the CSV, including the email and phone that a single-order read returns under the Integrations security disclaimer, only ever lives where you paste it. Handle the copied block like any other customer export.

Already connected? Skip the paste. Ask your agent for the “export orders to CSV” recipe, name your date range and columns, and it formats the same CSV from your own store.

How it works

  1. List the orders in the date range and statuses you name.
  2. Read each one for the fields you asked for, like totals, dates, and customer details.
  3. Lay the rows out as CSV text with a header row, ready to copy.
  4. Note anything it could not include so the file is honest about its gaps.

Questions

Does the agent create a file on my server?
No. It has no file access. It formats the CSV as text in the chat and you copy it into a spreadsheet or a .csv file yourself. Reading the orders writes nothing back to the store.
Can I get billing and shipping details in the export?
Yes. Reading a single order returns the full billing and shipping address, including email and phone, under the Integrations security disclaimer, so ask for the columns you want. Treat the result as customer data.