ITEM1 Serial Inventory

Warehouse 1 · SQLite database

Prefix — · v2.0
Connected to Server
In0
Out0
In stock0
Not signed in

Lookup a serial

Type or scan any serial. Result is instant even at 100,000+ rows.

Waiting for a serial

Live summary

  • Total received0
  • Total shipped0
  • Currently in stock0
  • Active itemITEM1
  • Required prefixITEM1-SN#

Recent activity

No scans yet.

Add an item

Each product gets a code and the serial prefix used when receiving or shipping that item.

Item list

Item code Name Prefix

Receive inventory

IN

Click New Receipt, fill date, quantity, received from, and driver, then scan. Save writes the whole receipt.

Receipt ID: —

No saved receipt open.

Order Quantity 0 Scanned Quantity 0 Remaining Quantity 0
0.00%
Click New Receipt to start

This receipt

No serials scanned yet.

Last receipts

Nothing received this session.

Ship inventory

OUT

Click New Shipment, fill date, quantity, shipped to, and driver, then scan. Save writes the whole shipment.

Shipment ID: —

No saved shipment open.

Order Quantity 0 Scanned Quantity 0 Remaining Quantity 0
0.00%
Click New Shipment to start

This shipment

No serials scanned yet.

Last shipments

Nothing shipped this session.
Item Serial Warehouse Recv ID Ship ID Status Date received Received from Receive driver Date shipped Shipped to Ship driver
Page 1

Import from Excel / CSV

Choose the file, then click Import to check it. Nothing is saved until you click Import again after the check. Cancel leaves the database unchanged.

Import ID: —

No import selected.

Export

Download a snapshot from the SQLite database.

Imports

Click an import to make it active above. Exports are downloads and do not get an ID.

Import ID Date Item code Warehouse Imported Skipped User

Clear all serials

Clear this item removes only the selected item in the warehouse selected at the top. Clear this warehouse removes every item in that warehouse. Delete all serials removes every warehouse.

In stock by item

Superuser only. Quantity is serials still in stock. ALL shows every warehouse. Click an item to see each warehouse.

Item code Quantity

Backup

Version 6.13. Each receipt and shipment belongs to one warehouse. Level 1 users only see warehouses assigned to them.

Backup times

Time

Available backups

FileDateTimeSize

Rules

Restart applies the saved port and opens the app on that address.

Wrong passwords from the same IP are counted. At this number the IP is banned.

No-reply email

These fields let the server send mail from a no-reply address. The password is saved on the server and is not shown again.

Warehouses

Version 5.40. Each receipt and shipment belongs to one warehouse. Level 1 users only see warehouses assigned to them.

CodeName

Users

Level 0 is superuser. Level 1 can receive, ship, and view Records and Inventory, but cannot edit records, items, users, or import.

Username Level New password Warehouses

Banned IPs

An IP is added here after too many wrong passwords. Select rows and remove the ban.

IPFailed triesBanned atReason

Sign in