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:


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)"


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.  If you want to select file, that is situated on FTP server,

you should have correct FTP connection.


Select products to export

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


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.


You can choose products to export using the filter function:


You can see the Advanced Export Options area below:

Advanced Export Options area
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. 

Check the 'Export Parent Details' field -  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 delimiter step

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.

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

Rows tool on the Select Fields step


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

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.


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

Filter tool


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.


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.

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.

Comments