Vendor-managed pricing report

The vendor-managed pricing report contains all Drop Ship Vendor (DSV) Orders that have been placed by Walmart for a Supplier within the past 2 months.

All items and store costs can be accessed using the VENDOR_MANAGED_PRICING report in Walmart’s On Request Reporting API.

The joint primary key for this report is the item/store combination. This means each row in the report is a unique item, store, and distributor (supplier) combination.

This report does not return real-time results. Allow 24 hours for any updates to appear in the report.

Vendor-managed pricing report information

Key report information includes the following:

  • Report Name: VENDOR_MANAGED_PRICING
  • Versions Available: 1
  • Report Primary Keys: Item, Store, Distributor
  • Report Data Refreshed: Every 24 hours at 4 AM CT, reflecting previous days changes
  • Supports Filters Applied to Report: Yes, per following table
Attributes included in the reportWalmart Item Number, Store Label Description, UPC, Replenishment Item Type, Vendor Number, Vendor Name, Store Number, Store Specific Cost, Store Specific Retail Price, Corporate Retail Price, Cost Effective Date, Cost Amount, Cost Cancel Date, Cost Received Date, Cost Pricing Type Code, Retail Effective Date, Retail Amount, Retail Cancel Date, Retail Received Date, Retail Pricing Type Code, Supplier Effective Date, Supplier Vendor Number, Supplier Vendor Department Number, Supplier Vendor Department Sequence, Supplier Cancel Date, Supplier Date Received
Supports defining attributes included in the report?No; attributes in this report will not vary
Value FiltersSupply Item Status Code (Active, Inactive, Deleted), Store Number, Walmart Item Number, Vendor Number
Date Range FiltersCost Effective Date; Cost Cancel Date; Cost Received Date; Retail Effective Date; Retail Cancel Date; Retail Received Date; Supplier Effective Date; Supplier Cancel Date; Supplier Date Received