AITOC

Orders Export and Import

  • Popularity Score 376 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

    0 0 1+ 1+ 250+ 250+ 1000+ 1000+ 10000+ 10000+

Export orders from Magento and import into other Magento installs, ERP systems and/or accounting software.
Compatible with:
This extension is currently unavailable on Magento Connect. Please contact the developer.

You will be re-directed to the developer's website to complete your purchase.

You must be registered and logged in to get extension key.
In order to get this extension, you must be logged in to the Magento Community. Click here to login or register.
In order to get this extension, you must have active Magento Go Store. Click here to create Go store.

Magento Connect

$129.00
Previous Next
Overview

Orders Export and Import

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

 

CE-compatible version: http://www.aitoc.com/en/magentomods_orders_export_and_import.html

EE-compatible version: http://www.aitoc.com/en/orders_export_and_import_for_enterprise_edition.html

 

List of features

  • Exports the following:
  • Orders; Order Addresses; Order Payments; Order Payment Transactions; Order Status History;
  • Invoices, Invoice Comments; Invoice Items;
  • Shipments; Shipment Comments; Shipped Items; Shipments Tracking;
  • Credit Memos; Credit Memo Comments; Credit Memo Items;
  • Checkout fields;
  • Allows export via remote FTP and e-mail;
  • Allows for automatic export via cron;
  • Supports CSV/Tab Separated, XML formats;
  • Allows for exporting orders based on the following:
  • Order Status;
  • Order Numbers;
  • Order Placement Date;
  • Customer IDs and/or Product IDs;
  • after checkout is complete;
  • after invoices were created for all products within that order;
  • Allows to automatically export orders upon the following conditions:
  • after checkout is complete;
  • after invoiced were created for all products within that order;
  • All data that was exported can be imported;
  • If an order is missing customer data, the extensions creates a customer based on the Billing Address info;

 

Export/Import Tracking features:

  • Creates pages with data about all imported  and all exported orders;
  • Keeps a log of errors that occurred during Order Import;

 

Admin can:

  • Interrupt the Order Import process when errors occur;
  • Configure Import Behavior (add, replace or delete data for matching orders);
  • Export only orders from a specific selection that weren’t exported before;
  • Define Order Fields to be exported;
  • Upload XSL Template File for transferring orders to 3rd party software;
  • Import orders to specific stores.

The extension comes with a User Manual. The extension's functionality is 100% Open Source.


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

 

CE-compatible version: http://www.aitoc.com/en/magentomods_orders_export_and_import.html

EE-compatible version: http://www.aitoc.com/en/orders_export_and_import_for_enterprise_edition.html

Live Demo: http://orders-export-and-import.demo.aitoc.com/admin

Login: admin
Password: a111111

Please note that the extension is already enabled, there's no need to Manage Aitoc Modules in the back-end of the demo. Navigate to System>Aitoc Order Export or System>Aitoc Order Import to see the extension in action.




Why choose AITOC modules and support services.

MODULES:

  • Solutions to optimize your store’s speed, navigation, checkout, user experience, admin routine, marketing efforts;
  • No encryption;
  • 30-days moneyback;
  • 3-9 months updates;
  • Regular updates and bugfixes;
  • Timely compatibility releases.

 

DISCOUNTS:

Bulk and accrual discounts, and inbuilt discounts on support time.

SUPPORT:

  • At least 30 minutes of support time for ANY Magento problem with each module;
  • Available team of qualified professionals;
  • Prepaid support time to save time on negotiating the price and making transactions in case of emergency;
  • Fixed rates on all task groups to help plan your spending in advance;
  • Free email support  that doesn’t require our team working on your host;
  • One-Week Warranty on support;
  • Priority support for urgent tasks.

Read more about our support offer.

-------

Find us on Facebook and on Twitter

Release Notes

Changelog

2014-09-26 11:49:22
  • Version number: 1.2.9
  • 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, 1.7, 1.8, 1.8.1, 1.9

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;

Orders Export & Import extension changelog

2012-10-08 12:33:33
  • Version number: 1.1.3
  • 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, 1.7

+ stands for new feature added
* stands for bugfix


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.

Compatible with Magento CE 1.7.0.0.

2012-05-17 14:22:59
  • Version number: 1.0.7
  • 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, 1.7
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

This extension was developed by and is supported by AITOC

Orders Export and Import 4.6 5 15 15
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
2 next>>
Q&A
(6 Questions : 6 Answers)

Product Q&A

Ask your questions. Share your answers.

 
 
« Back
 
 
Sort by
 
1 answer

VAT

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26911406
Customer avatar
Hi,
I work with two several VAT´s: 7% and 19%
Will the extension export the relevant vat and also the vat used for transport costs?

Thank you.
by
tufantopcu
-
1 year, 8 months ago
+1point
1out of 1found this question helpful.
Was this helpful?Yes1No0

Answers

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_108971
Customer avatar
Answer: 
The extension exports all information from orders. Of course with VAT information. Moreover you can modify output by XSL modification to export only VATs with necessary information.
by
AITOC
-
1 year, 8 months ago
0points
0out of 0found this answer helpful.
Was this helpful?Yes0No0
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_83030
Customer avatar
Hello,

couple of questions regarding the plugin for Migration:

1) Does this extension support migration from ver.1.3.x.x to 1.7.xx

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?

Thanks,
Alex
by
BLIZZARD
-
11 months ago
+1point
1out of 1found this question helpful.
Was this helpful?Yes1No0

Answers

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_108971
Customer avatar
Answer: 
Hello Alex,

1) Does this extension support migration from ver.1.3.x.x to 1.7.xx

Yes, it does. From 1.3.2.4.

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.

Regards,
Aitoc Team

.
by
AITOC
-
11 months ago
0points
0out of 0found this answer helpful.
Was this helpful?Yes0No0
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_27422246
Customer avatar
Can I export orders / sales / invoices from version 1.3.2.4 and import everything to version 1.8.1?
Thanks
by
seoagencias
-
8 months ago
+1point
1out of 1found this question helpful.
Was this helpful?Yes1No0

Answers

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_108971
Customer avatar
Answer: 
Hello,

Yes, admin can export all the info from orders like Orders, Order Addresses, Order Payments, Order Payment Transactions, Order Status History, Invoices, Invoice Comments, Invoice Items, Shipments, Shipment Comments, Shipped Items, Shipments Tracking, Credit Memos, Credit Memo Comments, Credit Memo Items, Checkout fields.

All this info can be exported from version 1.3.2.4 and imported to version 1.8.1.0

Thank you.
by
AITOC
-
8 months ago
0points
0out of 0found this answer helpful.
Was this helpful?Yes0No0
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_27305161
Customer avatar
i am using enterprise edition1.13.1.0. this extenstion is supported or not...?

please give quick reply..

thanq
Latha T
by
lathavedic
-
7 months ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0

Answers

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_108971
Customer avatar
Answer: 
Yes, Orders Export and Import extension is compatible with Magento Enterprise Edition 1.9.0.0 - 1.13.1.0.

Thank you.
by
AITOC
-
7 months ago
0points
0out of 0found this answer helpful.
Was this helpful?Yes0No0
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_27305161
Customer avatar
by
lathavedic
-
7 months ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0

Answers

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_108971
Customer avatar
Answer: 
Hello,

Please go to the System > Import/Export > Aitoc Order Export > Cron Settings to enable export by cron. Please follow a link below to find our How to Set Up a Cron Job.

http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/how_to_setup_a_cron_job

Thank you.
by
AITOC
-
7 months ago
0points
0out of 0found this answer helpful.
Was this helpful?Yes0No0
 
1 answer

Inventory Update

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26994530
Customer avatar
Hi,

Does your extension automatically update the inventory when an order is imported into Magento?

For example if we import an order of 16 x Product A of which we only have 20 in stock, will this automatically update the inventory to display a quantity of 4 x Product A in stock?
by
curty123
-
4 months, 2 weeks ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0

Answers

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_108971
Customer avatar
Answer: 
Hello,

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.

Thanks.
by
AITOC
-
4 months, 1 week ago
0points
0out of 0found this answer helpful.
Was this helpful?Yes0No0
1 of 1
1 of 1
Get Help

Support for This Extension

The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Magento Platform Support

If you need support for a Magento platform, there are different options for support depending on which Magento platform you are using. Below are links for specific platforms.

In order to upload extension, you must be logged in to the Magento Community. Click here to login or register.

Close

Register

* Required Fields

Close window

Forgot Your Password?

Please enter your email below and we'll send you a new password.

* Required Fields

Close window

Login

To upload extension you must be logged in.

* Required Fields

Close window

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.