Import Excel > Stock In & Out & Audit & Move | BoxHero User Guide
🔹

Stock In & Out & Audit & Move

💡

When you add a transaction, such as Stock In & Out & Audit & Move, you can import an Excel file and submit multiple products at once.

image

You can import an Excel file and submit multiple products at once from Stock In / Stock Out / Audit > via Excel File

Import Excel File

Barcodes and quantity of products must be in an Excel file to add a transaction.

If you already have an Excel file with barcode and quantity, you can import the file, and if not, you can download the template by clicking the Download Template at the top right.

Please read Import Excel instructions, check frequently asked questions, or contact the support center if you have any difficulties.

💡

You can upload an Excel file OR copy and paste the Excel file data into the bottom area.

Matching Barcode with Quantity and Column

BoxHero will automatically match barcodes and quantities on the first row. If it doesn't match, maybe barcodes in the Excel file and Product List are different. So please select the column for each field, such as barcode, and quantity after uploading the Excel file.

After selecting a partner, please input the memo and click 'Submit' to finish Stock In / Stock Out / Audit.

💡

You can also use the Import Excel feature in the same way as above in Stock Move of the Location Mode.