E-commerce Price Monitoring: A Step-by-Step Playbook (With Real Walmart TV Prices)
A price monitoring service is only as useful as the questions you ask of the data. Most teams start by collecting "all the prices" and end up with a spreadsheet nobody trusts. This playbook goes the other way: decide what to compare, collect only the fields that answer it, and refresh on a schedule that matches how fast prices move.
To keep it concrete, we use a real example. We collected 95 TV listings from Walmart.com US search results and put them in a free CSV: the Walmart TV Prices dataset. Every number below comes from that file.
Step 1: Define the comparison before you collect anything
Competitor price monitoring fails when the unit of comparison is vague. A "TV" is not one product. A 32-inch set and a 75-inch set sit in different markets. So the first decision is the comparison key.
For TVs, three keys do most of the work:
- Brand: who is priced above or below whom.
- Screen size band: the strongest single driver of price.
- Condition: new, open box or restored. Mixing these corrupts any average.
Write these down first. Everything else in the data model follows.
Step 2: Choose the fields that matter
Our sample has 13 columns. These are the ones that earn their place in a price tracking data model:
| Field | Why it matters |
|---|---|
product_id |
Stable key for tracking one item across days |
price and was_price |
Current price and the previous price Walmart shows |
savings |
Discount depth in dollars, derived from the two prices |
brand, screen_size_in |
The comparison keys from Step 1 |
seller |
Separates Walmart-sold items from marketplace sellers |
open_box |
Flags condition so it can be analysed separately |
rating, review_count |
Demand and quality signals next to price |
The product_id deserves special attention. Titles change, and sellers edit them. The ID does not, so it is the key for any time series.
What our Walmart sample shows
Here is what the 95 listings say once you apply the keys above.
The market is cheap in the middle and stretched at the top. The median price is $248, but the average is $532.60. A handful of very large sets pull the mean up; the most expensive listing is a 115-inch TCL at $13,998. If you report only averages, you misdescribe the shelf. Report medians next to them.
Screen size drives price. Average price by size band:
| Size band | Listings | Average price | Median price |
|---|---|---|---|
| 32 in and under | 16 | $111.75 | $120.99 |
| 40–43 in | 17 | $187.19 | $193.99 |
| 50–55 in | 19 | $247.84 | $248.00 |
| 58–65 in | 18 | $490.16 | $353.00 |
| 70 in and over | 24 | $1,333.96 | $538.00 |
Notice how the 70+ band has a median of $538 but an average above $1,300. Extreme listings distort that band more than any other.
About one in four listings shows a markdown. 25 of 95 listings (26.3%) carry a previous price. For those, the average saving is $110.91, or roughly 19.2% off the previous price. The deepest cut in the sample is an LG listing at $1,399.99, down from $2,699.99.
Brands sit in different price tiers. VIZIO has the most listings among the big names after TCL, and Samsung and TCL show the widest spread:
| Brand | Listings | Average price | Median price | Listings with a previous price |
|---|---|---|---|---|
| TCL | 17 | $1,109.29 | $268.00 | 1 |
| VIZIO | 16 | $355.18 | $237.00 | 5 |
| Samsung | 15 | $766.13 | $378.00 | 5 |
| Hisense | 11 | $307.27 | $284.00 | 3 |
| LG | 9 | $622.89 | $448.00 | 3 |
TCL's average is more than four times its median because of the 115-inch outlier and other very large sets. This is a good example of why brand comparisons should be done inside a size band.
Open-box units are priced low, but be careful with the comparison. Five listings are marked open box. Their average price is $172.19, against $552.62 for the rest. That gap is mostly a size effect, not a pure discount, because the open-box units are small and mid-size sets. A fair read needs a like-for-like match. For example, an open-box VIZIO 50-inch is listed at $219 with a previous price of $268. Only two of the five open-box rows show a previous price at all.
Most listings are sold by Walmart; a minority are third-party. 83 of 95 listings come from Walmart's own seller names, and 12 from marketplace sellers. The third-party group averages $653.50 versus $515.12 for Walmart-sold items, but with only 12 rows we would not draw a conclusion from that. It is a reason to track seller as a field, not a finding.
Ratings are high and reviews are concentrated. The average rating is 4.32. The median listing has 3,926 reviews, and the most reviewed has 55,408. Ratings barely separate products here, so review count is the more useful popularity signal.
Here is an excerpt from the CSV:
| product_id | brand | screen_size_in | price | was_price | seller |
|---|---|---|---|---|---|
| 14574454877 | TCL | 43 | 218 | Walmart.com | |
| 18211860310 | Samsung | 65 | 428 | 477.99 | Walmart.com |
| 17942205635 | onn | 32 | 60 | 68 | Walmart |
| 14319716143 | LG | 32 | 138 | Walmart.com | |
| 18028408201 | VIZIO | 65 | 246 | Walmart |
The full file is on the dataset page. For a second category from the same retailer, see our earlier Walmart laptop sample, and our Walmart product data guide.
Step 3: Set up daily tracking
A snapshot is a report. A time series is monitoring. To turn the sample into the second one:
- Fix the query. Keep the search term, category and delivery location constant. Walmart prices and availability can vary by store, so pin a ZIP code.
- Collect on a schedule. Run the same collection once per day at a consistent time.
- Key every row by
product_idand date. Append, never overwrite. - Compute changes, not just levels. Day-over-day price change, new markdowns, items that disappeared, and items that came back.
- Alert on thresholds. For example, a competitor's price in your size band dropping below yours.
For TVs, daily is a sensible default. Promotions cluster around events and weekends, and a weekly snapshot will miss short markdowns. For slow categories, weekly is enough.
Use cases
- Repricing: match or beat a competitor inside the same brand and size band.
- Assortment gaps: spot size bands where a retailer has many listings and you have none.
- Promotion tracking: measure how often and how deeply a rival discounts.
- Marketplace oversight: watch third-party sellers listing your brand.
- Analyst reporting: build ecommerce price intelligence for category reviews.
If you also watch other retailers, our write-ups on Best Buy electronics data and an Amazon electronics case study show how the same approach carries across stores.
Common challenges
Anti-bot measures. Large retailers detect automated traffic. Reliable collection needs managed infrastructure that handles rotation and rendering, not a script on a laptop.
Pagination. Search results span many pages, and a page can include sponsored items. We deduplicated by product_id to reach a clean set.
Layout and field changes. Retailers change markup and field names. Monitoring needs checks that fail loudly when a column goes empty.
Data quality. Brand and size usually have to be parsed from titles. Titles include marketing text, and some say "Powered by" another brand, so rules need review. Condition flags such as "Open Box" or "Restored" must be captured, or averages mislead.
Previous prices are not always real baselines. A was_price is what the retailer shows. Treat it as a signal, and compare against your own history.
Which tool to use
You can build collection in-house, buy a SaaS tracker, or use a managed price monitoring service. In-house gives control but needs ongoing maintenance. SaaS is fast to start but limited to its fields. A managed service delivers the dataset you define, so your team spends time on analysis. Our datasets start from $49; see pricing.
FAQ
How often should I refresh price tracking data? Daily for fast-moving categories such as electronics. Weekly is enough for stable categories.
Should I use averages or medians? Both, but lead with medians. In our sample the average price is $532.60 and the median is $248.
How do I compare open-box prices fairly? Match brand and screen size to a new unit, and keep open-box rows in a separate segment.
Is collecting public prices allowed? We only collect publicly visible product information, with no personal data and no pages behind a login. Check the rules for your own use case.
Get your own sample
If you want competitor price monitoring for your own products, request a free sample of your own target and we will return a CSV like the one above.
Author: DataHarbor Team