03333 445950
03333 calls are same cost
 |  |  |
Making It Happen
Accounting and Information Technology, Assistance and Support
Standard Sage 50 Imports - Product Records
Import Sage 50 products (i.e. stock) records from a CSV file formatted as for Sage's built in import routine plus some additional fields.
The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.
| Field | Description | Notes | |
| 1 | A | 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 | |
| 3 | C | VAT Code | (usually T1) |
| 4 | D | Sales Price | |
| 5 | E | Unit of Sale | |
| 6 | F | Location | |
| 7 | G | Nominal Code | An existing valid nominal code (watch out for leading zeros being removed by excel) |
| 8 | H | Stock Category Number | |
| 9 | I | Department Number | |
| 10 | J | Supplier Ref | An existing valid supplier account ref |
| 11 | K | Supplier part number | |
| 12 | L | Reorder level | |
| 13 | M | Ignore Stock level flag | |
| 14 | N | Commodity Code | |
| 15 | O | Unit Weight | |
| 16 | P | Stock Take Date | |
| 17 | Q | Re-order Quantity | |
| 18 | R | Last Cost Price | |
| 19 | S | Qty last Stock take | |
| 20 | T | WEB_SPECIAL_OFFER | |
| 21 | U | WEB_PUBLISH | |
| 22 | V | WEB_DESCRIPTION | |
| 23 | W | CUSTOM_1 | |
| 24 | X | CUSTOM_2 | |
| 25 | Y | CUSTOM_3 | |
| 26 | Z | WEB_LONGDESCRIPTION | |
| 27 | AA | INTRASTAT_COMMODITY_CODE | |
| 28 | AB | PURCHASE_NOMINAL_CODE | |
| 29 | AC | LAST_PURCHASE_DATE | |
| 30 | AD | COUNTRY_OF_ORIGIN | |
| 31 | AE | PRODUCT_BARCODE |
Details of the sizes, limitations and other fields available in the Stock table are here
