Alright we all know that as an online shop owner, what you want is a way to do a bulk upload of all your products at once and also to be able to do bulk editing . Prestashop has that capability but its handled in a CSV file. In Prestashop we found that many people are having problems doing this due to poor documentation that leaves room for users to practice trial and error on something that should be a straight forward thing. Please do not condemn Prestashop, it is actually one of the best free E-commerce systems and i cant imagine using any other solution than Prestashop.
Now let us walk you through the process of doing a bulk upload of your products, there are not so many tutorials of this problem and even the ones you have skipped the most findamental process.
1.In Prestashop BO Go to Advanced Parameters > CSV Import
2. Stay on this page and scan around the options for a while
3. On the option that reads "What kind of entity would you like to import?" , choose "Products" from the drop down. (this also applies to other things you may want to import like categories , etc.)
4. Once this is chosen scroll down (in P 1.6 ) and observe the following listed Available fields
Price tax excluded or Price tax included
Tax rules ID
On sale (0/1)
Discount from (yyyy-mm-dd)
Discount to (yyyy-mm-dd)
Supplier reference #
Additional shipping cost
Unit for the unit price
Text when in stock
Text when backorder allowed
Available for order (0 = No, 1 = Yes)
Product available date
Product creation date
Show price (0 = No, 1 = Yes)
Image URLs (x,y,z...)
Delete existing images (0 = No, 1 = Yes)
Available online only (0 = No, 1 = Yes)
Customizable (0 = No, 1 = Yes)
Uploadable files (0 = No, 1 = Yes)
Text fields (0 = No, 1 = Yes)
Action when out of stock
ID / Name of shop
Advanced Stock Management
Depends on stock
5. Open an excel sheet and paste each an every field into a column like the picture below. Make sure each field pasted ends with a comma. You may click here
to see a faster way of doing the pasting .
6. Now enter the appropraite value (do not use a coma at the end), you do not need to enter all, Prestashop would use the defaults where there is no value.
7. Save the excel file as csv coma delimited
8. Now come back to the CSV import page, change your field separator from semicolon(;) to coma(,). Go through the process of uploading your csv file.
If you did the process right, you should arrive at a similar image below, assuming your products replaces the values below (It should match the fields right, where it is not matched, match the heading to the value by selecting the appropraite from the dropdown).
Please take note of the following :
Hope this helps, leave us a comment if you find this article good.