How to monitor competitor prices without maintaining a spreadsheet

Most small stores start the same way: a spreadsheet with a column of product names, a column of competitor prices typed in by hand, and a growing sense that it is out of date the moment it is saved. Here is how to do it properly, whether you use a tool or not.

1. Pick the competitors that actually overlap

The most useful competitor is not the biggest one. It is the store a shopper would compare you with: it sells many of the same products, ships to the same places and is priced in the same currency. Start with three to five. More than that produces noise before it produces insight.

2. Watch the products that matter

You do not need every product. Start with:

• your best sellers, because a price gap there costs the most;
• products you share with competitors, since only those can be compared;
• products where you are the cheapest by a wide margin, which may be margin you are giving away.

3. Record more than the price

A price alone can mislead. For each product, record:

• the current price and the "compare at" price, to tell a sale from a regular price;
• whether it is in stock, because an out-of-stock rival price is not a real option for shoppers;
• the date, so you can see changes over time instead of a snapshot;
• which variant or pack size the price belongs to.

4. Choose a sensible frequency

Daily is right for fast-moving categories such as electronics or anything sold on marketplaces. Weekly is plenty for stable catalogs. Checking more often than prices actually change only creates alerts you will learn to ignore.

5. Know the mistakes that corrupt the data

• Comparing different packs. A single item against a 5-pack looks like a huge price gap. It is not one.
• Comparing the lowest variant. Many stores show "from $X", which is the cheapest size or option, not the one you sell.
• Ignoring shipping and currency. A lower sticker price with expensive shipping, or a price in another currency, is not an undercut.
• Matching by title alone. Similar names are not always the same product. Prefer SKUs, barcodes or catalog IDs where they exist.

6. Turn it into a decision

Looking at prices is only useful if it changes something. A simple routine is to review the products where a competitor is more than a set percentage below you, decide for each whether to match, hold or explain the difference, and write the rule down so next week's review is faster.

Where a tool helps

The slow parts of a spreadsheet are collecting the prices and matching products across stores. That is what Tensorbasis automates: it reads the catalogs of the stores you pick, matches the overlapping products, tracks changes and emails you when something moves. You still make the pricing decisions.