Price Index Calculator

Compute a weighted price index vs competitors from CSV or copy/paste: index, top 5 SKUs above/below target and a traffic light within tolerance.

Note: results are not made indexable via URL parameters. Canonical: https://tools.snapsoft.de/en/tools/preisindex

Who is this for?

  • Pricing teams needing a quick level benchmark vs competitors
  • Category managers who want to weight important SKUs higher (revenue/units/proxy)
  • Teams working without APIs/scraping via copy/paste/CSV

Price index vs competitors: fast, weighted, no APIs

A price index is a condensed metric: it compares your price level vs competitors — typically weighted (e.g. by revenue/units) so important SKUs matter more than long-tail items.

Upload a CSV or paste a table (columns: sku, ownPrice, competitorPrice, optional weight). The tool computes the weighted index, shows top deviations and flags via a traffic light whether you’re within tolerance around your target index. Everything runs locally in your browser.

Calculator

Max 6 inputs, clear outputs. Everything runs locally in your browser.

Inputs

Max 6 core inputs — everything runs locally (no server-side upload/storage).

Data (CSV or copy/paste table)

Header optional. With header: sku, ownPrice/price, competitorPrice/competitor_price (weight optional). Without header: columns 1–3 = SKU, ownPrice, competitorPrice; column 4 = weight (optional).

Copy/paste or CSV. Results are not indexed via URL.

%
Advanced options
%

Simple text filter (SKU/name).

Result

Paste a CSV/table (or pick a file) and click “Calculate”. Everything runs locally in your browser.

How it works

Weighted price index: Index = (∑ ownPrice·weight) / (∑ competitorPrice·weight) · 100.

If a row has no weight, the default weight is used (e.g. revenue or units as weight).

Traffic light: compare the index to your target index and check whether the deviation is within your tolerance (relative to the target index).

Top lists: compute a per‑SKU index (ownPrice/competitorPrice·100) and show the largest deviations above/below target.

Quick conclusion

  • A weighted price index is a quick benchmark for your price level vs competitors.
  • Top lists show which SKUs pull the index up/down (prioritization).
  • Next step: use revenue/units weights and define clear target-index corridors per country/channel.

Sources & notes

Disclaimer: assumptions, fees and policies can vary and change. Always verify critical values in official sources (marketplace, supplier, payment provider).

FAQ

What does an index of 100 mean?

100 means parity: on a weighted average you match the competitor price. 105 means ~5% above (weighted), 95 means ~5% below.

Which weights should I use?

Common choices are revenue, units, or sessions as a proxy. Weights only need to be correct relatively — absolute scale doesn’t matter as long as ratios are right.

How does tolerance work?

Tolerance defines a band around your target index. Example: target 100, tolerance 3% ⇒ 97–103. With target 110, tolerance 3% ⇒ 106.7–113.3.

Why are some rows skipped?

Rows are skipped when prices cannot be parsed as numbers or are ≤ 0 (or when weight is invalid/negative). Check decimal separators (comma/dot), header/column positions, and empty cells.

Do you store inputs?

No. Everything runs locally in your browser.

Turn it into a repricing rule in SnapTrade

If you want price index targets to become persistent guardrails/rules in your pricing system: SnapTrade can help.