The CSV import functions enable you to quickly fill in your product catalog when you have a very large amount of products, or to import data that you exported and converted from another e-commerce tool.
CSV stands for "Comma-separated values". It is a popular plain-text format when there is a need to import, export or simply store data in a non-proprietary format. Almost all data handling tools support CSV format, in various incarnations.
The CSV import process requires preparation, and starts with a form made of primary settings:
What do you want to import? Entities are the types of data that you can import. PrestaShop enables you to import the following types of data:
- Combinations ("versions" in previous versions of PrestaShop),
Select a CSV file to import. You can import more than one file at a time, but make sure that they all contain the same type of data.
You can download sample files for each type of data from the "Download sample CSV files" section on the right. This helps you compare your own files with those recommended by PrestaShop, so that you can make sure that the files you are about to import are indeed ready to be imported into PrestaShop. These files are actually stored in the /docs/csv_import folder of your installation of PrestaShop.
Language of the file. Data can only be imported for a single language at a time. If your data exists in more than one language, you should split it into as many files as there are languages.
Field separator. Not all CSV files use commas to separate their values: some use tabs, others semicolons, etc. You can indicate what your files use in this field.
Multiple value separator. When an attribute can support more than one value, these values need to be separated with a specific separator. After reviewing your files, indicate your separator here.
Delete all (categories, products, etc.) before import? This option will erase all previously existing entries of the type of data you are importing. You will start with a clean slate.
Force all ID numbers during import? Product import only. You can choose to have the product ID be determined by PrestaShop, or instead use its reference as the ID. In this case, check that the file contains references for all your imported products.
Use product reference as key? Product import only. You can choose to have the product key be determined by PrestaShop, or instead use the product's reference as the ID. In this case, make sure the file contains references for all your imported products.
Skip thumbnails regeneration. Category and product import only. You can choose to have PrestaShop regenerate the thumbnails that are linked from your CSV file (in the "Image URL" or "Image URLs" fields).
Force all ID numbers. You can either keep the imported IDs, or let the importer auto-increment them.
When changing the entity setting, the section on the right, "Available fields", displays the expected data fields. Although the import tool helps you by matching your files' fields with PrestaShop's, you should strive to make your data more import-friendly by following the naming scheme and order of the presented fields. If not, the import will be more tedious, but not impossible.
Some fields have a little information popup available, which you can display by hovering the mouse over it. They mostly pertain to PrestaShop's multistore or advanced stock management features. Make sure to read them all in order to better build/edit your data files.