Magento Order Import Extensions, Commercial or Otherwise

Question

Is there a standard third-party module that everyone/anyone is using for programming batch order imports in Magento? I need to do a complicated history import for a client, and the SOAP API doesn't have an order creation API, and an Order model existing in the system is dependent on so many other things already existing that it's not a simple straight forward "create an order model". Has anyone created tools to solve this problem?

I'm interested in hearing people's experiences with modules that are specifically aimed at importing arbitrary orders, and extensions that are aimed at importing orders from third party systems (like the M2E extension for eBay). I know how to approach the problem from a "raw programmatic" approach; I'm looking for tools that have already solves a lot of the bumps you'll run into on the way.

Answer 1

Alan,

Thanks so much for your contributions to the Magento development community. I really appreciate it.

When I was in your position about 6 months ago, we evaluated a lot of the extensions that were available for this sort of transaction, and none of them seemed viable. We tested a few that left out information like addresses, another errored out, it was a mess. We ended up doing it programmatically. The quality of some of the extensions available is really questionable, and it seems that the import/export market is particularly bad. Good luck!

Answer 2

Alan- not sure but probably Unirgy's uRapidFlow might be helpful. I haven't tested it myself though.

Answer 3

I actually just got done with the same type of situation. My client wanted me to migrate 7 years worth of orders (just over 500,000 total orders).

Truth be told I only had the budget to try a single product (it was an extension of DataFlow) and I have to say that while it did sort of import orders, it was far from complete. I tried to fix his code to make it work for me but the problem was that to import that much information took an incredibly long time (I started the process before going on vacation for a week and when I came back it was only 70% done).

I looked at some other solutions but in the end I really just had to dive into the code and make my own script that lived outside of Magento to push the orders in.

I spent about 5 months on and off getting this one done. There really probably is a good market for an affordable way to push orders into the system. Frankly I am surprised this kind of functionality does not already exist inside of Magento's API system.

Answer 4

Hi,

I have the same problem, that I need to import orders and customer data.

I just found some solutions for transfering Order and Customer data from one Magento DB to another. But this will be very expensiv if I use this for each transfer: - http://www.shopping-cart-migration.com/ - http:// www. commerceextensions.com/magento-dataflow-batch-import-export-orders-to-csv.html

The first solution I tested and I think it is working good. It's based on a Webservice and Business Modell is OnDemand so it will be too expensive in the long run... The second one I don't know if its working.

Did your solution finally worked? I'm on Magento 1.4.1

Cheers, Sebastian

Answer 5

I've tried http://www.commerceextensions.com/magento-dataflow-batch-import-export-orders-to-csv.html but it doesn't work and is really buggy. Grateful for any other solutions!