In Brightpearl, a price list is a collection of prices assigned to a contact. They are categorized into two different kinds: sell price lists or buy price lists.
Price lists let you add multiple prices for any product. Perhaps you have a number of types of customer (B2C and B2B perhaps) - they will have different prices for the same item.
Similarly, you might have different cost prices for items based on where you buy them from. Many merchants have base currency cost price lists and foreign currency cost price lists for items imported from overseas.
Adding a new price list
To add a new price list, go to Settings > Products/Inventory > Price lists and click 'Add a new price list' on the top right hand side of the page.
You must give the price list a name, a code and a currency, then choose whether the prices should be displayed exclusive or inclusive of tax (net or gross), and whether the price list is a buy price list or a sell one.
Net or gross
Price lists can be set as inclusive or exclusive of tax, allowing prices to be displayed in Brightpearl as net or gross. For example, UK users may prefer retail prices to be displayed inclusive of tax.
Any tax inclusive price in Brightpearl will be underlined.
Brightpearl calculates the tax inclusive amount to display by taking the net price and adding the tax amount on top, based on the tax code being applied at the time.
For example, if the net price is £10, and the tax code has a rate of 20%, the price displayed would be £12.00 (£10 + (20% of 10)).
Note: All prices in the Brightpearl database are stored as net (excluding tax) prices. When importing prices they must always be net.
Sell price lists
Sell price lists are used to define customer groups such as retail, wholesale or distribution.
Any price list not set as a supplier "cost" price list is then a sell price list used for customers.
The default price list assigned to new customers is set at Settings > Contacts > Contact defaults.
Cost price lists
Cost price lists are used for recording the prices used for buying inventory from vendors (suppliers).
All price lists set as a supplier price list are "cost" price lists.
Where there are multiple vendors of the same item, separate price lists will need to be created. Where there is only a single vendor of each product, then a price list can be shared.
The default price list assigned to new vendors can be set under Settings > Purchases > Purchase settings.
Adding and updating prices to price lists
The prices on a price list can be updated in three ways:
- Individually, on a product record
To update the price of a product on a product record, go to Products > List products/services and click into the product record. Then, go to the 'Prices' tab, and select the relevant price list. From there, you can change the price:
- In bulk, using a price list import
Price lists can be imported under Settings > Products/Inventory > Price lists.
Learn more about importing price lists here.
- In bulk, using a product import
Prices can also be imported using a product import, under Settings > Data/import > Import products.
Learn more about updating prices using a product import here.
Foreign currency price lists
If you buy or sell in foreign currencies, you will need to set up price lists for those currencies, since existing price lists cannot be converted into multiple currencies.
In order to create foreign currency price lists, you will need to add the relevant currencies and exchange rates into the system.
Working with price lists
There are certain actions which can be taken on the list of price lists:
- Export all items as XLS or CSV
Clicking these buttons on the top right-hand side of the page will export a simple product list containing product ID, SKU and item name, which can be used to build a price list.
- Export price list as XLS or CSV
Clicking the Excel icon or page icon will export a specific price list as an XLS or a CSV file, for easy editing.
Learn more about exporting price lists here.
- Connect suppliers to products
Every supplier is assigned a price list, and products can be assigned suppliers. Clicking this button will assign all suppliers using the price list to all of the products using the price list. This can't be undone, so use it carefully!
- Delete price lists
If a price list is associated with a contact or has been used on an order it cannot be deleted.
You can associate a different price list with your contacts in order to delete the price list that was being used. However, you cannot change price lists on invoiced orders.
Products and prices
Displaying price lists on product records
- If you have 14 or fewer price lists in Brightpearl you will see each one displayed as a tab within the product record. You can click between each price list to make any changes and then save at the end.
- If you have 15 or more price lists in Brightpearl it is not possible to fit them all as tabs on the product record. Instead you will see a dropdown menu which allows you to switch and edit each price list.
Note: If making any changes to a product's prices when there are over 15 price lists, you'll need to save between each change. Use the "Save and stay here" button to save changes but remain in the product record.
Price list (supplier/vendor) SKUs
A product can be assigned a SKU against each price list.
This can be used to record a vendor (supplier) SKU, or a customer SKU, so that when orders are placed they may use and see their own SKUs.
Price list SKUs can be added to individual products by entering a value into the "SKU" field on the price list:
Or when importing a price list.
Note: If a price list SKU is in use, that is the SKU which will display on any sales or purchase orders using that price list.