Wine-Searcher Pricing Scraper
Overview
An automated Python scraper that collects wine names, providers, and prices from Wine-Searcher and identifies the cheapest provider for each wine. Human-like browsing behavior is simulated to avoid detection, and a fresh comparison sheet is produced every four hours. Outcome: Delivered a reliable lowest-price-per-wine report that the client uses to drive sourcing decisions, with no manual lookups required.
Architecture & Pipeline
flowchart LR
n0["Scheduler (4 h)Recurring runs"]
n1["Wine-SearcherSource site"]
n2["Anti-Detection BrowseHuman-like behavior"]
n3["Per-Wine Cheapest ProviderCross-provider compare"]
n4["Spreadsheet BuilderPandas"]
n5["Email / Drive DeliveryClient report"]
n0 --> n1
n1 --> n2
n2 --> n3
n3 --> n4
n4 --> n5
classDef step0 fill:#f1f5f9,stroke:#64748b,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step1 fill:#ecfeff,stroke:#06b6d4,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step2 fill:#f0fdfa,stroke:#0d9488,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step3 fill:#ecfdf5,stroke:#10b981,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step4 fill:#fffbeb,stroke:#f59e0b,color:#1e293b,stroke-width:2px,rx:10,ry:10;
class n0 step0;
class n1 step1;
class n2 step2;
class n3 step2;
class n4 step3;
class n5 step4;
End-to-end flow derived from this project's scope and tech stack. Tap View Fullscreen for a larger view, or scroll horizontally on small screens.
Key Features
- Cross-provider price comparison per wine
- Anti-detection techniques to handle bot mitigation
- Scheduled runs with automated email/file-sharing delivery
- Structured spreadsheet output ready for analysis
- Tech Stack:** Python, Selenium, BeautifulSoup, Requests, Pandas