Bulk Upload Items
Upload multiple items at once using an Excel file
Instructions
- Download the template Excel file below
- Fill in all required columns (marked with *)
- Do not change column headers or sheet names
- Ensure Item Code is unique for each row
- Save as .xlsx format before uploading
- Maximum 500 rows per upload
Required Columns
| Column | Required |
|---|---|
| Item Code | Yes |
| Item Name | Yes |
| Category | Yes |
| Type | Yes |
| Unit | Yes |
| Min Qty | Optional |
| Max Qty | Optional |
| Reorder Qty | Optional |
| Description | Optional |
Upload File
Upload Result Summary
Completed48
Total Rows
45
Imported
2
Skipped (Dup.)
1
Errors
Error / Warning Details
| Row | Item Code | Issue | Status |
|---|---|---|---|
| 12 | ITM-0002 | Duplicate Item Code — skipped | Skipped |
| 23 | ITM-0015 | Duplicate Item Code — skipped | Skipped |
| 38 | ITM-0031 | Invalid Category "Gadgets" — not in masters | Error |