Retail Scanning Inventory 2.0

App used to collect retail inventory by scanning barcode or QR codes

Retail Scanning Inventory is an updated version of the Physical Retail Scanned Inventory that has been developed fresh to satisfy new Android requirements about storage.

To use this app efficiently, you will need at least one external barcode or QR scanner.

Most of the functionality is available for you to test and make sure it meets your inventory needs.

The app allows you to break the inventory into area and/or sections.

Initially, on the app settings, you need to specify a folder on which files can be saved.

The app settings screen has many options that you can choose from:

Default 1 as quantity for the scanned item.

Expand UPC-E items to UPC-A

Allow letters in items

Validate items agains an item master

Allow specific length for items

To start taking an inventory, you need to be on the app home screen.

Start by scanning the barcode or QR code on the product.

The scanners usually are set to automatically send the ENTER key

Now you are ready to enter a quantity, enter the quantity and press ENT (ENTER)

Repeat the scanning and entering quantities.

To change an area or a section, enter a four digit and the AREA/SECTION buttons will be enabled for you to tap and change the area or section.

For quantities, you can enter any valid math expression and the app will evaluate the correct quantity using math principles.

Entry examples

Item/UPC Quantities

012345678901 12

012345678901 2 * 12

012345678901 25 * 2 -1

012345678901 10 + 5

You can set it up to keep entering quantities for an item until a new item is scanned

Item/UPC Quantities

012345678901 2 ENTER

2 * 12 ENTER (24)

4 ENTER

5 ENTER

012345678902 3 ENTER

4 ENTER

On the HOME screen you can HOLD for a few second the button to the right of SECTION button to switch the default quantity to 1 or viceversa.

You can load an ITEM_MASTER.CSV file to validate scanned items.

The app was tested with over 600,000 items for the item master.

ITEM_MASTER.CSV format

The file needs to be CSV (comma separated)

There can be from 1 up to 10 fields in the following order:

Column Data Sample

Item Id 000000100014

Description 40SQ FT(30X16)TRADITIONAL

Quantity on Hand 10

Retail/Price 1.99

Department 084

Department Descr Department 084

SKU 407477

Cost 1.00

Single Count 12

Single UPC 000010001412

NOTE

Columns can be left empty, but the order matters for fields that are used. If you need to have Item,Description and SKU,

you will need include all the other columns in between like:

upc,description,quantity_on_hand,retail,department,department_description,sku

000000100014,40SQ FT(30X16)TRADITIONAL,,,,,407477

When an item master is used, you can activate item validation and if the item scanned is not in the item master, the auditor will need to enter twice to make sure the right item has been scanned

You can view totals by area-section combinations.

You can save the data to a file.

The detailed inventory can be saved as JSON and/or CSV file.

The summarized inventory can be saved as CSV.

When using the computer software to process the inventory, you can download and upload data wirelessly using a WI-FI network that doesn't need internet.

To download the ITEM_MASTER.CSV file thru WI-FI, tap DOWNLOAD ITEM MASTER button on app settings screen.

To upload JSON inventory data, tap the QUICK JSON UPLOAD button on the import/export screen.

You can place the ITEM_MASTER.CSV manually in the folder you configure on the app settings screen and tap the IMPORT FILE button on the import/export screen.

For more efficiency while taking an inventory, it also recommended to use an external Bluetooth keypad. Preferably a mechanical one