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
  • General guidelines for configuring Amazon MWS on Daton
  • Known Issues
  • Snapshot
  • Raw Tables
  • Amazon Reports
  • Amazon MWS Merchant Token
  • Integrate AmazonMWS with Daton
  • Workflow
  • AmazonMWS Data
  • ListOrders
  • FlatFileOrdersByLastUpdateReport

Was this helpful?

  1. Connectors
  2. Data Sources
  3. Ecommerce Platforms

Amazon MWS

Amazon MWS ETL connector for data replication

General guidelines for configuring Amazon MWS on Daton

  • Create separate integration for ListOrder and ListOrderItems tables. These two are the largest and slower APIs.

  • Create separate integration for rest of the Raw tables.

  • Create separate integrations for reports. It is advised to limit to 20 reports per integration. If you are on starter or above subscription plan, you can create multiple integrations per connector without any increate in monthly billing.

  • Suggested frequency for raw tables - 1hr

  • Suggested frequency for daily reports - 4 hrs (Note that even if we set the frequency to 4 hrs, data would be fetched only twice per day)

  • Suggested frequency for monthly reports - 24 hrs

  • Suggested frequency for real time reports - 1 hr

  • Reach out to support@sarasanalytics.com for any guidance with the setup and optimization.

Known Issues

  1. Cancelled reports - Report requests can get cancelled if there is any parallel process using the same requests or when users manually request for these reports from console. Daton will try again in subsequent jobs in case of cancelled or failed report requests and there will not be any loss of data.

  2. Changes in fields and datatypes - We have observed that there could be changes by Amazon in the report field names. While we are trying to make the migration process as seamless as possible, it may be required to reload the reports if any names or datatypes change.

  3. Presently, daily reports will be processed 2 times in a day to account for failure reports. We will optimize this further in our upcoming releases and try to process only one successful job.

Snapshot

Features

Details

Release Status

Released

Source API Version

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

MerchantID or SellerID MWS Auth Token Marketplace

Replication Type

Full Replication Key Based Incremental

Replication Key

Date

Suggested Replication Frequency

4 hrs

Raw Tables

Data from raw tables can be used to build custom reports.

Suggested replication frequency - 2 hrs

  • ListFinancialEventGroups

  • ListFinancialEvents

  • ListMarketplaceParticipations

  • ListOrder

  • GetFeedSubmissionList

  • ListRecommendations

  • ListInventorySupply

  • ListAllFulfillmentOrders

  • ListRegisteredDestinations

  • ListSubscriptions

  • ListOrderItems

  • GetMatchingProduct

  • GetCompetitivePricingForSKU

Amazon Reports

Amazon MWS Merchant Token

Integrate AmazonMWS with Daton

  1. Signin to Daton

  2. Select AmazonMWS from the list of Integrations

  3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

  4. Post successful authentication, you will be prompted to choose from the list of available tables

  5. Then select all required fields for each table

  6. Submit the integration

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

AmazonMWS Data

ListFinancialEventGroups

Purpose: This API is used to get the list of all varients in the catelog.

Replication: Key Based Replication

Replication Key: financialEventGroupStartedAfter

Fields

Name

Target Datatype

FinancialEventGroupId

STRING

ProcessingStatus

STRING

FundTransferStatus

STRING

OriginalTotal

RECORD

ConvertedTotal

RECORD

FundTransferDate

DATETIME

TraceId

STRING

AccountTail

STRING

BeginningBalance

RECORD

FinancialEventGroupStart

DATETIME

FinancialEventGroupEnd

DATETIME

ListFinancialEvents

Purpose: This API is used to get the list of all Financial events for an order

Replication: Key Based Replication

Replication Key: withPostedAfter

Fields

Name

Target Datatype

ShipmentEventList

RECORD

RefundEventList

RECORD

GuaranteeClaimEventList

RECORD

ChargebackEventList

RECORD

PayWithAmazonEventList

RECORD

ServiceProviderCreditEventList

RECORD

RetrochargeEventList

RECORD

RentalTransactionEventList

RECORD

PerformanceBondRefundEventList

RECORD

ProductAdsPaymentEventList

RECORD

ServiceFeeEventList

RECORD

SellerDealPaymentEventList

RECORD

DebtRecoveryEventList

RECORD

LoanServicingEventList

RECORD

AdjustmentEventList

RECORD

SAFETReimbursementEventList

RECORD

SellerReviewEnrollmentPaymentEventList

RECORD

FBALiquidationEventList

RECORD

CouponPaymentEventList

RECORD

ImagingServicesFeeEventList

RECORD

NetworkComminglingTransactionEventList

RECORD

AffordabilityExpenseEventList

RECORD

AffordabilityExpenseReversalEventList

RECORD

ListMarketplaceParticipations

Purpose: This API is used to get the list of marketplaces that the seller submitting the request and list of participations that include seller.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

ListMarketplaces

RECORD

ListParticipations

RECORD

ListOrders

Purpose: This API returns the list of all orders created or updated.

Replication: Key Based Replication

Replication Key: createdAfter

Fields

Name

Target Datatype

AmazonOrderId

STRING

SellerOrderId

STRING

PurchaseDate

DATETIME

LastUpdateDate

DATETIME

OrderStatus

STRING

FulfillmentChannel

STRING

SalesChannel

STRING

OrderChannel

STRING

ShipServiceLevel

STRING

ShippingAddress

RECORD

OrderTotal

RECORD

NumberOfItemsShipped

INTEGER

NumberOfItemsUnshipped

INTEGER

PaymentExecutionDetail

RECORD

PaymentMethod

STRING

PaymentMethodDetails

RECORD

IsReplacementOrder

BOOLEAN

ReplacedOrderId

STRING

MarketplaceId

STRING

BuyerEmail

STRING

BuyerName

STRING

BuyerCounty

STRING

BuyerTaxInfo

RECORD

ShipmentServiceLevelCategory

STRING

ShippedByAmazonTFM

BOOLEAN

TFMShipmentStatus

STRING

EasyShipShipmentStatus

STRING

OrderType

STRING

EarliestShipDate

DATETIME

LatestShipDate

DATETIME

EarliestDeliveryDate

DATETIME

LatestDeliveryDate

DATETIME

IsBusinessOrder

BOOLEAN

PurchaseOrderNumber

STRING

IsPrime

BOOLEAN

IsPremiumOrder

BOOLEAN

PromiseResponseDueDate

DATETIME

IsEstimatedShipDateSet

BOOLEAN

GetFeedSubmissionList

Purpose: This API returns the list of all active recommendations or for all categories.

Replication: Key Based Replication

Replication Key: withSubmittedToDate

Fields

Name

Target Datatype

InventoryRecommendations

RECORD

SelectionRecommendations

RECORD

PricingRecommendations

RECORD

FulfillmentRecommendations

RECORD

ListingQualityRecommendations

RECORD

GlobalSellingRecommendations

RECORD

AdvertisingRecommendations

RECORD

GetFeedSubmissionList

Purpose: This API returns the list of all all feed submissions.

Replication: Key Based Replication

Replication Key: withSubmittedToDate

Fields

Name

Target Datatype

FeedSubmissionId

STRING

FeedType

STRING

SubmittedDate

STRING

FeedProcessingStatus

STRING

StartedProcessingDate

DATETIME

CompletedProcessingDate

DATETIME

ListRecommendations

Purpose: This API returns the list of active recommendations for all categories for a specific marketplace.

Replication: Full Based Replication

Replication Key: N/A

Fields

Name

Target Datatype

InventoryRecommendations

RECORD

SelectionRecommendations

RECORD

PricingRecommendations

RECORD

FulfillmentRecommendations

RECORD

ListingQualityRecommendations

RECORD

GlobalSellingRecommendations

RECORD

AdvertisingRecommendations

RECORD

ListInventorySupply

Purpose: This API returns the list of active recommendations for all information about the availability of a seller's inventory

Replication: Full Based Replication

Replication Key: N/A

Fields

Name

Target Datatype

SellerSKU

STRING

FNSKU

STRING

ASIN

STRING

Condition

STRING

TotalSupplyQuantity

INTEGER

InStockSupplyQuantity

INTEGER

EarliestAvailability

RECORD

SupplyDetail

RECORD

ListAllFulfillmentOrders

Purpose: This API returns the list of fulfillment orders fulfilled.

Replication: Key Based Replication

Replication Key: QueryStartDateTime

Fields

Name

Target Datatype

SellerFulfillmentOrderId

STRING

MarketplaceId

STRING

DisplayableOrderId

STRING

DisplayableOrderDateTime

DATETIME

DisplayableOrderComment

STRING

ShippingSpeedCategory

STRING

DeliveryWindow

RECORD

DestinationAddress

RECORD

FulfillmentAction

STRING

FulfillmentPolicy

STRING

FulfillmentMethod

STRING

CODSettings

RECORD

ReceivedDateTime

DATETIME

StatusUpdatedDateTime

DATETIME

FulfillmentOrderStatus

STRING

NotificationEmailList

RECORD

ListRegisteredDestinations

Purpose: This API returns the list of all current destinations.

Replication: Full Based Replication

Replication Key: N/A

Fields

Name

Target Datatype

DeliveryChannel

STRING

AttributeList

RECORD

ListSubscriptions

Purpose: This API returns the list of all current subscriptions.

Replication: Full Based Replication

Replication Key: N/A

Fields

Name

Target Datatype

DeliveryChannel

STRING

AttributeList

RECORD

ListOrderItems

Purpose: This API returns the order items based on the AmazonOrderId .

Replication: Key Based Replication

Replication Key: createdAfter

Fields

Name

Target Datatype

AmazonOrderId

STRING

ASIN

STRING

SellerSKU

STRING

OrderItemId

STRING

Title

STRING

QuantityOrdered

INTEGER

QuantityShipped

INTEGER

ProductInfo

RECORD

PointsGranted

RECORD

ItemPrice

RECORD

ShippingPrice

RECORD

GiftWrapPrice

RECORD

ItemTax

RECORD

GiftWrapPrice

RECORD

ShippingTax

RECORD

GiftWrapTax

RECORD

ShippingDiscount

RECORD

ShippingDiscountTax

RECORD

PromotionDiscount

RECORD

PromotionDiscountTax

RECORD

PromotionIds

RECORD

CODFee

RECORD

CODFeeDiscount

RECORD

IsGift

BOOLEAN

GiftMessageText

STRING

GiftWrapLevel

STRING

InvoiceData

RECORD

ConditionNote

STRING

ConditionId

STRING

ConditionSubtypeId

STRING

ScheduledDeliveryStartDate

STRING

ScheduledDeliveryEndDate

STRING

PriceDesignation

STRING

BuyerCustomizedInfo

RECORD

TaxCollection

RECORD

SerialNumberRequired

BOOLEAN

IsTransparency

BOOLEAN

GetMatchingProduct

Purpose: This API returns list of products and their attributes, based on a list of ASIN values .

Replication: Key Based Replication

Replication Key: QueryStartDateTime

Fields

Name

Target Datatype

Identifiers

RECORD

SalesRankings

RECORD

AttributeSets

RECORD

Relationships

RECORD

GetCompetitivePricingForSKU

Purpose: This API returns current competitive price of a product, based on SellerSKU.

Replication: Key Based Replication

Replication Key: QueryStartDateTime

Fields

Name

Target Datatype

Identifiers

RECORD

SalesRankings

RECORD

AttributeSets

RECORD

Relationships

RECORD

CompetitivePricing

RECORD

LowestOfferListings

RECORD

Offers

RECORD

InventoryReport

Purpose: The api detailed all open listings report that contains a summary of the seller's product listings with the price and quantity for each SKU.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

sku

STRING

asin

STRING

price

NUMERIC

quantity

NUMERIC

Business_Price

NUMERIC

Quantity_Price_Type

NUMERIC

Quantity_Lower_Bound_1

NUMERIC

Quantity_Price_1

NUMERIC

Quantity_Lower_Bound_2

NUMERIC

Quantity_Price_2

NUMERIC

Quantity_Lower_Bound_3

NUMERIC

Quantity_Price_3

NUMERIC

Quantity_Lower_Bound_4

NUMERIC

Quantity_Price_4

NUMERIC

Quantity_Lower_Bound_5

NUMERIC

Quantity_Price_5

NUMERIC

standard_price_point

NUMERIC

ProductTaxCode

STRING

AllListingsReport

Purpose: The api detailed all listings report.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

item_name

STRING

item_description

STRING

listing_id

STRING

seller_sku

STRING

price

NUMERIC

quantity

NUMERIC

open_date

STRING

image_url

STRING

item_is_marketplace

BOOLEAN

product_id_type

STRING

zshop_shipping_fee

NUMERIC

item_note

STRING

item_condition

STRING

zshop_category1

STRING

zshop_browse_path

STRING

zshop_storefront_feature

STRING

asin1

STRING

asin2

STRING

asin3

STRING

will_ship_internationally

BOOLEAN

expedited_shipping

BOOLEAN

zshop_boldface

BOOLEAN

product_id

STRING

bid_for_featured_placement

STRING

add_delete

STRING

pending_quantity

STRING

fulfillment_channel

STRING

optional_payment_type_exclusion

STRING

merchant_shipping_group

STRING

status

STRING

maximum_retail_price

STRING

scheduled_delivery_sku_set

STRING

standard_price_point

NUMERIC

ProductTaxCode

STRING

minimum_seller_allowed_price

NUMERIC

maximum_seller_allowed_price

NUMERIC

OpenListingsReport

Purpose: The api detailed open listings report.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

item_name

STRING

item_description

STRING

listing_id

STRING

seller_sku

STRING

price

NUMERIC

quantity

NUMERIC

open_date

STRING

image_url

STRING

item_is_marketplace

BOOLEAN

product_id_type

STRING

zshop_shipping_fee

NUMERIC

item_note

STRING

item_condition

STRING

zshop_category1

STRING

zshop_browse_path

STRING

zshop_storefront_feature

STRING

asin1

STRING

asin2

STRING

asin3

STRING

will_ship_internationally

BOOLEAN

expedited_shipping

BOOLEAN

zshop_boldface

BOOLEAN

product_id

STRING

bid_for_featured_placement

STRING

add_delete

STRING

pending_quantity

STRING

fulfillment_channel

STRING

optional_payment_type_exclusion

STRING

Business_Price

NUMERIC

Quantity_Price_Type

STRING

Quantity_Lower_Bound_1

NUMERIC

Quantity_Price_1

NUMERIC

scheduled_delivery_sku_set

STRING

merchant_shipping_group

NUMERIC

ProductTaxCode

STRING

CanceledListingsReport

Purpose: The api detailed canceled listings report.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

item_name

STRING

item_description

STRING

listing_id

STRING

seller_sku

STRING

price

NUMERIC

quantity

NUMERIC

image_url

STRING

item_is_marketplace

BOOLEAN

product_id_type

STRING

zshop_shipping_fee

NUMERIC

item_note

STRING

item_condition

STRING

zshop_category1

STRING

zshop_browse_path

STRING

zshop_storefront_feature

STRING

asin1

STRING

asin2

STRING

asin3

STRING

will_ship_internationally

BOOLEAN

expedited_shipping

BOOLEAN

zshop_boldface

BOOLEAN

product_id

STRING

add_delete

STRING

optional_payment_type_exclusion

STRING

Business_Price

NUMERIC

Quantity_Price_Type

STRING

Quantity_Lower_Bound_1

NUMERIC

Quantity_Price_1

NUMERIC

Quantity_Lower_Bound_2

NUMERIC

Quantity_Price_2

NUMERIC

Quantity_Lower_Bound_3

NUMERIC

Quantity_Price_3

NUMERIC

standard_price_point

NUMERIC

merchant_shipping_group

STRING

ProductTaxCode

STRING

SoldListingsReport

Purpose: The api detailed sold listings report that contains items sold on Amazon's retail website.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

item_name

STRING

listing_id

STRING

sku

STRING

price

NUMERIC

shipping_fee

NUMERIC

purchase_date

STRING

buyer_email

STRING

buyer_nick_name

STRING

date_listed

STRING

item_is_marketplace

BOOLEAN

quantity

NUMERIC

ListingQualityandSuppressedListingReport

Purpose: The api detailed listing quality and suppressed listing report that contains your listing information that is incomplete or incorrect..

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

sku

STRING

product_name

STRING

asin

STRING

field_name

STRING

alert_type

STRING

current_value

NUMERIC

last_updated

STRING

explanation

STRING

GlobalExpansionOpportunitiesReport

Purpose: The api detailed products that a seller lists which have a high sales potential in other Amazon marketplaces

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

sku / STRING product_id | STRING product_id_type | STRING item_name | STRING price | NUMERIC minimum_seller_allowed_price | NUMERIC maximum_seller_allowed_price | NUMERIC item_condition | STRING quantity | NUMERIC status | STRING marketplace | STRING

UnshippedOrdersReport

Purpose: The api detailed orders that are not confirmed as shipped.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

order_id

STRING

order_item_id

STRING

purchase_date

STRING

payments_date

DATETIME

reporting_date

DATETIME

promise_date

DATETIME

days_past_promise

INTEGER

buyer_email

STRING

buyer_name

STRING

buyer_phone_number

STRING

sku

STRING

product_name

STRING

quantity_purchased

NUMERIC

quantity_shipped

NUMERIC

quantity_to_ship

NUMERIC

ship_service_level

STRING

recipient_name

STRING

ship_address_1

STRING

ship_address_2

STRING

ship_address_3

STRING

ship_city

STRING

ship_state

STRING

ship_postal_code

STRING

ship_country

STRING

payment_method

STRING

cod_collectible_amount

NUMERIC

already_paid

BOOLEAN

payment_method_fee

NUMERIC

is_business_order

BOOLEAN

purchase_order_number

STRING

price_designation

STRING

fulfilled_by

STRING

shipment_status

STRING

OrderReport

Purpose: The api detailed orders report.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

payments_status

STRING

order_id

STRING

order_item_id

STRING

payments_date

DATETIME

payments_transaction_id

STRING

item_name

STRING

listing_id

STRING

sku

STRING

price

NUMERIC

shipping_fee

NUMERIC

quantity_purchased

NUMERIC

total_price

NUMERIC

purchase_date

STRING

batch_id

STRING

buyer_email

STRING

buyer_name

STRING

recipient_name

STRING

ship_address_1

STRING

ship_address_2

STRING

ship_city

STRING

ship_state

STRING

ship_zip

STRING

ship_country

STRING

special_comments

STRING

upc

STRING

ship_method

STRING

VAT

STRING

fulfilled_by

STRING

FlatFileOrdersByLastUpdateReport

Purpose: The api detailed all orders updated in the specified period.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

amazon_order_id

STRING

merchant_order_id

STRING

purchase_date

STRING

last_updated_date

DATETIME

order_status

STRING

fulfillment_channel

STRING

sales_channel

STRING

order_channel

STRING

url

STRING

ship_service_level

STRING

product_name

STRING

sku

STRING

asin

STRING

item_status

STRING

quantity

NUMERIC

currency

STRING

item_price

NUMERIC

item_tax

NUMERIC

shipping_price

NUMERIC

shipping_tax

NUMERIC

gift_wrap_price

NUMERIC

gift_wrap_tax

NUMERIC

item_promotion_discount

NUMERIC

ship_promotion_discount

NUMERIC

ship_city

STRING

ship_state

STRING

ship_postal_code

STRING

ship_country

STRING

promotion_ids

STRING

is_business_order

BOOLEAN

purchase_order_number

STRING

price_designation

STRING

fulfilled_by

STRING

is_sold_by_ab

BOOLEAN

FlatFileReturnsReportbyReturnDate

Purpose: The api detailed returns information, including return request date.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

Order_ID

STRING

Order_date

STRING

Return_request_date

STRING

Return_request_status

STRING

Amazon_RMA_ID

STRING

Merchant_RMA_ID

STRING

Label_type

STRING

Label_cost

STRING

Currency_code

STRING

Return_carrier

STRING

Tracking_ID

INTEGER

Label_to_be_paid_by

STRING

A_to_z_claim

STRING

Is_prime

STRING

ASIN

STRING

Merchant_SKU

STRING

Item_name

STRING

Return_quantity

INTEGER

Returnreason

STRING

In_policy

STRING

Return_type

STRING

Resolution

STRING

Invoice_number

STRING

Return_delivery_date

STRING

Order_amount

NUMERIC

Order_quantity

INTEGER

SafeT_action_reason

STRING

SafeT_claim_id

STRING

SafeT_claim_state

STRING

SafeT_claim_creation_time

NUMERIC

SafeT_claim_reimbursement_amount

NUMERIC

Refunded_amount

NUMERIC

Category

STRING

ReferralFeePreviewReport

Purpose: The api detailed open listings as well as the price and estimated referral fees for each SKU.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

seller_sku

STRING

asin

STRING

item_name

STRING

price

STRING

estimated_referral_fee_per_item

NUMERIC

ActiveListingsReport

Purpose: The api detailed active listings report.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

item_name

STRING

item_description

STRING

listing_id

STRING

seller_sku

STRING

price

NUMERIC

quantity

NUMERIC

open_date

STRING

image_url

STRING

item_is_marketplace

STRING

product_id_type

STRING

zshop_shipping_fee

NUMERIC

item_note

STRING

item_condition

NUMERIC

zshop_category1

STRING

zshop_browse_path

STRING

zshop_storefront_feature

STRING

asin1

STRING

asin2

STRING

asin3

STRING

will_ship_internationally

BOOLEAN

expedited_shipping

BOOLEAN

zshop_boldface

STRING

product_id

STRING

bid_for_featured_placement

STRING

add_delete

STRING

pending_quantity

NUMERIC

fulfillment_channel

STRING

Business_Price

NUMERIC

Quantity_Price_Type

STRING

Quantity_Lower_Bound_1

STRING

Quantity_Price_1

NUMERIC

Quantity_Lower_Bound_2

STRING

Quantity_Price_2

NUMERIC

Quantity_Lower_Bound_3

STRING

Quantity_Price_3

NUMERIC

Quantity_Lower_Bound_4

STRING

Quantity_Price_4

NUMERIC

Quantity_Lower_Bound_5

STRING

Quantity_Price_5

NUMERIC

optional_payment_type_exclusion

STRING

merchant_shipping_group

STRING

InactiveListingsReport

Purpose: The api detailed inactive listings report.

Replication: Key Based Replication

Replication Key: StartDate

Fields

Name

Target Datatype

item_name

STRING

item_description

STRING

listing_id

STRING

seller_sku

STRING

price

NUMERIC

quantity

NUMERIC

open_date

STRING

image_url

STRING

item_is_marketplace

STRING

product_id_type

STRING

zshop_shipping_fee

NUMERIC

item_note

STRING

item_condition

NUMERIC

zshop_category1

STRING

zshop_browse_path

STRING

zshop_storefront_feature

STRING

asin1

STRING

asin2

STRING

asin3

STRING

will_ship_internationally

BOOLEAN

expedited_shipping

BOOLEAN

zshop_boldface

STRING

product_id

STRING

bid_for_featured_placement

STRING

add_delete

STRING

pending_quantity

NUMERIC

fulfillment_channel

STRING

optional_payment_type_exclusion

STRING

merchant_shipping_group

STRING

PreviousEcommerce PlatformsNextRelease Notes

Last updated 4 years ago

Was this helpful?

Please grant access to our Developer Id by following the steps outlined in this document:

Provide Merchant/Seller ID, MWS Auth Token and Marketplaces listed in. You can get your details from

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

https://docs.sarasanalytics.com/faqs/source-api-keys/amazon-mws-merchant-token-and-auth-token
MWS Auth Token
http://docs.developer.amazonservices.com/en_US/finances/Finances_ListFinancialEventGroups.html
http://docs.developer.amazonservices.com/en_US/finances/Finances_ListFinancialEvents.html
http://docs.developer.amazonservices.com/en_US/sellers/Sellers_ListMarketplaceParticipations.html
http://docs.developer.amazonservices.com/en_US/orders-2013-09-01/Orders_ListOrders.html
http://docs.developer.amazonservices.com/en_US/feeds/Feeds_GetFeedSubmissionList.html
http://docs.developer.amazonservices.com/en_US/feeds/Feeds_GetFeedSubmissionList.html
http://docs.developer.amazonservices.com/en_US/recommendations/Recommendations_ListRecommendations.html
http://docs.developer.amazonservices.com/en_US/fba_inventory/FBAInventory_ListInventorySupply.html
http://docs.developer.amazonservices.com/en_US/fba_outbound/FBAOutbound_ListAllFulfillmentOrders.html
http://docs.developer.amazonservices.com/en_US/subscriptions/Subscriptions_ListRegisteredDestinations.html
http://docs.developer.amazonservices.com/en_US/subscriptions/Subscriptions_ListSubscriptions.html
http://docs.developer.amazonservices.com/en_US/orders-2013-09-01/Orders_ListOrderItems.html
http://docs.developer.amazonservices.com/en_US/products/Products_GetMatchingProduct.html
http://docs.developer.amazonservices.com/en_US/products/Products_GetCompetitivePricingForSKU.html
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html#ReportTypeCategories__ListingsReports
26KB
AmazonMWS_Reports.xlsx
Amazon Reports - Description