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
- API Endpoints
- Entity Relationship Diagram
- Amazon Seller Central Schema
- Release Updates
- Related Resources
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.
Amazon Seller Central Schema
The Daasity Amazon Seller Central Extractor creates these tables using the endpoints (for APIs) or the Report API (for reports) listed. The data is mapped from the source to the table based on the mapping logic outlined in each table.
ASC FBA Inventory
- Endpoint: GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA Report in Reports API
- Amazon UI: Fulfillment by Amazon (FBA) -> FBA Manage Inventory report
- Update method: UPSERT
- Table Name: amazon.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
- Endpoint: GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL Report in Reports API
- Amazon UI: Fulfillment by Amazon (FBA) -> Flat File All Orders Report by Last Update
- Update method: UPSERT
- Table Name: amazon.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
- Endpoint: GET_FBA_MYI_ALL_INVENTORY_DATA Report in Reports API
- Amazon UI: Fulfillment by Amazon (FBA) -> FBA Manage Inventory -- Archived
- Update method: UPSERT
- Table Name: amazon.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)