Admin Settings

Manager or admin sign-in required.

Product lookup index manager

Managers can monitor and rebuild the receiver lookup index when an admin is not available. No other admin tools are exposed to managers at this time.

Lookup index status is not loaded yet.

Index Waiting for manager or admin session.

Use Rebuild now after large Lightspeed catalog changes or when you want to retest the indexed lookup path.

Shared pricing settings

These values apply to receiving and product creation for all users.

Raw spreadsheet manifest builder

Select a raw spreadsheet from the Work folder, enter paid and retail totals, and save a new working workbook into the Manifest folder.

Raw spreadsheet

What was paid Retail total

Supplier

Formula preview —

Percent = (Paid + (Paid × 30%)) ÷ Retail

Output workbook columns are generated to match the app processing table, including Qty, KFO Retail, Processed Qty, Remaining Qty, Status, and Supplier.

Accepted raw file types: .xlsx, .xlsm, and .csv. Required columns: Item #, Item Description, QTY, Unit Retail, and Category.

Monthly archive

Closed-month processing totals move here automatically based on the process log history.

Loading monthly archive...

Month	Products	Units	People	Created	Received
No monthly archive loaded yet.

Saved suppliers

Manage the supplier names available in the manifest builder dropdown.

Saved suppliers appear in the dropdown above.

No saved suppliers yet.

Stale inventory report

Check Lightspeed for products that still have quantity on hand but have not been updated recently. This uses the Lightspeed product updated date as the stale-age proxy.

Stale after days Minimum qty on hand Max rows

Include suppliers

No suppliers included. All suppliers will be checked.

Loading suppliers...

Run the report on demand. Results show items with stock on hand and an old Lightspeed updated date.

Report Not generated yet.

Item #	Title	Qty	Updated	Age	Price	Retail value
No stale inventory report yet.

Missing images

List Lightspeed products without a picture and add an image URL or upload a file for the selected product.

Search Max rows Only show 0 qty items

Load the report to find Lightspeed products without a picture.

Report Not generated yet.

Item #	Title	Qty	Supplier	Action
No missing-image report yet.

Select a product to add an image.

API keys and secrets

Store API keys in an encrypted server-side file instead of leaving them directly in .env. A single SECRET_STORE_MASTER_KEY must remain in the environment to unlock the encrypted store.

Secret store status not loaded yet.

Update one or more values below, then save them into the encrypted store.

Inventory audit

Generate a random 25-item count sheet, print it, then come back later to reconcile counted quantities in Lightspeed.

Inventory audits are stored on the server.

Created	Status	Progress	Action
No inventory audits yet.

Select an inventory audit to view or print it.

Audit history

Created, saved, reconciled, and deleted audits are logged here.

When	Action	Audit	Status	By	Note
No audit history yet.

Access roles

Super admins can grant or remove admin and manager access by email. Managers only receive the product lookup index tools.

Admin access

Admins receive the full admin toolset.

Email	Action
No admin users configured.

Manager access

Managers can view and rebuild the product lookup index only.

Email	Action
No manager users configured.

Admin settings

Connection status

Microsoft sign-in