All templates

Online shop: orders & inventory

Every order from every channel on one board, stock on hand worked out from what came in and what went out, and the customers and suppliers behind them.

Start from this template

Who it is for

  • A small online shop selling on Shopee, TikTok Shop, Facebook or its own website.
  • A store owner who counts stock in a notebook or a spreadsheet.
  • Anyone who has to answer "how many do we have left?" more than once a day.

What is inside

Orders
Each order with its customer, products, channel, status, total, shipping fee, payment method and carrier, timed to the minute.
Products
Your catalogue with SKU, price, cost, margin and reorder level. Stock on hand is the sum of its movements, so it is never typed by hand.
Stock movements
Every purchase, sale, return and write-off as a signed quantity: plus for stock in, minus for stock out.
Customers
Who buys, where they first bought, how many orders they have placed and how much they have spent.
Suppliers
Who you buy from, their contact and how long they take to deliver.

How it opens

  • Orders open as a board by status: New, Packed, Shipping, Delivered, Returned, Cancelled.
  • Each card shows the customer, channel, total and when the order came in.
  • A Shop dashboard: revenue, orders, average order value, orders by channel and by day.

How to start

  1. Press Start from this template. A base with sample products, orders and stock is made in your account.
  2. Replace the sample products with yours, with price, cost and reorder level.
  3. Record your opening stock as one Purchase movement per product.
  4. Add each order as it comes in and move its card as you pack and ship it; log the sale in Stock movements.
  5. Sort Products by stock on hand to see what to reorder, and read the dashboard for the week's sales.

Questions

How is stock on hand calculated?

It adds up the product's stock movements: purchases and returns are positive, sales and write-offs negative. Change a movement and the stock follows.

Can I track orders from several channels?

Yes. Each order has a channel (Shopee, TikTok Shop, Facebook, Website or Store), and the dashboard splits revenue by channel.

Does it connect to Shopee or TikTok Shop automatically?

Not yet: orders are added by hand or imported from the CSV those platforms export. Bank transfers can arrive automatically through mintgrid's SePay sync.

Is it free?

Yes. Making a base from a template is free, and you can change every table and field in it.

More templates