DSV orders report
The DSV orders report contains all drop ship vendor (DSV) orders that have been placed by Walmart within the past 2 months.
The primary key for this report is the purchase order (PO)/purchase order line (PO Line) combination. Each row in the report is a unique PO/PO line combination. A single supplier PO can be repeated multiple times if there are multiple PO lines in the order.
This report does not return real-time results. Allow 24 hours for any updates made by suppliers, customers, or Walmart to appear in the report.
DSV orders report information
Key report information includes the following:
- Report name:
DSV_ORDERS - Versions available: 1
- Report primary keys: Purchase Order Line/Purchase Order Line Number
- Report data refreshed: Every 24 hours at 4 AM CT
- Supports filters: Yes, per the following table:
| Attributes included in the report | Purchase Order Level: – Purchase Order Number; Customer Order Number; Ship Node; Order Date; Ship By Date; Purchase Order Status; Total Purchase Order Cost; Purchase Order Line Level Attributes – PO Line Number; Purchase Order Line Status; Cancellation Reason; GTIN; SKU; Walmart Item Number; Product Name; Quantity Ordered; Quantity Shipped; Item Retail Selling Price; Item Cost; Total Purchase Order Line Cost; Customer Name; Customer Phone Number; Ship to Address 1; Ship to Address 2; City; State; Zip; Ship To; Carrier Method; Shipment Date; Order Tracking Number ID |
| Supports defining attributes included in the report? | No; attributes in this report do not vary |
| Value Filters | Purchase Order Status; Purchase Order Line Status ; Cancellation Reason; Ship Node |
| Date Range Filters | Order Date; Ship By Date; Shipment Date |
Note 1: This report has orders from the past 2 months by default. Users can ask for orders data from the past 2 years, however this is not an advisable best practice as it will increase the report generation time.
Note 2: If a single customer order contains items spread across multiple DSV suppliers, the PO order line status may include multiple values. This is a known issue that Walmart is working on resolving. The overall PO status, however, will be correct.
Note 3: Purchase orders that were cancelled by suppliers due to being “unrecognized” or having incorrect data, and then later re-issued by Walmart for the same customer order with a new purchase order number will not be present in the report. You can identify by searching for multiple orders with the same Customer Order Number
Updated 4 days ago