This is an old revision of the document!

Excel File 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

creating_serial_numbers_format_sample.zip

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