03333 445950
 |
 |
 |
Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Product Records V12 and Above
The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.
| Field | Description V11- | Description V12+ | Notes | |
| 1 | A | Product Reference | Product Reference | This must be just the letters A to Z and the Numbers 0 to 9 You can not have any spaces |
| 2 | B | Product Description | Product Description | |
| 3 | C | VAT Code | VAT Code | (usually T1) |
| 4 | D | Sales Price | Sales Price | |
| 5 | E | Unit of Sale | Unit of Sale | |
| 6 | F | Location | Location | |
| 7 | G | Nominal Code | Nominal Code | An existing valid nominal code (watch out for leading zeros being removed by excel) |
| 8 | H | Stock Category Number | Stock Category Number | |
| 9 | I | Department Number | Department Number | |
| 10 | J | Supplier Ref | Supplier Ref | An existing valid supplier account ref |
| 11 | K | Supplier part number | Supplier part number | |
| 12 | L | Reorder level | Reorder level | |
| 13 | M | Ignore Stock level flag | Ignore Stock level flag | |
| 14 | N | Commodity Code | Commodity Code | |
| 15 | O | Unit Weight | Unit Weight | |
| 16 | P | Stock Take Date | Stock Take Date | |
| 17 | Q | Re-order Quantity | Re-order Quantity | |
| 18 | R | Qty last Stock take | Last Cost Price | |
| 19 | S | Qty last Stock take** |
Refer to our field information table for the actual limitations of data values for these fields
Our Custom integration and import solution will allow you to have fields in any order and extract them from formats other than CSV eg: mailing labels printed to disk you can also import all the other fields associated with customers such as price lists.
