Request an inventory reconciliation report

Use the on-request reports API to generate the inventory reconciliation report for Walmart Fulfillment Services (WFS) items. This report captures net inventory movement over a specified time period.

It helps compare starting and ending quantities for each SKU and track units sold, returned, lost, found, damaged, and other inventory adjustments.

When to use this report

• Investigate inventory discrepancies for WFS items
• Compare beginning and ending inventory for a SKU over a selected time period
• Analyze net inventory movement, including units sold, returned, lost, found, and adjusted
• Export reconciliation data for analysis in internal systems

How it works

The inventory reconciliation report is generated asynchronously using the on-request report workflow:

Create a report request using reportType=INVENTORY_RECON
Check the report status using the requestId
Download the report once the status is READY

Create report request

Sample request

curl -X POST "https://marketplace.walmartapis.com/v3/reports/reportRequests?reportType=INVENTORY_RECON&reportVersion=v1" \ -H "WM_SEC.ACCESS_TOKEN: <access_token>" \ -H "WM_QOS.CORRELATION_ID: <uuid>" \ -H "WM_SVC.NAME: Walmart Marketplace" \ -H "Accept: application/json" \ -H "Content-Type: application/json" \ -d '{ "dataStartTime": "2024-05-01T00:00:00Z", "dataEndTime": "2024-05-31T23:59:59Z" }'

Sample response

{ "requestId": "6f72a4e2-9f3a-4f3e-9f72-2b8a2f5c9d41", "requestStatus": "RECEIVED", "requestSubmissionDate": "2024-06-01T15:30:00Z", "reportType": "INVENTORY_RECON", "reportVersion": "v1", "payload": { "dataStartTime": "2024-05-01T00:00:00Z", "dataEndTime": "2024-05-31T23:59:59Z" }
}

Track and download

1. Check status until the report is ready.

   HTTP

   GET https://marketplace.walmartapis.com/v3/reports/reportRequests/{requestId}

   Status values: RECEIVED, INPROGRESS, READY, ERROR.

2. Download once status is READY.

   HTTP

   GET https://marketplace.walmartapis.com/v3/reports/downloadReport?requestId={requestId}

If you prefer not to poll, subscribe to Report status notifications and receive a callback when the file is ready.