To import your product database from Hiboutik to Prestashop with ease, you will find two CSV files in « Products/Export-import/Export data » that respects the import requirements of Prestashop.
Step 1 : Generate and download the files « Prestashop » and « Prestashop variants» on your computer.
The first file is your product list and the second one all the details of variants for products with variations (combinations in Prestashop).
Step 2 : In your Prestashop admin panel, Go to the Catalog/Products tab and click on the Import link from the Configuration icon in the top right corner.
On the import page, select « Products » as import type, upload the first file (« Prestashop »), choose semicolon (;) as field delimiter and switch off all buttons.
You must then map correctly your file columns with the Prestashop headers in the import wizard. Here are some information on the different columns of the file :
Name |
Notes |
Active (0/1) |
1 by default (=active), or 0 if the product is archived. |
Name |
Name of the product. |
Categories (x,y,z…) |
Category of the product. If it doesn’t exist in Prestashop, it will be created automatically. |
Price tax included |
Selling price (with or without taxes according to your account settings) |
Tax rules ID |
Tax ID from Hiboutik («Settings/Sales taxes »). |
Wholesale price |
Supply price (excl. taxes). |
Reference # |
Barcode of the product (barcode of the parent product if the product has variants). |
Supplier reference # |
Supplier reference. |
Supplier |
Supplier of the product. If it doesn’t exist in Prestashop, it will be created automatically. |
Manufacturer |
Brand of the product. If it doesn’t exist in Prestashop, it will be created automatically. |
Quantity |
Quantity of the product if you track it into inventory. |
Validate and check data in the Catalog/Products tab.
Step 3 : Go back to the import page on Prestashop, select «Conbinations» as import type, upload the second file (« Prestashop variants »), choose semicolon (;) as field delimiter and switch on the button « Use product reference as key».
The link between variations and the parent product is the parent product reference, that’s why it is important to activate this button.
You must then map correctly your file columns with the Prestashop headers in the import wizard. Here are some information on the different columns of the file :
Name |
Notes |
Product reference |
Barcode of the parent product. |
Attribute (Name:Type:Position) |
The variant type. If it doesn’t exist in Prestashop, it will be created automatically. |
Value (Value:Position) |
The variant value (combination name). If it doesn’t exist in Prestashop, it will be created automatically. |
Reference |
The barcode of the variation. |
Wholesale price |
Supply price. Only if it is different from the parent product supply price. |
Impact on price |
Price difference (exl. Taxes) with the parent product selling price. Leave blank if no price difference. |
Quantity |
Quantity of the variation if the product is tracked into inventory. |
Validate and check data in the Catalog/Products tab.