Guide: Tenzo Data Importer (Google Sheets: Inventory)
How do core concepts map to Tenzo?
Key: ✅ Supported 🚸 Work in Progress ❌ Not supported
 |
|
|---|---|
| Location | ✅ Location |
| Vendor | ✅ Vendor |
| Category | ✅ Item Category |
| Item | ✅ Item |
| Purchases | ✅ Amount |
| Actual Usage | ✅ Amount (on separate tab) |
| Theoretical Usage | ✅ Amount (on separate tab) |
| Wastage | ✅ Amount (on separate tab) |
| Menu Item Costs | ✅ Cost (on separate tab) |
Data Ingestion
| Real-time optionally available? | ❌ |
| Default polling frequency | Every 24 hours |
| Data retrieved on each poll | All data in the sheet |
| Historical data | All data in the sheet |
How do I connect this data to Tenzo?
GoogleSheets can be connected directly inside of the Tenzo app. This is the template you should be using.
If you have an Enterprise account, you can talk to your Customer Success Manager and they will connect this for you.
How do I populate the template?
You can delete the columns that are not relevant for what you are uploading (e.g. revenue center, order type, etc.) and just leave the ones you will be filling.
Please note that for the template to work, dates need to be in the same formatting you find at the top of the template, YYYY-MM-DD:
How do I compare data to data in Tenzo?
Access the GoogleSheet and compare the daily total by line.
You will then be able to see the same number by selecting one day within Tenzo’s “Inventory by Location” view and select on the drop-down on the right “Purchases” or “Actual Usage”.
Purchases
Actual Usage
Exceptions
None