App Logo

Sheet template · Small businesses

Inventory tracker

Stock levels and reorder alerts. Made from one message, so you can get your own in minutes.

Inventory tracker

Qty in Stock vs. Reorder Level

SKUItemCategorySupplierUnit Cost ($)
CF-001Ethiopia Guji green beans (per kg)Green CoffeeOrigin Trade Partners8.4
CF-002Colombia Huila green beans (per kg)Green CoffeeOrigin Trade Partners7.2
CF-003Brazil Santos green beans (per kg)Green CoffeeOrigin Trade Partners6.1
CF-004Sumatra Mandheling green beans (per kg)Green CoffeeOrigin Trade Partners7.85
PK-10112 oz kraft bag with valvePackagingPackwell Supply0.32
PK-1022 lb kraft bag with valvePackagingPackwell Supply0.58
PK-103Shipping box 10x8x4 inPackagingPackwell Supply0.74
PK-104Branded label roll (500 labels)PackagingPackwell Supply14.5

Stock levels and reorder alerts

The prompt

Create a Sheet inventory tracker for Marlow & Finch Coffee, a small specialty coffee roaster and café. Use columns for SKU, item, category, supplier, unit cost, quantity in stock, reorder level, stock value (formula) and a reorder flag (formula that shows REORDER when stock is at or below the reorder level). Add 15 example items like Ethiopia Guji green beans, Colombia Huila green beans, Brazil Santos green beans, Sumatra Mandheling green beans, oat milk, paper cups and compostable lids.

Make it yours

  • Change the details in the prompt to fit small businesses.
  • For example, change it so that it is for a neighborhood plant nursery called Fernhill Greens and the items are potting soil, ceramic pots, succulent starters and organic fertilizer, with a Location column added.
  • Ask for edits in plain words: tone, colors, length, layout or data.
  • Share the result by link or export it when you are done.

More sheet templates

Browse all

Platforms

Your agent, wherever you are.

  • Web appAny modern browserAvailable
  • Chrome extensionChat with any pageAvailable
  • Desktop appmacOS and WindowsSoon
  • TelegramYour agent on the goSoon