Import Stock from Excel
Upload an .xlsx file to bulk create Items, Sizes, Colors, and Stock (LotNo) entries.
upload_file
Drop Excel file here or click to browse
Supports .xlsx, .xls, .csv files up to 10MB
info Expected Excel Format
Column headers (Row 1) should match these names. Only ItemName is required — all others are optional.
| SeqNo | ItemGroup | ItemType | ItemName | Brand | Size | Color | SKU | DesignNo | Barcode | QtyIn | MRP | NetRate | PurchaseRate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Mens Wear | T-Shirts | Classic Round Neck Tee | Allen Solly | M | Black | AS-TS01-M-BLK | DES-001 | APP0010201 | 60 | 499 | 324 | 259 |
| 2 | Mens Wear | Jeans | Skinny Fit Denim | Levis | 32 | Blue | LV-JN07-32-BLU | DES-007 | APP0070804 | 30 | 1999 | 1199 | 999 |
| 3 | Womens Wear | Saree | Banarasi Silk Saree | Nalli | Free Size | Red | NL-SR15-FS-RED | DES-015 | APP0151503 | 10 | 4999 | 2999 | 2499 |
All columns: SeqNo, ItemGroup, ItemType, ItemName, Brand, Size, Color, SKU, DesignNo, Barcode, QtyIn, MRP, NetRate, PurchaseRate
Required: Only ItemName is required. All others are optional. Brand creates entry in ItemCompany table. QtyIn = stock quantity (or use "Stock" column). If Item+Size+Color already exists, stock is added to existing quantity.
download Download Sample Excel