User Tools

Site Tools




Serial Number Import

The ability to import an excel file of serial numbers to then be allocated to an order at a later date is possible with this utility.

You can download one of the templates below to start creating your import file

The format of the file you create must be saved as a csv and the columns in the file are as follows.

No header line

Column A is the branch number its been assigned to. This would normally be the main warehouse. Our example set at 001

Column B is the PLU or Product number you have created in your product file.

Column C is the serial number (Maximum character length has been set at 30)

Example Excel Format that would be saved as a csv format.

There are 3 parts in the serial numbers process.

Part 1: Serial Number Creation (As Shown in this section)

Part 2: Stock Picking (

Part 3: Goods In (

If any of these steps are missed, then the rest of the system will not work correctly

start/utilities/serial_number_import.txt · Last modified: 2021/07/22 13:47 by Justin