Google Shopping Price Comparison via DataForSEO API
Budget: $250 – $750 USD
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
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