The price list structure in Brightpearl is really powerful, so it's worth spending a bit of time to understand exactly how it works.
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:
- 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 and editing price lists
Note that price lists are the list names, not the prices on the lists. To edit prices, see further below. If you have a "Products" tab in your main menu, click it, then go to Setup : Price lists.
Create any new price lists you need. A price list code will be created automatically (all price lists need a code).
To create a foreign currency price list, see further down this page.
Price lists, net, gross and tax
If you want a price list to be an end-user price list that should show prices including tax, then you can set it up appropriately on the price list edit page.
Business-to-Business (B2B) prices are usually shown excluding tax (net)
Business-to-Consumer (B2C) prices are usually shown including tax (gross), These prices are shown underlined throughout Brightpearl.
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.
Volume discounts
If you want to provide items cheaper when bought in bulk then you can use the volume discount boxes (only available with Standard and Premium stock control). Open a product to edit, and visit the Prices tab.
Enter 1+ £10 in the top row of boxes
Enter 10+ £9.50 in the second row of boxes
This would give the customer a price of £9.50 when buying 10 or more.
Volume discounts are only applied automatically:
- Iin the shopping cart if you have Ecommerce
- If you click "reset prices" in a sales order
- In EPOS module
Price lists and Contacts
Price lists are applied to contacts, via the contact edit screen, in the Financials tab.
Ensure that your suppliers are set to use a "COST" price list.
Price lists and Sale/Purchase Orders
When you create a sale or purchase for a contact, the contact price list is used. When you add products, the relevant price list is used.
The important bit:
When you search for products when adding to an order, you will only see items that have a price on the price list that you're using.
This allows you to have certain subsets of products that are only available to certain customers/suppliers. A typical situation may be that you have items that you sell to end-users at retail price, and another set of items that are only available to wholesale customers. As long as your wholesale customers are set to use the wholesale price list, then the default searches will only bring up wholesale products.
In a similar fashion, you can set suppliers to have their own price lists, which will reduce the risk of staff ordering product from the wrong supplier. Ensure that each supplier has their own price list, and set the supplier to use this price list in the contact edit screen.
Editing product prices
Prices can either be edited in the product edit page (Search for the product, click the pencil to edit it and choose the prices tab), allowing you to edit a single products prices across all the pricelists you have configured, or you can edit all product prices across a single pricelist by going to Products : Setup : Price lists.
Updating prices with Excel
You can use the Data Manager to update hundreds of prices at once if you need to.
- Click Setup : Import data from the main menu
- Click "products" from the choices in the Excel section - you will need Stock control module to access this feature
- Create a data map, with a "hook" in the first column (product ID or SKU)
- Choose one or more price lists for the second/third columns
- Save your data map
- Create an Excel file with matching headers
- Import the file!
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
Standard stock control module is required for foreign currency orders.
You can raise sales orders and purchase orders in foreign currency, which will be converted to your base currency in the accounting system.
- Create a new currency at Setup:Options:Other:Localisation:Currencies. Make sure you click to update the currencies so that there is a value on it.
- Set up a new price list
- Set the currency of the price list
- Open the foreign customer / supplier and set them to use that price list. Save the contact.
- Create a new order for the contact - you will see that the order has been set to the foreign currency.
Once you have created your new price list you will probably want to add some prices to products. Open any product for edit and you'll see the new price list available. 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.
