Integration: Amazon Seller Central

This article will help you learn about how Daasity replicates data from Amazon Seller Central using the Selling Partner API, limitations to the data we can extract and where the data is stored in the Amazon Seller Central schema

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

Integration Availability

This integration is available for:

  • Growth (accessibility to each report is indicated in the description)
  • Pro

Extraction Overview

Amazon is retiring the current MWS platform on July 31st, 2022 and requiring all integrations to migrate to the new REST API platform also called the Selling Partner API.

Daasity is in the process of migrating all currently available functionality to the new Selling Partner API as well as building out additional functionality to support merchants that sell through Amazon Seller Central

The updated Amazon integration will extract data into a new schema and thus Daasity will continue to update this document to reflect updates to supported endpoints in the Selling Partner API.

Currently Daasity supports the following endpoints:

  • Orders API
    • getOrders
  • Reports API
    • Flat File All Orders Report by Last Update
    • FBA Manage Inventory - Archived
    • FBA Manage Inventory

The Orders API and the Flat File All Orders Report by Last Update are each run hourly to provide intra-day sales performance.  All other APIs are run on a daily basis.

Entity Relationship Diagram

The embedded diagram houses the ERD for the Daasity Amazon Seller Central integration illustrating the different tables and keys to join across tables.  Hover over the embedded diagram to reveal controls to zoom and scroll.

 

ASC FBA Inventory

CSV Column Database Column

SKU 

SKU 

FN_SKU 

FN_SKU 

ASIN 

ASIN 

Product_name 

Product_name 

Product_condition 

Product_condition 

Product_price 

Product_price 

MFN_listing_exists 

MFN_listing_exists 

MFN_fulfillable_quantity 

MFN_fulfillable_quantity 

AFN_listing_exists 

AFN_listing_exists 

AFN_warehouse_quantity 

AFN_warehouse_quantity 

AFN_fulfillable_quantity 

AFN_fulfillable_quantity 

AFN_unsellable_quantity 

AFN_unsellable_quantity 

AFN_reserved_quantity 

AFN_reserved_quantity 

AFN_total_quantity 

AFN_total_quantity 

Per_unit_volume 

Per_unit_volume 

AFN_inbound_working_quantity 

AFN_inbound_working_quantity 

AFN_inbound_shipped_quantity 

AFN_inbound_shipped_quantity 

AFN_inbound_receiving_quantity 

AFN_inbound_receiving_quantity 

AFN_researching_quantity 

AFN_researching_quantity 

AFN_reserved_future_supply 

AFN_reserved_future_supply 

AFN_future_supply_buyable 

AFN_future_supply_buyable 

Seller_id 

Seller_id 

Marketplace_id 

Marketplace_id 

ASC Orders

  • Endpoint: getOrders in Orders API
  • Amazon UI: N/A
  • Update method: UPSERT
  • Table Name: amazon.asc_orders
XML Element Database Column

Order_id 

Order_id 

Seller_order_id 

Seller_order_id 

Buyer_email 

Buyer_email 

Order_date 

Order_date 

Order_type 

Order_type 

Order_status 

Order_status 

Currency_code 

Currency_code 

Order_amount 

Order_amount 

Payment_type 

Payment_type 

Payment_method 

Payment_method 

Sales_channel 

Sales_channel 

Business_order_flag 

Business_order_flag 

Premium_order_flag 

Premium_order_flag 

Prime_order_flag 

Prime_order_flag 

Replacement_order_flag 

Replacement_order_flag 

Fulfillment_control 

Fulfillment_control 

Earliest_ship_date 

Earliest_ship_date 

Ship_date 

Ship_date 

Ship_service_level 

Ship_service_level 

Ship_service_level_category 

Ship_service_level_category 

Num_items_shipped 

Num_items_shipped 

Num_items_not_shipped 

Num_items_not_shipped 

Buyer_name 

Buyer_name 

Ship_name 

Ship_name 

Ship_address1 

Ship_address1 

Ship_city 

Ship_city 

Ship_state 

Ship_state 

Ship_postalcode 

Ship_postalcode 

Ship_countrycode 

Ship_countrycode 

Updated_at 

Updated_at 

Address_sharing_flag 

Address_sharing_flag 

Amazon_business_flag 

Amazon_business_flag 

Global_express_flag 

Global_express_flag 

Marketplace_id 

Marketplace_id 

Seller_id 

Seller_id 

ASC Report All Orders

CSV Column Database Column

Order_id 

Order_id 

Merchant_order_id 

Merchant_order_id 

Purchase_date 

Purchase_date 

Last_updated_date 

Last_updated_date 

Order_status 

Order_status 

Fulfillment_channel 

Fulfillment_channel 

Sales_channel 

Sales_channel 

Order_channel 

Order_channel 

URL 

URL 

ASIN 

ASIN 

Item_status 

Item_status 

Promotion_ids 

Promotion_ids 

CPF 

CPF 

Payment_method_details 

Payment_method_details 

SKU 

SKU 

Number_of_items 

Number_of_items 

Product_name 

Product_name 

Quantity 

Quantity 

Currency 

Currency 

Item_price 

Item_price 

Item_tax 

Item_tax 

Shipping_price 

Shipping_price 

Shipping_tax 

Shipping_tax 

Gift_wrap_price 

Gift_wrap_price 

Gift_wrap_tax 

Gift_wrap_tax 

Ship_service_level 

Ship_service_level 

Address_type 

Address_type 

Ship_city 

Ship_city 

Ship_state 

Ship_state 

Ship_postal_code 

Ship_postal_code 

Ship_country 

Ship_country 

Item_promotion_discount 

Item_promotion_discount 

Ship_promotion_discount 

Ship_promotion_discount 

Cod_collectible_amount 

Cod_collectible_amount 

Item_extentions_data 

Item_extentions_data 

Is_business_order 

Is_business_order 

Purchase_order_number 

Purchase_order_number 

Price_designation 

Price_designation 

Customized_URL 

Customized_URL 

Customized_Page 

Customized_Page 

Buyer_company_name 

Buyer_company_name 

License_number 

License_number 

License_state 

License_state 

License_expiration_date 

License_expiration_date 

Is_replacement_order 

Is_replacement_order 

Is_exchange_order 

Is_exchange_order 

Original_order_id 

Original_order_id 

Tax_collection_model 

Tax_collection_model 

Tax_collection_responsible_party 

Tax_collection_responsible_party 

Fulfilled_by 

Fulfilled_by 

Is_amazon_invoiced 

Is_amazon_invoiced 

VAT_exclusive_item_price 

VAT_exclusive_item_price 

VAT_exclusive_shipping_price 

VAT_exclusive_shipping_price 

VAT_exclusive_giftwrap_price 

VAT_exclusive_giftwrap_price 

IS_IBA 

IS_IBA 

Order_invoice_type 

Order_invoice_type 

Seller_id 

Seller_id 

Marketplace_id 

Marketplace_id 


ASC Report Inventory

CSV Column Database Column

SKU 

SKU 

FN_SKU 

FN_SKU 

ASIN 

ASIN 

Product_name 

Product_name 

Product_condition 

Product_condition 

Product_price 

Product_price 

MFN_listing_exists 

MFN_listing_exists 

MFN_fulfillable_quantity 

MFN_fulfillable_quantity 

AFN_listing_exists 

AFN_listing_exists 

AFN_warehouse_quantity 

AFN_warehouse_quantity 

AFN_fulfillable_quantity 

AFN_fulfillable_quantity 

AFN_unsellable_quantity 

AFN_unsellable_quantity 

AFN_reserved_quantity 

AFN_reserved_quantity 

AFN_total_quantity 

AFN_total_quantity 

Per_unit_volume 

Per_unit_volume 

AFN_inbound_working_quantity 

AFN_inbound_working_quantity 

AFN_inbound_shipped_quantity 

AFN_inbound_shipped_quantity 

AFN_inbound_receiving_quantity 

AFN_inbound_receiving_quantity 

AFN_researching_quantity 

AFN_researching_quantity 

AFN_reserved_future_supply 

AFN_reserved_future_supply 

AFN_future_supply_buyable 

AFN_future_supply_buyable 

Seller_id 

Seller_id 

Marketplace_id 

Marketplace_id 

Release Updates

  • 2022-05-11: Initial release of the integration document covering the first set of endpoints released (Orders API and several reports from the Reports API)

Related Resources