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.
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.