eCommerce Link Builder

Features

• ValueSERP API integration for SERP scraping
• Position 1 filtering (top result only)
• URL depth calculation to exclude homepages
• Any Google domain, country and language via script constants
• Configurable 'Stockists' query suffix
• Built-in rate limiting (1s delay between requests)
• Deduplicates results by URL

How to use

1. 1 Create brands.txt with brand names you stock (one per line)
2. 2 Paste your ValueSERP API key into the script constants
3. 3 Set the Google domain, country and language 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 ValueSERP 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: 200 brands is 200 API credits.

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

Everything is configured as constants at the top of the script: paste your key into VALUESERP_API_KEY (it ships as 'your-key-here'), and put one brand per line in a brands.txt file in the same folder. Country is set via GOOGLE_DOMAIN, COUNTRY_CODE and LANGUAGE; the comments show UK, US, Canada and Australia examples but any Google domain and gl/hl pair 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).