Prestashop Import Export

The module lets you to import/export products, combinations, categories, customers, addresses, brands/manufacturers, suppliers, alias, stores, discounts, and more.

You can also create many cron jobs for an automated process, like one for categories, other for products, etc.

Why is it different from PrestaShop’s default Import feature

Other than products, combinations, categories, customers, addresses, brands/manufacturers, suppliers, alias, and stores, it also allows you to Import and Export the discounts, carriers, and groups.

Not only this, the module also gives you ton of other options to configure while importing or exporting the entities.

In addition, it also adds other file import methods like FTP, SFTP and file URL.

Note: Prestashop Import Export module is compatible with PrestaShop multi-store feature.

Features of the Prestashop Import Export module

• Import products, orders, combinations, features, attributes, product specific prices, categories, customers, addresses, brands/manufacturers, suppliers, alias, stores, discounts, carriers, and groups.s/manufacturers, suppliers, alias, stores, discounts, carriers, and groups.
• Supports import by file upload.
• Upload file in CSV, XLS, XLSX,XML, JSON or TXT format.
• Option to reuse previously added CSV files.
• Supports import by file URL.
• Supports import by FTP and SFTP.
• Set Import CRON for an automated process.
• Set the maximum number of columns and rows to display while mapping the imported entity.
• Option to specify the number of rows to skip. Also, you can set the import start row and end row.
• Export file in CSV, XLS, XLSX, or XML format.
• Import/Export product CSV with name, summary, and description fields in multi-language.
• Set the offset limit based on the data size and server capacity.

How to install the Prestashop Import Export module

• Firstly, go to the module manager in back office and click on ‘upload a module’.
• After that, drag and drop the module file or select the file from the system.
• In this way, the module installation will be successful.

Module Configuration

General Settings

Configure the General settings of the modules from the “General” tab.

Also, download sample files for each type of data from the “Download sample CSV files for Import” section.

This helps you compare these sample files with your own files, so that you can make sure that the files you are about to import are indeed ready to import to PrestaShop.

Under General Settings, admin can set:

• Maximum visible columns
• Maximum visible rows
• Server offset limit

Import

The import process requires preparation, and starts with a form made of primary settings:

Import entity:  Choose in the drop-down list what kind of entity you would like to import to your shop.

The given entities are: products, combinations, categories, customers, addresses, brands/manufacturers, suppliers, alias, stores, discounts, etc.

Note: Discounts must be imported in ascending order of discount Id.

Import entities:

Note: If Products is selected in Import entity, then in category column first category will be treated as default category.

Import method: You can either upload files from your computer, or choose files already available on your FTP or in your history. SFTP and file URL are also the two options given.

Different import methods:

File upload:
Upload files from your computer.
Supported formats are:
.CSV,
.XLS,
.XLSX,
.XML,
.JSON, and
.TXT

History:
Choose history to display the list of available files (including the ones you previously uploaded using the browser), then click the “Use” button for the file you wish to import.

FTP:
Enter FTP details from where the file that you want to import will be fetched.

SFTP:
Enter SFTP details from where the file that you want to import will be fetched.

URL:
Set file URL where the file that you want to import is available.

Supported file formats are:

• .CSV,
• .XLS,
• .XLSX,
• .XML,
• .JSON, and
• .TXT

Let’s look at the other settings below.

Language of the file. The language the file is written in. You will need to also have the appropriate language pack installed.

Multilang fields. Enable this field to import multi-language values in name, summary, and description fields (Applicable only in case of product entity).

Field separator. Select separator that separates each field.

Multiple value separator. Select separator that separates multiple values for a field.

Price separator: Indicate your price separator.

Update entries by: This option allows you the update the entities of CSV.

Delete all records before import: This option will erase all previously existing entries of the type of data you are importing. Thus you will start with a clean slate.

Note: Delete all record option will delete all records from the database.
Whereas in import combination case, it will delete only those products combinations which are mentioned in import file.

Skip thumbnails regeneration: You can choose to have PrestaShop regenerate the thumbnails that are linked from your CSV file.

Force all ID numbers:  You can either keep the imported IDs, or let the importer auto-increment them.

Send notification email: Activate this option to receive an email when the import is complete.

Let’s now see the Import Product process using the File Upload option.

CSV to import:

Import Multilang CSV

Brand/Manufacturer: Select brands/manufacturers whose products you want to import.

Supplier: Select suppliers whose products you want to import.

Category: The products under the selected categories will import.

Note that the brand/manufacturer, supplier and category fields appear only while importing the Products. Rest, all the entities have the same configuration form.

When clicking the “Next step” button, the next page will open. Here admin can interchange or set the columns according to his import file.
Also, admin can ignore some unwanted columns.

You have set 6 columns (in general settings) that is why 6 columns are showing on the screen, please, click the “->” and “<-” buttons at the bottom of the page to see the other columns. 

The Rows to Skip field allows your import to ignore starting number of rows in the import file, mostly starting rows contain the header of the file.

Import start from row: This allows you to set the starting row number from where the import data will begin, counting includes header row.

Import end row: This allows you to set the last row number where import data will end.

Note: When we set start row or end row or both then we can not skip starting row. To skip starting rows please set starting row accordingly.

Click Import button to proceed with the Import.

The products are imported and added to the catalog.

Let’s also see the process to import the “Customers”. The process is the same as “Product” import.

The customer are imported and added to the customers list.

Likewise, you can import combinations, categories, addresses, brands/manufacturers, suppliers, alias, stores, discounts, carriers, groups, features, attributes, product specific prices.

Import Orders

Click on the information to view the points to be considered before preparing the CSV file.

Export

Similar to import, you can also export product in one click. Let’s see the Export settings below.

Name: Set the name of the exported file.

Export Entity: Choose what you want to export.

Entity Columns: Select the columns that you want to export.

Export type: You can export the file in the following formats.

1- CSV
2- XLS
3- XLSX
4- XML

Here is the glimpse of the exported file.

Likewise, you can export products, combinations, categories, customers, addresses, brands/manufacturers, suppliers, alias, stores, discounts, etc.

Import Cron

Cron is a tool that allows you to execute something on a schedule. 

In this section, you can set Cron to import entities.

Add CRON

Note: To execute your cron tasks, please insert the following line in your cron tasks manager.

“https://www.sitename.com/module/wkimportexport/wkcronimport?token=447934bafeaed986e21f03162494bca4”

The admin needs to replace the string “www.sitename.com” with the site link.

So, this was all about Prestashop Import Export Module. I hope this document will help you in checking the functionality of the module in a better way. 

Also, do let us know about your views in the comments.

Support

For any kind of technical assistance or query, please raise a ticket or send us a mail at support@webkul.com

Also, please explore our Prestashop development services and vast range of quality Prestashop addons.