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
ID
Active (0/1)
Name
Categories (x,y,z...)
Price tax excluded or Price tax included
Tax rules ID
Wholesale price
On sale (0/1)
Discount amount
Discount percent
Discount from (yyyy-mm-dd)
Discount to (yyyy-mm-dd)
Reference #
Supplier reference #
Supplier
Manufacturer
EAN13
UPC
Ecotax
Width
Height
Depth
Weight
Quantity
Minimal quantity
Visibility
Additional shipping cost
Unit for the unit price
Unit price
Short description
Description
Tags (x,y,z...)
Meta title
Meta keywords
Meta description
URL rewritten
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)
Feature (Name:Value:Position:Customized)
Available online only (0 = No, 1 = Yes)
Condition
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
Warehouse
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 :
1.
Hope this helps, leave us a comment if you find this article good.
