The complete documentation of the Order Export & Order Import for WooCommerce plugin covers the setup and configuration of the plugin.
Features offered by the Plugin
By using this plugin you can make use of the following features.
- Export and import orders to and from your WooCommerce store.
- Bulk update of existing orders.
- Export and import of coupons to and from your store.
- Bulk update of all coupon data in your store.
Installation of the Plugin
If you haven’t already installed the plugin in your store, you can either do it directly via the WordPress plugin repository or download the zip file of the plugin from the WordPress.org and install it to your website. For the detailed installation info, you may refer to the article How to Install a Free Plugin from WordPress.
Pre-requisites for the Plugin
- The plugin takes CSV (Comma-separated values) as input for import. It maps each field of CSV file to the particular filed of Coupons/Orders.
- To get started you must have a CSV file. You can create one or export the coupons/orders to get the format of CSV, or download the sample CSV given below.
- The CSV Import file must be in UTF-8 format if you need to know more about it read How to save CSV / Excel File as UTF-8 Encoded?
Structured CSV Format for Coupons & Orders
As said above, the plugin takes CSV (Comma-separated values) as input for import. It maps each field of CSV file to the field of a particular Coupon/Order.
More precisely, in terms of orders, the Order_id field gets mapped to the identification number of the order and the shipping_total field gets mapped to the total shipping cost of the order. To learn more about the structured format of order CSV visit the article.
For coupons, the Coupon ID field gets mapped to the identification number of the coupon and the coupon_amount field gets mapped to the total coupon amount. To learn more about the structured format of coupon CSV visit the article.
Getting Started with the Plugin
To get started with the plugin you can navigate to WooCommerce > Order Im-Ex/Coupon Im-Ex tab.
Following is a screenshot of the opening window of the plugin.
Here you can find separate tabs for the import and export of orders, coupons, and subscriptions (subscription import export is a premium feature of the Order/Coupon/Subscription Import Export Plugin.)
Now, let’s get started on how each of the import and export process is carried out.
In this section, you can import orders (in CSV format) to your shop by uploading a CSV file.
It also allows you to update existing product data in bulk.
By clicking the Import Orders button a new window appears for you to upload the order CSV file.
You can select a file from your computer (The CSV should be UTF – 8 encoded with a maximum file size of 1 GB).
Export and download your orders in CSV format. This file can be used to import orders back into your WooCommerce shop.
Offset – It denoted the number of orders to skip before exporting. If the value is 0, no orders are skipped. If the value is 100, orders from order id 101 will be exported.
Limit – It denotes the total number of orders to be exported. If no value is given all orders will be exported. This filter is useful if you have a large number of orders and want to export only a partial list of orders.
Order Statuses – Here you can select the order status(es) that need to be exported.
Start Date – Here you can choose a specific date to export orders starting from the date.
End Date – Here you can choose a specific date to export orders up to the date.
Following is a screenshot of an exported CSV.
Once you complete the configurations you can click the Export Orders button.
From this window you can either import or export coupons. Bulk update option for coupons is also available.
Update coupons if exists – You can select the checkbox to update the coupon data in your store. Ie; if the coupon CSV contains coupons with the same ID as in the store those coupons will be updated.
Choose the CSV file containing the required coupon data and click the upload file and import button to import the data into your store.
By clicking on the Export Coupons button you will be able to export a CSV containing coupons. Filter options and column mapping are only available in the premium version of the Order/Coupon/Subscription Import Export plugin.
Following is a screenshot of an exported CSV of coupons.
From this section you will be able to find the documentation and sample CSV file that you can use to easily format CSV for the import of both orders and coupons.
Order management is a key component of any eCommerce business. Adding the Order/Coupon Import Export plugin to your store will make your business smooth by enabling easy management of hundreds and thousands of orders and coupons in your store.