To start BoxHero, users must register their products first. If an excel sheet with product information already exists, you can easily register your products by uploading the excel file to BoxHero.
Registering Products in Bulk with Excel
When creating your team, you can find the excel file upload button from the pop-up.
You can also upload your excel(s) in
Product List > Manage > Import Excel when needed.
Preparing Excel File
First, an excel file of the product list is needed. Information required in the file is
Barcode, Product Name, Category. Please note that 'Category' must be set beforehand to add the information through Excel import in the
Settings. For more, please refer to Additional Info page.
You can use your existing excel file if you have one. If you do not, please create one like the example below. If the barcode does not exist within the products you manage, please leave the barcode column empty to have barcodes generated automatically when uploaded.
|8809380645526||Chex Mix Snack Mix Traditional||Chex Mix||Chips||26|
|8806390532211||Teddy Grahams||Teddy Grahams||Cookies||3|
|8806403433627||FRITOS Original Corn Chips||Fritos||Chips||6|
|8806130881753||DORITOS Nacho Cheese Flavored Tortilla Chips||Doritos||Chips||24|
|8806130880831||LAY'S Classic Potato Chips||LAY'S||Chips||38|
Please be reminded that the first row is regarded as a header when uploaded.
Matching Columns after Upload
BoxHero provides a format for user's convenience, therefore, please choose the data to use for each column after uploading the file.
Product are default information and
Product Category does not have to be matched. Barcodes will automatically be formed by selecting
Barcode > Generate if barcodes do not exist in the file.