Walmart CPFR Weekly Manual Data Update Walkthrough

Kyle introduces the Walmart CPFR manual update process, explaining that automations via Apps Script normally handle weekly updates but trainees need to understand the manual process for troubleshooting or off-schedule updates. He outlines the left-to-right tab navigation approach, noting the CPFR tab is updated last.

Kyle demonstrates updating the RJW Summary tab by copying data from the RJW Transfer Sheet's Summary tab and pasting values using Shift+Command+V. He explains the tab shows supply pipeline data including SKU-level inventory at RJW, weekly forecasts, and units in transit from RFI to RJW.

Kyle walks through updating three orange-coded tabs from the Supply Pipeline Report: the weekly Pipeline Overview (a Monday morning BOH snapshot updated once per week), Daily Chicago On Hand from the WMS Daily tab, and Daily In Transit Detail. He warns trainees not to overwrite the formula-protected Column J in the In Transit tab and notes he has locked that column as a safeguard.

Kyle covers the three dark-blue tabs updated from the Eufy team's PSI Report — In-Stock, Historical Store Count, and Sell-Out History — which are updated once per week, typically on Tuesdays. He notes that on this Wednesday the PSI data is still only updated through Week 15, but the Sell-Out History has been updated, and he demonstrates copying that data into the CPFR sheet, mentioning future plans to automate the pull directly from Alloy.

Kyle explains the light-blue teal section driven by Walmart's weekly email ladder plan (268 columns of sales forecast, in-stock rates, order history, etc.), demonstrating how to paste data from the email starting at Column M while preserving formula columns A through L. He then walks through a critical multi-sort step — sorting by Channel Type A-to-Z and then Last Week POS Z-to-A — to ensure Walmart Stores rows appear above Walmart.com rows so VLOOKUP/XLOOKUP formulas grab the correct store-level data.

Kyle covers updating the Actual Orders tab from the Sell-In Data Report's Walmart Pivot, copying the Current Week Forecast to Last Week Forecast as hard-coded values before making changes, updating the Last Week Root Cause Summary from the QTD Forecast Raw Data file filtered to current week and Walmart customer ID 657, and copying Current Week QTD to Last Week QTD to preserve week-over-week comparison integrity.

Kyle demonstrates downloading Walmart's purchase order data from the Nova app on Walmart Retail Link, filtering by supplier ID and current week order create date, and verifying that today's orders are included by running a secondary check filtered to the current date. He then creates a pivot table from the downloaded file to sum ordered units by SKU and pastes the results into the Process PO tab, which uses a formula to project the full-week order quantity based on how many ordering days have elapsed.

Kyle completes the update by returning to the main CPFR tab, entering the current week's Monday date (4/27) to shift all formula-driven data to Week 17, then filtering to Row 24 (Sell-In Forecast) and copying all SKU forecast values one column to the left so hard-coded forecasts align correctly with the new current week. He explains this prevents erroneous week-over-week deltas and notes a zero delta is the expected result after a clean shift, flagging one expected variance due to a mid-week NPI SKU change.