Looking for a guide to PrestaShop import CSV? You’re in the right place! In this article, we will walk you through all the essential steps to import products, categories, and combinations to PrestaShop using CSV.
Keep reading to learn more about:
- Tips to build an import file that works like a charm
- 4 steps to perform PrestaShop import CSV
- Import products into PrestaShop
- Import categories into PrestaShop
- Import combinations into PrestaShop
How to Build an Import File that Works?
At this point, PrestaShop only supports importing files in CSV format. If you aren’t familiar with this type of file, my advice is to modify your data in a spreadsheet first, then save your work in CSV format later. This approach allows you to work more efficiently by simplifying the data display.
There’s no limitation to which spreadsheet program you must use to customize your PrestaShop import CSV file. Therefore, feel free to choose the solution that you are most comfortable to work with. It could be Microsoft Excel, Google Sheets, Apple Numbers, and many more.
Now that you have a better way to deal with your data, here’s what you need to pay attention to during the PrestaShop import CSV process:
- The price column uses your store's default currency.
- Categories are indicated by their existing identifier (so you need to import them first), and are separated by commas.
- The web address of the images must be an absolute link (For example https://yourstore.com/image.jpg)
- PrestaShop provides support for UTF-8 and ISO-8859-1 encoding system. Hence, if your CSV file is encoded in a different format type, the importing process might not work as expected.
How to Import CSV File into PrestaShop?
Though there are different templates for different types of data, overall, the PrestaShop import CSV follows these simple steps:
#1. Step 1. From the PrestaShop dashboard, navigate to “Advanced Parameters > Import”.
#2. Step 2. Choose what you want to import from the drop-down list, then click “Browse” to select the corresponding file to upload.
Here, you can upload 9 different data types, including:
- Categories
- Products
- Combinations
- Customers
- Addresses
- Brands
- Suppliers
- Alias
- Store contact
#3. Step 3. Configure the PrestaShop import CSV settings, then click “Next step” when finished.
Here’s a breakdown for each configuration so you’ll know what to choose to best fit your specific requirements:
- File language: Select the language of your data. If you want to import more than one language, please kindly split them into different files.
- Field separator: Indicate what type of field separator (colon, semicolon, tab,…) you used in your PrestaShop CSV file.
- Multiple-value field separator: Indicate what type of separator you used to isolate different values in one attribute.
- Delete all (products, categories,…) before import: Wipe out existing entities in your inventory before importing to avoid duplicated content.
- Use product reference as key: Enable this option to use the product reference as ID.
- Force all ID numbers: Enable this option if you want to use your imported ID, or disable to let PrestaShop generate your ID numbers.
#4. Step 4. Map your data to the corresponding field and select “Import”.
And that’s it. Within four simple steps, you can successfully perform the PrestaShop import CSV process with ease.
Import Products to PrestaShop Using CSV
From my experience, it would be easier to modify your data based on the Prestashop product import CSV sample. This prototype can be easily found and downloaded under the Import section.
The product importing process is straight-forward. Simply follow the previously mentioned steps, and you will be ready to go. Nonetheless, you’ll need to pay close attention to the available fields in your import file. Since one single mistake can lead to inaccuracy in your product display after the PrestaShop import CSV process, it’s crucial to understand each field to avoid any confusion and mix-up.
CSV column | Product property | Example | Note (if any) |
ID | Your product ID | 001, 002, 003 | This ID will be granted to your products if you enable the "Force all ID numbers" option |
Active | The current state of your product | 1 | 1: Active 0: Inactive |
Name | Product's name | Graphic T-Shirt | This field is required |
Price tax excluded | The price of your product not including tax | 50 | The currency here will be automatdically filled by your default currency |
Price tag included | The price of your product including tax | 58 | The currency here will be automatdically filled by your default currency |
Tax rule ID | The specific set of tax rule you want to apply | 1 | If you want to apply a specific tax rate for a set of countries, set up a new tax rule and fill its ID here. |
Wholesale price | Your product price when buying in bulk | 45 | The currency here will be automatdically filled by your default currency |
On sale | The state of your sale program | 0 | 1: Yes 0: No |
Discount amount | The amount of discount you want to set | 10 | The unit here is your default currency |
Discount percentage | The percentage of discount you want to set | 5 | The unit here is percentage |
Discount from Discount to | Your promotion period | 2024-01-08 2024-08-31 | The date must follow this format: yyyy-mm-dd |
Supplier Manufacturer | The name of your supplier and manufacturer | Shure Online | |
EAN13 | Your barcode digit | 1234567890123 | |
Quantity | Your stock number for each product | 170 | |
URL rewritten | The product's URL that you want to display | graphic-tee-shirt | Must not contain space |
Image URL | The URL that associates with your image | https://yourstore.com/image1.jpeg | Must be an absolute URL |
Available for order | Indicating if you want that product to be available for purchase | 1 | 1: Yes 0: No |
How to Perform PrestaShop Import CSV for Categories
Similar to PrestaShop import products CSV, you can easily download and modify the sample CSV file from their website. Then, follow this instruction to perform PrestaShop import CSV for categories.
Here’s what you need to fill in before importing categories into PrestaShop.
CSV column | Product property | Example | Note (if any) |
ID | Your product ID | 001, 002, 003 | This ID will be granted to your products if you enable the "Force all ID numbers" option |
Active | The current state of your product | 1 | 1: Active 0: Inactive |
Name | Category's name | Everyday Sneakers | This field is required |
Parent category | The parent category if you have any | Shoes | Only fill in this form if you have subcategory under it |
Root category | This is where the category tree can begin | 1 | This option is used with multistore |
Description | Your product's description | Light, airy tree fiber blend in the upper material delivers effortless fit and feel for life in motion | |
Meta title | How your product's title appear on search engine | Men's Tree Gliders | |
Meta keywords | The focus keywords that you want search engine to regconized | men shoes | |
Meta description | How your product's description appear on search engine | Light, airy tree fiber blend in the upper material delivers effortless fit and feel for life in motion | |
URL rewritten | The product's URL that you want to display | graphic-tee-shirt | Must not contain space |
Image URL | The URL that associates with your image | https://yourstore.com/image1.jpeg | Must be an absolute URL |
ID / Name of shop | Assign your category to a specific store | Ignore this field if you don't use the multistore tool. If leaved empty, the default shop will be used |
Generating the Combination PrestaShop CSV Import File
PrestaShop allows store owners to link multiple normal products together instead of using attributes, and this option is called “combination”.
To import combination, simply download the sample file, and follow this instruction to perform the PrestaShop import CSV for combination.
CSV column | Product property | Example | Note (if any) |
Product ID | Your product ID | 001, 002, 003 | This ID will be granted to your products if you enable the "Force all ID numbers" option |
Product reference | The current state of your product | 1 | 1: Active 0: Inactive |
Attribute | Category's name | Everyday Sneakers | This field is required |
Value | The parent category if you have any | Shoes | Only fill in this form if you have subcategory under it |
EAN13 | Your barcode number | 80446392 | |
Wholesale price | The price when buying in bulk | 100 | The currency here will be set as your store's currency |
Quantity | The number of products | 100 | |
Default | Choose if you want to set the combination as default or not | 1 | 1: Yes 0: No |
Image URL | The URL that associates with your image | https://yourstore.com/image1.jpeg | Must be an absolute URL |
ID / Name of shop | Assign your category to a specific store | Ignore this field if you don't use the multistore tool. If leaved empty, the default shop will be used | |
Advanced stock management | Enable advanced stock management | 1 | 1: Yes 0: No |
Depends on stock | 0 | 0: Use quantity set in product 1: Use quantity from warehouse | |
Warehouse | ID of the warehouse to set as storage | 1 |
PrestaShop Import CSV – FAQs
If you want to perform PrestaShop import CSV, please follow these steps:
- From the PrestaShop dashboard, navigate to Advanced Parameters > Import.
- Choose what you want to import from the drop-down list, then click Browse to select the corresponding file to upload.
- Configure the PrestaShop import CSV settings, then click Next step when finished.
- Map your data to the corresponding field and select Import.
PrestaShop comes with a built-in import tool that you can find under the Advanced Parameters section. With that being said, if you have a large amount of data that needs to be imported, please consider using a third-party service, like LitExtension, to have your data customized and imported with easy.
Here are 5 simple steps to import a product into PrestaShop
- From the PrestaShop dashboard, navigate to Advanced Parameters > Import.
- Download the product importing sample and customize it to your liking.
- Get back to the Import section, choose Products from the drop-down list, then click Browse to select the product file.
- Configure the PrestaShop import CSV settings, then click Next step when finished.
- Map your data to the corresponding field and select Import.
Absolutely, PrestaShop is still actively used and remains a popular choice for businesses of all sizes. It's a robust and versatile platform known for its flexibility and extensive customization options. It is favored by merchants seeking greater control over their online store's design and functionality.
Conclusion
And that's how easy it is to perform PrestaShop import CSV for products, categories, and combinations.
If you have any question regarding this matter or you want to import to PrestaShop from another platform, please don't hesitate to reach out! With over 10 years of experience working with PrestaShop, LitExtension can certainly answer your questions and cater to all your needs.
