Our webstore uses cookies to offer a better user experience and to manage the modules licenses. We consider that you accept their usage if you continue the navigation.
Applicable to : Merlin Backoffice ™, PrestaPricing (tuto and screen shots made with PrestaPricing)
Prerequisites: this tutorial assumes that you already know how to use PrestaPricing to import products and declinations. The basics of importing and importing the import window are not detailled. If necessary, please start by viewing our PrestaShop import video tutorials
This technique is very little known, yet it is possible to create new attributes, new manufacturers, suppliers or characteristics from an Excel file in the Prestashop database, without creating new products or new versions.
Here is an excel file containing what we want to import, three columns with attributes, including a group that does not yet exist, a column with manufacturers and a last one with suppliers:
At first, here is what the base contains, some colors but not fushia or magenta, a single size, no "Material" attribute etc ... This view comes from the "Attributes" tab of PrestaPricing:
Note : all screen captures below have been made with PrestaPricing, but the same features are also available within the csv or xls importation addon of Merlin Backoffice.
To do your excel file import, proceed as for a traditional import:
Go to Import / Export / Scrpts and click on the button "Import and update of products ...."
The program then asks you if you want to import products (with or without categories) or declinations. The answer does not matter to this method, because we will not create either. We will stop at step 3 of the process.
In the example described here, it can be seen that the Size has auto-mapped to the extent that the "Size" attribute already exists in the database (with the same spelling, in the upper case). We just have to click on the small square to include it in the import and to check that in the line "Data type", we have the option "Values: create if does not exist". Otherwise, the new values will not be created.
For the color attribute, it is necessary to make a manual mapping because "color" contained in the Excel file does not have a capital C as in the base and has therefore not been recognized. Hence the importance of giving your attribute columns (also true for the characteristics) the names of the attribute groups identically to those of the database.
So for a manual mapping:
For "new" attribute group, which does not yet exist, choose "New to create (name = column title)." The program will then start by creating a new group, which will be named "MA- It is the title of the column, then it will create dasn this grupe, the new values "gold", "silver", "steel"
In the same way, the Manufactuer column is mapped:
And finally the column Supp:
Import window of an Excel file in PrestaPricing
The result is displayed:
The new "Material" attribute group was created (displayed in green) with the new gold, silver, steel attribute values.
Let's go back to the main window to see the contents of the database. (Do you know that there is a button at the top right of each window, allowing you to switch from one to the other?).
Although this tutorial does not show it, the same technique can be used to mass import from a xls or CSV file a list of product features without creating any product. Just select "Id or feature name", instead of "Id or attribute name".
Next week, for a new trick bein simpler, showing how to keep the same products in the new categories created by duplication.
Category's other articles