Skip to content
On this page

Selling price groups

Last updated: 7 November 2026 · 3 min read

A selling price group is a separate price list. You might sell to the public at one price and to contractors, hotels or other shops at a lower one. Create the group once, then give each product a price for it.

Before you start: You need permission to open Product setup. The products must already exist. See Add a product.

Create a price group#

  1. Go to Product setup > Selling Price Group (1). The list shows each group with its description. The demo business already has Wholesale.
  2. Select Add (2).
  3. Enter the Name (1), for example Contractor Price, and a Description (2) to remind you who it is for.
  4. Select Save (3).

Selling Price Group list showing Wholesale, with the menu item and the Add button marked

Add selling price group pop-up with the name, description and Save button marked

A new group has no prices yet. A product keeps its normal selling price for any group you have not priced.

Set group prices per product#

  1. Go to Products > List Products and find the product.
  2. Select the arrow next to Edit and choose Add or edit Group Prices (1).

Product row menu with Add or edit Group Prices marked

  1. The page shows the Default Selling Price (Inc. Tax) and one column for each group. Enter the group price in the box (1). For Dulux Weathershield 4L - White, the default price is Rs. 12,095.00 and the Wholesale price is 11500.
  2. Choose Fixed or Percentage (2) under the price. Fixed is the price itself. Percentage is a percentage of the default price.
  3. Select Save (3). BillBook shows Updated Successfully.

Add or edit Group Prices page with the Wholesale price, price type and Save button marked

You can also reach this page from a new product: on Add Product, open Save and and choose Save & Add Selling-Price-Group Prices. That choice only shows when you have at least one group.

Import and export prices#

To change many prices at once, use a file.

  1. Go to Import / Export > Prices (export / import).
  2. Select Export product prices (1). BillBook downloads product_prices.xlsx with one row for every single and variable product.
  3. Open the file and change prices. The columns are product, sku, Selling Price Including Tax and one column for each active group, named after the group, for example Wholesale. Type a percentage as 10%, or a plain number for a fixed price.
  4. Do not change the product names, SKUs or the column headings.
  5. Under File To Import (2), choose the edited file (.xls, .xlsx or .csv).
  6. Select Submit (3). BillBook shows Product prices imported successfully.

Update Price page with the Export product prices button, the file box and the Submit button marked

Note: If one row has a SKU BillBook cannot find, or a Selling Price Including Tax that is empty or not a number, BillBook stops and shows an error. No prices from that file are saved, so fix the row and import again.

Use a group per location or customer group#

  • Per location: go to Settings > Business Locations, edit the location and choose a Default Selling Price Group. Sales at that location then start with that group. See Set up business locations.
  • Per customer group: in Contacts > Customer Groups, set Price calculation type to Selling Price Group and choose the group. See Customer groups and group pricing.

Activate or deactivate a group#

  1. On the Selling Price Group list, select the arrow next to Edit (1).
  2. Select Deactivate (2). A deactivated group is left out of the price export and the group price pages, but its prices stay saved.
  3. Open the same menu and select Activate to bring it back.

The menu also has Delete.

Wholesale row with the Edit button and the Deactivate option in the row menu marked