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 |
|---|---|
| Orders | Orders, status, fulfilment channel (FBA or merchant-fulfilled), purchase and update times. |
| OrderItems | Order lines by ASIN and SKU, with quantity, price and promotions. |
| ListFinancialEvents | Financial events - revenue, each type of fee, refunds and adjustments per order. |
| ListFinancialEventGroups | Financial event groups by settlement period. |
| GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE | Returns report by return date. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | AWS Seller Partner Account Type, AWS Environment, LWA Client Id, LWA Client Secret, Refresh Token, AWS Region |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
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.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line 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 orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
| Units sold | Total quantity of products in the order lines of valid orders. | Count |
| Marketplace fees | Marketplace commission and service fees, allocated to lines by line revenue. | Currency |
| Return rate | Returned orders divided by valid orders.= returned_orders / Valid orders | Ratio (%) |
| Contribution margin | Net 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 cost | Currency |
Connect Amazon Seller Partner in 3 steps
- 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
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
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
Connect Amazon Seller Partner and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes