Connector Enhancements

Amazon MWS Connector

  1. Follow the Generic Guidelines while creating integrations. These will help with reducing delays while processing the data. The documentation for the Generic Guidelines for configuring the connector can be found here.

  2. Datatype Changes in Reports: Following is the list of corrections required in the existing integrations: NOTE: Edit the existing integrations to drop the tables first and then add them back. This is required to be done only if these changes are required. You can leave the existing integrations as is if these changes are not required. Datatype Changes:

    • ActiveListingsReport - open_date(string to datetime), item_condition(numeric to String), Quantity_Lower_Bound_1,2,3,4,5(String to Numeric)

    • AllListingsReport - open_date(string to datetime), item_condition(numeric to String), pending_quantity(string to Integer), maximum_retail_price(string to Numeric)

    • InactiveListingsReport - open_date(string to DateTime), item_condition(numeric to String)

    • FBAStrandedInventoryReport - date_stranded(string to datetime), date_classified_as_unsellable(string to datetime)

    • OpenListingsReport - open_date(string to datetime), pending_quantity(string to Integer)

    • FlatFileOrdersByLastUpdateReport - purchase_date(string to DateTime)

    • FlatFileAllOrdersReportByLastUpdateDate - purchase_date(string to DateTime)

    • FBAPromotionsReport - shipment_date(string to DateTime)

    • FBAInventoryAgeReport - snapshot_date(string to DateTime)

    • FBAStorageFeesReport - estimated_monthly_storage_fee(string to Numeric)

    Table Renames:

    • FBASmallAndLightReports to FBASmallAndLightInventoryReport

    • RestockInventoryReport to FBARestockInventoryReport

    • FlatFileOrdersByLastUpdateReport to FBAFlatFileOrdersByLastUpdateReport

    Column Renames:


    • Order_Amount to Order_amount

    • Refunded_Amazon to Refunded_amazon

    • Item_Name to Item_name

    • Return_reason to Returnreason

    • Merchant_RMA_ID(New field)

  3. The list of reports, their description, and their behavior can be found in the source documentation.

    • The list of reports that require reloading to get accurate historic data is as follows. Incremental data will be accurate even without the reload after this release (18th March).

      List of tables that require reload -

      1. FBAPromotionsReport

      2. FBAMonthlyInventoryHistoryReport

      3. FBAInventoryEventDetailReport

      4. FBAInboundPerformanceReport

      5. FBAStorageFeesReport

      6. FBAReplacementsReport

      7. ReferralFeeDiscountsReport

      8. FBAReturnsReport

    • Support for historic data has been removed for snapshot reports.  Snapshot reports will process data from the date of integration. No action is required from the users.

  4. Real-Time Reports:

    • Jobs for all real-time reports will have a start time of 12:00 AM (Local time) and an end time as the current time.

    • This will increase the number of duplicates but will ensure that the data is accurate.

    • The data of the previous day would be fetched until 6 AM local time to address latency from Amazon. No action will be required from the users.

    • Reload will be required only if there are differences in data for the previous months.

Last updated