Open topic with navigation

To import price lists

Accounts Plus and Accounts Professional only

You can import product prices onto any customer or supplier price list that is set up in Sage 50 Accounts. You can also use the import process to add new products onto a price list.

When you import product prices onto a price list, the calculation method is Fixed Price.

The details you import must be in a comma separated value (CSV) format or in a text (TXT) file and in the following structure:

Product Code, Price list price

For example:

STOCK001, 100.00

1. Products, Customers or Suppliers > click Price Lists.
2. Select the price list you want to import details onto > Edit.
3. Import > Browse > locate the required file > Open.
4. Continue > check the details are correct.
5. If you want to clear the existing price list, select Remove all items from the Price List prior to importing.
6. If you only want to see errors when you import, select Hide warnings, errors will still be displayed.
7. If you want to remove any of the items you've imported, select the item line > Delete Line.
8. Apply > Save > Close.