03333 445950
Home
Up

                                

 

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.


Home Main site Contact Terms

Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!

This Sage 50 import website is copyright © Making I.T. Happen 2017