RJ Reynolds Retail Scan Data Report

RJ Reynolds Retail Scan Data Report Overview

The "RJ Reynolds Retail Scan Data Report" is a scan data format developed by RJ Reynolds (the manufacturer) to facilitate the secure export of retail scan data reports to the RJ Reynolds server.

RJR scan data reports serve as a valuable analytical tool for both the manufacturer and retail partners. These reports offer actionable insights into consumer purchasing behavior, product performance, promotional effectiveness, and overall sales trends. They also support compliance tracking and strategic decision-making around inventory and marketing.

The FTx Cloud POS system at your store allows you to collect scan data — which can be measured and compiled into reports — when an item is scanned/sold at the register. This transactional data is then aggregated and formatted into weekly reports, which can be submitted to RJ Reynolds for further analysis. The manufacturer leverages this data to evaluate consumer buying patterns, optimize promotional programs, ensure regulatory compliance, and enhance supply chain forecasting.

Key Considerations Before Implementing the RJR Scan Data Functionality:

To include buydowns and discounts information along with sales data in the report, you need to configure a few settings for each discount and buydown created for tobacco products in the "Discounts" and "Buydowns" modules.
Also, ensure the "Hide Scan Data Options" setting in "Product/General Settings" (Maintenance>>Settings & Panels >> POS >> Product/General Settings) is set to "No."
Configure a single FTP/SFTP and send a unified scan data report file for all locations.

This article includes:

"RJ Reynolds Retail Scan Data Report" overview
How to create a single FTP/SFTP
How to view the run history of scan data
How to generate scan data files

Prerequisite Settings for RJR Scan Data Reports

There is a loyalty setting that needs to be configured first and foremost to get started with RJR Scan Data export files:

Go to Maintenance>> Select Settings & Panels>>Loyalty Settings>>RJR Settings

Figure 0.0

Enter the company ID provided by RJR that is needed in the scan data exports.

Reaching the "RJR Retail Scan Data Report"

To reach the "RJ Reynolds Retail Scan Data Report," follow the below steps:

Step 1: Log into Control Center
Step 2: Choose Point of Sale
Step 3: Choose Reports
Step 4: Choose Scan Data
Step 5: Choose RJ Reynolds Retail Scan Data

Figure 0.1

See Figure 0.1. You will see 3 types of scan data reports that will be useful to your retail business. By clicking the "Choose Report" drop-down selection, you will see the different types of scan data reports.

1. Understanding the "RJ Reynolds Retail Scan Data Report"

By clicking "RJ Reynolds Retail Scan Data," you will be redirected to the "RJ Reynolds Retail Scan Data Report" page with relevant connection and report options.

Figure 1.0

Please see Figure 1.0 to know all the information needed to be filled out in the RJR Scan Data Exports.

Figure 1.0 displays the below-mentioned topics, which are explained below:

1. General Information: This displays general information explained below in the 1.1 General Information section.
2. FTP Configuration: This displays information on FTP configuration explained below in the 1.2 FTP Connection section.
3. Promotions: It displays information on promotions explained below in the 1.3 Promotions section.
4. Report Options: It displays information on explained below in the 1.4 Report Options section.
6. Filters: This displays information on report filters explained below in the 1.5 FTP Connection section.
6. Action Buttons: This displays all the action buttons explained below in the 1.6 FTP Connection section.

1.1. General Information:

Report Type: This field lets you select the scan data report format type as RJ Reynolds Scan Data, PM/UST Retail Scan Data, or ITG Retail Scan Data: Here, you have to pick "RJ Reynolds Scan Data."
Notification List: Enter the email address of the individual who should receive a notification when the scan data report is sent to the manufacturer.

1.2. FTP Connection:

Single FTP/SFTP Connection: If this toggle is set to "Yes," then a single scan data file is generated for all the locations. If this is how the manufacturer wants the file, then establish the FTP connection as per the details provided by RJR needed to establish the FTP connection (explained below).

Enable Auto Send: This is a toggle that, when set to "Yes," enables you to auto-send the RJR file on the RJR server every week. If set to "No," you can generate scan data files manually with the "Generate Files" button (the process is explained below).
Once you enable it, the Auto Send At field will appear, as Figure 1.2.1 shows.

Auto Send: Select the day and enter the time for scheduling the auto-send feature for a particular day and time.

Figure 1.2.1

Method: Choose the method of making the connection with the RJR server. The drop-down selection is: FTP| SFTP| FTP Active.
Port: Enter the port number that was provided by RJ Reynolds, e.g., 21, that is utilized by your store.
FTP Site: Enter the IP address (or domain) where the file will be placed on the server.
Username: Enter the user name needed for FTP configuration.
Password: Enter the password to access the site.
Folder: This field requires the mention of the FTP folder where the generated file is to be kept.

Once done, click on the "Save" button in the top right corner.
Test FTP/SFTP Connection: This button lets you test the FTP/SFTP connection once it is established. See Figure 1.2.2.

Figure 1.2.2

In case the Single FTP/SFTP Connection toggle is set to "No," you can configure specific location(s) as highlighted in Figure 1.2.3.

Figure 1.2.3

1.2.1. Add New Config:
This button lets you establish the FTP connection for the selected location(s).

Figure 1.2.1.1
1. Location Field and FTP Configuration:
The field for Location Field and FTP Configuration and the steps to configure the FTP connection are the same as above.
But you can add/configure locations for the scan data from Manage Location Assignment. (explained below).

2. Manage Location Assignments:
Under this section, the locations are selected and configured for sending location specific data. You can either choose All, By Locations, or By Location Groups.

   Figure 1.2.2.2
If you choose "All," the system will add all your store locations. But if you choose "By Locations," follow the below-mentioned steps to select and apply the location selection. See Figure 1.2.2.3.
Figure 1.2.2.3
Find Location: Use this Search box to search for a specific location by name or location number.
Pricebook Zones: You can filter the location records results by pricebook zones. Make the selection as needed.
All Active: This is a drop-down that helps you choose the location type as All, Only Active, or Only Deleted.
Results: This section shows the list of selected parameters. For example, if you have chosen the "Store" tab, it will show a list of stores.
Selection Checkboxes: You must select the required stores by ticking the checkbox.
Arrow: Click the green Arrow button to move the selected stores to Selected List.
Click the "Clear Selection" button to remove the whole selection. To remove any record from the list, click the Remove (x) icon.
Click "Apply" to apply the selection for generating the report or you can click on close to discard changes.

  Figure 1.2.2.4
Once done, click on "Save Config" to save the changes made.
3. Custom Location Settings

This section is useful when you create a Config for each location. You can enter customized fields per location and if a field is left blank, it will use the base report options.

Figure 1.2.2.5
Outlet Name: It is the outlet name on the first column of RJR/lTG scan data and also part of the file name. This should only need to be entered one time once validated.
Submitter ID: This is a unique identifier assigned to entities that submit data electronically.
Retailer Name:  It refers to the name of the store or retail chain that is submitting the sales data.

1.2.2. Location-Specific Action Buttons

These are common actions that are common for all the configured locations.

Figure 1.2.2.6
Download: This button is for the corporate side users who download and verify the report data. When you click on this button, the form highlighted in the Figure 1.2.2.8 below will be displayed.
If the Test File toggle is set to "Yes," then the file is downloaded as a test file.

Send: This button is to send the scan data over the FTP/SFTP connection on RJ Reynolds' server. Figure 1.2.2.7 will be displayed.

Figure 1.2.2.7
If the Test File toggle is set to "Yes," (as highlighted in Figure 1.2.2.7 above), then the file will be sent as a test file and the manufacturer would be notified that it is a test file.

Figure 1.2.2.8
Edit: Clicking this button allows you to modify the FTP connection and the configured location(s). Upon clicking, the Edit FTP Connection window will appear. Make the necessary changes and then click the "Save Config" button to apply the changes.
Remove: This button will remove the FTP configuration for the associated location.

1.3. Promotions

"Promotions" displays the active discounts and buydowns in the scan data report.

Discounts: This tab lists all active discounts in the scan data report, including Discount Name, Start Date, and End Date.

Figure 1.3.1

To ensure the discount is included in the scan data report, make sure to enable the "In Scan Data Report" toggle on the Edit Discount
page as highlighted in the Figure 1.3.2.

Figure 1.3.2

Buydowns: The "Buydowns" tab lists all active buydowns in the scan data report, including the Buydown Name, Start Date, and End Date

Figure 1.3.3

To ensure the buydown is included in the scan data report, make sure to enable the "Include in Scan Data Report" toggle on the Edit Buydowns page as highlighted in the Figure 1.3.4.

Figure 1.3.4

1.4. Report Options:

Figure 1.4.1

Provider: These are the companies that offer services to collect, analyze, and report sales data, often for retail and tobacco products.
Submitter ID: This is a unique identifier assigned to entities that submit data electronically.
Retailer Name:  It refers to the name of the store or retail chain that is submitting the sales data.
Outlet Name: It is the outlet name on the first column of RJR scan data and also part of the file name. This should only need to be entered one time once validated.  See Figure 1.4.1. Here, Middletown is the outlet name.

  Figure 1.4.2
Device Multi Pack: If you enable this button, the system will split the scan data records into segments of 2.
For example:
If one or two records are in the scan data file, it will have one row.
If three or four records are in the scan data files, it will have two rows.
If five or six records are in the scan data file, it will have three rows.
Auto Flag Promo: The toggle will automatically apply to the scan data if set to "Yes."

Figure 1.4.3
Flag as Resubmission: If this toggle is set to "Yes," the system will add the "_RESUB" suffix to the file name for the RJR to identify the file as a resubmitted file.
Include Header: Enabling this toggle to Yes will allow users to generate the scan data file with or without a header row. This provides flexibility when submitting scan data to RJR or external systems. When Include Headers is enabled, the file includes the following column headers:
Outlet Name, Outlet Number, Outlet Address1, Outlet Address2, Outlet City, Outlet State, Outlet Zip Code, Transaction Date/Time, Market Basket Transaction ID, Scan Transaction ID, Register ID, Quantity, Price, UPC Code, UPC Description, Unit of Measure, Promotion Flag, Outlet Multi-pack Flag, Outlet Multi-pack Quantity, Outlet Multi-pack Discount Amount, Account Promotion Name, Account Discount Amount, Manufacturer Discount Amount, Coupon PID, Coupon Amount, Manufacturer Multi-pack Flag, Manufacturer Multi-pack Quantity, Manufacturer Multi-pack Discount Amount, Manufacturer Promotion Description, Manufacturer Buy-down Description, Manufacturer Buy-down Amount, Manufacturer Multi-Pack Description, Account Loyalty ID Number, Coupon Description.
Note: Enabling headers affects the file format only and does not change report data values. Use this option only when headers are required for RJR submission guidelines.
Coupon Department: This field lets you choose the department that handles the RJR coupon.

1.5. Filters:

This part is for adding filter types with the "Add Filter" button.

Add Filter: This button lets you add (filter) items in the scan data file you precisely need to generate files for.
From Add Filter Type, choose the item type from the drop-down as shown in Figure 1.5.1.

Figure 1.5.1

Depending upon the selection made from the drop-down displayed in Figure 1.5.1, you can manage the selection as below.

Figure 1.5.2

Manage Filters: As per the selection, you can manage item filters by following the steps explained below:

Figure 1.5.3

Find a Product: Use this search box to search for a specific product by name or UPC.
All Items: This is a drop-down that helps you choose the product type: All items, child items only, parent item, or standalone items.
Results: This section shows the list of selected parameters. For example, if you have chosen the "Store" tab, it will show a list of stores.
Selection Checkboxes: You must select the required stores by ticking the checkbox.
Arrow: Click the green Arrow button to move the selected items to Selected List.
Clear Click the "Clear Selection" button to remove the whole selection. To remove any record from the list, click the Remove (x) icon.
Click "Apply" to apply the selection for generating the report or you can click on close to discard changes.

The added products will be displayed as highlighted in the Figure 1.5.4.

Figure 1.5.4

1.6. Actions Buttons

Figure 1.6.1

Cancel: This button lets you cancel the changes you make at any time.
View Run History: This button lets you view the scan data history log. For more information, please refer to 3. View Run History.
Generate Files: This button generates the scan data files. For more information, please refer to 2. Generate Files.
Save: This button lets you save the changes you make at any time.

2. Generating RJR Scan Data Files:

If the "Enable Auto Send" toggle is set to "No" (refer to the section under Figure 1.2.1 above), then you can generate scan data reports manually. To generate RJR scan data files manually, please follow the below steps:

Make the export format settings as required and explained above.
Click on the Generate Files button.
The form highlighted in Figure 1.7.1 is displayed.

Figure 1.7.1

Fields:

Time Frame: The manufacturer wants the scan data file to be sent the same day every week. Hence, the time frame generally is one week, and if the Enable Auto Send toggle is set to "Yes," it will auto-send the report that same day every week.
Test File: If this toggle is set to "Yes" and if you click on the "Download File" and "Send" buttons.

Buttons:

Close: This button lets you exit the Generate File form.
Download File: This button lets you download the file.

Figure 1.7.2

Send: This button will send the scan data file to RJR.

3. View Run History:

This section allows you to view the run history of the scan data files — whether the file is sent over FTP/SFTP or downloaded by corporate users.

Figure 1.8.1

Type: This is the format of the scan data report; it is RJR in this case.
Run Type: This is the run type of the report, whether it was downloaded or sent over FTP/SFTP.
Ran At: This is the date and timestamp when the report was sent or downloaded.
Start Date: This is the start date of the predefined time frame for sending over the report.
Stop Date: This is the stop date of the predefined time frame for sending over the report. The timeframe is most often set to 1 week.
File Name: The name of the scan data file is mentioned here.
Actions: The actions mainly include the "Download" button for downloading the file.
Cancel: This action exits you from the form.

4. FTx Academy Training Course

Check out this FTx Academy video to learn how to set up and submit RJR retail scan data reports for your manufacturers.

Check out this FTx Academy video to learn how to set up and manage scan data discounts.

To gain a more comprehensive understanding, sign up for the FTx Academy training program — enroll in the courses and explore the topic lesson by lesson and reinforce your learning with quick quizzes at the end of each module.