Stockvisor
Back to the app

Filling in your Sheet

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.


Give each supplier their own tab

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.

KESPROHARTWALLKOFFPM-JUOMA+

Four columns, left to right

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.

Group items under a category

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:

CategoryItem nameUnitMonthly count
RED WINEMalbec Reservabottle14
Cabernet Sauvignonbottle9
WHITE WINESauvignon Blancbottle11
BEERLager 330mlcan48
Pilsner 500mlbottle20

Repeat for every supplier tab

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.

Done? Connect it

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.