Create and amend price bands

Note: Limited price bands are available if you have selected Enable limited price bands in Price Book default settings.

A price band is price list. Each price band contains the prices of your stock items. Each price band is linked to your customer accounts and this determines the price your customer receives for each stock item.

These contain the prices for all stock items.

  • All customers are linked to the Standard price band by default.
  • A customer can only belong to a single Universal price band.
  • When a customer is added to a new Universal price band, they are removed from an existing one.
  • Every customer must belong to at least one Universal price band. When they are removed from a price band they're automatically added back to the Standard price band.

These can be used for special and promotional prices. You can choose which stock items prices to include and which customers they're linked to. You can set them up in advance and choose when they're active.

  • You can use both Universal and Limited price bands.
  • You choose which stock items to add stock items to these price bands.
  • Customers can belong to any number of Limited price bands.
  • You can chose a date / time period the price band is used in.
  • Once a price band has expired, you can activate it again by changing the date / times.
  • You can make a price band inactive so it's not in use.
  • The price in the Limited price band takes priority over a price in a Universal price band.
  • When a customer is eligible for more than one limited price, the lowest price is used.
  • When a customer returns goods, the current price is used by default on the return. This may be different to the price on the original order, particularly if you're using time limits on your price bands.
  • All customers must be linked to a single Universal price band. This is because every customer must have a price for every stock item.
  • Unless you set up additional price bands, all customers are linked to the Standard price band by default.
  • Customers can be linked to any number of limited price bands, in addition to a single Universal price band.
  • If a customer is linked to a Universal band and a Limited band, the price in the Limited band takes priority over the price in the Universal band, provided the Limited band is Active and has not expired.
  • If a customer is linked to more than one Limited price band and is eligible for more than one limited price, the lowest price is used.

Note: When a customer returns goods, the current price is used by default on the return. This may be different to the price on the order if you are using time limits on price bands.

You can also set foreign currency prices for stock items. To do this you set a currency on the price band. Only customers using the same currency can be linked to the price band.

Create price bands

Open: Price Book > Price Bands > Maintain Price Bands.

Every price band must have a Name.

  1. Choose Universal as the price band Type.

  2. Choose how to set the starting selling prices.

    You can set them to zero (0.00000), set them to be the same as an existing universal price band, or set them to be the same as the Standard price band.

  1. Choose Limited as the price band Type.
  2. For limited price bands, you can choose:
    1. Active: A price band must be Active for the prices to be used, even if a current time period is set.

    2. Time-based: The start date / time is mandatory but you can choose whether to enter a finish date / time. This must be today's date or later as you cannot start a time-limited price band in the past.

      Note: If you select today's date as the From date, the from time will default to 00:00. You must select a start time later than the current time, so that it's not in the past.

  3. Choose how to set the starting selling prices.

    You can set them to zero (0.00000), set them to be the same as an existing universal price band, or set them to be the same as the Standard price band.

This is only visible if you've selected to Enable limited price bands in the Price Book Settings.

To link and unlink customers

  1. Select any price band (except the Standard price band).
  2. Click Link to Customers.
    1. Click Add Customers.
    2. Select the customers to add to the price band.

      3. Tip: To select multiple items, use the Ctrl key to pick individual items, or hold down the Shift key to select a block of items.

    3. Click OK.

      4. If a customer is linked to another price band, confirm that you want to link the customer to this price band instead.

    1. Select the customers you want to remove from the price band.
    2. Click Remove Customers.

    3. Click OK.

      The customers will now be linked to the Standard price band.

Delete a price band

  • For Universal prices bands, any customers linked to this price band are removed and added back to the Standard price band.
  • The price on existing sales order or invoices will remain the same.
  • If you change an existing order or invoice, increase or decrease the quantity for example, then the new price will be used. This will be the price from the Standard price band unless you've linked the customer to a different price band. If the customer is already linked to a different Limited price band, then this Limited price will be used.

Open: Price Book > Price Bands > Maintain Price Bands.

  1. Select the price band.
  2. Click Delete.

What's next?

Enter selling prices and link stock items to price bands

See also

Steps in this task

Enter selling prices and link stock items to price bands

Enter selling prices per stock item

Other tasks

Setting up your selling prices

How to set up discounts

How prices and discounts are applied to orders and invoices

Markup pricing