Export Magento Orders with Ordered Products, Shipping Data and Customer Details
Starting from ver. 2.15.0 (967) of Store Manager for Magento and higher, users can experience facilities of new improved Export Orders Wizard. It has been re-designed for more comfortable usage and additional possibilities were added for shop entrepreneur to have more control over orders and related to them information coming to their online shops.
New Magento Export Orders Possibilities
- Group of Fields to Export
Namely, from now at the step “Select fields to export” you can not only manually drag or move with arrows in the middle, the fields you would like to be exported to the file, but also at once add a group of fields with associated information. This way you will definitely not skip some important fields in case you need to perform orders export of some definite details.
For the mentioned purposes at the top of the page there is the menu with “Add group of fields” button, clicking which you will see gathered under certain parameter set of fields containing general data, ordered items and customer billing and shipping data.

- On-the-Fly Fields Adjustments
You can make file modifications right in the process of export to avoid manual adjustment when the spreadsheet is already received and opened. It is possible by means of expression option. It is good when for example, you need to send information on shipping information to some delivery company or your partner and would like name, middle name and lastname of person to whom the purchase will be delivered to be in one column, instead of 3. So, this way using this useful functionality and applying special expression formula you can get the mentioned fields merged into one in your result file.
In our case expression will be -
CONCAT([shipping_address_firstname], ' ', [billing_address_middlename], ' ', [billing_address_lastname])

More on expressions and their examples you can find here -
How to input missing dataon-the-fly in the process of data uploadMore Information That Can Be Exported
- Export orders with purchased products
You can get in your file columns with information on products added to the order, like SKU of item, its name, description, price, quantity etc. This way you can get more information and see which goods are in more demand and more often purchased.
- Shipping details export
You can get in the file all shipping details on orders that include all the information where and to whom order should be delivered. This is especially convenient in case you are not delivering products yourself, but working with some shipping company or service that might need these details.

- Export of full name of customer who placed the order
Previously it was possible to get the file with customers’ name, middle name and last name in separate columns. Now you can get those details in one column when exporting orders.
Read detailed tutorial and find out how goes order export procedure -
mag-manager.com/magento-export-ordersExport orders FREE using Store Manager for Magento Export Now
Related Articles:

Magento Import Orders
Guides on performing Magento orders import and configuring .csv import file. Read More...

How to Export Magento Orders to QuickBooks
Find out how ho register Quickbookds Integration Plugin and get steb-bystep instructions on exporting Magento orders to Quickbooks. Read More...

How to Generate Magento Invoices for Orders
Step-by-step guides on Magento invoices generation and printing; learn how to generate invoices massively. Read More...

Magento Order Management with POS
The list of benefits provided by Magento integration with POS system and instructions on how to use the POS. Read More...
COMMENTS