Magento Extensions

Orders Export Tool

The Orders Export Tool allows you to create xml csv and txt order files from your Magento admin panel and export them to any CRM application or order management software/platform. Any kind of export file types can be easily customized

  /  16 Reviews

License from

80

  • Single License
  • Custom License
You may also be interested in...

Data Feed Manager

Export your products from your magento website into csv, txt and xml data feeds for any shopping engine or market place ! This extension includes all Google Shopping features and 19 pre-configured templates.

License from

€80

  • Single License
  • Custom License

The basic knowledge about Magento and order management

How Magento deals with the customer's orders ?

Orders in Magento are arranged as a structured group of data that are shared in different database table instances.

The main instance is the Order table that contains the summary of each order placed (date, total amount, tax, customer,...).

Attached to this instance there are 3 sub-instances concerning the order details :

  • Product
  • Shipping address
  • Billing address

These instances describe which products have been ordered and gives details about the customer's adresses.

4 other sub-instances, help to store the different steps in the the order process : 

  • Payments
  • Invoice
  • Shipment
  • creditmemo

The above instances can be summarized in a simple diagram :

Of course this diagram doesn't display all the data available in each instance, there is much more data you can extract from your Magento database.

That is where Orders Export Tool can help.

How "Orders Export Tool" exports the Magento Data ?

Orders Export Tool enables the export of all the order data into Xml or Txt/Csv files.

These files can then be transfered into your CRM/ERP software or can be used for reporting purposes.

The way this extension deals with the order data is very simple. When configuring your export profile, you have to complete a template in which you can use static and dynamic values.

Static values are data that don't change from one order to another and that are added in the ouput file to make it readable and dynamic values are data that are different for each order (price, address, product ordered...).

Imagine you want to export all the orders placed into you Magento webstore and what you want to get is a simple txt file consisting of the order # and the total amount of each order.  What you get should look like :

#123456789 	$150.00
#234567891	$275.00
#345678912	$450.00

Your template would be very simple :

#{increment_id}  ${total_paid}

the # and the $ are static values while {increment_id} and {total_paid} are dynamic values that changed for each order.

{increment_id} and {total_paid} refer to the order instance and could also be written {increment_id order} and {total_paid order}.

You might need to complete your export file with the method used by your customers to pay their order. This data can be found in the payment instance. And you should use {method payment}. This syntax means you want to know the value of the payment method for each order.

You might want to know which syntax to use? No worries, Orders Export Tool includes a full library of all data available for all instances : order, products, payment, invoice, shipment, creditmemo...

How to use Orders export tool?

How to configure your export profile with Orders Export Tool?

When creating or editing an export profile in Orders Export Tool, you have to be aware of some basic settings: 

Export file configuration

  • File name : the base name of the exported files (eg : myOrders), no need to add any file extension (xml, csv, txt), the extension does it for you
  • File type : this is the main setting that defines if you want either an XML file type or a CSV/TXT file type. Depending on this setting the template section will be managed differently
  • File directory : the directory in which the generated file will be saved. We recommend using a protected directory such as var/
  • File name format : your file name can be completed with the current date at the time of the exportation. Different formats are available.

Orders export configuration

This section allows you to define which group of orders must be exported

  • Store views : allows you to choose one or more store views from your webstore(s) to use in the exportation process
  • Start with order # : allows you to specify a order number from which to start the export process
  • Register the last exported # :  allows you to automatically register the last exported order into the 'Start with order #' input
  • Flag each exported order : allows you to flag each exported order as exported in Sales > Orders
  • Export only unmarked orders : allows you to specify that only the orders not yet flagged must be exported

Filters

This section allows you to specify the type of order you want to export

  • Order status : at least one status must be selected
  • Customer Group : at least one customer group must be selected
  • Advanced Filters : allows you to create advanced filters based on specific attributes/values

Ftp Settings

This section defines if and how the files must be uploaded to any FTP location

Scheduled tasks

This section defines when (days and hours) the profiles must be run

Advanced Options

This section defines some very specific behaviors such as multi-file generation and sort process.

How to configure your XML template ?

An XML template is made up of 3 parts :

  • the header pattern which is at the start of the file
<orders>
  • the order pattern which is iterated for each order included in the file
<order>     
    <customer>
     {customer_lastname,[strtoupper]} {customer_firstname,[strtolower],[ucfirst]}
    </customer>
    <billing>
        {firstname billing} {lastname billing} 
        {postcode billing} {street billing,[implode]} 
        {city billing} {country_id billing}
    </billing>
    <shipping>
        {firstname shipping} {lastname shipping} 
        {postcode shipping} {street shipping,[implode]}
        {city shipping} {country_id shipping}
    </shipping>
    <items>
        {product::start}
        <item id="{item_id product}">{name product}</item>
        <weight>{weight product}</weight>
        {product::end}
    </items>
<order>
  • the footer pattern which is at the bottom of the file
</orders>

The XML structure allows you to use iterative syntax in different parts of the template, as follows :

{product::start}
    <item id="{item_id product}">
          <name>{name product}</name>
          <weight>{weight product}</weight>
    </item>
{product::end}

In most cases, orders contain more than one product, so it may be useful to create an iteration that loops for each ordered product. All the content between the opening and closing markers will repeated for each product and all dynamics values will be replaced

 {product::start}
...
 {product::end}

These iteration markers can be used for all order instances :

{payment::start}
...
 {payment::end}
{invoice::start}
...
 {invoice::end}
{shipment::start}
...
 {shipment::end}
{creditmemo::start}
...
 {creditmemo::end}

How to configure your TXT/CSV export profiles?

To create a CSV/TXT datafeed, you just have to choose 'csv' or 'txt' in File type , in the Configuration tab. The template tab will be updated to match with the file type.

  • Include header allows you to include or not the column's name in the first row of your CSV/TXT file.
  • Columns name is for the attribute name that can be displayed at the top of the file
  • Pattern works in the same way as in XML files.
    Like in XML files, you're allowed to use PHP code if you want to customize the pattern.
    You just have to write your PHP code in one single line, and it will work perfectly.
    You can add a field by using the button Add field . The fields can then be re-ordered easily by using the up and down arrows.
  • Field delimiter lets you choose which kind of delimiter you want to use to separate your fields.
  • Fields enclosure lets you choose which kind of enclosure you want for your data.

The main difference with the XML mode is that you can't use any iteration instructions. Instead, Orders Export Tool uses an auto-consolidation internal  process. This simply means if you try to get the value of any attribute of an instance (product for example) that contains several items, the extension will automatically duplicate the txt/csv line for each item.

With the following configuration :

Logically the module should export one line for each order, but some orders may contain several product items. The extension will create several lines for the same order, as in the following output example :

Order#         Product Name          Product Sku
#10000001      my product A          AAA
#10000001      my product B          BBB
#10000001      my product C          CCC
#10000002      my product D          DDD
#10000003      my product B          BBB
#10000003      my product E          EEE
...

How to create customized attributes or computed values ?

In some cases you might need to get the value of one attribute that is not available in any of the default instances (order, product, address, payment, invoice, shipment or creditmemo). Or you might need to use the value of one attribute but with a computed output.

Orders Export Tool allows to create your own customized attributes directly from your admin panel by using some php code.

Here are 3 examples of common customized attributes :

  • Get the color for each product of the order
 <? $product=Mage::getModel('catalog/product');
      $product->load($item->getProductId());         
      $value=$product->getColor(); ?>

or

<? return Mage::getModel('catalog/product')->loadByAttribute('sku',$item->getSku())->getAttributeText('color'); ?>
  • Get a consolidated string of all product skus in the order
 <? $skus = array();
 foreach ($data['products'] as $product) {
 	$skus[]= $product->getSku();
 }
 return implode(',',$skus); ?>
  • Get the status of an order and retrieve a computed value for Google Trusted Stores
<? switch($item->getStatus()){
  case 'canceled': $value= 'MerchantCanceled'; break;
  default : $value= 'BuyerCanceled';
} ?>

In order to create a valid customized attribute, you must respect these rules :

  • $value is used to store the data that must be returned. You can also use the return instruction
  • $item refers to the item of the current instance , eg :
    • {your_custom_attribute order} : $item refers to the order instance
    • {your_custom_attribute product} : $item refers to the current product instance
    • ...
  • $data is an associative array that contains all the instances data of the current order. 
    • $data[products] contains all the product data relative to the current order
    • $data[payments] contains all the payment data relative to the current order

Process questions Installation questions
Process questions

How to schedule my data feed generation with Orders Export Tool?

Orders Export Tool provides you a fully configurable schedule in the Scheduled task tab of your template configuration for each data feed.

Warning : in order this to work, you must have one main scheduled task running from your server side and targeting cron.php (or cron.sh) - located  in the root directory of magento - each hour (ideally).

If the management panel from your hosting compagny doesn’t provide such a service, you can use a remote service such as : https://www.mywebcron.com

Orders Export Tool also provides you a cron job reporting, so you can get email reports on each data feed you will generate.

Installation questions

I didn't receive my payment confirmation for Orders Export Tool

1. The payment confirmation email should only take a few minutes, rarely more than one hour
2. Check your spam filter
3. Contact us: we will try again to send it

If I want to test an extension first on a staging server, do I have to buy 2 licenses for 2 domains ?

When installing a module on a new environment, you should see a screen as below offering to update the license, just click on the link Request a free license update in your admin, and your request should be approved within one hour.

How do I install Orders Export Tool?

1. To complete the setup of your extension in the best way, you first need to disable the compiler in your Magento admin. For that, go to System > Tools > Compilation.

If the compiler is activated, you must disable it by clicking on Disable.

2. Then, you need to refresh caches in System > Cache Management.

 

3. Now you can download the zipped extension from your Wyomind account > My downloads. Choose the one you just purchased and click on the grey arrow.

4. Click on the orange link (example: 3. 1.0 available) to download your extension.

5. Once you have downloaded it, unzip the folder content.

6. Copy the folder content (app,skin and lib directories) and paste all files and directories into your Magento web site root directory.

7. Once your installation is complete, don’t forget to enable the Compiler if it was activated before the installation and to Run Compilation Process.

8. Clean the cache and log in again.  

Well done, your Wyomind extension installation is all set! Have a look at our next FAQ on how to activate your license.

How do I activate Orders Export Tool ?

Now you must activate your license.

1. Copy the activation key (example: ACTKEY-ABCD)
2. Go to System > Configuration > Wyomind and choose the Wyomind extension you have installed.
3. Paste the activation key (that you previously copied from your Wyomind account) in the Activation key field.
4. Save your data.
5. Choose an activation method between Automatic (Yes) and Manual (No) .
Automatic (Yes): you allow a connection to Wyomind's license server
Manual (No): you must log in with your browser to Wyomind's license server

6. A notification appears at the top of your admin: Activate it now! Click on it.
7. Copy and paste the license code in the License code field of your admin or click on Activate now!.
8. You must log out and clean the caches so that the installation is complete. And that's all!

I'm asking to overwrite /lib/Varien/Data/Form/Element/link.php, should I carry on?

You can skip this file, it's only for magento < 1.4.

I get an error saying "Base table or view not found".

This issue may be due to a problem during the installation process.

You can fix it by following these steps :

  • Access your database via your control panel (cPanel for example)
  • Delete the entry ordersexporttool_setup from the table core_resource
  • Logout from your Magento admin
  • Log into your Magento admin

I get an error saying "err_connection_reset".

It can happen on localhost environments because of rights on session files stored locally.
You have to rename app/code/local/wyomind/ordersexporttool/sql/ordersexporttool_setup to something different: for example ordersexporttool_setup_XX.

I get a fatal error concerning Mage_Core_Model_Resource_Setup.php

If your site crashes and gives this error message after uploading all files to the correct folders:

Fatal error: Class 'Wyomind_Notificationmanager_Model_Resource_Setup' not found in includes/src/Mage_Core_Model_Resource_Setup.php on line 234

It probably comes from installing an extension while the compiler is still enabled.

Important note:
• If the compilation is enabled on your website (System > Tools > Compilation). Disable it first before installing any extension. After installation re-run the compilation process and re-enable the compiler.
• Before installing any extension, it's advisable to backup your Magento installation.

Here is the way to disable the magento compiler:
Edit the following file: includes/config.php and add a # before the 2 following lines:

define('COMPILER_INCLUDE_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'src');
define('COMPILER_COLLECT_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'stat');

to get:

#define('COMPILER_INCLUDE_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'src');
#define('COMPILER_COLLECT_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'stat');

Then go back to your website admin and re-run the compilation process.

I get a 404 error instead of the configuration page in the admin panel

Most of the time log-out/log-in may solve this issue.

I get an error saying "This is a required field" even if I select one or all fields

Check if all files have been uploaded on your server and if you are using the compiled CSS/JS then you should re-compile all the data from your cache section.

How do I fix the issues with scheduled tasks?

How do cron tasks work:

  • cron.php is launched regularly from your server side (every 5 minutes most of the time)
  • The cron task for Orders Export Tool is targeted and evaluates if a data feed or a profile needs to be refreshed (depending on the timestamp stored in the database and on the schedule table for this specific profile)
  • If the above condition matches, then the data feed and the profile is re-generated

Be sure that you have correctly configured a scheduled task from the server side (cpanel) targeting the cron.php file in your magento installation.

Orders Export Tool includes reporting and debug tools for the scheduled tasks in:
system > configuration > Wyomind > Orders Export Tool

We also strongly advice to install the AOE Scheduler that will help you to monitor the magento cron tasks.

How do I uninstall Orders Export Tool?

In order to uninstall Orders Export Tool, you must remove all the following files and directories:

  • app/etc/modules/Wyomind_ordersexporttool.xml
  • app/code/local/Wyomindordersexporttool
  • design/adminhtml/default/default/layout/ordersexporttool.xml
  • design/adminhtml/default/default/template/ordersexporttool
  • skin/adminhtml/default/default/ordersexporttool
  • app/locale/lang_LANG/Wyomind_ordersexporttool.csv

 

Clean the cache and re-launch the compiler (if you use it).

Orders Export Tool Features
  • Xml, csv and txt order files generation
  • Easy to use task scheduler
  • FTP Upload
  • Last exported order registration
  • Optional file name increments for complete export history
  • Highly and easily customizable export profiles
  • All data exportable : orders, ordered items, payments, invoices, shipments and credit memos
  • Real-time file preview
  • Exportable fields available in one step through the internal library 
  • Syntactic console to avoid any syntax error
Orders Export Tool Screenshots
Magento Compatibility

Magento Community Edition

1.9.0.1 1.9.0.0 1.8.1.0 1.8.0.0 1.7.0.2 1.7.0.1 1.7.0.0 1.6.2.0 1.6.1.0 1.6.0.0 1.5.1.0 1.5.0.1 1.4.2.0 1.4.1.1 1.4.1.0 1.4.0.1 1.4.0.0 1.3.3.0 1.3.2.4 1.3.2.3 1.3.2.2 1.3.2.1 1.3.2 1.3.1.1 1.3.1

Magento Enterprise Edition

1.14.0.1 1.13.1.0 1.13.0.2 1.12.0.2 1.12.0.1 1.12.0.0 1.11.2.0 1.11.1.0 1.11.0.2 1.11.0.0 1.10.1.1 1.10.0.2 1.10.0.1
User's reviews

Awesome Extension &amp; Support
These guys rock!
Not only creating great extensions but also for supporting my sometimes stupid sounding questions with fast and helpful support.
Thanks Guys

View 6 Com

2014-07-08

EXCELLENT!
Hi
I bought this product last week and had a few snags! However the developers had excellent support and resolved all issues i had!
They really stand out of the crowd these guys and i can recommend them with impunity!
Thank you Pierre!
You made a customer for life out of me!

Felconian1

2014-02-05

Best support i have ever seen
This module works great, but the support that its given is really 5*
Pierre responds real quick on any question. When my developers couldnt figure out some customization issues. Pierre offered to do it himself. Really great geisture as we had much urgency with this job. 100% RECOMMENDED!

Ikramadoui

2014-01-17

This extension far exceeded my expectations.
We needed an extension that was user-friendly with a high level of customization. Wyomind delivered it in spades!
The set-up was quick and easy. Documentation was readily available and written in manner that even a novice like myself could understand.
What few issues I did encounter were quickly and professionally resolved by customer support. In fact Pierre wrote two custom attribute scripts for me when all I asked him how I could do it myself.
You will not regret purchasing this product.

ToolChuck

2013-12-03

A great product surpassed only by the developer's support
I needed to export orders to several places, and all of them had very different xml schemas.
Multiple export profiles allowed easy creation and management of the multiple schemas. Filters prevented extraneous orders from being sent. And custom attributes allowed me to convert data into whatever crazy format was specified.
I had several questions for support and not only was the response prompt and helpful, but continued well after hours

mbutlerDTI

2013-12-03

Very good support!
Very good extension and support. I had a few problems but they were fixet in a day by the developer. I recommend both the extension and the developer

disenthat

2013-10-18

Good tool and great support!
The plugin really does what is descriped and is very easy to use.
If you have questions, they are answered very quick from the support and for a really good price the report was customized for me.
Thanks!

datadocks

2013-07-11

Amazing extension and support
My clients are way behind on technology so I needed something to export their orders without them having to do much. This extension works perfectly and the customer support is amazing!!

creativeone

2013-06-24

Great product, great support
The extension works perfectly as expected. My question got immediately responded by the support team.
Higly recommended.

stijndw

2013-05-16

Great Developer Support
As a preferred supplier I was happy to see the new Order Export extension and when we had to query the developer they prompt in their reply as ever!

getsquare

2013-05-13

Great Tool
This tool works great. it is now very easy to create my own reports with variables I would like to see. It's saved me a lot of time
I asked for help by the support and they were fast and good.
Thanks.
KingToys

Anonymous

2013-05-08

Works exactly as stated
Have tried a couple of other extensions/modules to export orders, but they did not quite work. This extension/module does exactly what it says on the tin.
It is very easy to use, and understand, you can even make new export templates as needed.
The developer seems to be always there ready to help if needed, though I have not needed any help, we have been discussing adding to the module to accommodate tracking information, this enhancement would make it even better for the Google Trusted Stores feed,
Third module by Wyomind and have not had a problem with any.

vehicleartz

2013-05-04

Another High Quality Extension from Wyomind
This is my 3rd extension I purchased from Wyomind and the quality of their extensions are consistently high. You will be able to tell that they put a lot of thoughts into designing and developing their extensions.
I previously purchased the data feed manager which now has been sweetly running for 6 months on multiple product comparison sites including Google merchant.
What really shines about this extension is the ability to custom the outputs, and even inserting your own script to do your own calculation. It takes all attributes from Magento to assist you generating most accurate order output. It is a very flexible module with plenty of features.
Admin interface is simple to use.
I'm not a programmer, so support is very important for me and their support team never fail to promptly answer all of my questions. My experience is not a once off, I have always utilised their support with my purchase of their extension.
I look forward for the purchase of another useful & high quality extension from Wyomind.

exeltek

2013-04-22

This extension is extremely good.
This extension is extremely good. And the person deicated to support for this is also excellent.
Overall, a very useful extension.

Triyugi

2013-03-07

Without a doubt the best
Having tried several other order exports I have to say this is without a doubt the best. Its totally customisable and has enabled me to create various different export types for delivery partners and accounts purposes. It saves me literally hours every day.

Support is also absolutely brilliant from Wymomind, Ive bought several extensions and have always been assisted with any setup challenges with very patient and prompt support. If you need a powerful order export extension, this is it!

logicc

2013-01-13

Tool works like a charm.
Tool works like a charm. Makes it very easy to create your own reports with variables you like. Saved me a lot of time.

info348

2012-12-21

logo of PayPal


We are proud to be
magento partner

Support or enquiries by email 7/7 . answer under 24h*

15 days money back guarantee

Free Lifetime Support

3 months free updates