---
title: "WooCommerce order export each month · Hypamoon"
description: "Exporting WooCommerce orders for your bookkeeper every month? Get the file you need on the first, with the columns your bookkeeper asks for."
url: https://hypamoon.com/connect-to/woocommerce/order-export
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [WooCommerce](https://hypamoon.com/connect-to/woocommerce)
3.  Order export

For teams that run on WooCommerce

# WooCommerce order export each month

WooCommerce Analytics lets you download an orders report when you ask for it, and a large one arrives as a link by email that works for a week. The file your bookkeeper wants, with tax per rate, refunds and payment method, still takes a download and a cleanup every month.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=woocommerce/order-export)

## How it goes today

1.  Open Analytics, pick last month and request the download.
2.  Wait for the email with the link and download the file.
3.  Delete the columns your bookkeeper does not use and add the ones they need.
4.  Add the refunds of the month and email the file.

## How it can go

**Your bookkeeper gets last month's orders on the first, in their format.**

On the first working day of the month your bookkeeper gets a file with last month's orders: order number, date paid, customer, country, the amount per tax rate, shipping, payment method and refunds on their own lines. The columns and the order are yours to choose once. You get a copy and a short summary of the totals.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your WooCommerce key in the portal, never in the chat.

Your request

> With Hypamoon, on the first working day of every month, make a file with last month's paid orders from our WooCommerce shop: order number, date paid, customer, country, amount per tax rate, shipping and payment method, with refunds on their own lines. Use the columns and order I give you once. Email it to our bookkeeper and send me a copy with the totals.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~woocommerce/order-export&say=a%20monthly%20file%20of%20last%20month's%20WooCommerce%20orders%20for%20our%20bookkeeper%2C%20with%20tax%20per%20rate%2C%20shipping%2C%20payment%20method%20and%20refunds%2C%20in%20the%20columns%20we%20choose%20once.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=woocommerce/order-export)

You create the WooCommerce key yourself under WooCommerce, Settings, Advanced, REST API. It stays yours.

## More for teams on WooCommerce

-   [**I want orders to show as shipped, with a tracking link for the customer.**](https://hypamoon.com/connect-to/woocommerce/shipped-orders)
-   [**Many of my customer emails ask where their order is, and I look each one up.**](https://hypamoon.com/connect-to/woocommerce/where-is-my-order)
-   [**The low stock email comes too late for a supplier with a four week lead time.**](https://hypamoon.com/connect-to/woocommerce/reorder-points)
-   [**When new stock arrives I edit every product in WooCommerce by hand.**](https://hypamoon.com/connect-to/woocommerce/stock-updates)
-   [**I want one page per customer with every order, the total and their favourite products.**](https://hypamoon.com/connect-to/woocommerce/customer-view)
-   [**I want to know my repeat purchase rate and my sales per country.**](https://hypamoon.com/connect-to/woocommerce/repeat-customers)
-   [**Business customers ask me for a proper PDF invoice of every order.**](https://hypamoon.com/connect-to/woocommerce/pdf-invoices)
-   [**Our B2B customers email PDF purchase orders and we retype each one.**](https://hypamoon.com/connect-to/woocommerce/purchase-orders)
-   [**I want the sales of yesterday by email, without logging in.**](https://hypamoon.com/connect-to/woocommerce/sales-report-email)
-   [**I want to raise the prices of a whole category without opening every product.**](https://hypamoon.com/connect-to/woocommerce/price-changes)
-   [**I want to ask customers for a review a week after their order arrives.**](https://hypamoon.com/connect-to/woocommerce/review-requests)
-   [**I want to set a date for a product to go offline or back in stock.**](https://hypamoon.com/connect-to/woocommerce/scheduled-products)
-   [**Customers who first ordered as a guest don't see those orders in their account.**](https://hypamoon.com/connect-to/woocommerce/guest-orders)
-   [**A bot placed hundreds of fake orders overnight and I cleared them one by one.**](https://hypamoon.com/connect-to/woocommerce/card-testing)
-   [**We run two WooCommerce shops and I update the stock in both after every sale.**](https://hypamoon.com/connect-to/woocommerce/multi-store-stock)
-   [**Our shopping feed keeps refusing products because the GTIN field is empty.**](https://hypamoon.com/connect-to/woocommerce/product-data-check)
-   [**Our regular customers order the same every week and I type it in again each time.**](https://hypamoon.com/connect-to/woocommerce/standing-orders)
-   [**Every week I clean up the supplier's CSV before I can import it.**](https://hypamoon.com/connect-to/woocommerce/supplier-files)
-   [**I have to set the photo for each colour variation one by one.**](https://hypamoon.com/connect-to/woocommerce/variation-grid)
-   [**Before each class I build the attendee list from the orders and email everyone.**](https://hypamoon.com/connect-to/woocommerce/class-lists)
-   [**I want to tell customers their local pickup order is ready to collect.**](https://hypamoon.com/connect-to/woocommerce/pickup-ready)
-   [**I add up our sales per state in a spreadsheet to see where we are getting close to nexus.**](https://hypamoon.com/connect-to/woocommerce/sales-tax-by-state)
-   [**We have thousands of old coupon codes and no safe way to clear them.**](https://hypamoon.com/connect-to/woocommerce/coupon-cleanup)
-   [**I need 300 unique single-use discount codes for an event.**](https://hypamoon.com/connect-to/woocommerce/coupon-codes)
-   [**I copy each order to the supplier who ships it and wait for the tracking code.**](https://hypamoon.com/connect-to/woocommerce/supplier-orders)
-   [**When I sell one product, the stock of the other product should go down too.**](https://hypamoon.com/connect-to/woocommerce/shared-stock)
-   [**Each quarter I split our WooCommerce sales per EU country and VAT rate for the OSS return.**](https://hypamoon.com/connect-to/woocommerce/oss-report)
-   [**For each sale I have to look up what the lowest price was in the last 30 days.**](https://hypamoon.com/connect-to/woocommerce/lowest-price-check)
-   [**Every morning I compare the bank statement with the WooCommerce orders on hold.**](https://hypamoon.com/connect-to/woocommerce/bank-transfers)
-   [**I keep a spreadsheet of what each business customer owes us.**](https://hypamoon.com/connect-to/woocommerce/customer-statements)
-   [**Each month I work out in a spreadsheet what each consignor sold and what we owe them.**](https://hypamoon.com/connect-to/woocommerce/brand-statements)
-   [**Each month I work out the commission per influencer code by hand.**](https://hypamoon.com/connect-to/woocommerce/coupon-commissions)
-   [**Every day I copy the options and names from each order onto a production sheet.**](https://hypamoon.com/connect-to/woocommerce/production-list)
-   [**I open every order and write down what to pick.**](https://hypamoon.com/connect-to/woocommerce/pick-list)
-   [**When a backorder is delayed I email each waiting customer by hand.**](https://hypamoon.com/connect-to/woocommerce/backorder-updates)
-   [**I message every cash on delivery customer to confirm before I ship.**](https://hypamoon.com/connect-to/woocommerce/cash-on-delivery)
-   [**Our business customers want an e-invoice, so I retype each order in our accounting package.**](https://hypamoon.com/connect-to/woocommerce/e-invoices)
-   [**At the end of the year I make a donation statement for each donor from our WooCommerce orders.**](https://hypamoon.com/connect-to/woocommerce/donation-statements)
-   [**Our webhook was off for weeks before we noticed orders had stopped coming through.**](https://hypamoon.com/connect-to/woocommerce/store-health)
-   [**I track the open core charges in a spreadsheet and refund each one by hand.**](https://hypamoon.com/connect-to/woocommerce/deposit-returns)
-   [**Everything for WooCommerce**](https://hypamoon.com/connect-to/woocommerce)
