What you'll do: set the right on-hand quantity for many products at once, for example after setting up or after a quick shelf check.
Before you start: your role needs the permission to add opening stock (product.opening_stock). Only products with Manage Stock on are listed.
Edit on screen
Section titled “Edit on screen”Open Inventory & Products → Products → Update Product Stock. The Update Product Stocks page opens: one row per product (or variation) and one column per branch.
1 Products · 2 Update Product Stock Narrow the list: type in Search by name or SKU..., use Filter by Category or Filter by Brand, and choose the branches to show in Visible Branches.
Type the new quantity in the cell of each product and branch. The page counts your changes (3 rows changed).
1 Search · 2 Visible Branches · 3 Quantity cell · 4 Save Changes Press Save Changes.
Update with Excel
Section titled “Update with Excel”On the same page, press Excel. The Bulk Update Stocks via Excel window opens.
1. Download Current Stocks: press Export Product Stocks. You get a file with every product and its stock at each branch.
Change only the quantities in the file. Don't change product names, SKU values or the branch column headings.
2. Upload Updated File: choose the file in File to Import and press Update Stocks via Excel.
1 Export Product Stocks · 2 File to Import · 3 Update Stocks via Excel