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.viewto open the page,inventory.prices.manageto add, edit and deactivate. The Warehouse Manager role has both.- The item must already exist in the Item Catalog.
The four price types
| Type | Use it for |
|---|---|
| Default | The normal price everyone pays. Every sellable item should have one. The customer portal only uses Default prices. |
| Customer-Specific | A 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. |
| Promotional | A 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:
- Looks at the customer's Price Type (set on the customer by the Sales team; customers with none use Default).
- Finds the active prices of that type for the item that are valid on the document date and whose minimum quantity the line reaches.
- Uses the one with the highest quantity break reached; if two tie, the lower price.
- 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.
| Column | Meaning |
|---|---|
| Item, SKU | The item the price belongs to. |
| Type | Default, Customer-Specific, Tiered or Promotional. |
| Price Name | A label you choose, such as "Wholesale" or "Summer Sale". |
| Unit Price | Price per unit. |
| Min Qty | The quantity break, for tiered prices. |
| Valid From / Valid To | The promotion window (Valid To is hidden by default). |
| Active | Whether the price is still offered. |
| Created | Hidden by default. |
Add a price
- Select Add Price.
- 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.
- Select Add Price. You see "Price added".
Change a price
- Open the row menu and choose Edit.
- Change the values. Fill in Reason for change — for example "Supplier price increase" — so the change is explained in the price's history.
- 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
| Problem | What 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 price | The item has no active Default price (and no price for the customer's type). Add one. |
| A promotion is not being applied | Check 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 order | The portal always uses the Default price; sales orders use the customer's price type and quantity breaks. |
Related pages
- Item Catalog — the items being priced.
- Profit Analysis — what you earned at these prices.
- Portal Orders — orders placed at the Default price.