Configuring Amazon Seller Exports

Set up Amazon Seller exports to send data into Google Sheets or BigQuery. Use the data reference when you need every field spelled out.

Set up an export

Create an Amazon Seller export and pick tabs, columns, and a date range.

Column dictionary

See every available field for each Amazon Seller tab.

Overview

After connecting your Amazon Seller account, use the Export Builder to create focused exports by data type and selected fields.

Prerequisites

Amazon Seller account connected (see Connecting Your Amazon Seller Account)
A Google Sheets or BigQuery destination configured

Create an export

Go to Export Builder and create a new export.
Select Amazon Seller as the source and choose the connected seller account.
Select destination (Google Sheets or BigQuery).
Choose date preset and configure tab settings.
Save the export and run it manually for validation.

Available data tabs

Orders: uses the selected date range. Buyer and shipping address fields are coming soon for new exports.
Order Items: uses the selected date range
FBA Inventory: current FBA inventory snapshot, not historical
Listings: current listing snapshot, not historical
Settlement Reports: Amazon-generated settlement flat files (payout statements); separate from Financial Events. History limited to about 90 days by Amazon report retention. The date preset filters by when Amazon created each report file, not the settlement period inside it.
Financial Events: Finances API transaction detail filtered by posted date; separate from Settlement Reports. Requires the Finance and Accounting SP-API role. How far back Amazon returns data varies by account.
Returns: date-range FBA returns report
FBA Storage Fees: monthly/current storage fee report, not full historical backfill
FBA Long-Term Storage Fees: uses the selected date range
FBA Fee Preview: current estimated fees for active FBA offers, not historical
FBA Reimbursements: date-range FBA reimbursement report
Promotions: Lightning Deal and Best Deal performance for promotions that start in the selected date range; requires Brand Registry eligibility. One row per product included in each promotion.
Coupons: coupon clips, redemptions, budget, and sales for coupons that start in the selected date range (if your account qualifies)

Each enabled tab writes to its own destination table/sheet tab.

Full column lists and descriptions: Amazon Seller data reference.

Date presets

Amazon Seller exports support the same preset selection pattern used in other exporters, including Since last export, recent windows, monthly windows, and Maximum.

You can also choose Custom range and pick exact start and end dates (maximum 1 year). That window is fixed: it does not move forward on later runs, and scheduled exports are paused while it is selected. Use Run now. Snapshot tabs such as FBA Inventory, Listings, and FBA Fee Preview still export current data and ignore the date range.

Most date-range tabs use the selected preset directly. Two finance tabs behave differently:

Settlement Reports: filters by when Amazon generated each report file (about 90 days of report retention). Not the same as Financial Events.
Financial Events: filters by posted date via the Finances API. Separate from settlement report files; how much history Amazon returns varies by account.
Promotions and Coupons: filter by promotion or coupon start date within the selected preset (included in Since last export).

Use smaller windows for initial setup and troubleshooting. Increase range after validating performance and output.

Building finance history over time

Amazon limits how long settlement report files and Finances API events remain available, and the two sources are independent. Settlement report files are typically available for roughly 90 days. Financial Events history varies by account and is not guaranteed to match your export date preset.

To keep finance data beyond what Amazon exposes at any one time, enable Append on the Settlement Reports and/or Financial Events tabs and run exports on a schedule. Each run adds new rows to your destination.

Column selection

For each tab, select only the fields you need. Fewer columns improve export speed and keep destination tables easier to maintain.

Append vs replace

Replace: overwrite the tab output on each run.
Append: add new rows to existing output.

Use append when building history over time and replace for snapshot-style tabs. This is especially important for Financial Events and Settlement Reports, where Amazon limits how far back data can be fetched.

Scheduling

After validating a manual run, configure schedule frequency and timing from the export details page.