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-store costs can be accessed using Walmart’s On Request Reporting Platform API’s and accessed in the VENDOR_MANAGED_PRICING report. For more information, please refer to the On Request Reporting Guide about the platform and associated workflows.

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 is not in real time and updated daily. It will take 24 hours for any updates made by suppliers or Walmart to appear in the report.

Invoices Report Information

Key report information includes the following:

Report Name: VENDOR_MANAGED_PRICING

Versions Available: 1

Report Primary Key(s): Item, Store, Distributor

Report Data Refreshed: Every 24 hours (4 AM CT) reflecting previous days changes

Supports Filters Applied to Report: Yes (details below)


Attributes included in the report	Walmart 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 and will always stay consistent/ the same
Value Filters	Supply Item Status Code (Active, Inactive, Deleted), Store Number, Walmart Item Number, Vendor Number
Date Range Filters	Cost 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