### Stock Import

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.
Sheet
Header row
Data starts at row

System Field | Your Column | Type
--- | --- | ---

2

###### Purchase details

Supplier *
Branch
Purchase Date
Reference / PO Number
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

Import Type *
Branch
Effective Date
Reason / Notes
3

###### Upload & Import

Stock Out will deduct quantities and mark serials as returned. Ensure the serial numbers in the file are currently in stock.
0%
Uploading…

###### Skipped rows

Row | Reason
--- | ---