A live sale needs two separate records: what a buyer asked for and what you actually accepted. Keeping those states separate prevents a repeated comment, cancellation, or sold-out item from silently changing your stock count.
This guide provides a small order ledger you can reproduce on paper or in a spreadsheet. The names, prices, and events below are fictional worked examples created by PC Wise AI, not measured results from a real seller.
Disclosure: PC Wise AI also sells the optional template linked at the end. No purchase is needed to use the method below.
Give every product and buyer a stable identifier
Before going live, make an item list with an item ID, description, unit price, and starting quantity. Use a buyer ID that you can map to the correct account. Display names alone are unreliable because different people can use the same name.
| Item ID | Item | Unit price | Starting stock |
|---|---|---|---|
| A01 | Blue pouch | USD 12.00 | 3 |
| B02 | Canvas tote | USD 18.00 | 2 |
Decide and explain how you will order claims before the sale starts. Keep a reference to the platform comment or message so that you can resolve a dispute without guessing which comment came first.
Record one row per claim
A useful ledger has these columns: claim ID, time or sequence, buyer ID, item ID, quantity, price at acceptance, status, and source reference. A unique claim ID lets you correct a row without confusing it with another purchase by the same buyer.
| Claim | Buyer | Item | Qty | Status | Note |
|---|---|---|---|---|---|
| C001 | BUY01 | A01 | 2 | Accepted | First accepted claim |
| C002 | BUY02 | A01 | 1 | Accepted | Last available pouch |
| C003 | BUY01 | B02 | 1 | Accepted | Different item |
| C004 | BUY03 | A01 | 1 | Waitlisted | No stock available |
| C005 | BUY01 | A01 | 2 | Duplicate | Repeat of C001, not another order |
Do not automatically label two similar comments as duplicates. Check the buyer and source: a buyer may intentionally add another item. If the intention is unclear, keep the new claim pending until you confirm it.
Count accepted reservations, not all comments
In this example, an accepted claim reserves stock even before payment. Available stock is starting stock minus the quantity in active accepted claims. Pending, waitlisted, duplicate, and cancelled rows do not reserve stock.
- A01: 3 starting − 2 for C001 − 1 for C002 = 0 available.
- B02: 2 starting − 1 for C003 = 1 available.
If BUY02 cancels C002, mark it cancelled and keep the row. A01 then has one unit available. Offer that unit to the next eligible buyer under your announced rules; do not silently convert C004 into a confirmed purchase. When BUY03 accepts, change C004 to accepted and record the confirmation reference.
Keep payment separate from claim status
An accepted order is not proof of payment. Track unpaid, partially paid, and paid in a separate payment field or payment ledger. Otherwise, changing a claim to paid may accidentally remove it from a formula that counts only accepted claims and make the stock look available again.
Preserve the price agreed when the claim was accepted. If you change the product price later, historical orders should not inherit the new price without an explicit correction.
Check three totals before packing
- Stock: active reserved quantities must not exceed the starting quantity, adjusted for any recorded stock changes.
- Claims: each accepted row needs a buyer, item, quantity, and source reference. Review pending and waitlisted rows separately.
- Money: reconcile confirmed receipts against each buyer’s final amount. A payment screenshot is a clue to investigate, not a substitute for checking the receipt.
After the cancellation and waitlist acceptance above, BUY01 has USD 42.00 of merchandise and BUY03 has USD 12.00. BUY02 has no active merchandise order. The merchandise total is USD 54.00, with shipping, discounts, and any applicable taxes still to be handled separately.
Move from accepted claims to an invoice
The next step is grouping accepted rows by buyer, applying each order-level charge once, and subtracting confirmed payments. See the separate worked invoice and partial-payment example for that calculation.
You can build this ledger yourself. If you prefer a prepared product, the Live Selling Order & Inventory Tracker is our paid option. Check its current product description and whether its workflow matches your claim and cancellation rules before purchasing.
Updated October 1, 2026: added the claim ledger, stock calculation, cancellation example, and payment checks so this page can be used independently of a paid template.
답글 남기기