| Load Store Table | |
|---|---|
| Expected input format: | CSV (Comma Separated Values) |
| Line Layout: (First line will be omitted.) |
StoreNumber,StoreName
|
| Line Example: |
1,Boone
|
Store Table Upload Progress |
|
| Load Department Table | |
|---|---|
| Expected input format: | CSV (Comma Separated Values) |
| Line Layout: (First line will be omitted.) |
Department,DepartmentName
|
| Line Example: |
15,POWER TOOLS & ACCESSORIES
|
Department Table Upload Progress |
|
| Load Item Table | |
|---|---|
| Expected input format: | CSV (Comma Separated Values) |
| Line Layout: (First line will be omitted.) |
Store,SKU,Description,QOH,Deparment,AverageCost,Location1,Location2,Location3,Location4,Location5,Location6
|
| Line Example: (only as many locations as needed, up to 6) |
1,6757116,7747830 SUNBURST STOPRUST,7,30,3.850,07A,84B,345K,,,
|
Item Table Upload Progress |
|
| Load UPC Table | |
|---|---|
| Expected input format: | CSV (Comma Separated Values) |
| Line Layout: (First line will be omitted.) |
UPCCode,SKU
|
| Line Example: |
020066774783,6757116
|
UPC Table Upload Progress |
|
| Expected input format: | Columnar Format |
| Line Layout: |
Columns 1 - 11 [3rd party variable - unused]
Column 12 [store number] Columns 13 - 26 [sku or upc] Columns 27 - 31 [count quantity] Columns 32 - 37 [location code] Columns 38 - 40 [3rd party variable - unused] |
| Line Example: |
[P ][1][008925162902 ][00001][008310][ U ]
|
3rd Party Count Upload Progress |
|
This creates the initial sections for Jenkins Inventory, any 5 digit location is added to a section that is equal to the first 3 digits of each location.
generate sections