Seamless CSV export with Sc

Why exporting with Store Commander?

  1. Analyzing your product catalog

    • Export key information (prices, stock, descriptions, SEO, categories, etc.) to check the quality or consistency of your data.

    • Ideal for audits or clean-up operations.

  2. Preparing mass modifications

    • Export products, edit them in Excel or Google Sheets, then re-import the files to quickly update your shop.

    • E.g.: changing prices, descriptions, categories, etc.

      .

  3. Sharing data with partners

    • Send product catalogues to your suppliers, resellers, or third-party platforms.

    • Format your exports according to their requirements (separators, columns, formats, etc.).

  4. Creating specific backups

    • Keep a copy of certain data (e.g. variations, images, product sheets) before making significant changes.

🌟Key features of the export too

  • Select the fields you want to export: choose only what interests you.

  • Powerful filters: export by category, stock levels, status, language, etc.

  • Flexible formats: export to CSV, compatible with Excel, Google Sheets, or other software.

  • Scheduled exports: automate regular exports at set times via a cron task

🚀 The tangible benefits

  • Huge time savings compared to manual extraction in PrestaShop.

  • High flexibility in data management.

  • Fewer errors thanks to easier information control.

  • Easier collaboration with teams and external partners.

Setting up a csv export

A CSV export allows you to extract specific product information off your shop.

Knowing this, you will decide

  • which data to export: creating the mapping

  • which products to take into account: selecting categories

Creating the export script

From the top panel, click on the icon to create the export script. In the popup window, enter the name of the script and validate on OK The line for the script is created and each column will need to be completed.

Creating the mapping

To add fields/columns that you wish to include in your export, click on the icon to then enter the number of fields to add to your mapping, and validate oK. The number entered will add the corresponding number of lines in the mapping panel. Now you need to select each field on each line by double clicking the lines in column 'database field' to display the list of available fields to choose from.

Don't forget to select the required options in the 'language' and 'options' columns when cells are on a color background. Name and save your mapping (mandatory).

Selecting categories

To take into account products during your export, you need to select the categories those products are in, simply by ticking the corresponding checkboxes. Name and save your selection (mandatory).

Configuring the script

Back in the top panel, on the line of your script, select all necessary information in each column, one after the other: mapping, categories, name of exported file, and other options. If you work in Multistore mode, select the concerned shop in the second column.

Running the export

All options are selected, you are now ready to export: click on the start icon

Downloading the export file

Once the export process has finished, a download link will be displayed, onto which you can click to open/save the file. Alternatively, you can click on the filename in the 'Exported files' panel to open/save the file.

Quick Checklist

​Here is the ‘Checklist’ to run all your exports seamlessly.

  1. Create your export script

  2. Create your mapping & save it (compulsory)

  3. Select your categories & save the selection (compulsory)

  4. Select the saved mapping

  5. Select the categories selection from the drop- down menus

  6. Name your export file (remember to add the file extension)

  7. Select the appropriate options

  8. Run the export process

Customizing your mapping

Store Commander's CSV Export tool allows you to export onto a CSV file various product information, such as prices, quantities, descriptions, etc.

Within the Export window, the mapping panel is where you select the data to export and provides you with various customization options in order to generate a CSV file that suits your needs.

Indeed, you can re-organize the order of the column by a simple drag/drop:

You can also rename column titles using 'Column name' (very useful to export your products onto market places):


Modify information by inserting various formulas that will modify calculated fields or exported character strings for example:

Deleting old export mappings

To delete export mapping, you can load it and then hit the 'delete' icon on the toolbar:

If you have a very long list of mapping to delete, you can do so via your FTP.
Indeed, mapping are saved on your server as .map.xml in /modules/storecommander/xxx/SC_TOOLS/cat_export/

Exporting by batches: ideal for large files

Whether you are on a dedicated or shared server, the server's resources will be impacted during the export process, especially considering the large number of products, and whether they include combinations, features, image, etc.

To ensure a seamless export, we have designed a powerful auto-export option in the Export Process panel.

The auto-export allows you to setup a time interval to split the export process in small chunks, which will reduce the server resources, especially if you are on a shared server.

To enable the option, simply click on the clock icon.
Enter the number of lines and the time interval in seconds and hit the 'start' button.

Once the process has started, you can follow it in the panel until it is completed: