Used to update or add the serial number to an items.
- Step 1. Go to Items menu under Inventory module from the left sidebar
- Step 2. Click Serial numbers button.
The screen below will display items that can be added or updated with serial numbers: Add serial number for items, update serial numbers for items.
In case of filtering items by type "Add Serial numbers for Items": display items with inventory quantity > 0 but not enough serial number (inventory 1 has 1 serial number) => add serial number for items that do not have enough or it is possible to update existing serial numbers.
In case of filtering by type "Update Serial numbers for items": display items with inventory > 0 and have enough serial numbers => allow updating serial numbers of these items.
- Step 3. Select the item to import Serial number, then click "Export the selected item" -> Click Download items list.
- Step 4. Open the downloaded file and update the serial number on the file → Select this file and press Import
Do not add any columns or rows to the file downloaded from the system. Only the value of the Serial Number column (the blue column) can be updated, not the orange column value.
In the above excel file
ID column = 0 means this item does not have a serial number. ID column = 1 means this item already has a serial number and can be updated.
(*)commodity_id column : get from the id column of the items table
(*)Warehouse column : get the corresponding item's inventory. get from warehouse_id column of warehouse table
(*)inventory_manage_id column : id retrieved in inventory_manage table (inventory table)
(*)Commodity Name column : displays the names of selected items that have inventory > 0.
(*)Serial number column : allows adding/updating Serial number
In case the import fails, the Error file download button will be displayed. To see the import error, click Error file download to download the file and see the error