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

# Inventory 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 - Inventory 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)
* [Inventory Reports](https://developer-docs.amazon.com/sp-api/docs/report-type-values#inventory-reports)

## Entity Relationship Diagram (ERD)

[Click here to view the ERD for the Daasity Amazon Seller Central - Reports API - Inventory integration](https://lucid.app/documents/embedded/95af43b8-02b7-4878-aab2-9135c7f04b52) 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.

* [All Listings Report](#all-listings-report)

### **All Listings Report**

* This report provides data on all the products you have listed on Amazon and includes details about each listing, including condition, item-note, and BMVD (Book, Music, Video and DVD) shipping setting
* Endpoint: [Inventory Reports](https://developer-docs.amazon.com/sp-api/docs/report-type-values#inventory-reports)
* Update Method: UPSERT
* Table Name:\
  \[`AMAZON_SELLER_CENTRAL.GET_MERCHANT_LISTINGS_ALL_DATA`]

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

* Can only be extracted every 24 hours.
* Amazon updates data daily.
* Amazon puts restrictions on pulling historical reports, which can take a prolonged period of time.
  * To learn more about requesting historical reports, reach out to <Support@Daasity.com>
    {% endhint %}