A price tracker should explain comparable offers over time, not encourage automatic undercutting. Prices differ because bundles, variants, delivery, warranty, seller reputation and campaign terms differ. Normalize those facts before asking AI for a pattern.
Capture Comparable Observations
Use one row per dated observation:
capture_date | listing_id | url | seller | sku_equivalent | quantity
variant | displayed_price | shipping | voucher_condition | normalized_unit_price
placement | stock_note | warranty | notes | checked_by
Keep formulas transparent. normalized_unit_price = (displayed price + unavoidable shipping - universally applicable discount) / quantity. Conditional vouchers stay in their own field; do not subtract a discount most buyers cannot use.
Google Sheets can flag changes and create pivot views. AI can summarize supplied rows, but require listing IDs and dates for every observation. Never ask it to scrape accounts or bypass platform controls.
Worked Example
Three sellers appear to price storage jars at PKR 1,399, 1,599 and 1,850. Normalization shows the first is a four-pack, the second a six-pack with shipping, and the third a six-pack with thicker material and warranty language. The cheapest displayed price is not the cheapest equivalent unit.
After four weekly captures, the tracker shows campaign discounts that reverse afterward. The business decides not to chase each change. It sets a sustainable floor, monitors position, and tests whether clearer quantity and material information supports its price.
Turn the Tracker Into a Decision Log
Add decision, reason, approved_by, effective_date and review_date. Most observations should produce “no change.” If you do change price, write the hypothesis first—for example, clearer bundle value at the current price versus a lower price—and keep a baseline. The tracker then explains why a decision happened instead of becoming a colorful archive.
Failure Cases to Diagnose
- Tracking screenshots without dates or URLs.
- Comparing different quantities or specifications.
- Treating conditional vouchers as universal prices.
- Auto-lowering price whenever a competitor changes.
- Storing competitor or platform credentials in a script or sheet.
🇵🇰 Pakistan Angle
Separate imported-input price changes, currency effects, campaign subsidies and city-specific delivery. A sustainable Pakistani seller may need a higher price than an informal competitor who has omitted packaging, tax, returns or warranty costs.
Hands-On Exercise
- Select five genuinely comparable listings.
- Capture them on three dates.
- Normalize bundle and unavoidable shipping differences.
- Ask AI for row-cited patterns and verify each.
- Set a pricing review rule that does not auto-undercut.
Completion Rubric
- Every price has URL, date and offer conditions.
- Quantities and specifications are normalized.
- Conditional discounts remain visible.
- AI output cites supplied rows.
- Price decisions respect a documented floor.
Sources
- Google Sheets Help — Create and use pivot tables
- Shopify Help Center — Product pricing
- Daraz Pakistan — Marketplace Agreement and commission terms
Key takeaway: Track comparable value over time; do not automate a race to the lowest displayed number.