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.

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 -

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.

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 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 [e-mail] 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.

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

• 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 [e-mail] for any guidance with the setup and optimization.

Known Issues

1. Some of the APIs such as 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 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.

Change log

Affected entities	Release date	Update
SubscribeAndSaveForecastReport, SubscribeAndSavePerformanceReport	2023-03-13	New reports
SalesAndTrafficReportByChildASIN, SalesAndTrafficReportByDate, SalesAndTrafficReportyBySKU	2023-02-17	Corrected faulty parsing of null values.
PromotionsPerformanceReport	2023-02-17	API call now starts with 00:00.
VATTransactionsReport	2023-02-13	Corrected incorrect parsing of dates
FBAPromotionsReport	2023-02-10	Added 24 hour overlap of dates between batch loading
FBARestockInventoryReport	2023-02-01	Five columns added
InventoryLedgerSummaryReportByFulfillmentCentre	2023-01-23	New table
Source	2023-01-11	Table level history implemented.
SalesAndTrafficReportByChildASIN	2023-01-11	Corrected faulty report dates processing.
VATTransactionsReport	2022-12-28	Increased supported historical lookback period
All raw tables	2022-12-26	Rate limiter implemented
SalesAndTrafficReportByChildASIN	2022-12-20	New 'sku' column redacted
FBARestockInventoryReport	2022-12-20	Enabled for all marketplaces
Monthly Reports	2022-12-19	Corrected faulty mechanism used to calculating dates and run jobs in monthly reports
Source	2022-12-19	Corrected faulty parsing of DOUBLE datatype.
MarketBasketAnalysisReport, RepeatPurchaseBehaviourReport	2022-12-19	New tables added (Brand Analytics). Call the 'GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT' and 'GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT' reportTypes respectively in the Brand Analytics reports section.
SalesAndTrafficReportByDate	2022-12-14	Previously deprecated, now added back back to the list of tables that can be selected.
SalesAndTrafficReportByChildASIN	2022-12-05	New 'sku' column added.
Source	2022-12-02	User ASIN/SKU file input enabled from the backend.
Source	2022-11-22	New Belgium marketplace added.
ListingQualityAndSuppressedListingsReport	2022-11-22	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.
Source	2022-11-16	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.
FBADailyInventoryHistoryReport, FBAMonthlyInventoryHistoryReport, FBAInventoryEventDetailReport, FBAInventoryAdjustmentsReport, FBAInventoryReconciliationReport, FBAReceivedInventoryReport, FBAInventoryHealthReport, FBAInventoryAgeReport	2022-11-16	Deprecated. New and existing integrations will be unable to add them if not added. Support will be slowly be discontinued for existing tables. Replacement tables are InventoryLedgerSummaryReport, InventoryLedgerDetailedReport and FBAManageInventoryHealthReport.
SalesAndTrafficReportByDate, SalesAndTrafficReportByParentASIN	2022-11-16	Deprecated. New and existing integrations will be unable to add them if not added. Support will be slowly be discontinued for existing tables. SalesAndTrafficReportByChildASIN will be the only supported report.
All dependent raw tables	2022-11-16	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.
ListFinancialEventsByGroupId	2022-11-14	Corrected faulty passing of groupIDs as null.
APlusContentDocument	2022-11-09	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 getContentDocument operation from the A+ Content API.
ListingsItemsIssues/ ListingsItemsSummary	2022-10-26	Pass failing skus into destination with nulls in all fields instead of failing entire job.
FBAStorageFeesReport	2022-10-25	Move dates forward when report for a date range is cancelled. Call monthly data everyday until next month.
CatalogItems	2022-10-21	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 getCatalogItem operation in the Catalog Items API.
VATTransactionsReport	2022-10-20	Corrected faulty parsing of dates into YYYY-MM-DD format.
SalesAndTrafficReportByChildASIN	2022-10-10	Increased lookback window, faster historical data processing.
InboundShipmentsTransportDetails	2022-10-03	New table added. Gives details about fulfillment inbound shipments including weight, dimensions and value data about partnered and non partnered data. Calls the getTransportDetails operation in the Fulfillment API.

The Amazon APIs incident

Amazon published an incident related to the Orders, Finances and Reports API on 8th Jan 2023.

Refer: Selling Partner API - Health Dashboard

FAQs for the Amazon APIs incident

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. Click here 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?

   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?

   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.

   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.