Prestashop v1.1: Importing an entire catalog in your store from a file. Csv (Excel, Calc ...)

How to import many products, many categories in my catalog Prestashop .

Through files in CSV (Comma Separated Values), you have the ability to import large quantities of products with a few clicks.
Simply create a CSV file using a spreadsheet (Excel, Calc ...).
If you already have. CSV file of your old database, it is not necessary to modify the import function of PrestaShop, will allow you to reassign each column to a specific field (name, price, etc.).

If you do not know what it's like a CSV file is a flat file, ie containing plain text separated by semicolons.
We provide two CSV files: one for categories, one for products, that'll show examples later in this article.

You can download here, the sample file. csv import categories. and here, the sample file. csv import products .

We have, for reasons of readability, created only a few columns. But you can create more. Just look on the side of each field as possible for each entity to import. (So ​​you thirty opportunity for products).

First appointment in the "Back Office>> Tools>> Import".
In the "Choose File", click Browse and open one by one the two sample files.

Click the "Download files".

Import categories with Prestashop

Once the file is loaded in the import section, select the entity to import, in our case it is the first Category.
Below, we will select where the data to import. Here: the file categories.csv.xxxxx (xxx is the date of dispatch of the file).

The field separators are to be changed if you have created a CSV file with other non-standard characters. They help to define each entity and treat them as unique objects.
By registering a. CSV standard, or using our example files, you do not have to change these two options.

Click Convert to Unicode well to properly display the characters on your site. Very important if your files contain accents ...

If you want to import your categories, and delete all the existing categories before (except for the category Home), you must check the option just below: "Delete the categories before the import."

Click on Next Step.

Selection of columns in your file. CSV

In our example you will notice that the first line is useless. But it is useful to correctly each column in the right fields, so you see it here (you should do the same, not go wrong in the reassignment of your columns).
for the import tool ignores this first line, enter 1 in the "Jump X lines."
Now you will have to specify each column, the field you want to assign by selecting from the dropdown above each column.

You should get this:

Of course, if your CSV file contains more fields, PrestaShop will take them into account, feel free to learn more!

Click on Import Data.

Warning: If you are hosted on a small server, you will divide your file with the number of insertions to be made. About 1000 lines per CSV file.
Indeed, the import takes time, most servers are limited to one script execution to 60 seconds. With a file too big, so you can have a timeout, and an incomplete import!

You can now go to your catalog.
You will notice that the class have been implemented, and the sub-categories. To check the sub-category simply click on the category 'washing machines' and see 'whrilpool'.

Import products in your catalog Prestashop

Now to import products, redirect you in the "Back Office>> Tools>> Import".

Perform the same spot again by selecting the entity's products and the corresponding file, remember to click 'Convert to Unicode'.

Click Next Step.

For treatment, skip 1 line as the first time to ensure that the field names are included in the database.

Head over to "Back Office>> Catalog" and choose the category "Computer -> Netbooks" you will see a Eee PC made its appearance.

Conclusion:

This tool is very powerful to import many items in a few clicks!

Note that it is very important to fill your CSV file with the correct categories to properly align the columns of the products to their respective fields.

Remember to describe your products and write words in the meta keywords section (for research and referencing).

The board of the team Magavenue:

Use of the CSV file may seem unnecessary after the first import. Our advice is rather to make maximum use these files:

• For security reasons, first, if you have a problem with the database and you do not have a recent backup, these files may help.
• In a second point, for reasons of utility, in case of big update, or transfer your shop, it will be easier to import your catalog, rather than moving from one base to another.
• And finally, for practical reasons: If you have a catalog of products in 1000, it will be easier for you to change the prices of your products (due to a general increase in your or your suppliers) and import the CSV file rather than changing them one by one each product. Hope there is soon a function in the Prestashop admin to do this directly.

Articles on this topic:

1. Video: Import Products in Prestashop from a CSV file (excel, calc ...) Feel free to subscribe to the RSS feed to not miss any article.Vous have finished installing your Prestashop and have started to use it. To make it fully operational you will need to complete your product catalog. For this 2 solutions ...
2. Transfer your PrestaShop online store from a local installation Feel free to sign up for RSS to not miss any article.Si your local store PrestaShop installed, you seem ready to venture into the jungle of shops line. If you have refined your catalog and photos ...
3. Add a Sitemap file to your Magento store Feel free to sign up for RSS to not miss any article.Un Sitemap file, what is it? The Sitemap is as its name implies, a map of your site that contains links to all pages of your ...