TheBinMap
Nationwide Liquidation Bin Store Directory
A 528-page nationwide directory of liquidation bin stores built solo, end-to-end, in under 10 weeks. Programmatic SEO architecture with zero runtime servers, zero API routes, and zero hosting costs.
The Problem
Bin stores — retail outlets selling Amazon returns and liquidation inventory at deep discounts — have proliferated across the United States. However, bin store information is fragmented across Google Maps, Facebook pages, and word-of-mouth forums.
- No centralized directory existed
- Shoppers cannot easily find stores, restock schedules, or pricing
- Store owners have no dedicated directory to drive foot traffic
- Five competitors have partial coverage, but none offer nationwide scope
The Solution
TheBinMap is a nationwide directory with structured restock data and programmatic SEO architecture, built from zero to 528 live pages using Astro SSG with a SQLite data layer queried at build time.
- 469 store detail pages with LocalBusiness schema
- 20 metro/city pages with ItemList schema
- 21 state pages with structured navigation
- 6 SEO-optimized educational guides
Verified Scale & Performance
528
Total Indexed Pages
456
Verified Stores
1,002
GSC Unique Queries
6.78
Top Position
Top Query Positions (Verified)
| Query | Impressions | Position |
|---|---|---|
| liquidation stores near me | 9 | 6.78 |
| bin store hendersonville tn | 20 | 8.35 |
| grey matter liquidation | 15 | 7.20 |
| palmary liquidation | 114 | 8.03 |
Metrics sourced from production Search Console exports. Verified as of June 2026.
Technical Stack
| Framework | Astro 5 (static site generation, zero JS by default) |
| Data Layer | SQLite via sql.js (build-time queries, no runtime DB) |
| Hosting | Cloudflare Pages (global CDN, 301 redirects, $0/month) |
| Maps | Leaflet (deferred via IntersectionObserver, zero cost on non-map pages) |
| Forms | Web3Forms (no backend required) |
| Scraper | Python — Google Places API with batch runs and rate limiting |
| LLM Enrichment | DeepSeek via OpenRouter (~$10 total LLM cost) |
| Schema.org | 6 types: Organization, WebSite, BreadcrumbList, LocalBusiness, FAQPage, Article, ItemList |
| Monetization | Amazon Associates, Keepa, Google AdSense |
Technical Challenges Solved
Amazon Infrastructure False Positives
Google Places returns Amazon Lockers, Counters, Fulfillment Centers alongside retail stores. A regex-based exclusion guard with Place type filtering caught 10–15% at ingestion, and a post-hoc audit removed 53 more missed listings.
Non-Durable Google Places Photo URLs
Google Places media URLs expire, returning broken images. Photos were suppressed from public pages as a short-term degraded-UX fix; a planned server-side image caching pipeline will provide permanent stable assets.
Zero-Budget Scaling
Every architectural decision prioritized zero recurring costs. Build-time SQLite queries eliminate runtime database hosting. Deferred Leaflet maps load only when scrolled into view. Cloudflare Pages provides global CDN on the free tier.
LLM Accuracy at Low Cost
Extracting operational data from unstructured review text required strict "return null don't guess" guardrails. DeepSeek via OpenRouter at ~$0.017 per listing with three-phase execution: test batch, bulk enrichment, and GSC-prioritized description generation.
Slide Deck
TheBinMap Video Storyboard
Complete visual storyboard and slide deck covering architecture, SEO strategy, and growth trajectory.
Download Slides (ODP)Screenshots
TheBinMap homepage with nationwide directory search and featured cities.
City page example — Louisville, KY store listings with map and structured data.
Individual store listing with LocalBusiness schema, hours, and map integration.
SEO-optimized educational guide — top-of-funnel content with Article schema.
Let's Build a Directory
Interested in a scalable directory, SEO content system, or programmatic architecture? Let's discuss how these capabilities apply to your project.