CloudHQ4 Manual

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

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

CloudHQ4 Manual

User Tools

Site Tools

Page Tools