How to Export Your WooCommerce Orders

WooComerce is a great way to set up your online store. However, whereas WooCommerce has awesome functionality in setting up, concluding orders, and creating reports, many store owners turn towards a separate plugin to export their orders. The process of exporting WooCommerce orders is done to address a number of different factors: Migrating an online store to a new websiteOrganizational purposesKeeping a backup of your store dataOrder fulfillment With a plugin like WP All Export, you can export tens, even thousands of WooCommerce orders in a few simple steps. In this article, we’re going to take on a hands-on approach and show you how to export your WooCommerce orders using WP All Export. Let’s get to work. Pricing Before we start off with the tutorial, let’s take a look at the pricing options for WP All Export. The Pro version comes in 3 options: Export Standalone – $99Import + Export Standalone – $169Import +Export Pro Package – $249 If you’re thinking of migrating to a new website, or envision using the import version of the plugin at a later stage, I suggest opting for the Import + Export packages. For the purposes of this tutorial, however, the Export Standalone will work just fine. Setting Up The Export To start a new export, go to All Export > New Export in the WordPress sidebar. The first thing you need to do is select WooCommerce Orders from the drop-down menu. At this point, you can add filtering options to specify exactly which orders you want to export. You can do this by adding various criteria. In this case, I’ve set the order status to complete. By adding this criterion, I will only be exporting completed orders. It’s a pretty neat feature to have. Continue on to the next step to customize your export file. Customizing Your WooCommerce Orders Export File The plugin interface is pretty straightforward. WP All Export displays the available data on the right-hand side of the screen which you can then drag and drop into the dashed rectangle in the center of your screen. The way you order your elements will be reflected in the CSV or excel file once it is exported. Alternatively, you can also click the Add Field button which displays a list of all the available fields. To remove one of the elements, simply drag it out of the box and it will disappear. You also have the option to delete all the elements by clicking on the Clear All button. You can also reorder elements in the same way by dragging and dropping them within the box. In this way, you can add as much or as little information as you want. You can add data about the order, order items, customer, taxes and shipping, notes, refunds, and more. When you’re happy with your choice, use the Preview button to see what your export file will look like. This gives you a live preview of your excel file with real data from the export. If you need to make any changes, you can always go back and edit your fields. Once your fields are all set, you need to choose your export type. WP All Export gives you a number of options. You can either export your WooCommerce Orders into a spreadsheet or as a feed. In this example, I’m going to opt for the spreadsheet. From the drop-down menu, choose between a CSV file, XLS, or XLSX file. Alternatively, you can export your WooCommerce orders to a feed as a simple XML feed or Custom XML Feed. Finalizing and Running the Export WP All Export gives you scheduling options that allow you to automatically export any WooCommerce data on a schedule. You can set daily, weekly or monthly exports and set a specific time (and time zone). Under Advanced Options WP All Export lets you specify whether you want to only export orders once. This means that with each subsequent run, only new orders will be exported. Alternatively, you can choose to only export modified orders. In this case, orders with altered data will be exported. All that’s left is to name your feed so that it’s easier to recognize later on. Confirm and run your export. Final Steps In the final step of the plugin, WP All Export will display all the things you can do with your newly exported WooCommerce Orders file. Download Here you can download your exported file and access the feed URL for the file. Your file should look similar to the following spreadsheet: You can also download a “Bundle”. This will create a zip file that you can upload through WP All Import when migrating your WooCommerce Orders to a new site. All of your settings will automatically be filled in for you thanks to the WP All Import plugin. Scheduling Here you can review your schedule or set one up if you skipped the step earlier on in this tutorial. External Apps WP All Export has a Zapier integration to automatically send your exported file to Google Drive, Dropbox, any email via Gmail, and much more. This section comes with a video tutorial that will teach you how you can do so. Export, Edit, Import WP All Export also gives you the option to download your spreadsheet, edit it and reupload it through WP All Import. Conclusion WP All Export is a great way to export your WooCommerce data. Online stores can be difficult to keep organized and up to date. This is where WP All Export comes in to enable you to keep track of all your orders and back up your data as local spreadsheets. If you’re thinking of migrating to a new website, WP All Export simplifies this task for you thanks to its intuitive interface and customization options. The plugin is easy to use and great for beginners and proficient WordPress users alike. Have you used WP All Export to export WooCommerce data? Let us know in the comments section below. Gabriella Galea Gabriella is the Project Operations Manager at WP Mayor. Architect by profession, designer by nature, she is dedicated to helping readers navigate the online world of WordPress. You can find her on Twitter @GabriellaGalea. Related Topics: Plugin Reviews Tags: woocommerce, wp all export Consider sharing this post so others can find it: Share on facebook Share on twitter Share on linkedin Share on reddit Share on telegram Share on whatsapp Share on pocket Share on email Join thousands of people receiving real-world, genuine evaluations of WordPress products and services just like this one every week. Email Stay informed for free

Share:

Facebook
Twitter
Pinterest
LinkedIn

Leave a Comment

Your email address will not be published.

Table of Contents

On Key

Related Posts

Best Google Maps Plugins for WordPress

Before we start looking at any plugins, it’s good to review the way Google Maps work. There are several components in the Google Maps API family, all of which can be found on the Google Maps API Family page. When working with WordPress, we are mainly interested in two of these APIs: Static Maps APIMaps

How to Get a Custom Field Value via Shortcode

Sometimes we want to make it easy for site administrators to include the value of a custom field (maybe created as part of a custom meta box) into a post. An ideal solution to this challenge is to use shortcodes. You can either do this through these two plugins: Get Custom Field Values Custom Fields

Best Auto Translation Plugins for WordPress

Having the content of your website available in different languages can mean a much bigger audience for you. A very simple way to do this is to provide automatic translators, they’re not the same as manually translating all your content, but do a pretty good job. It’s better to have an automatic translation plugin than

Best WordPress Multilanguage Plugins

The two main contenders as best multilanguage plugins for WordPress are WPML and QTranslate. If you want a quick answer to which one comes out on top, I would say go for WPML. If you have enough time to give them a test drive, by all means, do so and judge for yourself which one