Fulfillment by Amazon (FBA) Report Type Values

FBA Amazon Fulfilled Shipments Report (Invoicing)

reportType value:
GET_AMAZON_FULFILLED_SHIPMENTS_DATA_INVOICING

For FBA sellers only.

Tab-delimited flat file report. This report should be used to generate tax invoices in the EU region. You can request up to one month of data in a single report. Content updated in near-real time in Europe (EU), Japan, and North America (NA).

Note: In most cases, there will be a delay of approximately one to three hours from the time a fulfillment order ships and the time the items in the fulfillment order appear in the report. In some rare cases there could be a delay of up to 24 hours.

Can be requested.

Flat File All Orders Report by Last Update

reportType value:
GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL

For all sellers.

Tab-delimited flat file report. 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.

Can be requested.

XML All Orders Report by Last Update

reportType value:
GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL

For all sellers.

XML file order report that 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.

Can be requested.

FBA Customer Shipment Sales Report

reportType value:
GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_SALES_DATA

For FBA sellers only.

Tab-delimited flat file report. Contains condensed item level data on shipped FBA customer orders including price, quantity, and ship to location. Content updated in near-real time in Europe (EU), Japan, and North America (NA).

Note: In Japan, EU, and NA, in most cases, there will be a delay of approximately one to three hours from the time a fulfillment order ships and the time the items in the fulfillment order appear in the report. In some rare cases there could be a delay of up to 24 hours.

Can be requested.

FBA Customer Taxes

reportType value:
GET_FBA_FULFILLMENT_CUSTOMER_TAXES_DATA

For FBA sellers only.

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.

Can be requested.

FBA Amazon Fulfilled Inventory Report

reportType value:
GET_AFN_INVENTORY_DATA

For FBA sellers only.

Tab-delimited flat file report. Content updated in near-real time.

Can be requested.

Inventory Ledger Report - Summary View

reportType value:
GET_LEDGER_SUMMARY_VIEW_DATA

Tab-delimited flat file report. 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, StartDate is 2023-01-15T00:00:00+00:00 and EndDate 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. StartDate must be set to first of the month and EndDate must be set to last day of the month to get monthly data. For example, StartDate of 2022-12-01T00:00:00+00:00 and EndDate 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. StartDate and EndDate must be start and end of the week to get weekly data. For example, StartDate is 2023–01-09T00:00:00+00:00 and EndDate 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 startDate/endDate 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 startDate/endDate for appropriate aggregatedByTimePeriod filter options).

Can be requested.

FBA Reserved Inventory Report

reportType value:
GET_RESERVED_INVENTORY_DATA

For FBA sellers only.

Tab-delimited flat file report. Provides data about the number of reserved units in a seller's inventory. Content updated in near-real time.

Can be requested.

FBA Manage Inventory - Archived

reportType value:
GET_FBA_MYI_ALL_INVENTORY_DATA

For FBA sellers only.

Tab-delimited flat file report. Contains current details of all (including archived) inventory including condition, quantity, and volume. Content updated in near-real time.

Can be requested.

FBA Inbound Performance Report

reportType value:
GET_FBA_FULFILLMENT_INBOUND_NONCOMPLIANCE_DATA

For FBA sellers only.

Tab-delimited flat file report. Contains inbound shipment problems by product and shipment. Content updated daily.

Can be requested.

FBA Bulk Fix Stranded Inventory Report

reportType value:
GET_STRANDED_INVENTORY_LOADER_DATA

For FBA sellers only.

Tab-delimited flat file report. 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. Content updated in near-real time.

Can be requested.

Get Report Exchange Data

reportType value:
GET_PRODUCT_EXCHANGE_DATA

Tab-delimited flat file report that contains product exchange information for the specified time duration.

Can be requested.

FBA Inventory Storage Overage Fees Report

reportType value:
GET_FBA_OVERAGE_FEE_CHARGES_DATA

Available to FBA sellers with the Amazon Fulfillment role.

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.

Can be requested.

FBA Fee Preview Report

reportType value:
GET_FBA_ESTIMATED_FBA_FEES_TXT_DATA

For FBA sellers only.

Tab-delimited flat file report. 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.

Can be requested.

FBA Long Term Storage Fee Charges Report

reportType value:
GET_FBA_FULFILLMENT_LONGTERM_STORAGE_FEE_CHARGES_DATA

Tab-delimited flat file report that contains the charge data for long-term storage.

Can be requested.

FBA Returns Report

reportType value:
GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA

For FBA sellers only.

Tab-delimited flat file report. Contains customer returned items received at an Amazon fulfillment center, including Return Reason and Disposition. Content updated daily.

Can be requested.

FBA Recommended Removal Report

reportType value: GET_FBA_RECOMMENDED_REMOVAL_DATA

For FBA sellers only.

Tab-delimited flat file report. This report 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. Content updated daily.

Can be requested.

FBA Removal Shipment Detail Report

reportType value:
GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA

For FBA sellers only.

Tab-delimited flat file report. This report 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 will not include canceled returns or disposed items; it is only for shipment information. Content updated in near-real time.

Can be requested.

Small & Light Inventory Report

reportType value:
GET_FBA_UNO_INVENTORY_DATA

Tab-delimited flat file report. Contains all of a seller's products that are enrolled in the Small & Light program and how much inventory they currently have in Small & Light fulfillment centers. The report also shows the seller's current prices and whether any of their products are in unsellable status.

Can be requested.

Subscribe and Save Forecast Report

reportType value:
GET_FBA_SNS_FORECAST_DATA

Available to FBA sellers with the Amazon Fulfillment role.

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

Can be requested.