Competitor price analysis for webshops: model and example
How to run a price-based competitor analysis for your webshop, with a simple model, EAN matching, a price index and a worked example.
A competitor analysis for a webshop is mostly about prices in practice: who sells the same products as you, at what price, with what shipping, and whether they have the product in stock. This guide leaves brand, audiences and marketing aside and concentrates on the price-based competitor analysis, which you can use directly to set prices. You get a simple model, a template and a worked example.
Choose the competitors that actually matter
It is tempting to include everyone, but a competitor analysis is most useful when you stick to the shops your customers actually compare you with. These are typically:
- the shops listed next to you on PriceRunner and Prisjagt for your most important products
- the large generalists that sell many of the same products
- the specialist shops in your niche
- marketplaces, if your customers also shop there
Three to eight competitors are enough for most webshops. More gives you more data, but also more noise from shops that only overlap on a few products.
Compare identical products only
A price comparison is only useful if it compares the same product. Names vary from shop to shop, and the same model can come in several colours, sizes or bundles. The safest key is the EAN number, because it is the same for the same product whoever sells it. Where the EAN is missing, the manufacturer’s part number can be used, but the match then needs a manual check. The guide on why EAN matching beats name matching goes into more detail.
A wrong match is worse than no match. If you compare a 1-litre model with a 1.5-litre model, a competitor appears to be cheaper, and you may end up lowering your price for no reason.
A simple competitor analysis model
The model below can be built in a spreadsheet. One row per product and one column per competitor is enough to begin with.
| Column | Content |
|---|---|
| Product and EAN | Name and EAN number |
| Your price | Your current price including VAT |
| Competitor A, B, C | Their price including VAT |
| Shipping | Their shipping charge to the customer, if not free |
| Stock | Whether the competitor has the product in stock |
| Campaign | Whether the price is a time-limited campaign price |
| Index | 100 × your price ÷ their price |
The index shows your price position. An index of 100 means the same price, above 100 means you are more expensive, and below 100 means you are cheaper. The average index across all shared products is your price index against that competitor. The guide on how to read a price index explains the number in more depth.
A worked competitor analysis example
Example. Four products and three competitors. The prices are made up.
| Product | Your price | A | B | C |
|---|---|---|---|---|
| Coffee grinder | DKK 599 | DKK 579 | DKK 599 | DKK 649 |
| Electric kettle | DKK 349 | DKK 329 | DKK 359 | not sold |
| Milk frother | DKK 249 | DKK 249 | DKK 229 | DKK 239 |
| Espresso machine | DKK 2,499 | DKK 2,399 | not sold | DKK 2,599 |
The index per product and on average is shown below. The averages are calculated from the unrounded figures.
| Product | Index vs A | Index vs B | Index vs C |
|---|---|---|---|
| Coffee grinder | 103.5 | 100.0 | 92.3 |
| Electric kettle | 106.1 | 97.2 | – |
| Milk frother | 100.0 | 108.7 | 104.2 |
| Espresso machine | 104.2 | – | 96.2 |
| Average | 103.4 | 102.0 | 97.5 |
On these four products you are on average 3.4 % more expensive than A, 2.0 % more expensive than B and 2.5 % cheaper than C. The figures are only comparable on products you both sell, so the index against B and C is based on three products and not four.
Read the price together with stock, shipping and campaigns
The raw price does not tell the whole story, and the next three columns often change the conclusion.
Stock. B sells the milk frother for DKK 229 but does not have it in stock. A price the customer cannot buy at is not a real competitor today, and it should not pull your price down.
Shipping. A charges DKK 49 for shipping, while you ship free above DKK 499. For the coffee grinder the customer therefore pays 579 + 49 = DKK 628 at A against DKK 599 with you. Including shipping, your index against A on that product is 95.4, which makes you the cheapest rather than the most expensive.
Campaigns. A’s kettle at DKK 329 is a weekend campaign. If you follow it down, you are left with the low price when A returns to its regular price. Look at the competitor’s price over a period before you react to a single change.
Turn the analysis into a decision
A competitor analysis is only worth something if it ends in an action. Split the products into three groups:
- Products where you are the most expensive and the competitor has the product in stock with comparable shipping. Consider adjusting the price, as long as you stay above your minimum price.
- Products where you are the cheapest by a clear distance. There may be room to raise the price without losing your position.
- Products where the difference is due to stock, shipping or a short campaign. Keep an eye on them, but leave the price as it is.
Repeat the analysis regularly. Prices on PriceRunner and Prisjagt move every week, and an analysis from last month can point in the wrong direction. Corprice checks competitors’ prices daily from PriceRunner, Prisjagt and webshops, matches on EAN and shows a price index per competitor. Read more on the competitor analysis page.
If you need to set limits first, the guide on setting a minimum price from your cost price shows how far down you can go, and the guide to pricing strategies helps you choose how to position yourself against competitors.