DEV Community

Public Rows
Public Rows

Posted on AI-assisted

Where your product ranks on Amazon, and what the category charges, as rows for $1 per 1,000

Checking where a product ranks on Amazon, or pricing a whole category, usually means opening dozens of search pages by hand and fighting the odd CAPTCHA. This turns an Amazon search into rows, one per result, with the ASIN, price, rating and badges Amazon shows on the page, from a licensed source.

Disclosure: I built the actor this uses. The rows come from Amazon through the licensed DataForSEO Merchant API; nothing is scraped, there are no CAPTCHAs to solve, and the output is product facts only, with no descriptions, images or reviews.

What you get

One row per result on the search page: rank (the absolute position), asin and title, price and price_to with the currency, rating and reviews_count, bought_past_month, the is_amazon_choice and is_best_seller badges, is_sponsored for paid placements, special_offers and delivery_message, and the product_url built from the ASIN. Ten Amazon marketplaces are covered.

What it costs

Item Price 1,000 products
Products $0.001 per product $1.00
First 20 products free −$0.02
Total about $1

Billing happens on your Apify account. The first 20 products of every run are free, so a first search costs nothing.

Steps

  1. Open Amazon Product Search on Apify and sign in or create a free Apify account.
  2. Write your searches in searches, one per line ("wireless earbuds", "stand mixer", a brand name). Each line is one search.
  3. Pick marketplace, and set location and language to match it: amazon.com pairs with United States and en_US, amazon.co.uk with United Kingdom and en_GB, amazon.de with Germany and de_DE, and so on across all ten marketplaces.
  4. Set maxPerSearch up to 700; each block of up to 100 results is one request to the supplier.
  5. Set maxItems and press Start.
  6. Download CSV, Excel or JSON, or schedule the same searches weekly to build a price and rank history. It is also an MCP tool through mcp.apify.com, so an agent can ask where a product sits on Amazon right now.

Things worth knowing

  • Sponsored placements are included in the results and flagged with is_sponsored; rank is the absolute position on the page, so a change in rank over time is a ranking change, not noise.
  • price is the lowest price shown for the result and price_to the top of a range; run it on a schedule if you want a price history rather than one snapshot.
  • marketplace, location and language must match each other; a mismatch, such as amazon.co.uk with United States, answers from the wrong country's results.
  • If the supplier is unreachable the run waits and retries for several minutes; if it still gets nothing, it fails with the reason and you are not charged.
  • You can bring your own DataForSEO credentials in the two optional inputs if you prefer the supplier charge on your own account; the row price stays the same.

If you try it and something feels off, open an issue on the actor page; I read them.

Top comments (0)