Rating 0 stars - 0 votes

WooCommerce Order Export into CSV file

Store Manager for WooCommerce shopping cart keeps on obtaining new useful tools to constantly cheer up your business. Starting from version 1.11.0.811 it is possible to export orders from WooCommerce Store Manager into a CSV file using a special wizard. The procedure requires a few minutes and consists only of four stages.

How can I export order data from WooCommerce Store Manager into CSV file?

In order to export orders into .csv easily and in no time, follow the next steps:

  1. Choose 'Orders' in the upper grid of Store Manager and after that Press 'Export Data'. There will appear a wizard to assist you in carrying out WooCommerce order export.

  2. Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

  3. Specify place to save file to. If you have a saved configuration, you are able to load it.

  4. Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

    If you need to use FTP connection, find the corresponding box. If you tick it, the advanced FTP settings will appear. Fill them in and proceed to the next step.


    Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

  5. Select .csv delimiter (comma or tab). It is also recommended to quote string values to secure correct file opening.

  6. Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

  7. Add the order fields you want to export using special buttons or simply drag them to the export grid. If you added unnecessary fields, you can easily remove them from the export file. Besides, it is possible to add or remove all the fields in one strike.

  8. Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

    In case you need to add fields with simple/extended expression, find the corresponding buttons in the upper grid of the wizard If you press them, there will appear Expression Editors for simple and extended fields relatively. Use the expression field to enter SQL statements in both editors.


    Starting work with simple expression editor, check out the options that are available here:

    • Insert database field value;
    • Execute expression;
    • Save expression to file;
    • Load expression from file.

    Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

    if you are not familiar with creating expressions, use the hints below in the editor. In case they are not enough, select SQL Help button or simply press F1.


    Working with extended expression editor, you can perform the following actions:

    • Execute SQL;
    • Execute only selected SQL statements;
    • Insert parameter;
    • Insert macro;
    • Load query from file;
    • Save SQL to file;
    • Run visual query builder etc.

    Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

    If you need some assistance, use the integrated SQL help.


  9. Check out order export options letting you specify which records you would like to export (all records or selected only). If you need to change date & time formats, open advanced options and fill in the values. In case something goes wrong, just return to these settings.

  10. Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

    If you open advanced options, you will find date & time formats and their separators. You can either change them or leave the default settings. In case you changed the formats and after that something went wrong in the process of export, just return to these settings and change them again.


    Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

  11. Press 'Export [Page Down]' and select what action you would like to perform when WooCommerce order export is finished:
    • Nothing;
    • Open directory containing the result file;
    • Open result file.
    You can save the configuration to file, if you wish to.

  12. Exporting Orders From WooCommerce Store Manager into CSV file
    Exporting Orders From WooCommerce Store Manager into CSV file

  13. Press 'Finish [Page Down]' to complete the procedure.

If you are running a latter version of WooCommerce Store Manager, update it to version 1.11.0.811 and let this helpful innovation contribute to managing your POS.

Update your Store Manager for WooCommerce to v.1.11.0.811. to manage your orders more effectively.

Export Orders into CSV File with Store Manager for WooCommerce

Export Orders Free

COMMENTS
Be the first to comment.