Integration Specifications

Refresh Cadence

The Walmart Marketplace extractor updates daily. In each update, we pull data from the previous 7 complete days.

Availability

This integration is available for:

• Enterprise

• Growth

API Endpoints

This extractor is based on the Walmart Developer Portal docs. The following endpoints are used to replicate data into Daasity:

• Fulfillment Orders Status (no historical extraction)

• Inventories (no historical extraction)

• Items (no historical extraction)

• Orders

• Returns

Entity Relationship Diagram (ERD)

Walmart Marketplace Schema

The Walmart Marketplace extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

• Inventories

• Inventory Nodes

• Item Unpublished Reasons

• Items

• Return Line Group Label Carrier Info List

• Return Line Group Labels

• Return Line Group Return Lines

• Return Order Line Charge References

• Return Order Line Charge Taxes

• Return Order Line Charges

• Return Order Line Charge Totals

• Return Order Line Current Tracking Statuses

• Return Order Line Refund Channels

• Return Order Line Tracking Detail References

• Return Order Line Tracking Details

• Return Order Lines

• Returns

• Order Fulfillment Status Order Line Quantity Infos

• Order Fulfillment Status Order Lines

• Order Fulfillment Status Shipment Lines

• Order Fulfillment Status Shipments

• Order Fulfillment Status Shipment Dates

• Order Fulfillment Statuses

• Order Fulfillment Status Order Line Quantity Infos

• Order Fulfillment Status Order Lines

• Order Fulfillment Status Shipment Lines

• Order Fulfillment Status Shipments

• Order Fulfillment Status Shipment Dates

• Order Fulfillment Statuses

• Order Line Charges

• Order Line Refund Charges

• Order Line Statuses

• Order Lines

• Orders

Inventories

• Endpoint: Inventories

• Update Method: Upsert

• Table Name: walmart_marketplace.inventories

JSON Element	Database Column
inventories[].sku	sku
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(sku)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Inventory Nodes

• Endpoint: Inventories

• Update Method: Upsert

• nodes are nested into each Inventory

• Table Name: walmart_marketplace.inventory_nodes

JSON Element	Database Column
inventories[].sku	sku
inventories[].nodes[].shipNode	ship_node
inventories[].nodes[].inputQty.unit	input_qty_unit
inventories[].nodes[].inputQty.amount	input_qty_amount
inventories[].nodes[].availToSellQty.unit	avail_to_sell_qty_unit
inventories[].nodes[].availToSellQty.amount	avail_to_sell_qty_amount
inventories[].nodes[].reservedQty.unit	reserved_qty_unit
inventories[].nodes[].reservedQty.amount	reserved_qty_amount
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(sku, ship_node)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Item Unpublished Reasons

• Endpoint: Items

• Update Method: Upsert

• Reasons are nested inside the reason element, which is nested into the unpublishedReasons element of Items

• Table Name: walmart_marketplace.item_reasons

JSON Element	Database Column
itemResponse[].upc	upc
itemResponse[].unpublishedReasons.reason	reason
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(upc, index - ordinal place in reasons array)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Items

• Endpoint: Items

• Update Method: Upsert

• Table Name: walmart_marketplace.items

JSON Element	Database Column
itemResponse[].upc	upc
itemResponse[].wpid	wpid
itemResponse[].gtin	gtin
itemResponse[].sku	sku
itemResponse[].productName	product_name
itemResponse[].shelf	shelf
itemResponse[].mart	mart
itemResponse[].condition	condition
itemResponse[].productType	product_type
itemResponse[].publishedStatus	published_status
itemResponse[].lifecycleStatus	lifecycle_status
itemResponse[].price.currency	price_currency
itemResponse[].price.amount	price_amount
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(upc)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Line Group Label Carrier Info List

• Endpoint: Returns

• Update Method: Upsert

• carrierInfoLists are are nested into each element of the Labels collection, which are in turn nested into each element of the returnLineGroups collection within Return Orders

• Table Name: walmart_marketplace.return_line_group_label_carrier_info_lists

JSON Element	Database Column
returnOrders[].returnOrderId	return_order_id
groupNo (parent group’s)	group_no
carrierId	carrier_id
carrierName	carrier_name
serviceType	service_type
trackingNo	tracking_no
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, group_no, carrier_id)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Line Group Labels

• Endpoint: Returns

• Update Method: Upsert

• Labels are are nested into each element of the returnLineGroups collection within Return Orders

• Table Name: walmart_marketplace.return_line_group_labels

JSON Element	Database Column
returnOrders[].returnOrderId	return_order_id
groupNo (parent group’s)	group_no
labelImageUrl	label_image_url
returnExpectedFlag (parent group’s)	return_expected_flag
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, group_no)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Line Group Return Lines

• Endpoint: Returns

• Update Method: Upsert

• returnLines are are nested into each element of the returnLineGroups collection within Return Orders

• Table Name: walmart_marketplace.return_line_group_return_lines

JSON Element	Database Column
returnOrderId (parent return order’s)	return_order_id
groupNo (parent group’s)	group_no
returnOrderLineNumber	return_order_line_number
returnExpectedFlag (parent group’s)	return_expected_flag
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, group_no)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Line Charge References

• Endpoint: Returns

• Update Method: Upsert

• references are nested into charges, in turn nested into returnLines, within each Return Order

• Table Name: walmart_marketplace.return_order_line_charge_references

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber (parent line’s)	return_order_line_number
name	name
value	value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number, name)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Line Charge Taxes

• Endpoint: Returns

• Update Method: Upsert

• tax elements are nested into charges, in turn nested into returnLines, within each Return Order

• Table Name: walmart_marketplace.return_order_line_charge_taxes

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber (parent line’s)	return_order_line_number
name	name
excessTax[currencyAmount]	excess_tax_currency_amount
excessTax[CurrencyUnit]	excess_tax_currency_unit
taxPerUnit[CurrencyAmount]	tax_per_unit_currency_amount
taxPerUnit[currencyUnit]	tax_per_unit_currency_unit
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number, tax_name)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Line Charges

• Endpoint: Returns

• Update Method: Upsert

• returnLines are nested into each element of the returnLines within each Return Order

• Table Name: walmart_marketplace.return_order_line_charges

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber (parent line’s)	return_order_line_number
chargeCategory	charge_category
chargeName	charge_name
isDiscount	is_discount
isBillable	is_billable
chargePerUnit[currencyAmount]	charge_per_unit_currency_amount
chargePerUnit[currencyUnit]	charge_per_unit_currency_unit
excessCharge[currencyAmount]	excess_charge_currency_amount
excessCharge[currencyUnit]	excess_charge_currency_unit
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number, charge_category)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Line Charge Totals

• Endpoint: Returns

• Update Method: Upsert

• chargeTotals are nested into returnLines, within each Return Order

• Table Name: walmart_marketplace.return_order_line_charge_totals

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber (parent line’s)	return_order_line_number
name	name
value[currencyAmount]	value_currency_amount
value[currencyUnit]	value_currency_unit
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number, name)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Line Current Tracking Statuses

• Endpoint: Returns

• Update Method: Upsert

• currentTrackingStatuses are nested within returnLines, which in turn are nested into each Return Order

• Table Name: walmart_marketplace.return_order_line_current_tracking_statuses

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber (parent line’s)	return_order_line_number
status	status
statustimeT	status_time
currentRefundStatus	current_refund_status
quantity[unitOfMeasure]	quantity_unit_of_measure
quantity[measurementValue]	quantity_measurement_value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Line Refund Channels

• Endpoint: Returns

• Update Method: Upsert

• refundChannels are nested into returnLines, within each Return Order

• Table Name: walmart_marketplace.return_order_line_refund_channels

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber (parent line’s)	return_order_line_number
refundChannelName	channel_name
quantity[measurementValue]	quantity_measurement_value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number, channel_name)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Line Tracking Detail References

• Endpoint: Returns

• Update Method: Upsert

• references are nested within returnTrackingDetail items, which in turn are nested into returnLines, within each Return Order

• Table Name: walmart_marketplace.return_order_line_tracking_details

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber (parent line’s)	return_order_line_number
sequenceNo	sequence_no
eventTag	name
eventDescription	value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number, sequence_no, name)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Line Tracking Details

• Endpoint: Returns

• Update Method: Upsert

• returnTrackingDetail items are nested into returnLines, within each Return Order

• Table Name: walmart_marketplace.return_order_line_tracking_details

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber (parent line’s)	return_order_line_number
sequenceNo	sequence_no
eventTag	event_tag
eventDescription	event_description
eventTime	event_time
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number, sequence_no)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Return Order Lines

• Endpoint: Returns

• Update Method: Upsert

• returnLines are are nested into each element of the returnOrderLines collection within Return Orders

• Table Name: walmart_marketplace.return_order_lines

JSON Element	Database Column
Return_order_id (parent order’s)	return_order_id
returnOrderLineNumber	return_order_line_number
salesOrderLineNumber	sales_order_line_number
sellerOrderId	seller_order_id
returnReason	return_reason
purchaseOrderId	purchase_order_id
purchaseOrderLineNumber	purchase_order_line_number
exceptionItemType	exception_item_type
rechargeReason	recharge_reason
returnCancellationReason	return_cancellation_reason
isReturnForException	is_return_exception
returnExpectedFlag	return_expected_flag
isFastReplacement	is_fast_replacement
isKeepIt	is_keep_it
lastItem	last_item
refundedQty	refunded_qty
rechargeableQty	rechargeable_qty
refundChannel	refund_channel
status	status
statusTime	status_time
currentDeliveryStatus	current_delivery_status
currentRefundStatus	current_refund_status
cancellableQty	cancellable_qty
item[sku]	item_sku
item[condition]	item_condition
item[productName]	item_product_name
item[itemWeight][unitOfMeasure]	item_item_weight_unit_of_measure
item[itemWeight][measurementValue]	item_item_weight_measurement_value
unitPrice[currencyAmount]	unit_price_currency_amount
unitPrice[currencyUnit]	unit_price_currency_unit
quantity[unitOfMeasure]	quantity_unit_of_measure
quantity[measurementValue]	quantity_measurement_value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id, return_order_line_number)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Returns

• Endpoint: Returns

• Update Method: Upsert

• Table Name: walmart_marketplace.returns

JSON Element	Database Column
returnOrders[].returnOrderId	return_order_id
returnOrders[].customerEmailId	customer_email_id
returnOrders[].customerOrderId	customer_order_id
returnOrders[].returnOrderDate	return_order_date
returnOrders[].returnByDate	return_by_date
returnOrders[].returnType	return_type
returnOrders[].refundMode	refund_mode
returnOrders[].replacementCustomerOrderId	replacement_customer_order_id
returnOrders[].customerName.firstName	customer_name_first_name
returnOrders[].customerName.lastName	customer_name_last_name
returnOrders[].totalRefundAmount.currencyAmount	total_refund_amount_currency_amount
returnOrders[].totalRefundAmount.currencyUnit	total_refund_amount_currency_unit
returnOrders[].returnChannel.channelName	return_channel_channel_name
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(return_order_id)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Order Line Quantity Infos

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• orderLineQuantityInfo are nested into orderLines, which in turn are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_order_line_quantity_infos

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
status	status
statusDescription	status_description
statusQuantity[unitOfMeasure]	status_quantity_unit_of_measure
statusQuantity[measurementValue]	status_quantity_measurement_value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, status, status_description, status_quantity_unit_of_measure, status_quantity_measurement_value)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Order Lines

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• orderLines are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_order_lines

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
fulfillmentType	fulfillment_type
lastModified	last_modified
shippingMethod	shipping_method
shippingTier	shipping_tier
orderProduct[productName]	order_product_name
orderQty[unitOfMeasure]	order_qty_unit_of_measure
orderQty[measurementValue]	order_qty_measurement_value
shipToAddress[address][addressLineOne]	ship_to_address_line_1
shipToAddress[address][addressLineTwo]	ship_to_address_line_2
shipToAddress[address][addressType]	ship_to_address_address_type
shipToAddress[address][city]	ship_to_address_city
shipToAddress[address][countryCode]	ship_to_address_country_code
shipToAddress[address][postalCode]	ship_to_address_postal_code
shipToAddress[address][stateOrProvinceName]	ship_to_address_state_or_province_name
shipToAddress[address][stateOrProvinceCode]	ship_to_address_state_or_province_code
shipToAddress[address][completeName]	ship_to_address_complete_name
shipToAddress[address][firstName]	ship_to_address_first_name
shipToAddress[address][lastName]	ship_to_address_last_name
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, fulfillment_type, last_modified, shipping_method, shipping_tier)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Shipment Lines

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• shipmentLines are nested into shipments, which in turn are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_shipment_lines

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
shipmentLineNo	shipment_line_no
fulfillerLineId	fulfiller_line_id
quantity[unitOfMeasure]	quantity_unit_of_measure
quantity[measurementValue]	quantity_measurement_value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, shipment_line_no, fulfiller_line_id, quantity_unit_of_measure, quantity_measurement_value)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Shipments

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• shipments are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_shipments

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
purchaseOrderId	purchase_order_id
status	status
statusDescription	status_description
scac	scac
trackingNo	tracking_no
externalTrackingUrl	external_tracking_url
shipmentNo	shipment_no
actualShipmentDate	actual_shipment_date
packageAsn	package_asn
carrierDescription	carrier_description
carrierServiceCode	carrier_service_code
packageId	package_id
lastModified	last_modified
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, purchase_order_id, shipment_number, package_id)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Shipment Dates

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• shipmentDates are nested into shipments, which in turn are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_shipment_dates

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
actualDate	actual_date
dateTypeId	date_type_id
expectedDate	expected_date
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, actual_date, date_type_id, expected_date)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Statuses

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• Table Name: walmart_marketplace.order_fulfillment_statuses

JSON Element	Database Column
sellerOrderId	seller_order_id
orderType	order_type
status	status
orderDate	order_date
buyerInfo[primaryContact][firstName]	buyer_info_primary_contact_first_name
buyerInfo[primaryContact][lastName]	buyer_info_primary_contact_last_name
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Order Line Quantity Infos

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• orderLineQuantityInfo are nested into orderLines, which in turn are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_order_line_quantity_infos

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
status	status
statusDescription	status_description
statusQuantity[unitOfMeasure]	status_quantity_unit_of_measure
statusQuantity[measurementValue]	status_quantity_measurement_value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, status, status_description, status_quantity_unit_of_measure, status_quantity_measurement_value)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Order Lines

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• orderLines are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_order_lines

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
fulfillmentType	fulfillment_type
lastModified	last_modified
shippingMethod	shipping_method
shippingTier	shipping_tier
orderProduct[productName]	order_product_name
orderQty[unitOfMeasure]	order_qty_unit_of_measure
orderQty[measurementValue]	order_qty_measurement_value
shipToAddress[address][addressLineOne]	ship_to_address_line_1
shipToAddress[address][addressLineTwo]	ship_to_address_line_2
shipToAddress[address][addressType]	ship_to_address_address_type
shipToAddress[address][city]	ship_to_address_city
shipToAddress[address][countryCode]	ship_to_address_country_code
shipToAddress[address][postalCode]	ship_to_address_postal_code
shipToAddress[address][stateOrProvinceName]	ship_to_address_state_or_province_name
shipToAddress[address][stateOrProvinceCode]	ship_to_address_state_or_province_code
shipToAddress[address][completeName]	ship_to_address_complete_name
shipToAddress[address][firstName]	ship_to_address_first_name
shipToAddress[address][lastName]	ship_to_address_last_name
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, fulfillment_type, last_modified, shipping_method, shipping_tier)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Shipment Lines

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• shipmentLines are nested into shipments, which in turn are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_shipment_lines

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
shipmentLineNo	shipment_line_no
fulfillerLineId	fulfiller_line_id
quantity[unitOfMeasure]	quantity_unit_of_measure
quantity[measurementValue]	quantity_measurement_value
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, shipment_line_no, fulfiller_line_id, quantity_unit_of_measure, quantity_measurement_value)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Shipments

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• shipments are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_shipments

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
purchaseOrderId	purchase_order_id
status	status
statusDescription	status_description
scac	scac
trackingNo	tracking_no
externalTrackingUrl	external_tracking_url
shipmentNo	shipment_no
actualShipmentDate	actual_shipment_date
packageAsn	package_asn
carrierDescription	carrier_description
carrierServiceCode	carrier_service_code
packageId	package_id
lastModified	last_modified
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, purchase_order_id, shipment_number, package_id)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Status Shipment Dates

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• shipmentDates are nested into shipments, which in turn are nested into each Fulfillment Order

• Table Name: walmart_marketplace.order_fulfillment_status_shipment_dates

JSON Element	Database Column
sellerOrderId (parent Fulfillment’s)	seller_order_id
actualDate	actual_date
dateTypeId	date_type_id
expectedDate	expected_date
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id, actual_date, date_type_id, expected_date)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Fulfillment Statuses

• Endpoint: Fulfillment Orders Status

• Update Method: Upsert

• Table Name: walmart_marketplace.order_fulfillment_statuses

JSON Element	Database Column
sellerOrderId	seller_order_id
orderType	order_type
status	status
orderDate	order_date
buyerInfo[primaryContact][firstName]	buyer_info_primary_contact_first_name
buyerInfo[primaryContact][lastName]	buyer_info_primary_contact_last_name
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(seller_order_id)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Line Charges

• Endpoint: Orders

• Update Method: Upsert

• charges are nested into orderLines, which in turn are nested into each Order

• Table Name: walmart_marketplace.order_lines

JSON Element	Database Column
purchaseOrderId (parent Order’s)	purchase_order_id
Line_number (parent Line Number’s)	line_number
chargeType	charge_type
chargeName	charge_name
chargeAmount[currency]	charge_amount_currency
chargeAmount[amount]	charge_amount_amount
tax[name]	charge_tax_name
tax[taxAmount][currency]	charge_tax_amount_currency
tax[taxAmount][amount]	charge_tax_amount_amount
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(purchase_order_id, line_number, charge_type)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Line Refund Charges

• Endpoint: Orders

• Update Method: Upsert

• refundCharges belong to the refund element, which is nested into orderLines, which in turn are nested into each Order

• Table Name: walmart_marketplace.order_lines

JSON Element	Database Column
purchaseOrderId (parent Order’s)	purchase_order_id
Line_number (parent Line Number’s)	line_number
refund[refundId]	refund_id
refundReason	refund_reason
charge[chargeType]	refund_charge_type
charge[chargeName]	refund_charge_name
charge[chargeAmount][currency]	refund_charge_currency
charge[chargeAmount[amount]	refund_charge_amount
charge[tax][taxName]	refund_tax_name
charge[tax][taxAmount]	refund_tax_amount
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(purchase_order_id, line_number, refund_charge_type, refund_charge_name, refund_charge_currency, refund_charge_amount)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Line Statuses

• Endpoint: Orders

• Update Method: Upsert

• orderLineStatuses are nested into orderLines, which in turn are nested into each Order

• Table Name: walmart_marketplace.order_lines

JSON Element	Database Column
purchaseOrderId (parent Order’s)	purchase_order_id
Line_number (parent Line Number’s)	line_number
status	status
cancellationReason	cancellation_reason
statusQuantity[unitOfMeasurement]	status_quantity_unit_of_measurement
statusQuantity[amount]	status_quantity_amount
trackingInfo[shipDateTime]	tracking_info_ship_datetime
trackingInfo[carrierName][carrier]	tracking_info_carrier_name_carrier
trackingInfo[carrierName][otherCarrier]	tracking_info_carrier_name_other_carrier
trackingInfo[methodCode]	tracking_info_method_code
trackingInfo[trackingNumber]	tracking_info_tracking_number
trackingInfo[trackingUrl]	tracking_info_tracking_url
returnCenterAddress[name]	return_center_address_name
returnCenterAddress[address1]	return_center_address_1
returnCenterAddress[address2]	return_center_address_2
returnCenterAddress[city]	return_center_city
returnCenterAddress[state]	return_center_state
returnCenterAddress[postalCode]	return_center_postal_code
returnCenterAddress[country]	return_center_country
returnCenterAddress[dayPhone]	return_center_day_phone
returnCenterAddress[emailId]	return_center_email_id
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(purchase_order_id, line_number)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Order Lines

• Endpoint: Orders

• Update Method: Upsert

• orderLines are nested into each Order

• Table Name: walmart_marketplace.order_lines

JSON Element	Database Column
purchaseOrderId (parent Order’s)	purchase_order_id
line_number	line_number
statusDate	status_date
returnOrderId	return_order_id
originalCarrierMethod	original_carrier_method
referenceLineId	reference_line_id
serialNumbers	serial_numbers
intentToCancel	intent_to_cancel
configId	config_id
sellerOrderId	seller_order_id
refund[id]	refund_id
refund[comments]	refund_comments
item[productName]	item_product_name
item[sku]	item_sku
item[condition]	item_condition
item[imageUrl]	item_image_url
item[weight][value]	item_weight_value
item[weight][unit]	item_weight_unit
orderLineQuantity[unitOfMeasurement]	quantity_unit
orderLineQuantity[amount]	quantity_amount
fulfillment[fulfillmentOption]	fulfillment_option
fulfillment[ship_method]	fulfillment_ship_method
fulfillment[storeId]	fulfillment_store_id
fulfillment[pickupBy]	fulfillment_pickup_by
fulfillment[pickupDatetime]	fulfillment_pickup_datetime
fulfillment[shippingProgramType]	fulfillment_shipping_program_type
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(purchase_order_id, line_number)	__sync_key
Timestamp of extraction (UTC)	__synced_at

Orders

• Endpoint: Orders

• Update Method: Upsert

• Table Name: walmart_marketplace.orders

JSON Element	Database Column
purchaseOrderId	purchase_order_id
customerOrderId	customer_order_id
customerOrderEmail	customer_order_email
orderDate	order_date
orderType	order_type
originalCustomerOrderID	original_customer_order_id
buyerId	buyer_id
mart	mart
isGuest	is_guest
paymentTypes[]	payment_types
shippingInfo[phone]	shipping_info_phone
shippingInfo[estimated_delivery_date]	shipping_info_estimated_delivery_date
shippingInfo[estimated_ship_date]	shipping_info_estimated_ship_date
shippingInfo[method_code]	shipping_info_method_code
shipping_info_postal_address_name]	shipping_info_postal_address_name
shippingInfo[postalAddress][address1]	shipping_info_postal_address_1
shippingInfo[postalAddress][address2]	shipping_info_postal_address_2
shippingInfo[postalAddress][city]	shipping_info_postal_address_city
shippingInfo[postalAddress][state]	shipping_info_postal_address_state
shippingInfo[postalAddress][code]	shipping_info_postal_address_code
shippingInfo[postalAddress][country]	shipping_info_postal_address_country
shippingInfo[postalAddress][type]	shipping_info_postal_address_type
shipNode[type]	ship_node_type
Merchants’ seller ID in Daasity	_seller_id
Merchant’s account ID in Daasity	_account_id
Merchant’s integration ID in Daasity	__source_id
MD5(purchase_order_id)	__sync_key
Timestamp of extraction (UTC)	__synced_at