Order capture
Extract product, quantity, variant, delivery method, address, requested date, and payment hint from natural chat.
Shop Ops captures WhatsApp and Telegram orders, confirms the details, and writes clean order, item, payment, and delivery rows into the Google Sheet your shop already trusts.
The first version is built for small sellers who already sell through chat: home bakeries, resellers, florists, preorder shops, frozen food sellers, and neighborhood stores.
Extract product, quantity, variant, delivery method, address, requested date, and payment hint from natural chat.
Summarize the order and ask for confirmation before creating active order rows in the shop workbook.
Keep products, customers, orders, order items, payments, delivery, summaries, and data quality in Google Sheets.
Track unpaid, partial, paid, and refunded orders with safe references for transfer notes or payment proof.
Update New, Confirmed, Preparing, Ready, Delivered, or Cancelled from chat or from the Sheet.
Ask orders today, unpaid orders, delivery tomorrow, or pending orders and get concise replies from Sheets.
One private WhatsApp or Telegram message starts the flow.
Produk are matched against the catalog and missing fields are asked one at a time.
The assistant repeats the order, total, payment state, and delivery detail before writing.
The order appears in Orders and Order Items, ready for payment and fulfillment tracking.
The portal stays operational. The owner's daily workspace is still Google Sheets.
| Tab | Purpose | Why it matters |
|---|---|---|
| Produk | Catalog, aliases, price, variant, active flag. | Chat matching stays grounded in the owner's product list. |
| Customers | Customer profile, provider identity, address notes. | Repeat buyers can be recognized without a CRM. |
| Orders | One row per order with status and payment state. | The owner can scan today's work in one tab. |
| Order Items | One row per product inside an order. | Multi-item orders stay clean instead of becoming messy columns. |
| Payments & Delivery | Payment method, amount, proof reference, address, courier, status. | Follow-up work is visible without hunting through chats. |
| Daily Summary | Counts by order, payment, and fulfillment state. | Owner chat summaries read from the same source of truth. |
No. Boring Cash is Level 0 for personal or household expense capture. Shop Ops is Level 1 for shop orders, products, customers, payment, and fulfillment.
No. The Sheet is the shop operations workbook. Shop Ops structures chat messages and writes clean rows into it.
No. Customers keep using WhatsApp or Telegram private chat. The shop owner gets structure behind the scenes.
One customer order becomes one confirmed order in Sheets, the owner can update status, and owner summaries read the workbook correctly.
Bring a product catalog, one WhatsApp or Telegram channel, and a small set of real order examples. We map the first workflow before adding heavier shop features.