AITOC

Orders Export and Import

  • Popularity Score 320 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

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

Export orders from Magento & import easy 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

$119.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.


List of features


  • Exports 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;
  • Enables export via remote FTP and e-mail;
  • Supports CSV/Tab Separated, XML formats;
  • Enables Admin to upload XSL Template File for transferring orders to 3rd party software;
  • Allow for exporting orders based on Order Status, Order Numbers, Order Placement Date, Customer IDs and/or Product IDs;
  • Enables Admin to define Order Fields which are to be exported;
  • Allows for automatic export via cron;
  • Allows to automatically export orders after checkout is complete;
  • Allows to automatically export an order after invoiced were created for all products within that order;
  • Enables Admin to export only those orders from a specific selection that weren’t exported before;
  • Creates a page with data about all exported orders;
  • Creates a page with data about all imported orders;
  • Keeps a log of errors that occurred during Order Import;
  • Allows for importing orders to specific stores;
  • Enables Admin to interrupt the Order Import process when errors occur;
  • Enables Admin to configure Import Behavior (add, replace or delete data for matching orders);
  • If an order is missing customer data, the extensions creates a customer based on the Billing Address info;
  • All data that was exported can be imported;
  • Comes with a User Manual;
  • The extension's functionality is 100% Open Source.



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

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.5 5 12 12
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
Take it from a guy who hates writing reviews 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 all this 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! BTW I listed 5 on support because I never had to call on support. Worked out of the box just fine. June 6, 2013
Great Plugin! 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 April 15, 2013
Good Company but wouldn't reccomend extension We have used Aitoc before and no problems however this extension has caused us nothing but problems. The extension continually repeated itself so that you would find a 10gb of files in the VAR folder when you woke up in the morning and even took our clients site down twice. Aitoc were unable to help as we could not let them replicate the issue (website is very busy and we couldn't risk it) Support is OK but not what I would call quick and communication needs to be improved. We didn't use this extension in the end and went with Xtento who has a similar module and really good. We did ask for a refund as this module was not fit for purpose but were told no. Because of this we probably wouldn't use them again. April 4, 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, 4 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, 4 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
-
7 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
-
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_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
-
3 months, 4 weeks 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
-
3 months, 4 weeks 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
-
3 months, 1 week 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
-
3 months, 1 week 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
-
3 months, 1 week 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
-
3 months, 1 week 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
-
1 week, 4 days 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
-
6 days 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.