Pricing & Labels

Price Batch Master

The Price Batch Master is the primary tool for managing price changes across your inventory. Build a batch of items, calculate new prices using powerful bulk methods, round them to your zone's rounding rules, review side-by-side old vs. new, and execute all changes at once. Price batches can also be created automatically from Purchase Orders and Vendor Invoices when costs change. Access from Inventory › Price Batch Master or from the Price Batch List.

Header Fields

Batch No.

Auto-assigned batch number (up to 10 characters). Automatically numbered with "#" on creation.

Price Zone

The price zone this batch applies to. Determines which prices are loaded and which stores are affected when executed. If you change the zone after adding items, the system prompts you to either delete items that don't have prices in the new zone, or create new prices for them.

Description

Free-text description (e.g., "Q2 margin increase", "Vendor ABC cost update"). Auto-filled when created from a PO or vendor invoice.

Executed On

Read-only. Shows the date the batch was executed. Blank until execution.

Reference

Reference string for cross-referencing or notes (optional).

Status

Transaction status. Controls posting and visibility in lists.

Date

Posting date for the transaction. Defaults to today.

Time

Time of posting. Auto-filled from the system clock.

Work Date

Work date for the transaction (may differ from posting date).

Shift

Shift assignment for labour or shift-based reporting.

Store

Store where the transaction is posted. Defaults to current store.

Station

Workstation or terminal where the transaction was entered.

Employee

Employee who created or is responsible for the transaction.

Memo

Free-form memo or notes attached to the transaction.

Items Table

The table shows each item's current pricing alongside the proposed new price. Columns:

Item Number — Scan or type an item number. Only sold items with prices in the selected zone are accepted.
Description — Read-only. Auto-filled from the item record.
Size — Dropdown of the item's available selling sizes. When changed, the Cost, Target Margin, and Price reload for the selected size.
Type — The price type to change. Dropdown showing all price levels defined for this item: Regular, Cust Level 1–4, Qty Level 1–4, Low Price. Changing the type loads the current price for that level.
Cost — The item's current replacement cost for this zone (read-only). Used by the Calculate Prices function.
Target Margin — The item's target gross margin percentage. Editable — if changed, you are prompted on save whether to update the item's target margin permanently.
Price — The current selling price for this zone/size/type (read-only).
New Price — Editable. The proposed new price. Defaults to the current price. Change manually or use Calculate Prices to fill in bulk.

Size

Dropdown of the item's available selling sizes. When changed, the Cost, Target Margin, and Price reload for the selected size.

Type

The price type to change. Dropdown showing all price levels defined for this item: Regular, Cust Level 1–4, Qty Level 1–4, Low Price. Changing the type loads the current price for that level.

Power Buttons

These buttons transform the Price Batch from a simple list into a powerful bulk pricing engine:

Add Items

Opens a selection dialog to bulk-add items by department, subdepartment, group, vendor, or other criteria. Rather than scanning items one at a time, you can load hundreds or thousands of items in a single action. The dialog shows a count of items added when complete.

Clear Items

Removes all items from the batch (with confirmation). Useful for starting over after an Add Items selection that was too broad.

Remove Unchanged

Scans every row and deletes items where Price equals New Price — i.e., items that were not actually changed. After using Calculate Prices, some items may remain unchanged (e.g., their calculated price matched their current price). This button cleans up the batch to show only genuine price changes, making review and execution more focused.

Calculate Prices

The most powerful button. Opens a calculation dialog that applies a formula to every item in the batch at once. Five calculation methods:

Method	Formula	Use When
Cost Markup	New Price = Cost + (Cost × %)	You want a fixed markup over cost (e.g., 50% markup on all items)
Price Change	New Price = Old Price + (Old Price × %)	Across-the-board percentage increase or decrease (e.g., raise all prices 3%)
Gross Margin	New Price = Cost × 100 / (100 − %)	Set all items to a specific gross margin (e.g., 35% GM)
Target Margin	Uses each item's own target margin	Recalculate all items to their individually-set target margins after a cost change
From Zone	Copies prices from another price zone, optionally adjusted by a percentage	Setting up a new store zone based on an existing zone's pricing

The calculation respects tax-inclusive and deposit-inclusive pricing, automatically adding back taxes and deposits after calculating the base price. A progress bar shows calculation progress for large batches.

Round Prices

Applies the price zone's rounding rules to every New Price in the batch. For example, if the zone rounds to x.99 endings, a calculated price of $4.73 becomes $4.99. Requires the zone to have rounding rules configured. Reports the number of prices rounded.

Execution Buttons

Execute Batch

Applies all New Prices to the actual item records. For each item where the new price differs from the current price, the item's price is updated in the database for the selected zone, size, and type. After execution:

• The Executed On date is set to today.
• You are prompted to print a report of the price changes.
• You are prompted to create label batches — one per store in the zone — so shelf labels can be reprinted for changed items.

Make Labels

Creates Label Batches for items with changed prices, without executing the batch. A label batch is created for each store in the price zone. Only items where New Price differs from Price are included. Items with "No Labels" label type are skipped. Items with "Item Labels" get one label per unit on hand; "Shelf Labels" get one label each.

Typical Workflow

1. Create a new batch and select the Price Zone.
2. Click Add Items to bulk-load items (e.g., all items from vendor "ABC Supply").
3. Click Calculate Prices and choose Target Margin to recalculate prices based on updated costs.
4. Click Round Prices to apply zone rounding rules.
5. Click Remove Unchanged to clean up items that didn't actually change.
6. Review the Price vs. New Price columns. Manually adjust any outliers.
7. Click Execute Batch to apply, print, and create labels.

Zone Change Prompt

Choose an Action

When you change the price zone after items have been added, this dialog asks whether to delete lines that have no price in the new zone, or create new prices for them.