CStoreOffice® Support & Learning

Tobacco Scan Data supporting RBH (Canada)

With this report, you can set up the transaction-level scan data export to the Rothmans, Benson & Hedges Inc. (RBH).

To start working with the report, use the following navigation tips:

Before You Begin

Before you start configuring the Scan Data reports for your locations, make sure they have an active Scan Data subscription.

If a location does not have an active Scan Data subscription, such location is disabled in the report and cannot be configured.

If the location's Scan Data subscription has been expired, the report's data is not sent for this location.

Opening the Report

You can find the report at Reports > Accounting > Export Data > Tobacco Scan Data supporting RBH (Canada).

The report can be opened at all levels:

  • Account
  • Company
  • Division
  • Location (Station)

For more information, see Viewing Reports.

Setting Up the Report's Export

You can set up the data export with the Tobacco Scan Data supporting RBH (Canada) report in the following two ways:

Data Export Control

To control whether the report is exported successfully, you can perform the following actions:

Try sending the report ahead of time

To make sure that the export settings are set up correctly, you may export the report data ahead of the schedule. Do the following:

  1. Go to the top of the report form and set the sending date range. The recommended date range is from Sunday to Saturday. For example, you can take the most recent data range available.

  2. Make sure that its data is correct. Click the Download button, extract the report file from archive and check its data.
  3. Export the report data ahead of the schedule. Click the Send button and wait until the report data are exported. When successful 'Done' notification is displayed, it means your report data are exported successfully.

File Sending Control

CStoreOffice® allows you to control if the required reports are generated and sent successfully to the destination by schedule. To do this, CStoreOffice® introduces a special service—File Sending Control—that is responsible for the following activities:

Submission Guidelines

RBH supports weekly and daily data submission schedules.

Weekly submissions

  • For chains submitting daily transaction sales data on a weekly schedule, sales data must be reported for each SKU/UPC for each store every week.
  • Reports must be submitted no later than the agreed-upon day of the following week.
  • Each reporting week must end on a Saturday.

Daily Submission

  • For chains submitting daily transaction sales data on a daily schedule, sales data must be reported for each SKU/UPC for each store every day.
  • Reports must be submitted by the following day.

Exported File Structure

The report generates the actual data file (containing transactional data) and an audit file for verifying completeness.

Data file

The report exports the data in the plain text file with the pipe ("|") separator. Leading zeros in fields are removed.

The file is named according to the following rules:

  • Weekly report: CH<RBH Chain ID>_<RBH ChainName>_<Week Ending Date (YYYYMMDD)>.txt (for example, CH201_DonsConvenience_20240803.txt)
  • Daily report: CH<RBH Chain ID>_<RBH ChainName>_<Date (YYYYMMDD)>.txt (for example, CH201_DonsConvenience_20240802.txt)
Field Length Description Example
Week Ending 10 Week ending date for the provided file in YYYY-MM-DD format. 2024-08-03
Sales Date 10 The date representing the day of the sale in YYYY-MM-DD format. 2024-07-30
Sales Time 12 The time representing the time of the sale on a day in HH:MM:SS AM/PM format. 10:08:52 AM
Transaction/Receipt Number 20 Receipt number of the transaction 000000001
Store Number 32 The store number assigned by the Chain to the store. The store number should be the store number that the chain’s business users use. 101
Store Name 32 The name of the store - which could also include the store number. Chain #101
Store Address 64 The physical street address of the store. Multiple short address lines can be concatenated together. 1 Main Street
Store City 24 The name of the city per Canadian postal definitions. Toronto
Store Province 2 The province code in two character Canada Post abbreviation (for example, ON = Ontario). ON
Store Postal Code 7 The postal code of the store. Postal code should be in the A1A 1A1 format. M4B 1B3
SKU/Item Category 20 The type or category of product. For example cigarette, pipe tobacco, snus, and so on. Cigarettes
Brand/Manufacturer 20 Brand/manufacturer of the product RBH
UPC Code 14

The UPC (GTIN/EAN/PLU) code assigned to the SKU. GTIN must be provided as a 14 digit non-compressed right justified zero filled code with the check digit in the rightmost position.

A pack of Rothmans King Size 20's and a carton of Rothmans King Size 20's are considered two different SKU's/UPCs.

61900000538
SKU ID 8 This identifier is a code or number that uniquely identifies a SKU in your chain. It could be same value as the UPC Code. ON01202
SKU Description 40 The description of the SKU/Product/UPC Rothmans King Size 25 ONT
Unit of Measure Name 10 The description of the SKU/UPC’s unit of measure. For example pack, carton, pouch, and the like. Pack
Unit Sales Quantity 10 This should be the number of units sold of the stated Unit of Measure. For example if the UOM is in packs, then the Unit Sales should show the number of packs – and the related dollar amount. If the week’s sales for a product/UPC in a given store resulted in a net return quantity then this amount can have a negative value. 10
Gross Sales Dollar Amount 10 Numeric with 2 decimal digits. This should be the total dollar value of units sold before sales taxes and any discounts. 89.99
Net Sales Dollar Amount 10 Numeric with 2 decimal digits. This should be the total dollar value of units sold including any discounts, before sales taxes. 83.49
Discount 10 Numeric with 2 decimal digits. This should be the total discount applied on each unit sold before sales taxes. 6.50
Bundle/Multipurchase Flag 2 A Yes/No flag representing whether a product was sold as part of a bundle. Y
Additional Pricing Fields 15 Any additional pricing fields that help us to determine sales transaction type of the product sold in a particular transaction.  

Audit file

The audit data is provided in the plain text file with the pipe ("|") separator. The first line contains field names. Leading zeros in fields are removed.

The file is named according to the following rules:

  • Weekly report: CH<RBH Chain ID>_<RBH ChainName>_<Week Ending Date (YYYYMMDD)>_Audit.txt (for example, CH201_DonsConvenience_20240803_Audit.txt)
  • Daily report: CH<RBH Chain ID>_<RBH ChainName>_<Date (YYYYMMDD)>_Audit.txt (for example, CH201_DonsConvenience_20240802_Audit.txt)
Field Length Description Example
File Name 30 Transaction data file name. CH201_DonsConvenience_20240803.txt
Week Ending 10 Week ending date for the provided file in YYYY-MM-DD format. 2024-08-03
File Generation Date Time 10 Date and time at which the transaction file mentioned in File Name field is generated . 2024-07-30 10:08:52 AM
Sales Unit 10 Total sales unit reported in the transaction data file mentioned in the File Name field. 1256
Sales Quantity 10 Numeric with 2 decimal digits. Total sales volume reported in the transaction data file mentioned in the File Name field. 12347.60
Record Count 10 Total number of records submitted (excluding headers) in the transaction data file mentioned in the File Name field. 850

Additional Actions

To view the export history, click View Log or click Tobacco Scan Data supporting RBH Export Log at the bottom of the page.

To leave the report interface and go to the home page, click Home.

To view the log of the last export, click Show/Hide Last Transmission log.

For more information on additional report features, see Reports.