Efficient Order Export | v2.8.6

For M1
For M2 Efficient Order Export for Magento 2
Magento 1
Need to export orders? Very fast and flexible Efficient Order Export Magento extension will let you export all order data you need, including the one generated by third-party extensions.
Rapid & easy export of order data to CSV or XML
Export billing, shipping addresses & product info
Automate order export process
Send export files by email or upload via ftp
Export order data created by third-party extensions
30 Days moneyback
50% Off updates
120 Days free support
magento order export filters
magento fast order export
Fast and convenient way to export all possible order data.

Export of all possible order data.

Due to this Magento order export tool you can easily export invoice, shipment, product & credit memo info and order-related output of third-party extensions.

Thought out Magento export process for your convenience

Automatic order export process

Just create an export profile (or several of them) and configure a cron job to launch the profile url according to your preferred schedule and conditions.

Optimized for performance

The module performs the export very rapidly and uses little server resources, so you won't have problems with exporting any amount of order data.

It is possible to export only newly created orders

You have an ability to configure export profiles so that only newly created orders are added to the export output. For example, you've exported orders from 10000001 to 10000021 with the first export. The module will start the next export with order 10000022. Feel free to use this feature for both manual and automatic export. Therefore, due to this Magento simple order export tool you can adjust the whole export process to your specific needs.

magento export orders in csv

Send exported from Magento files by email

This option saves you time by automatically sending export files by email according to the specified schedule, e.g. once per day.

Export product attributes

Now you can easily export all necessary product attributes along with other order items information. All created attributes assigned to particular products will be available for export on the Export Profile page and will be marked with the 'product_attribute' prefix.

Change order status for exported orders

For example, set the status of orders to change automatically from processing to complete after the orders have been exported.

Export Magento orders of an individual customer group

You can indicate orders of which customer group to export, when creating an export profile. For example, this can be useful if you provide some customer group with discounts and want to check if it's profitable.

Handy ways to export orders from your Magento

Export orders for a certain period or starting from a specific order number

For example, export orders from Mgento that occured in May or starting from order number 1110.

Specify a time zone that should be applied to the exported files

In case you use a server from abroad you can specify the necessary time zone for exported data to get order info displayed according to your local time.

Ability to specify till which number to export Magento orders

For example, export orders only till number 1221. If you set the export to start with 1221 and end with 1221, only the order with id 1221 will get exported.

Skip items with zero price

This option can be used to avoid duplicate entries when exporting orders of configurable products.

Enjoy fast and easy Magento XML export (Excel XML format) as well as CSV export

The extension supports common export formats, so export files are easy to view and use for further processing.

Run export profiles right from the 'Orders' grid

Now it is possible to run export profiles while you're working on the 'Orders' grid. No more exhausting switching between the tabs, spend your time more rationally!

Export orders with selected status

You can export orders from Magento with products having all possible statuses at once or run separate exports for each order status. Or export orders only with certain statuses, e.g. processing and complete. It is possible to export orders of several statuses in one profile.

Save export files to a server

You can save export files to the local server and/or upload it via ftp or sftp to any other server.

Skip child products

By default when a customer purchases a configurable product, child products are also added to the order. Enabling this option allows to skip child items and keep the exporting file clear from extra data.

Combine any number of fields into a single value

Make field mapping more comfortable and comprehensible by creating custom values that would include several fields from the database. For example you can make ‘Full Name’ column by combining ‘Name’ and ‘Last Name’ fields. This feature comes in handy for displaying customer address in a single line.

combine fields into one value

Bonus export process features

Additional export features:

  • Export either all order information or only specific one
  • Ability to automatically run an export profile after each new order is placed (either from frontend or backend);
  • Export orders containing products with specific SKU(s) (possible to export orders partially - only lines with specified SKUs);
  • Apply filter to order export by credit memo numbers;
  • Automatically start export from the last previously exported order or the first not exported one;
  • View the last exported order and the next one;
  • Export sold download links (for downloadable products);
  • Launch export profiles via url and by cron;
  • Generate shipment and cancellation feeds for Google Trusted Stores.

Exported file features:

  • Export each ordered product custom option or product attributes in a separate column;
  • Choose date format for dates within export output file;
  • Specify date and time for titles of export files;
  • Choose sorting order for fields in the export file;
  • Add fields with static values at the beginning and at the end of the export file.

magento order export options
Reasons to choose

Other Features

  • 100% Open Source — Easy To Customize
  • Follows Magento Code Architecture
  • Separated HTML/CSS/JS
  • W3C Validated Code

Online Extension User Guide

* The name "Magento" and the logo are the trademarks of Magento, Inc.

General Questions

How can I pay for Amasty extensions?

You can pay for our extensions in any convenient for you way as a full range of payment methods are supported. The most common means are credit card or PayPal. Security and fraud protection are guaranteed.

What is the license policy? On how many websites can I use Amasty extensions?

Our license allows you to use a single extension license on one Magento installation.

Extension is not domain related, but installation related. If you run several domains on the same instance of Magento, you can use one extension license. However if you run each website on a new installation of Magento, you need separate license for each of them.

The full end-user license agreement is located here: https://amasty.com/license.html

How to install Magento extension by Amasty?

Each Amasty extension pack includes module files, an installation guide, a user guide and license text. Depending on the extension you purchase, there also may be import files which can be used by you as examples.

Amasty extensions are easy to install. All you need is to have FTP/SSH access details, and follow 3 steps to complete.

  • Unpack a "zip" file you download.
  • Upload all files from the "Step 1" and then from the "Step 2" folders to the root folder of your Magento installation.
  • Clear the cache.

If you are using code compilation, before installing the extension it's necessary to disable it! After you install, click the "Run Compilation Process" button in Admin - System - Tools - Compilation to recompile.

Please also check the extensions installation video guide:

Still unsure? Have complicated configurations or a lot of modules? We can offer professional installation service as well!

Can I test an Amasty extension on a staging site before transferring it to a live one?

Yes, you can install any Amasty extension on a test site and configure all the settings there before doing it on your live store.

Can I get a refund if an extension doesn’t suit me?

Absolutely. Amasty provides a 30-day money back guarantee. No risks for you.

Will I get any other benefits?

Yes! The good news is that every Amasty customer becomes a member of our Loyalty Program and can get a discount of up to 15%. You can find more information about it on the Program page. This is our way to thank you for being our client.

Product questions

Does this extension support exporting product's custom options?

The module exports all custom attributes assigned only to configurable products.

Can I export orders containing products with different tax rates?

Magento stores tax information in the order items table, so you'll be able to export it with other order information.

Can I export order lines as well?

Yes, of course. There will be a new line for each SKU in the order.

Can this module do automatic scheduled exports?

Yes, that’s possible. Just set up your preferable settings and configure a cron job. For example, you can run an export process after each new order is placed.

The export files can be saved on your local server or on any other server via FTP or SFTP.

What file formats are supported by this Order Export extension?

You can export orders either in CSV or in XML formats.

What if I want different types of order export run simultaneously?

This extension enables you to create different profiles for order export. This means that each profile can have its own configurations. For example, one profile will export all order related data while another will another will load only the fields specified by you. The settings are really handy and they will let you achieve high flexibility.

Can I include info from 3-rd party extensions to my export file?

Yes, sure. Under System > Import/Export > Amasty orders Export > 3-rd Party Data Export you can add the output of any 3-d party extension to the exported data:

Magento Efficient Order Export extension by Amasty


You can find the detailed instructions on how to do that in our User Guide.

Awesome support!
Thank you, guys, for your wonderful technical support. This extension functions perfectly as described & is a real must have for any store.
Go for it - this is a HUGE time saver
First, let me say that Amasty extensions are super easy to install. The documentation is clear and concise, and support is great.
I've been using this extension for a long time. It does exactly what it says it does: export orders.
You can choose what to export. You can also rename the attributes to something else you like.
I have 3 websites under 1 magento account and I can create a 'profile' for each website.
Without a doubt it is worth the money. You will no longer do mistakes with your orders.
Useful, no bugs
This extension saves hours of work. We tuned everything so we get new orders every two hours and don’t need to browse through orders in the backend. It also can change the status of order after exporting so we change exp orted orders to ‘processing’ ones.
101% recommended
I usually don't tend to write reviews but this thing really blew me away. This is very priceless tool which allowed me to use various export types for delivering data according to my needs. It saves me literally hours every day!
Also their tech support is superb. I submitted a ticket and they helped me just within an hour.
Hope to see more features in the future!
Magento Connect
Export by e-mail from several admins works great
We have several managers managing parts of our products for defferent markets in different countries. It's great that now it's really easy to collect all the info about orders with e-mails.
Just seconds!
I have a store which sells different small things and everyday I have loooooots of orders. Now it takes just seconds to export all of them to the reports!
Additional handy feature!
FYI you can use this extension to generate shipment and cancellation feeds for Google Trusted Stores! The current GTS extension does not work on all installations. Highly recommended!

Kevin Woolf
Kevin Woolf
Highly recommended
This is the best addon to Magento anyone could have, I've tried others but settled on this one due to past experience I've had with the great support I get from Amasty

Beermonster , Magento Connect
The extension really helps!
I'm very satisfied using efficient order export. It's easy to use and really helps exporting shipping and tracking datas into 3rd party softwares perfectly.
I emailed the support for a question about a configuration issue; their answer came few minutes later! Less than 10 from then I was back to work using the extension with a new shipping system!

secretlight76 , Magento Connect
Another awesome extension from Amasty!
5 / 5
Functions as Described
5 / 5
Developer Support
5 / 5
This extension did everything we wanted it to do, and MORE.
Made my life so much easier.

Support was top-notch, only thing is if you're in North America they work on a different time zone.

But they respond very quickly and fixed my issue within 24 hours! I am very impressed with their products and services, this is my third extension purchase from Amasty.

Keep up the good work!
This is very good add-on
This is very good add-on and I will recommend it to anyone that needs to export orders to another software.

Write Your Own Review

You're reviewing: Efficient Order Export

Version 2.8.6 - December 12, 2016
– A number of minor fixes
Version 2.8.5 - October 18, 2016
– Fixed issue when both options `Export each product custom option in a separate column` and `Export each product attribute in a separate column` were on
Version 2.8.4 - September 01, 2016
– Option to add timestamp to the uploaded file name
Version 2.8.3 - August 11, 2016
– New option `Skip child products`
Version 2.8.2 - August 08, 2016
– Optimization of filesystem functions
Version 2.8.1 - July 27, 2016
– Security patch
Version 2.8.0 - April 20, 2016
– Possibility to apply filter to order export by credit memo numbers
Version 2.7.9 - February 15, 2016
– Code refactoring to improve speed and compatibility
– New feature to create columns which can combine several fields into one single value (like use "first name" and "last name" to create "name" column)
Version 2.7.5 - November 13, 2015
– Speed optimisation
Version 2.7.4 - November 03, 2015
– Possibility to upload exported file to SFTP
– Code refactoring and performance updates
Version 2.7.3 - October 27, 2015
– Admin routing patch (SUPEE-6788) compatibility
Version 2.7.2 - August 13, 2015
– Code optimization: using Magento native function to speed up file downloading
– Magento permissions system compatibility
Version 2.7.1 - June 10, 2015
– Possibility to export product attributes both with the order items information
Version 2.6.3 - May 07, 2015
– Possibility to specify timezone for exported dates
Version 2.6.0 - August 20, 2014
– Possibility to run export profile from the grid
Version 2.5.2 - July 18, 2014
– Multi-select for order status filter
Version 2.5.1 - July 18, 2014
– Minor bugfix
Version 2.4.1 - July 07, 2014
– Bugfix for saving large list of fields to export
– Optimisation for exported file sending by e-mail
Version 2.4.0 - June 04, 2014
– Possibility to export configurable product attributes in separate columns
Version 2.3.4 - November 20, 2013
– Minor bugfix for incorrect filter check when filtering by data not included in the export.
Version 2.3.3 - October 21, 2013
– Bugfix for invoice filters
Version 2.3.0 - October 02, 2013
– New feature: export by invoice number (+auto increment).
Version 2.2.5 - July 12, 2013
– Fix of issue with sending export files via email.
Version 2.2.4 - June 14, 2013
– Automatic profile run after each new order is placed (either from frontend or backend)
Version 2.2.3 - April 30, 2013
– Improved compatibility with Order Status module.
Version 2.2.1 - January 05, 2013
– Bugfix of incorrect export of products' custom options.
Version 2.2.0 - December 14, 2012
– Ability to export orders partially - only lines with specified SKUs.
Version 2.0.0 - October 22, 2012
– Ability to send export files by email, e.g. once a day.
Version 1.8.0 - May 30, 2012
– Ability to automatically change order status for exported orders. For example, you can set the status of orders to change automatically from pending to processing or from processing to complete after the orders have been exported.
Version 1.7.0 - April 02, 2012
– Export orders which contain products with specific SKU(s).
– Possibility to add fields with static values at the beginning and at the end of the export file.
– Ability to specify till which number to export orders, for example export orders only till number 120003221. If you set export to start with 120003221 and end with 120003221, only the order with id 120003221 will get exported.
Version 1.4.0 - December 16, 2011
– Ability to export each ordered product custom option in a separate column.
Version 1.3.6 - November 04, 2011
– Ability to choose sorting order for fields in the export file.
– Ability to skip items with zero price. This can be used to avoid duplicate entries when exporting orders of configurable products.
– Ability to specify date and time for titles of export files.
Version 1.3.5 - September 15, 2011
– Ability to specify date format for dates within output file.
Version 1.3.0 - August 08, 2011
– Ability to automatically start export from the last previously exported order or the first not exported one.
– Ability to export sold download links (for downloadable products).
Version 1.2.0 - August 02, 2011
– Launch of export profiles via url and by cron.
Version 1.1.0 - April 14, 2011
– Export of orders by customer groups.
Version 1.0.1 - February 10, 2011
– Choose orders with which status to export (it is possible to export orders with all statuses at once).