Retail Scanning Inventory 2.0

Ponce Solutions

About this app

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

What's new

The app is not longer using a directory to send file to the local web server.
It is using a string directly from the database.
The user was getting an error because the directory wasn't set.
This update removes the directory condition when sending the string.