 NOTE: Price list and special price lists are available in Sage 50 Accounts Professional. If you'd like to upgrade, leave your details and we'll be in touch.
You can use the Import option to import data into your accounts, to create your customer or supplier price lists. 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.
Customer and Supplier Price Lists The file format is the same for customer and supplier price lists:
| Field | Type | Size | Left blank? | Format | Excel column | Report to use | | Stock Code | Text | 8 | No | The stock code must already exist in your accounts data. | A | N/A | | Price List Price | Decimal | 11 | No | This is a fixed price of 8 digits + 2 decimal places. | B | N/A |
Next steps Follow our article to import price lists into Sage 50 Accounts.
|