====== 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

{{ :start:utilities: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 that would be saved as a csv format. 

{{:start:utilities:example_excel_format.png|}}


====== There are 3 parts in the serial numbers process. ======


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

Part 2:  Stock Picking (https://wiki.cloudposhq.com/doku.php/start:stock:stock_order_status)

Part 3:  Goods In (https://wiki.cloudposhq.com/doku.php/start:stock:goodsin:serial_numbers#there_are_3_parts_in_the_serial_numbers_process)

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