Dashboard
Inventory
| Item | Category | GL Code | Vendor | Store | Storage | Total | Par | Suggested | Status | Cost | Cost/Serving | Servings/Unit |
|---|
🔒 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.
Sync Square team members into BSC Staff. Matches on email — creates new records or updates existing ones.
Map Square location IDs to your BSC location names so synced data goes to the right store.
Pull merchandise, food, and grocery items from their Square catalog categories into BSC. Updates prices, names, categories, and propagates archive state both ways.
Pull current menu item stock counts from Square into per-location Menu Counts lists.
| First Name | Last Name | Plate | Location | Status |
|---|
Shared tags used across vendors, contacts, inventory, and maintenance
The seven roles are fixed, highest first — what each can do is built in. Click a role to change which pages it can see.
Locations appear in filters and inventory tracking
signin@email = slack@email — only needed when someone's Slack uses a different email than their Microsoft login.https://ops.bluesparrowcoffee.com). Leave blank and Slack messages arrive without an “Open in BSC Ops” link.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.
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.
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 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.
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.
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.