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 later 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 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 Products 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 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 ...

    • Adding new products via Purchase orders

      While you have options to create new products from product page manually or via excel file, you can also add new products into Hike via Purchase orders. There are two ways to add products via Purchase orders. We have a separate support article if you ...