Configuring Amazon Seller Exports

Set up Amazon Seller exports to send data into Google Sheets or BigQuery.

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: order-level Seller data
Order Items: line-item level order details
FBA Inventory: inventory and quantity metrics
Listings: listing catalog and status fields
Settlements: financial settlement rows
Returns: FBA returns data

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

Available export fields

Use column selection in each tab to choose from the fields below.

Orders

amazon_order_id, purchase_date, last_updated_date, order_status, fulfillment_channel, sales_channel, ship_service_level, currency_code, order_total, number_of_items_shipped, number_of_items_unshipped, payment_method, marketplace_id, buyer_email, buyer_name, ship_city, ship_state, ship_postal_code, ship_country, is_premium_order, is_business_order, is_prime, order_type, earliest_ship_date, latest_ship_date, earliest_delivery_date, latest_delivery_date, exportDate

Order Items

amazon_order_id, order_item_id, asin, seller_sku, title, quantity_ordered, quantity_shipped, currency_code, item_price, item_tax, shipping_price, shipping_tax, shipping_discount, promotion_discount, item_promotion_id, condition, is_gift, exportDate

FBA Inventory

seller_sku, fnsku, asin, product_name, condition, afn_fulfillable_quantity, afn_inbound_working_quantity, afn_inbound_shipped_quantity, afn_inbound_receiving_quantity, afn_reserved_quantity, afn_total_quantity, afn_unsellable_quantity, per_unit_volume, afn_researching_quantity, exportDate

Listings

seller_sku, asin, item_name, item_description, listing_id, price, currency_code, quantity, open_date, product_id_type, item_condition, status, fulfillment_channel, business_price, exportDate

Settlements

settlement_id, settlement_start_date, settlement_end_date, deposit_date, total_amount, currency, transaction_type, order_id, merchant_order_id, sku, quantity_purchased, marketplace_name, amount_type, amount_description, amount, fulfillment_id, posted_date, exportDate

Returns

return_date, order_id, seller_sku, asin, fnsku, product_name, quantity, fulfillment_center_id, detailed_disposition, reason, status, license_plate_number, customer_comments, exportDate

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.

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

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.

Scheduling

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