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

How to prepare your Mitre 10 data for krunchbox

If you are receiving the Weekly Report Wholesale Sales report from IHG, you will be able to load it directly into krunchbox, without alterations, using the following guide.

steps

Step 1  Source your data from IHG

This template particularly pertains to the IGH report Weekly Report Wholesale Sales .  The report format can be viewed here.

 

image of template

It is important that the report is unchanged, and exactly the same as the template.The load process will work by identifying the header rows are as expected, the column names are the same, and the report format is XLXS

Please do not delete or rename any columns.



Note: This file should contain a single week of sales data.

Step 2 - Upload your Mitre 10 IGH Weekly Report Wholesale Sales data to krunchbox

data load screen-1

  • Through your krunchbox portal > Admin > Partner data management
  • Review the accepted Mitre10 data template matches your 'Weekly Report Wholesale Sales'  document 
  • Next to the Mitre 10 option, browse for your file
  • Select from the calendar the retailer week
  • Upload the file
Once the fie is uploaded, a verification process will occur.  If the file is successfully loaded, the Data Load Status will change to LOADED. If it is unsuccessful, it will be listed as ERROR and you will need to review your format and try again.

Step 3 - View your data in krunchbox 

Dashboards is a great place to start for summaries and exception reporting.

From the menu bar, select Dashboards

menu


Trouble shooting

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

  • If you are providing the file to krunchbox to load on your behalf, please be sure to use the naming convention (your company name)Mitre10(date_reference).xlsx for example CompanynameMitre1020231208.xlsx where the date is YYYYMMDD and email to your krunchbox sales representative.