Ecommerce assortment price ladder calculator

Calculate product counts by declared price band and empty declared price bands with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use product counts by declared price band and empty declared price bands to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Price-band boundaries in one currency, all bands lower-inclusive and upper-exclusive (USD)
0,50,100,200
Products: unique SKU, price in same currency (USD)
A,25 B,50 C,150 D,250
Product counts by declared price band
0–50: 1; 50–100: 1; 100–200: 1
Empty declared price bands
None
SKUs outside all declared bands
D
Largest adjacent distinct-price gap
50→150; 150→250
Largest gap amount in that currency (USD)
$100.00

Try another scenario

Price-band boundaries in one currency, all bands lower-inclusive and upper-exclusive (USD)
0,50,100,200
Products: unique SKU, price in same currency (USD)
A,25 B,100 C,150 D,250
Product counts by declared price band
0–50: 1; 50–100: 0; 100–200: 2
Empty declared price bands
50–100
SKUs outside all declared bands
D
Largest adjacent distinct-price gap
150→250
Largest gap amount in that currency (USD)
$100.00
Calculation method

Calculation method

Product counts by declared price band

Count lower≤price<upper for every adjacent boundary pair.

Empty declared price bands

List bands with count zero.

SKUs outside all declared bands

Include prices below the first boundary or at/above the final boundary.

Largest adjacent distinct-price gap

Sort distinct prices and list every adjacent pair with the largest positive gap.

Largest gap amount in that currency (USD)

Maximum adjacent distinct-price difference, or zero when fewer than two distinct prices.

Symbols and units
a
Price-band boundaries in one currency, all bands lower-inclusive and upper-exclusive (USD)
b
Products: unique SKU, price in same currency (USD)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A price-distribution audit in one pre-normalized currency. Bands and gap comparisons are supplied business definitions, not pricing advice or a live market comparison.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

Google Merchant Center: product-data terminology and consistency background ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.