In fashion reselling, prices shift daily. A competitor might undercut you overnight, or a rare item could spike because of a celebrity sighting. A Fishgoo spreadsheet for price tracking keeps your finger on the pulse so you never sell too cheap or hold too long.
Why Price Tracking Separates Casual Sellers from Pros
Most resellers set a price once and forget it. But dynamic pricing based on real market data can increase revenue by 15-25%. When you track competitor prices, historical sell-through rates, and demand signals in one Fishgoo sheet, you gain the confidence to adjust prices proactively instead of reactively.
Price Tracker Columns You Need
| Column | Purpose | Data Type |
|---|---|---|
| SKU | Link to inventory | Text |
| Listed Price | Your current ask | Currency |
| Avg Market Price | 12-week average | Currency |
| Lowest Comp | Cheapest competitor | Currency |
| Highest Comp | Premium listing | Currency |
| Sell-Through Rate | % sold in 30 days | Percentage |
| Suggested Price | Auto-calculated | Formula |
| Last Updated | When data refreshed | Date |
The Dynamic Pricing Formula
Use a simple formula to suggest your next price based on market positioning:
Suggested Price = ((Avg Market + Lowest Comp) / 2) * (1 + (Sell-Through Rate / 100))
If an item sells fast, the formula nudges your price upward. If competition is fierce and sell-through is low, it pulls your price closer to the market floor. You stay competitive without racing to the bottom.
Need inventory to start tracking prices?
Find Fashion InventoryPrice Tracking Best Practices
- Update competitor prices weekly, not daily, to avoid overreacting to temporary sales.
- Flag SKUs with sell-through rates over 80% as candidates for a price increase.
- Keep a "Price History" log to see how an item's value trended over six months.
- Never price below your break-even; use the Fishgoo profit margin column as a guardrail.
Frequently Asked Questions
How do I find competitor pricing data?
Manually check 3-5 top listings on marketplaces where you sell. Record the range in your tracker. For volume, consider browser extensions that batch-scrape pricing.
Should I always match the lowest competitor?
No. Undercutting destroys margin. Position in the middle or top third if your photos, description, and shipping are stronger.
Conclusion
Price tracking is not about being the cheapest; it is about being the smartest. A dedicated Fishgoo spreadsheet tab for pricing gives you the data to make confident, profitable decisions every time you list an item.