User Tools

Site Tools


Sidebar

Index

start:utilities:serial_number_import

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

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.

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

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