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.
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, .xml) and 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.
Here is one more order export/import solution from aheadWorks.
Take it into consideration, please.
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.
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.
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