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 can 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 lets you 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 commas point.
We provide two CSV files: one for categories, one for products, that'll 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 fields each side possible for each entity to import. (So you have 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 the button "File Upload".

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 the data. Here: categories.csv.xxxxx file (xxx is the date of sending the file).

The field separators to be changed if you created a CSV file with other non-standard 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 on the Convert property 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 the existing categories before (except the category Home), you must check the option just below: "Clear categories before importing.

Click Next Step.

Select your column. CSV file

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 here (we recommend you do the same, not to mislead you in the reassignment of your columns).
to the import tool does not consider this first line, enter 1 in the option "Skip X lines".
Now you'll have to tell each column, the field you want to assign by selecting 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 Import Data.

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

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

Import products in your catalog Prestashop

Turning to the import of products, redirect to the section "Admin Panel>> 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, jumping a line like 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 that Eee PC has made its appearance.

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 products to their respective fields.

Be sure to describe your products and type words into the meta keywords section (for research and referencing).

The council team Magavenue:

Using CSV files would be useless after the first import. Our advice is more about using up these files:

• For security reasons, firstly, if you have a problem database and you do not have a recent backup, these files might help you.
• In a second point, for reasons of utility, where big update, or transfer of 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, making it easier for you to change the selling prices of your products (due to a general increase in your or your suppliers) and import the CSV file rather than changing 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 the RSS feed to never miss any article.Vous have finished installing your PrestaShop store and have begun to use. To make it fully operational you will need to complete your product catalog. For this two solutions ...
2. Transferring your PrestaShop online store from a local installation Feel free to subscribe to RSS feed to never miss any article.Si your local store PrestaShop installed, you seem ready to venture into the jungle of shops line. If you've honed your catalog and your photos ...
3. Add a sitemap file to your shop Magento Feel free to subscribe to RSS feeds do not miss article.Un sitemap is what? The sitemap is as its name suggests, a plan of your site that contains links to all pages of your ...