This tutorial explains how to setup Order / Coupon / Subscription Export Import Plugin for WooCommerce. Please refer to the product page to know more about the plugin features.
Overview
Order / Coupon / Subscription Export Import plugin is an ideal plugin for exporting and importing orders/coupons/subscription orders to/from your WooCommerce store for migrating an existing online store.
Import Order / Coupon / Subscription
Orders: You can import orders from WooCommerce store as well as another e-commerce platform. It exports orders from WooCommerce store to the CSV file. You can import/export/merge(update existing order) hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information.
Coupons: You can import/export/merge(update existing order) hundreds, even thousands, of coupons using one CSV file which saves your effort and time of manually adding coupon information.
Subscription orders: Since the subscription involves a product, customer, payment gateway and an order, migrating subscription orders can be very difficult. But this plugin provides you an easy and flexible way to import the subscription orders. You can import/export/merge(update existing subscription order) hundreds, even thousands, of coupons using one CSV file which saves your effort and time of manually adding information.
You can map your import columns to the appropriate WooCommerce data to import or merge orders, coupons and subscription order. You can also import data from a variety of sources, such as an uploaded CSV file on FTP, locally saved CSV file to your computer.
For importing orders/coupons/subscription orders to your online store, you must create a CSV(Comma-Separated Values) file which contains information about mapping fields in a tabular form. You can create a CSV file by using a spreadsheet program, such as Excel, or Google Spreadsheets. Save this file with extension.CSV. After entering all details about orders/coupons/subscription orders in the spreadsheet, you can import to your online store.
Export Order / Coupon / Subscription
The plugin easily exports your WooCommerce shop orders, coupons, and subscription orders to CSV file with multiple powerful filters such as order status, date ranges, coupon types, subscription order status, etc. Even the plugin automatically upload your exports via FTP.
Order XML File Import Export
Order XML File Export Import for WooCommerce plugin allows you to easily export or update metadata of orders of your store into the XML file format required for printing the labels, shipment tracking, etc. by using Stamps.com/FedEx Desktop/UPS WorldShip/ Endicia Desktop Application. You can export/update existing hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information.
The plugin also exports individual orders from Orders listing page, export all orders or specified orders by offset/limit with a certain date range in bulk.
For updating orders to your online store, you must import XML file which is a reply from Stamps /FedEx Desktop/UPS WorldShip/ Endicia Desktop application which contains information about the orders (tracking number, postage cost, etc. ) along with the Order ID.
Pre-requisites
- For using Subscription Orders Import/Export, you must set up your WooCommerce online store with the following plugins:
- WooCommerce Subscriptions
- WooCommerce payment (Stripe, PayPal) Gateway
Installation
After purchasing the Order / Coupon / Subscription Export Import Plugin for WooCommerce, plugin Zip file is available in MY ACCOUNT.
- Navigate to My Account -> API Downloads tab and download the plugin.
Note: If you have Basic/Free version already installed, please Deactivate and Delete the Basic Version before installing Premium Version to avoid any conflict. Your plugin settings will be retained intact. - Install the downloaded plugin zip into your WordPress / WooCommerce Site.
- You get Activation Key and Activation Email at My Account -> API Keys.
- Go to your site Admin and the Settings page of the plugin and activate it using email and key.
For detailed information about installing Plugins, See How to Download, Install, Activate & Update WooCommerce Plugin?
Navigating to Order / Coupon / Subscription Export Import Plugin for WooCommerce
After installing the plugin, you can navigate to it as given below:
- Navigate to Plugins > Installed Plugins > Order / Coupon / Subscription Export Import Plugin for WooCommerce > Import Export link OR;
- Navigate to Dashboard > WooCommerce > Order Im-Ex or Coupon Im-Ex, Subscription Order Im-Ex, or Order XML Im-Ex as per requirement.
Order Coupon Subscription Import Export-Menu Navigation
Order tab
You can import orders from WooCommerce store as well as another e-commerce platform. It exports orders from WooCommerce store to the CSV file. You can import/export/merge(update existing order) hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information. For more information about Order Import / Export, please refer How to Import and Export WooCommerce Orders using Order / Coupon / Subscription Export Import Plugin?
Coupon tab
You can import Coupon from WooCommerce store as well as another e-commerce platform. It exports Coupon from WooCommerce store to the CSV file. You can import/export/merge(update existing Coupon) hundreds, even thousands, of Coupons using one file which saves your effort and time of manually adding Coupon information. For more information about Coupon Import / Export, please refer How to Import and Export WooCommerce Coupon using Order / Coupon / Subscription Export Import Plugin?
Subscription Order tab
You can import Subscription Order from WooCommerce store as well as another e-commerce platform. It exports Subscription Orders from WooCommerce store to the CSV file. You can import/export/merge (update existing) hundreds, even thousands, of Subscription Orders using one file which saves your effort and time of manually adding Subscription Order information. For more information about Subscription Order Import / Export, please refer How to Import and Export WooCommerce Coupon using Order / Coupon / Subscription Export Import Plugin?
Order XML tab
Order XML File Export Import for WooCommerce plugin allows you to easily export or update metadata of orders of your store into the XML file format required for printing the labels, shipment tracking, etc. by using Desktop Application. You can export/update existing hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information. The available methods are as given below:
- WooCommerce: For more information, see How to Export and Import Orders XML from WooCommerce using Order / Coupon / Subscription Export Import Plugin.
- Stamps.com: For more information, see How to Export and Import Orders XML from Stamps.com using Order / Coupon / Subscription Export Import Plugin for WooCommerce.
- FedEx: For more information, see How to Export and Import Orders XML from FedEx using Order / Coupon / Subscription Export Import Plugin for WooCommerce.
- UPS WorldShip: For more information, see How to Export and Import Orders XML from UPS WorldShip using Order / Coupon / Subscription Export Import Plugin for WooCommerce.
- Endicia: For more information, see
How to Export and Import Orders XML from Endicia using Order / Coupon / Subscription Export Import Plugin for WooCommerce.
Help Guide tab
Under the Help Guide tab, you can find sample Export and Import files with documentation links as shown below:
Import/Export Settings tab
Under the import/export settings menu tab, you can set the FTP settings to export Order / Coupon / Subscription as well as XML/URL Orders. Also, you can auto-export / import the Order, Coupon, Subscription, Order XML and Order URL.
The Import/Export settings tab is further subdivided into Order CSV, Subscription, Coupon, Order XML and Order URL with respective FTP settings.
The FTP Settings for Import/Export (Order CSV) is as shown below:
WooCommerce Order Coupon Subscription Import Export Settings
- Select the checkbox to enable FTP import/export Orders.
- Enter FTP Server Host/IP.
- Enter FTP User Name.
- Enter FTP Password.
- Enter FTP Port.
- Select Use FTPS checkbox to connect securely.
- Enable this checkbox to send data over a network with SSL encryption.
- To Enable FTP in Passive mode, tick this checkbox.
- Test FTP button ensures a successful FTP connection.
- Specify the path in the server to which the CSV file will be exported in the Export Path field
- Specify the name of the CSV file to be exported in the Export Filename field
- Export Settings:
- Choose the Enable option to Automatically Export Orders from FTP Server Host/IP.
- Enter the required Export Start time for exporting the Orders.
- Enter the time interval in minutes for exporting Orders.
- Exclude already exported
- Export line items into separate columns
- Include hidden metadata
- Orders with the selected status will be exported.
- Orders of selected Products will only be exported.
- Order dates mentioned between these dates will be exported.
- Import Settings:
- Choose the Enabled option to Automatically Import Orders from FTP Server Host/IP.
- Check this option to import multiple CSV files.
- Enter complete CSV path to import multiple files and also include the filename in case of a single file in the import file field.
- If the user (customer) belonging to an order doesn’t exist in the target site, a new user will be created if Create user option is checked. Leave this option unchecked if you do not want new users to be created.
- By default, a comma is taken as the delimiter. If any other delimiter like a semicolon is used in your CSV, you may specify it in this field.
- Enter the required Import Start time for importing the Orders.
- Enter the time interval in minutes for importing Orders.
- Select Update Orders if exist checkbox to merge existing orders with the updated details. The Merging is possible only if the ID of order already exists in your online store. Otherwise, the order is imported as a new one.
If the Update Orders if exist field is not checked while importing and if the IDs of the importing orders already exists in the store, the orders will be imported with a new ID. Otherwise, if the original order ID does not exist in the store, the ID for the order will be retained after the import. - Select a required mapping file from the Select a mapping file drop-down list if it was previously created.
- Click Save Settings to save settings.
For more information about corn job, please refer Setting Up The Cron Job.
Similarly, you can set the FTP settings for import and export of coupon, subscription order, and XML order by clicking on its corresponding options.
Delete Trashed Orders / all Orders/ all Coupons
As an Admin, you can delete the Trashed Orders, all orders, or all Coupons in a click. To do this, navigate to Dashboard > WooCommerce > System Status > Tools. It appears as shown below:
Order Coupon Subscription Import Export-Status-Tools
- Delete Trashed Orders: Click Delete Trashed Orders button to remove all the trashed orders.
- Delete Orders: Click Delete Orders button to remove all the orders from the online store allowing you to start with fresh orders.
- Delete Coupons: Click Delete All Coupons to remove all the coupons from the online store allowing you to start with fresh coupons.
- Delete Trashed Subscription Orders: Click Delete Trashed Subscription Orders button to remove all the trashed subscription orders.
- Delete Subscription Orders: Click Delete Subscription Orders button to remove all the subscription orders from the online store allowing you to start with fresh orders.
Check out our Order / Coupon / Subscription Export Import Plugin for WooCommerce.
Comments (27)
jamie
June 3, 2020
Looking to get started with importing orders with csv. not able to download or view the sample doc. any special instructions for that? or best / simplest way to create a CSV template to get started.
Alan
June 5, 2020
Hi,
Here is the link to the sample order CSV file: https://www.webtoffee.com/wp-content/uploads/2016/09/Order_Sample_CSV.csv
You can also get the sample template CSV file by exporting an order from your site using the plugin.
Luca
May 27, 2020
Is there a way to export only a certain state order? Like only processing or completed?
Alan
May 28, 2020
Hi,
Yes, using the premium version of the plugin you can filter the order export based on the order status.
Eugene
April 17, 2020
Hello there,
Looking for an export solution from Woocommerce and this is great, but in the csv templates I can see orders with single products only. Does your plugin supports exporting orders with multiple items(lines) and where I can find the template for that to check if it’s suitable for my ERP?
Alan
April 17, 2020
Hi,
Yes, the plugin supports exporting orders containing multiple order items. Here is the sample CSV file containing multiple items in an order.
eugene
April 17, 2020
Thanks! Appreciate! 😉
Eugene
April 20, 2020
Hello again, Alan. One more question – is it possible to export ‘order lines’ each in new line/row(not colun)?
What I am looking for, for the file with order to look like this:
006(sku), 1(qty), 56(price)
B11V2(sku), 5(qty), 111(price)… etc.
We are willing to automatically create orders in our ERP, but parsing order lines where everything is in one cell is not a good idea. Any suggestions?
Mariana Florea
May 28, 2020
I am looking for the exactly the same functionality (like in the Advanced Order Export For WooCommerce plugin from Algol, which, however, does not have import)
Alan
May 28, 2020
Hi,
We can provide you with a custom code snippet for the premium version of the plugin so that you can export the line items into separate rows instead of separate columns. Please reach us via support.
Warren
January 15, 2020
When I try to export orders I get the following message
This site can’t be reachedThe webpage at “site url”/wp-admin/admin.php?page=wf_woocommerce_order_im_ex&action=export might be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE
Alan
January 15, 2020
Hi,
We are able to export the orders without any issues in our test environments. The issue you are facing on your site might be due to some site-specific issues. Could you please reach us via support.
Michaël
November 7, 2019
Hi
I’m trying to import my coupon with you plugin. My coupon have lower and upper case. The plugin convert every thing in lower case. Is it possible to have them not converted?
Thanks!
Alan
November 8, 2019
Hi,
Our plugin supports importing coupons having both lower and upper case letters. Please note that in the coupon list page all the coupon codes will be displayed in lower case letters. Please try opening/editing the imported coupon where you can see the correct imported coupon code.
If the issue still persists please reach us via support.
michael
November 8, 2019
That’s true, when I click on the coupon, it appears lowercase!
Thanks
Fredrick Housel
October 21, 2019
Hi,
I tried this out and it works mostly, but the few latest orders aren’t importing. In the log it looks like there’s a conflict with the importer trying to import some html and css… I checked the .csv file, there was some at the bottom, but even after cleaning that up, it still won’t import the newest orders. Not sure where it’s getting the html/css stuff.
Alan
October 22, 2019
Hi,
Please reach us via support and share with us the CSV file you are importing. Our support team will follow you up from there.
Ajay
April 11, 2019
Hi
We’re looking to use this plug in for exporting orders with several hundred order lines per order. Is there a way that we can export so that the products can be grouped so that the rows are the products and the columns are the customers? We would want to choose an order range.
Alan
April 11, 2019
Hi Ajay,
Please share us a sample CSV file with the format you would like to have in the exported CSV. Please reach us via support.
jeremy.shreve
April 4, 2019
I am trying to use the export feature, but it is not exporting anything from my woocommerce addons (I use “check-out add’ons” plugin for woocommerce to add fields like “How did you hear about us?” and I need that data included in my export.
Alan
April 4, 2019
Hi,
If you are using any third party plugin to create custom fields to the orders it will be stored as metadata. You may please export the orders with the option include hidden metadata checked and the custom metadata fields will be included in the exported CSV.
Fatma
June 15, 2018
csv export not included weight but i need that with export how i can add weight colums in export as well ?
Mark
June 18, 2018
Hi Fatma,
By default, WooCommerce won’t store or display order total weight with the order details. Are you using any code snippet to do it? If yes, we can develop custom code snippet to export the data into the CSV if you provide corresponding meta key in which you are storing the data.
Please reach us via support.
Erik
February 10, 2018
I’ve done some own columns in the check out form. Is it possible to get them as well when I export the order to a CSV.file?
Karen
February 1, 2018
I’m sure this question is answered somewhere… but I’m not sure whether to use the API key on our existing site that I’m exporting from? Or our staging site (which in a few month’s will be the production site) that I’m importing / merging into?
loison
October 20, 2017
Where can I find exported orders?
Anindo
October 21, 2017
Hi loison,
The exported orders will be downloaded as a csv.
Or if you have an FTP connection setup, then your file will be downloaded in the FTP location.