Skip to content
  • There are no suggestions because the search field is empty.

How to prepare your Walmart data for krunchbox

The following explains how to source the Walmart USA data from the Retail Link portal in a format that can be uploaded to krunchbox. krunchbox offer data retrieval services for obtaining the data.

steps to load walmart-1

Step 1  Download your data from Walmart

  • Sign in to your Walmart Retail Link account

    log in screen

    landing page


  • If you don't already, add the app Decision Support - New.

    app

    decisions support new app
  • Build out the report

    Build report landing page-1

    • Under Templates, Select Sales and Margin > Store details

      step 1 build report
    • There are a lot of options on the menu. The search function will make it faster to find the ones in the template. These fields come from the Report Columns section

      step 2 use search function
    • The search will show you what area the result was listed under.  Click on the desired field to add it to the 'Selected Columns' box. Do this for all fields in the template.

      step 2 use search results

    • When all the fields are selected, in the same orders as this template, it is time to select the products for the report.  Go to the Items tab,
      select Filters,
      and Vendor Nbr (6-digit) .
      Enter your vendor numbers and add them to the template.
      Note, if you have multiple vendor numbers, be sure to use the OR when adding additional vendors numbers.

      step 3 add items-1
    • Now add the Store detail. Go to the locations tab. 
      Select Stores
      Select Store Type Breakdown
      and select All Stores to show in the Selected locations box.

      step 4 add locations
    • Select the time period for the reports. In this example, we show how to make a selection to you can save the report and schedule for it to be rerun with the current selections each week.

      Tap in the Times tab,
      select Time Range 1,
      select by Fuzzy dates,
      and Time Range 1 Last week

      step 5 select times

    • That's all the selections for the data.
      Now go to the Submit tab to prepare the report for export
      Delivery method = browser
      Format = Excel 2007

      We recommend you select Weekly Schedule which will save you making the same selections each week

      Schedule = weekly 
      Select Fri (Friday) for end of week
      Use the calendar to select the first Friday the report will run

      The click Run Now

      step 5 export options
    • The Status will show you whether the report is ready.  When it is, click to download.
    • To retrieve a scheduled report, log back in and navigate to the Decision Support- New app and check the Status.  

      step 8 retrieve report

Step 2 - Upload your Walmart data to krunchbox

  • Through your krunchbox portal > Admin > Partner data management
    Review the accepted Walmart data template matches your Walmart data extract
    Select from the calendar the retailer week
    Upload the file

Step 3 - View your data in krunchbox 


Dashboards is a great place to start for summaries and exceptions.

Possible enhancements

When reporting by location, it is possible to report dotcom sales separately from the total.  When subscribing to krunchbox, we report stores vs dotcom so the channel of sales can be identified

 

Trouble shooting

Having trouble loading to the specific Walmart template?  Try using the Alternative load template which is a simplified, non-retailer specific, data template.

If you don't have store level data, the column should be filled with WALMARTUSA