Never Lose Profit Again: The Cost, Margin & Price Update Worksheet

If you manage a Counterpoint database with thousands of SKUs, you already know the pain: a supplier raises costs on 200 items, and now someone has to open each one, do the math, and update it — one line at a time. Multiply that across every supplier, every season, every price change, and “quick pricing update” turns into a multi-day project.

The POS Highway Cost, Margin & Price Update Worksheet was built to eliminate that bottleneck. It connects directly to your NCR Counterpoint SQL product database, so instead of clicking through individual item records, you’re working in one organized, spreadsheet-style view — updating costs, margins, and prices across thousands of items at once.

How It Works

The worksheet pulls your live inventory data straight from Counterpoint, then lets you filter and review it however makes sense for the task at hand — by supplier, product category, subcategory, or any other criteria you choose. From there, you can adjust costs and let the worksheet recalculate prices based on your target margin or markup, review everything before committing, and push the changes back to Counterpoint in one batch.

No more toggling between a spreadsheet, a calculator, and Counterpoint’s item screen. It’s one workflow, start to finish.

What You Get

Speed that actually matters. The core win is time. Updating thousands of product costs, margins, and selling prices — a job that used to eat hours or days — now takes minutes. When a supplier sends a new cost sheet, you can process it the same day instead of letting it sit in a queue.

Margins that don’t quietly erode. Selling prices update automatically based on new supplier costs and your target margin or markup, so profitability isn’t left to whoever remembers to do the math correctly on item #847. The worksheet also lets you preview current vs. proposed costs, prices, margins, and markups before anything goes live — so you’re never pushing changes blind.

Bulk control, not bulk risk. Because you can apply updates by supplier, category, subcategory, or other inventory groupings, you get the speed of a mass update with the precision of working item-by-item. That same structure makes it easy to standardize pricing rules and margin targets consistently across departments and product lines — not just react to one supplier at a time.

Pricing that reflects how you actually sell. Whether you’re managing retail, wholesale, B2B, cash-and-carry, or customer-specific price levels, the worksheet supports updating multiple pricing tiers at once — and keeps costs and prices consistent across every store, warehouse, and sales channel if you operate more than one location.

Fewer errors, more confidence. Manual entry is where pricing mistakes creep in — a misplaced decimal, an outdated cost, a margin that never got recalculated. Centralizing the process in one worksheet reduces that risk and gives you a clearer picture of exactly how a supplier cost change ripples through your margins and profitability before you commit to it.

Pricing maintenance shouldn’t be the thing that eats your week every time a supplier sends a new cost sheet. The POS Highway Cost, Margin & Price Update Worksheet turns that recurring, error-prone task into a faster, more controlled process — so you can protect profitability, cut down on administrative work, and manage even the largest Counterpoint catalogs with confidence.

Ready to stop updating prices one item at a time? Get in touch to see the Cost, Margin & Price Update Worksheet in action on your own Counterpoint data.