Importing Composite Products via Excel File

Importing Composite Products via Excel File

Hike allows for creating composite products. To create them in bulk efficiently, similar to creating products, you can import the composite products. You can either use your own template or the Hike one. We would recommend the latter because it will simplify the mapping process and progress faster. Here's the explanation of the basics of how to use the Hike product template to import composite products. For details on how to import products in Hike, please refer to Importing Products via Excel Files

Component part - not sold individually - This field is considered only for component products. Enter TRUE if you do not want to sell the component product individually and prefer selling it only as part of a composite product. else enter FALSE. Enter FALSE in the rows of composite products.

Is composite product - Enter TRUE for composite products. Enter FALSE for component products.

Composite product1_SKU - SKU of the first component product to be entered in the row of composite products. Keep this field blank for the component products.

Composite product1_Quantity - The quantity of the first component product, in the row of composite products. Keep this field blank for the component products.

Composite product2_SKU - SKU of the second component product to be entered in the row of composite products. Keep this field blank for the component products.

Composite product2_Quantity - The quantity of the second component product in the row of composite products. Keep this field blank for the component products.

Below is the screenshot of an example composite product including the fields mentioned above, where Bag and Purse are component products and Combo is the composite product.



Other common fields which are to be considered while importing composite product are as below with the details how they need to be entered.

Track inventory: Enter FALSE for composite products. It can be set TRUE or FALSE for component products as per your requirement.

Allow out of stock: Enter FALSE for composite products. It can be set TRUE or FALSE for component products as per your requirement.

Store_Cost price: Leave the cost price field as blank for composite products because composite products' cost price is based on the component products.

Store_Retail price: Enter the Retail Price of composite product.

Also leave all stock related columns (Store_Stock on hand, Store_Reorder level, Store_Reorder value ) blank for composite products. Composite products' inventory management is based on that of component products.

Below is the screenshot of the example composite product including the fields mentioned above, where Bag and Purse are component products and Combo is the composite product.




Import The File to Hike

Once you have completed filling details in all columns above, save the file and upload it into the Import screen in Hike. 



A new window will then slide out with two columns:

  • On the left is the column headers in your file (Data Fields in your File)
  • On the right are the column headers that Hike uses. (Corresponding Data Fields in Hike) 


Once you have finished, select Continue.

A dialogue box will appear asking you whether you would like to save the mappings as a template. It will be useful if you use your own template rather than that of Hike. Click on yes or cancel as per your requirement.



Click on Connected & Validate to commence the upload.



If the import has been completed, it will be shown as Processed. You can download and check the errors on the same page if any occurs during the import.



    • Related Articles

    • Importing Products via Excel Files

      When businesses are moving to Hike POS, rather than having to manually create all data, like products, customers & suppliers. It may be preferable to have all information stored onto a spreadsheet, that can then be imported into Hike. Also, manually ...
    • Importing Customers via Excel File

      Importing your Customers via Excel file When businesses are moving to Hike POS, rather than having to manually create all their data – products, customers & suppliers – it may be preferable to have all information stored onto a spreadsheet, that can ...
    • Importing Suppliers via Excel Files

      When businesses are moving to Hike POS, rather than having to manually create all their data – products, customers & suppliers – it may be preferable to have all information stored onto a spreadsheet, that can then be imported into Hike. This ...
    • Importing Unit of Measure via Excel Files

      Hike supports the feature, unit of measure, to enable selling and purchasing products in bulk. For the details of the feature, please refer to Unit of Measure: Sell or Purchase Products in Bulk. Apart from creating them manually one by one, you can ...
    • Tips: Importing Different Products with The Same Name

      Some businesses require to have the same name for different products. If it sounds like yours, then you can import such products in bulk in Hike by using the product import feature. The process is the same as explained in Importing Products via Excel ...