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 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. Specify place to save file to. If you have a saved configuration, you are able to load it.


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



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


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


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


    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.


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


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


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



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


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

Privacy Preference Center

Strictly Necessary

These cookies are necessary fro the site ot function.

woocommerce_cart_hash, woocommerce_items_in_card, wp_woocommerce_session_{hash}

Performance

These are used to track user interaction and detect potential problems. These help us improve our services by providing analytical data on how users use this site.

_ga, _gid, _gat-_UA-326982215-25, LaSID, LaVisitorId, __utma, __utmc, __utmv, __utmz

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?