Product Price Lists (or customer groups)

Price lists let you add multiple sell and buy 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.

In addition to price lists, customers can be assigned a flat rate discount to apply to the price list they have been assigned.

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.

Add or configure price lists at Settings > Products/Inventory > Price lists.

Net or gross

All prices in the Brightpearl database are stored as net(excluding tax) prices. When importing prices they must always be net.

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.  Brightpearl calculates the tax inclusive amount to display by taking the net price and adding the relevant tax value based on the tax code being applied at the time.

Any tax inclusive price in Brightpearl will be underlined

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 .

Cost price lists

Cost price lists are used for recording the prices used for buying inventory from vendors (suppliers).

A price list called "Cost" is provided with every Brightpearl account. More can be added if required.

All price lists set as a supplier price list are "cost" price lists.

cost list

Where there are multiple vendors (suppliers) of the same item, separate price lists will need to be created. Where there is only a single vendor (supplier) of each product, then a price list can be shared.

Foreign currency price lists

Additional price lists are required when managing foreign currencies.

A price list cannot be converted into multiple currencies so a price list is required for each different currency used to sell and each currency used to buy.

Currencies will also need to be added and exchange rates added/downloaded in order to create foreign currency price lists.

Displaying price lists on products

  • 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. You will need to save after changing each price list. Use the "Save and stay here" to save changes but remain in the product record.

Price list 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.

Deleting price lists

If a price list is associated with a contact or has been used on an order; then the price list 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.

Video : product price lists

 

Have more questions? Submit a request