6. Export Products

fmProductImportExport

Export PrestaShop Products wizard will help you to export your products from PrestaShop to comma-separated values file (.csv) which can be easily opened in MS Excel or other application for detailed analysis.

To start Export PrestaShop Products procedure you need to click on PrestaShop Import/Export Product button which starts the PrestaShop Import/Export Wizard:

Import-export wizard

PrestaShop Products' Import/Export Wizard is a lot like Categories Import/Export Wizard.

Export wizard steps

To perform Custom PrestaShop Export follow up several steps:

Select "Export - save PrestaShop products to comma-separated values file format (.csv)"

Export action

Select file

Store Manager can export products from PrestaShop to the .csv file. You should enter the file name or select one to be replaced.

Specify file to export

If you want to select file, that is situated on FTP server, you should have correct FTP connection.

The data on FTP fields

Select products to export

On the next page, you can see some general PrestaShop export options.

Select products to export

All products - if you want to export all products at the current store. If you wish to export PrestaShop products only from the specific category(ies), select "Selected Categories" option.

In the list of available categories below check those ones, which products have to be exported.

'Use Product Filter'

You can choose products to export using the filter function - i.e. check the 'Use product filter' position. In case there are any pre-saved filter parameters, select the necessary one from the drop-down list:

Use product filter variant

Take a note, such parameter will be visible in the particular list in case it is added to the main filter list on the Products page of Store Manager:

Main filter list

To add the own parameter of the data filtering press 'Search' action in the program's top toolbar:

Product Search

Specify the product name (1) you want to use in the form, which appears, press the button to start searching (2). Once the results are shown in the table below, click on the ‘Create filter’ (3):

Create filter steps

You will get the new filter position which is available during the exporting as well - on the 'Export Options' step:

Export Options filter list

In other cases, create the filter to be able to use it during the current operation.

- press the 'Create filter' option:

Create new filter tool

- indicate the parameter which the data will be filtered for:

Create filter in Products Options step

- add filter to the filter list:

Press 'Filter' button

You will see the products which match the specified parameter listed below:

Press 'Next' button

The lower area of the current step are the Advanced Export Options fields:

Advanced export options below

If you need to get the full path of categories to the products in the export file you should check the appropriate column below.

In the file with exported data you can see the full categories and their sub-categories names separated by using the appropriate delimiters:

Full categories path

If the items which are exporting have parent details (some relations in rows of combinations or price values ) mark the corresponding field to transfer such data in the export file as well.

Export parent details field

Check the 'Export Parent Details' field - - and get the result file in which all product's data along with combinations will be inscribed in each appropriate column.

Check parent details field

While if you leave this field unchecked you will get the file with empty columns in it. The only columns with the main product's data will be filled.

Uncheck parent details field

Take a note of the Product accessories identification method at the bottom - there are two identifiers you can select:

- reference;

- EAN13

Check one(s) you need for identification product accessories during exporting and press the button to move to the next step of the export process.

Product accessories identification field

Select fields delimiters and quote character

Fields Delimiter page has some important settings. Check them to ensure proper configuration.

Select fields delimiters and quote character

The first option is delimiter character. Most popular delimiters are the comma (,), semicolon (;) and tab character ( ) however other symbols can be used as well.

The PrestaShop Export file is usually generated for further import. If the incorrect delimiter is specified during import, the file will not be parsed properly and PrestaShop products will not be imported. Second option. 'Quote string values' is used to separate strings in CSV file.

The third setting is category delimiter. This is not native .csv setting, it is used only in Store Manager. As you know categories are organized in a form of a tree, where one category can contain one or more subcategories and subcategory can contain one or more other categories. Category delimiter character is used to separate category names and specify full category tree path for given PrestaShop product. Category path is very similar to directory path, used to specify the full file name in Windows, where every directory separated by the backslash (\) character like this one C:\\Program Files\eMagicOne\Store Manager for PrestaShop\.

As for example, category path for "Women" (see image below) will be Root|Home|Women. The pipe (|) character was used as a separator.

Category path for subcategory 'Women'

If you select a field below - 'Use ID as category path' - the Store Manager identifies items location on Categories IDs only.

Category path as IDs

There are three tabs on the lower area on the current step.

- Images. The tab allows specifying conditions for product illustrations during exporting.

Images tab

'Export image filename with full HTTP URL path' - selected (marked) field allows to add to the image local name the store URL path and generate the direct link to the products in the browser.

Full image path

Such external path should be acceptable and openable after exporting - just specify image URL in the browser to see the appropriate illustration.

Indicate the directory to which the images will be forwarded after export. Default images path - default images path is the exact place to store image files.

Default image path

Top separate multiple illustrations between each other select the correct delimiter in the box below.

Image delimiter field

- Downloadable Files. Current tab serves for configuring export conditions of downloadable items and contains the similar to the previous tab fields.

Check the field below which allows generating the full external path to the downloadable items via browser:

Export file with Full downloadable URL path

Specify the path to the directory to which exported downloadable products will be placed after export.

Save downloadable item to the directory

The default path is the location to store downloadable files.

- Attachments. If you have any attachments and need to transfer them to the file when exporting - open the third tab and check the field for attachments.

Specify the directory, where your attachments will be added (saved) in the field below,

Click on the 'Next' button to move to the following step of export.

Select fields to be exported

All available fields that can be exported are listed in the left pane. Select fields you want to be exported and click ">" button to move them to the right pane. If you'd like to export all fields simply press ">>".

Select fields to be exported

The order in which columns will be saved in the .csv file can be changed. To do this you can move exported columns up and down using corresponding buttons.

To group or summation, ascending or descending values of corresponding fields you can use the Expression option. By clicking 'Add Expression Field' button in the top menu of the current window

Add Expression Field option

you open the 'Expression Editor' form. Type required expression in it and check the correctness of its formula by clicking 'Execute Expression' button.

After that, this formula should appear on the right - in the list of fields that should be exported.

To simplify the process of selecting fields to export, you can use the grouped data, which are in the top menu of the window. Press 'Add Group of Fields' and choose

from the drop-down list the most appropriate datasets. Among the new features of Store Manager for Prestashop - export such groups of fields as customized fields,

combination fields and specific prices (as in the illustration below).

Select fields to be exported

Note

The filter, available on this step, allows you to filter out the required fields and facilitates search process during selection

Filter in Export

Note

The 'Warehouse Location' field from now can be exported among the other data related to the Warehouse information.

Warehouse location field

Preview export data

Preview' button launches the next step of export process, where you can see all fields of products, that will be exported and if you have any inaccuracies you can go back to

the previous steps by pressing 'Back' button.

Preview exported data step

Attention! When you press "Export" Button, export process will start!

Summary results

On the last page of PrestaShop Export Wizard, you can preview the result.

You can save all your PrestaShop Export Settings or Load Existing ones.

Finish step

If you don't want to perform any action after saving PrestaShop export data, use "Just close this window" checkbox and Wizard will be automatically closed when you press Finish.

If you make a choice to open a directory containing result file, check corresponding option.

Open result file option allows you to see export file opened in Excel.

Now PrestaShop products' export is completed.

Please, check for useful information in the articles below:

Set Up Scheduled PrestaShop Product Export to Create PrestaShop CSV Data Feeds

PrestaShop Export Products

By eMagicOne Inc.