NOTE: Supplier price lists are available in Sage 50 Professional. If you'd like to upgrade, leave your details and we'll be in touch.

Import file format

The import file must be a CSV or TXT file and must show the data in the following order:

TIP: CSV UTF-8 has been found to work effectively.

• Column 1 - Product reference - This must already exist in your product list.
• Column 2 - Product price - Enter the purchase price for the product.

EXAMPLE: 

Import a price list

Before completing this procedure you must create the supplier price list in Sage 50 Accounts. We also recommend that you take at least one backup of your company data.

1. Click Suppliers, select the required supplier, then click Price lists.
2. Click Import, click Browse, browse to and click your import file, click Open, then click Continue.
   
   The Confirm Supplier Price List Import window appears, displaying the following information:
   
   

   Number of items in current price list	Total number of lines included in the file
   Valid items in import file	The number of items able to be imported without further corrections
   Invalid items in import file	The number of items that require amendment before they can be imported
   Line	The line number of the item.
   Stock Code	The stock code for the price list. This must match a current stock code in Sage Accounts.
   Current Price	The cost price currently held for the item
   Proposed price	The price included on the import file for the item.
   Warnings	For an invalid item (shown in red) the warning column displays the reason why this line cannot be imported, for example, if the stock code doesn't already exist in Sage Accounts, the warning: 'Product code not recognised' appears. This column can also provide information, for example, if the imported item would overwrite a current list price.

3. Complete the Confirm Supplier Price List Import window as required:
   
   • To remove a line from the import, select the relevant line then click Delete Line.
   • To change the new price for the product on the price list, under Proposed Price enter the required price.
   • To clear the existing price list before importing the new details, click the Remove all items from the Price List prior to importing check box.
   • To hide any import warnings in the Warnings column, click the Hide warnings, errors will still be displayed check box.
   • The Save and Save As options are to save your changes back to the import file or to a new file prior to the import.
     
     
4. Click Apply, click Save then click Close.
   
   

Error and warning messages

Errors appear on the Confirm Supplier Price List Import window in red and are not imported into the price list. To import the information, you must take the required action to change the error to a warning or remove the error. The following errors may appear:

Warnings appear on the Confirm Supplier Price List Import window in black and are still imported into the price list. The following warning message may appear:

• Overwrite current product list price of (value)