Step-by-Step Tutorial

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

1. Sign into codeREADr.com

2) Create a Service

3) Select ‘Validate Scans with a Database’

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.

Step 2:

Create a new database (simply name it here, later you’ll build your 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.

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

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.

 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’
Example:
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’

Step 2:

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

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’.

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.”

Step 5:

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

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.

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

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.
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

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

3. Select the ‘Import’ tab

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

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

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.