cancel
Showing results for 
Search instead for 
Did you mean: 

can one import order into Magento from 3rd party sites like Amazon and Home Depot.com

can one import order into Magento from 3rd party sites like Amazon and Home Depot.com

We sell through our own site which will be magento but also sell through multiple other sites.   We have Amazon. pull in a number of Channel advisor sites, traditional retail customer with new websites like Home Depot, Lowes, and are continually adding others.

 

Would like to use the reporting capability out of Magento but need to import orders to do so.

 

Is there a way to use the magento back office to do so or do I need to add an extension  to do so.

 

 

5 REPLIES

Re: can one import order into Magento from 3rd party sites like Amazon and Home Depot.com

Hi j7brook, 

 

If you wish to preserve all order details and to have them at disposal when producing your reports, it’s better to use an extension to migrate Orders between third-party platforms and Magento.

 

For instance, you can try our Magento Orders Export / Import extension www.magentocommerce.com/magento-connect/orders-export-and-import.htm

 

It allows you to export and import 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.

 

Besides, it support a variety of formats (.csv, .xmland allows you to choose which fields to export/import.  The .xml format is recommended as it is native to Magento.

 

You can find CSV and XML order import examples with descriptions at www.aitoc.com/en/magentomods_orders_export_and_import.html#docs

 

The mandatory fields for order import are the two fields listed below:

increment_id (Order ID)

store_code (this info can be found at System > Manage Stores)

 

Here is a link to the demo, if you'd like to take a look. 

 

Hope this helps.


Aitoc is a group of distinguished web developers that have been building for Magento since 2009.
See our extensions for Magento 2.

Re: can one import order into Magento from 3rd party sites like Amazon and Home Depot.com

Hi!

Here is one more order export/import solution from aheadWorks. 

Take it into consideration, please.

https://ecommerce.aheadworks.com/magento-extensions/import-export-orders.html

Re: can one import order into Magento from 3rd party sites like Amazon and Home Depot.com

You can also check Store Manage for Magento, it also includes the functionality allowing you import of orders from CSV to Magento with related customer data (with columns mapping, so csv format can be adjusted on the fly).

It is also paid, but there is  14-day free fully-functional version you can download at from the link in my signature, so you can try it  and in case the task is not repeated you can perform it without fees.

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: can one import order into Magento from 3rd party sites like Amazon and Home Depot.com

I have Store Manager and use it relatively often. I wouldn't recommend it for importing customers though. 

 

If you do use it, test test TEST your import before you commit it.

 

For whatever reason the software was reading some of the CSV values from the wrong row, meaning almost 12,000 customers had an incorrect value in the "city" field. I'm still paying for not checking properly. 

Re: can one import order into Magento from 3rd party sites like Amazon and Home Depot.com

Hello @tmaharding

 

Actually this is the matter of tech support. The problem might be in wrong delimiter or some other settings. To tell you more exactly what is the reason of the issue will be possible after you contact our support. We provide free phone, chat and mail support.

 

p.s. by the way, you have only one reply under this account and this only post is about why you 'wouldn't recommend Store Manager'. It looks like competitor's post Smiley Happy

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.