Online Store Operations Hub
Small online shops selling their own goods
For online shops: SKUs and stock, purchase orders, fulfillment, returns, sales by channel.
Use this templateOnline Store Operations Hub
Start here: how this workspace runs
Dashboard
Daily fulfillment routine
Weekly stock count and reorder
Returns and exchanges
Orders
Ship-by dates drive the day. Press Assign to me before you pack and Mark shipped when the label is on.
| Order | Status | Customer | Product | SKU | Handled by | Quantity |
|---|---|---|---|---|---|---|
| HH-4100 | Delivered | Leopold Thackeray | Stoneware serving bowl | Serving bowl - large | Dwayne Castellan | 1 |
| HH-4103 | Delivered | Tamsin Iyer | Linen napkin set of 4 | Napkin set - natural | Dwayne Castellan | 2 |
| HH-4106 | Delivered | Tobias Valdez | Gift box, medium | Gift box - medium | Annika Solheim | 60 |
| HH-4109 | Delivered | Ottoline Rutherford | Ceramic mug, speckled | Speckled mug - oat | Edmund Pryor | 1 |
| HH-4112 | Delivered | Silas Fontaine | Soy candle, fig and tea | Fig and tea - 8 oz | Dwayne Castellan | 2 |
| HH-4115 | Returned | Imelda Boateng | Linen throw blanket | Throw blanket - oatmeal | Dwayne Castellan | 1 |
| HH-4118 | Cancelled | Desmond Pemberton | Tea towel, plaid | Plaid tea towel - red | Nomvula Dlamini | 12 |
| HH-4121 | Packing | Fenella Mbeki | Soy candle, cedar and smoke | Cedar and smoke - 8 oz | Edmund Pryor | 2 |
SKUs and stock
The Stock column reads Reorder when what is on hand plus what is on order falls to the reorder point.
| SKU | SKU code | Product | Option | On hand | Reorder at | Reorder quantity |
|---|---|---|---|---|---|---|
| Speckled mug - oat | HH-101-OAT | Ceramic mug, speckled | Oat glaze | 26 | 15 | 48 |
| Speckled mug - slate | HH-101-SLT | Ceramic mug, speckled | Slate glaze | 11 | 15 | 48 |
| Serving bowl - large | HH-108-L | Stoneware serving bowl | Large, 10 in | 18 | 8 | 24 |
| Cedar and smoke - 8 oz | HH-115-8 | Soy candle, cedar and smoke | 8 oz tin | 41 | 25 | 72 |
| Cedar and smoke - 14 oz | HH-115-14 | Soy candle, cedar and smoke | 14 oz jar | 23 | 20 | 48 |
| Fig and tea - 8 oz | HH-122-8 | Soy candle, fig and tea | 8 oz tin | 9 | 25 | 72 |
| Fig and tea - 14 oz | HH-122-14 | Soy candle, fig and tea | 14 oz jar | 0 | 20 | 48 |
| Napkin set - natural | HH-129-NAT | Linen napkin set of 4 | Natural | 18 | 12 | 30 |
Purchase orders
| Purchase order | Supplier | Status | Ordered | Expected | Received on | Units |
|---|---|---|---|---|---|---|
| Tideline restock - slate mugs | Tideline Ceramics | Confirmed | Nov 2, 2026 | Nov 23, 2026 | — | 48 |
| Wick and Wax - fig and tea | Wick and Wax Studio | Sent | Nov 14, 2026 | Nov 24, 2026 | — | 120 |
| Tideline - holiday ornaments | Tideline Ceramics | Partly received | Oct 19, 2026 | Nov 16, 2026 | — | 60 |
| Loomhouse - charcoal throws | Loomhouse Textiles | Sent | Nov 9, 2026 | Dec 7, 2026 | — | 12 |
| Boxcar - gift boxes and tissue | Boxcar Packaging | Received | Oct 24, 2026 | Oct 31, 2026 | Nov 1, 2026 | 250 |
| Loomhouse - autumn napkins | Loomhouse Textiles | Received | Sep 19, 2026 | Oct 17, 2026 | Oct 19, 2026 | 60 |
| Wick and Wax - cedar restock | Wick and Wax Studio | Draft | Nov 18, 2026 | Nov 28, 2026 | — | 72 |
Returns
| Return | Order | Customer | Reason | Outcome | Status | Asked on |
|---|---|---|---|---|---|---|
| Throw blanket - snag in weave | HH-4115 | Imelda Boateng | Refunded | Nov 12, 2026 | ||
| Serving bowl - chipped rim | HH-4100 | Leopold Thackeray | Closed | Nov 3, 2026 | ||
| Napkins - wrong color | HH-4103 | Tamsin Iyer | Label sent | Nov 15, 2026 | ||
| Fig and tea candle - gift return | HH-4112 | Silas Fontaine | Requested | Nov 17, 2026 | ||
| Mug - changed mind | HH-4109 | Ottoline Rutherford | Received | Nov 13, 2026 |
Products
| Product | Style code | Category | Status | Price (USD) | Landed cost per unit (USD) | Supplier |
|---|---|---|---|---|---|---|
| Ceramic mug, speckled | HH-101 | $28 | $9.50 | Tideline Ceramics | ||
| Stoneware serving bowl | HH-108 | $46 | $16.75 | Tideline Ceramics | ||
| Soy candle, cedar and smoke | HH-115 | $24 | $7.20 | Wick and Wax Studio | ||
| Soy candle, fig and tea | HH-122 | $24 | $7.20 | Wick and Wax Studio | ||
| Linen napkin set of 4 | HH-129 | $36 | $12.40 | Loomhouse Textiles | ||
| Waffle bath towel | HH-136 | $32 | $11.10 | Loomhouse Textiles | ||
| Linen throw blanket | HH-143 | $88 | $31.50 | Loomhouse Textiles | ||
| Gift box, medium | HH-150 | $4 | $1.10 | Boxcar Packaging |
Customers
| Customer | Segment | Phone | First order | Ships to (state) | Emails OK | |
|---|---|---|---|---|---|---|
| Fenella Mbeki | fenella.mbeki@inbox-mail.net | (401) 555-0199 | Oct 29, 2026 | RI | Yes | |
| Leopold Thackeray | leopold.thackeray@inbox-mail.net | (401) 555-0136 | Sep 16, 2026 | MA | Yes | |
| Imelda Boateng | imelda.boateng@inbox-mail.net | (401) 555-0173 | Aug 4, 2026 | NY | No | |
| Anders Jessup | anders.jessup@inbox-mail.net | (401) 555-0110 | Jun 22, 2026 | CT | Yes | |
| Ottoline Rutherford | ottoline.rutherford@inbox-mail.net | (401) 555-0147 | May 10, 2026 | RI | No | |
| Humphrey Aldercott | humphrey.aldercott@inbox-mail.net | (401) 555-0184 | Mar 28, 2026 | VT | Yes | |
| Tamsin Iyer | tamsin.iyer@inbox-mail.net | (401) 555-0121 | Feb 13, 2026 | NJ | Yes | |
| Desmond Pemberton | desmond.pemberton@inbox-mail.net | (401) 555-0158 | Jan 1, 2026 | ME | Yes |
Suppliers
| Supplier | Contact | Phone | Lead time (days) | Terms | Minimum order (USD) | |
|---|---|---|---|---|---|---|
| Tideline Ceramics | Marisol Rosenthal | marisol@tidelineceramics.net | (401) 555-0149 | 21 | $400 | |
| Wick and Wax Studio | Teodor Whitlock | teodor@wickandwax.net | (401) 555-0186 | 10 | $250 | |
| Loomhouse Textiles | Kwame Carrow | kwame@loomhousetextiles.net | (401) 555-0123 | 28 | $600 | |
| Boxcar Packaging | Ingrid Halvorsen | orders@boxcarpackaging.net | (401) 555-0160 | 7 | $150 |
What lives where
An order's path
Who does what
Your rhythm
Making it yours
Replace the sample suppliers and products with your own, then add one SKU row for every option you stock. Delete the sample orders once real ones come in. The Landed cost should include freight and duty split across the units, or your margins will look better than they are.
| Order | Status | Customer | Product | SKU | Handled by | Quantity |
|---|---|---|---|---|---|---|
| HH-4100 | Delivered | Leopold Thackeray | Stoneware serving bowl | Serving bowl - large | Dwayne Castellan | 1 |
| HH-4103 | Delivered | Tamsin Iyer | Linen napkin set of 4 | Napkin set - natural | Dwayne Castellan | 2 |
| HH-4106 | Delivered | Tobias Valdez | Gift box, medium | Gift box - medium | Annika Solheim | 60 |
| Order | Status | Customer | Product | SKU | Handled by | Quantity |
|---|---|---|---|---|---|---|
| HH-4100 | Delivered | Leopold Thackeray | Stoneware serving bowl | Serving bowl - large | Dwayne Castellan | 1 |
| HH-4103 | Delivered | Tamsin Iyer | Linen napkin set of 4 | Napkin set - natural | Dwayne Castellan | 2 |
| HH-4106 | Delivered | Tobias Valdez | Gift box, medium | Gift box - medium | Annika Solheim | 60 |
| Product | Style code | Category | Status | Price (USD) | Landed cost per unit (USD) | Supplier |
|---|---|---|---|---|---|---|
| Ceramic mug, speckled | HH-101 | $28 | $9.50 | Tideline Ceramics | ||
| Stoneware serving bowl | HH-108 | $46 | $16.75 | Tideline Ceramics | ||
| Soy candle, cedar and smoke | HH-115 | $24 | $7.20 | Wick and Wax Studio |
| Return | Order | Customer | Reason | Outcome | Status | Asked on |
|---|---|---|---|---|---|---|
| Throw blanket - snag in weave | HH-4115 | Imelda Boateng | Refunded | Nov 12, 2026 | ||
| Serving bowl - chipped rim | HH-4100 | Leopold Thackeray | Closed | Nov 3, 2026 | ||
| Napkins - wrong color | HH-4103 | Tamsin Iyer | Label sent | Nov 15, 2026 |
Late to ship
| Order | Status | Customer | Product | SKU | Handled by | Quantity |
|---|---|---|---|---|---|---|
| HH-4100 | Delivered | Leopold Thackeray | Stoneware serving bowl | Serving bowl - large | Dwayne Castellan | 1 |
| HH-4103 | Delivered | Tamsin Iyer | Linen napkin set of 4 | Napkin set - natural | Dwayne Castellan | 2 |
| HH-4106 | Delivered | Tobias Valdez | Gift box, medium | Gift box - medium | Annika Solheim | 60 |
SKUs to reorder
| SKU | SKU code | Product | Option | On hand | Reorder at | Reorder quantity |
|---|---|---|---|---|---|---|
| Speckled mug - oat | HH-101-OAT | Ceramic mug, speckled | Oat glaze | 26 | 15 | 48 |
| Speckled mug - slate | HH-101-SLT | Ceramic mug, speckled | Slate glaze | 11 | 15 | 48 |
| Serving bowl - large | HH-108-L | Stoneware serving bowl | Large, 10 in | 18 | 8 | 24 |
Stock arriving in the next 7 days
| Purchase order | Supplier | Status | Ordered | Expected | Received on | Units |
|---|---|---|---|---|---|---|
| Tideline restock - slate mugs | Tideline Ceramics | Confirmed | Nov 2, 2026 | Nov 23, 2026 | — | 48 |
| Wick and Wax - fig and tea | Wick and Wax Studio | Sent | Nov 14, 2026 | Nov 24, 2026 | — | 120 |
| Tideline - holiday ornaments | Tideline Ceramics | Partly received | Oct 19, 2026 | Nov 16, 2026 | — | 60 |
Open returns
| Return | Order | Customer | Reason | Outcome | Status | Asked on |
|---|---|---|---|---|---|---|
| Throw blanket - snag in weave | HH-4115 | Imelda Boateng | Refunded | Nov 12, 2026 | ||
| Serving bowl - chipped rim | HH-4100 | Leopold Thackeray | Closed | Nov 3, 2026 | ||
| Napkins - wrong color | HH-4103 | Tamsin Iyer | Label sent | Nov 15, 2026 |
Before 10 am
Picking and packing
Labels and shipping
The 2 pm cut-off
The carrier collects at 3. Anything not packed by 2 pm moves to the next morning's list; the packer tells support so they can answer if a customer asks.
Wholesale orders
Wholesale orders ship by courier or are picked up. Count twice, pack by case, and put the invoice in the first box. Ask the buyer to count on arrival and report shortages within 48 hours.
End of day
Why count every week
Numbers in a system drift: a broken mug nobody logged, a candle given to a friend, a miscount when stock came in. Counting the fast sellers every week and everything else once a month keeps On hand honest, which keeps the Reorder flag honest.
The Monday count
Reading the Stock column
Setting reorder points
A reorder point is what you sell during the supplier's lead time, plus a cushion. Example: the fig and tea 8 oz tin sells about 12 a week. Wick and Wax takes 10 days. Twelve a week is about 17 in 10 days; add 8 for a busy week and the reorder point is 25. Raise points in October for the holiday rush and lower them again in January.
Writing a purchase order
Receiving
Check Late from supplier every Monday. A supplier who is late twice in a season needs a longer lead time in your numbers, or a second source.
The policy, in plain words
When a request comes in
When it arrives
Exchanges
Treat an exchange as a new order at no charge, linked in the return's notes. Ship the new item as soon as the return is in transit, not when it arrives. Customers notice.
What to look at each month
The Dashboard's Returns by reason chart. Many Arrived damaged returns mean the packing needs work. Not as pictured means the photos or description are misleading. Wrong item sent means picking needs a second check. One fix at the source saves a dozen returns.
What's inside
8 tables · 21 views · 1 form · 2 row actions · 1 agent6 pages
- Online Store Operations Hub
- Start here: how this workspace runs
- Dashboard
- Daily fulfillment routine
- Weekly stock count and reorder
- Returns and exchanges
7 tables
- Suppliers2 views · 4 sample rows
- Products2 views · 10 sample rows
- SKUs and stock2 views · 16 sample rows
- Customers2 views · 12 sample rows
- Orders7 views · 24 sample rows
- Purchase orders4 views · 7 sample rows
- Returns2 views · 5 sample rows
Questions
- What is included in the Online Store Operations Hub template?
- 6 pages (Online Store Operations Hub, Start here: how this workspace runs, Dashboard, Daily fulfillment routine, Weekly stock count and reorder and 1 more) and 7 tables (Suppliers, Products, SKUs and stock, Customers, Orders and 2 more), filled with 78 sample rows so every view opens with realistic data.
- Who is the Online Store Operations Hub template for?
- Small online shops selling their own goods.
- Is the Online Store Operations Hub template free?
- Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
- Can I change the template after I use it?
- Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.
Related workspaces
Boutique Clothing Store HQFor clothing boutiques: sizes and stock, seasonal buys, markdowns, holds, consignment.
Florist ShopDaily orders and deliveries, wedding and event proposals, and the stem cooler.
Independent Bookstore HQFor bookstores: titles and stock, special orders, publisher orders and returns, events.
Print on Demand Shop HQFor print-on-demand shops: designs, listings, print partners, production, reprints.
Subscription Box Business HQFor subscription boxes: monthly editions, subscribers, renewals, failed charges, pauses.
Wholesale Distributor HQFor distributors: case stock and best-by dates, POs, routes, invoices and collections.