Tag Archives: orders2csvpro

  • Orders2CSV PRO - Variable use in column value

    Posted on October 16, 2012 by ext4mage

    Variable use in column value

    There are a lot of variables at your disposal. All variables that exist in Orders2CSVPRO are shown in the help section, and you can also use default Magento variables. The way that you indicate a variable, is by using the format shown below in code example.

    {{variable_code}} the format
    {{order_data_status}} example, will print the status of the order

    The variables are divided up into different types. A general section which can be used in all types ofCSV’s.

    Magento orders2csvPRO extension help general

    And there a variables that can only be used in different types. There are groups of variables for invoice, shipment and credit memo, which can only be used in that CSV types.

    Magento orders2csvPRO extension help invoice

    Variables related to product are found under each type, and general variables that can be used in all type under Product and Product Bundle, which include variables related to the bundle group and the single items in the bundle.

    Formatting variables

    There are some standard formatting options available in the Orders2CSVPRO module. These formatting can be used on all variables, whether or not they are computed or single. The last tab in help pages, is a list of all the available formatting options.

    Magento orders2csvPRO extension help formatting

    You use formatting for a single variable on the way shown below here:

    {{formatting variable_code}} the format
    {{format_price order_data_subtotal}} example, will print the subtotal of order with the correct currency formatting

    If you have inline code the formatting of that is as follows

    ##formatting  the_code## the format
    ## format_price  {{order_data_subtotal }}-{{order_data_discount}}## example, will print the subtotal minus the discount with the correct currency formatting

    Coding inline in value field

    With Orders2CSVPRO inline code you can make the export file very specialized. You can do everything from simple math stuff to very complex PHP code. I will give a short introduction to what you can do, but there is many more options to generate custom values. The format of inline coding in Orders2CSVPRO is as follows

    ## the_code## the format
    ##{order_data_subtotal }}-{{order_data_discount}}## will print the subtotal minus the discount

    The above example is very simple, here we just take one value and subtracts another.

    The power of this function is very massive, because you can use different types of PHP code directly in the value field. An example could be that you to print the a text and calculate the average item price, this can be done by below code:

    You have ordered {{format_integer invoice_data_total_qty}} item with an average price of  ##{{format_convert_price invoice_data_subtotal_incl_tax}}/{{format_integer invoice_data_total_qty}}##

    Not all PHP function can be used. Example: if expression cannot be used, instead use the conditional operator ?: - the eval function is used in Orders2CSVPRO, you can read more about it on php.net

    Be sure that you are signed up for ext4mage newsletter, because we will be sending out tips and examples of ways to use inline coding.

    The Orders2CSV PRO extension for Magento
    See more about the magento extension Orders2CSV PRO


    This post was posted in Manual and was tagged with orders2csvpro, orders2CSV PRO, manual

  • Orders2CSV PRO User manual - System options

    Posted on July 15, 2012 by ext4mage

    System options

    Set up the general options for the use of the module.

    Magento orders2csvPRO extension configuration setup

    Field description:

    • Is module active – whether or not the orders2csv module shall be used. Only when set to Yes the action will be shown in orders grid.
    • File structure  – which file structure shall be used to generate the CSV file in Order, Invoice, Shipment and Credit memo grid
    • License code – the code you are given from ext4mage when buying this module
    • Order id for preview – used in help function of the module
    • Product in order for help – used in help screen, the specified product id must be contained in the above specified order
    • Bundle product in order for help - used in help screen, the specified product id must be contained in the above specified order
    • Invoice number for preview – used in help function of the module
    • Product in invoice for help – used in help screen, the specified product id must be contained in the above specified invoice

    The Orders2CSV PRO extension for Magento
    See more about the magento extension Orders2CSV PRO


    This post was posted in Manual and was tagged with magento, orders2csvpro, orders2CSV PRO, manual

  • Orders2CSV PRO User manual - Schedule setup

    Posted on July 15, 2012 by ext4mage

    Schedule setup

    Under the schedule item you can, do the setup of all the schedules that shall be run. A schedule is when and what shall be sent by email to a receiver automatic. One order will only be sent once per schedule, so that they do not come double entries.

    Magento cron has to be setup – see more here:     how_to_setup_a_cron_job

    Grid overview

    Here you get an overview off all schedules, with information of title, which file structure is used and when it is last been run automatic. One thing to notice is on the far right, here you can do a test send. That means that a email will be sent based on the schedule, but which orders has been sent will not be logged, and the last run timestamp is not updated.

    Orders2CSV PRO magento extension - schedule grid

    Create/ Edit schedule

    In this screen you setup all information about the schedule. The parameters controllers how, what and to who the schedule file structure shall be sent.

    Orders2CSV PRO magento extension - schedule edit

    Field description:

    • Title – The title of the schedule also used as email subject
    • Is active – is the schedule active or not, will be run is active
    • Receiver email – the email which the file structure shall be sent to.
    • File structure – which file structure that shall be used to generate the csv that gets sent.
    • Order status – choose all statuses or a single status, and only orders with that status will be used in the csv file that’s get generated.
    • Run this – interval that the schedule shall be run
    • Include header – if the header (column titles) shall be included in the csv
    • Attach output as file – shall the csv be attached as file or written directly into the email text

    The Orders2CSV PRO extension for Magento
    See more about the magento extension Orders2CSV PRO


    This post was posted in Manual and was tagged with magento, orders2csvpro, orders2CSV PRO, manual

  • Orders2CSV PRO User manual - Save CSV

    Posted on July 15, 2012 by ext4mage

    Save orders to CSV files

    In the order grid you on the left select the orders you want to save to a CSV file, and then select Orders2CSV in the Action dropdown box and click the submit button.  Orders2CSV PRO User manual - Order grid action dropdown save CSV

    The Orders2CSV PRO extension for Magento
    See more about the magento extension Orders2CSV PRO


    This post was posted in Manual and was tagged with magento, orders2csvpro, orders2CSV PRO, manual

  • Orders2CSV PRO User manual - The CSV file

    Posted on July 15, 2012 by ext4mage

    Example of a CSV file

    Below is an example of a CSV file generated with the module. Here the Excel function Text to Columns has been used to import the data.

    Orders2CSV PRO magento extension - The CSV file shown in Excel

    Opening CSV file in Excel

    When you have downloaded or received the CSV file, it can be read by multiple different programs, but one of the most used is Microsoft Excel. To transform the CSV to the tables and columns in Excel you can use the inbuilt function Text to Columns, that you find under the Data tab.

    Orders2CSV PRO magento extension - Howto transform the CSV to Excel

     
     Manual Index   -          
     
     

    The Orders2CSV PRO extension for Magento
    See more about the magento extension Orders2CSV PRO


    This post was posted in Manual and was tagged with magento, orders2csvpro, orders2CSV PRO, manual

  • Orders2CSV PRO User manual - Index

    Posted on July 15, 2012 by ext4mage

    Manual for Orders2CSV PRO - Magento Extension

    The orders2csvPRO module from ext4mage.com lets you export your order, invoice, shipment and creditmemo information to a CSV file with ease. You can easily make new file structures, where you though the orders2csv admin pages, can setup which fields shall be included in the CSV file. You can use many different variables in the export and it is also possible to make use of simple logic to general field value. You can setup schedules where you define which order, invoices, shipments or creditmemos shall be exported based on status or states, then send the CSV file to a defined email address.

    This document is a guide to teach you how to use the module. For installation instructions please see the installation manual.

    1. System options
    2. File structure setup
    3. Variable use in column value
    4. Schedule setup
    5. Save CSV
    6. The CSV file

    The Orders2CSV PRO extension for Magento
    See more about the magento extension Orders2CSV PRO


    This post was posted in Manual and was tagged with magento, orders2csvpro, orders2CSV PRO, manual

  • Orders2CSV PRO User manual - File structure setup

    Posted on July 15, 2012 by ext4mage

    File structure setup

    Orders2CSV PRO magento extension - menu item

    Here you setup al information need the generate a CSV file from your orders. You find it under ext4mage in the navigations bar at the top of the page.

    Grid overview

    The first screen you will see is the grid overview, here all file structures are listed. By clicking on either the row or the edit link on the right side, you will get to the edit page of that element. You can also create a new by clicking on the Create new file structure button.

    Orders2CSV PRO magento extension - file structure grid

    General – element information

    Either way you choose the first screen you will see is the one below, here you setup the general stuff about the file structure that is selected.

    Magento orders2csvPRO extension file structure general

    Field description:

    • Title – The title of the file, will also be used as filename on generation
    • Status – The status of this element, only enabled will show up in configuration
    • Type – Define the type of the file structure, values are Order, Invoice, Shipment and Creditmemo
    • Delimiter -  This is the delimiter to be used in the generated CSV file
    • Enclosure – Set the character to be used to enclose value in the CSV file

    File columns

    The next thing you want to setup in your file structure, is the different column. There is no limit in the module of how many columns that you can have.

    Magento orders2csvPRO extension file structure column

    Field description:

    • Title – The title of the column, also to be used in the head row of the CSV file
    • Value – Put in the variable that shall be in the column, you can see all variable available in the help section of the extension – see more about how to use variables into the sections Variable use in column value, Formatting variables and Coding inline in value field.
    • Sort order – In which order this column shall be shown, from left to right

    The CSV file is buildup in the following way, that if it contains item, option or bundle variables it generates extra row for each of these, each of these repeating  the order information. Let me try to explain it with an example.

    You want to export 1 order, with 2 items in. One item has 2 options and the other is a bundle with 3 elements, then the column value will determent how many rows it generated like this:

    Contains values Order rows Item row Option/Bundle rows Total rows
    Only order value 1 1
    Order and item values 1 2 3
    Order, item, options 1 2 2 5
    Order, item, bundle 1 2 3 6
    Order, item, option, bundle 1 2

    5

    8

    The Orders2CSV PRO extension for Magento
    See more about the magento extension Orders2CSV PRO


    This post was posted in Manual and was tagged with magento, orders2csvpro, orders2CSV PRO, manual

  • Orders2CSV item not showing in order grid

    Posted on June 25, 2012 by ext4mage

    Problem:
    The Orders2CSV in not showing up in the massaction dropdown menu on order grid.

    Solution:
    If you are using Orders2CSV PRO - just upgrade to newest version. Below solution is only working for free version.

    Most common reason for this error, is that another extension is also overwriting the "Mage_Adminhtml_Block_Sales_Order_Grid" function _prepareMassaction. What you can do is either to call my Grid (Ext4mage_Orders2csv_Block_Sales_Order_Grid) from that extension, or call that other extension from the file Ext4mage_Orders2csv_Block_Sales_Order_Grid. Alternative you can also include Orders2CSV functionality into the other function or vice versa.

    Example:
    Other module code add into Orders2CSV _prepareMassaction function:

    protected function _prepareMassaction()
    {
      parent::_prepareMassaction();
      if (Mage::getStoreConfig(self::XPATH_CONFIG_SETTINGS_IS_ACTIVE)) {
         $this->getMassactionBlock()->addItem('orders2csv', array(
           'label'=> Mage::helper('sales')->__('Orders2CSV'),
           'url' => $this->getUrl('*/sales_order_orders2csv/makecsv'),
         ));
         // Below is the other Extension code
         $this->getMassactionBlock()->addItem('delete_order', array(
           'label'=> Mage::helper('sales')->__('Delete order'),
           'url' => $this->getUrl('*/sales_order/deleteorder'),
         ));
      }
    }

    Related product:

    Orders2CSV PRO extension


    This post was posted in FAQ and was tagged with order, orders2csv, orders2csvpro, orders2CSV PRO, grid

8 Item(s)