WooCommerce – Export Orders with Specific Dates or Date Range

Let’s see how to export WooCommerce orders with specific dates or by date range.

Maybe you need to export your WooCommerce orders created on a specific date, or all orders from last week, month, or year.

This can be useful if you want to analyze the impact or results from a specific marketing campaign held during a specific date interval.

Exporting WooCommerce orders by specific date or date range can be very useful for creating custom sales reports based on a specific timeframe.

Consider these examples of how exporting orders placed during a specific date or date range can serve your needs:

• Export all WooCommerce orders from last month or your desired timeframe
• Track and analyze your sales by day, week, or month
• Get orders placed within a specific date interval for accounting purposes
• Export WooCommerce orders with a date range that aligns with your restocking schedule
• Create quarterly business reviews by exporting WooCommerce orders placed during the last three months

This is not possible with WooCommerce alone. You might need to create the table manually and copy the orders’ information one by one.

That’s boring! Fortunately, we have great news!

WP Sheet Editor – WooCommerce Orders

You can use an intuitive spreadsheet to find and export WooCommerce orders created during a specific date range.

We’re talking about the WP Sheet Editor – WooCommerce Orders plugin.

It displays all your WooCommerce orders and their complete information on a spreadsheet.

It contains a Search tool to help you filter your orders.

You can also use the Bulk Edit tool, which allows you to edit thousands of orders in minutes.

And you can use the plugin’s export and import tools to manage your orders using CSV files.

After installing and activating it, go to Sheet Editor > Edit orders to open the orders spreadsheet.

Now, just follow these simple steps.

1- Open the “Search” tool to filter your orders by date range

The Search tool allows you to filter orders using several search parameters and save a lot of time.

You can open it by clicking on Search.

You’ll find the following search fields:

• Contains keyword – Search for orders containing a specific keyword in the title.
• Status – Search for orders with statuses: Pending Payment, Processing, On hold, Completed, Cancelled, Refunded, Failed, Trash.
• Find orders containing these products – Search for orders containing specific products.
• Order notes – Search for orders containing a specific keyword in the order notes.
• Enable advanced filters – Use filters to search orders by date range, billing and shipping info, order total, etc.

2- Filter all your orders with specific date or date range

After opening the search tool, decide if you want to search for orders containing specific dates or orders within a date range.

Tip: Use a specific date if you want orders from a particular day. Use a date range if you want orders from a time period such as a week, a month, or a year.

a) Orders with specific date

To search for orders with specific dates, select these values in the search tool:

• Tick the Enable advanced filters checkbox
• Field: Date (GTM) (post_date_gtm)
• Operator: CONTAINS
• Value: Enter the date using YYYY-MM-DD format.
• Click Run search.

Once you filter your WooCommerce orders with specific dates, you will see them displayed on the spreadsheet. You will also see the active search filters above the spreadsheet.

If you chose this search option, you can go to the next step and export your orders containing a specific date.

b) Orders with specific date range

Let’s say you want to find all orders placed during January 2024. In this case, set a date range from January 1 to January 31.

You can use this method to track sales for last year, last quarter, Christmas season, or any other custom timeframe.

In the Search tool, tick the Enable advanced filters checkbox and enter these values:

• Date range from: Enter the initial date.
• Date range to: Enter the final date.
• Click Run search.

You will then see all your orders created during the specified date range displayed on the spreadsheet.

You can view the applied search filters above the spreadsheet.

3- Export the filtered orders

Now you need to export the orders you’ve filtered by date or date range.

Click on Export in the top toolbar.

Select these values to export WooCommerce orders to a CSV file:

• What columns do you want to export: Select all the columns you want. You can click Select all active columns, Select all, or choose individual columns.
• Which rows do you want to export: Export all rows (orders) from your current search.
• What app will you use to edit this file: Choose Microsoft Excel (Office 365), older Excel versions, Google Sheets, etc.
• You can add a name for this export in the Name of this export field.
• If you want to export a detailed list of products instead of one row per order, tick Export every product (line item) as separate rows.
• Click Start new export.

After running the export, a CSV file containing the selected orders will be downloaded. You can now send a clean report to your client.

As you have seen in this tutorial, you don’t need to spend hours opening many tabs and clicking buttons to export orders by date interval.

You can save a lot of time finding and exporting all your orders by specific date or date range with WP Sheet Editor – WooCommerce Orders.