Subtotal $0.00

Total $0.00
You have no items in your shopping cart.
Extensions Services About Us Blog Login Sign Up Get Support

Orders Export and Import

5 Created with Sketch.
A flexible tool for exporting/importing Orders from/to Magento. Easily transfer data to another installation or third-party software. If customer data is missing, the extension will restore it automatically from the billing address.
Compatible with
Community 1.3.2.4 - 1.9.2.3
Community
Enterprise
  • 1. Free updates for 6 months
  • 2. Free email support
  • 3. 30-day money back
QtyYou can use this extension on one live Magento host and unlimited test hosts.

Orders Export and Import for Enterprise Edition

5 Created with Sketch.
A flexible tool for exporting/importing Orders from/to Magento. Easily transfer data to another installation or third-party software. If customer data is missing, the extension will restore it automatically from the billing address.
Compatible with
Enterprise 1.8.0.0 - 1.14.2.1
Community
Enterprise
  • 1. Free updates for 12 months
  • 2. Free email support
  • 3. Free bugfixes for life
  • 4. 30-day money back
  • 5. PRO installation included  
    Professional installation by the Aitoc team (paid for CE-version users) is included into every Magento Enterprise extension package. To schedule the installation please email us at magsupport@aitoc.com.
QtyYou can use this extension on one live Magento host and unlimited test hosts.

Why Use Orders Export and Import

  1. Export/import data when migrating to another Magento installation, ERP system or accounting software.
  2. Merge several Magento stores into one with no hassle at all.
  3. Restore missing customer data from the billing info.

What You Can Export/Import

  1. Orders, Order addresses, Order payments, Payment transactions, Order status history.
  2. Invoices, Invoice comments or Invoice items.
  3. Shipments, Shipment comments, Shipped items, Shipments tracking.
  4. Credit Memos, Credit Memo comments, Credit Memo items.
  5. Checkout fields.

You Can Export Orders:

  1. Based on Order status.
  2. Based on Order number.
  3. Based on Order placement date.
  4. Based in Customer ID and/or Product ID.
  5. After the checkout is complete.
  6. After an invoice is created for all products in the Order.
  7. Automatically - upon checkout or invoice creation.

Formats & Other Features

  1. Export data via remote FTP or email.
  2. Perform automatic export via Cron.
  3. Use CSV/Tab Separated or XML (recommended) formats.
  4. Define Order fields to be exported.
  5. If an Order is missing Customer data, it’s restored from the billing info.
  6. Upload an XSL template file for transferring Orders to third-party software.
  7. Import Orders to specific Magento Stores.
  8. Work with multiple currencies (export / import the base currency and the currency the Order has been placed in).

Keeping Track of Export/Import

  1. See a history of imported and exported Orders.
  2. Get a log of errors that occurred during the import.
  3. Interrupt Order import is an error occurs.
  4. Configure import behavior (add, replace or delete data for matching Orders).
  5. Export only Orders that haven’t been exported yet from a specific selection.

If you need to export from Magento Comminuty to Magento Enterprise, and you need two versions of the product - get an automatic discount in the shopping cart when you’re buying both versions of the extension!

Request a new feature

Changelog

+ stands for new feature added
* stands for bugfix


November 5, 2015 (ver. 1.2.11)

+ The extension is compatible with Magento 1.9.2.2 / SUPEE-6788 patch.

October 12, 2015 (ver. 1.2.10)

* Fixed incompatibility with Magento patch SUPEE-6285 for sub-admin with restricted resources.

September 3, 2015 (ver. 1.2.9)

+ Compatible with Magento 1.9.2.1.

November 27, 2014 (ver. 1.2.9)

+ Compatible with Magento 1.9.1.1.

August 21, 2014 (ver. 1.2.9)

* Issue with customer creation based on billing address during order import is fixed.

July 28, 2014 (ver. 1.2.8)

* Incompatibility issue with Checkout Fields Manager is fixed.

June 4, 2014 (ver. 1.2.7)

* Issue with incorrect date conversion from different magento locales is fixed.

June 2, 2014 (ver. 1.2.6)

* Bug with the configurable products import is fixed.

May 14, 2014 (ver. 1.2.5)

+ The extension is compatible with Magento 1.9.0.1

December 18, 2013 (ver. 1.2.5)

+ The extension is compatible with Magento 1.8.1.0

October 1,  2013 (ver. 1.2.4)

* Fixed the issue with wrong transaction date;

September 27, 2013 (ver. 1.2.3)

+ The extension is compatible with Magento 1.8.0.0
* Fixed the issue with importing configurable products;

September 12, 2013 (ver. 1.2.2)

* Fixed the issue with importing configurable products;

July 26, 2013 (ver. 1.2.0)

+ Multi-profile for export is now added;

June 10, 2013 (ver. 1.1.7)

* Fixed the issue with missed auto-export orders after changes status of order;

January 17, 2013 (ver. 1.1.5)

* Fixed several issues. Extension stability is improved. The extension now ignores the missing fields. Cancel action;

September 24, 2012 (ver. 1.1.4)

* Fixed the issue with automatic export by cron via ftp;

August 16, 2012 (ver. 1.1.3)

+ The extension now works for Magento 1.7.0.1 and Magento 1.7.0.2.

August 6, 2012 (ver. 1.1.3)

* Values are now exported through tabulation when the delimeter is set to \t;
* Comments history notes, invoices, shipments and credit memos now all have correct dates of creation after import.

July 18, 2012 (ver. 1.1.2)

* The crash when viewing export history in Magento 1.4.1.0 is now fixed;
* The extension now works correctly with locales other than en_US.

July 16, 2012 (ver. 1.1.1)

+ Allows for importing specific orders into specific stores based on store ID in the import file;
* Automatic export after the checkout now works for Email and Remote FTP export;
* track_number field now appears when exporting order from Magento 1.4-1.5 and importing it to Magento 1.6 and up.

May 29, 2012 (ver. 1.1.0)

* Any number of orders is now exported and imported correctly;
* Orders with payment transactions are now exported and imported without crashing;
* The fatal error which happened during the import when Magento is in developer's mode if now fixed;
* Orders with names containing symbols like ®,&0000195;, are now exported and imported.

April 27, 2012 (ver. 1.0.7)

+ The extension is compatible with Magento 1.7.0.0.

April 20, 2012 (ver. 1.0.7)

* Deleting orders through import history now works correctly for Magento 1.3.2.4;
* The date of the order is now exported and imported correctly for Magento versions lower than 1.4.1.0;

April 18, 2012 (ver. 1.0.6)

* Orders from CSV files for Magento 1.3 are now imported correctly;
* Fatal error now doesn't occur when the extension is installed on Magento 1.3.2.4;

April 03, 2012 (ver. 1.0.4)

* Delivery Date field now is exported correctly when the option "Automatically export order after checkout" is set to "YES";

March 26, 2012 (ver. 1.0.3)

* Importing from Magento with custom payment systems to Magento now works correctly;

March 13, 2012 (ver. 1.0.2)

* Import now works correctly for orders with "complete", "processing" and "closed" statuses;
* XML order exporting and importing now works correctly for Magento 1.3.2.4;

March 2, 2012 (ver. 1.0.1)

* AITOC Order Export and AITOC Order Import tabs are now displayed for all configuration

January 25, 2012 (ver. 1.0.0)

+ The extension has been launched for the community version of Magento;

19 Customer Reviews

  • Francesco Astorino,
    Jun 15, 2015

    One of the best import tool for orders out there. It does exactly what's required. I submitted some feature requests to the support team and they promised to add them to the next updates. Amazing feedback. Thankk you guys for this great extension. Greetings from Italy.

  • DomT,
    Nov 19, 2014
    on

    Great Extension and support. Saved me a LOT of time. We migrated from 1.7 to 1.9.01 and had few hunderd orders to move over. Worked perfectly. Very simple set up but very effective. Deffinitely recomend.

  • this is the one to get,
    Nov 3, 2014

    Great tool that creates customers as it imports orders. Great documentation as well. Had one issue and Victor was gracious with his time and support. I use this as well as the product import/exports and all are top notch.

  • dunno,
    Oct 7, 2014
    on

    Incredibly perfect! The import from Magento 1.4 to 1.9 worked perfectly. It solved us so many issues and was an incredible tool to keep developing the upgraded site, leaving the old online since the last second. Orders match, invoices match, credit notes match, shipping data match and all the comments match too. Honestly we were expecting at least some partial loss of data and it was a surprise to see that all has been perfect and really fast. Thanks to the team for helping us solve a little issue with the installation that was totally our fault. If you are upgrading your site and you can't turn it down for hours and hours, that's the product you need.

  • Darren Scott,
    Aug 27, 2014

    I am not one to write reviews, however, this module was awesome. I was integrating 2 websites into a third and wanted to keep all the orders, credit memos etc in one place. This extension was easy to use and most of all fast! Thanks!

  • Ben,
    Jul 15, 2014

    We have been using Orders Export and Import for over 1 year. I use it to export all orders by email to a dedicated email account. I then have another program retrieve the email and import the order details into our dinosaur inventory / order processing software that has terrible order import options. We only had one issue with the software in that time due to some changes at our hosting server and support was quick to help solve the problem. The software itself was easy for me to learn and has every feature I could ask for. Highly recommended!

  • Great product,
    Jul 8, 2014

    For my client I had to export orders from Magento 1.4 and import them to Magento 1.8. This works perfectly! You will get a logfile before you import, so you can see what might be a problem with the import.

  • starpunjabi,
    Mar 13, 2014
    on

    extension is very usefull if you want to export import products in various versions of magento, they also provide support in best way. i recommend it

  • brunotallarico,
    Dec 11, 2013
    on

    Great extension, functioned perfectly in Magento 1.7. Very quick and helpful support. Highly recommend.

  • Anonymous,
    Oct 31, 2013
    on

    This extension was very easy to install and very simple to use. The Aitoc support team are extremely helpful and were replying to me in under 5 minutes. I would definitely recommend any product from Aitoc!

  • andrea81it,
    Sep 1, 2013
    on

    This is an amazing extension. Easy installation and setup, it can save you time: I was considering to take care by myself of the orders migration between two Magento installations, but after a short time I realized it would be a massacre! :-) After a while from migration I have noticed that it was impossible to place orders and invoices: two nights of debugging led me to realize that logs where full of exception caused by integrity constraint violation on tables related to orders and sales. The bad surprise was that indexes in eav_entity_store were not updated to new order ids, so i had to manually increase them based on the last migrated order/invoice id. It was one of the most difficult bug fix in my career on Magento...I'll not forget easily.

  • envisagetech,
    Jun 9, 2013
    on

    Fantastic tool. We had to export and import all the orders from the magento db while migrating from one system to another, and this tool did exactly what we were looking for.

  • Ky Bluff,
    Jun 4, 2013

    Look, I was really bummed that I couldn't just dump sql and upload the orders to my clients new site. It seems like a huge disconnect with upgrading Magento platforms. So basically I landed on this site 4 different times wile googling everything I could to get a solution for transferring orders and finally realized im losing myself money waisting any more time searching. So I purchased this extension and it is done within 10 minutes. If you're wondering it if works or if its worth it. Just buy it. You'll keep a clean database for your new install and you'll be done reading the Magento boards looking for migration tips. Take it from a guy who hates writing reviews and never buy extensions from developers I'v never worked with. This one is a diamond in the ruff and Im so stoked im actually writing a review. Well done guys! Thank you Thank you!

  • Jeff Minor - CTO - Goedekers.com,
    Apr 18, 2013

    Amazing extension. We had 50,000 orders we had to find an easy, uniform way to port over from our old platform to Magento. Once we got a template set up to quickly get the CSVs constructed, this extension worked like a charm. AITOC was a lifesiver!

  • Great plugin!,
    Apr 15, 2013

    I at first was a little hesitant on this plugin due to some of the reviews, but after researching a number of plugins, it was the best choice for me to resolve the import issue I had to resolve in dealing with MOM. I must say that I couldn't have been happier! I had to perform order mappings from another database and Magento and this worked as expected. I had a couple hiccups along the way but that was just because we weren't using the export functionality from the plugin, we were trying to use the plugin to map the values correctly so I could the import using this plugin. When I ran into a wall with regards to mapping something for payment, Vladimir couldn't have been more helpful. He offered up a number of solutions and ideas and in the end it was a very easy process. I rarely leave feedback but because this plugin made what could have been an awful experience great, I felt the need to give back and state how it helped me. Thanks guys for all your help through this conversion! Dan

  • Jan Fervers - gewaechshaus®,
    Jul 6, 2012

    A piece of stable code which is based on new methods and functions, no more dataslow :). Instead of the competitors products price and effort are matching. And the most important thing, the support is fast and seems to be pro. I gave 4 stars, but this is clearly a 4,5 with tendencies to 5.

  • christian,
    Jun 22, 2012

    Excellent support from Aitoc. We had to move a selection of orders from one complex multi website system to another. Thank you very much!

  • Matt Hubball - PureDsign,
    Jun 21, 2012

    What a great module!! Had issues with the install but the guys from AITOC sorted in out for us in no time!! Thanks Guys. A++ Support

  • cinthya,
    May 30, 2012
    on

    Excellent product and excellent support from Aitoc Support team. I really needed to export all my orders in a few steps. Thank you so much for helping.

 
Add Review
Choose number of stars that seems fair
Post Review and Rating

Changelog

+ stands for new feature added
* stands for bugfix

September 9, 2015 (ver. 10.1.7)

+ Compatible with Magento Enterprise Edition up to 1.14.2.1;

August 21, 2014 (ver. 10.1.7)

* Issue with customer creation based on billing address during order import is fixed.


June 24, 2014 (ver. 10.1.6)

+ Compatible with Magento Enterprise Edition 1.14.0.1.

June 4, 2014 (ver. 10.1.6)

* Issue with incorrect date conversion from different Magento locales is fixed.

June 02, 2014 (ver. 10.1.5)

* Bug with the configurable products import is fixed.

June 02, 2014 (ver. 10.1.4)

* An export order bug with deleted product is fixed.

March 12, 2014 (ver. 10.1.3)

+ Compatible with Magento Enterprise Edition 1.13.1.0.

October 01, 2013 (ver. 10.1.3)

* Issue with wrong transaction date is fixed.

September 27, 2013 (ver. 10.1.2)

* Fixed the issue with importing configurable products.

September 12, 2013 (ver. 10.1.1)

* Issue with importing configurable products is fixed.

July 29, 2013 (ver. 10.1.0)

+ Multi-profile for export is now added.

June 24, 2013 (ver. 10.0.2)

+ Compatible with Magento Enterprise Edition 1.13.0.1.

August 8, 2012 (ver. 10.0.0)

+ The extension has been launched for the Enterprise version of Magento.


1 Customer Review

  • Jeff Minor - CTO - Goedekers.com,
    Apr 18, 2013

    Amazing extension. We had 50,000 orders we had to find an easy, uniform way to port over from our old platform to Magento. Once we got a template set up to quickly get the CSVs constructed, this extension worked like a charm. AITOC was a lifesiver!

 
Add Review
Choose number of stars that seems fair
Post Review and Rating