Import your product database – Prestashop

 

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 »).
Check that IDs are matching with Prestashop taxes IDs (Customize/International/Taxes), and modify the file if needed.

Wholesale price

Supply price (excl. taxes).

Reference #

Barcode of the product (barcode of the parent product if the product has variants).
Very important because it is the key to link Hiboutik with Prestashop.

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.
If the product has variants, quantities will be imported with the second file.

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.
By default, the Type (=name displayed on your website when you select a combination) is the same as the variant type (=Name).

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.
Very important because it is the key to link Hiboutik with Prestashop.

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.

the owl has written 47 articles