AI Matrx Logo

Wine shop

Kingsweir Grove Wine Shop · Wine shop · Bend, OR

Ulla Tamarind owns Kingsweir Grove Wine Shop in Bend, Oregon, and she uses this to count every bottle, see which wines have dropped below their reorder line and load a distributor's stock sheet without doubling a single wine.

RetailInventoryImports4 tables · 6 views · 2 forms · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 agent
Use this template

All wines

Wines
WineShelf tagStyleVintageSupplierCost a bottleShelf price
Alpine Frost ProseccoKG-1017Sparkling—Fenwick Sparkling Imports$13$24
Ashgrove ChardonnayKG-1002White2,022Cascadia Cellar Distributing$17$30
Ashgrove Pinot NoirKG-1001Red2,021Cascadia Cellar Distributing$19.50$34
Bodega Altamira AlbariñoKG-1012White2,023Low Tide Importers$16$29
Bodega Altamira Rioja ReservaKG-1011Red2,017Low Tide Importers$21$38
Bosco Alto BarberaKG-1007Red2,021Low Tide Importers$16$29
Bosco Alto GaviKG-1008White2,023Low Tide Importers$15$27
Caldera Ridge RieslingKG-1006White2,023Cascadia Cellar Distributing$14$26
Cantina Verrane NebbioloKG-1009Red2,018Low Tide Importers$38$66
Coldwater GewürztraminerKG-1028White2,022Redwood Ridge Growers Co-op$16$29
Delacroix-Lenoir Champagne BrutKG-1016Sparkling—Fenwick Sparkling Imports$46$79
Domaine Pellerin RoséKG-1013Rosé2,023Low Tide Importers$15$28

18 more rows

Tables

Wines

30 sample rows · 17 columns

Every bottle the shop sells, how many are on the shelf and when it must be reordered.

WineShelf tagStyleVintageSupplierCost a bottleShelf price
Alpine Frost ProseccoKG-1017Sparkling—Fenwick Sparkling Imports$13$24
Ashgrove ChardonnayKG-1002White2,022Cascadia Cellar Distributing$17$30
Ashgrove Pinot NoirKG-1001Red2,021Cascadia Cellar Distributing$19.50$34
Bodega Altamira AlbariñoKG-1012White2,023Low Tide Importers$16$29
Bodega Altamira Rioja ReservaKG-1011Red2,017Low Tide Importers$21$38
Bosco Alto BarberaKG-1007Red2,021Low Tide Importers$16$29
Bosco Alto GaviKG-1008White2,023Low Tide Importers$15$27
Caldera Ridge RieslingKG-1006White2,023Cascadia Cellar Distributing$14$26
Cantina Verrane NebbioloKG-1009Red2,018Low Tide Importers$38$66
Coldwater GewürztraminerKG-1028White2,022Redwood Ridge Growers Co-op$16$29
Delacroix-Lenoir Champagne BrutKG-1016Sparkling—Fenwick Sparkling Imports$46$79
Domaine Pellerin RoséKG-1013Rosé2,023Low Tide Importers$15$28

18 more rows

Orders

20 sample rows · 11 columns

Every case order placed with a supplier: what was ordered, what it costs and when it lands.

Order numberWineSupplierCasesBottlesOrder costOrder status
PO-3304Maison Roussel CrémantFenwick Sparkling Imports424$528Ordered
PO-3301Tamsin Hill SyrahCascadia Cellar Distributing224$528Ordered
PO-3303Bodega Altamira Rioja ReservaLow Tide Importers224$504Ordered
PO-3302Bosco Alto GaviLow Tide Importers336$540Ordered
PO-3305Fogbank Grenache RoséRedwood Ridge Growers Co-op224$336Ordered
PO-3308Ashgrove Pinot NoirCascadia Cellar Distributing224$468Received
PO-3315Redwood Ridge ZinfandelRedwood Ridge Growers Co-op224$480Received
PO-3311Bosco Alto BarberaLow Tide Importers224$384Received
PO-3309Ashgrove ChardonnayCascadia Cellar Distributing224$408Received
PO-3316Redwood Ridge Sauvignon BlancRedwood Ridge Growers Co-op336$432Received
PO-3310Silverbell Cabernet SauvignonCascadia Cellar Distributing112$372Received
PO-3317Tamsin Hill ViognierCascadia Cellar Distributing224$432Received

8 more rows

Suppliers

5 sample rows · 8 columns

The distributors and growers the shop buys from, with their minimum order and lead time.

SupplierSales repRep phoneRep emailLead time, daysMinimum orderWines
Cascadia Cellar DistributingFennimore Laszlo-Adeyemi(541) 555-0151fennimore.laszloadeyemi@cascadiacellardistributing.net4$600Ashgrove Pinot Noir, Ashgrove Chardonnay, Tamsin Hill Syrah, Tamsin Hill Viognier, Silverbell Cabernet Sauvignon, Caldera Ridge Riesling, Ironbark Petite Sirah
Fenwick Sparkling ImportsRosaline Whitcombe-Aziz(541) 555-0154rosaline.whitcombeaziz@fenwicksparklingimports.com12$1,200Mirabel Brut Sparkling, Maison Roussel Crémant, Delacroix-Lenoir Champagne Brut, Alpine Frost Prosecco, Lantern Row Moscato d'Asti
Low Tide ImportersOdalys Prendergast-Mbeki(541) 555-0152odalys.prendergastmbeki@lowtideimporters-wine.com9$900Bosco Alto Barbera, Bosco Alto Gavi, Cantina Verrane Nebbiolo, Quinta da Sorrel Vinho Verde, Bodega Altamira Rioja Reserva, Bodega Altamira Albariño, Domaine Pellerin Rosé, Salt Pan Tempranillo
Redwood Ridge Growers Co-opEmmerich Tallis-Ngoma(541) 555-0153emmerich.tallisngoma@redwoodridgegrowerscoop.org3$400Redwood Ridge Zinfandel, Redwood Ridge Sauvignon Blanc, Millrun Estate Merlot, Millrun Estate Late-Harvest Semillon, Fogbank Grenache Rosé, Coldwater Gewürztraminer
Stonecutter Natural Wine CollectiveLeopold Okafor-Thissen(541) 555-0155leopold.okaforthissen@stonecutternaturalwine.com6$500Wren Creek Skin-Contact Pinot Gris, Wren Creek Pét-Nat Rosé, Hollowtree Gamay, Hollowtree Chenin Blanc

Forms and booking

Add a wine

Form
Add a wineWhat Ulla fills in when a new wine goes on the shelf.
What number is on the shelf tag? *KG- and four digits.
Which wine is it, producer and name? *
What style is it? *RedWhiteRoséSparklingOrangeDessert
Which vintage is on the label?
Who sells it to the shop? *
What does a bottle cost you?
What will it sell for?
How many bottles came in?
At how many bottles should it be reordered?
Put it on the shelf

Place an order

Form
Place an orderWhat the buyer fills in when cases are ordered from a supplier.
What is the order number? *
Which wine is being reordered?
Which supplier is it going to?
How many cases? *
How many bottles is that? *
What does the order come to? *
Who is placing it?
Save the order

Dashboards

Stock at a glance

Wines
Wines by stock level
  • In stock20
  • Low6
  • Out of stock4
Bottles on hand by style
  • Red203
  • White255
  • Rosé11
  • Sparkling64
  • Orange11
  • Dessert8
Order value by supplier0

Also included

  • Wines to reorderDigest
  • New order placedNotificationTells the stock clerk an order is on its way so receiving is ready.

Related templates