Bar Stock Agent + Dashboard

Automating bar stock dashboard generation from SSRS reports involves extracting live inventory data using Python requests-ntlm for authentication, classifying stock against par thresholds, and deploying a self-contained HTML dashboard to Netlify.

Yes, you can pull live inventory data from PilotLive SSRS reports using Python with requests-ntlm to handle the NTLM authentication protocol and extract real-time bar stock levels for processing.

Classifying inventory levels against par thresholds involves matching extracted SKU data against predefined product par levels to categorize stock status as critical, low, healthy, or variance.

Yes, the approach supports generating daily stock briefs and sending them to bar managers via Telegram, providing an automated notification channel for inventory shortages and status updates.

The best way to deploy a self-contained HTML inventory dashboard to Netlify is to generate the static HTML file locally with embedded order assistant and admin features, then push it to your Netlify hosting environment.

Generating UD Excel order schedules for bar inventory restocking uses Node.js with ExcelJS to build structured order schedules and tracks supplier confirmations through deployed Netlify Functions.