HomeDocumentationCode SamplesAnnouncementsModelsRelease NotesFAQGitHubVideos
Developer HubAPI StatusSupport
Documentation
Developer HubAPI StatusSupport

Fulfillment by Amazon (FBA) Reports

FBA Reports for the Selling Partner Reports API.

Fulfillment by Amazon (FBA) reports

There are limits to how often Amazon will generate FBA reports. These limits depend on whether an FBA report is a near-real time report or a daily report. Refer to the following table to review which FBA reports are near-real-time and which are daily.

A near-real time FBA report is generated no more than once every 30 minutes. This means that after a near-real time FBA report is generated following your report request, a 30-minute waiting period must pass before Amazon will generate an updated version of that report. Note that the four "All Orders" reports are not subject to this limitation.

A daily FBA report is generated no more than once every four hours. This means that after a daily FBA report is generated following your report request, a four-hour waiting period must pass before Amazon will generate an updated version of that report.

FBA Sales Reports

FBA Amazon Fulfilled Shipments Report

reportType Value: GET_AMAZON_FULFILLED_SHIPMENTS_DATA_GENERAL

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Contains detailed order/shipment/item information including price, courier, and tracking data. You can request up to one month of data in a single report.

📘

Note:

Fulfillment order report data may be delayed up to three hours from the time a fulfillment order ships to the time the items appear in the report.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • amazon-order-id
  • merchant-order-id
  • shipment-id
  • shipment-item-id
  • amazon-order-item-id
  • merchant-order-item-id
  • purchase-date
  • payments-date
  • shipment-date
  • reporting-date
  • buyer-email
  • buyer-name
  • buyer-phone-number
  • sku
  • product-name
  • quantity-shipped
  • currency
  • item-price
  • item-tax
  • shipping-price
  • shipping-tax
  • gift-wrap-price
  • gift-wrap-tax
  • ship-service-level
  • recipient-name
  • ship-address-1
  • ship-address-2
  • ship-address-3
  • ship-city
  • ship-state
  • ship-postal-code
  • ship-country
  • ship-phone-number
  • bill-address-1
  • bill-address-2
  • bill-address-3
  • bill-city
  • bill-state
  • bill-postal-code
  • bill-country
  • item-promotion-discount
  • ship-promotion-discount
  • carrier
  • tracking-number
  • estimated-arrival-date
  • fulfillment-center-id
  • fulfillment-channel
  • sales-channel

FBA Amazon Fulfilled Shipments Report (Invoicing)

reportType Value: GET_AMAZON_FULFILLED_SHIPMENTS_DATA_INVOICING

Role: Tax Invoicing (Restricted)

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Use this report to generate tax invoices in the EU region. You can request up to one month of data in a single report.

📘

Note:

Fulfillment order report data may be delayed up to three hours from the time a fulfillment order ships to the time the items appear in the report.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • amazon-order-id
  • merchant-order-id
  • shipment-id
  • shipment-item-id
  • amazon-order-item-id
  • merchant-order-item-id
  • purchase-date
  • payments-date
  • shipment-date
  • reporting-date
  • buyer-email
  • buyer-name
  • buyer-phone-number
  • sku
  • product-name
  • quantity-shipped
  • currency
  • item-price
  • item-tax
  • shipping-price
  • shipping-tax
  • gift-wrap-price
  • gift-wrap-tax
  • ship-service-level
  • recipient-name
  • ship-address-1
  • ship-address-2
  • ship-address-3
  • ship-city
  • ship-state
  • ship-postal-code
  • ship-country
  • ship-phone-number
  • bill-address-1
  • bill-address-2
  • bill-address-3
  • bill-city
  • bill-state
  • bill-postal-code
  • bill-country
  • item-promotion-discount
  • ship-promotion-discount
  • carrier
  • tracking-number
  • estimated-arrival-date
  • fulfillment-center-id
  • fulfillment-channel
  • sales-channel

FBA Amazon Fulfilled Shipments Report (Tax)

reportType Value: GET_AMAZON_FULFILLED_SHIPMENTS_DATA_TAX

Role: Tax Remittance (Restricted)

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

This report is for calculating and remitting taxes in the NA region. You can request up to one month of data in a single report.

📘

Note:

Fulfillment order report data may be delayed up to three hours from the time a fulfillment order ships to the time the items appear in the report.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • amazon-order-id
  • merchant-order-id
  • shipment-id
  • shipment-item-id
  • amazon-order-item-id
  • merchant-order-item-id
  • purchase-date
  • payments-date
  • shipment-date
  • reporting-date
  • buyer-email
  • buyer-name
  • buyer-phone-number
  • sku
  • product-name
  • quantity-shipped
  • currency
  • item-price
  • item-tax
  • shipping-price
  • shipping-tax
  • gift-wrap-price
  • gift-wrap-tax
  • ship-service-level
  • recipient-name
  • ship-address-1
  • ship-address-2
  • ship-address-3
  • ship-city
  • ship-state
  • ship-postal-code
  • ship-country
  • ship-phone-number
  • bill-address-1
  • bill-address-2
  • bill-address-3
  • bill-city
  • bill-state
  • bill-postal-code
  • bill-country
  • item-promotion-discount
  • ship-promotion-discount
  • carrier
  • tracking-number
  • estimated-arrival-date
  • fulfillment-center-id
  • fulfillment-channel
  • sales-channel

Flat File All Orders Report by Last Update

reportType Value: GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted), Product Listing

Availability: Sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Returns all orders updated in the specified date range regardless of fulfillment channel or shipment status. This report is intended for order tracking, not to drive a seller's fulfillment process. It does not include customer identifying information and scheduling is not supported.

Select to expand list of report attributes.
  • amazon-order-id
  • merchant-order-id
  • purchase-date
  • last-updated-date
  • order-status
  • fulfillment-channel
  • sales-channel
  • order-channel
  • ship-service-level
  • product-name
  • sku
  • asin
  • item-status
  • quantity
  • currency
  • item-price
  • item-tax
  • shipping-price
  • shipping-tax
  • gift-wrap-price
  • gift-wrap-tax
  • item-promotion-discount
  • ship-promotion-discount
  • ship-city
  • ship-state
  • ship-postal-code
  • ship-country
  • promotion-ids
  • is-business-order
  • purchase-order-number
  • price-designation

Flat File All Orders Report by Order Date

reportType Value: GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)

Availability: Sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Returns all orders placed in the specified date range regardless of fulfillment channel or shipment status. This report is intended for order tracking, not to drive a seller's fulfillment process. It does not include customer identifying information and scheduling is not supported.

Select to expand list of report attributes.
  • amazon-order-id
  • merchant-order-id
  • purchase-date
  • last-updated-date
  • order-status
  • fulfillment-channel
  • sales-channel
  • order-channel
  • ship-service-level
  • product-name
  • sku
  • asin
  • item-status
  • quantity
  • currency
  • item-price
  • item-tax
  • shipping-price
  • shipping-tax
  • gift-wrap-price
  • gift-wrap-tax
  • item-promotion-discount
  • ship-promotion-discount
  • ship-city
  • ship-state
  • ship-postal-code
  • ship-country
  • promotion-ids
  • is-business-order
  • purchase-order-number
  • price-designation

XML All Orders Report by Last Update

reportType Value: GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)

Availability: Sellers

Requested/scheduled: This report can only be requested.

Report output type: XML file

Returns all orders updated in the specified date range regardless of fulfillment channel or shipment status. This report is intended for order tracking, not to drive a seller's fulfillment process. It does not include customer identifying information and scheduling is not supported.

Select to expand list of report attributes.
  • amazon-order-id
  • merchant-order-id
  • purchase-date
  • last-updated-date
  • order-status
  • fulfillment-channel
  • sales-channel
  • order-channel
  • ship-service-level
  • product-name
  • sku
  • asin
  • item-status
  • quantity
  • currency
  • item-price
  • item-tax
  • shipping-price
  • shipping-tax
  • gift-wrap-price
  • gift-wrap-tax
  • item-promotion-discount
  • ship-promotion-discount
  • ship-city
  • ship-state
  • ship-postal-code
  • ship-country
  • promotion-ids
  • is-business-order
  • purchase-order-number
  • price-designation

XML All Orders Report by Order Date

reportType Value: GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL

Role: Pricing, Amazon Fulfillment, Inventory and Order Tracking, Direct to Consumer Shipping (Restricted)

Availability: Sellers

Requested/scheduled: This report can only be requested.

Report output type: XML file

Returns all orders placed in the specified date range regardless of fulfillment channel or shipment status. This report is intended for order tracking, not to drive a seller's fulfillment process. It does not include customer identifying information and scheduling is not supported.

Select to expand list of report attributes.
  • amazon-order-id
  • merchant-order-id
  • purchase-date
  • last-updated-date
  • order-status
  • fulfillment-channel
  • sales-channel
  • order-channel
  • ship-service-level
  • product-name
  • sku
  • asin
  • item-status
  • quantity
  • currency
  • item-price
  • item-tax
  • shipping-price
  • shipping-tax
  • gift-wrap-price
  • gift-wrap-tax
  • item-promotion-discount
  • ship-promotion-discount
  • ship-city
  • ship-state
  • ship-postal-code
  • ship-country
  • promotion-ids
  • is-business-order
  • purchase-order-number
  • price-designation

FBA Customer Shipment Sales Report

reportType Value: GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_SALES_DATA

Role: Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Contains condensed item level data on shipped FBA customer orders including price, quantity, and ship to location.

📘

Note:

Fulfillment order report data may be delayed up to three hours from the time a fulfillment order ships to the time the items appear in the report.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • shipment-date
  • sku
  • fnsku
  • asin
  • fulfillment-center-id
  • quantity
  • amazon-order-id
  • currency
  • item-price-per-unit
  • shipping-price
  • gift-wrap-price
  • ship-city
  • ship-state
  • ship-postal-code

FBA Promotions Report

reportType Value: GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Marketplace availability: North America (NA)

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Daily; every 4 hours

Contains promotions applied to FBA customer orders sold through Amazon, such as Super Saver Shipping.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • shipment-date currency
  • item-promotion-discount
  • item-promotion-id
  • description
  • promotion-rule-value
  • amazon-order-id
  • shipment-id
  • shipment-item-id

FBA Customer Taxes

reportType Value: GET_FBA_FULFILLMENT_CUSTOMER_TAXES_DATA

Role: Amazon Fulfillment, Tax Remittance (Restricted)

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Tab-delimited flat file report for tax-enabled US sellers. This report contains data through February 28, 2013. All new transaction data can be found in the Sales Tax Report.


Remote Fulfillment Eligibility

reportType Value: GET_REMOTE_FULFILLMENT_ELIGIBILITY

Role: Amazon Fulfillment, Inventory and Order Tracking

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Contains all of a seller's US Fulfillment by Amazon offers, including whether they qualify for the North America Remote Fulfillment (NARF) program.

📘

Note:

Recheck this report regularly, since ASIN eligibility can change. This report can take up to 24 hours to generate.

Select to expand list of report attributes.
  • Merchant
  • SKU
  • ASIN
  • Product
  • name
  • Offer
  • status
  • More
  • Details

FBA Inventory Reports

FBA Amazon Fulfilled Inventory Report

reportType Value: GET_AFN_INVENTORY_DATA

Role: Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • seller-sku
  • fulfillment-channel-sku
  • asin
  • condition-type
  • Warehouse-Condition-code
  • Quantity Available

FBA Multi-Country Inventory Report

reportType Value: GET_AFN_INVENTORY_DATA_BY_COUNTRY

Role: Pricing, Amazon Fulfillment

Availability: Seller Central sellers

Marketplace availability: Europe (EU)

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Contains quantity available for local fulfillment by country, helping Multi-Country Inventory sellers in Europe track their FBA inventory.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • seller-sku
  • fulfillment-channel-sku
  • asin
  • condition-type
  • country
  • quantity-for-local-fulfillment

Inventory Ledger Report - Summary View

reportType Value: GET_LEDGER_SUMMARY_VIEW_DATA

Role: Amazon Fulfillment

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

The Inventory Ledger Report is like a bank statement of your inventory. It provides end-to-end inventory reconciliation capability by showing starting inventory balance, received inventory, customer orders, customer returns, adjustments, removals and ending balance.

This report accepts the following reportOptions values:

  • aggregateByLocation - Include Country to aggregate Summary View data by country. Include FC to aggregate Summary View data by fulfillment center. Default: COUNTRY. Example: "reportOptions":{"aggregateByLocation":"COUNTRY"}

  • aggregatedByTimePeriod - Specify the time period to aggregate Summary View data accordingly (for example, MONTHLY, WEEKLY, DAILY, etc.). Default: MONTHLY. Example: "reportOptions":{"aggregatedByTimePeriod":"MONTHLY"}

  • FNSKU - Include FNSKU value to view report data for that particular FNSKU.

  • MSKU - Include MSKU value to view report data for all active FNSKU mappings of that MSKU.

  • ASIN - Include ASIN value to view report data for all active FNSKU mappings of that ASIN.

Report behaviors:

  • You can pass multiple parameters to ReportOptions as shown in the following example: "reportOptions":{"eventType":"Adjustments", "FNSKU" : "X00001", "MSKU" : "Test"}

  • If aggregateByLocation is set as FC, Ledger Summary View will return data aggregated at FC level.

  • If aggregateByLocation is set as COUNTRY, Ledger Summary View will return data aggregated at COUNTRY level.

  • If aggregatedByTimePeriod is set as DAILY, Ledger Summary View will return data aggregated at the end of day. For example, dataStartTime is 2023-01-15T00:00:00+00:00 and dataEndTime is 2023-01-15T23:59:59+00:00 will return Jan 15th data.

  • If aggregatedByTimePeriod is set as MONTHLY, Ledger Summary View will return data aggregated at the end of the month. dataStartTime must be set to first of the month and dataEndTime must be set to last day of the month to get monthly data. For example, dataStartTime of 2022-12-01T00:00:00+00:00 and dataEndTime 2022-12-31T00:00:00+00:00 will return December Month data.

  • If aggregatedByTimePeriod is set as WEEKLY, Ledger Summary View will return data aggregated at the end of the week. dataStartTime and dataEndTime must be start and end of the week to get weekly data. For example, dataStartTime is 2023–01-09T00:00:00+00:00 and dataEndTime 2023-01-15T23:59:59+00:00 will return weekly data of 15th Jan.

  • If no reportOptions are passed to request, Ledger Report Summary View will return data with DEFAULT options which is COUNTRY for aggregateByLocation and MONTHLY for aggregatedByTimePeriod.

  • Ledger Report Summary View can return empty data if invalid dataStartTime/dataEndTime is passed along with aggregatedByTimePeriod filter values. (Refer to the behaviors for aggregatedByTimePeriod under report behaviors for the GET_LEDGER_SUMMARY_VIEW_DATA report type on how to set a valid dataStartTime/dataEndTime for appropriate aggregatedByTimePeriod filter options).

Select to expand list of report attributes.
  • Date
  • FNSKU
  • ASIN
  • MSKU
  • Title
  • Disposition
  • StartingWarehouseBalance
  • InTransitBetweenWarehouses
  • Receipts
  • CustomerShipments
  • CustomerReturns
  • VendorReturns
  • WarehouseTransferIn/Out
  • Found
  • Lost
  • Damaged
  • Disposed
  • OtherEvents
  • EndingWarehouseBalance
  • UnknownEvents
  • Location

Inventory Ledger Report - Detailed View

reportType Value: GET_LEDGER_DETAIL_VIEW_DATA

Role: Amazon Fulfillment

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Use the Inventory Ledger Report - Detailed View to analyze your inventory movements to and from Amazon fulfillment centers, including products that are sold, returned, removed/disposed, damaged, lost, and found. You can view all historical movements of your inventory for 18 months in this report.

This report accepts the following reportOptions values:

  • eventType - Filters report data for a particular warehouse event. Default is the empty string, which returns all events. Other possible values are as follows:
    • Adjustments
    • CustomerReturns
    • Receipts
    • Shipments
    • VendorReturns
    • WhseTransfers
    Examples:
    • "reportOptions":{"eventType":""}
    • "reportOptions":{"eventType":"Adjustments"}
  • FNSKU - Include FNSKU value to view report data for that particular FNSKU.
  • MSKU - Include MSKU value to view report data for all active FNSKU mappings of that MSKU.
  • ASIN - Include ASIN value to view report data for all active FNSKU mappings of that ASIN.

You can pass multiple parameters to ReportOptions as shown in the following example:

"reportOptions":{"eventType":"Adjustments", "FNSKU" : "X00001", "MSKU" : "Test"}

Select to expand list of report attributes.
  • Date
  • FNSKU
  • ASIN
  • MSKU
  • Title
  • EventType
  • ReferenceID
  • Quantity
  • FulfillmentCenter
  • Disposition
  • Reason
  • Country
  • ReconciledQuantity
  • UnreconciledQuantity

FBA Reserved Inventory Report

reportType Value: GET_RESERVED_INVENTORY_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Provides data about the number of reserved units in a seller's inventory.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • sku
  • fnsku
  • asin
  • product-name
  • reserved_qty
  • reserved_customerorders
  • reserved_fc-transfers
  • reserved_fc-processing

FBA Manage Inventory

reportType Value: GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Contains current details of active (not archived) inventory including condition, quantity, and volume.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • sku
  • fnsku
  • asin
  • product-name
  • condition
  • your-price
  • mfn-listing-exists
  • mfn-fulfillable-quantity
  • afn-listing-exists
  • afn-warehouse-quantity
  • afn-fulfillable-quantity
  • afn-unsellable-quantity
  • afn-reserved-quantity
  • afn-total-quantity
  • per-unit-volume
  • afn-inbound-working-quantity
  • afn-inbound-shipped-quantity
  • afn-inbound-receiving-quantity
  • afn-researching-quantity
  • afn-reserved-future-supply
  • afn-future-supply-buyable

FBA Manage Inventory - Archived

reportType Value: GET_FBA_MYI_ALL_INVENTORY_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Contains current details of all (including archived) inventory including condition, quantity, and volume.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • sku
  • fnsku
  • asin
  • product-name
  • condition
  • your-price
  • mfn-listing-exists
  • mfn-fulfillable-quantity
  • afn-listing-exists
  • afn-warehouse-quantity
  • afn-fulfillable-quantity
  • afn-unsellable-quantity
  • afn-reserved-quantity
  • afn-total-quantity
  • per-unit-volume
  • afn-inbound-working-quantity
  • afn-inbound-shipped-quantity
  • afn-inbound-receiving-quantity
  • afn-researching-quantity
  • afn-reserved-future-supply
  • afn-future-supply-buyable

Restock Inventory Report

reportType Value: GET_RESTOCK_INVENTORY_RECOMMENDATIONS_REPORT

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers in the following marketplaces:

  • Canada
  • US
  • Mexico
  • Spain
  • UK
  • France
  • Germany
  • Italy
  • Japan

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Provides recommendations on products to restock, suggested order quantities, and reorder dates.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • Country
  • Product Name
  • FNSKU
  • Merchant SKU
  • ASIN
  • Condition
  • Supplier
  • Supplier part no.
  • Currency code
  • Price
  • Sales last 30 days
  • Units Sold Last 30 Days
  • Total Units
  • Inbound
  • Available
  • FC transfer
  • FC Processing
  • Customer Order
  • Unfulfillable
  • Working
  • Shipped
  • Receiving
  • Fulfilled by
  • Total Days of Supply (including units from open shipments)
  • Days of Supply at Amazon Fulfillment Network
  • Alert
  • Recommended replenishment qty
  • Recommended ship date

FBA Inbound Performance Report

reportType Value: GET_FBA_FULFILLMENT_INBOUND_NONCOMPLIANCE_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Daily; every 4 hours

Contains inbound shipment problems by product and shipment.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • issue-reported-date
  • shipment-creation-date
  • fba-shipment-id
  • fba-carton-id
  • fulfillment-center-id
  • sku
  • fnsku
  • asin
  • product-name
  • problem-type
  • problem-quantity
  • expected-quantity
  • received-quantity
  • performance-measurement-unit
  • coaching-level
  • fee-type
  • currency
  • fee-total
  • problem-level
  • alert-status

FBA Stranded Inventory Report

reportType Value: GET_STRANDED_INVENTORY_UI_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Contains a breakdown of inventory in stranded status, including recommended actions.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • primary-action
  • date-stranded
  • Date-to-take-auto-removal
  • status-primary
  • status-secondary
  • error-message
  • stranded-reason
  • asin
  • sku
  • fnsku
  • product-name
  • condition
  • fulfilled-by
  • fulfillable-qty
  • your-price
  • unfulfillable-qty
  • reserved-quantity
  • inbound-shipped-qty

FBA Bulk Fix Stranded Inventory Report

reportType Value: GET_STRANDED_INVENTORY_LOADER_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Contains a list of stranded inventory. Update the listing information in this report file and then submit the file using the Flat File Inventory Loader Feed POST_FLAT_FILE_INVLOADER_DATA of the Feeds API.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • sku
  • product-id
  • product-id-type
  • price
  • minimum-seller-allowed-price
  • maximum-seller-allowed-price
  • item-condition
  • quantity
  • add-delete
  • will-ship-internationally
  • expedited-shipping
  • standard-plus
  • item-note
  • fulfillment-center-id
  • product-tax-code
  • leadtime-to-ship
  • merchant_shipping_group_name

FBA Storage Fees Report

reportType Value: GET_FBA_STORAGE_FEE_CHARGES_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can be requested or scheduled.

Report output type: Tab-delimited flat file

Contains estimated monthly inventory storage fees for each ASIN of a seller's inventory in Amazon fulfillment centers.

Select to expand list of report attributes.
  • asin
  • fnsku
  • product_name
  • fulfillment_center
  • country_code
  • longest_side
  • median_side
  • shortest_side
  • measurement_units
  • weight
  • weight_units
  • item_volume
  • volume_units
  • product_size_tier
  • average_quantity_on_hand
  • average_quantity_pending_removal
  • estimated_total_item_volume
  • month_of_charge
  • storage_rate
  • currency
  • estimated_monthly_storage_fee
  • dangerous_goods_storage_type
  • eligible_for_inventory_discount
  • qualifies_for_inventory_discount
  • total_incentive_fee_amount
  • breakdown_incentive_fee_amount
  • average_quantity_customer_orders

FBA Manage Inventory Health Report

reportType Value: GET_FBA_INVENTORY_PLANNING_DATA

Role: Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Provides a consolidated view across your sales (7, 30, 60, and 90 days), shipment statuses (working, received, and shipped), estimated storage and long-term storage fees, and aged and excess units. It includes metrics across sales, inbound, estimated fees, and recommended actions. Not available in the MX marketplace.

Select to expand list of report attributes.
  • historical-days-of-supply
  • fba-minimum-inventory-level
  • fba-inventory-level-health-status
  • snapshot-date
  • sku
  • fnsku
  • asin
  • product-name
  • condition
  • available
  • pending-removal-quantity
  • inv-age-0-to-90-days
  • inv-age-91-to-180-days
  • inv-age-181-to-270-days
  • inv-age-271-to-365-days
  • inv-age-365-plus-days
  • currency
  • qty-to-be-charged-ltsf-11-mo
  • projected-ltsf-11-mo
  • qty-to-be-charged-ltsf-12-mo
  • estimated-ltsf-next-charge
  • units-shipped-t7
  • units-shipped-t30
  • units-shipped-t60
  • units-shipped-t90
  • alert
  • your-price
  • sales-price
  • lowest-price-new-plus-shipping
  • lowest-price-used
  • recommended-action
  • healthy-inventory-level
  • recommended-sales-price
  • recommended-sale-duration-days
  • recommended-removal-quantity
  • estimated-cost-savings-of-recommended-actions
  • sell-through
  • item-volume
  • volume-unit-measurement
  • storage-type
  • storage-volume
  • marketplace
  • product-group
  • sales-rank
  • days-of-supply
  • estimated-excess-quantity
  • weeks-of-cover-t30
  • weeks-of-cover-t90
  • featuredoffer-price
  • sales-shipped-last-7-days
  • sales-shipped-last-30-days
  • sales-shipped-last-60-days
  • sales-shipped-last-90-days
  • inv-age-0-to-30-days
  • inv-age-31-to-60-days
  • inv-age-61-to-90-days
  • inv-age-181-to-330-days
  • inv-age-331-to-365-days
  • estimated-storage-cost-next-month
  • inbound-quantity
  • inbound-working
  • inbound-shipped
  • inbound-received
  • no-sale-last-6-months
  • reserved-quantity
  • unfulfillable-quantity

FBA Inventory Storage Overage Fees Report

reportType Value: GET_FBA_OVERAGE_FEE_CHARGES_DATA

Role: Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Estimated inventory storage overage fees for each storage type of your inventory in Amazon fulfillment centers that exceeds your storage limits.

Select to expand list of report attributes.
  • charged_date
  • country_code
  • storage_type
  • charge_rate
  • storage_usage_volume
  • storage_limit_volume
  • overage_volume
  • volume_unit
  • charged_fee_amount
  • currency_code

FBA Payments Reports

FBA Fee Preview Report

reportType Value: GET_FBA_ESTIMATED_FBA_FEES_TXT_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Contains the estimated Amazon Selling and Fulfillment Fees for the seller's FBA inventory with active offers. The content is updated at least once every 72 hours. To successfully generate a report, specify the StartDate parameter for a minimum 72 hours prior to NOW and EndDate to NOW.

Select to expand list of report attributes.
  • sku
  • fnsku
  • asin
  • product-name
  • product-group
  • brand
  • fulfilled-by
  • has-local-inventory
  • your-price
  • sales-price
  • longest-side
  • median-side
  • shortest-side
  • length-and-girth
  • unit-of-dimension
  • item-package-weight
  • unit-of-weight
  • product-size-weight-band
  • currency
  • estimated-fee-total
  • estimated-referral-fee-per-unit
  • estimated-variable-closing-fee
  • expected-domestic-fulfilment-fee-per-unit
  • expected-efn-fulfilment-fee-per-unit-uk
  • expected-efn-fulfilment-fee-per-unit-de
  • expected-efn-fulfilment-fee-per-unit-fr
  • expected-efn-fulfilment-fee-per-unit-it
  • expected-efn-fulfilment-fee-per-unit-es
  • expected-efn-fulfilment-fee-per-unit-se

FBA Reimbursements Report

reportType Value: GET_FBA_REIMBURSEMENTS_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Daily; every 4 hours

Contains itemized details of a seller's inventory reimbursements, including the reason for the reimbursement.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • approval-date
  • reimbursement-id
  • case-id
  • amazon-order-id
  • reason
  • sku
  • fnsku
  • asin
  • product-name
  • condition
  • currency-unit
  • amount-per-unit
  • amount-total
  • quantity-reimbursed-cash
  • quantity-reimbursed-inventory
  • quantity-reimbursed-total
  • original-reimbursement-id
  • original-reimbursement-type

FBA Long Term Storage Fee Charges Report

reportType Value: GET_FBA_FULFILLMENT_LONGTERM_STORAGE_FEE_CHARGES_DATA

Role: Pricing, Amazon Fulfillment

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Contains the charge data for long-term storage.

📘

Note:

To ensure the correctness of the report generated, the time between the dataStartTime and the dateEndTime attributes of the CreateReportSpecification should be equal to one month.

Select to expand list of report attributes.
  • snapshot-date
  • sku
  • fnsku
  • asin
  • product-name
  • condition
  • per-unit-volume
  • currency
  • volume-unit
  • country
  • qty-charged
  • amount-charged
  • surcharge-age-tier
  • rate-surcharge

FBA Concessions Reports

FBA Returns Report

reportType Value: GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Daily; every 4 hours

Contains customer returned items received at an Amazon fulfillment center, including Return Reason (reason) and Disposition (detailed-disposition).

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • return-date
  • order-id
  • sku
  • asin
  • fnsku
  • product-name
  • quantity
  • fulfillment-center-id
  • detailed-disposition
  • reason
  • status
  • license-plate-number
  • customer-comments

FBA Replacements Report

reportType Value: GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA

Role: Amazon Fulfillment

Availability: FBA sellers.

Marketplace availability: NA and IN marketplaces.

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Daily; every 4 hours

Contains replacements that have been issued to customers for completed orders. For FBA sellers only.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • shipment-date
  • sku
  • asin
  • fulfillment-center-id
  • original-fulfillment-center-id
  • quantity
  • replacement-reason-code
  • replacement-amazon-order-id
  • original-amazon-order-id

FBA Removals Reports

FBA Recommended Removal Report

reportType Value: GET_FBA_RECOMMENDED_REMOVAL_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Daily; every 4 hours

Identifies sellable items that will be 365 days old or older during the next Long-Term Storage cleanup event, if the report is generated within six weeks of the cleanup event date.

This report includes both sellable and unsellable items.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • snapshot-date
  • sku
  • fnsku
  • asin
  • product-name
  • condition
  • sellable-quantity
  • sellable-271-365-days
  • sellable-365+-days
  • sellable-removal-quantity
  • unsellable-quantity
  • unsellable-0-7-days
  • unsellable-8-60-days
  • unsellable-61-90-days
  • sellable-121-180-days
  • sellable-181-270-days

FBA Removal Order Detail Report

reportType Value: GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Contains all the removal orders, including the items in each removal order, placed during any given time period. You can use this information to reconcile the total number of items requested to be removed from an Amazon fulfillment center with the actual number of items removed, along with the status of each item in the removal order.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • request-date
  • order-id
  • order-type
  • service-speed
  • order-status
  • last-updated-date
  • sku
  • fnsku
  • disposition
  • requested-quantity
  • cancelled-quantity
  • disposed-quantity
  • shipped-quantity
  • in-process-quantity
  • removal-fee
  • currency

FBA Removal Shipment Detail Report

reportType Value: GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA

Role: Pricing, Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

Type/limit: Near-real time; every 30 minutes

Provides shipment tracking information for all removal orders and includes the items that have been removed from an Amazon fulfillment center for either a single removal order or for a date range. This report does not include canceled returns or disposed items; this report only provides shipment information.

If you request this report before the waiting period, the API returns a status of CANCELLED.

Select to expand list of report attributes.
  • request-date
  • order-id
  • shipment-date
  • sku
  • fnsku
  • disposition
  • shipped-quantity
  • carrier
  • tracking-number
  • removal-order-type

FBA Subscribe and Save Reports

Subscribe and Save Forecast Report

reportType Value: GET_FBA_SNS_FORECAST_DATA

Role: Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

The subscribe and save forecasting report provides an eight-week forecast of sales based on existing subscriptions and sales history.


Subscribe and Save Performance Report

reportType Value: GET_FBA_SNS_PERFORMANCE_DATA

Role: Amazon Fulfillment

Availability: FBA sellers

Requested/scheduled: This report can only be requested.

Report output type: Tab-delimited flat file

The subscribe and save performance report provides a trailing four-week view of items shipped, percentage of orders missed due to being out of stock, average post-discount sale price, and average discount for each SKU.