![Syde [formerly Wyomind]](http://www.syde.shop/cdn/shop/files/logo_noir.svg?v=1790605670&width=118){kind=logo}
![Syde [formerly Wyomind]](http://www.syde.shop/cdn/shop/files/logo.svg?v=1790605675&width=118){kind=logo}
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:
Those instances describe which products have been ordered and gives details about the customer's addresses.
There are 4 other sub-instances that help to store the different steps in the order process:
The above instances can be simply summarized:
Of course, there is much more data that you can extract from your Magento database and this is where Mass Order Export can help.
Mass Order Export enables the export of all the order data 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 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 to the output file to make it readable.
Dynamic values are data that are different for each order such as price, address, the product ordered...
Imagine you want to export all the orders placed into your Magento website and what you want to get is a simple TXT file including the order number and the total amount of each order. What you get should look like:
#123456789 $150.00
#234567891 $275.00
#345678912 $450.00Your template would be very simple:
#{increment_id} ${total_paid}# and $ 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 as {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 orders. 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.
Mass Order Export is quite easy to use. You'll need 4 steps to configure your extension. Once these steps completed, your extension will be ready to use.
To configure your extension, first go to:
System › Configuration › Wyomind › Mass Order Export
There you get two subtabs.
Mass Order Export allows you to enable cron job reporting.
Note that the Core Settings part is for advanced users.
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 FTP configuration, and the scheduled tasks in order to generate the profile.
You can edit or create a new profile from:
Sales › Mass Order Export › Export Profiles
From there, you have the possibility to delete or generate several profiles at a time.
When creating a profile, you should see a black box on the right of your screen. The Mass Order Export extension includes that tool to help you create your profile and see what is wrong.
The black box is inevitably a very useful tool. This will help you to configure your data feed more quickly.
Here are the different options of the black box:
This button allows you to check if your syntax is correct. It helps you to see if you have forgotten a bracket or a comma by underlining in yellow the part of text that contains a mistake.
You might want to know which syntax to use? No worries, Mass Order Export includes a full library of all data available for all instances: order, products, payment, invoice, shipment, creditmemo...
When clicking on that button, you'll see a preview of your profile. It's very useful to see if the values are correctly retrieved or if your filters are working.
When creating or editing an export profile in Mass Order Export, you have to be aware of some basic settings.
Choose the types of products you want to export.
This section allows you to define which group of orders must be exported.
In this tab, you'll be able to configure your profile template according to your needs. Mass Order Export allows you to create different kinds of file:
An XML template is made up of 3 parts:
<orders><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></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}-2">
<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 be 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}To create a CSV/TXT data feeds, you just have to choose 'CSV' or 'TXT' in File type, in the Configuration tab. The template tab will be updated to match the file type.
The main difference with the XML mode is that you can't use any iteration instructions. Instead, Mass Order Export 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
...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.
This section allows you to specify the type of order you want to export. At least one status must be selected.
In this tab, choose the customer group of the orders you want to export. At least one customer group must be selected
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 orderYou can also export orders placed by customers whose last name ends with 'son':
order > customer_lastname | like | %sonYou have a choice between several options:
With Mass Order Export, you have many possibilities to export your profiles.
The first solution is to store your file directly on your server.
You can also configure the FTP settings. For example:
wyomind.com
/var/export/ftp
Finally, you can choose to send your profiles by email. Don't forget to separate the email addresses with a comma.
In that tab, you can choose the days and hours when you want your profiles to be generated.
Now that your profiles are configured, you can export your orders into these files.
You will be able to see to which profile each order has been exported in:
Sales › Orders
For each order, different notifications will be displayed in the Exported to column:
There are several ways of exporting your orders to anyone of your profiles.
By generating a profile, the orders that match with the profile configuration are automatically exported to that file.
Choose a profile and simply select the Generate option from the Action dropdown in
Sales › Mass Order Export › Export profiles
A message is displayed and indicates how many orders have been exported to the file.
Choose an order and click on View in:
Sales › Orders
There you can select a profile for each product of the order. For example: default
Go back in:
Sales › Orders
In the Exported to column, the order displays:
=> default
This means that the order will be generated to that profile.
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.
2 options are interesting in the Configuration tab of your profile from:
Sales › Mass Order Export › Export profiles
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 › Orders
Then, when the profile will be run, the order will be exported a new time.
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 credit memo) or you might need to use the value of one attribute but with a computed output.
Mass Order Export allows creating your own customized attributes directly from your admin panel by using some PHP code.
In order to create a valid customized attribute, you must respect these rules:
Below are 3 examples of common customized attributes:
<?
$product=Mage::getModel('catalog/product');
$product->load($item->getProductId());
$value=$product->getColor();
return $value;
?>or
<? return Mage::getModel('catalog/product')->load($item->getProductId())->getAttributeText('color'); ?><? $skus = array();
foreach ($data['products'] as $product) {
$skus[]= $product->getSku();
} return implode(',',$skus);
?>
<? switch($item->getStatus()){
case 'canceled': $value= 'MerchantCanceled'; break;
default : $value= 'BuyerCanceled';
} return $value;
?>This extension works with Magento Community Edition and also Magento Enterprise Edition. To know if Mass Order Export is compatible with your Magento version, please check the Compatibility tab.
We offer our customers who want to migrate their Magento 1 license to a Magento 2 license, the transfer at a reduced price.
You have the possibility to migrate your license directly from your Wyomind account in:
My account › Licenses & Downloads
Click on migrate to magento 2 in front of the extension and the domain you want to transfer.
Confirm you want to migrate your license to a Magento 2 license by clicking on Confirm and checkout .
An invoice will be automatically added to your account from:
My account › Invoices
The price of the transfer is equivalent to a 30% reduction compared to the price of the regular Magento 2 license.
You can proceed to the payment by clicking on PP .
Once the payment is done, you can go back to:
My account › Licenses & Downloads
There you will be able to download and install your license for Magento 2.
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 one.
If you run several domains on the same Magento installation, you will need only one license for all of them.
Although your license doesn’t have a limited period of validity, your support period does. By purchasing an extension, you’ll be granted a 6-month support period for free. Passed this period, you will have to renew your Support plan (see FAQ: How to extend my support period?).You can pre-register your live domain to your license 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:
next to the extension you want your domain to pre-register on.
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 2 cases:
To be able to use Mass Order Export on both your production and testing environments, follow the instructions below:
Now that you can use Mass Order Export on your production environment, repeat the same steps as above on your testing environments.
The only difference this time: a notification will appear in your Magento admin.
You will be given a choice between:
Click on Add this domain to my license.
A transfer request will then be sent to our team within an hour.
Once the request is taken care of, you will receive a confirmation email.
If your transfer request is accepted, you can use Mass Order Export on both environments at the same time.
The order in which you activate your license on your domains does not matter.In order to download Mass Order Export, log into your Wyomind account:
icon next to Mass Order Export.
A new window opens.
Your download can start.
When purchasing an extension from wyomind.com, you benefit from a lifetime upgrade. You can at any time download the latest version of the extension directly from your account.
To upgrade Mass Order Export, follow the steps below:
next to Mass Order Export.
To uninstall Mass Order Export, go on its zip folder and open it.
You will find a shell file (such as: yourextension-uninstall.sh) that you must 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).
Before installing Mass Order Export, you’ll have to:
Now you can install Mass Order Export:
Next step is to activate your license, to do so, click here: Extension activation
Once Mass Order Export is installed, you have to activate the license:
configuration › advanced › advancedIf the message doesn't appear then you must check that:
Wyomind's License Manager has not been removed from your installation.
Wyomind's License Manager is enabled in: app/etc/modules/Wyomind_Licensemanager.xml
The HTML output for Wyomind_Licensemanager and/or Adminhtml_Notification are not disabled in your system under: system
To activate the license of an extension that includes other modules, you’ll have to repeat the steps described above for each extension, using the corresponding activation keys (each module has its own activation key).
To download your file, you need to:
Mass Order Export provides you with a fully configurable schedule in the Scheduled task tab of your template configuration for each data feed.
Warning: So that it works, you must
have one main scheduled task running from your server side and targeting cron.php (or cron.sh) located in the Magento root directory (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: http://www.mywebcron.com.
Mass Order Export also provides you with a cron job reporting, so you can get email reports on each data feed you will generate.
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.
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.
It's possible to use the if/else statements by using some php code.
<? if ("{country_id billing}" == "US") return "8000"; else return "8001"; ?>Example: If the billing country id is Belgium return 8000 else return 8001.
Here is how to retrieve state/region from the shipment address of a customer:
{country_id shipping}/<? return Mage::getModel('directory/region')->load({region_id shipping})->getCode(); ?>Example: If the shipment address is located in California, then this will return: US/CA.
For example, you want to retrieve "France" instead of "Fr". In that case, you can use:
<? return Mage::app()->getLocale()->getCountryTranslation("{country_id shipping}"); ?>To retrieve the custom options of ordered products, you need to create a custom attribute in:
Sales › Mass Order Export › Custom Attributes
$attribute = "Color"; /* You must replace the value with the label of the attribute */
$o = unserialize($item->getData('product_options'));
foreach($o['attributes_info'] as $opt) {
if ($opt['label'] == $attribute) return $opt['value'];
}For another option called example:
$attribute = "Example"; /* You must replace the value with the label of the attribute */
$o = unserialize($item->getData('product_options'));
foreach($o['attributes_info'] as $opt) {
if ($opt['label'] == $attribute) return $opt['value'];
}Mass Order Export 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 orderYou can also export orders placed by customers whose lastname ends with 'son':
order > customer_lastname | like | %sonYou have the choice between several options:
In Mass Order Export, you can specify ftp settings to upload your file.
Select a file and go to the Ftp Settings tab. There you'll be able to configure some parameters:
wyomind.com
/var/export/ftp
The file is uploaded each time the feed is generated manually or automatically.
It can be due to an incorrect configuration or to a problem from your server. You need to check several things:
Here is an example of an FTP configuration:
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 234It probably comes from installing an extension while the compiler is still enabled.
Important note:
Here is how to disable the Magento compiler:
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');If you're getting a white page using the extension, you should enable the error reporting in order to display the error. You can do that from index.php.
How do cron tasks work:
Be sure that you have correctly configured a scheduled task from the server side (cpanel) targeting the cron.php file in your Magento installation.
The extension includes reporting and debug tools for the scheduled tasks in:
system › configuration › Wyomind › Mass Order Export
We also strongly advice to install the AOE Scheduler that will help you to monitor the Magento cron tasks.
This issue may be due to a problem during the installation process.
You can fix it by following these steps:
Be careful, that entry depends on your extension. For example, if you have the extension called Simple Google Shopping, you should delete simplegoogleshopping_setup.
If when saving your data feed configuration, you get:
Forbidden, You don't have permission to access /.../ on this server.
This is probably something regarding the hosting company that doesn't allow to post XML in the form.
The mod_security (security module) includes rules that stop all post/get requests including code.
In order to fix that issue, you should get in touch with your hosting company so that they can add some exceptions to the security rules.
The order details are missing from the Order view in:
Sales › Orders
In that case, replace the content of the default.phtml template by the content of the one available in your own Magento version in:
app > design > adminhtml > default > default > template > ordersexporttool > sales > order > view > items > renderer
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.
If your products/orders grid doesn't show any new columns, it means you may have some conflicts with other extensions.
Then, install the free extension Modules Conflict Detector from Alekseon. It will help you to check if you have conflicts in rewrites between installed modules.
Once the module is installed, you should be able to see what the problem if you go to:
Alekseon tools › Modules Conflict Detector
In our case, we can see that the Order grid is overridden by:
CompanyName_ModuleName_block_adminhtml_Order_Grid
In that case, copy the class name that overrides the default Magento grid, for example CompanyName_ModuleName_block_adminhtml_Order_Grid and go to:
System › Config › Wyomind › The extension
In the System tab, you're able to override 2 grids (depending on the module):
You should then paste the new class name into the appropriated field and save your config.
PT
We use XML to export orders from Magento and it is working well for us. It is almost three+ years we have been using it. I would recommend this product if you have a Magento store and need to export order to sync with some other system.
James
We are delighted with the Mass Order Export extension, it has saved us many hours of manual order processing and we couldn't function without it now!
Mark Manshanden
We use Wyomind's mass order export for a variety of uses. But the most important ones are: double check on the purchase invoices. Did we sell what we purchased and can the differences be explained. Further more we sell across different countries so need to do some paperwork to have our products cross the border. With Mass order export it is a piece of cake to export both order product information and self added constant values which relate to the different countries. The import/export information is automatically generated and distributed to our bookkeeping and customs department.
Peter T
Wyomind order export tool is working great for our website. we are using wyomind extensions more than 5 years for different websites. The order export tool extension have amazing functionality and meet your requirements. 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. solid and totally versatile piece of software absolutely useful for your M2 store.
Paul S
Being able to export all the orders into a CSV file is pretty essential for the way our business works, we can easily pass this information to our accountant. The 2 things I love about this plugin the most is the support and the flexibility. Having the ability to build my own own profile to export the exact data I need is really good, they provide you with all the info needed to do this. It's also possible to add data from other 3rd party plugins, you can do this using PHP staright within the admin, that makes this plugin super powerful. Previously I was using a similar plugin from another company with Magento 1, it was good but unfortunately the support was not available. Wyomind will go above and beyond to make sure the plugin works as advertised, keep up the good work guys!
Nicolas
Ce module est excellent pour mes exports comptable et tracking. Je l'utilise aussi pour du dropshiping. Le support est au top ! Ne pas hésiter.
Kimmo Räntilä
We had a problem with a script to find the orders we needed. Jean-Paul gave excellent superfast support. Now it works perfectly. Thanks!
Kimmo Räntilä
This extension has been great. We have used it to get a list for Intrastat export reports and find orders with certain products. Thanks.
Jelle
My client has been using the Magento 1 version of this extension for years. So it is needless to say, we needed it for Magento 2 too. The tool is fast and flawless. It's very flexible, as was the Magento 1 extension. Never had any issue with the support either. They're fast in responses!
Daniela Buehrig
The data Mass order export extension is easy to use and to implement. Have used this extension for M1EE and for M2EE and currently is in use for M2EE 2.3.5. However, with the upgrade to 2.3.5 we see some inconsistencies in performance. Nothing that can't be solved, it just requires a bit of time and effort to get it to work again. Whilst the last version was easier to configure, the current version allows more flexibility as you can create unique data comands.
Peter
Have used this extesions for more then 3 years on M2 and many more years on M1 and works really good. Can take some time to load big feeds and can also be a bit buggy when upgrading. But overall I would say its a good module that allow you to get the customized data you need.
Carlos
I've been using this extension for more than 4 years and it has been very useful for our eCommerce. The option of using PHP script to get customized data from the system is a great differential for us. Recommended.
Nicola
excellent for exporting orders to invoicing management systems, great extension and great assistance
Scafflaw
Great extension with lots of flexibility to get the export file you need.
KaffeTilbud.dk
If your webshop in magento starts to run a bit and you are in a market with many competitors, the price pressure is high and the margins are low. With many orders and weekly price adjustments, it is difficult to monitor the overview of profitability. Thanks to Wyominds export tool, we can. The weekly export gives us a direct overview of how much we have left over per order and what the webshop has delivered last week. That gives you peace of mind.
Thiago
Our store needed to export orders in different formats to integrate sales data with ERP, CRM and the post management system. All of this was possible with the Order Export Tool module. Today we have a data export profile for every need, working perfectly.
daniela
The extension is very easy to implement and it works without any problems. The support team is super responsive and try to action things as soon as possible. The extension does exactly what is promised.
Paul
Great extension, works as expected. If there are any technical issues support staff are very good
Ben
Excellent extension which has endless power and customisation. Any questions and support team are there to help
Tait
We've been using Wyomind extensions for years and always have great support. The Order Export module is superb and allows so much flexibility. The support team are always quick to react and help us to resolve any issues.
How merchants put Mass Order Export to work, step by step.
Initial release for the master version
Initial release for the legacy version
<? $this->load(["product","invoice"]); ?>
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}
{product::start}
<order_id>{increment_id order}</order_id>
<sku>{sku product}</sku>
{product::end}
Patch:
Patch:
Specific needs or any ideas of enhancements and new features to add to the extension? Tell us more, we'll get back to you shortly!