Solution Properties
Solution ID:
250321124927893
Last Modified Date:
Fri Mar 21 13:04:05 UTC 2025
Taxonomy Path:
Case category//How do I...//import/export
Author:
[email protected]
Product record data fields you can import
Description

You can use the Import option to import data into your accounts, either to create or update your product records.

Here you can check which data fields you can import and find out more about the format required for each field.

 TIP: There are reports in Sage 50 Accounts that you can use to export your existing data in the correct format for CSV files.

Product Records

Field Type Size Left blank? Format Excel column Report to use
Stock Code Text 30 No Up to 30 characters with no spaces. A Product Record CSV
Description Text 60 Yes   B Product Record CSV
Tax Code Integer 3 Yes - defaults to T0. Enter a code between T0 and T99. C Product Record CSV
Sales Price Decimal 11 Yes 8 digits + 2 decimal places. D Product Record CSV
Last Cost Price (Standard) Decimal 11 Yes 8 digits + 2 decimal places. E Product Record CSV
Unit of Sale Text 8 Yes   F Product Record CSV
Location Text 16 Yes   G Product Record CSV
Nominal A/C Ref (Sales nominal) Text 8 Yes - This assigns the default customer nominal code. The nominal code must already exist in your accounts data. H Product Record CSV
Stock Category Integer 3 Yes Enter a number between 1 - 999 with no decimal places. I Product Record CSV
Bar Code Text 60 Yes Up to 60 characters. J

 

Product Record CSV
Department Integer 3 Yes Enter a number between 0 - 999 with no decimal places. K Product Record CSV
Supplier A/C Ref Text 8 Yes The supplier account must already exist in your accounts data. L Product Record CSV
Supplier Part No. Text 16 Yes   M Product Record CSV
Re-order Level Decimal 11 Yes 8 digits + 2 decimal places. N Product Record CSV
Com. Code Description Text 30 Yes   O Product Record CSV (Extended)
Weight Decimal 11 Yes 8 digits + 2 decimal places. P Product Record CSV (Extended)
Stock Take Date Date 10 Yes Enter the format DD/MM/YYYY. Q Product Record CSV (Extended)
Re-Order Quantity Decimal 11 Yes 8 digits + 2 decimal places. R Product Record CSV (Extended)
Last Stock Take Quantity Decimal 11 Yes 8 digits + 2 decimal places. S Product Record CSV (Extended)
Inactive account Integer 1 Yes This must show 1 if inactive. T Product Record CSV (Extended)
Item Type Integer 1 Yes - defaults to Stock. This must be 0, 1 or 2.
0 = Stock, 1 = Non-Stock and 2 = Service.		 U Product Record CSV (Extended)
Web Special Offer?
 Integer  2  Yes This must show 0 if No Special Offer or 1 if Special Offer. V  Product Record CSV (Extended)

Next steps

For help with importing the records, follow our Import product records when setting up your company article.