AerisJet · Inventory

search

Scan QR Code

Or type a code manually:

Recent scans

Bulk edit

Select assets below, then choose a bulk action. Stock-level lot moves are edited per item.

Data & Export

swap_horiz

EZOFFICE INVENTORY MIGRATION

Upload any of the three EZOfficeInventory exports — the importer auto-detects the format. Upload them one at a time: asset_list (serialised assets → type asset), inventory_items (consumables → type consumable), all_asset_stock_report (stock items → type asset_stock). Group and Subgroup become tags. Asset Identification Numbers become QR codes. Custody maps to checkout. Re-running is safe — items are upserted on QR code.

Drop an EZOfficeInventory CSV here
asset_list, inventory_items, or all_asset_stock_report

upload_file

CSV IMPORT

Bulk import items. One row per asset; for stock or consumable items, one row per lot (grouped by itemTitle + itemType). Columns: itemTitle, itemType, tags, location, status, qty, supplier, serialNumber, notes, qrCode.

Drop CSV/XLSX here
or click to browse

download

CSV EXPORT

Export all items to a CSV (one row per asset / one row per lot). Useful for backups or migrating from EZOfficeInventory.

qr_code_2

QR LABEL SHEET

Generate a printable A4 sheet of QR labels (Avery-compatible grid). Select items to include and print directly from the browser.

fact_check

AUDIT LOG

Recent activity across all items. Exports the full audit history as CSV.

User Access

Microsoft users with admin (read-write) access. If this list is empty, all signed-in users are admin.

Theme

Dark mode is the default. Light mode is easier on bright hangars.

Tag Cleanup

Merge or rename tags across all items.

SharePoint Setup

One-time setup: create all required columns on the InventoryItems, InventoryAudit, and AppSettings lists. Safe to re-run — existing columns are skipped.

Locations

Known locations (union of all items). Rename propagates to every item.