Skip to content

E-commerce

Connect Amazon Seller Partner to DataxLand

For sellers on Amazon, the Amazon Seller Partner connector reads orders, order items, financial events (fees, refunds, adjustments) and Seller Central reports through the Selling Partner API. Si maps Amazon orders to the same retail model as your website and other channels (Shopify, WooCommerce, and in Southeast Asia Shopee, TikTok Shop and Lazada), so Amazon's net revenue, marketplace fees from financial events, return rate and gross profit after fees sit next to every other channel on one dashboard, with one definition.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with Amazon Seller Partner

  • Compare profit after fees on Amazon with your other channels when you sell the same products in several places.
  • Track Amazon fees (referral fees, FBA fees) as a share of revenue month by month.
  • See which products are returned most on Amazon.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
OrdersOrders, status, fulfilment channel (FBA or merchant-fulfilled), purchase and update times.
OrderItemsOrder lines by ASIN and SKU, with quantity, price and promotions.
ListFinancialEventsFinancial events - revenue, each type of fee, refunds and adjustments per order.
ListFinancialEventGroupsFinancial event groups by settlement period.
GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATEReturns report by return date.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inAWS Seller Partner Account Type, AWS Environment, LWA Client Id, LWA Client Secret, Refresh Token, AWS Region
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Units soldTotal quantity of products in the order lines of valid orders.Count
Marketplace feesMarketplace commission and service fees, allocated to lines by line revenue.Currency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Contribution marginNet revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return costCurrency

Connect Amazon Seller Partner in 3 steps

  1. 1

    Register an SP-API app

    In Seller Central, register as a developer and create a private app to get the LWA client ID, client secret and refresh token.

  2. 2

    Add the source

    In the workspace choose Add source, find Amazon Seller Partner in the connector library, enter the LWA client ID, client secret, refresh token, region, environment and account type, then click Test connection.

  3. 3

    Choose streams and review

    Pick orders, order items and financial events; Si proposes the mapping to the retail model, and you approve before the build.

Limits and caveats

  • You register the SP-API app with Amazon yourself; DataxLand does not run the Amazon sign-in for you.
  • Amazon generates reports asynchronously and rate-limits them; the first load and large reports can take a while.
  • Amounts stay in each marketplace's currency as Amazon returns them; keep this in mind when comparing with channels that sell in another currency.
  • Amazon data has no cost of goods; add it with Excel or Google Sheets. This is an Airbyte connector (ELv2) run inside DataxLand.

Frequently asked questions

Does it read buyer information?

The spec has an option to include personal data; if you turn it on, those columns are still hashed on load and never returned through dashboards, the API or MCP.

What if I sell on several Amazon marketplaces?

Each region is one source; dashboards split or combine by marketplace.

Does it change listings or prices?

No. DataxLand only reads data.

Dashboard templates that use this source

Ask Si about your Amazon Seller Partner data →Amazon Seller Partner + Amazon Ads →All data sources →

Connect Amazon Seller Partner and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes