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

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

With files CSV (Comma Separated Values), you have the possibility to import large quantities of products in a few clicks.
Simply create a CSV file using a spreadsheet (Excel, Calc, ...).
If you already have. CSV files from 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 is like a CSV file is a flat file, ie containing plain text separated by commas.
We provide two CSV files: one for categories, one for products, which we show examples later in this article.

You can download here the example file. Csv import categories. And here the example file. Csv import products.

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

First you go in the "Admin Panel>> Tools>> Import.
In the "Choose File", click Browse and open one by one the two sample files.

Click "Load File".

Importing categories with Prestashop

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

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

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

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

Click Next Step.

Selection of columns in your file. CSV

In our example you will notice that the first line is unnecessary. But it is convenient to assign each column correctly at the right fields, so you see here (we recommend you do the same, not to mislead you in the reassignment of your columns).
for the Import tool does not take into account that first line, enter 1 in the option "Skip X lines.
Now you'll need to specify each column, the field you want to assign by selecting it 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 inquire more information!

Click Import Data.

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

You can now go to your catalog.
You'll notice that the class has been implemented, and sub categories. To check the sub-category by clicking on the category 'Washing machines' and you'll see 'whrilpool'.

Import products in your catalog Prestashop

Now to import products, redirect to the section "Admin Panel>> Tools>> Import.

Retry the same spot 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 ensure that field names are included in the database.

Point you in "Admin panel>> Catalog" and choose the category "Computer -> Netbooks you will see a eee pc has appeared.

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 very good categories for to match the columns of products to their respective fields.

Remember to describe your products and type words into the section meta keywords (for search and referencing).

The council team Magavenue:

Using CSV files may seem pointless after the first import. Our advice is instead of using up these files:

• For security reasons, first, if you have a problem with the database and you do not have a recent backup, these files might help.
• In a second point, for reasons of utility, where 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 1,000 products, it will be easier for you to change the sales price of your product (following 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 admin Prestashop to do this directly.

Articles on the same subject:

1. Video: Importing Prestashop products from a CSV file (excel, calc ...) Feel free to subscribe to RSS feed to avoid missing any article.Vous have finished installing your Prestashop shop and have begun the 'use. To make it fully operational it will have you fill out your product catalog. 2 solutions for this ...
2. Transferring your Prestashop shop online from a local installation Feel free to subscribe to RSS feed to avoid missing any article.Si your shop Prestashop installed locally, you seem ready to venture into the jungle of shops row. If you've honed your catalog and photos ...
3. Add a Sitemap file to your Magento store Feel free to subscribe to the RSS feed to never miss any article.Un Sitemap file, what is it? The Sitemap is as its name suggests, a map of your site that contains links to all pages of your ...