Walmart

Walmart Marketplace lets third-party sellers list and sell products on Walmart.com, and manage items, inventory, orders, returns, pricing, shipping and Walmart Fulfillment Services (WFS) through the Walmart Marketplace APIs. With Weld you can sync your Walmart Marketplace data into your data warehouse and combine it with your other sales channels to report on orders, returns, settlement and listing quality in one place.

Features

Feature name	Supported
Column Hashing	True	Column level
Blocking	True	Column level
Incremental	True
Custom data	False
History	True
ReSync	True	Table level
Templates	False

Data Schema

---

Setup Guide - ELT

Step 1 - Retrieve your Client ID and Client Secret

1. Sign in to Seller Center and navigate to the API Integration page.
2. Select API Key Management to sign in to the Walmart Developer Portal with your Seller Center credentials.
3. Locate your personal key pair (marked with a lock icon) and copy the Client ID and Client Secret.

Step 2 - Create the connection

1. In the Weld app, navigate to Connections and click + New Connection.
2. Search for Walmart and select it.
3. Enter the destination schema name of your choice. This name is used to identify the connection in future syncs.
4. Enter your Client ID and Client Secret.
5. Click Connect. When the connection is established, you are redirected back to the Weld connections overview.

Step 3 - Data To Sync

Select the tables you wish to include in the sync. You can view the schema, remove columns or hash sensitive information.

The connector exposes 16 selectable tables, covering:

• Catalogue and inventory — item, inventory
• Orders and returns — order, return
• Pricing — pricing_insights, price_incentive
• Feeds — feed
• Payments and settlement — payment_statement_report, recon_report
• Shipping settings — shipping_template, shipping_template_details, shipping_configuration, shipping_coverage
• Fulfillment (WFS) — inbound_shipment
• Listing quality — listing_quality_score, listing_quality_item

Several of these bring related tables with them, so selecting the parent is enough — you do not select the child tables separately. In total the connector lands 57 tables:

Select this table	You also get
item	item_unpublished_reason, item_variant_group_attribute
inventory	inventory_node (quantities per ship node)
order	order_line, order_line_charge, order_line_status, order_line_refund_charge, order_line_serial_number, order_payment_type
return	return_order_line, return_order_line_charge, return_order_line_charge_tax, return_order_line_charge_reference, return_order_line_charge_total, return_order_line_tracking_status, return_order_line_refund_channel, return_order_line_tracking_detail, return_order_line_tracking_detail_reference, return_line_group, return_line_group_line, return_line_group_label, return_line_group_label_carrier
feed	feed_item, feed_item_ingestion_error
shipping_template_details	shipping_template_fulfillment_center, shipping_template_method, shipping_template_configuration, shipping_template_address_type, shipping_template_tiered_charge, shipping_template_region, shipping_template_sub_region, shipping_template_state, shipping_template_state_subregion
shipping_configuration	shipping_configuration_setting, shipping_configuration_category
shipping_coverage	shipping_coverage_area
inbound_shipment	inbound_shipment_tracking_number
listing_quality_item	listing_quality_item_score, listing_quality_item_content_issue, listing_quality_item_trend, listing_quality_item_trend_value

Step 4 - Configure sync

1. Select how often you would like the data to sync.
2. Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Walmart Marketplace account.