# Amazon Selling Partner

Amazon Selling Partner is the new replacement for the to-be-deprecated Amazon MWS API, offering better reporting and organization of data.&#x20;

### Pre-requisite steps

If you are using a non-admin account to configure your SP-API connections, please make sure the user account being used to authenticate has the following permissions -&#x20;

<figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2Fx5AvDlGiAiWdbDayCZ0v%2F2022-10-21%20at%203.37%20PM.png?alt=media&#x26;token=327cf430-4da2-4afd-b764-e934e7037fdf" alt=""><figcaption></figcaption></figure>

<figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FD7WWnfPVoiVUvq4NEedb%2F2022-10-21%20at%203.38%20PM.png?alt=media&#x26;token=d14b1b4e-a2dc-4d09-8840-fc269edfaad4" alt=""><figcaption></figcaption></figure>

<figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FCrtHDFAwosrnyY5S8bpF%2F2022-10-21%20at%203.39%20PM.png?alt=media&#x26;token=179aac43-7c93-40ff-b9e9-ad888619154d" alt=""><figcaption></figcaption></figure>

<figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FGfMtoAmtWnF4Z7VsxiQF%2F2022-10-21%20at%203.39%20PM.png?alt=media&#x26;token=1d100c3f-49d2-4640-9848-260425e49891" alt=""><figcaption></figcaption></figure>

<figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FFOvwObflkHNo6mLr9JD6%2F2022-10-21%20at%203.39%20PM.png?alt=media&#x26;token=79756696-9413-4e38-aad3-34617ceff578" alt=""><figcaption></figcaption></figure>

<figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FwTeAZjqWMoiVApZm4p9K%2F2022-10-21%20at%203.40%20PM.png?alt=media&#x26;token=b9a8532a-4af6-4bcc-a99c-46ebbbc32fc6" alt=""><figcaption></figcaption></figure>

### How to make an Amazon Selling Partner Integration in Daton?

1. Log in to Daton. If you don't have previous credentials, sign up for Daton.
2. Assuming you have configured your destination, search "Amazon Selling Partner" in the search bar and click configure on the integration that appears. If not, configure your data warehouse first. [Daton supports several data destinations.](https://docs.sarasanalytics.com/integrations/destinations)&#x20;
3. Provide Integration Name, Replication Frequency, History, and Marketplace. Integration name would be used while creating tables on the warehouse and cannot be changed later. See [general guidelines](#general-guidelines-for-configuring-amazon-selling-partner-connector-on-daton) if you are unsure of which option to pick.
4. Click the 'Authenticate' button. You will be taken to Amazon's Seller Central login page to authorize Daton to access data from Amazon's SP-API. Allow Daton to access the scopes and authorize the Daton app.
5. If you prefer to not use the primary account, you will need to give access to a set of permissions on Amazon in order to authorize Daton. Contact <support@sarasanalytics.com> to learn more.
6. After authentication, you will be prompted to choose from the list of available tables. Select the required tables and columns.
7. Submit the integration. You can now view the tables being created in your data destination by the name given to your integration.

### &#x20;What happens next?

1. Click on your integration in the 'Sources' page to see the status of each table.
2. Click on a table to see its status. The jobs would be in pending state initially and then will be moved to Active state once data starts flowing into the destination.
3. Job status can be viewed at any time. You can also edit the integration to change frequency and history.

### General guidelines for configuring Amazon Selling Partner Connector on Daton <a href="#general-guidelines" id="general-guidelines"></a>

* Select frequency as 1 hour. This will ensure fastest replication of historical data.
* Historical data replication happens in batches and it will take a few jobs for the data to be replicated up until current day
* Select the duration of history based on availability of data, i.e. for the period the business has been active.
* Reach out to <support@sarasanalytics.com> for any guidance with the setup and optimization.

### Known Issues

1. &#x20;Some of the APIs such as [fba-inventory-api](https://github.com/amzn/selling-partner-api-docs/tree/main/references/fba-inventory-api) are not available for all marketplaces. Refer to each report category for detailed list of availability.
2. Authentication while creating integrations on Daton must be done using the primary seller account only.
3. Transaction (Payments) reports are not available through APIs. Reach out to our [support](https://support.sarasanalytics.com/) for alternatives.
4. In case Business Reports (SalesAndTrafficReports) are being added while editing the integration post its creation, you will have to re-authenticate the integration since Daton requires a new set of permissions to access Business Reports.&#x20;

### Change log

<table><thead><tr><th width="245">Affected entities</th><th width="129.66666666666666">Release date</th><th>Update</th></tr></thead><tbody><tr><td>SubscribeAndSaveForecastReport, SubscribeAndSavePerformanceReport</td><td>2023-03-13</td><td>New reports</td></tr><tr><td>SalesAndTrafficReportByChildASIN, SalesAndTrafficReportByDate, SalesAndTrafficReportyBySKU</td><td>2023-02-17</td><td>Corrected faulty parsing of null values.</td></tr><tr><td>PromotionsPerformanceReport</td><td>2023-02-17</td><td>API call now starts with 00:00. </td></tr><tr><td>VATTransactionsReport</td><td>2023-02-13</td><td>Corrected incorrect parsing of dates</td></tr><tr><td>FBAPromotionsReport</td><td>2023-02-10</td><td>Added 24 hour overlap of dates between batch loading</td></tr><tr><td>FBARestockInventoryReport</td><td>2023-02-01</td><td>Five columns added</td></tr><tr><td>InventoryLedgerSummaryReportByFulfillmentCentre</td><td>2023-01-23</td><td>New table</td></tr><tr><td>Source</td><td>2023-01-11</td><td>Table level history implemented. </td></tr><tr><td>SalesAndTrafficReportByChildASIN</td><td>2023-01-11</td><td>Corrected faulty report dates processing.</td></tr><tr><td>VATTransactionsReport</td><td>2022-12-28</td><td>Increased supported historical lookback period</td></tr><tr><td><a href="https://docs.sarasanalytics.com/integrations/data-sources/ecommerce/amazon-seller-partner/all-report-types-and-tables#report-types">All raw tables</a></td><td>2022-12-26</td><td>Rate limiter implemented</td></tr><tr><td>SalesAndTrafficReportByChildASIN</td><td>2022-12-20</td><td>New 'sku' column redacted</td></tr><tr><td>FBARestockInventoryReport</td><td>2022-12-20</td><td>Enabled for all marketplaces</td></tr><tr><td><a href="https://docs.sarasanalytics.com/integrations/data-sources/ecommerce/amazon-seller-partner/all-report-types-and-tables#report-types">Monthly Reports</a></td><td>2022-12-19</td><td>Corrected faulty mechanism used to calculating dates and run jobs in monthly reports</td></tr><tr><td>Source</td><td>2022-12-19</td><td>Corrected faulty parsing of DOUBLE datatype.</td></tr><tr><td>MarketBasketAnalysisReport, RepeatPurchaseBehaviourReport</td><td>2022-12-19</td><td>New tables added (Brand Analytics). Call the 'GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT' and 'GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT' reportTypes respectively in the <a href="https://developer-docs.amazon.com/sp-api/docs/report-type-values#brand-analytics-reports">Brand Analytics reports</a> section. </td></tr><tr><td>SalesAndTrafficReportByDate</td><td>2022-12-14</td><td>Previously deprecated, now added back back to the list of tables that can be selected.</td></tr><tr><td>SalesAndTrafficReportByChildASIN</td><td>2022-12-05</td><td>New 'sku' column added.</td></tr><tr><td>Source</td><td>2022-12-02</td><td><a href="https://docs.sarasanalytics.com/faqs/faqs/steps-to-upload-your-own-asin-and-sku-file">User ASIN/SKU file input enabled from the backend. </a></td></tr><tr><td>Source</td><td>2022-11-22</td><td>New Belgium marketplace added. </td></tr><tr><td>ListingQualityAndSuppressedListingsReport</td><td>2022-11-22</td><td>Deprecated. New and existing integrations will be unable to add them if not added. Support will be slowly be discontinued for existing tables. The replacement table is available on Daton under the name SuppressedListingsReport.</td></tr><tr><td>Source</td><td>2022-11-16</td><td>ActiveListingsReport to be used as the default reference table for ASINs and SKUs in new integrations. This will also be in effect for integrations with this report already selected in the list of tables. For integrations without this table added, AllListingsReport will continue to be the reference table for ASINs and SKUs.</td></tr><tr><td><p>FBADailyInventoryHistoryReport, FBAMonthlyInventoryHistoryReport, FBAInventoryEventDetailReport, FBAInventoryAdjustmentsReport,</p><p>FBAInventoryReconciliationReport,  FBAReceivedInventoryReport, FBAInventoryHealthReport, FBAInventoryAgeReport</p></td><td>2022-11-16</td><td>Deprecated. New and existing integrations will be unable to add them if not added. Support will be slowly be discontinued for existing tables. <a href="https://docs.sarasanalytics.com/faqs/faqs/amazon-business-and-inventory-reports-faqs#mapping-of-soon-to-be-deprecated-inventory-reports">Replacement tables are InventoryLedgerSummaryReport, InventoryLedgerDetailedReport and FBAManageInventoryHealthReport</a>.</td></tr><tr><td>SalesAndTrafficReportByDate, SalesAndTrafficReportByParentASIN</td><td>2022-11-16</td><td>Deprecated. New and existing integrations will be unable to add them if not added. Support will be slowly be discontinued for existing tables. <a href="https://docs.sarasanalytics.com/faqs/faqs/how-exactly-do-business-reports-work-in-daton">SalesAndTrafficReportByChildASIN will be the only supported report.</a></td></tr><tr><td><a href="https://docs.sarasanalytics.com/faqs/faqs/steps-to-upload-your-own-asin-and-sku-file#which-tables-require-asin-sku-input">All dependent raw tables</a></td><td>2022-11-16</td><td>Batching logic implemented to restrict the number of ASINs passed to dependent tables in each job. This change reduces job duration, mitigates data loss in case of ASIN errors and reduces rate limit errors.</td></tr><tr><td>ListFinancialEventsByGroupId</td><td>2022-11-14</td><td>Corrected faulty passing of groupIDs as null.</td></tr><tr><td>APlusContentDocument</td><td>2022-11-09</td><td>New table added. Gives details about the collateral used in a Seller's A+ Content page including product description, image upload destination, image text, tech specs etc. Calls the <a href="https://developer-docs.amazon.com/sp-api/docs/selling-partner-api-for-a-content-management#getcontentdocument">getContentDocument</a> operation from the A+ Content API.</td></tr><tr><td><p>ListingsItemsIssues/</p><p>ListingsItemsSummary</p></td><td>2022-10-26</td><td>Pass failing skus into destination with nulls in all fields instead of failing entire job.</td></tr><tr><td>FBAStorageFeesReport</td><td>2022-10-25</td><td>Move dates forward when report for a date range is cancelled. Call monthly data everyday until next month.</td></tr><tr><td>CatalogItems</td><td>2022-10-21</td><td>New table added. Cannot be used in conjunction with CatalogItemsVariations, CatalogItemsSalesRank, CatalogItemsSummary tables. Gives details about items in a Seller's catalog including data about attributes, dimensions, images, salesRanks etc. Calls the <a href="https://developer-docs.amazon.com/sp-api/docs/catalog-items-api-v2022-04-01-reference#getcatalogitem">getCatalogItem</a> operation in the Catalog Items API. </td></tr><tr><td>VATTransactionsReport</td><td>2022-10-20</td><td>Corrected faulty parsing of dates into YYYY-MM-DD format.</td></tr><tr><td>SalesAndTrafficReportByChildASIN</td><td>2022-10-10</td><td><a href="https://docs.sarasanalytics.com/faqs/faqs/how-exactly-do-business-reports-work-in-daton">Increased lookback window, faster historical data processing.</a></td></tr><tr><td>InboundShipmentsTransportDetails</td><td>2022-10-03</td><td>New table added. Gives details about fulfillment inbound shipments including weight, dimensions and value data about partnered and non partnered data. Calls the <a href="https://developer-docs.amazon.com/sp-api/docs/fulfillment-inbound-api-v0-reference#gettransportdetails">getTransportDetails</a> operation in the Fulfillment API. </td></tr></tbody></table>

### The Amazon APIs incident&#x20;

**Amazon published an incident related to the Orders, Finances and Reports API on 8th Jan 2023.**&#x20;

Refer: [Selling Partner API - Health Dashboard](https://sellercentral.amazon.com/sp-api-status)

### FAQs for the Amazon APIs incident&#x20;

1. **How is it relevant to us?**\
   \
   An issue was found from the Orders API that affected the Finances and Reports API where the order item ID in orders used to get changed every time there was a status update. This means that if the status was changed three times, there would be four order item IDs overall. Now if you calculate your revenue based on the number of order item ids, this will give you 3x of the actual sales.\
   \
   Tables without order item IDs still have inflated sales numbers as the data for those tables comes from the raw Orders API data.\\

2. **What are its impacts on billing?**\
   \
   Depending on the number of rows that are going to be extracted, it can go over the quota for your tier.\
   \&#xNAN;*Click* [*here*](https://daton-sarasanalytics.gitbook.io/daton/~/changes/nunm1uwBsHvoNsFSts9M/platform/essentials/billing) *to read more about the billing plans.*\\

3. **My data looks fine, I don't want Daton to fetch data from December 15, 2022.**\
   \
   If that is the case, please email support\@sarasanalytics before Friday 12 PM UTC and we can take off your list of source ids from our cleanup efforts.\\

4. **What columns are affected by the incident?**

   &#x20;\
   All the columns from the tables `OrderItemId`, `quantity`, `item_status`, and `itemPrice` have been affected.\\

5. **How do I know if my data has been affected?**

   &#x20;

   If you are a seller who is not based in the US region (US, MX, BR, CA), it is unlikely that this issue has impacted you. However, just to be sure we will perform fetch data for all regions.

   &#x20;

   To check a discrepancy, you can download a business report from your console for Jan 10 and compare it with data for Jan 10 fetched between Jan 11 - Jan 15. If the sales numbers are extremely inflated, then there is a high chance that you have been affected by the issue.
