Ecommerce Data API Blog
Blog
Hands-on API workflows and AI agent recipes for ecommerce sellers.
Building an Amazon data report: if it cannot be compared to last week, it is not a report
Reports go unread not because they lack detail but because they cannot be set beside the previous one. The three things that must stay fixed, a minimum report structure, and three habits that void a report.
Five decisions to settle before you integrate an Amazon data API
The docs cover how to send a request. This covers what to settle before you send one, including the rule people trip over most: RPM, concurrency and credits aggregate per account, so extra API keys buy no extra quota.
Amazon ASIN reverse keyword lookup: what one request returns and how to read it
Passing an ASIN to get its keywords sounds simple, but what comes back is not "every relevant term". This covers what the lookup actually measures, the pagination ceiling, how to read the rank fields, and three common misreadings.
Amazon category analysis: four distributions decide whether you can still get in
A big category total does not mean a share of it is available to you. Listing age, seller type and price distributions, plus one statistics call, read the competitive structure — above all whether new listings still have room.
Amazon competitor analysis: the comparison table is useless, the difference is not
A side-by-side competitor table rarely produces an action. Four angles that do — keyword difference, dual-placement waste, unmet demand in negative reviews, variation structure — plus one number you can compute directly.
An Amazon Competitor Analysis Template That Ends in Actions
A downloadable competitor sheet that keeps what you observed, what you think it means, and what you will do in three separate columns — plus how to pick rivals and keep the rows comparable.
Amazon Data Analysis: Facts vs Estimates vs Judgment
Price, BSR and rating counts are published facts; monthly sales, revenue and market size are estimates. Which is which, what each can support, and which data answers which question.
Choosing an Amazon Data API: SP-API, Third-Party Endpoints and Scraping
Three things go by the name "Amazon API" and they solve different problems. What each one can and cannot return, and the most common misjudgement: expecting SP-API to show you a competitor.
Where Amazon data comes from: why there is no single "Amazon database"
People searching for a database want a dataset to download. Data splits along authorization boundaries into three blocks, and it is a stream rather than a store. A map of what exists, how fast each field goes stale, and whether you can keep a copy.
How to optimize Amazon keywords: sort them into four conversion classes
Keyword optimization is not stuffing words into a title. Your listing already gets impressions for a set of terms, and optimizing means classifying that set — which to defend, which to investigate, which to stop paying for.
Monitoring Amazon keyword rank: three layers, summary first and drill down after
Monitoring is not storing the rank of two thousand terms daily. The division of labour between summary, per-term and market layers, a way to compute dual-placement terms from three numbers, and what to rule out before blaming your listing.
Amazon Market Analysis: Where the Market Size Number Comes From
Market size is the least reliable number in the dataset — it rests on a head sample and two layers of estimation. This post opens up how it is computed, the unit trap in ratio fields, and how to read share properly.
Choosing Amazon negative keywords: three sources and one line you should not cross too early
Negatives are not about deleting terms. They move budget away from positions that will not convert. Three classes safe to negate, what each looks like in the data, and when negating does damage.
Amazon PPC keyword bidding: why one term comes back with 36 numbers
Asking what to bid on a term expects one number. The endpoint returns 36 — three match types, each with a bid, CPA, budget and ACOS, and each of those a range rather than a point. How to read them.
Choosing Amazon PPC keywords: exclude three kinds first, then read four competition fields
Picking ad keywords is not picking SEO keywords. SEO needs relevance and volume; advertising also needs terms you can afford to win. The three kinds to exclude first, and the four fields that actually decide it.
How to Find Products to Sell on Amazon: Eliminate Before You Discover
How to find products to sell on Amazon starts with removing them, not finding them. Four elimination layers, what data each one uses, and why reversing the order throws away everything you did before it.
An Amazon Product Research Template That Makes Two Sheets Comparable
A downloadable product research sheet that fixes the marketplace, the collection date, and which numbers are estimates — plus the field mapping for when filling it in by hand stops scaling.
Amazon Product Research Tools: 3 Types + a Test Checklist
Most product research tools draw on similar data; what differs is how much they decide for you behind an "opportunity score". Compare the three tool types, run an acceptance checklist, or skip the tool.
Remote MCP: Query Amazon Data From ChatGPT Without Pasting a Key
The browser OAuth path, for clients that cannot run a local installer. Client support matrix, a first prompt that verifies the connection without spending credits, and what revoking a connection actually does.
Choosing a Reverse ASIN Tool: An Acceptance Checklist You Can Run Yourself
No rankings. A method instead: fix a set of ASINs, test any tool against the same conditions, and check the three things no reverse lookup can return. Downloadable checklist included.
How to analyse Amazon reviews: from a pile of them to three kinds of actionable conclusion
The output of review analysis should not be a summary. It should be three separated conclusions — fix the product, fix the listing, fix nothing — because blending them turns a description problem into an expensive product change.
Exporting Amazon reviews into a spreadsheet: 21 columns and a template to download
The problem with copy-pasting reviews into Excel is not that it is slow — it is that it drops the fields you need to judge them. A downloadable review analysis sheet, the endpoint field behind every column, and the three traps in exporting.
Amazon Review Types Explained: Verified Purchase, Vine, Free Product and Early Experience
What each review label means, how to tell them apart in API data (verified, vine, free, experience), and why a star average computed before separating them has no commercial meaning.
What Amazon sales data can and cannot tell you: the API labels its own estimates
The marketplace never publishes unit sales, so every monthly figure is derived from BSR. This breaks down the fields across three sales endpoints — which are facts, which are derived, and the parent-versus-child comparison that quietly inflates results.
Four hidden costs of building your own Amazon scraper
Getting a scraper running is a day-one problem. This breaks down the four recurring costs that start after: anti-bot upkeep, defining your own field semantics, compliance exposure, and what happens when the person who wrote it leaves.
What Is an ASIN? vs UPC, EAN, ISBN, SKU
An ASIN is the ten-character code Amazon gives every product. How it differs from UPC, EAN, ISBN, SKU and FNSKU, how book ASINs work, and what it opens up.
The Complete Amazon Data API Guide: Choosing Among 46 Endpoints by Workflow
A walkthrough of 46 Amazon data endpoints grouped by the job they do — product research, keywords, market analytics, traffic, and trademarks — with the fields each returns and how to chain them.
Querying Amazon Data in Claude Code Without Writing Code
Two integration paths, the first prompt you can copy, and how to confirm real data came back. No code, and no endpoint paths to memorize.
Handing Product Research to an AI Agent: One Conversation From Seed Term to ASIN Shortlist
A copyable multi-step prompt that walks an agent through keyword expansion, category sizing, product filtering, and sales estimation, ending in a shortlist with reasons.
Competitor Analysis in Cursor or Codex: A Reproducible Conversation Script
Start from one ASIN and have an agent find competing products, reverse-look-up their traffic terms, compare traffic structure, and tell you which terms you are missing.