We’re looking for an experienced Python developer familiar with the DataForSEO Merchant (Google Shopping) API to build an automated price comparison tool. The goal is to compare our own product prices with competitor prices listed on Google Shopping. We already have a working API account, credentials, and a functioning local Python environment. You’ll have full freedom to define the structure, libraries, and logic — as long as the script runs locally on Windows (Python 3.x). Task Objectives Create a Python script that: Reads input from a CSV file (example attached) containing columns such as: sku, ean, product_name, color, cost_price, my_price For each product: - Uses the DataForSEO Merchant Google API to search for the product on Dutch Google Shopping / Merchant (country NL, language EN) Fetches detailed product data including seller names and prices - Produces an output CSV file comparing our own price with competitors, including: sku, ean, product_name, my_price, cheapest_seller_name, cheapest_seller_price, second_seller_name, second_seller_price, avg_top3_price, price_difference - Handles API limits, timeouts, and 404s gracefully - Includes clear logging (print or log file) showing progress and any skipped items - Saves intermediate data (so we can resume where it left off if interrupted) Technical Requirements - Must use DataForSEO - Should be executable locally (Windows) - Please use your own .env or configuration method for API credentials - We will attach a small example CSV for testing If your solution requires slightly different input columns, please let us know — we can easily adapt our CSV format. Deliverables One or more working Python scripts that: - Perform batch comparison using the DataForSEO API - Generate a final CSV with competitor price data Basic README file explaining: - How to set up and run the script locally - How to configure the API credentials Clean, readable code with minimal dependencies Any questions let me know