Why Your Competitor Price Spreadsheet Stopped Working

You probably started the same way everyone does. A new Google Sheet. A few columns: competitor name, product, their price, your price, date checked. Maybe a conditional formatting rule to highlight anything more than 10% off.

For a while, it worked. You checked a handful of competitors once a week, updated the cells, and had a rough sense of where you stood.

Then it stopped working. Not all at once, but gradually. The spreadsheet got wider, the tabs multiplied, the person updating it got busier, and the data inside got older. By the time you looked at a row and asked "is this still accurate?" you already knew the answer: probably not.

If this sounds familiar, you are not doing anything wrong. You are running into a fundamental limitation of spreadsheet-based competitor monitoring. Spreadsheets are excellent general-purpose tools, but they were never designed for tracking fast-moving ecommerce data across dozens of stores and thousands of SKUs.

This article explains exactly why competitor price spreadsheets fail, what that failure costs your business, and what the alternative looks like in practice.

The snapshot problem

A spreadsheet captures a snapshot. Someone visits a competitor's site, writes down a number, and moves on. That number was accurate at the moment it was recorded. Five minutes later, it may not be.

Ecommerce prices change constantly. Flash sales start on Tuesday mornings. Prices adjust automatically based on inventory levels. Competitors run weekend promotions that end before your Monday review. Compare-at prices shift when sale windows open and close.

A weekly spreadsheet update gives you 52 snapshots per year. A competitor who changes prices twice a week creates 104 data points you are missing. The spreadsheet does not just get stale; it creates a false sense of knowledge. You think you know what your competitor charges because you have a number in a cell. But that number may be days or weeks old, and the competitor may have changed direction since you last checked.

The real cost is not missing a single price change. It is making decisions based on data you believe is current but is not.

Coverage shrinks as catalogs grow

When you have 50 products and three competitors, a spreadsheet can plausibly cover your competitive landscape. You are tracking 150 price points. That is an hour of focused work per week.

Scale that to 500 products and eight competitors. Now you are looking at 4,000 price points. Nobody is checking all of those. Instead, the person updating the spreadsheet naturally gravitates toward the same familiar products and competitors every time.

The result is coverage bias. You know a lot about a narrow slice of your competitive landscape and almost nothing about the rest. New competitor products get missed. Category expansions go unnoticed. Pricing shifts in segments you do not actively watch happen without your knowledge.

This is not a discipline problem. It is a capacity problem. Manual monitoring cannot scale linearly with the number of products and competitors you need to watch. At some point, every team doing this by hand hits a ceiling where the time required to maintain the spreadsheet exceeds the time available.

You lose everything that is not a price

Spreadsheets are built for numbers, and the most obvious number to track is price. But price is only one of the signals that matter in competitive ecommerce. When you reduce competitor monitoring to a price column, you lose visibility into:

Inventory signals. When a competitor restocks a previously sold-out product, that often precedes a promotional push. When they run out of stock on a product you both carry, you have a temporary window where their demand may shift to you. A spreadsheet does not track these events because nobody thinks to add an "in stock?" column, and even if they do, nobody checks it consistently.

Catalog changes. Competitors adding new products signals category expansion. Competitors removing products signals contraction or strategic repositioning. A spreadsheet tracks existing products; it does not tell you about products that appeared or disappeared since your last check.

Sale and promotion state. A price of $39.99 means something very different depending on whether it is the regular price, a temporary sale price, or a clearance price. Without tracking the compare-at price, sale status, and timing, you cannot distinguish between a permanent price cut and a weekend flash sale. Your response to each should be completely different, but the spreadsheet shows you the same number either way.

Timing and velocity. How fast is a competitor changing prices? Are they adjusting weekly, daily, or multiple times per day? A spreadsheet gives you point-in-time values but no sense of how rapidly the landscape is moving. A competitor who changed prices 12 times in the last month is telling you something different from one who has not changed prices in six months. The spreadsheet treats both the same.

The person problem

Every spreadsheet-based monitoring process has a single point of failure: the person who updates it.

When that person is engaged and has time, the spreadsheet works. When they go on vacation, get pulled into a product launch, or leave the company, the monitoring process dies. This is not speculation; it is the most common way competitor monitoring breaks down in practice.

Even when the person is present and diligent, human checking introduces variability. Different people notice different things. The same person checks more carefully on some days than others. Nobody is perfectly consistent at a repetitive manual task performed dozens of times per week.

The spreadsheet also does not alert you when something important changes. It sits there passively, waiting for someone to open it, update it, and interpret it. If your competitor drops prices by 20% on a Thursday and nobody checks the spreadsheet until Monday, you have lost four days of response time. In fast-moving categories, that is enough for customer perception to shift.

What changes when you stop relying on snapshots

The alternative to a spreadsheet is not a better spreadsheet. It is a different kind of system: one that watches your competitors continuously and tells you when something changes, rather than waiting for you to check.

The shift from snapshot monitoring to signal-based monitoring changes several things at once:

You see changes as they happen, not days later. Instead of a stale number in a cell, you get a notification or a feed entry showing that a specific product at a specific competitor changed from one price to another at a specific time. You know what changed, when, and by how much.

Coverage stops being a function of your team's time. An automated system monitors every product at every competitor you watch, every cycle. The tenth competitor gets the same attention as the first. The five-hundredth product is tracked as consistently as the first. Scale stops being the bottleneck.

You track more than price. A monitoring system that watches product catalogs can detect restocks, out-of-stock events, new product launches, product removals, sale-start and sale-end events, and other signals that a spreadsheet is structurally incapable of capturing.

History accumulates automatically. Instead of asking "what was this price last month?" and finding an empty or outdated cell, you have a complete history of every price that product has ever had. Patterns become visible. Trends emerge. You can see whether a competitor's pricing strategy is shifting over time, not just where they are right now.

The process survives personnel changes. Because the system does the checking, the monitoring does not stop when someone goes on vacation, changes roles, or leaves the company. The institutional knowledge of "what are our competitors doing?" stops being stored in one person's head and one person's spreadsheet.

When it is time to make the switch

Not every team needs to abandon their spreadsheet today. If you are watching two competitors and 30 products, a well-maintained spreadsheet may be fine for now. The transition point usually comes when one of these is true:

• You have stopped updating the spreadsheet regularly and the data is visibly stale
• Your competitive landscape has grown beyond what one person can realistically track
• You have missed a significant price change or competitor move because nobody checked in time
• You are spending more than two hours per week on manual competitor checking
• A team member who owned the process has left and nobody has picked it up
• You find yourself making pricing decisions and realizing afterward that a competitor had already moved

Any one of these is a signal that spreadsheet monitoring has hit its natural limit for your operation.

What to look for in a monitoring tool

If you decide to move beyond the spreadsheet, the tool you choose should do a few things well:

• Automated store monitoring. Add a competitor store once and the tool watches it continuously, without you needing to visit the site or update any cells.
• Change detection across signal types. Price drops, price increases, restocks, out-of-stock events, new products, and product removals should all be tracked, not just price.
• History and context. Every product should have a price history so you can see trends, not just snapshots.
• Alerts that filter noise. You do not want a notification for every $0.10 fluctuation. Good alerting lets you set thresholds so you only hear about changes that are worth acting on.
• Multi-platform support. Your competitors are probably not all on the same platform. The tool should work across Shopify, WooCommerce, BigCommerce, and other ecommerce platforms.

Bonesaw was built specifically for ecommerce operators making this transition. It watches competitor stores, detects changes across all the signal types above, and gives you a feed of meaningful changes instead of a static spreadsheet you have to maintain yourself. You can set up alerts that tell you when something worth responding to happens, and review your competitive landscape weekly without spending hours on manual checking. Bonesaw monitors publicly accessible storefront pages and does not access private customer data.

The spreadsheet was the right starting point. It just was not designed to be the long-term solution.

Start small

If your spreadsheet is already showing cracks, you do not need to replace everything at once. Start with the competitors and products that matter most. Add your top three competitors to an automated monitoring tool and see what you have been missing. Most operators are surprised by how many changes they were not seeing.

The goal is not to track everything. It is to stop missing the changes that actually affect your business.

Frequently Asked Questions

When is a spreadsheet still fine for competitor monitoring?

A spreadsheet is workable if you watch fewer than three competitors, track under 50 products, and have a dedicated person updating it weekly. Past that, coverage drops fast. The test is simple: if you cannot confidently say when your top competitor last changed price on your best-selling product, the spreadsheet has stopped working.

How often do competitor prices actually change?

It depends on the category, but most ecommerce operators underestimate change frequency. Active competitors often adjust prices on popular SKUs weekly or even daily during promotional periods. Subtle compare-at and sale-state changes happen even more frequently. A once-a-week spreadsheet review misses most of these events.

What is the real difference between a spreadsheet and a monitoring tool?

A spreadsheet records what someone saw at a moment in time. A monitoring tool watches continuously and notifies you when something changes. The first produces snapshots; the second produces a timeline. The practical difference shows up when a competitor drops price on a Thursday and you need to decide whether to respond before the weekend.

Do I need to abandon my spreadsheet to switch to a monitoring tool?

No. Many operators keep a lightweight internal spreadsheet for strategic notes and let an automated tool handle the data collection. The point is to stop using the spreadsheet as the source of truth for current competitor prices, because it cannot be current at the scale most operators need.

What happens to my historical data if I switch tools?

The historical snapshots in your existing spreadsheet remain useful as a baseline, but going forward the monitoring tool accumulates its own history automatically. After a few weeks of continuous monitoring, the tool's history becomes more complete and more accurate than anything a manual process produced.

---

Stop maintaining your competitor spreadsheet

Bonesaw monitors competitor prices, restocks, new products, and catalog changes automatically. Replace your spreadsheet with a feed of the changes that matter.

Get started free · Learn more