Import Price Level

Create many price levels (By Item or Fixed %) at once from the LocalizeBook Excel template using Import Price Levels.

Last updated: Nov 18, 2026

Overview

Import Price Levels lets you create many price levels at once from a single Excel file, instead of adding them one by one. Both price level modes are supported:

  1. By Item — a set price for each item, with optional quantity ranges.
  2. Fixed % — one rule for all items, such as increase or decrease by a percentage or an amount.

Example: create a Wholesale level with its own price for each item and a VIP 5% level that takes 5% off every item — in one import.

Note: The import only creates new price levels. A price level name that already exists in your business is refused. If you don't see Import Price Levels in the menu, make sure Price Level is active for your business.

Step 1: Download the template

  1. Go to Accounting > Bulk Operations > Import Data > Import Price Levels.
  2. Click Download Template at the top of the page to download the price level template (Price Level Template.xlsx).

Important: Always use the latest template. Import Price Levels does not support Smart Import, so your own file layout is not accepted. If you choose an old template or a different file, LocalizeBook shows "The Excel template is out of date. Please download the latest template."

Step 2: Fill in the template

Each different PRICE_LEVEL_NAME becomes one price level. Fill in the columns on the PriceLevels sheet:

Column

Description

PRICE_LEVEL_NAME

Name of the price level (required). Rows with the same name belong to the same price level.

MODE

BY_ITEM (By Item) or FIXED_PERCENTAGE (Fixed %).

TYPE

Fixed % only: Increase or Decrease.

VALUE

Fixed % only: how much to increase or decrease, for example 5. It can't be negative.

DISCOUNT_METHOD

Fixed % only: % or Amt (amount).

ROUND_TYPE

Fixed % only: how to round the new price, for example NoRounding or 0.1.

MEMO

Optional note for the price level.

ITEM_CODE

By Item only: the item's code. The item is found by its code first, then by its name.

ITEM_NAME

By Item only: the item's name (used when there is no code).

PRICE

By Item only: the item's price in this price level, in the currency of the item's base-unit price.

START_QTY / END_QTY

By Item only, optional: a quantity range for tiered prices. Whole numbers only. The first range starts at 0 and each next range starts right after the previous END_QTY, with no gaps.

BRANCHES

Optional. Used only when price levels are separated by branch. Leave it blank to use all of your branches.

MEMO and BRANCHES belong to the whole price level: fill them on one row, or repeat the same value on every row of that level.

Example: By Item price level

Add one row for each item price, or one row for each quantity range of an item:

PRICE_LEVEL_NAME

MODE

ITEM_CODE

ITEM_NAME

PRICE

START_QTY

END_QTY

Wholesale

BY_ITEM

ITM-001

Coffee Beans 1kg

18.00



Wholesale

BY_ITEM

ITM-002

Green Tea 500g

9.50

0

9

Wholesale

BY_ITEM

ITM-002

Green Tea 500g

8.75

10


Example: Fixed % price level

Use a single row with TYPE, VALUE, DISCOUNT_METHOD and ROUND_TYPE, and no items:

PRICE_LEVEL_NAME

MODE

TYPE

VALUE

DISCOUNT_METHOD

ROUND_TYPE

VIP 5%

FIXED_PERCENTAGE

Decrease

5

%

NoRounding

Tip: Type 5 for 5%. If the cell is formatted as a percentage in Excel, 5% is stored as 0.05 and would be read as 0.05%.

Step 3: Import the file

  1. Click Browse File and choose your completed file.
  2. LocalizeBook checks every row. If something is wrong, the problem is shown on the cell it is about — fix it in your file and choose the file again.
  3. Review the list of price levels that will be created.
  4. Click Import.
  5. When it finishes, a message shows how many price levels were imported.

If a price level can't be saved, the import stops at that level. Levels already saved are removed from the list — fix the problem and click Import again to import the rest.

Common problems

  1. Name already exists: use a new PRICE_LEVEL_NAME. The import creates new price levels only — edit existing ones in Customer > Price Level.
  2. Item not found: check that ITEM_CODE or ITEM_NAME matches an active item.
  3. Not a number: type numbers without thousand separators, for example 1500 instead of 1,500.
  4. Negative value: VALUE can't be below zero.
  5. Branches not found: check the branches you entered in BRANCHES.
  6. Quantity ranges: START_QTY and END_QTY must be whole numbers, start at 0 and continue without gaps.

Common questions

Where do I import price levels? Accounting > Bulk Operations > Import Data > Import Price Levels.

Where do I see or edit price levels after importing? Go to Customer > Price Level. The import cannot change existing price levels.

Can one file create several price levels? Yes. Each different PRICE_LEVEL_NAME in the file becomes its own price level, and you can mix By Item and Fixed % levels in the same file.

How do I set tiered prices by quantity? In a By Item price level, add one row per quantity range for the item using START_QTY and END_QTY. The first range starts at 0 and the ranges continue without gaps.

How do I make a price level that gives 5% off every item? Use one row with MODE FIXED_PERCENTAGE, TYPE Decrease, VALUE 5, and DISCOUNT_METHOD %. Type 5, not 5%.

Why do I see "The Excel template is out of date"? The file is not the current price level template. Click Download Template, copy your data into the new template, and import again.

Related Articles