Please note that this extension is provided as is. It is recommended to always backup your installation prior to use.

Overview

Orders Export and Import

*Easily migrate orders and other data between Magento and other programs.*

Orders Export & Import allows you to export orders from Magento and import them into other Magentos, ERP systems or accounting software. You need just one product license to migrate the data from one magento installation to another.

Export only orders from a specific selection that weren’t exported before.

Define the Order Fields to be exported.

Upload an XSL Template File for transferring orders to 3rd party software.

If you need a custom XSL template to fit a specific format of the software you’re data exporting to, we’d be glad to help. Please contact us for a quote via the Support tab. Also please provide your requirements and/or samples for a faster response.

August 16, 2012 (ver. 1.1.3)

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.

Compatible with Magento CE 1.7.0.0.

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;

Extension release

2012-05-17 14:20:43

Version number:
1.0.0

Stability:
Stable

Compatibility:
1.3, 1.4, 1.4.1.1, 1.4.2, 1.5, 1.6, 1.6.1, 1.6.2.0

January 25, 2012 (ver. 1.0.0)
+ The extension has been launched for the community version of Magento;

Reviews

About the Developer

Great Extension and support.
Great extension. 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.
November 19, 2014

the order import/export plugin to get
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.
Worked for me on versions 1.7-1.9
November 3, 2014

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.
October 7, 2014

Great module
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.
July 8, 2014

very usefull
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
March 13, 2014

Makes Importing Orders Much Easier
Our site needed a way to bulk import orders into Magento from other vendors / venues that we sell on and this extension provided it with that ability.
Most of our venues / vendors provide us with CSV files with orders. The extension came with examples of import sheets, so we were able to easily convert those files to an importable one for the extension.
We have not used the XML importing only the CSV. It works great, but make sure that you format your CSV file properly (proper capitalization, no extra spaces, etc). CSV can be very tricky, but as long as you format it properly, this extension does what it intended to do.
No extension is perfect, but this one really helped us out a lot. This extension saved us time and money by allowing us to import large amounts of orders at one time.
Finally, the developers have been great to deal with. The are professional, courteous, and respond very quickly.
We had a specific need / customization for the extension. They gave us a quote for the customization, and completed the custom work within days of payment.
Also, they were able to make minor adjustments within a day to the custom extension that suited our needs even better. We would recommend them to work with, and are even considering doing some more custom work with them.
December 27, 2013

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

Great extension and great support
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!
October 31, 2013

Very good extension, but I a bad surprise...
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.
September 1, 2013

Fantastic!!! Does much more than the default magento import/export function can do
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.
June 9, 2013

Was this helpful?Yes1No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/question/149327/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D149327&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/answer/156577/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D149327%26expandanswer%3D156577&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

2) Will it work with huge amount of records?About 340k orders and about 160k customers.

3) Is any support included/possible?We have some custom attributes in sales/customers models so probably we’ll need some support for transferring values of these attributes. Some manual how to add it is also good (we have in-office magento developer)

4) What about guarantee/money-back period? In case if this plugin won’t meet our requirements.

5) Is it possible to run export/import procedure one more time (the same DBs)? The reason is test first run, test the result and then run it one more time. Our site is quite loaded, a lot of new registrations/orders every day, so we don’t want to miss something. Ideally we would like to control export/import process somehow so that we can run process when we need (reproducible process in other words for one our site). Is it everything possible?

Was this helpful?Yes1No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/question/276940/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D276940&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Answers

2) Will it work with huge amount of records?About 340k orders and about 160k customers.

Yes, it will. Current average speed ~10 orders per second (Depends on server performance)It will be better to import customers before you import orders. Extension can create customers, but fields set doesn't contain full information about customer.

3# Is any support included/possible?We have some custom attributes in sales/customers models so probably we’ll need some support for transferring values of these attributes. Some manual how to add it is also good #we have in-office magento developer#

Small package of support time already included into purchase. You can buy additional support time to solve all of your issues.

4# What about guarantee/money-back period? In case if this plugin won’t meet our requirements.

30 days of unconditional money-back.

5) Is it possible to run export/import procedure one more time #the same DBs)? The reason is test first run, test the result and then run it one more time. Our site is quite loaded, a lot of new registrations/orders every day, so we don’t want to miss something. Ideally we would like to control export/import process somehow so that we can run process when we need #reproducible process in other words for one our site). Is it everything possible?

Yes, it's possible. The extension has option to export orders which haven't been exported before.

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/answer/339006/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D276940%26expandanswer%3D339006&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes1No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/question/316217/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D316217&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/answer/384160/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D316217%26expandanswer%3D384160&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/question/324095/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D324095&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/answer/393837/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D324095%26expandanswer%3D393837&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/question/324106/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D324106&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/answer/393851/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D324106%26expandanswer%3D393851&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/question/358011/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D358011&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Answers

This functionality is not available out of the box and a customization of the module is required. We do not provide customizations services, however you can hire any 3d party developer or company to modify our modules since the extension code is not encrypted.

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/answer/437654/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D358011%26expandanswer%3D437654&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes1No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/question/437839/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D437839&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Was this helpful?Yes0No0http://answers.magentocommerce.com/answers/4643-en_us/product/11617/answer/524569/undohelpfulness.djs?format=embeddedhtml&sessionparams=__BVSESSIONPARAMS__&return=__RETURN__&innerreturn=http%3A%2F%2Fanswers.magentocommerce.com%2Fanswers%2F4643-en_us%2Fproduct%2F11617%2Fquestions.djs%3Fformat%3Dembeddedhtml%26scrolltotop%3Dtrue%26expandquestion%3D437839%26expandanswer%3D524569&user=__USERID__&userdisplayname=__USERDISPLAYNAME__&authsourcetype=__AUTHTYPE__&submissionparams=__BVSUBMISSIONPARAMETERS__&submissionurl=__BVSUBMISSIONURL__

Login

You are using an outdated browser

We built Magento Connect using the latest techniques and technologies.
This makes Magento Connect faster and easier to use.
Unfortunately, your browser doesn't support those technologies.
Use the links below to download a new browser or upgrade your existing browser.