Release Highlights
Documentation Changes
- SSI Column Removal: The catlg_item_id column has been removed.
For full details and all advanced notifications, see the Coming Soon post.
Release Highlights
- Documentation Updates
- Store Fulfillment (OPD) – Removal of Last Year (LY) Fields: After further validation, Last Year (LY) data is not supported for the Store Fulfillment table. As a result, all LY fields have been removed from the table structure and related documentation.
Note: Store Fulfillment (OPD) data reflects current-year metrics only.
- Store Fulfillment (OPD) – Removal of Last Year (LY) Fields: After further validation, Last Year (LY) data is not supported for the Store Fulfillment table. As a result, all LY fields have been removed from the table structure and related documentation.
- Table Enhancements:
- Calendar Dimensions Table: The Calendar Dimensions table has been enhanced to include relative Walmart week data, enabling faster aggregation and analysis aligned to Walmart week reporting.
The planned February Release will include the following:
- Calendar Dimensions Table Relative Walmart Week data - The Calendar Dimensions table has been enhanced to include relative Walmart week data, enabling faster aggregation and analysis.
For full details and all advanced notifications, see the Coming Soon post.
Release Highlights
- Documentation Changes:
- SSI Column Naming & Calculation Clarifications: Documentation for the SSI table has been updated to reflect revised business names, technical names, and recommended calculation guidance.
- What's Changed:
- Updated business names and technical names for select SSI columns to better reflect calculation logic.
- Added recommended calculation guidance to column documentation where applicable.
- What's Changed:
- SSI Column Naming & Calculation Clarifications: Documentation for the SSI table has been updated to reflect revised business names, technical names, and recommended calculation guidance.
- New for Suppliers
The planned January Release will include the following:
Table Enhancements
- Store Fulfillment Update The Store Fulfillment (OPD) table has been re-launched with a significantly enhanced schema to support year-over-year analysis and improved store-level insights.
- What’s New
- The table now includes separate This Year (TY) and Last Year (LY) metrics for key Store Fulfillment measures, enabling easier year-over-year comparisons without requiring additional joins.
- New store-level attributes, including Geographic Region Code and Operational Company Code, have been added.
- Column naming has been standardized to clearly distinguish TY (ty) and LY (ly) metrics.
- What Stayed the Same:
- Existing access to the Store Fulfillment (OPD) table remains unchanged.
- Refresh frequency and target refresh times are unchanged.
- Core Store Fulfillment metrics continue to be available, now delivered in an expanded and more analysis-ready format.
- Note: This update introduces a large number of new columns and replaces prior single-year metric fields. Customers are encouraged to review the updated documentation and adjust queries as needed to leverage the new schema.
- What’s New
New Tables
- New for Suppliers:
- SSI Table The Scintilla BI Link pre-joined SSI table delivers week-level aggregated data across nine source tables—Backroom Adjusted Inventory, Inventory Adjustments, MTR, MUMD, Store Customer Returns, Store Fulfillment (OPD), Store Inventory, Store Returns, and Store Sales—in a single pre-compiled dataset. Because the data is aggregated at the week grain, users should carefully review aggregations and calculations to ensure analytical accuracy.
Welcome to BI Link - PSP! 🎉 This initial release includes the following tables. Please see our Documentation section for table details.
New for Suppliers:
- Status: - The Status table lets you know whether or not a Cloud Feed table is available. Please always use this to check the status before calling any tables. The Status table responses will be:
- Completed: The refresh is complete.
- Completed No Data: The table was refreshed, but there are no updates, deletions, or inserts.
- Running: The refresh is in progress.
- Item Dimensions: The Item Attributes table provides Walmart item attribute information, including hierarchy, descriptions, and status.
- Calendar Dimensions: The Calendar Dimensions table provides Walmart calendar Date, month, and week details. This table will be available for Suppliers only.
- Store Dimensions: The Store Dimensions table provides attribute information for the given store number, including information such as location, manager details, and related codes. This table will be available for Suppliers only.
- DC Item Measures: The Distribution Center (DC) Item Measures table provides information about the DC items related metrics.
- Long Range Store Demand Forecast: The Long Range Store Demand Forecast table provides information about the future demand for orders.
- Order Forecast The Order Forecast table provides information about the future demand for orders.
- Store Fulfillment (OPD): The Store Fulfillment (OPD) table provides information about all scheduled store fulfillment orders at Walmart item and store level.
- Store Inventory: The Store Inventory table provides information about inventory at the store level; several types of metrics across in-stock inventory; and markup, markdown, and margins on an item, store, and day grain.
- Store Sales: The Store Sales table provides information about all store sales at item, channel, store, or Date level.
