How to Navigate Walmart's OTIF Scorecard in Retail Link

Bekah Tatem

By Bekah Tatem, Sr. Content Writer

Last Updated December 17, 2024

9 min read

In this article, learn about:

  • The OTIF Scorecard in Retail Link

  • Downloading and filtering data

  • Viewing your OTIF performance, charges, and purchase order details

For Walmart suppliers, On Time In Full (OTIF) performance is an important measurement of supply chain efficiency, reliability, and the ability to meet Walmart's stringent delivery standards.

In Walmart's words, "OTIF provides unvarnished, accurate, readily available, one version of the truth visibility to our joint on time and in full supply chain performance. This enables all stakeholders to easily view current and trended inbound performance by various levels of the business."

So, how do you access your OTIF data in Retail Link? As Walmart continues to expand its supplier-facing portals, there are multiple ways to access OTIF data. Let's walk through accessing the dashboard and the reports you can download in Retail Link.

Related Reading: 2024 OTIF Performance Metrics

Login to Retail Link, select Apps, then select On Time In Full (OTIF) Scorecard to access the application. If you anticipate using this application often, you can click the star to mark it as a favorite.

Screenshot of a Walmart supplier portal interface displaying various tools. The 'On Time In Full (OTIF) Scorecard' is highlighted with a red border and has a pink 'OT' icon. It falls under the 'Ethics & Compliance' category. Other tools visible include 'Supplier Center' (Accounting / Finance) with a purple 'SC' icon, 'Modular Planning' (Merchandising) with a blue 'MP' icon, 'PO Tracking' (Sourcing / Global Procurement) with a green 'PT' icon, 'Where’s My Stuff' (Ethics & Compliance) with a blue 'WM' icon, and 'SWAS Report' (Merchandising) with a green 'SR' icon. Each tool has an information icon and a star icon for favoriting.

Once you log into the landing page, you'll see the Summary page with the options below across the top and down the left side:

OTIF Scorecard Top Menu

  1. The Performance tab indicates how your business performed across the latest updated week.

  2. The Charges tab provides visibility to all OTIF fines that Walmart has invoiced and shows future projections of non-invoiced POs.

  3. The dropdown menu item labeled OTIF allows you to change views to display dashboards for SQEP, ASN, FMP, and CARS data.

  4. The Filter option is a global filter to customize data. You can also save up to 10 filter settings.

  5. The Download option allows you to download the current page view as a CSV or PDF file.

Screenshot of Walmart's OTIF (On Time In Full) performance summary page for WMT Stores. The interface has a blue header with a notice about quarterly charges for suppliers. Below, there are performance metrics such as 'Prepaid' at 90.00%, 'Collect Ready' at 98.00%, and 'Prepaid & Collect' at 95.00%.

OTIF Scorecard Left Side Menu

  • The bars icon provides the same view as the Performance tab above.

  • The sheet icon provides downloadable PO Details.

  • The grid icon is the Common Compliance View, showing compliance across a variety of areas like OTIF, SQEP, ASN, etc.

  • The letter icon displays My Subscriptions

  • The question mark lets you see frequently asked questions and toggle Portal Help on and off.

  • The megaphone icon shows Walmart announcements. It will also display as a banner across the top of the page at login.

How to Download OTIF Scorecard Files

The process for downloading files applies equally throughout the OTIF Scorecard. If the download button below is visible in the top right corner of a page, then the contents of that page are available for download.

When you click the Download button from the Summary page, you'll be able to select CSV or PDF.

Screenshot of a download dialog box with a white background and black text. The dialog box has a title 'Download' and a section labeled 'Select Type' with two radio button options: 'CSV' (selected, highlighted in pink) and 'PDF' (unselected). Below, there are two buttons: 'Cancel' (plain text link) and 'Download' (a bordered button).

Downloading the Summary page as a PDF will return data as a chart.

Screenshot of a Walmart OTIF (On Time In Full) performance summary dashboard. The top section displays key performance metrics, including: 'ON TIME': 98.00% Prepaid, 98.00% Collect Ready 'IN FULL': 98.00% Food, Consumables, 98.00% General Merchandise, Health & Wellness The data is displayed for 'Week 02 - Week 02 (02/06/2021 - 02/12/2021),' compared to the previous period 'Week 01 - Week 01.' The last update timestamp is '02/23/2021 07:19 CST,' and the report was downloaded on '02/25/2021 10:34 CST.'

Downloading as CSV will return the data as a file with tabs included for each data set, such as accountability information and distribution center performance (see example below).

Screenshot of a download dialog box with a white background and black text. The dialog box has a title 'Download' and a section labeled 'Select Type' with two radio button options: 'CSV' (selected, highlighted in pink) and 'PDF' (unselected). Below, there are two buttons: 'Cancel' (plain text link) and 'Download' (a bordered button)

Note: From the PO Details page, only the CSV download is available.

How to Use OTIF Scorecard Filters

The filters and saving preferences within the OTIF dashboard allow you to customize your view, streamline data analysis, and focus on the metrics that matter most to your supply chain performance.

When you select the filter button, you can choose between WMT Stores (Walmart Stores) and e-Commerce.

Choosing WMT Stores (Walmart Stores) displays the following filter options:

  • 6 Digit Supplier Number

  • 9 Digit Supplier Number

  • Vendor Pool ID Number

  • Distribution Center Number

  • Freight Type (Prepaid or Collect)

  • Merchandising Alignment

  • Supplier Business Unit

  • Department

  • Category

  • Buyer ID

Choosing eCommerce displays the following filter options:

  • 6 Digit Supplier Number

  • 9 Digit Supplier Number

  • Distribution Center/Fulfillment Center Number

  • Freight Type (Prepaid or Collect)

  • Merchandising Alignment

  • Supplier Business Unit

  • Department

  • Category

  • Buyer ID

Use the dropdowns to filter the data you want to view. You can have as many filters as you want, and you may select multiple options in all dropdowns.

Click the Apply button to execute. The page will load to reflect your selections. You'll note there is now a number beside the filter, which indicates the total of filters applied to the current view

To remove your selections, click the Reset button at the bottom.

The filter functionality works the same way across various tabs of the application, although you may see slightly different filter options depending on the specific context or data set available in each tab.

How to Save and Delete Filters

You can save any filter by clicking the Save As button and naming it. You can save up to 10 combinations.

To delete a saved filter:

  1. Select the filter you wish to delete

  2. Click the Manage button 

  3. Click the Delete Filter button

  4. On the popup window, click the Yes Delete button

Frequently Asked Questions about the OTIF Scorecard

Q: Why isn't all the data downloading when I click Download?

A: This issue may be caused by previously saved filters limiting the data. To clear any selections, click the Reset button at the bottom of the Filter menu. Afterward, ensure the Filters Applied field on the main page displays Total Company to include all data.

Q: How do I view historical OTIF data?

A: The OTIF dashboard defaults to displaying data for the most recent Walmart week. To view historical weeks, use the Data displayed for the dropdown menu to select your desired timeframe.

Q: Where can I find PO level OTIF data?

A: Navigate to the PO Details section in the left-hand navigation menu (look for the sheet icon). Once there, use the Performance and Charges toggles at the top left of your screen to access PO Line Level data for each respective category.

Q: Can I compare current metrics to previous periods?

A: Yes, the Trend Analysis chart under the Charges section allows you to compare data across three 13-week ranges and against the same period last year.

Q: How do I interpret the DC Performance map?

A: The map displays Distribution Center locations using colored dots to indicate performance status. Click on a dot to see detailed information about that DC. Use the legend to understand the performance range:

  • Red: 0%--60%

  • Dark pink: 60%--70%

  • Pink: 70%--80%

  • Light pink: 80%--90%

  • Green: 90%--100%

Q: What is the difference between metrics in the Performance tab and the Charges tab?

A: Metrics in the Performance and PO Details tabs include non-compliant Walmart accountable cases/eaches. In contrast, the Charges tab only represents individual supplier performance and excludes non-compliant Walmart accountable cases/eaches.

Q: What are "non-compliant Walmart accountable cases/eaches"?

A: These are instances where Walmart, rather than the supplier, is accountable for non-compliance with OTIF targets. These metrics are included in the Performance and PO Details tabs but excluded from the Charges tab.

Q: Where do I find my international OTIF scorecard?

A: International OTIF data is located in a different application. To access it, go to Retail Link > Apps > OTIF Scorecard Intl. 2.0.

Q: Where do I find OTIF data for Sam's Club?

A: Sam's Club OTIF data is located in a different application. To access it, go to Retail Link > Apps > Sams OTIF Next Gen.

How to Access OTIF Data in Supplier One

Walmart's Supplier One was created with the goal of streamlining some of the more siloed features of Retail Link to be able to introduce a universal system of prioritization for supplier action. As Walmart continues to roll out new features and functionality within Supplier One, you can now access OTIF data within the app.

To view your OTIF data within Supplier One:

  1. Navigate to the left-hand menu and select Performance > Scorecard.

  2. From this screen, you'll see an overview of your OTIF scores.

  3. Click View Report next to your score to open the OTIF Scorecard application for a more detailed analysis.

Stay Connected with SupplierWiki

Did you find this resource helpful? SupplierWiki is dedicated to empowering Walmart suppliers with essential insights and tools for success. Sign up for our weekly newsletter to receive supplier-specific updates, resources, and content directly to your inbox!

Get Better with SupplyPike

Managing Walmart deductions doesn't have to be complex. SupplyPike offers cutting-edge software to help suppliers dispute deductions, maximize cash flow, and uncover critical data insights.

Schedule a call today to learn how SupplyPike can save you time and help you recover your hard-earned money!

Related Content