Before Stockvisor can track your stock, your Google Sheet needs your products in it. This takes about ten minutes. Here's exactly what to type where.
At the bottom of the Sheet, make one tab per supplier you order from, and name each tab after that supplier. Everything that supplier delivers goes on their tab.
On each supplier's tab, fill in these columns: Category, Item name, Unit, and Monthly count. Don't touch the columns after that — Stockvisor adds those on its own as weeks go by.
Unit is whatever you count the item in — bottle, can, keg, pack. Monthly count is how many you have on hand right now, from an actual physical count.
Items of the same kind belong under one category name. Type the category once, then select that cell plus the blank cells below it down to the last item in the group, and merge them (right-click → Merge cells). Here's what a finished tab looks like:
| Category | Item name | Unit | Monthly count |
|---|---|---|---|
| RED WINE | Malbec Reserva | bottle | 14 |
| Cabernet Sauvignon | bottle | 9 | |
| WHITE WINE | Sauvignon Blanc | bottle | 11 |
| BEER | Lager 330ml | can | 48 |
| Pilsner 500ml | bottle | 20 |
Go through each tab the same way. It's fine if some tabs are small — a supplier with three items still gets their own tab.
Share the Sheet with the account Stockvisor showed you, as an Editor, then paste the Sheet's link back into the app. From then on, deliveries and pickups update these numbers automatically — you won't need to edit the Sheet by hand again unless you're doing a fresh physical count.