This step-by-step guide will show you how to download your Kroger sales data and upload it into Repsly’s reporting system. This is a manual process that must be repeated whenever you’d like to make new sales data available in Repsly.
Step 1: Download your latest sales data
To begin, you’ll need your latest point-of-sale data file from Kroger. Most brands access this data via the Kroger 8451o (Market 6) portal. Others receive this data from their brokers via email.
If you access your POS data via the Kroger 8451o portal:
- Log in to the Kroger 8451o portal.
- Next, you will create a new OnDemand report template that matches the data contained in this sample file. (You will re-use this template each time you download your Kroger sales data to ensure the formatting is correct.)
- Start by selecting the Business Review Integrated standard report.
(Report Wizard > Personal > Report Library)
- Then, select the Locations, Dates, and Products you would like to report on. (Fig. 1) Under Date, please select “fiscal week” (Mon - Sun). You can download this data either weekly or monthly.
- Under Measures, be sure each of the 25 column headers contained in this sample file are selected, and arrange them under Field Order to match the order from the sample file.
- Select Run Report, and click Export > Data Only, and download as an .xlsx file.
- Be sure to name the file as follows: Kroger_Time reference (e.g. 'Kroger_202008' or 'Kroger_202008_202009')
If you receive point-of-sale data from your broker via email:
- Download the attachment as an “.xlsx” file.
What should my POS file look like?
Once you’ve downloaded your POS data file, compare it to the sample file attached here. Your file should contain all of the column headers included in the sample file in the same order, with exactly the same column names and formatting. It is common for the first few rows to contain metadata (as shown in the example below), but Repsly can also accept files that begin with the column headers in Row 1.
You can see a preview of the sample file below, for reference:
What happens if my POS file doesn’t look like that?
If your file does not match the format of the sample file, please revisit the download template in the Market 6 portal and ensure that all of the required data elements, and no unnecessary elements, are included.
If you received your POS file from your broker, please make sure that all of the required column names are included and that the columns are in the same order as they appear in the sample file.
Step 2: Upload your Kroger POS file to Repsly
Now that you’ve downloaded your POS file, you’re going to upload it to a unique AWS S3 bucket*. This will allow Repsly to pull your sales data into the application.
*An AWS S3 bucket is a cloud-based location for data storage and sharing. You can securely upload files to your unique bucket, which gives Repsly access to download and use those files (like a shared folder).
- Your Repsly Customer Success Manager will send you a unique Access Key ID. You will use these credentials to access your dedicated S3 bucket.
- There are several ways to access your S3 bucket (including API). We recommend using a free tool called Cyberduck, which allows you to simply drag and drop your POS file into the S3 bucket.
- Download Cyberduck here, and open the application.
- If you’re using Cyberduck for Windows, click on Open Connection on the upper left side of the application. (Fig. 2a)
- If you’re using Cyberduck for Mac, click on the + symbol at the bottom left side of the application to add a New Bookmark. (Fig. 2b)
- Next, you’ll see a dialog box where you’ll enter the credentials your Customer Success Manager sent you.
- In the dropdown FTP (File Transfer Protocol) select Amazon S3.
- Under Access Key ID, paste your AWS access key
- Under Secret Access Key, paste your Secret AWS access key
- Go to More Options > Path and type: repsly-pos/ then paste your Company rowid (Fig. 3)
- Click Complete
- Drag your POS file into the Cyberduck window to upload. (Fig. 4)
- After loading your POS file into the S3 bucket you will receive an email notifying you that your upload to Repsly has been initiated.
Fig. 3 (sample credentials, yours will be unique)
Step 3: View your Kroger POS data in Repsly
Once Repsly has finished processing of your data, you will receive an email notifying you that your upload is complete. Now, you can view your brand’s latest Kroger sales data in Repsly’s Insights Dashboards, alongside the store-level observations and activity data collected in Repsly.