Prices + Price Lists

The price list structure in Brightpearl is really powerful, so it's worth spending a bit of time to understand exactly how it works.

Price lists are used for storing both the purchase (cost) and the sell price of your product items. If you buy or sell in different currencies you will also need separate cost and sell price lists for each currency. Your price lists are always displayed with their currency symbol to ensure you know which one you're using.

There are a few default price lists set up in your Brightpearl account, but you can add as many as you require, although we advise keeping things as simple as possible to start with, for example:

• Cost
• Wholesale
• Retail

If you have more than 15 price lists, then you won't see all the price lists in the product edit screen. You'll only see the first 3 lists, plus any price list that is attached to any suppliers for the item.

Adding prices is a two stage process, first you need to create a new price list and then you can add a price for each of your products, either manually or using a data import.

Net, Gross & Tax

Brightpearl handles B2B and B2C pricing in a powerful, easy to use fashion:

B2C means Business to Consumer, i.e. you're selling to the general public or end-user. Prices are typically (in the UK) displayed as inclusive of tax. This is also called "gross".

B2B means Business to Business, so you're selling to another company. Usually this means that you're quoting prices exclusive of tax, or "net".

You can handle both in Brightpearl using price lists; create a price list for each of the customer and supplier groups that you work with. Each price list can be set up to "show prices including tax" or not. If you see a price in Brightpearl that's underlined, then you know it includes tax.

All prices are stored as NET, to 4 decimal places on the database. If you're using a B2C/Gross price list, then it's translated to the gross amount when showing on-screen.

Price Breaks (Volume Discount)

You can use price breaks to apply discount for different levels of bulk purchases. The different prices are applied automatically:

• In the shopping cart if you have e-commerce
• If you click "reset prices" in a sales order
• In EPOS module

Adding & Editing Price Lists

Note that price lists are the list names, not the prices on the lists. You can create any new price lists you need.

1. Go to Setup > Products > Price lists.
2. Click Add a new price list.
3. Enter a name for the price list, e.g. Cost, Retail, Wholesale.
4. Enter a code for the list, e.g. RRP.
5. Select the currency of these prices that will be added to this list. (Read below for more information on foreign currency price lists).
6. Specify whether to show prices including or excluding tax; useful for adding lists for B2B or B2C transactions.
7. Specify whether the prices on this list are cost prices, used for purchases from your suppliers.
8. Click Save.

You price list is now listed with a summary of the settings. Once product prices are added you will be able to export a list of these items with their prices by clicking on the Excel icon. You will also be able to see how many contacts and suppliers have been assigned to the price list; you can click the number to view a listing of them.

Add/Edit Prices for Products

Prices are added directly to products. This can be done manually for each item or by importing the data.

Manual

1. Search for the product.
2. When the item is listed click on the name to view/edit.
3. Select the Prices tab and then the tab for the relevant price list.
4. Enter the product prices. Use price breaks to apply different prices for different order quantities. Underlined prices represent amounts including tax.
5. Click Save changes.

Don't forget that if a contact/order is set to use a certain price list, then you'll only see items that have a price on that price list when adding items to an order.

Importing

You can import prices for your products and include price breaks for volume discounts too.

Make sure ALL your prices are net figures (tax exclusive) on your spreadsheet as when the price is added to the product the tax is automatically caluclated using the tax rate on the product.

Formatting the Excel file

You require 6 columns for importing prices and it must be saved as a CSV file:

Here's an example product in Excel:

Note that you don't require a supplier SKU, you can leave the cell blank.

Save your file as a CSV file.

To import/update your price list:

1. Go to Setup > Products/Inventory > Price Lists.
2. On the right-hand side of the screen select which column you want to match up prices to products by; Product ID (the Brightpearl reference), Primary SKU (the main product SKU) or Supplier SKU. This is what will be used to match the items in the spreadhseet to the items in Brightpearl so make sure all the row have one of whatever you choose to use.
3. Tick the checkbox if you want to skip items not matched; this will update all the items it matches. If you want to cancel the whole import if items aren't matched untick this box.
4. Browse for your price list Excel file.
5. Select the price list you want to update.
6. Click the Import CSV button.

Note that the prices you put into your spreadsheet should be NET (ex tax) regardless of whether the price list is set to display prices including tax or not.

Foreign Currency Pricing

To create sales and purchases using a foreign currency you will need to:

1. Add the currency
2. Update exchange rates
3. Create the foreign currency price list
4. Add product prices to the price list
5. Assign the price list to customers/suppliers

Sales and purchases are ALWAYS posted to accounting in your base currency so any foreign currency sales or purchases will be converted prior to being posted. They are converted using the exchange rates stored in Brightpearl. You will need to ensure these are kept up-to-date, however, you can see the rate that's being applied directly within the order.

Learn more about multi-currency sales or multi-currency purchases