Advanced: How to Create a Retail Price Audit that Validates Scans Against a Database

Step-by-Step Tutorial

1. Sign into

Barcode Scanner App

2) Create a Service

Create a scanning service

3) Select ‘Validate Scans with a Database’

Validation database for scans

Step 1:

Select one of these options: Online in Real-Time or On-Device and later sync online.
Note: We recommend that you select ‘On-Device and Later Sync Online’ because many indoor locations don’t have stable Internet connections throughout the facility.

Real-time or on-device sync

Step 2:

Create a new database (simply name it here, later you’ll build your database)

Select a database

Step 3:

Select Status of duplicate scan: Select duplicates = Valid or duplicates = Invalid

By default, any scan that has already been scanned will be marked as ‘Invalid’. You can change this to ‘Valid’ if you need to scan the same barcode more than once.

Select status of duplicate scan

3) Name the service (required) and add a description for the app user to see (optional).

Describe your service

4) Select which app users are authorized to access this service on their device.

Note: You can have an app username and password for each app user or a single one for all users.
 We suggest you add one or more app-users. A common method is to have the username prefix be the initials of your organization followed by text or numbers, e.g. ABC-001, ABC-002, etc.
Authorize users to scan

 5) Add one or more Questions (prompts) for data collection. Create your own custom questions or select questions from the list of ‘Available Questions’.

The most common prompts for Price Audits are ‘Short Answer’ question types, ‘Multiple Choice (Single Answer)’ question types, and ‘Dropbox Collection’ question types where a photo can be taken and saved in the scan record.

Step 1:

Select ‘Add a Question’
Question:                                                                             Question Type:
If the displayed pricing the standard price?                   —  (Multiple Choice, Single Answer)
If not, is the price the promotional price?                      —  (Multiple Choice, Single Answer)
If neither, enter the displayed price here.                      — (Short Answer – Manual)
Take a photo to document the discrepancy.                  — (Dropbox: Image Only)
Step 1: Select ‘Add a Question’
Coding custom questions

Step 2:

Name the question and select an ‘Answer Type’ in the dropdown menu. Submit the question when complete.

Name the question

Step 3:

Drag the questions from the list of ‘Available Questions’ into the appropriate field to the left i.e. ‘Ask after submitting a Valid Scan’.

Add questions to scan flow

Step 4:

Add a new Short Answer (Manual) Question after an invalid scan.

Example: “This item is not in the database. Enter item description and displayed price if it should be added to the database.”
Add questions after invalid scans

Step 5:

When finished creating / including questions into the service. Save and Continue.

Save question flow

6) In the Advanced section you might want to consider checking the following boxes:

  • ‘Allow users to delete scans saved on device.’ This option is useful in case the app user made an entry mistake.
  • ‘Allow users to edit answers saved on device.’
  • ‘Manual Sync (auto check for new database after scan upload)’
  • ‘Email me when on-device scans are uploaded.’ Check this option if you need an immediate alert and you don’t plan on creating a report template option on the Scans page – the place where scans are normally filtered and downloaded on demand.
  • ‘Track the device’s location at the time of each scan. Collect it …’  Check this option if you want to track the app user’s GPS location. (The most common selection is ‘without interruption as a scan property’ which we call ‘background GPS’.)
  • ‘Improve performance by targeting the barcode format(s) of this service.’ Check this option if you know the barcode type(s) you will be scanning – it can make scanning faster.
codeREADr advanced settings

7) Review the service and select ‘Done’ to complete service creation.

Save scan service

Part Two: Fill the Database

Note: To have this new service loaded to a mobile device or tablet, the app user will need to sign out and sign back into the app or refresh its services.

Step 1:

Create CSV file
Item UPC codes (barcode values) must be in column ‘A’
The ‘Response’ (The text or HTML content you want the app user to see after a scan) must be in Column ‘B’
Below is an example spreadsheet for a retail price audit.
Fill the barcode database
To create a database CSV file in the correct format, please click here.

Step 2:

Upload the CSV file:
1. Click the ‘Database’ link in the navigation bar
Upload the csv database

2. Select the ‘Edit’ option for the service in which you would like to edit

Edit the database

3. Select the ‘Import’ tab

Select import database

4. Click ‘Browse’ to select the CSV file from your computer, then click the ‘Import Database’ button.

Import the CSV database

After your file has been uploaded and processed, your barcode’s value and responses will quickly fill your database.

View database barcode values
Important: Updated databases for ‘On-Device’ service types must be uploaded to the mobile devices or tablets when the devices have access to the internet.
Please Read our Best Practices: Price Audit – Retail  article and / or watch the video below for more information.