How a one-person online shop can run inventory, kits and purchase orders without five tools
Replace the purchase-order spreadsheet and hand counts with one tool that scans barcodes, builds kits and shows what to reorder.
SuperCat
Your message is ready to send
I run a one-person online shop on BigCommerce and want one simple inventory tool that replaces my Google Sheet and my hand counts. I keep ShipStation for labels and QuickBooks for the books.
Build one tool: products with SKU, barcode, cost, supplier and a count of what is on the shelf. Print barcode labels for products and shelf bins, and let me scan with my phone camera to receive stock, pick an order and do a cycle count. Every scan goes into a log of who changed what and when.
Kits: I box 10 packs into one sellable case, so let me define a kit as its parts (10 packs = 1 case). Building 20 cases takes 200 packs off the shelf and adds 20 cases, and the kit shows how many more I can build.
Purchase orders replace my sheet: supplier, items, quantities, cost, status (draft, ordered, paid, shipped, received), ETA and payment date, with a receive screen that updates stock by scanning and flags anything short or late.
Reorder: from my weekly sales and each supplier's lead time, show what to order, how much and when, with the days of stock left for every product.
Orders: import my store orders from a CSV export and show a pick list sorted by shelf location. Export purchase orders and receipts as CSV for QuickBooks. Phone-first, with a helper login later that can scan and count but not see costs.
Opens WhatsApp with this message and a code for 5 cans. Nothing to install, no account to create.
Prefer another app? the message.
What you get
- One phone-friendly tool with products, barcodes, shelf locations and a log of every stock change.
- Printable barcode labels and scan-to-receive, scan-to-pick and scan-to-count screens.
- Kits that move stock between parts and sellable cases automatically.
- A purchase-order tracker with status, ETA and payment date that flags anything short or late.
- A reorder view based on weekly sales and supplier lead times, plus CSV exports for the books.
What usually gets in the way
- The purchase-order sheet is typed by hand, so paid status, ETAs and quantities drift from what is really on the shelf.
- Stock is pulled and counted by hand with no barcodes, so every count is a chance for a mistake.
- Kits, such as ten packs boxed into one sellable case, are tracked in someone's head instead of in the numbers.
- What to order, how much and when lives in a separate forecasting tool that does not know what is already on order.
- Shipping labels, books, forecasting, spreadsheet and storefront are five places to keep in step.
The longer story
A shop that starts small often ends up with a tool for every step: one for shipping labels, one for the books, one for forecasting, a spreadsheet for purchase orders and the storefront itself. Each does its job, but nothing connects them, so the person in the middle becomes the integration. The spreadsheet is usually where it breaks first, because it is all manual typing and nobody notices a wrong number until the shelf disagrees with it.
Barcodes fix the part that is most error-prone, which is physical counting. Scanning a product when it arrives, when it is picked and when it is counted gives a record of every movement, and a kit definition keeps the parts and the sellable cases in step without arithmetic. Purchase orders belong in the same place as the stock they create, so that receiving a delivery updates both at once.
The shipping and accounting tools can stay. What changes is that the stock and purchase-order sheet becomes one small tool built around how this particular shop buys, boxes and sells.
Send it as it is, or change anything first
SuperCat asks a question or two, then builds it.
Send on WhatsAppOpens WhatsApp with this message and a code for 5 cans. Nothing to install, no account to create.
Prefer another app? the message.
More requests like this
Online shops· Inventory, Bookkeeping
Average-cost inventory, sales profit and expenses for a reseller
Log each purchase as a lot, work out cost of goods from the average cost, and keep expenses, receipts and mileage in one place.
Send this to SuperCat
I resell collectibles, supplies and accessories online as a one-person LLC and want one simple bookkeeping tool to replace my Excel tabs. I keep YNAB for bank transactions.
Build one tool: Inventory with each purchase lot (date, supplier, item, quantity, total cost) and a running average cost per item, so a lot of thousands of items is one row, not thousands.
Sales: record each sale with price, fees and shipping. The tool takes the cost of goods from the average cost, lowers the stock count and shows profit per sale and per month.
Expenses: import my YNAB export as CSV and let me split one transaction across categories (inventory, supplies, equipment, software, shipping) with a note and a photo of the receipt. Spending in the inventory category creates or tops up a purchase lot so I enter it once.
Mileage: log trips with date, purpose and miles, with the IRS rate applied and a yearly total.
Reports: monthly and yearly profit and loss, inventory value on hand, cost of goods sold, and a tax-time CSV export for my accountant. Just me, phone-friendly, with a short checklist of what an accountant will ask for.
Opens WhatsApp with this request and a code for 5 cans to get started.
Online shops· Bookkeeping, Reporting
Reconcile store payouts with Stripe and the bank
Break each payout into sales, refunds, fees and net, match it to the bank deposit and flag anything that does not add up.
Send this to SuperCat
We sell online with Shopify and take payments through Stripe, and I want one simple tool that reconciles payouts so the books match the bank.
Build one tool: import the Shopify orders export and the Stripe payouts and balance transactions as CSV files. For each Stripe payout, list the orders it covers and break it into gross sales, refunds, Stripe fees, chargebacks and net, then match the net to the bank deposit from a bank CSV.
Flag anything that does not add up: a payout with no deposit, an order with no payment, a refund in a different month, a fee that differs from the expected rate.
Show a monthly summary with gross sales, refunds, fees, sales tax collected and net deposits, plus a list of items still unmatched that I can mark resolved with a note.
Export the summary and the matched payouts as CSV for the bookkeeper. Phone-friendly, and let me invite my bookkeeper with a read-only login.
Opens WhatsApp with this request and a code for 5 cans to get started.