LogoLogo
Daton
Daton
  • Daton Defined: From Web App Essentials to Advanced Integrations
  • Platform
    • Essentials
      • Billing
      • Integrate Facebook Ads on Daton
      • Integrate Shopify on Daton
      • Integrate Google Analytics on Daton
      • Access permissions for Daton
      • How to get started with Daton setup
      • Terminology in Daton
        • Source and Source_Table statuses
      • Various pages in Daton
    • Features
      • Navigating the pages in Daton
        • Notifications
        • Logs
        • Dashboard
        • My Account
        • Connectors
        • My Integrations
        • Integration Details
      • Templates
      • Account Management
        • My Account Page
      • Notifications
      • Monitoring
        • Logging and Log Retention
      • Manage Integrations
        • Handling Changes to Schema
        • Modifying an integration
      • Data
        • Handling Nested Data
        • Daton Metadata
        • Inserts, Updates, and Upserts
        • Data Type Mapping
        • Data Replication in Daton
          • Replication Fields
          • Replication Methods
            • Key-based Incremental Replication
      • Knowledge Base
        • What is ELT and how is it different from traditional ETL tools
          • Billing
      • Pipelines
        • Pipeline Jobs
        • Loading Behavior
      • Security
      • Feature Updates
        • Amazon Vendor Central
  • Connectors
    • Data Sources
      • Advertising
        • Adjust v1
        • Adjust v2
          • About Adjust v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Adjust v2 with Daton
          • Schema Information
        • Amazon Ads
          • Release Notes
        • Amazon Attribution
          • Release Notes
        • Amazon Brand Metrics
          • About Amazon Brand Metrics
          • Essential Attributes and Supported Tables
          • How to Integrate Amazon Brand Metrics with Daton
          • Schema Infomation
        • Amazon DSP V1
          • Release Notes
        • Amazon DSP V2
        • Amazon Marketing Cloud (AMC)
        • Amazon Marketing Streams
          • About Amazon Marketing Streams Connector
          • Essential Attributes
          • How to Integrate Amazon Marketing Streams with Daton
          • Release Notes
        • Amazon Sponsored Brand Ads
          • Release Notes
        • Amazon Sponsored Display Ads
          • Release Notes
        • Amazon Sponsored Product Ads
          • Release Notes
        • Amazon Sponsored TV Ads
        • Bing Ads
          • Release Notes
        • Bol Ads
          • Release Notes
        • Facebook Ads
          • Release Notes
        • Google Ads
          • Release Notes
        • Google My Business
        • Google My Business v2
          • About Google My Business v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Google Business Profile Account with Daton
          • Schema Information
        • Gorgias
        • Gorgias V2
        • HelpScout
        • HelpScout v2
          • About HelpScout Platform
          • Essential Attributes and Supported Tables
          • How to Integrate HelpScout with Daton
          • Schema Information
          • Release Notes
        • Outbrain
          • Release Notes
        • Outbrain v2
          • About Outbrain Platform
          • Essential Attributes & Supported Tables
          • How to Integrate Outbrain v2 with Daton
          • Schema Information
        • Pinterest v2
          • About Pinterest v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pinterest v2 with Daton
          • Schema Information
        • Rakuten
          • About Rakuten Connector
          • Essential Attributes
          • How to Integrate Rakuten with Daton
        • StackAdapt
          • About StackAdapt Platform
          • Essential Attributes and Supported Tables
          • How to Integrate StackAdapt with Daton
          • Schema Information
        • Typeform
          • About Typeform Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Typeform with Daton
          • Schema Information
        • Upscribe
          • Release Notes
        • Upscribe V2
          • About Upscribe Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Upscribe v2 with Daton
          • Schema Information
      • Analytics Platforms
        • Appsflyer
        • GA4
          • About Google Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate GA4 with Daton
          • Schema Information
        • Google Analytics
          • Release Notes
        • Jungle Scout
        • Northbeam
          • About Northbeam Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Northbeam with Daton
          • Schema Information
        • Prodco Analytics
          • About Prodco Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate Prodco Analytics Account with Daton
          • Schema Information
        • Rainforest
          • About Rainforest Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rainforest Account with Daton
          • Schema Information
        • Sprout Social
          • About Sprout Social Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Sprout Social with Daton
          • Schema Information
        • Taboola
        • Taboola v2
          • About Taboola v2
          • Essential Attributes and Supported Tables
          • How to Integrate Taboola v2 with Daton
          • Schema Information
        • Edge by Ascential
      • Business
        • ClickUp
          • About ClickUp Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ClickUp with Daton
          • Schema Information
        • Bubble
        • Pipedrive
          • About Pipedrive Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pipedrive with Daton
          • Schema Information
        • Teamwork
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork with Daton
          • Schema Information
        • Teamwork v2
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork v2 with Daton
          • Schema Information
        • TikTok Business
          • About TikTok Business Connector
          • Essential Attributes and Supported Tables
          • How to Integrate TikTok Business with Daton
          • Schema Information
        • Unbounce v2
          • About Unbounce v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unbounce v2 with Daton
          • Schema Information
      • Call Center
        • Aircall
        • Callpage
        • JustCall
          • About JustCall Connector
          • Essential Attributes and Supported Tables
          • How to Integrate JustCall with Daton
          • Schema Information
      • Databases
        • Amazon Aurora MySQL
          • About Amazon Aurora Platform
          • Essential Attributes
          • How to Integrate Amazon Aurora with Daton
        • Amazon Redshift
          • About Amazon Redshift Platform
          • Essential Attributes
          • How to Integrate Amazon Redshift with Daton
        • GCP MySQL
          • About GCP MySQL Platform
          • Essential Attributes
          • How to Integrate GCP MySQL with Daton
        • GCP PostgreSQL
          • Setup Manual
        • Magento (DB)
          • About Magento Connector
          • Essential Attributes
          • How to Integrate Magento with Daton
        • MySQL
          • Release Notes
        • NetSuite
        • PostgreSQL
          • Release Notes
        • SQLServer
        • WooCommerce SQL
          • About WooCommerce SQL Platform
          • Essential Attributes
          • How to Integrate WooCommerce SQL with Daton
      • Daton Connector
        • Release Notes
      • Ecommerce Platforms
        • Amazon MWS
          • Release Notes
        • Amazon Selling Partner
          • All Report Types and Tables
          • Release Notes
        • Amazon Vendor Central
          • All Report Types and Tables
          • Real Time Reports
          • Daily Reports
          • Weekly Reports
          • Snapshot Reports
          • Monthly Reports
          • Raw Tables
          • Release Notes
        • Bigcommerce
        • BigCommerce v2
          • About BigCommerce Platform
          • Essential Attributes and Supported Tables
          • How to Integrate BigCommerce Account with Daton
          • Schema Information
          • Release Notes
        • Bol Retail v2
          • Release Notes
        • Capillary Martjack
          • Release Notes
        • Kaufland
          • About Kaufland Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Kaufland with Daton
          • Schema Information
        • Keepa
          • About Keepa Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Keepa with Daton
          • Schema Information
        • Lazada
        • Loopreturns
          • Release Notes
        • Magento
          • Release Notes
        • Magento 2 (APIs)
          • Release Notes
        • Mercado Libre
          • About Mercado Libre Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Mercado Libre with Daton
          • Schema Information
        • Shopify
          • Access tokens for Shopify
          • Release Notes
        • Shopify V2
        • Walmart
          • Release Notes
        • Walmart_v2
          • Release Notes
        • WooCommerce
      • Files
        • Amazon S3
          • Release Notes
        • Dropbox
          • Release Notes
        • Email Attachments
          • About Email Attachments Connector
          • Essential Attributes and Connector Guidelines
          • How to Integrate Email Attachments with Daton
        • Google Cloud Storage
          • Release Notes
        • Google Drive
        • Google Sheets
          • Release Notes
        • SFTP (SSH File Transfer Protocol)
      • OMS/WMS
        • Cin7
        • Goflow
          • About Goflow Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Goflow with Daton
          • Schema Information
        • Rippling
          • About Rippling Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rippling with Daton
          • Schema Information
      • Payments
        • PayPal
          • About PayPal Connector
          • Essential Attributes and Supported Tables
          • How to Integrate PayPal with Daton
          • Schema Information
        • Razorpay
          • About Razorpay Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Razorpay with Daton
          • Schema Information
        • Razorpay v1
        • Stripe
      • Productivity Trackers
        • GitLab
          • Release Notes
        • Time Doctor
          • Release Notes
      • SaaS Integrations
        • Aftership
          • Release Notes
        • Aftership V2
        • Anvyl
        • Ascend
        • Awtomic
          • Release Notes
        • Braintree
          • About Braintree Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Braintree Account with Daton
          • Schema Information Braintree
        • Calendly
          • Release Notes
        • Calendly V2
        • Campaign Monitor
        • Capsule CRM
        • Chargebee
        • Freshworks CRM
        • Loop Subscription
        • Commission Junction
        • Constant Contact
        • Copper CRM
          • About Copper
          • Essential Attributes and Supported Tables
          • How to Integrate Copper Account with Daton
          • Schema Information
          • Release Notes
        • Criteo
        • Criteo Retail Media
        • Customer.io
        • DotDigital
        • dotdigital V2
        • Easyecom
        • EasyEcom V2
          • Release Notes
        • ePallet ERP
        • Etsy
        • Exchange Rates
          • About Exchange Rate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Exchange Rates with Daton
          • Schema Information
          • Release Notes
        • Fairing (previously EnquireLabs)
          • Release Notes
        • FreshBooks
          • Release Notes
        • Freshdesk
          • Release Notes
        • Freshsales
          • Release Notes
        • Fulfil
        • Gladly
          • Release Notes
        • Google Search Console
          • Release Notes
        • HubSpot
          • Release Notes
        • HubSpot v2
          • About HubSpot v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate HubSpot v2 with Daton
          • Schema Information
        • Impact
          • Release Notes
        • Infusionsoft (now Keap Max Classic)
          • About Infusionsoft Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Infusionsoft with Daton
          • Schema Information
        • Insightly
        • Intercom
          • Release Notes
        • Intercom V2
          • Release Notes
        • Outbrain V2 (Old)
          • Release Notes
        • Inventory Planner
        • Jira
        • JudgeMe
          • Release Notes
        • Kibo Commerce
        • Klaviyo
          • Release Notes
        • Klaviyo V2
          • Release Notes
        • Kustomer
        • LeadSquared CRM
        • LeadSquared V2
        • LinkedIn Ads
        • LiveChat
        • LoyaltyLion
        • MailChimp
          • Release Notes
        • MNTN
        • Monday
        • NewRelic
        • Okendo Reviews
          • About Okendo Reviews Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Okendo Reviews with Daton
          • Schema Information
        • Optimove
          • Release Notes
        • Pingdom
        • Pinterest
        • Pipedrive
        • PushEngage
        • Quickbase
        • QuickBooks
        • Quickbooks v2
          • About Quickbooks Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Quickbooks v2 with Daton
          • Schema Information
        • Re:amaze
        • ReCharge Payments
          • Release Notes
        • ReCharge Payments v1
          • Setup Manual
          • Schema Information
        • Recharge Payments V2
          • Setup Manual
          • Schema Information
        • Reviewmonitoring
          • Release Notes
        • Salsify
          • Release Notes
        • SendGrid
          • Release Notes
        • Shiphero
        • Shippo
        • Shiprocket
          • Release Notes
        • Shiprocket v2
          • About Shiprocket Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Shiprocket with Daton
          • Schema Information
        • Shipstation
          • Release Notes
        • Skubana
        • SkuVault
          • About SkuVault Connector
          • Essential Attributes and Supported Tables
          • How to Integrate SkuVault with Daton
          • Schema Information
        • Smartrr
        • Smartrr v2
          • About Smartrr Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Smartrr v2 with Daton
          • Schema Information
        • Stamped.io
          • About Stamped.io Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Stamped.io with Daton
          • Schema Information
        • Stamped.io v1
        • Stay AI
        • Sticky.io
        • SugarCRM
          • Release Notes
        • Survey Monkey
        • Tune
        • Unbounce
        • Unicommerce
        • Unicommerce
          • About Unicommerce Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unicommerce with Daton
          • Schema Information
          • Release Notes
        • When I Work
        • Xero
        • Xero V2
          • About Xero Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Xero V2 with Daton
          • Schema Information
        • Yahoo Gemini
        • Yotpo
        • Yotpo v2
          • About Yotpo Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Yotpo v2 with Daton
          • Schema Information
        • Zendesk Chat
        • Zendesk ETL
          • Release Notes
        • Zoho CRM
          • Release Notes
        • ZohoDesk
          • Release Notes
      • Surveys
        • Alchemer
          • About Alchemer Platform
          • Essential Attributes and Supported Tables Alchemer
          • How to Integrate Alchemer Account with Daton
          • Schema Information Alchemer
        • Fairing
          • About Fairing Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Fairing with Daton
          • Schema Information
        • Survicate
          • About Survicate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Survicate with Daton
          • Schema Information
      • Shipping Platforms
        • 3PL Central
        • Byrd
        • Cin7
        • ClickPost
        • Dear
        • Easypost
        • Ohi
          • About Ohi Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Ohi with Daton
          • Schema Information
        • ShipBob
          • About ShipBob Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ShipBob with Daton
          • Schema Information
      • Webhooks
    • Destinations
      • Amazon RDS PostgreSQL
        • Amazon RDS for PostgreSQL Integration with Daton
        • How to Set up RDS PostgreSQL Destination in Daton
      • Amazon RDS MySQL
        • About Integrating Amazon RDS for MySQL database with Daton
        • How to Set up RDS MySQL Destination in Daton
      • Amazon Redshift
        • Querying Daton created tables on RedShift
        • Release Notes
      • Amazon S3
        • Release Notes
      • Azure One Lake
        • About Azure One Lake as a connector in Daton
        • How to Set up an Azure One Lake Database for Integrating with Daton
        • How to Integrate your Azure One Lake Database as a Destination in Daton
      • Azure Data Lake Storage
        • About Azure Data Lake Storage as a connector in Daton
        • How to Set up an Azure Data Lake Storage for Integrating with Daton
        • How to Integrate Your Azure Data Lake Storage Database as a Destination in Daton
      • GCP PostgreSQL
        • About Google Cloud SQL for PostgreSQL Database with Daton
        • How to Set up GCP PostgreSQL Destination in Daton
      • Google BigQuery
        • Release Notes
      • GCS
      • MySQL
        • About Integrating MySQL with Daton
        • How to Set up a MySQL Database for Integrating with Daton
        • How to Set up Your MySQL Database as a Destination in Daton
      • Oracle Autonomous Data Warehouse
      • Snowflake
        • Release Notes
  • FAQs and Troubleshooting
    • Connector permissions and API Keys
      • Access tokens for Shopify
      • Amazon Ads Permissions
      • Where to find my Amazon MWS Merchant Token and Auth Token
      • How to create BigCommerce API Account and generate Client Id, Client Secret and Access tokens
      • How to create Client credentials for Bol Retail
      • How to create Developer application for Mercado Libre
      • How to create API Keys for SendGrid
      • Where to find API Keys for Freshsales
      • Where to find API Keys for Freshdesk
      • How to create REST API Keys for NewRelic
      • How to create API Keys for Chargebee
      • How to generate Access Token for Calendly
      • How to obtain Klaviyo API Key
      • Where to find API Keys for RazorPay
      • How to create API Keys for PushEngage
      • How to create Criteo API User and generate Client Id and Client Secret
      • How to find site-id/domain and create WooCommerce Consumer Key and Secret
    • Authentication Failure while connecting Database using SSH tunnel
    • Common Errors and Resolution
    • FAQs
      • How to get access to FB Ads Business Manager?
      • How to get access to Google Analytics?
      • Querying Daton created child tables for nested data
      • Google Analytics - FAQs
      • How does Lite Plan Work?
      • How do I upgrade my subscription?
      • How does loading behaviour impact billing?
      • What are the tables highlighted with the letter "F"?
      • Amazon Advertising FAQs
      • Amazon Business and Inventory Reports FAQs
      • Why don't I see my data?
      • How exactly do Business Reports work in Daton?
      • Steps to upload your own ASIN and SKU file in Amazon SP connectors
      • What are 'FATAL' and 'CANCELLED' report statuses in Amazon Selling Partner?
      • How to setup Google BigQuery Project
      • Amazon Selling Partner, Vendor Central - Access to resource denied error.
      • VendorSalesReportByManufacturing showing a FATAL report status?
      • How to Enable SSH Tunneling during a Database Source Authentication?
  • New Subscription Plans and Billing
    • Subscription Plans Overview
    • Find Your Perfect Data Integration Fit - Growth and Enterprise Plans Explored
    • Daton's Subscriptions Dashboard: Harness the Power of Your Data
    • How to Select and Subscribe to a Daton Subscription Plan?
    • Subscription Plan Upgrade and Downgrade
    • Changing Billing Cycle
  • Product Insights: Report, Roadmap, and Release Notes
    • Introduction to Product Insights
    • 2023 Recap and 2024 Roadmap
    • Release Notes
Powered by GitBook
On this page
  • Pre-requisite steps
  • How to make an Amazon Selling Partner Integration in Daton?
  • What happens next?
  • General guidelines for configuring Amazon Selling Partner Connector on Daton
  • Known Issues
  • Change log
  • The Amazon APIs incident
  • FAQs for the Amazon APIs incident

Was this helpful?

  1. Connectors
  2. Data Sources
  3. Ecommerce Platforms

Amazon Selling Partner

PreviousRelease NotesNextAll Report Types and Tables

Last updated 1 year ago

Was this helpful?

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. 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.

  3. 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.

  4. After authentication, you will be prompted to choose from the list of available tables. Select the required tables and columns.

  5. 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 support@sarasanalytics.com for any guidance with the setup and optimization.

Known Issues

  1. Authentication while creating integrations on Daton must be done using the primary seller account only.

  2. 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

2022-12-26

Rate limiter implemented

SalesAndTrafficReportByChildASIN

2022-12-20

New 'sku' column redacted

FBARestockInventoryReport

2022-12-20

Enabled for all marketplaces

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

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

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

SalesAndTrafficReportByDate, SalesAndTrafficReportByParentASIN

2022-11-16

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

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

VATTransactionsReport

2022-10-20

Corrected faulty parsing of dates into YYYY-MM-DD format.

SalesAndTrafficReportByChildASIN

2022-10-10

InboundShipmentsTransportDetails

2022-10-03

The Amazon APIs incident

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

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. 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.

  3. What columns are affected by the incident?

    All the columns from the tables OrderItemId, quantity, item_status, and itemPrice have been affected.

  4. 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.

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.

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 if you are unsure of which option to pick.

Some of the APIs such as are not available for all marketplaces. Refer to each report category for detailed list of availability.

Transaction (Payments) reports are not available through APIs. Reach out to our for alternatives.

New tables added (Brand Analytics). Call the 'GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT' and 'GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT' reportTypes respectively in the section.

Deprecated. New and existing integrations will be unable to add them if not added. Support will be slowly be discontinued for existing tables. .

Deprecated. New and existing integrations will be unable to add them if not added. Support will be slowly be discontinued for existing tables.

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 operation from the A+ Content API.

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 operation in the Catalog Items API.

New table added. Gives details about fulfillment inbound shipments including weight, dimensions and value data about partnered and non partnered data. Calls the operation in the Fulfillment API.

Refer:

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 to read more about the billing plans.

Daton supports several data destinations.
fba-inventory-api
support
Selling Partner API - Health Dashboard
here
general guidelines
All raw tables
Monthly Reports
Brand Analytics reports
User ASIN/SKU file input enabled from the backend.
Replacement tables are InventoryLedgerSummaryReport, InventoryLedgerDetailedReport and FBAManageInventoryHealthReport
SalesAndTrafficReportByChildASIN will be the only supported report.
All dependent raw tables
getContentDocument
getCatalogItem
Increased lookback window, faster historical data processing.
getTransportDetails