Import Stock from Excel
Upload an .xlsx file to bulk create Items, Sizes, Colors, and Stock (LotNo) entries.
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 | TaxPercentage |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Mens Wear | T-Shirts | Classic Round Neck Tee | Allen Solly | M | Black | AS-TS01-M-BLK | DES-001 | APP0010201 | 60 | 499 | 324 | 259 | 5 |
| 2 | Mens Wear | Jeans | Skinny Fit Denim | Levis | 32 | Blue | LV-JN07-32-BLU | DES-007 | APP0070804 | 30 | 1999 | 1199 | 999 | 12 |
| 3 | Womens Wear | Saree | Banarasi Silk Saree | Nalli | Free Size | Red | NL-SR15-FS-RED | DES-015 | APP0151503 | 10 | 4999 | 2999 | 2499 | 5 |
All columns: SeqNo, ItemGroup, ItemType, ItemName, Brand, Size, Color, SKU, DesignNo, Barcode, QtyIn, MRP, NetRate, PurchaseRate, TaxPercentage
Required: Only ItemName is required. All others are optional. Brand creates entry in ItemCompany table. QtyIn = stock quantity (or use "Stock" column). TaxPercentage matches against TaxCategory (e.g. 0, 5, 12, 18, 28); aliases Tax / GST accepted. If Item+Size+Color already exists, stock is added to existing quantity.
download Download Sample Excel