Orders Export Tool

Starting at
€95
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.
Starting at
€95
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 sample templates.
Starting at
€95
Orders Export Tool
is available for Magento® 2
The basic knowledge about Magento® 2 and order management
How Magento® 2 deals with the orders?
From Magento 2, the orders are managed as a structured group of data that are shared in different database table instances.
There are several instances from which the main one is the Order table that contains the summary of all the orders that have been placed (date, total amount, tax, customer...).
There are also 3 sub-instances that concern the order details. Those instances describe which products have been ordered and give details about the customer's addresses:
- Product
- Shipping address
- Billing address
The 4 following sub-instances help to store the different steps in the order process:
- Payments
- Invoice
- Shipment
- Creditmemo
Orders Export Tool will help you to extract much more data from your Magento 2 database.
How the Orders Export Tool extension exports the data in Magento® 2?
Orders Export Tool allows you to export all the orders data from your Magento 2 admin into XML or TXT/CSV files. These files can then be transferred into your CRM/ERP software or can be used for reporting purposes.
The way the Orders Export Tool extension deals with the orders data is very simple. When configuring your export profile, you have to complete a pattern 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 whereas Dynamic values are data that are different for each order such as price, address, product ordered...
To add the dynamic values to your pattern, you need to use a specific syntax as on the example below.
For example, you want to export all the orders placed into your Magento 2 website and you want to get a simple TXT file including the order id and the total amount of each order.
#123456789 $150.00
#234567891 $275.00
#345678912 $450.00
In your pattern, you should then copy:
#{{order.increment_id}} ${{order.total_paid}}
# and $ are static values while {{order.increment_id}} and {{order.total_paid}} are dynamic values that change for each order and that refer to the Order instance.
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 in 4 steps?
Orders Export Tool is quite easy to use. You'll need to follow 4 steps to configure your extension for Magento 2. Once these steps completed, your extension will be ready to use.
STEP 1: Configure Orders Export Tool in a general way
To configure Orders Export Tool for Magento 2, you need to go to Stores > Settings > Configuration > Wyomind > Orders Export Tool. There you get two subtabs.
- Cron job reporting
Orders Export Tool allows you to enable cron job reporting.
You have the possibility to send these generation reports to email addresses (they must be separated by a comma).
You can also change the report name as you want.
- Advanced settings
In that tab, you will be able to enable the log files.
You will also have the possibility to automatically execute profiles when an order is placed by filling the profile ids that you will find in Sales > Orders Export Tool > Export Profiles.
In the case where the grid is already overwritten by another module, you'll be able to easily modify the orders grid to override.
STEP 2: Configure your profiles
During that step, the different tabs that can be found in the configuration of a profile will be described. First, the profile configuration will be detailed followed by the different kinds of templates, the filters that can be created to adjust your configuration, the different storage outputs and the cron schedule in order to automatically generate the profile.
Orders Export Tool provides you a tool to help you configure your profile as you want. When editing a profile you'll find a toolbox on the right of the window.
You can open this toolbox by clicking on one of the following tabs:
- Preview: This will help you to check in real time the data retrieved by the values you added in the profile template.
- Library: It will list all data available for all instances: order, products, payment, invoice, shipment, creditmemo...
Configuration
When creating or editing an export profile in Orders Export Tool, you have to be aware of some basic settings.
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 automatically.
- Encoding type: choose the encoding type you want to use.
- File type: that defines if you want either an XML file type or a CSV/TXT file type. Depending on these settings the template section will be managed differently.
- File name format: your file name can be completed with the current date at the time of the exportation. Different formats are available.
- Create one file for each order: choose to export one order per file or not.
- Add a counter as the 1st column: choose if you want the first column to be a counter.
- Increment column header: define a name for the first column (counter).
Products to export
Choose the types of products you want to export.
Orders to export
This section allows you to define which kind of orders must be exported.
- Export from Store view: 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 an 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.
- Mark each exported order: allows you to flag each exported order as exported in Sales > Operations > Orders.
- Export only unmarked orders: allows you to specify that only the orders not yet flagged must be exported.
Orders will be marked only if they have been exported to a profile. If you need to export orders that have already been exported whereas you've defined Export only unmarked orders on YES, you can untag them by clicking on the cross.
- Update the order status: allows you to update the order status or not.
In the case where this last option is on YES, two new fields are added to the configuration:
- New order status: allows you to define the new status of the order.
- Message in the order history: you can also define a specific message in the order history.
Template
In this tab, you'll be able to configure your profile template according to your needs. Orders Export Tool allows you to create different kinds of file:
- XML profile
- CSV / TXT profile
XML file template
An XML template is made up of 3 parts:
- Enclose xml tag content inside CDATA (recommended): choose to enclose the content of your XML tags between CDATA or not.
- Header pattern: is at the start of the file: <orders>
- Order pattern: is iterated for each order included in the file
<order>
...
</order>
- Footer pattern: 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:
<items>
<?php foreach($products as $product): ?>
<item id="{{product.item_id}}">{{product.name}}</item>
<weight>{{product.weight}}</weight>
<?php endforeach; ?>
</items>
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 be repeated for each product and all dynamic values will be replaced:
<?php foreach($products as $product): ?>
...
<?php endforeach; ?>
These iteration markers can be used for all order instances:
<?php foreach($payments as $payment): ?>
...
<?php endforeach; ?>
<?php foreach($invoices as $invoice): ?>
...
<?php endforeach; ?>
<?php foreach($shipments as $shipment): ?>
...
<?php endforeach; ?>
<?php foreach($creditmemos as $creditmemo): ?>
...
<?php endforeach; ?>
CSV / TXT file template
To create a CSV/TXT profile, you just have to choose 'csv' or 'txt' as File type, in the Configuration tab. The template tab will be updated to match with the file type you've selected.
- 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 for 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.
- You can add a field by using the button Insert a new field. The fields can then be re-ordered easily by using the drag and drop 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 character you want to use 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
...
Filters
In the Filters tab, you can define the types of orders and customers you want to include in your export profile. You have also the possibility to create more advanced filters that will best meet your needs.
- Order status
This section allows you to specify the type of order you want to export. At least one status must be selected.
- Customer Group
In this tab, choose the customer group of the orders you want to export. At least one customer group must be selected
- Advanced Filters
In that tab, you can create more precise filters. For example, you can choose to export only one specific order by setting a filter:
order > increment_id | = | ID of your order
You can also export orders placed by customers whose last name ends with 'son':
order > customer_lastname | like | %son
You have the choice between several options:
=, >, <...
Equal to, greater than, lower than, greater than or equal to, less than or equal to, different from.
LIKE / NOT LIKE
like: starts / ends with the character string / includes the character string.
Not like: doesn't start / end with the character string / doesn't include the character string.
IS NULL / IS NOT NULL
is null: the value is null.
is not null: the value is not null.
IN / NOT IN
in: is in (selection of several options).
not in: is not in (selection of several options).
Output
With Orders Export Tool, you have many possibilities to export your profiles.
- Storage settings
The first solution is to store your file directly on your server.
- FTP settings
You can also configure the ftp settings in order to upload the generated profile to an external FTP server. For example:
Upload by FTP : Select Yes if you want to upload your profile using FTP.
Host : In that field, fill in the host. For example: wyomind.com.
Login : It is your login to connect to server.
Password : It is your password to connect to server.
Destination directory : It is a relative path from the entry directory when you connect to the ftp. For example: "/var/export/ftp".
Use SFTP : Select Yes if you are using SFTP.
Use Active mode : If you are using SFTP, you don't have to care about the passive/active mode.
- Email settings
Finally, you can choose to send your profiles by email. Don't forget to separate the email addresses with a comma.
The file is saved, uploaded or sent each time the feed is generated manually or automatically.Cron Schedule
STEP 3: Export your orders
Now that your profiles are configured, you can export your orders into these files.
From your Magento 2 backoffice, in Sales > Operations > Orders, you will be able to see to which profile each order has been exported. For each order, different notifications will be displayed in the Exported to column:
- √ default (X) : the order has been exported to the profile named default (only when the Mark each exported order option of the profile configuration is on YES).
- No profile defined: no profile is defined for the product(s) of the order.
- => default: the profile defined for that order is default.
You can export your orders to anyone of your profiles via several ways.
Generate the profile
Every time a profile is generated, the orders that are matching with the profile configuration are automatically exported to that file. From the Magento 2 back-office, in Sales > Orders Export Tool > Export profiles, choose a profile and simply select the Generate option from the Action dropdown.
A message is displayed and indicates how many orders have been exported to the file.
Manually export the orders
In Sales > Operations > Orders, choose an order and click on View. There you can select a profile for each product of the order. For example: txt_sample for a product and xml_sample for another one.
You can configure your profiles in Sales > Orders Export Tool > Export profiles.Go back in Sales > Operations > Orders. In the Exported to column, the order displays:
→ txt_sample
→ xml_sample
This means that the order will be exported to those profiles.
Now go back to the order View and click on Export. The order will then be exported to the profile(s) you've defined only if the order is matching with the configuration of the profile.
Export only unmarked orders
In Sales > Orders Export Tool > Export profiles, 2 options are interesting in the Configuration tab of your profile:
- Mark each exported order (in Sales > Operations > Orders)
- Export only unmarked orders
If you don't want to export several times the same orders, you can define both options on YES. Then only the unmarked orders will be exported.
If at any time, you want to export a new time an order that has already been exported, you have the possibility to unmark that order by clicking on the cross next to the profile name in Sales > Operations > Orders. Then, when the profile will be run, the order will be exported a new time.
STEP 4: Customize your profiles
With Orders Export Tool you can create your own custom variables and functions. You'll find examples in the following documentation that will help you to customize your profiles for Magento 2.
Create your custom variables
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 variables directly from your Magento 2 admin panel by using some php code.
To create a custom variable, go to Sales > Orders Export Tool > Custom variables and click on Add new.
Below are some examples of customized variables.
- Get the description of the product of the order
Scope = Product
Name = description
Comment = Retrieve the description of each product.
PHP Script =
<?php
$om = \Magento\Framework\App\ObjectManager::getInstance();
$model = $om->get(?\Magento\Catalog\Model\Product?);
$product = $model->load($item->getProductId());
return $product ->getDescription();
?>
- Get the SKUs of the ordered products:
Scope = Order
Name = skus
Comment = Retrieve the sku of each ordered product.
PHP Script =
<?php
$skus=array();
foreach($data["products"] as $product){ $skus[]=$product->getSku();
}
return implode(", ",$skus);
?>
Once you've created the custom variable, you can insert it into your XML or CSV file template.
For example, add {{order.skus}} to your file template, you should get the SKUs of all the products that have been ordered.
Create your custom functions
Orders Export Tool also gives you the possibility to create your own custom PHP functions.
To do so, go to Sales > Orders Export Tool > Custom functions and click on Add new.
You should now add your custom function in the PHP script field as follows:
<?php function example($self,$argument_1,$argument_2){
... do something with the arguments...
return $something;
} ?>
The variable $self represents the value of the attribute called when you use the custom function
Here is an example of custom function:
<?php
function parseDate($self,$format){
return date($format,strtotime($self));
}
?>
Once you've created the custom function and clicked on Save, you can insert it into your XML or CSV file template.
A custom function can be used in the template as follows:
{{any.variable php="example($self,'value 1','value 2')"}}
For example, add {{order.created_at php="parseDate($self,'m/d/Y')"}} to your file template. This will retrieve the formatted creation date of the order.
Note that you can't use a custom function on a custom variable.Manage your orders exports with ease thanks to Orders Export Tool for Magento® 2!
Easily export all your orders data into one file
- Export your orders, ordered items, payments, invoices, shipments and credit memos
- Export your data into XML, CSV and TXT files
Highly customize your data feeds profiles
- Add any attribute to your data feed templates
- Create you own attributes
- Add PHP code to your templates
Enjoy the precious help provided by the extension
- Start with the sample templates included in the extension
- Preview your data feeds and use the syntactic helper to avoid misprints
Automatically and regularly send your updated feed to any order management platform
- Use the scheduled tasks to automatically update and generate your data feed
- Send all your exports by email
- Upload your data feeds via FTP
Magento® versions supported by Orders Export Tool
This extension works with Magento Community Edition and also Magento Enterprise Edition. To know if Orders Export Tool is compatible with your Magento version, please check the Compatibility tab.
License validity
A license is valid for an unlimited period of time on one single Magento installation
If you use more than one Magento installation, you will have to buy a separate license for each.
if you run several domains on a same Magento installation, you will need only one license for them all.
Although your license doesn’t have a limited period of validity, your upgrade period does.
By purchasing an extension, you’ll be granted a 3-month upgrade period for free.
Passed this period, you will have to pay for a new one (see FAQ: Extension upgrade)License and testing environments
One license is valid for an unlimited period of time on one Magento installation only.
It is possible, however, to extend or transfer your license in three cases:- If you'd like to add your testing environments to your license.
In this case, it is possible to extend your license to an unlimited number of domains for free.
Forexample: mywebsite-staging.com or mywebsite-dev.com - If you redirected definitively one domain to another one (301 permanent
redirection ).
In this case, you can request a transfer of license for free. - If you'd like to shift your license from one Magento installation to another.
In this case, you can request a transfer of license which you'll have to pay for.
To be able to use Orders Export Tool on both your production and testing environments, follow the instructions below:
- Download Orders Export Tool (see FAQ: Extensions download).
- Install Orders Export Tool on your testing environment.
(see FAQ: Extensions installation) - Activate the license (see FAQ: Extensions activation).
- From your Magento admin panel,
Go to: stores CONFIGuration WYOMING YOUR EXTENSION
Enter your current Activation Key. - Save config.
Now that you can use Orders Export Tool on your production environment, repeat the same steps as above on your testing environments.
The only difference this time: a notification will appear on your Magento admin.
You will be given a choice in between: buy a new license now and add this domain to my license (see below).
Click on add this domain to my license.A transfer request will then be sent to our team within an hour.
The order in which you activate your license on your domains does not matter.
Once the request is taken care of, you will receive a confirmation email.
If your transfer request is accepted, you can use Orders Export Tool on both environments at the same time.
You can start with your staging/dev/local environment or with your live domain, the process will be the same.- If you'd like to add your testing environments to your license.
License and pre-registred environments
You can pre-register your live domain to your license and activate it in advance.
Thanks to this option, you'll be able to get the extension ready to use on your domain before it goes live.
To pre-register your production domain, go
to: account downloadsmy
And clickon next to the extension you want your domain to pre-register on.At the bottom of the page, below the list, click on the orange link saying:
Do you want to pre-register your domain in order to be ready to go live?
Finally, enter your domain name and click on PRE-REGISTER NOW
Extensions installation
There are three different options to install Orders Export Tool:
1. Manual installation
- Download Orders Export Tool (zip file) on:
my account my downloads
Refer to FAQ here: Extensions download - Once Orders Export Tool is downloaded, open the folder and unzip it.
- Copy the content of the unzipped folder and paste all files and directories in your Magento 2 root directory.
- In your Command Line Interface, execute:
If you are using a production mode, execute also:bin/magento setup:upgrade
bin/magento setup:static-content:deploy
bin/magento setup:di:compile
2. Installation via Composer
You can install Orders Export Tool using Composer software in two cases:- if you purchased Orders Export Tool on Magento Marketplace.
- if you purchased Orders Export Tool on Wyomind.com AND requested access to our repository: repo.wyomind.com
Add to your composer configuration our repository:
composer config repositories.wyomind composer https://repo.wyomind.com
Execute Composer command:
composer require wyomind/ordersexporttool
then go in your Command Line Interface and execute:
bin/magento setup:upgrade
If you are using a production mode, execute also:
bin/magento setup:static-content:deploy
bin/magento setup:di:compile
3. Installation via Web Setup Wizard
You can install Orders Export Tool via Web Setup Wizard if you purchased it from Magento Marketplace only.
To know how to proceed, click on the link below (all steps are described).
http://docs.magento.com/m2/ce/user_guide/system/component-manager.html
Next step is to activate your license, to do so, click here: Extension activation- Download Orders Export Tool (zip file) on:
Extensions uninstallation
To uninstall Orders Export Tool, go on the extension zip folder and open it.
You will find a shell file (suchas: yourextension -uninstall.sh) to execute on both your server and Magento root directory.
Once the uninstallation is over, refresh your cache and enable the compiler back again (if you use it).Extensions activation
Once Orders Export Tool is downloaded, you have to activate the license:
- Go to your Magento admin panel. A message pops up at the top of the page.
If the message doesn't appear then you must check that:
1. The Adminhtml_Notifications et Wyomind_Core modules are well enabled
2. The HTML output of the Adminhtml_Notifications and Wyomind_Core modules are not disabled in
stores configuration advanced advanced3. The encryption key well exists in app/etc/env.php
<?php return array ( 'backend' => array ( 'frontName' => 'admin', ), 'crypt' => array ( 'key' => '1e8f3c6772b7a6a6689c3c8cefa4ccf0', ), /* ... */ } ?>
- Copy your activation key.
You can find your activation key in 2 different places:
- In the confirmation email that you received after purchasing Orders Export Tool
- In your Wyomind account:MY ACcount My downloads
Select Orders Export Tool and click on
A new page opens where you'll find your activation key (see below). - In your Magento admin go to:
StoresConfiguration Wyomind Your extension
Paste the activation key in the Activation Key field and choose between the automatic (yes) or the manual (no) activation method
- By choosing Yes, the connection to Wyomind's license server will be automatic.
- By choosing No, you will have to log on to Wyomind's license server yourself. - Save config.
- A message appears at the top of your admin panel: Activate it now! Click on that link.
- Copy and paste the license code in the License code field from your admin or simply click on Activate now!
- Finally, refresh your cache, log out and log back in straight after, to complete the installation.
To activate the license of an extension that includes other modules, you’ll have to repeat the steps described above for each, using the corresponding activation keys (each module has its own activation key).
You can also use the command line to activate the license
bin/magento wyomind:license:activation Wyomind_ExtensionNamespace YOUR_ACTIVATION_KEY
- Go to your Magento admin panel. A message pops up at the top of the page.
How come I can't see mass actions in the orders grid?
If you are working on Magento 2.0.x, you'll have to rename:
Wyomind\ordersexporttool\view\adminhtml\ui_component\sales_order_grid_Mage_2.0.xml
into:
Wyomind\ordersexporttool\view\adminhtml\ui_component\sales_order_grid.xml
Extensions download
In order to download Orders Export Tool, log into your Wyomind account:
Extensions upgrade
With each purchased extension comes a free 3-month upgrade period, during which you can download and install the new versions of your extension. Passing this period, you will have to purchase an additional upgrade (price depends on how long the period is)
To upgrade Orders Export Tool, follow the steps below:- Go to: my account my downloads
- Click on next to Orders Export Tool
- Choose the latest version of Orders Export Tool (for Magento 1 and Magento 2).
- Click on download
- Enter your current activation key and click on
- Select domain name.
- Choose from 1 to 12 months upgrade period of.
- Choose a professional installation or not.
- Click on BUY NOW
To finish, don't forget to reinstall Orders Export Tool to update your Magento admin.
If you can't find your download after upgrading your domain, please contact us here:
https://www.wyomind.com/fr/contact.html
Can I open my CSV file with a spreadsheet application?
You have the possibility to open the generated CSV file with any spreadsheet application.
While opening your data feed, you need to make sure to select the delimiter options that correspond with your data feed configuration from your Magento 2 admin.
- In your data feed configuration (from Magento 2), choose how your columns will be separated with: tabulation, comma, semi-colon...
- Generate the data feed.
- Open the data feed with a spreadsheed application.
- Choose the same delimiter and enclosure characters as in your data feed configuration.
For example, if you've chosen semi-colon as Fields delimiter, then you'll need to open the file choosing ";" as field delimiter as well as if you've choosen double quotes as the Fields enclosure, then you'll have to make sure that you've selected the same character.
Note that the Excel application won't show this popup when opening the file.How to use filters with Orders Export Tool for Magento® 2?
Orders Export Tool offers you many possibilities to export your orders.You can set filters according to your needs. In the Filters tab of your profile configuration, you'll find 3 subtabs.
Order status
Select the types of orders you want to export. For example choose to export pending, processing and complete orders.
Customers group
In that tab, you can select the customers group of the orders you want to include in your data feed. For example choose to export orders placed by general and not logged in customers only.
Advanced filters
In that tab, you can create more precise filters. For example, you can choose to export only one specific order by setting a filter:order > increment_id | = | Id of your order
You can also export orders placed by customers whose lastname ends with 'son':
order > customer_lastname | like | %son
You have the choice between several options:
=, >, <...
Equal to, greater than, lower than, greater than or equal to, less than or equal to, different from.LIKE / NOT LIKE
like: starts / ends with the character string / includes the character string.
Not like: doesn't start / end with the character string / doesn't include the character string.IS NULL / IS NOT NULL
is null: the value is null.
is not null: the value is not null.IN / NOT IN
in: is in (selection of several options).
not in: is not in (selection of several options).How to configure the FTP settings with Orders Export Tool for Magento® 2?
In Orders Export Tool, you can specify FTP settings to upload your file.
From the Magento 2 admin, select a file and go to the Output tab. There you have 3 options to export your profile. If you choose to enable the FTP settings, here is how to configure each field:Enable FTP upload
Select Yes if you want to upload your data feed using FTP.Host
In that field, fill in the host.
For example: “wyomind.com”Login
is your login to connect to serverPassword
is your password to connect to serverDestination director
is a relative path from the entry directory when you connect to the ftp.
For example: "/var/export/ftp".Use SFTP
Select Yes if you are using SFTP.Use Active mode
The file is uploaded each time the feed is generated manually or automatically.
If you are using SFTP, you don't have to care about the passive/active mode.
For more info about Active and Passive mode, have a look to that documentation.Why my FTP upload doesn't work?
If your profile doesn't seem to be upload via FTP, it can be due to an incorrect configuration or to a problem from your server. Make sure that:
- your server allows the FTP access
- your credentials are entered without mistake
- the host is entered without directory following it
Here is an example of FTP configuration for Orders Export Tool on Magento 2:
Can I download my generated file?
Can I schedule the generation of my files with Orders Export Tool?
Orders Export Tool provides you a fully configurable schedule in the Cron Schedule tab of your pattern configuration for each data feed or profile.
So that it works, you need to have one main scheduled task running from your server side and targeting cron.php located in the pub directory of Magento 2 root directory (ideally every hour).
If the management panel from your hosting compagny doesn't provide such a service, you should be able to use a remote service such as: http://www.mywebcron.com
Orders Export Tool also provides you a cron job reporting, so that you can get email reports on each data feed or profile you generate.
"PHP features are disabled".
PHP features are disabled by default in Orders Export Tool.
If you're using PHP parameters in your variables or inline script in your patterns (<?php return ... ?>), you'll get an error saying: "PHP features are disabled".
In order to be able to use PHP script in your variables and patterns, you must make some modifications:
- in app/code/Wyomind/OrdersExportTool/Helper/Data.php:
replace:
public function execPhp($script, $order = null, $data = array(), $item = null) { return "Php features are disabled. In order to activate them please have a look at : https://www.wyomind.com/magento2/orders-export-tool-magento.html?section=faq"; }
with:
public function execPhp($script, $order = null, $data = array(), $item = null) { return eval($script); }
"Base table or view not found".
This issue may be due to a problem during the installation process.
You will be able to fix it by following these steps:
- Access your database via your control panel (Phpmyadmin for example).
- From the setup_module table, delete the entry Wyomind_ordersexporttool. Be careful, that entry depends on your extension. For example, if you have the extension called Simple Google Shopping, you should delete Wyomind_SimpleGoogleShopping.
- Logout from your Magento 2 admin.
- Log into your Magento 2 admin.
Magento® Community Edition
- 2.2.3
- 2.2.2
- 2.2.1
- 2.2.0
- 2.1.9
- 2.1.8
- 2.1.7
- 2.1.6
- 2.1.5
- 2.1.4
- 2.1.3
- 2.1.2
- 2.1.11
- 2.1.1
- 2.1
- 2.0.7
- 2.0.6
- 2.0.5
- 2.0.4
- 2.0.3
- 2.0.2
- 2.0.16
- 2.0.14
- 2.0.13
- 2.0.12
- 2.0.11
- 2.0.10
- 2.0.1
- 2.0
- 1.9.3 +
- 1.9.2 +
- 1.9.1 +
- 1.9.0 +
- 1.8.1 +
- 1.8.0 +
- 1.7.0 +
- 1.6.2 +
- 1.6.1 +
- 1.6.0 +
- 1.5.1 +
- 1.5.0 +
- 1.4.2 +
- 1.4.1 +
- 1.4.0 +
- 1.3.3 +
- 1.3.2 +
- 1.3.1 +
Magento® Enterprise Edition
- 2.2.3
- 2.2.2
- 2.2.1
- 2.2.0
- 2.1.9
- 2.1.8
- 2.1.7
- 2.1.6
- 2.1.5
- 2.1.4
- 2.1.3
- 2.1.2
- 2.1.1
- 2.1
- 2.0.7
- 2.0.6
- 2.0.5
- 2.0.4
- 2.0.3
- 2.0.2
- 2.0.16
- 2.0.14
- 2.0.13
- 2.0.12
- 2.0.11
- 2.0.10
- 2.0.1
- 2.0
- 1.9.1 +
- 1.14.3 +
- 1.14.1 +
- 1.13.1 +
- 1.13.0 +
- 1.12.0 +
- 1.11.2 +
- 1.11.1 +
- 1.11.0 +
- 1.10.1 +
- 1.10.0 +
Log into your account to leave your review and get up to 3 months of FREE Support & Upgrade
Very Useful extension and gives us what you want.
i m web designer and i m using wyomind extension from long. I must say that it works fantastically! The support team is friendly and fast.
Gilbert
19th April 2018
Best Export Extension and top support!
Fast and really nice support. Has saved us a lot of work. We can only recommend Wyomind and this extension.
Thomas - http://cbd-vital.at
6th March 2018
Very very good but I think their is a bug in the encrypted code
As said in the title this extension is very professional and flexible.You can export whatever attribute you want in whatever format you want. A problem I found is the export profiles are exported on the "checkout_submit_after_all" event, so if you redirect your client to a payment platform the export will occur before the payment is confirmed (so this can be an issue with you orders state for example). So I had to manually change the event in which the export is listening but it seems that this is causing a problem to mark orders as "exported" but as this part of the code is obfuscated I can't find where it's bugged... I hope I will get this problem fixed with the support which is reactive.
Pepe - http://monespacedesante.fr
27th February 2018
A very flexible extension that gives us all the options we needed
The Order export extension gave us access to all the order data we needed along with very flexible custom attributes. The choice of data delivery by a number of different methods and timed schedules was also very useful. Requests to Wyomind were responded to quickly and efficiently.
Gary Martin - https://www.bivouac.co.nz/
11th February 2018
Excelent
I am a web developer and I use Wyomind extensions on some clients and I find them fantastic. The Order Export Tool extension makes it easy and free to export data on orders, using output files on different channels.
Thiago
29th January 2018
Useful extension for many applications
I was looking for a bridge that would allow me to interface Magento 2 to my billing CRM, when I came across this extension that was right for my case. I must say that it works fantastically! The support team is friendly and fast.
Massimino Maria Rosaria - http://www.kinnik.it
23rd January 2018
Helped Us Export to QuickBooks
We used this extension in combination with ZedAxis to export to QuickBooks, perhaps not the smoothest solution, but it worked for us at the time, and it worked well. Very customizable, you can write your own PHP to really customize it as needed. Fairly simple setup, although we had a couple hiccups, it worked out fine, and support was solid in helping us to figure it out. This was the only extension we could find that would export each additional item in an invoice as its own line, duplicating the order information, rather than trying to cram it all into a single line(which makes for a very messy CSV file). We also used it for Stamps.com exporting and importing, since they haven't updated to support Magento 2 yet. So again, very versatile tool. Overall, very solid, just wish Wyomind would give lifetime updates, considering the price, and have us pay only for support.
Daniel Eck
14th January 2018
Wonderful tool
This is a must have export tool for Magento 2. Rock solid and totally versatile piece of software absolutely useful for your M2 store. My rating is 5 stars without any doubt.
Davide
27th November 2017
works, sometimes got some issues
Simple and works, but got some issue and hard to find out how to solve since not lot people use it I guess.
sennin32 - http://shopkey.doyustudio.com
22nd August 2017
The export tool help on export the custom shipping information
The export tool helps on export the custom shipping information where Magento 2 lack off. The function is catered all my requirement.
Leong
21st August 2017
Useful tool
It's quite helpful to process/automate order processing on a busy site. Easy to configure.
Optima
7th August 2017
Saved us a lot of manual work!
Before using the Wyomind export extension, orders placed on our website were all keyed in manually. Since installing, the orders are pushed into our shipping system automatically. It's reduced the workload on our customer service team, increases efficiency with faster order processing and works great!
Chris S
12th July 2017
Works great!!
The order export tool was easy to install and saves us a lot of data entry time entering orders into our ERP system. Highly recommend!
ben - https://www.hangers.com/
26th June 2017
Excellent and versatile tool
This module is a very good one as it allows you to create directly via back-end differentiated exporting profiles (i.e. export file formats) for your orders. So, if you use different shipment providers or if you change shipment provider, with this tool you have the flexibility to generate the files you need and pass them to the IT system of your used carrier(s). Also, the extended configuration facility offered by this module gives you the possibility to define what orders to export at a very granular lever.
Davide Cosnonni - https://www.advancedlogic.eu/
28th May 2017
Unable to include custom attributes in feed
I have a custom attribute eg "Player name" with input type field (the customer enters the player name before adding to cart). This appears in the order detail page. I need to include it in the feed. I expected this to be a standard feature.It requires writing php code. I haven't been able to come up with php code that works, and neither has the developer. Does anyone in the community have experience of this and can help please?
Xcom Dev
26th February 2017
Excellent Magento module
Perfect for exporting all Magento order information into the correct layout for us to import into our external company system. On the occasion where we have needed support it has been perfect and any issues resolved very fast. This magento extension is very highly recommended.
Garry
7th February 2017
Really useful!
This extension works perfectly on Magento 2.0.10 Flexible and useful I had a really good support from Wyomind. 5 stars of course
Linh PS
20th January 2017
Excellent module pour ma compta
Ce module est parfait pour faire un export pour la compta voir beaucoup plus !!! Il est hyper simple à utiliser et fonctionne très bien. Merci à toute l'équipe de Wyomind pour ce module génial.
Nicolas
5th January 2017
Worked like a charm
The extension works perfect, allowed us to easily generate a orders file to synchronize everything with our ERP automatically. The support is fast and reliable. Thanks!
CBDevelopers
27th December 2016
Useful thing
I have used this extension with Datafeed manager and Salescast connector export data into Lokad salescast system over two years. I use ftp scheduled sync to refresh salescast data in Lokad and there was no any bugs has been found in this time. Thanks for great stable module
Cermis
14th December 2016
Better than advertised.
We needed a bulk export tool for orders for invoicing suppliers, this tool exceeded our needs in exporting these data.Custom made attributes are easily included in export reports, a must have for us.Also this extension is really easy in configuration and use, no hours of studying the the possibilities needed!I will look at other extensions of Wyomind!
sendur
10th January 2016
Great Extension
This is a good extension, it works as described and is easy to use. This has already saved me heaps of time in being able to export information directly into my customer database and shipping tool. It is very flexible and I can already see a number of other areas this can help me with.Developer support was also very good. They had me up and running in no time. Thanks wyomind.
Ray24
3rd January 2016
SUPER!
This extension do what it says!To accommodate our specific requirements we needed an adjustment. The support was incredible fast and reactive!Thanks again guys! Great JOB..
manky27
20th October 2015
Very good
The Extension had a little error, but the support fixed it within a few hours. Very good extension and support!!! Thanks!
kimpink
30th September 2015
BRAVI: continuate così!
I recommend to all Magento users this extension especially for the support that is SUPER. I especially thank Pierre and Paul who are patient, professional and very fast in solving problems.Thank youPietro
adesart
20th March 2015
The best export extension on the market
If you are searching for an excellent extension for exporting your orders which you can import into almost any system, you have to buy this extension! You can customize the extension in the exact way you want it, and if you need any help, you can contact the support team and you will get help within 10-30 minutes, it's fantastic! Not only ftp upload is availabe, it's also possible to send export files to your email!
JB323
9th December 2014
Excellent !!!
Support is great,reactive,... and product let us a lot of flexibility.Congratulations for this module.Arnaud
arnauddevass
1st November 2014
Awesome Extension & 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
8th July 2014
EXCELLENT!
HiI 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
5th February 2014
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
17th January 2014
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
3rd December 2013
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
3rd December 2013
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
18th October 2013
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
11th July 2013
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
24th June 2013
Great product, great support
The extension works perfectly as expected. My question got immediately responded by the support team.Higly recommended.
stijndw
16th May 2013
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
13th May 2013
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 timeI asked for help by the support and they were fast and good.Thanks.KingToys
Anonymous
8th May 2013
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
4th May 2013
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
22nd April 2013
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
7th March 2013
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
13th January 2013
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
21st December 2012
Log into your account to leave your review and get up to 3 months of FREE Support & Upgrade
- v7.0.1released on 16/02/2018
- Fix for Magento Enterprise Edition and split databases.
Patch v7.0.1.3
- Fix for the command lines
- Setup script updated (1 undeclared variable fixed)
- v7.0.0released on 18/10/2017
Enhancements
- Magento v2.2.1 compatibility
php parameter is deprecated, output parameters must be used instead- Use of the Magento 2 native dialog/modal windows
- The Blackbox can now be minimized/maximized and/or collapsed/expanded
- Better support of the merging/bundling/minifying JS and CSS files
- Allow the upper cases in the custom variables names
- Javascript "use strict" mode
- Fix for the custom function registering
- Fix for the cron task class name
- Fix for the mass export from the mass action dropdown
- Profile_id is now registered in the export_to column of the sales_order_item and sales_quote_item tables
- Fix for the custom variables and custom options registering
- Js fix for the
txt /csv columns
- v6.1.1released on 28/09/2017
Compatibility
- Compatibility with
magento v2.2
- Compatibility with
- v6.1.0released on 31/05/2017
Enhancement
- new event available : ordersexporttool_order_export($data=[$order, $isPreview])
This event is triggered each time a export file is generated
- Hide the success messages on the frontend after checkout
Enhancement
- temp files are deleted even for export of single orders
- Optional auto-increment on the 1st column of the
csv /txt exports fixed
- Display of a notification message on the checkout success page removed when export is triggered on checkout
- new event available : ordersexporttool_order_export($data=[$order, $isPreview])
- v6.0.0released on 28/03/2017
Improvements
- Better management of Javascript files
Enhancements
- Blackbox is back
- Drag and drop available on the preview/library window
- Hide the success messages on the frontend after checkout
Enhancement
- temp files are deleted even for export of single orders
- Optional auto-increment on the 1st column of the
csv /txt exports fixed
- Display of a notification message on the checkout success page removed when export is triggered on checkout
- v5.0.10released on 11/11/2016
Improvements :
- Add a CLI option to export profiles
- Events are dispatched when files are generated or uploaded
- Display of a notification message on the checkout success page removed when export is triggered on checkout
- v5.0.9released on 27/07/2016
Bug Fix:
- Fix for csv files
Improvements:
- Better orders filtering
- Display of a notification message on the checkout success page removed when export is triggered on checkout
- v5.0.8released on 02/07/2016
Bug Fix:
- Minor fix for multiple store views export
- Display of a notification message on the checkout success page removed when export is triggered on checkout
- v5.0.7released on 29/06/2016
Bug Fix:
- Fix when removing columns in TXT/CSV files
- Display of a notification message in the checkout success page removed when export is triggered on checkout
- v5.0.6released on 16/06/2016
Bug Fix:
- Fix in the orders view in Sales > Orders
- Display of a notification message on the checkout success page removed when export is triggered on checkout
- v5.0.2released on 07/02/2016
Enhancements:
- New management of licenses for Magento 2
- Display of a notification message on the checkout success page removed when export is triggered on checkout
- v5.0.0released on 22/12/2015
Compatibility:
- Orders Export Tool is compatible with Magento 2
- Display of a notification message on the checkout success page removed when export is triggered on checkout
- v4.2.1released on 22/09/2017
Improvement
- Exported orders can now be sort by any field (increment_id, entity_id, created_at,...).
Patch v4.2.1.1
- Fix for the update script of v4.2.1
- v4.2.0released on 30/09/2016
Enhancements
- /baseline/ and /headline/
key words can now be used in the same profile Csv /txt file can now use an escaper character- For developer: you can now force the loading of entities by using a
php code in the header<? $this->load(["product","invoice"]); ?>
- Code cleaning
- Updated templates for Magento 1.8.x
- Mass Action to generate several profiles
- New options to generate profiles from urls, examples below:
http://www.website.com/index.php/ordersexporttool/ordersexporttool/generate/id/1,2,3,4,8/order/145000006,145000003/ak/{YOUR_ACTIVATION_KEY} http://www.website.com/index.php/ordersexporttool/ordersexporttool/generate/order/145000006,145000003/ak/{YOUR_ACTIVATION_KEY} http://www.website.com/index.php/ordersexporttool/ordersexporttool/generate/ak/{YOUR_ACTIVATION_KEY}
- /baseline/ and /headline/
- v4.1.3released on 18/08/2016
Improvement
- Mix of different sources of object in the template is now allowed, by example :
{product::start} <order_id>{increment_id order}</order_id> <sku>{sku product}</sku> {product::end}
- Mix of different sources of object in the template is now allowed, by example :
- v4.1.2released on 03/06/2016
Enhancements:
- Management of .dat format files
- v4.1.1released on 22/04/2016
Bug Fix:
- Fix for the orders status update
- v4.1.0released on 09/02/2016
Enhancements:
- New management of licenses
- v4.0.1released on 27/10/2015
Patch:
- Compatibility fix for Magento Security Patch SUPEE 6788
- v4.0.0released on 25/03/2015
New features:
- Possibility to send the exports by email
Patch:
- Compatibility fix for Magento Security Patch SUPEE-6285
- v3.4.0released on 26/09/2014
Enhancements:
- Better compatibility with Magento > 1.4
- Automatic change of the order status
- Generated link on the profile page
- v3.3.2released on 20/06/2014
Bug Fix:
- Fix on orders filtered out by using php code
- v3.3.1released on 22/05/2014
Enhancements:
- Better files management after generation and before FTP upload
- v3.3.0released on 10/02/2014
Enhancements:
- Simplified interface
- Possibility to run an export when a customer is placing an order
- Creation of a log file when logs are activated
- v3.2.1released on 16/10/2013
Enhancements:
- New cron tasks management
- No upload for empty files
- Flags update
Bug Fix:
- Fix on json_decode
- v3.2.0released on 30/07/2013
New features:
- Possibility to filter product fields
Enhancements:
- Optimized filters
- v3.1.0released on 29/07/2013
New features:
- Additional function: baseline
- v3.0.1released on 29/07/2013
Bug Fix:
- Fix on the export (multiple files)
- v3.0.0released on 07/06/2013
Enhancements:
- Optimized script
- New management of product types
- v2.9.0released on 04/06/2013
New features:
- SFTP upload
- v2.8.0released on 29/05/2013
New features:
- New option to manage exported product relationship
Bug Fix:
- Fix on line break
- v2.7.0released on 30/04/2013
New features:
- Additional header
- TSV and DIN file extensions support
- Encoding type selection (UTF8 or ANSI)
Bug Fix:
- Fix on cron conflict
- v2.6.1released on 09/05/2013
Bug Fix:
- Fix on product instance for CE
- v2.6.0released on 29/04/2013
New features:
- Split one CSV line into several sub-lines (eParcel requirements)
Enhancements:
- Easier custom attributes management
- v2.5.0released on 23/04/2013
New features:
- New function: breakline
- v2.4.0released on 15/04/2013
Enhancements:
- Code cleanup
- v2.3.2released on 02/04/2013
Enhancements:
- Data consolidation (CSV mode)
- v2.3.1released on 12/03/2013
Enhancements:
- Cron file update
- v2.3.0released on 25/01/2013
New features:
- New advanced options
Enhancements:
- Files format update
- v2.2.0released on 15/01/2013
New features:
- New export options
- 'Order by' filtering option
- Generation of one file for each exported order
- v2.1.0released on 07/01/2013
New features:
- Each order can be marked as exported for one or more profiles
- Filters by status rather than by states
Enhancements:
- Improvements in the profile configuration
- v2.0.1released on 21/12/2012
Bug Fix:
- Minor fix
- v2.0.0released on 26/11/2012
- First Release
-
http://demo.wyomind.com/
OrdersExportTool / OrdersExportTool123
-
http://demo2.wyomind.com/
ordersexporttool / ordersexporttool123
7
years of experience
2 Solution specialists
3 Front End developers
3 Certified developers
2 Certified developers plus
27 214
Customers
37 859 websites
2 000
Emails replied per month
15 min average response time (office hours)
1317
Reviews
4.9 average rating