Logo Wyomind Magento workshop

Add-ons for Magento®

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.

48 Reviews
Pre-sales informations
  • 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 and domains
  • 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 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 and upgrade period does. By purchasing an extension, you’ll be granted a 6-month support and upgrade period for free.
    Passed this period, you will have to pay for a new one (see FAQ: Extension upgrade).
  • 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.
      For example 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 license transfer for free.
    • If you'd like to shift your license from one Magento installation to another.
      In this case, you can request a license transfer 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:

    1. Download Orders Export Tool.
      (see FAQ: Extensions download)
      .
    2. Install Orders Export Tool on your production environment.
      (see FAQ: Extensions installation)
    3. Activate the license.
      (see FAQ: Extensions activation).
    4. From your Magento admin panel, enter your current Activation Key from:
      syStem CONFIGuration WYOMING YOUR EXTENSION 
    5. 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 in your Magento admin. 

    You will be given a choice in between:

    1. buy a new license now
    2. add this domain to my license


    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 Orders Export Tool on both environments at the same time.

    The order in which you activate your license on your domains does not matter.
    You can start with your staging/dev/local environment or with your live domain, the process will be the same.
  • Domains pre-registration

    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:

    my account downloads

    And click on   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 .

Extension Installation/Uninstallation and Activation
  • Extensions installation

    Before installing Orders Export Tool, you’ll have to:

    • Backup your Magento installation in:
      system  tools   backups
    • Disable the compiler in your Magento admin panel if it’s not already disabled:
      system  tools   COMPILATIONS
    • Refresh your cache in:
      systemselect cache typeactionsrefreshsubmit


    Now you can install Orders Export Tool:

    1. Download Orders Export Tool (zip file) from:
      my account my downloads
      Refer to FAQ here: Extensions download
    2. Once Orders Export Tool is downloaded, open the folder and unzip it.
    3. Copy the content of the unzip folder and paste all files and directories in your Magento root directory (the folder content can vary according to the extension but it generally includes app, lib and skin folders).

    4. Once your installation is complete, don't forget to enable the compiler back (if it was already enabled before the installation) and run compilation process.
    5. Refresh your cache, logout from your admin panel and log back in right after.

    Next step is to activate your license, to do so, click here: Extension activation

  • Extensions activation

    Once Orders Export Tool is downloaded, you have to activate the license: 

    1. 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:

      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   configuration  advanced advanced
    2. 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).

    3. In your Magento admin go to:
      SystemConfiguration 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.


    4. Save config.
    5. A message appears at the top of your admin panel: Activate it now!  Click on that link.

    6. Copy and paste the license code in the License code field from your admin or simply click on Activate now!
    7. 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).

  • Extensions uninstallation

    To uninstall Orders Export Tool, 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).

Extension versioning and download
  • Extensions download

    In order to download Orders Export Tool, log into your Wyomind account:

      1. Go to:
        my account  my downloads 

      2. Click on   next to Orders Export Tool.


        A new window opens.

      3. Choose the version of Orders Export Tool.
        You will be able to choose the most recent version of Orders Export Tool (for both Magento 1 and Magento 2).


      4. Click on download .

    Your download can start.

  • Extensions upgrade

    With each purchased extension comes a free 6-month upgrade period, during which you can download and install the new version 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:

    1. Go to:
      my account  my downloads 
    2. Click on   next to Orders Export Tool.
    3. Choose the latest version of Orders Export Tool (for Magento 1 and Magento 2).
    4. Click on  download .
    5. Enter your current activation key and click on  .
    6. Select the domain name.
    7. Choose from 1 to 12 months of Support and Upgrade period.
    8. Choose a professional installation or not.
    9. 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:
    https://www.wyomind.com/fr/contact.html

Extensions use
  • Download the data feed

    To download your file, you need to:

    1. Generate the file.
    2. Right-click on on the generated link from the grid.
    3. Choose the Save as option.

  • Schedule the data feeds generation

    Orders Export Tool 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.

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

  • Open a 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.

    1. In your data feed configuration, choose how your columns will be separated with: tabulation, comma, semi-colon...
    2. Generate the data feed.
    3. Open the data feed with a spreadsheed application.
    4. 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.

  • Use 'IF' and 'ELSE' statements with Orders Export Tool

    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.

  • Retrieve state/region from the shipment address of a customer

    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.

  • Retrieve the country name instead of its code

    For example, you want to retrieve "France" instead of "Fr". In that case, you can use:

    <? return Mage::app()->getLocale()->getCountryTranslation("{country_id shipping}"); ?>
  • Retrieve the custom options of ordered products

    To retrieve the custom options of ordered products, you need to create a custom attribute in:
    SalesOrders Export ToolCustom Attributes

    1. Name your custom attibute color_option, and add below script:
      $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'];
      }​
    2. In you export template, use {color_option product} in the column you want.

    For another option called example:

    1. Create a custom attribute called example_option, and add below script:
      $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'];
      }​
    2. In the export template, use {example_option product}.
  • Use the filters

    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).

  • Configure the FTP Settings tab

    In Orders Export Tool, 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:

    • 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 server
    • Password
      is your password to connect to server
    • Destination 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
      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.

    The file is uploaded each time the feed is generated manually or automatically.

  • The FTP upload doesn't work

    It can be due to an incorrect configuration or to a problem from your server. You need to check several things:

    • 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 an FTP configuration:

Troubleshooting
  • "This is a required field" error when one or more checkboxes are ticked on

    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.

  • "This is a required field" error when one or more checkboxes are ticked on

    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.

  • Product and/or order Grids overridden by third party module

    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 toolsModules 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:
    SystemConfigWyomindThe extension

    In the System tab, you're able to override 2 grids (depending on the module):

    • Product grid to override: by default `Mage_Adminhtml_Block_Catalog_Product_Grid`
    • Order grid to override: by default `Mage_Adminhtml_Block_Sales_Order_Grid'

    You should then paste the new class name into the appropriated field and save your config.

  • Scheduled tasks don't work

    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.

    The extension includes reporting and debug tools for the scheduled tasks in:
    systemconfigurationWyomindOrders Export Tool

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

  • 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 (Phpmyadmin for example).
    • Delete the entry ordersexporttool_setup from the core_resource table.
      Be careful, that entry depends on your extension. For example, if you have the extension called Simple Google Shopping, you should delete simplegoogleshopping_setup.
    • Logout from your Magento admin.
    • Log into your Magento admin.
  • Fatal error: 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, disable it first before installing any extension from: 
      SystemToolsCompilation
      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 how to disable the Magento compiler:

    1. 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');
    2. Then go back to your website admin and re-run the compilation process.
  • 404 error in the configuration page

    Most of the time log-out/log-in may solve this issue.
  • 403 forbidden error

    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.