Skip to main content

Item Pricing

Inventory → Item Pricing (/inventory/pricing) holds the selling prices of your items. When someone adds an item to a sales quotation or order, the price is filled in from this list; the customer portal also reads it.

This page is about what you charge, not what you pay. What an item costs you is worked out automatically from what you paid on receipts (the moving average — see Costing).

When to use this page​

  • Giving a new item its selling price.
  • Changing a price, and recording why.
  • Setting a cheaper price for buying in bulk (a quantity break).
  • Running a promotion for a fixed period.
  • Retiring a price that should no longer be offered.

Before you begin​

  • inventory.prices.view to open the page, inventory.prices.manage to add, edit and deactivate. The Warehouse Manager role has both.
  • The item must already exist in the Item Catalog.

The four price types​

TypeUse it for
DefaultThe normal price everyone pays. Every sellable item should have one. The customer portal only uses Default prices.
Customer-SpecificA separate price list for customers whose Price Type is set to it on their customer record.
Tiered (Qty Break)A price that applies from a minimum quantity, for example ₱90 each when buying 10 or more. Requires Min Quantity of 2 or more.
PromotionalA price that only applies between a Valid From and Valid To date.

How a sales line picks its price​

When an item is added to a sales document, the system:

  1. Looks at the customer's Price Type (set on the customer by the Sales team; customers with none use Default).
  2. Finds the active prices of that type for the item that are valid on the document date and whose minimum quantity the line reaches.
  3. Uses the one with the highest quantity break reached; if two tie, the lower price.
  4. If the customer's price type has no matching price, falls back to the Default price; if there is none, falls back to the item's standard unit cost.

The salesperson can still change the price on the line. Changing a price here never changes documents that already exist.

Understanding the page​

The standard list layout (Working with lists) with tabs All, Active and Inactive.

ColumnMeaning
Item, SKUThe item the price belongs to.
TypeDefault, Customer-Specific, Tiered or Promotional.
Price NameA label you choose, such as "Wholesale" or "Summer Sale".
Unit PricePrice per unit.
Min QtyThe quantity break, for tiered prices.
Valid From / Valid ToThe promotion window (Valid To is hidden by default).
ActiveWhether the price is still offered.
CreatedHidden by default.

Add a price​

  1. Select Add Price.
  2. Fill in:
    • Item — required.
    • Price Type — required.
    • Price Name — optional, for example "Wholesale", "VIP".
    • Unit Price — required, zero or more.
    • Min Quantity (qty break) — shown for Tiered prices only; 2 or more.
    • Valid From / Valid To — shown for Promotional prices only.
    • Notes — optional.
  3. Select Add Price. You see "Price added".

Change a price​

  1. Open the row menu and choose Edit.
  2. Change the values. Fill in Reason for change — for example "Supplier price increase" — so the change is explained in the price's history.
  3. Select Save. You see "Price updated".

Stop offering a price​

Choose Deactivate from the row menu (or the Deactivate button inside the edit drawer), and confirm. The price moves to the Inactive tab and is no longer offered on new documents. Prices are deactivated rather than deleted so their history is kept.

To deactivate many at once, tick them and use Deactivate in the bar that appears. Already-inactive rows are skipped.

Common issues​

ProblemWhat to check
"Tiered prices require minQuantity >= 2"Enter a Min Quantity of 2 or more, or choose another type.
A sales order shows the item's cost instead of a priceThe item has no active Default price (and no price for the customer's type). Add one.
A promotion is not being appliedCheck the document date is between Valid From and Valid To, and that the customer's Price Type is Promotional — the price type must match the customer's.
The portal shows a different price from a sales orderThe portal always uses the Default price; sales orders use the customer's price type and quantity breaks.