Users can upload their existing stock in/out history file(excel, csv) to upload the history at once. Also, if you have received an order list from the your retailer or supplier, you can conveniently upload the received file to BoxHero.
Uploading Excel File - Basic Mode
Preparing the Excel Sheet
The file format must follow the example like below. The very first row must include the item names and its information categories and the item list starts from the second row and on.
Quantity must be included in the information.
|2080178896917||LOVE II Couple Rings 14K Yellow Gold||999,999||3||...|
|2062735350711||Crystal Necklace 14K||123,456||4||...|
|2032995260815||Lake Wave Couple Rings Silver||777,000||2||...|
For some online retailers, there are some cases where the very first row consists of descriptions like the example below. For such cases, please delete the description row, so that the first row only consists of product information(
Product Order Number,
Product Number, ...).
When the file is ready, access it into
Stock In and click the
Import Excel button.
You can either drag the file into a box or click
Select File to bring the prepared file.
After importing, the information on the excel will appear. Please check the information and select the
Quantity column like the example down below.
Create, the data converts into stock in form. After inserting
Memo, please click
Stock In to finish the making the stock in.
Uploading Excel File - Multi Mode
Uploading the file is the same for Multi and Basic Mode, but instead of
Item ID must be included in the excel file.