Prestashop v1.1: Import 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 files. CSV 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 you two CSV files: one for categories, one for products, that'll show examples later in our article.

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

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

First you go in the "Back Office >> Tools >> Import".
Under "Choose a file", click Browse and open one by one the two sample files.

Click the "Load Files".

Import categories with Prestashop

Once the file is loaded in the import section, select the entity to import, in our first case these are the categories.
Below, we will select where the data to import. Here: the file categories.csv.xxxxx (xxx is the date for sending the file).

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

Click good to Convert to Unicode characters to display correctly on your site. Very important if your files contain accents ...

If you want to import your categories, and delete all existing categories before (apart from the category Home), you must check the option right below: "Delete the categories before importing."

Click on Next Step.

Selection of columns in your file. CSV

In our example you see that the first line is unnecessary. But it is very convenient to correctly each column at the right fields, which is why 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'll need to specify each column, the field you want to assign it by selecting it from the dropdown above each column.

You should get this:

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

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 a script execution 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'll notice that the category has been implemented, as well as subcategories. To check the subcategory just click on the category 'Washing machines' and you will 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 Products entity and the corresponding file, remember to click 'Convert to Unicode'.

Click Next Step.

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

Head over to "Back Office >> Catalog" and choose the category "Computing -> Netbooks" you will see a eee pc has emerged.

Conclusion:

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

Note that it is very important to fill your CSV files with good grades to even match the columns of the products in their respective fields.

Do not forget to describe your products and enter words in the meta keywords section (for research and referencing).

The board of the team Magavenue:

Using CSV files might seem useless after the first import. Our advice is rather to make maximum use these files:

• For security reasons, first, if you have a problem database and you do not have a recent backup, these files may help.
• In a second point, for reasons of utility, when big update, or transfer your shop, it will be easier to import your catalog, rather than going from one base to another.
• And finally, for practical reasons: If you have a catalog of 1000 products, 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.

Items on the same subject:

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 store and have begun to to use. To make it fully operational you will need to complete your product catalog. Two solutions for this ...
2. Transfer your PrestaShop store online from a local installation Feel free to sign up for RSS feeds do not miss any article.Si your PrestaShop store installed locally, you seem ready to venture into the jungle of shops line. If you have honed your catalog and photos, ...
3. Add a Sitemap file to your Magento store Feel free to subscribe to the RSS feed to not miss any article.Un Sitemap file, what is it? The Sitemap is as its name suggests, a plan of your site that contains links to all pages of your ...