Product price lists (AKA customer groups)

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.

mceclip1.png

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.

sell list

The default price list assigned to new customers is set at Settings > Contacts > Contact defaults.

mceclip0.png

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.

cost list

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.

mceclip8.png

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:
    mceclip2.png
  • 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.

Learn more about currencies and exchange rates here.

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
    mceclip3.png
    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.
  • mceclip5.png 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.
  • mceclip6.png Connect suppliers to products
    Clicking this button will assign all suppliers the price list is assigned to to all of the products using the price list. This can't be undone, so use it carefully!
  • mceclip7.png 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.

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.

Video

 

Have more questions? Submit a request