Connect Live Sales Data — Sandstar VMS & 365 Retail Markets (ADM)
Dashboard reads cost/price data live from your Google Sheet. Connect Sandstar & ADM to add real sell-through rates, machine-level performance, and per-location insights.
Make sure the Google Sheet is published to the web as CSV.
File → Share → Publish to web → CSV → Publish
Dashboard reads cost/price data live from your Google Sheet. Connect Sandstar & ADM to add real sell-through rates, machine-level performance, and per-location insights.
| Product | Units Sold | Sales Revenue | CPU | Sale Price | Margin % | Profit on Sales | Status |
|---|
Drag your HTML file onto Netlify's drop zone and get a public URL instantly — no account needed.
vending_dashboard.html onto the pageUpload to a GitHub repo and enable Pages for a permanent, version-controlled URL that updates when you update the file.
vending_dashboard.html → rename to index.htmlConnect a GitHub repo or drag-drop deploy. Supports custom domains if you want yourcompany.com/dashboard.
The dashboard fetches data directly from your Google Sheets in the visitor's browser. For this to work:
File → Share → Publish to web → Sheet1 → CSV → Publish
This sheet is already configured correctly.
Make sure your sales data sheet is also published:
File → Share → Publish to web → CSV → Publish
Publishing a Google Sheet makes it publicly readable by anyone with the link. Only publish sheets that don't contain sensitive personal or financial data you want to keep private. For password-protected access, consider hosting on a platform that supports basic auth, or contact a developer for a protected setup.
The dashboard automatically re-fetches data from Google Sheets:
Google Sheets publish updates propagate within 1–5 minutes of saving changes.
| # | Product | Vendor | Margin | CPU | Price | Revenue Potential | Score | Status |
|---|
| # | Product | Margin | CPU | Price |
|---|
| # | Product | Margin | CPU | Price |
|---|
| # | Product | Vendor | Margin | Waste Rate | Waste Cost | Revenue Pot. | Reason |
|---|
| Category | Suggested Products | Est. Margin | Rationale |
|---|---|---|---|
| Protein / Healthy Snacks | RX Bar, Kind Bar, Quest Bar | 65–75% | High demand, growing health trend |
| Functional Beverages | Liquid IV, Electrolit, LMNT | 60–70% | Premium price point, low cost |
| Better-for-You Chips | Siete, Hippeas, Beanfields | 65–72% | Higher ASP than standard chips |
| Nut Butter Snacks | Justin's PB Cups, Nuttzo bars | 58–65% | Complement existing Sahale nuts |
| Jerky / Meat Snacks | Epic Bars, Country Archer | 62–70% | High-protein, premium pricing |
| Cold Brew / RTD Coffee | Chameleon, Stumptown RTD | 55–62% | Better margin than La Colombe (40%) |
| Hydration / Sports | Nuun, Propel, Core Power | 63–70% | Better margin than Gatorade (45%) |
| Product | Action | Est. Saving |
|---|
| Product | Vendor | Units | CPU | Price | Margin | Revenue Pot. | Gross Profit | Waste | Status |
|---|