> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/amazon-seller-central/integration-specifications/fba-customer-concessions-reports.md).

# FBA Customer Concessions Reports

## Integration Overview

The Daasity Amazon Seller Central integrations utilize the Selling Partner API (SP-API) which is a REST-based API that helps Amazon selling partners programmatically access their data on orders, shipments, payments, and more.

## Integration Availability

This integration is available for:

* Enterprise

## API Endpoints

The Daasity Amazon Seller Central - Reports API - FBA Customer Concessions extractor is built based on this [Amazon Seller Central API documentation](https://developer-docs.amazon.com/sp-api/docs/what-is-the-selling-partner-api). The following endpoints are used by Daasity to replicate data from Amazon Seller Central:

* [Reports](https://developer-docs.amazon.com/sp-api/docs/reports-api-v2021-06-30-reference)
* [Fulfillment by Amazon (FBA) Reports](https://developer-docs.amazon.com/sp-api/docs/report-type-values#fulfillment-by-amazon-fba-reports)

## Entity Relationship Diagram (ERD)

[Click here to view the Daasity Amazon Seller Central - Reports API - FBA Customer Concessions integration](https://lucid.app/documents/embedded/6a00b96a-8b12-46cd-a5bc-33cf9ea91e4b) illustrating the different tables and keys to join across tables.

## Amazon Seller Central Schema

The Reports API will generate files in one of three formats (CSV, XML, and JSON). A report might vary slightly for each Seller Central account and thus Daasity will dynamically create the table based on the file extracted from Amazon. Thus each table will be a direct mapping from the file output to the table with no transformation.

* [FBA Returns Report](#fba-returns-report)
* [FBA Replacements Report](#fba-replacements-report)

### **FBA Returns Report**

* This report provides data on how many units of a SKU or set of SKUs have been returned and credited to your inventory balance.
* Endpoint: [FBA Reports](https://developer-docs.amazon.com/sp-api/docs/report-type-values#fulfillment-by-amazon-fba-reports)
* Update Method: UPSERT
* Table Name:\
  \[`AMAZON_SELLER_CENTRAL.GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA`]

{% hint style="info" %}
**Limitations:**

* Daasity extracts data every 24 hours.
* Amazon updates data daily.
  {% endhint %}

### **FBA Replacements Report**

* This report provides data on replacements that have been issued to customers for completed orders including the original order, the replacement order, and the reason for the replacement.
* Endpoint: [FBA Reports](https://developer-docs.amazon.com/sp-api/docs/report-type-values#fulfillment-by-amazon-fba-reports)
* Update Method: UPSERT
* Table Name:\
  \[`AMAZON_SELLER_CENTRAL.GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA`]

{% hint style="info" %}
**Limitations:**

* Daasity extracts data every 24 hours.
* Amazon updates data daily.
  {% endhint %}