DSV Orders Report
The DSV Orders Report contains all Drop Ship Vendor (DSV) Orders that have been placed by Walmart for a Supplier within the past 2 months.
The Primary Key for this report is the Purchase Order (PO) – Purchase Order Line (PO Line) Combination. This means 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 is not real time – it will take 24 hours for any updates made by suppliers, customers, or Walmart to appear in the report.
DSV Order Report Information
Key report information includes the following:
Report Name: DSV_ORDERS
Versions Available: 1
Report Primary Key(s): Purchase Order Line / Purchase Order Line Number
Report Data Refreshed: Every 24 hours (4 AM CT)
Supports Filters Applied to Report: Yes (details below)
| 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 will not vary and will always stay consistent/ the same |
| 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 11 days ago