sellersprite-rpa

sellersprite-rpa

Unified skill covering the 5 core sellersprite Amazon data-analysis modules:

section	sellersprite module	Mode	Returned content
`products`	Product selection `/v3/product-research`	API (POST JSON)	Best-selling ASINs under each marketplace + category
`keywords`	Keyword product selection `/v2/keyword-research`	DOM (URL pagination)	Keyword search/click/PPC data
`markets`	Market selection `/v2/market-research`	DOM (POST form)	Niche market size + concentration
`aba`	ABA data product selection `/v3/aba-research`	API (POST JSON)	Brand Analytics keyword search frequency ranking
`competitors`	Competitor research `/v3/competitor-lookup`	API (POST JSON)	Reverse-lookup competitors by keyword/brand/seller/ASIN

Merged from the 5 original per-skill installs (kept as backup under .claude/skills/sellersprite-<section>/ until retired). Transport is BrowserSkill (bsk) — see references/environment.md.

Requirements

BrowserSkill (bsk): CLI on PATH + browser extension connected — bsk status must show browsers connected >= 1
sellersprite login in that same browser. Login-expiry signal: v2 sections (keywords/markets) redirect to /w/user/login; v3 APIs may still return data anonymously — do not treat v3 success as proof of login.
Python 3.10+ (no third-party packages)

Quick start

CLI="python .claude/skills/sellersprite-rpa/scripts/sellersprite_rpa.py"

# products — top 100 US ASINs (5 pages × 20)
$CLI fetch --section products --station US --pages 5 --out data/us_top100.csv

# keywords — "flashlight" across 3 stations
$CLI fetch --section keywords --station US,JP,GB --keyword flashlight --pages 1 \
    --out data/keywords_by_station.csv

# markets — sub-markets matching "led"
$CLI fetch --section markets --station US --keyword led --out data/markets.csv

# aba — keyword rank (or ASIN reverse via --query B0XXXX)
$CLI fetch --section aba --station US --query "yoga mat" --pages 1 --out data/aba.csv

# competitors — exactly one of --keyword/--brand/--seller/--asin
$CLI fetch --section competitors --station US --keyword "yoga mat" --pages 1 \
    --out data/comp.csv

# analyze — report per section
$CLI analyze --section aba --input data/aba.csv --out-md reports/aba.md

Multi-station runs write one CSV per station (<stem>_<STATION>.csv) plus the combined CSV. All fetches accept --session (default sellersprite-rpa).

Station vocabulary

10 Amazon marketplaces: US United States / JP Japan / GB United Kingdom / DE Germany / FR France / IT Italy / ES Spain / CA Canada / IN India / MX Mexico.

Market-code quirk per section (see references/api_notes_*.md): products uses the 2-letter station code as body market; aba uses COM for US; competitors uses 2-letter codes; keywords/markets URLs need marketId ints (mapped automatically).

Architecture

scripts/
├─ sellersprite_rpa.py   # single-entry CLI: fetch / analyze (--section)
├─ bridge_browserskill.py# bsk transport adapter (call/evaluate/session_stop)
├─ common.py             # shared helpers: page fetch, station click, CSV writer
├─ core_api.py           # API engine: ensure→post_json loop→dedupe→flatten
├─ core_dom.py           # DOM engine: keywords URL-pagination / markets form-submit
├─ sections.py           # config registry: URLs, build_body/parse_row (verbatim)
├─ analyze.py            # report dispatcher
└─ report_<section>.py   # 5 report generators (verbatim ports, run() entry)

Rule: engines read config from sections.py and never hardcode section details; the parse/build/flatten functions are verbatim ports of the original per-skill scripts — do not rewrite them casually.

Gotchas digest

Subscription modal pops on every v3 page load — ensure_v3_page() auto-dismisses via .ant-modal-close.
Free-tier masking: products caps amzUnit at 100k; keywords unmask top 50 only; aba returns null items beyond page 1; competitors returns ~20 unique ASINs (page 2+ repeats, deduped automatically).
v2 station switching needs the UI click — URL station= param is ignored; click_station_button() handles it (matches label via startsWith).
SPA/HTML latency: engines sleep after navigation (products/aba/comp ~6s total; keywords 5s/page; markets 6s+6s). If you see 0 rows, suspect "too fast" before selectors.
GB pagination bug (products): page 2 may repeat page 1 — report_products.py dedupes by (market, ASIN).
Keyword index is station-specific for markets: flashlight returns 0 rows on JP/GB — use globally-recognized terms (led, phone, yoga) for multi-station runs.
CSV encoding: outputs are utf-8-sig (BOM). Read with encoding="utf-8-sig" on Windows.

About this skill