JSData & Media Start a project
Managed data pipeline · Amazon Seller Central

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.

amazon_seller / orders · order_item · orders_reportrole: Inventory and Order Tracking

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.

order status lifecycleASIN · SKU · quantityitem price · tax · shippingpromotions & discountsFBA vs. merchant fulfilledmarketplacebusiness orders flag
amazon_seller / settlement_report · financial_event_group · financial_*role: Finance and Accounting

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.

settlement linesfee breakdown per orderrefunds & chargebacksadjustments & reservescoupon & deal chargesads invoicespayout groups & transfer dates
amazon_seller / sales_and_traffic_business_report_* · parent · child · skurole: Brand Analytics

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.

sessions · page viewsbuy box %conversion (unit session %)ordered product salesunits ordered · B2B splitrefund rateby parent / child / SKU
amazon_seller / search_terms_report_* · repeat_purchase_report_*role: Brand Analytics

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.

search term ranktop 3 clicked ASINsclick share · conversion sharedaily · weekly · monthly · quarterlyrepeat customers %repeat purchase revenue
amazon_seller / marketplace_participationrole: Selling Partner Insights

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.

marketplace id · namecountry · currencyparticipation status

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 roleWhat the app readsWhy
Selling Partner InsightsMarketplace participationsIdentify your marketplaces and confirm the authorization works
Inventory and Order TrackingOrders, order items, All Orders report — without buyer contact or address detailsOrder and revenue history at item level, kept current daily
Finance and AccountingSettlement reports, financial event groups and eventsReconcile fees, refunds and payouts to orders and SKUs
Brand AnalyticsSales & Traffic report, Brand Analytics Search Terms and Repeat Purchase reportsDaily funnel and conversion by ASIN; search demand and share trends for Brand Registry sellers
Restricted rolesNot requested — no Direct-to-Consumer Shipping, Tax Invoicing, Tax Remittance, or Professional ServicesThe 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.

01

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.

02

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.

03

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.

Starter

Up to 3 connectors

Amazon Seller Central plus two more sources — Shopify, Meta Ads, TikTok Shop, Klaviyo and others.
$79/ month
  • All four Amazon data sets
  • Daily refresh, monitored
  • Full available history backfilled
Growth

Up to 8 connectors

Every channel you sell and market on, in one warehouse.
$179/ month
  • Everything in Starter
  • Amazon beside Shopify, ads and retail
  • Faster refresh schedules available
Scale

Up to 20 connectors

For brands and agencies running many sources and accounts.
$349/ month
  • 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 account

Questions first? jon@jsdata.ai · JS Data and Media Consults, Inc., El Segundo, CA