Upload the hardware stock Excel file — products and serial numbers are created
automatically
1
Choose Excel file
Click to browse or drag & drop
Accepts .xlsx — sheet must be named "Serialized
Stock"
2
Map columns Detected custom format
Your file uses a custom column layout. Map each product field to the matching column in your
file. Columns marked Required must be mapped.
System Field
Your Column
Type
2
Purchase details
3
Upload & Import
Creates a Purchase record (status: received), posts journal entries, registers
every
serial number and updates stock quantities. Duplicate serials are skipped automatically.
0%
Uploading…
1
Choose Excel file
Click to browse or drag & drop
Accepts .xlsx — sheet must be named "Serialized
Stock"
2
Inventory details
3
Upload & Import
Stock Out will deduct quantities and mark serials as returned.
Ensure the serial numbers in the file are currently in stock.