Scan barcode
Scan with the camera (barcode can be at any angle) or type the barcode — its item details appear automatically if it is in the Master list.
Expiry details
Enter the expiry date manually — day, month, year.
Expiry date photo
Tap to take
Front of item
Tap to take
Master / Import
Load your Store List and item list straight from the Excel sheet. Existing stores and items are updated with the new details; nothing is deleted.
Store List
Sheet Store List of your Excel file
…or paste rows copied from Excel
Item list
Sheet V1 of your Excel file
…or paste rows copied from Excel
After the file is read, the changes appear below for you to review — nothing is saved until you approve it.
Review item changes
Items are matched by barcode and SKU / item code. If both match, only the changed details are shown. If the barcode matches but the SKU is different, the item goes to SKU differs and is never updated unless you approve it. Only the items you approve are saved: update one by one, tick several, or use the “all” buttons.
| Barcode | SKU | Item name | What changes |
|---|
Price list — for the Price checker
…
…or paste rows copied from Excel
Master item list0
Used to look up item details when a barcode is scanned.
| Barcode | SKU | Item name | Category | Vendor | Unit | Price | Type | Active |
|---|
Photo check
Finds log entries whose photo file is no longer in the server's uploads folder (for example if the folder was replaced or emptied while updating the site).
Stores0
Imported from the Store List. Users are linked to a store by its code (Users tab).
| Code | Store | Operation Manager | Area Manager | Location | Region | Type | Users |
|---|
Expiry log
Every scanned entry will appear here along with its status.
| Sr | Barcode | Item Code | Description | Photos | Department | Day | Month | Year | Expiry Date | No. of Days Before Expiry | Status | Final Check | Quantity | Location | Type | Vendor Code | Supplier | Store | Added By | Scanned At |
|---|
Expired items
Items past their expiry date. Confirm whether each was sold, and whether the warehouse sheet (non-returnable) or supplier sheet (returnable) has been made.
Non-returnable items grouped by expiry date, week-wise or month-wise. Each week/month gets its own sheet number; open its sheet to see every item and date in it (print or Excel). Your choices stay saved until you change them. Tap a row to list only its items.
| Week | Sheet no. | Items | Total qty | To return qty | Sold qty | Oldest in store (days) |
|---|
Supplier-wise: how many expired items per supplier, and how many already have their supplier sheet made.
| Supplier | Expired items | Sheet made | Pending |
|---|
| Barcode | Item Code | Description | Photos | Expiry Date | In store (days) | Expired (days ago) | Qty | Location | Type | Supplier | Store | Added By | Scanned At | Sold? | Warehouse sheet | Supplier sheet |
|---|
Returned items
Verified record — items whose warehouse sheet (non-returnable) or supplier sheet (returnable) has been confirmed made. These are removed from the Log and Expired tabs automatically once confirmed.
| Barcode | Item Code | Description | Photos | Expiry Date | Returned Qty | Sold Qty | Location | Type | Returned to | Supplier | Store | Added By | Scanned At |
|---|
Dashboard
Everything still in the Log (items not yet returned), updated live. Tap a card to see those items.
Expiring soonest
Next items to expire (not yet expired).
| Item | Photos | Expires | Days | Qty | Where |
|---|
Expired, by supplier
Expired items still waiting to be returned.
Expiring within 30 days
Expired + near-expiry items by location.
History
Who added, edited or deleted what — the latest 500 actions.
| When | User | Action | Details |
|---|
Users
Create accounts and link each one to a store by its code. Everyone in the same store shares the same Log.
New user
Accounts are created by an admin — there is no public sign-up.