03333 445950
03333 calls are same cost

 

Home
Up

Making I.T. 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
1AProduct ReferenceThis must be just the letters A to Z and the Numbers 0 to 9 You can not have any spaces
2BProduct Description 
3CVAT Code(usually T1)
4DSales Price 
5EUnit of Sale 
6FLocation 
7GNominal CodeAn existing valid nominal code (watch out for leading zeros being removed by excel)
8HStock Category Number 
9IDepartment Number 
10JSupplier RefAn existing valid supplier account ref
11KSupplier part number 
12LReorder level 
13MIgnore Stock level flag 
14NCommodity Code 
15OUnit Weight 
16PStock Take Date 
17QRe-order Quantity 
18RLast Cost Price 
19SQty last Stock take 
20TWEB_SPECIAL_OFFER 
21UWEB_PUBLISH 
22VWEB_DESCRIPTION 
23WCUSTOM_1 
24XCUSTOM_2 
25YCUSTOM_3 
26ZWEB_LONGDESCRIPTION 
27AAINTRASTAT_COMMODITY_CODE 
28ABPURCHASE_NOMINAL_CODE 
29ACLAST_PURCHASE_DATE 
30ADCOUNTRY_OF_ORIGIN 
31AEPRODUCT_BARCODE 
 

Details of the sizes, limitations and other fields available in the Stock table are here


Home Account Apply Terms

Sage 50 Specialists: Pay-as-you-go Support, Sage Reports, Excel Reports, Consultancy, Integration, Help, Advice and more!Copyright - Making I.T. Happen 1995 - 2024
Website last updated 13/03/2024