Set up a New Price Book

Created by David Joyce

Overview

This guide explains how to create a Price Book, assign it to a customer, and add products to the price book using either bulk import or manual product-level pricing.

Price Books allow you to:

• Set customer-specific pricing

• Apply fixed prices or discounts

• Manage wholesale, trade, or contract rates

Step 1 — Create a New Price Book

1. Go to Settings & Tools.

2. Scroll to Customers.

3. Click Price Books.

4. Click Add New Price Book.

5. Enter a Price Book Name (e.g. Sample Price Book).

6. Save the price book.

The price book is now created but does not yet contain any products.

Step 2 — Assign the Price Book to a Customer

1. Go to Customers → List.

2. Locate the customer and click Edit.

3. Find the Price Book field.

4. Change it from Standard Price List to your new price book.

5. Save the customer.

The customer is now assigned to the price book.

Note: If the price book contains no products yet, standard pricing will still apply until prices are added.

Step 3 — Add Products to the Price Book (Bulk Import)

To add many products at once:

1. Go to Settings & Tools → Customers → Price Books.

2. Click Edit on the price book.

3. Select Price File Import.

4. Upload the completed price book import file.

This method is best for:

• Wholesale price lists

• Large customer catalogues

• Regular price updates

(See the Price Book Import training guide for details.)

Step 4 — Add Products to the Price Book (Single Product)

If you only need to price one or a few products:

1. Go to Stock → Products.

2. Find and View/Edit the product.

3. Scroll to the tabs at the bottom.

4. Open the Price Books tab.

5. You will see all available price books.

For the selected price book, choose one of the following:

Fixed Price

• Enter a specific price

• The customer is always charged this price

• Retail price is ignored

Discount Off

• Enter a discount percentage

• Price is calculated as a discount off the product’s standard price

Save the product once pricing is set.

How Pricing Works on Documents

When creating sales documents for the customer:

• Turbo checks the customer’s assigned price book

• If a price exists for the product:

  • Fixed price is applied, or

  • Discount is calculated automatically

• If no price exists:

  • Standard product pricing is used

Common Use Cases

• Contract pricing for key customers

• Wholesale vs retail pricing

• Special delivery or service rates

• Customer-specific negotiated prices

Best Practices

• Name price books clearly (e.g. Wholesale 2026, Customer XYZ Contract)

• Use bulk import for large price lists

• Use product-level pricing for one-off agreements

• Review price books regularly

Summary

To create and use a price book:

1. Create a new Price Book

2. Assign it to a Customer

3. Add products via import or product pricing

4. Use it automatically on sales documents

Price Books provide flexible, controlled pricing tailored to your customers.