Amazon Selling Partner
BetaThis source is currently in beta. It works end to end, but you may still hit rough edges. Let us know if you do.
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Amazon Selling Partner to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Seller accounts sync orders, order items, financial transactions and FBA inventory. The app needs the Inventory and Order Tracking, Finance and Accounting and Amazon Fulfillment roles. Orders and order items read the same Amazon endpoint, so syncing both takes twice as long. Vendor accounts sync daily sales, inventory, net pure product margin, forecasts and hourly sales reports, which need the Brand Analytics role and your marketplace IDs.
Configuration
| Option | Description |
|---|---|
RegionType: select Required: True | |
LWA client IDType: text Required: True | |
LWA client secretType: password Required: True | |
Refresh tokenType: password Required: True | |
Marketplace IDsType: text Required: False | Comma-separated. Required for vendor reports. For sellers it applies to orders, order items and inventory, while transactions always cover every marketplace. Sellers can leave it blank to use every marketplace they sell in. |
Linking Amazon Selling Partner to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Amazon Selling Partner
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
orders | A customer order placed with the seller, with its items nested in orderItems. | Incremental, Full refresh | lastUpdatedTime | — |
order_items | One row per item in an order, with the order's id, creation time and last update time. | Incremental, Full refresh | lastUpdatedTime | — |
transactions | A financial transaction on the seller account, such as an order payment, refund or fee. | Incremental, Full refresh | postedDate | — |
inventory_summaries | FBA inventory levels per seller SKU and marketplace. | Full refresh | — | — |
vendor_sales | Daily retail sales per ASIN for a vendor, from the Vendor Sales report (manufacturing view, retail program). | Incremental, Full refresh | startDate | — |
vendor_inventory | Daily inventory and operational health per ASIN for a vendor, from the Vendor Inventory report. | Incremental, Full refresh | startDate | — |
vendor_net_pure_product_margin | Daily net pure product margin per ASIN, a measure of Amazon's profitability on the vendor's items. | Incremental, Full refresh | startDate | — |
vendor_forecasts | The latest weekly customer demand forecast per ASIN, from the Vendor Forecasting report (retail program). | Full refresh | — | — |
vendor_real_time_sales | Hourly ordered units and revenue per ASIN, from the Vendor Real-Time Sales report. | Incremental, Full refresh | startTime | — |