Keeping you online and active



  • 9:00 am to 5:00 pm
MDS Business

Talk to us now

+44(0)798 4935 042

Visit our offices

LCS 5 Lamson Road , Rainham Essex.

Talk to us now

+44(0)798 4935 042

Visit our offices

LCS 5 Lamson Road , Rainham Essex.

Our Blog

Solved: Prestashop 1.6 Product Import problem

Print Email
(0 votes)

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

Active (0/1)
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 #
Minimal quantity
Additional shipping cost
Unit for the unit price
Unit price
Short 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)
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 :
2. Enter the full image path in the  Image URLs (x,y,z...) field. Example
Hope this helps, leave us a comment if you find this article good.

Leave a comment

Sign up for our newsletter to get the latest news

MDS Business

Master Digital Services. LLC.
Founded in 2008, we have gradually built from bottom to top and we are still building. MDS is fully committed to its clients and exercises conscience in our business dealings with clients.

Recent Posts

    <LOVE OF WEB DESIGNING="determination" Determination="skills" Skills="money"> LOVE OF WEB DESIGN…
    BEGINNING ONLINE (This article is focused basically on how to…

Our Core Values

Client satisfaction is at the core of our values,to be in business and successful, the client has to have 100% approval of your business services.

We offer a win win situation to clients and then make sure honesty is in the middle of our client relationship.

Copyright © Master Digital Services | Company Registeration No.07828367