Opening Stock – Serial Import
Select an item and branch, then upload the Excel file. Each row in the file is one serial with its own purchase date, unit price, warranty, and supplier — every purchase can come from a different supplier.
Stock Configuration
POST /api/v1/items/opening-stock/bulk-serial
Click or drag & drop Excel / CSV file here
Accepted: .xlsx, .xls, .csv
Expected Excel / CSV Columns:
| purchase_date | unit_price | warranty_type | warranty_value | serials | supplier_name |
|---|---|---|---|---|---|
| 03-04-2026 | 160 | m | 12 | fasdfad1325 | ABC Traders |
| 04-04-2026 | 170 | m | 12 | fasfasdfere234 | XYZ Distributors |
| 05-04-2026 | 125 | m | 12 | fasdre22823ghfg | ABC Traders |
warranty_type: d = day, m = month, y = year |
unit_price: cost per unit |
serials: one serial per row |
supplier_name: must exactly match an existing supplier (or use a supplier_id column instead) — each row/purchase can have a different supplier
| # | Serial | Purchase Date | Unit Price | Warranty | Supplier |
|---|
Creating opening stock… please wait