Your Amazon seller data, in your warehouse, every morning.
Seller Central shows you reports one screen at a time and lets you download them one file at a time. It doesn't let you join Amazon to Shopify, TikTok Shop, and the rest of your business. The jsdata Amazon Seller Pipeline does.
A managed, read-only integration with Amazon's Selling Partner API. You authorize it once from Seller Central; it then delivers your orders, settlements and fees, sales & traffic, and Brand Analytics search terms into a data warehouse you own — Amazon Redshift, Google BigQuery, or Snowflake — refreshed daily. No buyer personal information is requested or stored.
What the app delivers
Four data sets, modeled for analysis
Not raw report files — clean warehouse tables, named after the Amazon reports and APIs they come from, ready for your BI tool, your analysts, and your AI. Each data set maps to one Selling Partner API role, listed on every card.
Orders — complete history, item level
Every order with its items, prices, promotions, taxes and fulfillment channel, kept current as statuses move from pending to shipped to refunded. Built from the Orders API and the All Orders report so late updates and cancellations never go missing from revenue. Buyer names, emails and street addresses are never requested — geography stops at city, state and postal code.
Settlements and fees — what Amazon actually paid you
Every settlement report line and every financial event: product charges, referral and FBA fees, promotions, refunds, adjustments, service fees and advertising invoices — tied to the order and SKU they belong to. The reconciliation between "ordered" and "deposited" that finance teams otherwise rebuild in spreadsheets each period.
Sales & traffic — the funnel, daily, by ASIN
The Business Reports you check in Seller Central, captured every day and archived for good: sessions and page views (browser and app), buy box percentage, unit session percentage, units and ordered product sales, refunds and claims — by date for the account, and by parent ASIN, child ASIN and SKU. Daily history Amazon's console only shows for a limited window becomes a permanent, joinable record.
Brand Analytics — search terms and repeat purchase
For Brand Registry sellers: the Amazon Search Terms report pulled daily, weekly, monthly and quarterly — each search term's frequency rank and the top clicked ASINs with click share and conversion share — plus the Repeat Purchase report by ASIN. Daily capture turns a report Amazon serves one period at a time into a time series you can trend, alert on, and join to your own ads and sales data.
Account and marketplaces
The marketplaces your account participates in, with currency and language — the lookup table every other data set keys on, and the check that confirms the authorization is healthy.
read-only · nothing is written back to your account · we never change listings, prices, inventory, orders or shipments
Data access
Exactly the roles we need, and nothing restricted
The app requests four non-restricted Selling Partner API roles. It does not request any restricted role, so Amazon never shares buyer personally identifiable information, tax documents, or shipping-label data with us.
| SP-API role | What the app reads | Why |
|---|---|---|
| Selling Partner Insights | Marketplace participations | Identify your marketplaces and confirm the authorization works |
| Inventory and Order Tracking | Orders, order items, All Orders report — without buyer contact or address details | Order and revenue history at item level, kept current daily |
| Finance and Accounting | Settlement reports, financial event groups and events | Reconcile fees, refunds and payouts to orders and SKUs |
| Brand Analytics | Sales & Traffic report, Brand Analytics Search Terms and Repeat Purchase reports | Daily funnel and conversion by ASIN; search demand and share trends for Brand Registry sellers |
| Restricted roles | Not requested — no Direct-to-Consumer Shipping, Tax Invoicing, Tax Remittance, or Professional Services | The pipeline is for aggregate business reporting, not customer data |
your data is used only to deliver your own reporting · never sold, shared, or combined across sellers · it lands only in infrastructure you own · full practices in our privacy policy and data deletion instructions
What it unlocks
From report downloads to decision-grade
The same standard as everything we build: your definitions, your warehouse, one holistic view.
One view of the business
Amazon revenue and units land beside Shopify, TikTok Shop, and retail in the same warehouse — blended reporting, channel mix, and true totals without spreadsheet stitching.
Net revenue, not gross
Settlement and fee detail joined to orders gives you contribution after Amazon's cut — referral fees, FBA fees, promotions, refunds — by SKU and by day.
Search demand as a time series
Search Terms captured daily shows how demand for your category keywords moves, which ASINs win the clicks, and whether your share is rising — before the monthly report would tell you.
Conversion you can trend
Sessions, buy box percentage, and unit session percentage archived daily by ASIN, so a listing change, a price test, or a stock-out shows up in the numbers the next morning.
Privacy-safe by default
No buyer names, emails, phone numbers, or street addresses — the app never asks Amazon for them. Clean posture for audits and data reviews.
Feeds what you already use
Standard warehouse tables — Redshift, Snowflake, BigQuery — ready for QuickSight, Looker, Tableau, your AI semantic layer, or the dashboards you already have. Table and column names follow the Amazon report and API fields.
Security & privacy
Authorized by you, revocable by you
Standard Seller Central authorization
You grant access through Amazon's own authorization flow, signed in to your Seller Central account. We never ask for your Amazon password, and the authorization lists the exact roles above before you approve.
Revoke any time
Remove the app under Seller Central → Apps & Services → Manage Your Apps. Access ends immediately, and we delete credentials and any residual data within 30 days.
Your warehouse, not ours
Data is delivered into your own Redshift, BigQuery, or Snowflake. Anything that passes through our pipeline is encrypted in transit and at rest and removed after load.
Policy-aligned by design
Built to Amazon's Data Protection Policy and Acceptable Use Policy: aggregate business reporting for your own account only, no resale or cross-seller aggregation, least-privilege roles, documented incident response.
Onboarding
Live the same week
No developer work on your side — one authorization and we take it from there.
Authorize
A one-time approval from your Seller Central account using Amazon's authorization flow. We walk you through it live; it takes about ten minutes.
Backfill
Order and settlement history, and up to two years of sales & traffic and Brand Analytics reports (the window Amazon makes available), land in your warehouse. Report-based backfills run at Amazon's request limits, so a full two-year history completes over a few days.
Refresh daily
Fully automated and monitored from then on, with recent days re-pulled so Amazon's restatements are captured. If anything fails, we know before you do — and we fix it.
Pricing
One connector. Your warehouse.
The Amazon Seller Central connector is one connector in our flat-rate ETL plans — no rows metered, no per-report fees, and your data lands in your warehouse. We never hold it.
Up to 3 connectors
- All four Amazon data sets
- Daily refresh, monitored
- Full available history backfilled
Up to 8 connectors
- Everything in Starter
- Amazon beside Shopify, ads and retail
- Faster refresh schedules available
Up to 20 connectors
- Everything in Growth
- Multiple seller accounts and marketplaces
- Direct access to the person who built it
full plan details, refresh-frequency add-ons and destinations on the pricing page · writes to your Redshift, BigQuery, or Snowflake · month-to-month, cancel anytime — your data and history stay with you · multiple seller accounts or agency use: ask us
Start now
Reports you download today are history you can't rebuild later.
One ten-minute authorization; your Amazon seller data in your warehouse, beside every other channel, every morning after.
Connect your seller accountQuestions first? jon@jsdata.ai · JS Data and Media Consults, Inc., El Segundo, CA