eCommerce Link Builder

Features

• DataForSEO SERP API integration (Google organic, live advanced endpoint)
• Position 1 filtering (top result only)
• URL depth calculation to exclude homepages
• Any country and language via location and language code constants
• Configurable 'Stockists' query suffix
• Built-in rate limiting (1s delay between requests)
• Estimated API cost printed before the run
• Deduplicates results by URL

How to use

1. 1 Create brands.txt with brand names you stock (one per line)
2. 2 Set DataForSEO credentials via environment variables or the script constants
3. 3 Set the location and language code constants if needed
4. 4 Run the script to query '[Brand] Stockists' for each brand
5. 5 Review filtered results (position 1, non-homepage URLs, deduplicated)
6. 6 Results save automatically to brand_links_output.csv (query, URL, title, description)

Frequently asked questions

Why do some of my brands return no results at all?

Two filters remove results silently. Only the position 1 organic result for each '[Brand] Stockists' search is kept, so a stockist page ranking second yields nothing for that brand. Any URL with a depth of exactly 2 slashes (a bare homepage such as https://brand.com) is also removed, so if the top result is the brand's homepage the brand disappears from the output. Duplicated URLs across brands are then deduplicated, keeping the first.

What does it cost to run?

The script uses the paid DataForSEO SERP API and makes exactly one search request per brand in brands.txt, with a 1 second sleep between requests. Usage therefore scales linearly with the number of brands, and the script prints an estimated cost (at $0.002 per query) before it starts.

How do I set it up and change the target country?

Credentials come from the DATAFORSEO_LOGIN and DATAFORSEO_PASSWORD environment variables, or the matching constants at the top of the script (they ship as placeholders). Put one brand per line in a brands.txt file in the same folder. Country and language are set via the LOCATION_CODE and LANGUAGE_CODE constants; UK (2826) and US (2840) codes are included, and any DataForSEO location code works. The 'Stockists' suffix is also a constant (STOCKISTS_SUFFIX) so you can switch to 'Dealers', 'Where to buy' and so on.

Why is a non-stockist page in my results?

The script trusts Google's top result for the query and applies no content check, so any page that happens to rank 1 for '[Brand] Stockists' gets through as long as it is not a homepage. Results with a missing URL, title or description are dropped, but relevance still needs a manual review pass of the output CSV (brand_links_output.csv, UTF-8 with BOM).