Add Stock in bulk using an excel sheet
Step 1 - Open Add Stock form
Step 2 - Download a sample import file
Step 3 - Fill product SKU and quantity to add in CSV file
The download sample file has some instructions in the second row. You need to remove them before the import.
You only need to add sku and quantity columns in the csv file. You can leave lot number and rack location fields blank and fill 0 in pwot (price without tax).
This is how the final sheet will look like -
Step 4 - Import the sheet and Click on Auto Putaway Stock
After preparing the sheet, click on Bulk Import button on top and import the sheet.
Next, you need to click on Auto Putaway Stock button to receive the stock.