Google Sheets inventory sync
Concept screen: keep a shared stocktake sheet and the platform's stock levels in step.
Prototype / demo — not connected
Connection
Nothing is sent to Google in this prototype
Auto-sync after stock movements
Push changes when a supplier invoice is received
Sheet preview
What the platform would write to the sheet
| A · SKU | B · On hand | C · Available | D · Backordered |
|---|---|---|---|
| AS5026-NAV-M | 84 | 60 | 0 |
| AS5026-NAV-L | 62 | 32 | 0 |
| AS5026-WHT-M | 18 | 6 | 0 |
| AS5026-FOR-L | 6 | -12 | 12 |
| AS5101-BLK-L | 41 | 29 | 0 |
| AS5101-BLK-S | 9 | -13 | 13 |
| HV2200-ORG-XL | 22 | 4 | 0 |
| HV2200-ORG-2XL | 0 | 0 | 12 |
| CUST-CAP-SCS | 0 | 0 | 0 |
| CUST-JKT-TUI | 0 | 0 | 0 |
SKUs in scope
10
Sync direction
Two-way
Counts in, levels out
Conflict rule
Sheet wins on stocktake
External integrations shown in this prototype — Google Sheets, bank feeds, supplier email capture, IRD filing and Xero — are demonstrations only. No external account is connected and no data leaves this browser session.