Blue Sparrow Coffee
Operations Platform · Sign in with your BSC Microsoft account
Connected
Inventory items
tracked across locations
Low stock
at or below par
Pending orders
awaiting delivery
Today's checklist
tasks complete
Maintenance
overdue or due soon
Today's Checklist
Low Stock
Loading…
🚚 Deliveries
Loading…
Recent Orders
Loading…
Maintenance Alerts
Loading…
Currently Clocked In
Loading…
Working offline — count drafts auto-save locally and sync when you're back online.
Counter view — par, vendor, and cost are read-only. Counts you submit go to a Lead for review before posting. Flag an issue
Item Category Vendor Store Storage Total Par Suggested Status Cost Cost/Serving Servings/Unit
12 manual count 12 auto-updated (received / transfer) — hover a number for its source
Working offline — task completions will sync when you're back online.
House-made ingredients used to calculate cost of goods. Each prep item's cost per unit is calculated from its ingredients and batch yield.
Active competitors (click to toggle)
All items × all competitors (click any cell to edit)
Price history (selected item)
🤝 Would hire again judge each hire, then see what the two groups have in common — and what they don't
📊 Analytics visuals reflect current filters · click chips above to slice
Not connected — add your Square access token below
◼ Square API

🔒 The Square access token is stored securely on the server (Azure SQUARE_ACCESS_TOKEN), never in the app or SharePoint. There is nothing to enter here.

To rotate it: Square Developer Dashboard → Your App → Production → regenerate the token, then update SQUARE_ACCESS_TOKEN in the Azure Function App configuration and click Test Connection.

Diagnoses which Square endpoints are reachable with the current token
🔄 Auto-Sync from Square
👥 Team Members

Sync Square team members into BSC Staff. Matches on email — creates new records or updates existing ones.

📍 Location Mapping

Map Square location IDs to your BSC location names so synced data goes to the right store.

☕ Catalog / Menu Items

Pull your Square catalog — items, categories, and pricing — into the BSC Menu page.

🗂️ Inventory Categories

Pull merchandise, food, and grocery items from their Square catalog categories into BSC. Updates prices, names, categories, and propagates archive state both ways.

📦 Inventory Counts

Pull current menu item stock counts from Square into per-location Menu Counts lists.

First Name Last Name Email Location Status
🏷️ Tags

Shared tags used across vendors, contacts, inventory, and maintenance

👥 Roles & Permissions

Click a role to edit its name and module access

📍 Locations

Locations appear in filters and inventory tracking

🔔 Slack Notifications
Global Slack Pause
The Slack webhook URL is configured on the Function app (SLACK_WEBHOOK_URL environment variable). Set or rotate it in the Azure Portal → Function App → Configuration. Posts route through /api/slack-post.
Slack email aliases
One per line, signin@email = slack@email — only needed when someone's Slack uses a different email than their Microsoft login.
Notification Rules
📧 Auto-Send Orders by Email
✉️ Order Email Template
🥪 Sandwich Order Email Template (Marczyks)
🔔 Notification Recipients

Who gets DM'd for each location's notifications (orders, low stock, checklists, maintenance, no-clock-in). Auto derives the list from Staff — anyone with a manager/owner role covering the location. Manual lets you pick exactly who. Person-specific events (project owners, task assignees) always go to those people directly.

☕ Coffee Bags

Waste assumptions applied to monthly reconciliation. Each bag sold deducts an additional % from on-hand inventory to account for misprints (labels) or damage/expiry (retail bags).

%

Default: 10%. Higher % = more labels deducted per bag sold.

%

Default: 2%. Higher % = more bags deducted per bag sold.

🔑 Microsoft Staff Access

Sync Access — silently grants SharePoint site access to all active staff. No emails sent.
Send Invitations — emails the Microsoft sign-in invitation to external staff (Gmail, iCloud, etc.) so they can log in. Run after adding someone new or if they need the link resent.

🔐 Master Lock Vault Invites

Master Lock has no API for creating or deleting Vault Enterprise users, so inviting people stays a manual paste — this just formats it. Pick who to invite, then paste each batch into enterprise.masterlockvault.com → Users → Add Users. Ten per batch, so each paste is small enough to check before you send it.
Removing someone is manual too: the offboarding run posts a reminder to #bsc_hr on their last day, and the Staff page Revoke button now says so as well.

🔧 SharePoint Provisioning

Creates or updates the SharePoint lists and columns the app stores its data in — its database schema. This runs by itself on the first load after every app update, so you normally never need this button. Use it only to force a repair: for example, if a list or column was accidentally deleted directly in SharePoint. Safe to run any number of times — it only adds what's missing and never deletes existing data.

🗑 Clear Local Data

Wipes all cached app data from this browser (session cache, column preferences, notification settings, Square sync timestamps). The page will reload and re-fetch everything from SharePoint.

🏷️ Lane Labels
Rename lane titles on Phase 2 pages. Leave a field blank to use the default (shown as placeholder).
Loading…