Walmart Seller Center schema and ERD

57 tables

Loading diagram…

feed

inbound_shipment

inventory

item

listing_quality_item

order

return

shipping_configuration

shipping_coverage

shipping_template_details

feed

feed_id

string

feed_source

string

feed_type

string

partner_id

string

feed_status

string

items_received

long

items_succeeded

long

items_failed

long

items_processing

long

feed_item

feed_id

string

index

int

mart_id

int

sku

string

wpid

string

ingestion_status

string

pending_status_description

string

_weld_synced

date

feed_item_ingestion_error

feed_id

string

feed_item_index

int

index

int

type

string

code

string

description

string

_weld_synced

date

inbound_shipment

shipment_id

string

inbound_order_id

string

moved_shipment_id

string

status

string

shipment_units

int

received_units

int

created_date

date

expected_delivery_date

date

inbound_shipment_tracking_number

shipment_id

string

index

int

tracking_no

string

_weld_synced

date

inventory

sku

string

_weld_synced

date

inventory_node

sku

string

ship_node

string

input_qty_amount

double

input_qty_unit

string

avail_to_sell_qty_amount

double

avail_to_sell_qty_unit

string

reserved_qty_amount

double

reserved_qty_unit

string

_weld_synced

date

item

sku

string

mart

string

condition

string

availability

string

wpid

string

upc

string

gtin

string

product_name

string

item_unpublished_reason

sku

string

index

int

reason

string

_weld_synced

date

item_variant_group_attribute

sku

string

name

string

value

string

_weld_synced

date

listing_quality_item

item_id

string

sku

string

product_id

string

product_name

string

category_name

string

product_type

string

condition

string

priority

string

updated_timestamp

date

listing_quality_item_score

sku

string

score_type

string

score_value

double

impact

string

_weld_synced

date

listing_quality_item_content_issue

sku

string

attribute_name

string

attribute_value

string

score

double

issue_count

double

is_editable

boolean

is_spec_attribute

boolean

_weld_synced

date

listing_quality_item_trend

sku

string

stats_type

string

_weld_synced

date

listing_quality_item_trend_value

sku

string

stats_type

string

date

string

value_amount

double

value_currency

string

_weld_synced

date

listing_quality_score

listing_quality

double

score_offer_score

double

score_content_score

double

score_rating_review_score

double

score_price_score

double

score_shipping_score

double

score_transactibility_score

double

post_purchase_quality_defect_ratio

double

post_purchase_quality_item_defect_cnt

double

_weld_synced

date

order

purchase_order_id

string

customer_order_id

string

customer_email_id

string

order_type

string

order_date

date

shipping_info_phone

string

shipping_info_estimated_delivery_date

date

shipping_info_estimated_ship_date

date

order_line

purchase_order_id

string

line_number

string

item_sku

string

item_product_name

string

item_condition

string

order_line_quantity_amount

double

order_line_quantity_unit_of_measurement

string

status_date

date

order_line_charge

purchase_order_id

string

line_number

string

index

int

charge_type

string

charge_name

string

charge_amount_amount

double

charge_amount_currency

string

tax_tax_name

string

order_line_status

purchase_order_id

string

line_number

string

index

int

status

string

sub_seller_id

string

status_quantity_amount

double

status_quantity_unit_of_measurement

string

cancellation_reason

string

order_line_refund_charge

purchase_order_id

string

line_number

string

index

int

refund_reason

string

charge_charge_type

string

charge_charge_name

string

charge_charge_amount_amount

double

charge_charge_amount_currency

string

order_line_serial_number

purchase_order_id

string

line_number

string

index

int

serial_number

string

_weld_synced

date

order_payment_type

purchase_order_id

string

index

int

payment_type

string

_weld_synced

date

payment_statement_report

partner_id

string

outstanding_mca_balance

double

seller_info_store_front_url

string

seller_info_seller_status

string

seller_info_payment_status

string

seller_info_tenure

long

account_summary_opening_balance

double

account_summary_order_activity

double

price_incentive

item_id

string

incentive_id

string

offer_id

string

sku_id

string

product_name

string

product_url

string

product_image_url

string

current_price

double

target_price

double

pricing_insights

sku

string

item_name

string

current_price

double

buy_box_base_price

double

buy_box_total_price

double

buy_box_win_rate

double

competitor_price

double

comparison_price

double

recon_report

report_date

date

row_number

int

period_start_date

date

period_end_date

date

total_payable

double

currency

string

transaction_key

string

transaction_posted_timestamp

date

return

return_order_id

string

customer_order_id

string

customer_email_id

string

return_type

string

return_order_date

date

return_by_date

date

refund_mode

string

replacement_customer_order_id

string

return_order_line

return_order_id

string

return_order_line_number

string

sales_order_line_number

string

return_reason

string

return_description

string

return_method

string

purchase_order_id

string

seller_order_id

string

return_order_line_charge

return_order_id

string

return_order_line_number

string

index

int

charge_category

string

charge_name

string

charge_per_unit_currency_amount

double

charge_per_unit_currency_unit

string

excess_charge_currency_amount

double

excess_charge_currency_unit

string

is_discount

boolean

is_billable

boolean

_weld_synced

date

return_order_line_charge_tax

return_order_id

string

return_order_line_number

string

charge_index

int

index

int

tax_name

string

tax_per_unit_currency_amount

double

tax_per_unit_currency_unit

string

excess_tax_currency_amount

double

excess_tax_currency_unit

string

_weld_synced

date

return_order_line_charge_reference

return_order_id

string

return_order_line_number

string

charge_index

int

name

string

value

string

_weld_synced

date

return_order_line_charge_total

return_order_id

string

return_order_line_number

string

name

string

value_currency_amount

double

value_currency_unit

string

_weld_synced

date

return_order_line_tracking_status

return_order_id

string

return_order_line_number

string

index

int

status

string

status_time

date

current_refund_status

string

quantity_measurement_value

double

quantity_unit_of_measure

string

_weld_synced

date

return_order_line_refund_channel

return_order_id

string

return_order_line_number

string

index

int

refund_covered_by

string

refund_channel_name

string

quantity_measurement_value

double

_weld_synced

date

return_order_line_tracking_detail

return_order_id

string

return_order_line_number

string

sequence_no

int

event_tag

string

event_description

string

event_time

date

_weld_synced

date

return_order_line_tracking_detail_reference

return_order_id

string

return_order_line_number

string

sequence_no

int

name

string

value

string

_weld_synced

date

return_line_group

return_order_id

string

group_no

int

return_expected_flag

boolean

_weld_synced

date

return_line_group_line

return_order_id

string

group_no

int

return_order_line_number

string

_weld_synced

date

return_line_group_label

return_order_id

string

group_no

int

index

int

label_image_url

string

_weld_synced

date

return_line_group_label_carrier

return_order_id

string

group_no

int

label_index

int

index

int

carrier_id

string

carrier_name

string

service_type

string

tracking_no

string

_weld_synced

date

shipping_configuration

partner_id

string

partner_name

string

partner_display_name

string

partner_store_id

string

business_reg_number

string

country_of_incorporation

string

_weld_synced

date

shipping_configuration_setting

partner_id

string

configuration_name

string

_weld_synced

date

shipping_configuration_category

partner_id

string

configuration_name

string

name

string

fulfillment_lag_time

int

_weld_synced

date

shipping_coverage

ship_node

string

ship_node_name

string

_weld_synced

date

shipping_coverage_area

ship_node

string

index

int

coverage_area

string

_weld_synced

date

shipping_template

string

name

string

type

string

status

string

rate_model_type

string

shipping_type

string

created_by

string

modified_by

string

created_date

date

modified_date

date

_weld_synced

date

shipping_template_details

string

name

string

type

string

status

string

rate_model_type

string

shipping_type

string

created_by

string

modified_by

string

created_date

date

shipping_template_fulfillment_center

template_id

string

index

int

fulfillment_center_id

string

_weld_synced

date

shipping_template_method

template_id

string

index

int

ship_method

string

status

string

_weld_synced

date

shipping_template_configuration

template_id

string

method_index

int

index

int

transit_time

int

per_shipping_charge_unit_of_measure

string

per_shipping_charge_shipping_and_handling_amount

double

per_shipping_charge_shipping_and_handling_currency

string

per_shipping_charge_charge_per_item_amount

double

per_shipping_charge_charge_per_item_currency

string

per_shipping_charge_charge_per_weight_amount

double

per_shipping_charge_charge_per_weight_currency

string

_weld_synced

date

shipping_template_address_type

template_id

string

method_index

int

configuration_index

int

index

int

address_type

string

_weld_synced

date

shipping_template_tiered_charge

template_id

string

method_index

int

configuration_index

int

index

int

min_limit

double

max_limit

double

ship_charge_amount

double

ship_charge_currency

string

_weld_synced

date

shipping_template_region

template_id

string

method_index

int

configuration_index

int

region_code

string

region_name

string

_weld_synced

date

shipping_template_sub_region

template_id

string

method_index

int

configuration_index

int

region_code

string

sub_region_code

string

sub_region_name

string

_weld_synced

date

shipping_template_state

template_id

string

method_index

int

configuration_index

int

region_code

string

sub_region_code

string

state_code

string

state_name

string

_weld_synced

date

shipping_template_state_subregion

template_id

string

method_index

int

configuration_index

int

region_code

string

sub_region_code

string

state_code

string

state_subregion_code

string

state_subregion_name

string

_weld_synced

date