Import products

In 'Settings/Users/Access management', enable the right : 'Manage the export and import product files'.

You can import product data with a CSV file.
If some products have variants, you can import variant specific data in a second file (barcodes, prices, loyalty points...)


1/ Import products

In 'Products/Import-Export', go to the 'Import data : Products' section.

Download the .CSV template (delimiter ; and UTF-8 encoding), and open it in a spreadsheet.

Fulfill it and import it in the 'Import data : Products' section.
The import file should be a CSV file with semicolon (;) as field delimiter and UTF-8 for character encoding.

The system will show all data imported in a chart, and display errors if some are present.
Review the data, fix the errors if necessary, and validate at the end of the chart to import the products into your account.

The different template columns are :

Name Notes
Name* Name of your product/service.
Category ID ID of the category the product belongs to (available in Products/Product settings/Categories). It is the lower-level category.
You can enter directly the category name. If it doesn’t exist among the categories on your account, the line will appear as an error when importing.
Brand ID ID of the brand of the product (available in Products/Product settings/Brands).
You can enter directly the brand name. If it doesn’t exist among the brands on your account, the line will appear as an error when importing.
Supply price The supply price (excl. tax) of your product/service (used to populate your stock orders and calculate your markup).
Don’t include a currency sign, just put the number.
Supplier ID ID of the supplier of the product (available in Products/Product settings/Suppliers).
You can enter directly the supplier name. If it doesn’t exist among the suppliers on your account, the line will appear as an error when importing.
Supplier code The supplier reference of the product.
Selling price* The price you sell your product/service for (with or without taxes according to your account settings). Don’t include a currency sign, just put the number.
Tax ID* ID of the sales tax of the product (available in Settings/Sales taxes).
You can enter directly the sales tax (20 % or 0,2 or 0 .2) . If it doesn’t exist among the taxes on your account, the line will appear as an error when importing.
Barcode Your product barcode, otherwise Hiboutik will generate a unique barcode for your product. Must have at least 8 characters.
Stock management 0 if the product is NOT tracked into inventory (the product can be sold immediately but you can only track outputs).
1 if the product is tracked into inventory (you must proceed to a stock order before selling the product).
Variant type ID ID of the variant type of the product (available in Products/Product Settings/Variants and variant types).
You can enter directly the variant type name. If it doesn’t exist among the variant types on your account, the line will appear as an error when importing.
The different variants of the variant type will be applied to your product automatically.
Specific information by variant can be imported in a second step.

Notes :

  • Fields marked with a star are mandatory.
  • If you don’t need to fill out a column or a field, leave it blank. Keep the same order for columns.
  • if you don’t import by IDs, names must be exactly the same as the ones in your account (uppercase and lowercase letters, accents, space…).

Tips:

  • You can use the Replace function of your spreadsheet to substitute data in your import file.
  • If the CSV file doesn’t open properly in your spreadsheet, you can search in Internet for help (ex : Excel open CSV) and follow instructions.

2/ Import variants data

If variants have specific information compared to the parent product (ex : prices, loyalty points, barcodes), go to 'Products/Import-Export' in the 'Upload data: products by variant' section.

Download the .CSV template (delimiter ; and UTF-8 encoding), fulfill it and upload it in .CSV (delimiter ; and UTF-8 encoding).

In the file, the link between variants and the parent product can be done either on the ID, the barcode or the supplier code of the parent product.

The system will show all data imported in a chart, and display errors if some are present.
Review the data, fix the errors if necessary, and validate at the end of the chart to import the products into your account.


The different template columns are :

Name Notes
ID or barcode or supplier code of the parent product* Enter the ID OR the barcode OR the supplier code of the parent product to make the link between the variant and the parent product.
Barcode Complete only if the variant has a specific barcode. Must have at least 8 characters.
Variant ID of the variant (available in Products/Product Settings/Variants and variant types).
You can enter directly the variant name. If it doesn’t exist among the variants on your account, the line will appear as an error when importing.
Supply price Complete only if different from the parent product.
Selling price Complete only if different from the parent product.

In 'Products/Import-Export', you can also import product Tags and re-order points.