How to Export WooCommerce Orders as CSV (With no a Plugin)

How to Export WooCommerce Orders as CSV (With no a Plugin)
Comments Off on How to Export WooCommerce Orders as CSV (With no a Plugin), 28/09/2022, by , in Wordpress
[ad_1]

There are various reasons to export orders from WooCommerce applying CSV or TXT data files. Initially off, you may well have to have to share get details with crucial events, like dropshippers, third-occasion logistics/shipping associates, warehouse pickers, or shareholders.

Or, perhaps, you’re transferring your retail store from WooCommerce to an additional ecommerce system. In that situation, you will want to use WooCommerce to export orders right before the transfer.

👉 In this guidebook, you’ll learn the next:

How to export WooCommerce orders without the need of a plugin (CSV)

There is already a “WooCommerce export orders” function designed into the technique, so there is technically no cause to use a plugin for basic get exports.

To start, make guaranteed that you have some solutions and latest orders within WooCommerce for the export to get the job done.

Go to WooCommerce → Orders to see orders and guarantee that there are some past, lively, or processing orders to compile them into an export sheet:

Be aware: You can export “Cancelled” or “Pending Payment” orders but not by default.

an Orders button in WordPress, and order statues highlighted

The moment you’ve gathered some gross sales, and you are ready to export individuals orders into a CSV file, carry on under to complete that process:

Go to the Reports web site to export WooCommerce orders as CSV filesFilter which orders to export from WooCommerce to CSVExport the WooCommerce orders to CSVOpen, edit, or shift the CSV order export file

1. Go to the Reports page to export WooCommerce orders as CSV data files

To start out a WooCommerce export of all orders into a CSV, you require to get started by likely to the Experiences webpage. Simply click on WooCommerce → Stories:

a Reports button in WordPress

The Studies site presents graphs, charts, and figures on orders, clients, and inventory in just your WooCommerce retail outlet.

All get exports commence right here. You can filter based on certain metrics, then simply click on the Export CSV button for unique information in the export sheet:

the orders tab in WooCommerce reports

2. Filter which orders to export from WooCommerce to CSV

Just one way to go about it is to leave the filters alone to quickly export all orders designed in the past seven days.

Even so, it is also achievable to filter the experiences and, in transform, export info from individuals reports into a CSV file.

The very first filter exhibits income by date, the place you pick to present profits more than the final 7 times, this thirty day period, previous thirty day period, or the year. There’s also a Custom made subject to set your personal day assortment.

After you’ve created your alternative, simply click the Go button to activate the filters:

filters for sales by date

The Revenue By Item tab lets you pick selected stock objects and only export info from all those merchandise. Underneath the Sales By Item tab, find just one (or multiple) goods so that only they appear in the reports:

Observe: All filters basically make it possible for for filtering by day. For that reason, for occasion, you could incorporate the “sales by product” filter and the “sales by date” filter.

showing reports for one product

The Gross sales By Category tab serves as another filter, where you select a person (or several) categories from your WooCommerce shop. Then, only those categories get added to the WooCommerce export orders CSV:

a filter for product categories while using WooCommerce to export orders via CSV

Eventually, WooCommerce features tabs to filter experiences and buy exports by coupon codes and shopper downloads:

customer downloads filter

3. Export the WooCommerce orders to CSV

When you’ve designed filter picks (or remaining them as is for exporting all the latest orders) come across the Export CSV button.

Click on that to right away obtain a CSV file to your computer’s Downloads folder (or wherever you have downloaded browser documents likely by default):

the Export CSV link in WordPress

4. Open up, edit, or shift the CSV buy export file

Most of the time, your browser should really save this file to your computer’s local Download’s folder, but you could have a diverse folder for default browser downloads.

Regardless, locate the WooCommerce orders export CSV where ever it went on your laptop or computer:

a downloaded CSV in the downloads file

You are welcome to transfer the CSV file to an additional storage locale, or deliver it to the acceptable functions. You can also click on on the file to open it up.

The CSV file delivers a record of all WooCommerce orders from the specified timeframe, solution, or group.

You’ll see columns for:

Amount of objects soldNumber of ordersAverage web revenue amountCoupon amountShipping amountGross revenue amountNet income amountRefund sum:

a downloaded CSV with order details

Which is how you use WooCommerce to export orders to CSV information!

Use WordPress to export orders as XML file

Yet another way to export WooCommerce solution data is with a designed-in WordPress attribute for exporting content material from your web page.

This strategy is specifically helpful if you’d fairly attain an XML file with get information, which assists when importing to new WordPress web pages, or to other website builders and ecommerce platforms.

Navigate to the WordPress Export toolExport your WooCommerce orders, and nothing at all elseOpen, edit, or transfer the WooCommerce order export file

1. Navigate to the WordPress Export device

In your WordPress dashboard, go to Instruments → Export:

a WordPress tab called Export - to

2. Export your WooCommerce orders, and practically nothing else

The Export site supplies a number of options for exporting written content from all above your WordPress web site. You can export posts, web pages, products and solutions, variants, orders, refunds, discount codes, and media.

Even though it’s attainable to export “All Content” for building a internet site migration a little a lot easier, you would decide on the Orders industry to only attain an XML file with WooCommerce merchandise order details.

After selected, simply click the Download Export File button. This will save the file to your Downloads folder (or whichever folder you have set to mechanically help save information downloaded from the world wide web):

the Orders field selected and the download export file button

3. Open up, edit, or shift the WooCommerce purchase export file

You can come across the WooCommerce buy export XML saved on your pc (most very likely in the Downloads folder). Click on on the file to perspective or edit the information. Take into account saving it to a different area, or send out it to anyone else:

an XML file in the downloads folder

Continue to keep in head that an XML WooCommerce purchase export works in a different way than a CSV file.

It has special import choices, and the XML file isn’t as consumer-pleasant for viewing, considering the fact that it is extra for the transfer of details, not enhancing.

Best plugins to export WooCommerce orders

You now know the two means to export WooCommerce orders with CSV and XML information. Each of them are crafted-in applications with your standard WordPress/WooCommerce set up and consequently really don’t call for putting in a plugin.

Nonetheless, you could want to develop upon the default export functionality. Possibly there is no these kinds of export feature integrated in WooCommerce.

💡 In that situation, we suggest turning to a WooCommerce order export plugin.

There are several available plugins to export WooCommerce orders by means of CSV, XML, or other formats like PDF. Some plugins primarily aim on the exporting abilities, while other folks supply a huge selection of characteristics, with buy exports becoming just one of them.

📌 We’ve tested the most promising WooCommerce export orders plugins, and listed here are the kinds we endorse:

Order Export and Get Import for WooCommerce: Especially beneficial for batch WooCommerce order exports to CSV information.Highly developed Order Export for WooCommerce: The most superior resolution for exporting orders from WooCommerce, with functions for exporting order knowledge to file formats like CSV, XLS, XML, PDF, TSV, HTML, and JSON – you can also decide on the fields you want to export.WooCommerce Buyer/Get/Coupon Export: A high quality extension for exporting orders, together with buyers and discount coupons, from WooCommerce. The key gain of this plugin is that you can set an automatic plan for recurring exports, and it supports CSV and XML formats.Import/Export Suite for WooCommerce: Principally for use even though migrating an whole site, this plugin enables for exporting orders, passwords, products, prospects, and subscriptions. You can export WooCommerce orders through CSV or XML and deliver the data correct to community storage or FTP.Stamps.com XML File Export: Really helpful for customers of Stamps.com, since it routinely exports orders to Stamps.com in XML format. You can export bulk or individual orders, and use filters to specify which fields to include things like.

How to export WooCommerce orders to CSV with a plugin

If you are likely the plugin route, we really endorse applying the Innovative Purchase Exports for WooCommerce plugin, due to the fact it’s absolutely free, effortless to have an understanding of, and offers a list of order aspects that you can save in various formats, like CSV, XML, PDF, and HTML.

Here’s how to use the plugin to export your buy info:

Install the plugin and access the export featuresSet filters for day rangesChoose an export file formatFilter the export even even more (if desired)Run the export

1. Put in the plugin and access the export attributes

To get started, put in and activate the Innovative Exports for WooCommerce plugin.

As soon as you’ve done that, you will obtain a new Export Orders tab when scrolling in excess of the WooCommerce menu merchandise in WordPress.

Click on that to start off the method:

a button in WordPress to export orders

2. Set filters for day ranges

The plugin presents several day assortment filters so that you only export orders that came in during sure time durations.

Use the “Filter orders by” area to filter by get day, modification day, paid date, or accomplished date.

Soon after that, you can established a date range for the export.

There are also settings to get summary reports, configure the export file title, and alter which order statuses surface in the export:

a section in WordPress to filter orders by date

3. Pick out an export file format

The Format area features fields for:

Choose the CSV option to export your orders to a CSV file. You can see further CSV export options this sort of as for outputting column titles as the to start with line or getting rid of line breaks:

the format section to use WooCommerce to export orders via CSV

4. Filter the export even further more (if required)

If you want to get even much more qualified with your export filters, the ideal aspect of the interface lets you filter the export by the pursuing details:

ProductCustomerCouponBillingShippingItem and metadata:

Filter the export by details

For instance, you might pick to only export orders of a particular product or service , these kinds of as T-shirts:

filter by product section for WooCommerce export orders CSV

5. Run the export

The plugin has a wide range of other configurations to configure, so truly feel no cost to participate in all over with these.

The moment you’re joyful with your export options, find and click on on the Export button at the base of the window:

the Export button

The WooCommerce export orders CSV gets saved on your laptop, where by you can open up it to see a checklist of all orders with their order quantities, statuses, and the billing and shipping and delivery info from shoppers:

List of all orders

Each row also shows order particulars these types of as get complete total, SKU, item name, and item charge:

WooCommerce export orders CSV with order details like order amount

Bonus Phase: Check out exporting in a unique file format, like PDF or HTML

You can constantly go again to the Structure part in the plugin to re-operate an purchase export in a diverse file structure. Simply just pick one more subject, this kind of as PDF.

Each individual file format has its individual excess configurations. For illustration, the PDF format will allow for altering the orientation of the doc, page dimension, font size, and column width:

format section with PDF selected

Click the Export button just like you did in the earlier methods.

The terrific section about employing a plugin like this 1 for get exports is that you achieve the flexibility to export a extensive range of doc formats. And that can make perception, thinking of you’ll most possible want a PDF to print an order kind in numerous scenarios. Or, it could be sensible to export an HTML file if you want to incorporate that information to a web-site:

order list pdf with customer information

Do you have any queries on how to use WooCommerce to export orders by way of CSV?

You can export WooCommerce orders by using CSV, PDF, XML, and lots of other formats. You only will need to opt for the suitable approach (employing a plugin or the created-in WooCommerce export features) to permit for the desired formatting.

The good news is, each solutions do the job seamlessly 😎 and need to allow for you to down load an order checklist for inventory pickers, achievement organizations, and other people who could want a electronic or physical buy list.

Do you nevertheless have any thoughts about how to export WooCommerce orders as a CSV or other file formats? Enable us know in the comments!

No cost tutorial
5 Critical Ideas to Speed Up Your WordPress Website
Cut down your loading time by even 50-80% just by next very simple strategies.

[ad_2]

About Vikram Rout

Vikram Rout has been a blogger, digital marketer and an SEO expert at Pixxelznet.com, one of the fastest growing custom design crowdsourcing platforms. Over the years, he has been helping small businesses and startups improve website design and SEO strategy, content marketing and user experience. You can engage with him on here.