Amazon Selling Partner API schema and ERD

65 tables

Loading diagram…

catalog_item

fba_shipment_items

fee_estimates_by_sku

fulfillment_order

inventory_list

order

transactions

settlement_report

catalog_item

asin

string

marketplace_id

string

_weld_synced

date

catalog_item_summary

asin

string

marketplace_id

string

brand

string

browse_classification_display_name

string

browse_classification_classification_id

string

color

string

item_classification

string

item_name

string

catalog_item_classification

asin

string

marketplace_id

string

display_name

string

classification_id

string

parent

string

_weld_synced

date

catalog_item_dimension

asin

string

marketplace_id

string

item_height_unit

string

item_height_value

double

item_length_unit

string

item_length_value

double

item_weight_unit

string

item_weight_value

double

catalog_item_identifier

asin

string

marketplace_id

string

identifier

string

identifier_type

string

_weld_synced

date

catalog_item_image

asin

string

marketplace_id

string

variant

string

link

string

height

int

width

int

_weld_synced

date

catalog_item_product_type

asin

string

marketplace_id

string

product_type

string

_weld_synced

date

catalog_item_relationship

asin

string

marketplace_id

string

type

string

parent_asins

string

child_asins

string

variation_theme

string

_weld_synced

date

catalog_item_sales_rank_classification

asin

string

marketplace_id

string

classification_id

string

title

string

link

string

rank

int

_weld_synced

date

catalog_item_sales_rank_display_group_ranks

asin

string

marketplace_id

string

website_display_group

string

title

string

link

string

rank

int

_weld_synced

date

fba_inventory_summary

marketplace_id

string

asin

string

fn_sku

string

seller_sku

string

condition

string

last_updated_time

string

product_name

string

total_quantity

double

fba_inventory_summary_history

marketplace_id

string

asin

string

fn_sku

string

seller_sku

string

condition

string

last_updated_time

string

product_name

string

total_quantity

double

fba_shipment_items

shipment_id

string

seller_sku

string

fulfillment_network_sku

string

quantity_shipped

int

quantity_received

int

quantity_in_case

int

release_date

date

_weld_synced

date

fba_shipment_item_prep_details

prep_instruction

string

prep_owner

string

shipment_id

string

seller_sku

string

fulfillment_network_sku

string

_weld_synced

date

fba_shipments

shipment_id

string

shipment_name

string

shipment_status

string

label_prep_type

string

destination_fulfillment_center_id

string

are_cases_required

boolean

confirmed_need_by_date

date

box_contents_source

string

fee_estimates_by_sku

seller_sku

string

marketplace_id

string

fees_estimate_identifier_marketplace_id

string

fees_estimate_identifier_seller_id

string

fees_estimate_identifier_id_type

string

fees_estimate_identifier_id_value

string

fees_estimate_identifier_is_amazon_fulfilled

boolean

fees_estimate_identifier_price_to_estimate_fees_listing_price_currency_code

string

fee_estimates_by_sku_fee_details

seller_sku

string

marketplace_id

string

seller_input_identifier

string

fee_type

string

fee_amount_currency_code

string

fee_amount_amount

double

fee_promotion_currency_code

string

fee_promotion_amount

double

fee_estimates_by_sku_included_fee_details

seller_sku

string

marketplace_id

string

seller_input_identifier

string

fee_type

string

parent_fee_type

string

fee_amount_currency_code

string

fee_amount_amount

double

fee_promotion_currency_code

string

fulfillment_order

seller_fulfillment_order_id

string

marketplace_id

string

displayable_order_id

string

displayable_order_date

date

displayable_order_comment

string

shipping_speed_category

string

delivery_window_start_date

date

delivery_window_end_date

date

fulfillment_order_item

seller_fulfillment_order_id

string

seller_sku

string

seller_fulfillment_order_item_id

string

quantity

int

gift_message

string

displayable_comment

string

fulfillment_network_sku

string

order_item_disposition

string

fulfillment_shipment

seller_fulfillment_order_id

string

amazon_shipment_id

string

fulfillment_center_id

string

fulfillment_shipment_status

string

shipping_date

date

estimated_arrival_date

date

shipping_notes

string

_weld_synced

date

fulfillment_shipment_item

seller_fulfillment_order_id

string

amazon_shipment_id

string

seller_sku

string

seller_fulfillment_order_item_id

string

quantity

int

package_number

string

serial_number

string

manufacturer_lot_codes

string

_weld_synced

date

fulfillment_shipment_package_tracking

seller_fulfillment_order_id

string

amazon_shipment_id

string

package_number

string

tracking_number

string

customer_tracking_link

string

carrier_code

string

carrier_phone_number

string

carrier_url

string

fulfillment_shipment_package_tracking_event

seller_fulfillment_order_id

string

amazon_shipment_id

string

package_number

string

event_date

date

event_address_city

string

event_address_state

string

event_address_country

string

event_code

string

event_description

string

_weld_synced

date

fulfillment_return_item

seller_fulfillment_order_id

string

seller_return_item_id

string

seller_fulfillment_order_item_id

string

amazon_shipment_id

string

seller_return_reason_code

string

return_comment

string

amazon_return_reason_code

string

status

string

fulfillment_return_authorization

seller_fulfillment_order_id

string

return_authorization_id

string

fulfillment_center_id

string

return_to_address_name

string

return_to_address_address_line_1

string

return_to_address_address_line_2

string

return_to_address_address_line_3

string

return_to_address_city

string

fulfillment_payment_information

seller_fulfillment_order_id

string

payment_transaction_id

string

payment_mode

string

payment_date

date

_weld_synced

date

inventory_list

sku

string

total_inbound_quantity

long

total_onhand_quantity

long

inventory_details_available_distributable_quantity

long

inventory_details_replenishment_quantity

long

inventory_details_reserved_distributable_quantity

long

_weld_synced

date

inventory_list_expiration_detail

sku

string

expiration

date

onhand_quantity

long

_weld_synced

date

order

order_id

string

buyer_buyer_company_name

string

buyer_buyer_email

string

buyer_buyer_name

string

buyer_buyer_purchase_order_number

string

created_time

date

fulfillment_deliver_by_window_earliest_date_time

date

fulfillment_deliver_by_window_latest_date_time

date

fulfillment_fulfilled_by

string

order_alias

order_id

string

alias_id

string

alias_type

string

_weld_synced

date

order_associated_order

order_id

string

parent_order_id

string

association_type

string

_weld_synced

date

order_item

order_id

string

order_item_id

string

cancellation_cancellation_request_requester

string

cancellation_cancellation_request_cancel_reason

string

expense_points_cost_points_granted_points_monetary_value_amount

string

expense_points_cost_points_granted_points_monetary_value_currency_code

string

expense_points_cost_points_granted_points_number

double

fulfillment_packing_gift_option

string

fulfillment_quantity_fulfilled

double

fulfillment_quantity_unfulfilled

double

order_item_proceeds_breakdown

order_id

string

order_item_id

string

index

int

subtotal_amount

string

subtotal_currency_code

string

type

string

_weld_synced

date

order_item_proceeds_detailed_breakdown

order_id

string

order_item_id

string

order_item_proceeds_breakdown_index

int

index

int

subtype

string

value_amount

string

value_currency_code

string

_weld_synced

date

order_item_promotion_breakdown

order_id

string

order_item_id

string

promotion_id

string

_weld_synced

date

order_package

order_id

string

package_reference_id

string

carrier

string

created_time

date

package_status_status

string

ship_from_address_address_line_1

string

ship_from_address_address_line_2

string

ship_from_address_city

string

ship_from_address_country_code

string

order_package_item

order_id

string

order_item_id

string

package_reference_id

string

index

int

quantity

double

_weld_synced

date

ordermetrics

interval

string

unitCount

double

orderItemCount

double

orderCount

double

averageUnitPrice_amount

double

averageUnitPrice_currencyCode

string

totalSales_amount

double

totalSales_currencyCode

string

marketplaceId

string

intervalId

string

_weld_synced

date

product_pricing

buying_price_listing_price_currency_code

string

buying_price_listing_price_amount

double

buying_price_landed_price_currency_code

string

buying_price_landed_price_amount

double

buying_price_shipping_currency_code

string

buying_price_shipping_amount

double

regular_price_currency_code

string

regular_price_amount

double

transactions

transaction_id

string

selling_partner_metadata_selling_partner_id

string

selling_partner_metadata_account_type

string

selling_partner_metadata_marketplace_id

string

transaction_type

string

transaction_status

string

description

string

posted_date

date

transactions_related_identifiers

transaction_id

string

related_identifier_name

string

related_identifier_value

string

_weld_synced

date

transactions_items

transaction_id

string

description

string

total_amount_currency_amount

double

total_amount_currency_code

string

index

int

_weld_synced

date

transactions_item_related_identifiers

transaction_id

string

item_description

string

item_related_identifier_name

string

item_related_identifier_value

string

item_total_amount_currency_code

string

item_total_amount_currency_amount

double

transaction_item_index

int

_weld_synced

date

transactions_item_contexts

transaction_id

string

item_description

string

asin

string

quantity_shipped

int

sku

string

fulfillment_network

string

context_type

string

item_total_amount_currency_code

string

item_total_amount_currency_amount

double

transaction_item_index

int

index

int

_weld_synced

date

transactions_item_breakdowns_first_level

transaction_id

string

item_description

string

breakdown_type

string

breakdown_amount_currency_amount

double

breakdown_amount_currency_code

string

item_total_amount_currency_code

string

item_total_amount_currency_amount

double

transaction_item_index

int

_weld_synced

date

transactions_item_breakdowns_second_level

transaction_id

string

first_level_breakdown_type

string

breakdown_type

string

breakdown_amount_currency_amount

double

breakdown_amount_currency_code

string

item_description

string

item_total_amount_currency_code

string

item_total_amount_currency_amount

double

transaction_item_index

int

index

int

_weld_synced

date

transactions_item_breakdowns_third_level

transaction_id

string

first_level_breakdown_type

string

second_level_breakdown_type

string

breakdown_type

string

breakdown_amount_currency_amount

double

breakdown_amount_currency_code

string

item_description

string

item_total_amount_currency_code

string

item_total_amount_currency_amount

double

transaction_item_index

int

index

int

_weld_synced

date

transactions_breakdowns_first_level

transaction_id

string

breakdown_type

string

breakdown_amount_currency_amount

double

breakdown_amount_currency_code

string

_weld_synced

date

transactions_breakdowns_second_level

transaction_id

string

first_level_breakdown_type

string

breakdown_type

string

breakdown_amount_currency_amount

double

breakdown_amount_currency_code

string

_weld_synced

date

transactions_breakdowns_third_level

transaction_id

string

first_level_breakdown_type

string

second_level_breakdown_type

string

breakdown_type

string

breakdown_amount_currency_amount

double

breakdown_amount_currency_code

string

index

int

_weld_synced

date

transactions_contexts

transaction_id

string

context_type

string

deferral_reason

string

maturity_date

date

_weld_synced

date

fba_reimbursements_report

approval_date

date

reimbursement_id

string

case_id

string

amazon_order_id

string

reason

string

sku

string

fnsku

string

asin

string

fba_returns_report

order_id

string

return_date

date

sku

string

asin

string

fnsku

string

product_name

string

quantity

string

fulfillment_center_id

string

detailed_disposition

string

fba_storage_fee_charges_report

asin

string

fnsku

string

product_name

string

fulfillment_center

string

country_code

string

longest_side

string

median_side

string

shortest_side

string

merchant_listings_report

item_name

string

item_description

string

listing_id

string

seller_sku

string

price

double

quantity

int

open_date

string

image_url

string

orders_by_last_updated_date_report

amazon_order_id

string

merchant_order_id

string

purchase_date

date

last_updated_date

date

order_status

string

fulfillment_channel

string

sales_channel

string

order_channel

string

returns_by_return_date_report

order_id

string

order_date

date

return_request_date

date

return_request_status

string

amazon_rma_id

string

merchant_rma_id

string

label_type

string

label_cost

double

currency_code

string

sales_and_traffic_report_by_asin

marketplace_id

string

parent_asin

string

child_asin

string

sku

string

units_ordered

int

ordered_product_sales_amount

double

ordered_product_sales_currency_code

string

total_order_items

int

sales_and_traffic_report_by_asin_child

marketplace_id

string

parent_asin

string

child_asin

string

sku

string

units_ordered

int

ordered_product_sales_amount

double

ordered_product_sales_currency_code

string

total_order_items

int

sales_and_traffic_report_by_asin_sku

marketplace_id

string

parent_asin

string

child_asin

string

sku

string

units_ordered

int

ordered_product_sales_amount

double

ordered_product_sales_currency_code

string

total_order_items

int

sales_and_traffic_report_by_date

marketplace_id

string

date

ordered_product_sales_amount

double

ordered_product_sales_currency_code

string

units_ordered

int

total_order_items

int

average_sales_per_order_item_amount

double

average_sales_per_order_item_currency_code

string

search_query_performance_report

marketplace_id

string

start_date

date

end_date

date

asin

string

search_query_data_search_query

string

search_query_data_search_query_score

double

search_query_data_search_query_volume

double

impression_data_total_query_impression_count

double

settlement_report

settlement_id

string

order_id

string

report_document_id

string

report_document_index

string

amount_type

string

amount_description

string

sku

string

merchant_order_item_id

string

posted_date_time

string

merchant_adjustment_item_id

string

settlement

settlement_id

string

settlement_start_date

string

settlement_end_date

string

deposit_date

string

total_amount

double

currency

string

_weld_synced

date