# 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](https://developer.walmart.com/home/us-mp/). The following endpoints are used to replicate data into Daasity: * [Fulfillment Orders Status](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) (no historical extraction) * [Inventories](https://developer.walmart.com/api/us/mp/inventory#operation/getMultiNodeInventoryForAllSkuAndAllShipNodes) (no historical extraction) * [Items](https://developer.walmart.com/api/us/mp/items#operation/getAllItems) (no historical extraction) * [Orders](https://developer.walmart.com/api/us/mp/orders#operation/getAllOrders) * [Returns](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) ## Entity Relationship Diagram (ERD) {% @lucid/lucid-component url="" fullWidth="true" %} ## 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](#inventories) * [Inventory Nodes](#inventory-nodes) * [Item Unpublished Reasons](#item-unpublished-reasons) * [Items](#items) * [Return Line Group Label Carrier Info List](#return-line-group-label-carrier-info-list) * [Return Line Group Labels](#return-line-group-labels) * [Return Line Group Return Lines](#return-line-group-return-lines) * [Return Order Line Charge References](#return-order-line-charge-references) * [Return Order Line Charge Taxes](#return-order-line-charge-taxes) * [Return Order Line Charges](#return-order-line-charges) * [Return Order Line Charge Totals](#return-order-line-charge-totals) * [Return Order Line Current Tracking Statuses](#return-order-line-current-tracking-statuses) * [Return Order Line Refund Channels](#return-order-line-refund-channels) * [Return Order Line Tracking Detail References](#return-order-line-tracking-detail-references) * [Return Order Line Tracking Details](#return-order-line-tracking-details) * [Return Order Lines](#return-order-lines) * [Returns](#returns) * [Order Fulfillment Status Order Line Quantity Infos](#order-fulfillment-status-order-line-quantity-infos) * [Order Fulfillment Status Order Lines](#order-fulfillment-status-order-lines) * [Order Fulfillment Status Shipment Lines](#order-fulfillment-status-shipment-lines) * [Order Fulfillment Status Shipments](#order-fulfillment-status-shipments) * [Order Fulfillment Status Shipment Dates](#order-fulfillment-status-shipment-dates) * [Order Fulfillment Statuses](#order-fulfillment-statuses) * [Order Fulfillment Status Order Line Quantity Infos](#order-fulfillment-status-order-line-quantity-infos) * [Order Fulfillment Status Order Lines](#order-fulfillment-status-order-lines) * [Order Fulfillment Status Shipment Lines](#order-fulfillment-status-shipment-lines) * [Order Fulfillment Status Shipments](#order-fulfillment-status-shipments) * [Order Fulfillment Status Shipment Dates](#order-fulfillment-status-shipment-dates) * [Order Fulfillment Statuses](#order-fulfillment-statuses) * [Order Line Charges](#order-line-charges) * [Order Line Refund Charges](#order-line-refund-charges) * [Order Line Statuses](#order-line-statuses) * [Order Lines](#order-lines) * [Orders](#orders) ### Inventories * Endpoint: [Inventories](https://developer.walmart.com/api/us/mp/inventory#operation/getMultiNodeInventoryForAllSkuAndAllShipNodes) * 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](https://developer.walmart.com/api/us/mp/inventory#operation/getMultiNodeInventoryForAllSkuAndAllShipNodes) * 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](https://developer.walmart.com/api/us/mp/items#operation/getAllItems) * 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](https://developer.walmart.com/api/us/mp/items#operation/getAllItems) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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 {% hint style="warning" %} The `refundedQty` field represents the actual quantity of items accepted as returned and refunded, sourced directly from the Walmart API response and mapped to the `refunded_qty` column in the database. This value is distinct from the original order line quantity (`quantity` from the `order_lines` table) and should be used for accurate calculation of return metrics, refund totals, and net unit values. Refunded quantities are always processed as positive values in the `return_order_lines` table; negative values in net unit calculations are applied during metric aggregation to represent the deduction from gross sales. {% endhint %} | 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/returns#operation/getReturns) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/fulfillment#operation/getFulfillmentOrdersStatus) * 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](https://developer.walmart.com/api/us/mp/orders#operation/getAllOrders) * 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](https://developer.walmart.com/api/us/mp/orders#operation/getAllOrders) * 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](https://developer.walmart.com/api/us/mp/orders#operation/getAllOrders) * 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](https://developer.walmart.com/api/us/mp/orders#operation/getAllOrders) * 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](https://developer.walmart.com/api/us/mp/orders#operation/getAllOrders) * 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 |
--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/walmart-marketplace/integration-specifications.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.