Managing products by using csv files is recommended, you may find it’s not that easy at the beginning, but as time goes by, you would find that using csv files to manage product information would save a lot time.
Import/edit products by using csv files in prestashop.
Sample CSV files provided by PrestaShop1.7 are stored in the /docs/csv_import folder of your installation of PrestaShop, but 2 of them are wrong missing several columns, you can download corrected ones below.
Sample files for prestashop 1.7.1.x and 1.7.2.x
Prestashop17 sample csv files (296 downloads)
Sample files for prestashop 1.7.3.x
Prestashop 1.7.3 sample csv files (571 downloads)
The .zip file contains 3 files. Let’s go though them one by one.
ID column: you can use either ID or Reference to be the key column, I recommend using ID. Prestashop will use the key column to find correspond data to do modifications.
If you use ID column as key column, then don’t forget to enable the “Force all ID numbers” option before importing data from csv files.
If you use Reference column as key column, then don’t forget to enable the “Use product reference as key” option before importing data from csv files.
“Image URLs” column: Use absolute urls, like this http://yourdomain/productimages/1.jpg,http://yourdomain/productimages/2.jpg
Only two columns are required, one is the “Name” column, another is the key column, it can be ID or Reference.
- Never disabled the “Skip thumbnails regeneration” setting when importing products, generating thumbnails would take a lot of times, which may case time-out. Go to BO>Images page to generate thumbnails after importing. Disable the “Erase previous images” option when you generate thumbnails for new products, no need to generate thumbnails for old products again. If you get 500 error, don’t be panic, click “Regenerate thumbnails” button again to continue generate thumbnails, just keep in mind to keep the “Erase previous images” option disable. The process can be repeated, so even if your server is poor, you can get your product thumbnails generated without using 3 party modules.
- “Force all ID numbers” option, if you get error when importing, don’t be panic, enable the “Force all ID numbers” option, you can do importing again and again, till you fix all errors in your csv files. If you use reference as key, you need to enable the “Use product reference as key” option too.