Syntha Lab RU

Price monitoring by SKU: index to the market, position and price-scraping freshness

From a table of prices collected by scraping competitors calculates for each SKU the market median and minimum, your price index, your place among the competitors and the status against the corridor. Excludes stale data and SKUs with too few competitors from the total so that the index is not built on noise.

Working with stock: transfers, top-up, defects, prices, order entry For whom: Pricing and commercial directors, category managers, analysts.

Calculate on your data →

At a glance

What question does it answer?
Where our price stands against the market for each SKU and whether the parsing data can be trusted.
What data is needed?
By SKU: our price, the shelf prices of 1–3 competitors, the age of the data and optionally a weight (sales).
How to read the result?
On the example of 6 articles 3 are included in the total: two are excluded because of the age of the data (10 and 12 days against a limit of 7), one because of a single competitor. The simple price index is 97.6%, weighted by sales 94.3%. The “Hoodie” at 92.1% is below the ±5% corridor (we are the cheapest), the “Coat” at 104.0% is in the corridor. Example on the default values: SKUs monitored: 6; Included in the total: 3; Excluded: stale data: 2; Excluded: too few competitors: 1. The figures are illustrative: enter your own to see your result.

Why and how to reason

A price means nothing by itself: price relative to the market matters. The calculation builds a price index = our price ÷ median competitor price × 100. The median is used because one sharply underpriced or overpriced competitor should not shift the picture. Coat: our price 12,900, competitors 11,900, 13,500, 12,400, median 12,400, index 104.0: we are 4% above the market. Dress 5,900 against a median of 6,100 gives an index of 96.7; hoodie 3,500 against a median of 3,800 gives 92.1. But not all rows are usable. Scraped data older than the set age (7 days) or with fewer competitors than the minimum (2) is left out of the total: otherwise the index rests on noise. Of six items three entered the total, simple average 97.6, sales-weighted 94.3. The gap shows that fast sellers are cheaper than the market by more.

When to use it

It is useful when revising prices, before promotions and when assessing a brand’s position on marketplaces and in retail. It suits a brand and a retailer that scrape competitor prices. It does not suit non-comparable goods: the index compares analogs, not categories. Assumptions: competitor price excludes promotions and loyalty cards; comparison on the same sizes and colors; the corridor around the median is set by you.

How to read the result

First look at how many items entered the total and how many were excluded: if more than half are excluded the index is unreliable and scraping needs refreshing. Then compare the simple and weighted indices: the weighted shows position where you actually sell. Items below the corridor are a possible margin loss, above the corridor a possible sales loss. The “cheapest” position matters for fast-moving goods. The decision: raise the price where you are cheaper than the market and sell well, and check items above the corridor: is there a reason (brand, quality) that justifies it. It is worth recording conclusions per item and check after a week how demand reacted.

Common mistakes

Comparing goods of different quality and calling the index “position”. Taking competitor prices with promotions and treating them as permanent. Reacting to every fluctuation: marketplace prices change often, look at the trend over a period. Another trap: tracking the market minimum rather than the median: the lowest price often belongs to a clearance or a slow size.

What data is needed?

  • By SKU: our price, the shelf prices of 1–3 competitors, the age of the data and optionally a weight (sales).
  • The corridor around the median, the maximum age of the data, the minimum competitors in a row.

Inputs

FieldUnitValue in the exampleMeaning
Corridor around the market median%5An index within 100 ± this value counts as “in the corridor”. An example, not a standard: there is no single standard in Russia, enter your own threshold from your own data.
Maximum age of the scraped datadays7Rows older than this are left out of the total. An example: for fast-changing prices take less.
Minimum competitors in a rowpcs2With fewer competitors (comparable analogs) in a row the SKU is left out of the total.

How it is calculated

StepFormula
Price indexour price ÷ the median of competitors’ prices × 100
Place1 + the number of competitors whose price is below ours
Total indexthe average (or the sales-weighted average) of the indices of rows included

Worked numbers

Default values from the app; in the interactive version you enter your own.

Articles monitored
6
Included in the total
3
Excluded: stale data
2
Excluded: too few competitors
1
Price index to the market (simple average)
97.6 %100% means the price is at the competitors’ median.
Price index to the market (weighted by sales)
94.3 %
Below the corridor
1
Above the corridor
0
Share of articles where we are the cheapest
33.3 %
Most expensive relative to the market
104 % · Coat
Cheapest relative to the market
92.1 % · Hoodie

By article

ArticleOur priceMarket medianMarket minimumIndexPlaceStatusData age
Coat12,900 ₽12,400 ₽11,900 ₽104 %3 of 4In the corridor2 days
Dress5,900 ₽6,100 ₽5,600 ₽96.7 %2 of 4In the corridor3 days
Jeans4,900 ₽4,350 ₽4,200 ₽112.6 %3 of 3Stale data10 days
Hoodie3,500 ₽3,800 ₽3,700 ₽92.1 %1 of 4Below the corridor1 days
Jacket9,900 ₽9,400 ₽9,400 ₽105.3 %2 of 2Too few competitors4 days
Scarf1,500 ₽1,300 ₽1,200 ₽115.4 %4 of 4Stale data12 days

An index below 100 is not always a mistake: your brand may allow a different price level. Check against the elasticity and the article margin rather than aligning the price mechanically.

Parsing shows the price on a site, not the sales: allow for size availability, loyalty cards, promo codes and the comparability of the model. Check the collection of data from sites with a lawyer for conformity with the rules of those sites and with the laws.

Nuances and limits

  • Comparing incomparable models and prices on different bases (with and without a card, with and without VAT).
  • Reading a price below the market as a mistake: a brand may hold another level. Check data collection with a lawyer.

Terms used

Calculate on your data →