We are excited to share a major update regarding the Inventory System, featuring the completion of the advanced video game scanning pipeline and new security roadmap additions!
1. Advanced Video Game Scanning & PriceCharting API Waterfall
We have fully implemented and verified our premium retro game scanning pipeline:
- Intelligent Waterfall Querying: When standard UPC scans return video game categories, the system automatically redirects the query to the PriceCharting API, retrieving pristine, collector-curated game titles.
- Automatic Database Promotion: Game scans dynamically promote the SQLite
itemTypecolumn to'game', unlocking custom layouts and mapping Loose, CIB (Complete-in-Box), and New prices. - Store Barcode Warning & Photo Workflow: The React Native mobile scanner now flags store-internal barcodes, warning users and prompting them to capture a cover photo, which is zipped and processed by Google Lens on the server.
- Mocked Integration Testing: Created a robust, fully mocked integration test suite (
pricecharting.test.js) that verifies all waterfall cascades offline in under 50ms without hitting API rate limits.
2. Security Roadmap Expansion: Free TOTP 2FA
We expanded the security roadmap to incorporate Time-Based One-Time Passwords (compatible with Authy, Google Authenticator, and Microsoft Authenticator) with zero running cost:
- No External Gateways Required: Utilizes standard TOTP cryptographic validation rather than paid SMS text APIs.
- Administrative Override: Store Owners/Admins can reset 2FA configurations directly from the User settings panel to clear lost credentials for staff.
- Host CLI Emergency Reset: If the primary Admin is locked out, they can trigger an offline reset via a secure local CLI script on the host machine by verifying the installation’s master Product License Key.