Order / Coupon / Subscription Export Import Plugin for WooCommerce

Clear
4.69 out of 5

  • Compatible with WooCommerce 3.0.
  • You are protected by our 30 Day Money Back Guarantee.
Sold By: XAdapter
  • Description
  • Changelog
  • Reviews (13)
  • FAQ (5)
  • Comments (93)

This is perfect tool if you are migrating to or from an existing WooCommerce shop, allowing you to maintain your order history including subscription orders. Plugin will even allow you to migrate thousands of coupons from your old eCommerce platform or campaigns. WooCommerce Export Orders is the most used functionality of this plugin

What can Order / Coupon / Subscription Export Import Plugin do?

  • Import & Export WooCommerce Orders to CSV file.
  • Import & Export Subscription Orders to CSV file.
  • Import & Export Coupons to CSV file.
  • Scheduled Import and Export via FTP using Cron Job.

How does it work?
The Order / Coupon / Subscription Export Import Plugin’s simple interface makes it extremely easy to map the data in your CSV file to the appropriate fields in WooCommerce. The plugin supports Custom Fields, Custom Post Types, dates, and pretty much every other WooCommerce Order / Subscription / Coupon field.

Our Plugin is designed to be efficient with large imports as it splits large import files into smaller chunks, making it possible to import large files with thousands of data and records, even on slow hosting providers.

Main Features

Import: You can use the import functionality to:

  • Import by selecting file from your computer.
  • Import the file from a remote server via FTP.

Taking example of importing orders, you first need CSV file with orders details. Import this CSV file by using Import Orders option and map the required fields. This imports orders to your online store with Line Items, Customer details, Order total, etc.

Export: With this feature, you can export and download order / coupon / subscription details as a CSV file on your computer or on FTP server. You can select the starting order row number, the maximum number of orders, start date, end date, and status as criteria while exporting orders.

Merge: This feature is useful to add more information/update existing data. When your existing data need to be modified, you can update it by importing updated CSV file to get the latest details into your store.

Map and Transform: You can map the fields (WooCommerce fields) with column headings( CSV file header). For mapping, select the required field under Column Header by using the drop-down list for a particular Map to field. An Evaluation field is used to fix/update the required value for a particular field.

Bulk Export Selected: For example, In order listing page you can download selected orders with Download as CSV option from Bulk Action List.

Single Export: For example, You can export single order by using Download to CSV button or by selecting single order and applying Download as CSV option from the action list. It helps you to download that particular order into the CSV file.

Cron Job / Scheduled Import & Export: Plugin facilitates to schedule the Import and Export. You can auto import the Orders, Subscriptions Orders and Coupons at regular intervals from CSV which is present on FTP Server by providing starting time and intervals between import. You can also auto export the products to FTP in a CSV file at regular intervals.

Additonal Features

Exporting Orders to Service Providers in XML Format.

Our Plugin helps you to easily export WooCommerce bulk order data in XML format supported by respective Service Providers. Using exported XML, you will be able to import the orders to the Service Provider very easily with no time spent on manual efforts. It also provides option to export XML using WooCommerce format, using which you will be able to import the orders to another WooCommerce website.

Importing Order meta to WooCommerce site using XML exported from Stamps.com.

The exported XML File metadata exported from Stamps.com includes,

  • Actual Mailing Date.
  • Desired Mailing Date.
  • Hide Postage Amount.
  • Mail Class.
  • Mail Piece.
  • Postage Cost Mail Class.
  • Postage Cost Total.
  • Ship Method.
  • Tracking Number.
  • Tracking Service.
  • Weight Oz.

Importing Order meta to WooCommerce site using XML exported from UPS WorldShip & FedEx.

The exported XML File metadata exported from UPS WorldShip & FedEx includes,

  • Reply Header.
  • Customer Transaction Identifier.
  • Dim Weight Used.
  • Rate Scale.
  • Rate Zone.
  • Currency Code.
  • Billed Weight.
  • Base Charge.
  • Total Discount.
  • Surcharges Fuel.
  • Surcharges Other.
  • Total Surcharge.
  • Net Charge.
  • Total Rebate.

Importing Order meta to WooCommerce site using XML exported from Endicia.

The exported XML File metadata exported from Endicia includes,

  • Record ID.
  • Account.
  • Device ID.
  • Account Name.
  • Transaction ID.
  • Transaction Date & Time.
  • Status.
  • Transaction Type.
  • Account Balance.
  • Postmark Date & Time.
  • To Address.
  • To PostalCode.
  • Final Postage.
  • Mail Class.
  • Services USPS Tracking.
  • Weight Oz.
  • Tracking Number (PIC).
  • Description.
  • Value.
  • Cost Center.
  • Insurance.
  • Reply Postage.
  • Reprinted.
  • Customs Content Type.

Screenshots

Order Export Settings
Subscription Export Settings
Coupon Export Settings
Order Import Settings
Subscription Import Settings
Coupon Import Settings
Order Page – XML Export Menu

Last Updated: 03-Augast-2017

= 2.2.0 =
* PHP7 compatibility Tested OK
= 2.1.9 =
* Fix for HTML order notes import
= 2.1.8 =
* Bug fix for WC date format issue.
= 2.1.7 =
* Bug Fix.
= 2.1.6 =
* UPS XML Format updates
* Bug fix in order XML export date format.
= 2.1.5 =
* Added option for enable/disable Passive Mode while exporting/import via FTP.
= 2.1.3 =
* UPS XML export updated to latest WorldShip format (20.0.20).
= 2.1.2 =
* Compatibility updates for WooCommerce 3.0.3.
= 2.1.1 =
* Compatibility updates for WooCommerce 2.7.
= 2.1.0 =
* UPS order XML export format updates.
= 2.0.9 =
* Scheduled Order import updates.
= 2.0.8 =
* Coupon import/export updates.
= 2.0.7 =
* Order and user connection data modifications.
= 2.0.6 =
* mime_content type changes for PHP 5.2.9.
= 2.0.4 =
* Bug fix for UPS XML incorrect formatting.
= 2.0.3 =
* UI Change: Replaced order details separate options to a grouped option.
= 2.0.2 =
* Bug Fix: Corrected Order XML Formats of Fedex, Endicia, stamps, and WooCommerce.
= 2.0.1 =
* Bug Fix: Updated UPS XML to new UPS Worldship format.
= 2.0.0 =
* Merged with Order XML Import Export plugin.
= 1.4.3 =
*Bulk delete option modifications in WC Tools.
= 1.4.2 =
* Minimal fields order update fix.
= 1.4.1 =
* UI Updates.
= 1.4.0 =
* Updates orders with minimal fields.
= 1.3.9 =
* select all / unselect all option for columns in export screen in order/coupon/subscription plugin.
= 1.3.7 =
* Payment method meta updates on subscription import.
= 1.3.6 =
* order notes type updates fixes ( private / customer note ).
= 1.3.5 =
* Minor content update.
= 1.3.2 =
* Bug Fix.
= 1.3.1 =
* Added feature to import subscription meta data.
= 1.3.0 =
* Improvements on Coupon import and export.
= 1.2.8 =
* coupon usage count import export updates.
= 1.2.7 =
* Enhancement for additional meta with coupon export.
= 1.2.5 =
* Feature: Support URL URL Coupons in coupon import export.
= 1.2.4 =
* Enhancement: Quantity added in order line items export.
= 1.2.3 =
* Enhancement: Option to import order line items either by ID or SKU.
= 1.2.2 =
* Date Evaluation enhancements.
= 1.2.1 =
* Create user with order details if user not exist.
* Export settings tab updates.
= 1.1.9 =
* Security Improvements.
* UI improvement on Settings Page.
* Updated License Code.
= 1.1.5 =
* Stability improvements for subscription order import export.
= 1.1.4 =
* New Feature: Coupon Export Import.
* New Feature: Subscription Order Export Import.
= 1.1.2 =
* Added activation key.
* Generalized header and data filter of CSV.
= 1.1.0 =
* Added filter to support Role export.
= 1.0.9 =
* Updated support for Shipping fields.
* Suggest import to keep the given ID.
* Moved line items to last of CSV on export.
= 1.0.6 =
* New feature which will allow to change date format while mapping.
= 1.0.5 =
* Stability improvements.
= 1.0.2 =
* Moved custom meta data to end of CSV while export.
= 1.0.1 =
* Provision for adding extra meta.
= 1.0.0 =
* Initial version.
* Transform and map feature.
* Bulk export option in order listing page.

13 reviews for Order / Coupon / Subscription Export Import Plugin for WooCommerce

  1. Charles
    1 out of 5

    (verified owner)

    After 12 days of back and forth with support, I’m totally fed up. This plugin doesn’t work as described, is poorly made and the support has been useless. Worse, as soon as I started asking for my money back, they went silent on me. Go with All Import or something else and avoid these guys!

    • Anindo

      Hi Charles,

      We sincerely regret the inconvenience caused to you.
      Our team is already in communication with you. They have suggested to use the merge option.

      We request you to be in communication with our support team and show patience. We are confident that your problem will be resolved.

  2. John
    5 out of 5

    (verified owner)

    Great Support..

    I had an issue with my licence key that was sorted within minutes.. Thanks again for a perfect product and perfect support!

  3. Greg
    5 out of 5

    (verified owner)

    It’s better than woocommerce’s Skyverge import plugin which cant handle datestamps correctly. It also exports in a format more compatible with woocommerce order import than the alternatives which is strange but true. Keep up the good work.

  4. milosh
    5 out of 5

    (verified owner)

    Very good and useful plugin. I believe it can be even better with more flexible export filters.
    Amazing support, definitely made my day.

  5. Matthew
    5 out of 5

    (verified owner)

    A fantastic plugin which really delivers against my need to bulk import (and regularly update) subscriptions and orders. Nothing else like it in the marketplace. Outstanding support too 10/10!

  6. Drew
    5 out of 5

    (verified owner)

    We are using version 2.1.1 and for some reason the exported UPS WorldShip XML format did not match what WorldShip 2017 requires. Since I first contacted support, they have provided prompt replies and wrote custom code to get the plugin working for my site. I’m impressed that they spent the time to get the plugin working instead of telling me to purchase another plugin. I look forward to future updates so the plugin works out of the box.

  7. Jeremy
    5 out of 5

    (verified owner)

    Great support so far using this plugin, you certainly get what you pay for with this plugin

  8. David Furland
    5 out of 5

    (verified owner)

    What a great plugin. Really easy to use, and an OUTSTANDING support. Great.
    They really saved me.

  9. 5 out of 5

    I am a website developer which implemented this plugin into a client’s website. The plugin extremely simple to use and the setup was extremely simple. The support for extra functionality has been brilliant and i believe with future updates this plugin will be the best in the market, for example exporting to csv with permanent custom headers. I highly recommend this plugin to other developers looking for a woocommerce export to csv plugin.

  10. Jeroen
    5 out of 5

    (verified owner)

    This plugin helped me with a big problem: getting the right order information out of an old backup into a new site. Though there were problems along the way with different fields, Mark helped me as long as it took to get everything right.
    Great support!

  11. Scott
    5 out of 5

    (verified owner)

    This plugin developed the world’s best people and support staff – just incredible. For my needs, Mark and the team did update the plugin for the first time, allowing you to import custom date value, and Mark has worked with me almost all day to import the values in the custom field. The team that works on these plug-ins – are true professionals and great guys.

  12. Alex
    5 out of 5

    (verified owner)

    Plugin is great….but Support is 100 times better then plugin.

  13. Curtis
    5 out of 5

    (verified owner)

    Great Plugin.. Outstanding support.. You made my day!!!


Only logged in customers who have purchased this product may leave a review.

Frequently Asked Questions

Yes. It has provision to export order additional meta tags.

Yes. We have a support team working on for fixing any issues related with plugin.

Yes. Contact us.

Set up process is simple. Please refer the link to tutorial.


  • partounian

    partounian - 2 months ago

    Any plans to support SFTP?

  • Arthur

    Arthur - 2 months ago

    I have an order csv that i want to import, but the line items, the most important part, are no being imported. When I go to the import screen, there's no place to map the lime_item_1 header. Here's an example of my csv. usernames, emails, and names have been replaced for confidentiality purposes. https://www.dropbox.com/s/om44rfzlcbs1dsl/test%20transactions-5%20example.csv?dl=0 How can I get my line items to import? And how can I get the importer to have a field to map the line_items? they seem to be in the right format. thanks.

  • Anindo

    Anindo - 2 months ago

    Hi Arthur, No need to map line items while importing. It will automatically be imported Please check line_item column in sample Order CSV - https://www.xadapter.com/how-to-import-and-export-woocommerce-orders-using-order-coupon-subscription-export-import-plugin/ This will resolve your problem. Regards, Ando

  • Arthur

    Arthur - 2 months ago

    Now I have another problem. The prices are importing, but they are not being tied with an official product in my store. Here is an example of a line item of one of the orders: name:英語コーチング |product_id:3795 |quantity:1 |total:15000.00 |refunded:0.00 |tax:0.00 And this is what it looks like when imported. https://snag.gy/Ryo0h3.jpg The name isnt being imported, even though there is a product with the same name and ID in my store. Here are couple ideas why I think this could happen: 1. The product name is in Japanese If this is the case, is there a workaround? 2. The price in the CSV doesnt match any of the prices for the product in the store. If this is the case, is there a work around? 3. The product is a variable product and that isnt reflected in the CSV. If this is the case, what is the correct syntax for line items in the CSV for orders to get connected with products?

  • Anindo

    Anindo - 2 months ago

    Hi Arthur, Did you make any adjustments to the csv? Can you share the new csv?

  • Arthur

    Arthur - 2 months ago

    Sure, here it is https://www.dropbox.com/s/gq0d59yycjyo6p5/test-transactions-14%20copy.csv?dl=0

  • Anindo

    Anindo - 2 months ago

    Hi Arthur, Kindly check whether the product ids are correct. This problem comes when the product id associated with the line item is incorrect. Else, you can use SKU in the line items field and try. Here is the sample csv link which has the SKU in line items - https://www.xadapter.com/how-to-import-and-export-woocommerce-orders-using-order-coupon-subscription-export-import-plugin/

  • Arthur

    Arthur - 2 months ago

    his is really strange. Here is a link to my CSV https://www.dropbox.com/s/n8xdj20ukj09xgy/test-transactions-21.csv?dl=0 Row 2 imported with only the product ID and name, not SKU https://snag.gy/U1uILl.jpg name:英語コーチング |sku:3798|product_id:3795 |quantity:1 |total:15000.00 |refunded:0.00 |tax:0.00 Line Item: Row 3 didn't import at all https://snag.gy/2SXQyx.jpg Line Item:product_id:3795|quantity:1|total:13000|name:Eigo Coaching 2 Times Per Week(¥13000)|sku:3796| Row 4 didn't import at all https://snag.gy/UlJLvE.jpg Line Item:product_id:3795|quantity:1|total:13000|name:英語コーチング|sku:3796| Row 5 imported ok but the product code and variation code are the same https://snag.gy/qWcGBJ.jpg Line Item:product_id:3795|quantity:1|sku:3796| Here is my product info: https://snag.gy/YzyZp4.jpg One thing: I tried using the sku at the end without the pipe, but it made that become the price instead. So I put the pipe on the end and it seemed to work a little. Please tell me: 1) the items I need in order for a line item to read correctly 2) the order those items need to be in I really want to get this out of the way, I have almost 1000 orders that I need to get in the right order.

  • Veeresh

    Veeresh - 2 months ago

    Hello Arthur, We regret the inconvenience caused. Let us know What error messages you received for not imported orders? Please raise a request here HERE and share your Sample CSV. We will replicate on our site and let you know how to fix it. Hope that helps. Thank you for your cooperation. Regards, Veeresh

  • James

    James - 2 months ago

    Hello xadapter team, Great plugin by the way and everything goes well with import/export Orders. But beside of the great things we have only one issue with the import process that we'll need your help. Below it's what we need: After creating the CSV table I set "0" value to "customer_id" and "customer_user" columns for all the orders that I wanted to import them. But the import process adds new users based on email found in the order and we don't want to force users to have an account also to skip removing them after import because we have like more then 1k of orders that doesn't have users associated. Also I tried to change the code used for import in "class-wf-orderimpexpcsv-order-import.php" that adds users and I did a quick trick to force the if condition pushing new users but now the import process handle like 200 orders and after stops. Below it's what I changed from mentioned .php file:
    // $user_id = $this->hf_check_customer($meta_array, $email_customer);
    $user_id = true;
    Anyway I know that is not the best approach but I wanted to skip posting here what issue I encountered. I'm hoping you have a good solution to fix the import process for the guest orders and in this way I can import my orders. Thank you!


GET STARTED
You are protected by our 30 Day Money Back Guarantee.     Add to cart