User Tools

Site Tools


start:utilities:serial_number_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
start:utilities:serial_number_import [2021/07/22 11:26] Justinstart:utilities:serial_number_import [2021/07/22 13:47] (current) – [There are 3 parts in the serial numbers process.] Justin
Line 1: Line 1:
-**Excel File 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. 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.
Line 14: Line 15:
 Column A is the branch number its been assigned to. This would normally be the main warehouse. Our example set at 001 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 +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) Column C is the serial number (Maximum character length has been set at 30)
  
-Example Excel Format+Example Excel Format that would be saved as a csv format. 
  
 {{:start:utilities:example_excel_format.png|}} {{: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 
start/utilities/serial_number_import.1626917167.txt.gz · Last modified: 2021/07/22 11:26 by Justin