> 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-sales-reports.md).

# FBA Sales 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 Sales 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 ERD for the Daasity Amazon Seller Central - Reports API - FBA Sales integration](https://lucid.app/documents/embedded/82aba545-63e1-415e-9a9d-98744e98e643) 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 Promotions Report](#fba-promotions-report)

### **FBA Promotions Report**

* This report contains promotions applied to FBA customer orders sold through Amazon, such as Super Saver Shipping.
* 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_PROMOTION_DATA`]

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

* Can only be extracted every 24 hours.
* Amazon data is updated daily.
  {% endhint %}

<br>