Set up Amazon Seller exports to send data into Google Sheets or BigQuery.
After connecting your Amazon Seller account, use the Export Builder to create focused exports by data type and selected fields.
Each enabled tab writes to its own destination table/sheet tab.
Use column selection in each tab to choose from the fields below.
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, is_premium_order, is_business_order, is_prime, order_type, earliest_ship_date, latest_ship_date, earliest_delivery_date, latest_delivery_date, exportDate
Coming soon: buyer_email, buyer_name, ship_city, ship_state, ship_postal_code, ship_country. These fields are not available for new exports yet.
amazon_order_id, order_item_id, asin, seller_sku, title, quantity_ordered, currency_code, item_price, item_tax, shipping_price, shipping_tax, shipping_discount, promotion_discount, item_promotion_id, condition, exportDate
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
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
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
event_type, financial_event_group_id, 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
Each charge, fee, refund, adjustment, or promotion line from the Finances API is exported as its own row. This is not the same data as Settlement Reports — different API, different retention behavior.
Use append mode and scheduled exports to build history in your destination. How far back Amazon returns events varies by account and may not match your export date preset.
return_date, order_id, seller_sku, asin, fnsku, product_name, quantity, fulfillment_center_id, detailed_disposition, reason, status, license_plate_number, customer_comments, exportDate
asin, fnsku, product_name, fulfillment_center, country_code, month_of_charge, storage_rate, currency, estimated_monthly_storage_fee, exportDate
snapshot_date, sku, fnsku, asin, product_name, condition, qty_charged, amount_charged, surcharge_age_tier, rate_surcharge, exportDate
sku, fnsku, asin, product_name, fulfilled_by, currency, estimated_fee_total, estimated_referral_fee_per_unit, expected_domestic_fulfilment_fee_per_unit, exportDate
approval_date, reimbursement_id, case_id, amazon_order_id, reason, sku, fnsku, asin, product_name, amount_total, exportDate
promotion_id, promotion_name, marketplace_id, merchant_id, promotion_type, status, creation_channel, glance_views, units_sold, revenue, revenue_currency_code, amount_spent, amount_spent_currency_code, start_date_time, end_date_time, created_date_time, last_updated_date_time, funding_agreement_id, vendor_code, asin, product_name, product_glance_views, product_units_sold, product_revenue, product_revenue_currency_code, product_amount_spent, product_amount_spent_currency_code, exportDate
One row per product included in each promotion. The date preset filters by promotion start date, not order date. Amazon supports about two years of history.
coupon_id, merchant_id, marketplace_id, currency_code, name, website_message, start_date_time, end_date_time, customer_segment, discount_type, discount_amount, clips, redemptions, budget, total_discount, budget_spent, budget_remaining, budget_percentage_used, sales, asins, exportDate
One row per coupon. ASINs are comma-separated when a coupon applies to multiple products. The date preset filters by coupon start date. Availability depends on your Amazon account.
Amazon Seller exports support the same preset selection pattern used in other exporters, including Since last export, recent windows, monthly windows, and Maximum.
Most date-range tabs use the selected preset directly. Two finance tabs behave differently:
Use smaller windows for initial setup and troubleshooting. Increase range after validating performance and output.
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.
For each tab, select only the fields you need. Fewer columns improve export speed and keep destination tables easier to maintain.
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.
After validating a manual run, configure schedule frequency and timing from the export details page.