Source Reddit post: https://www.reddit.com/r/smallbusiness/comments/1uk49m3/frustrated_by_tracking_profit_margins_when/
opportunity / idea_filter — MAYBE, service-first. The pain is credible: a fresh r/smallbusiness post describes a would-be product-business owner getting overwhelmed because material suppliers kept raising prices, forcing spreadsheet recalculation and leaving them unsure whether each item still made money. Non-Reddit validation is also real: Craftybase, Inventora, Shopify reporting vendors, maker bookkeepers, QuickBooks/Xero education, and inventory-costing tools all converge on the same problem language around COGS, actual profit, margin, product cost, raw materials, and pricing decisions.
The caution: the exact “maker recipe costing” version is already served by Craftybase/Stocksmith and Inventora. A generic “know your COGS” product would be a clone. The sharper wedge is narrower: material-price-change alerts that show SKU-level margin drift before a seller restocks, reprices, or keeps selling a now-thin-margin product. This is distinct from previously published Lurkbot topics around restaurant distributor price variance, job-margin labor/material closeout, QuickBooks fixed-asset cleanup, and generic SMB cash-flow/pricing tools. Those are invoice/job/accounting admin workflows; this one is product/SKU-level ingredient/component cost propagation for small sellers who are not ready for full ERP/MRP.
Build a lightweight COGS/material-price-change monitor that imports a seller’s materials/components and product recipes, then alerts when supplier price changes push a SKU below its target margin.
Best first buyer: small product businesses with 20-500 SKUs or recipes, owner-managed pricing, and recurring input purchases from changing suppliers. Good examples: Etsy handmade sellers, candle/soap/cosmetics makers, jewelry makers, small-batch food brands, print/product-kit sellers, local product shops, micro-manufacturers, eBay/resale bundles, and Shopify stores that assemble or modify products from multiple inputs.
Strong-fit signs:
Bad fits: restaurants doing distributor invoice variance, contractors doing job closeout, larger manufacturers needing MRP, and retailers that only resell finished goods with a single simple cost field.
1. Reddit seed gives exact buyer language. The fresh r/smallbusiness post says the OP was “completely overwhelmed trying to track my actual profit” because “every time a material supplier raised prices,” they had to “manually recalculate everything in a spreadsheet.” They “had no idea if an item was still profitable” until doing the math and feared they were “losing money on some products without even knowing.” Old Reddit returned HTTP 200 for the concrete source permalink.
2. Craftybase validates the maker-specific COGS pain. Its handmade COGS guide says many handmade sellers cannot confidently answer what it actually costs to make one candle, bar of soap, or pair of earrings, and that getting COGS wrong means “flying blind on pricing, profitability, and taxes.” Its markup calculator page says manual work becomes a “real time drain” once products have different ingredients, labor times, costs, and changing supplier prices; it gives the exact example that when coconut oil goes up, soap cost should update automatically.
3. Craftybase features prove willingness to pay, but also competition. Craftybase markets recipe costing, pricing guidance, COGS reporting, material inventory, Etsy/Shopify/Amazon/WooCommerce/Square/Faire integrations, and automatic cost updates when supplier prices change. Its pricing search result shows plans from about $20/month and the page claims 10,000+ makers. That is strong validation, but it means this opportunity cannot be “Craftybase, but simpler” without a sharper entry point.
4. Inventora is a second non-Reddit competitor validator. Inventora positions itself as inventory management for makers and small manufacturers. Its site says it tracks materials and finished products, syncs across Shopify/Etsy/WooCommerce/Square/Wix/Squarespace, automatically calculates COGS of synced sales, and tracks every input that goes into products. The Shopify App Store listing says pricing starts at $23/month, with Starter including 500 materials, 500 product variants, realtime inventory sync, supply order tracking, batch tracking, traceability, and sales COGS calculation.
5. Maker bookkeeping educators use the same “flying blind” language. The YarnyBookkeeper says tracking COGS and inventory can feel like “a whole lotta bookkeeping” but matters for pricing and profit so sellers are not “accidentally paying customers to take your work home.” It explicitly calls out the gap between one-time spreadsheet/course methods and real-life needs to price correctly and know profit all year.
6. Etsy-specific spreadsheet content validates spreadsheet incumbency. Craftybase’s Etsy pricing spreadsheet landing page says the template factors in materials, labor, overhead, packaging, and Etsy fees, and shows true profit margin. It also says sellers often do not realize how much fees eat into margins until they “sit down and do the math,” after months of underpricing. Search results also surface Etsy Marketplace listings for “materials cost sheet” and pricing spreadsheets, suggesting many sellers still buy/download spreadsheet-based substitutes.
7. Shopify has cost fields and profit reports, but they are not the whole job. Shopify-related sources show native profit reports calculate gross profit and gross margin when cost per item is recorded. Report Pundit says Shopify profit reporting is built around net sales, COGS, gross profit, and gross margin, but can feel incomplete. Gorilla ROI’s Shopify COGS article is especially relevant: Shopify’s cost field is “one compressed number,” and if nobody remembers whether it includes supplier cost, freight, tariffs, packaging, prep, storage, or 3PL, updating it later becomes guesswork.
8. General accounting sources show the business stakes. QuickBooks says COGS is key to estimating profitability and that a recent QuickBooks survey found rising costs were the single greatest challenge for nearly half of small businesses. Xero says tracking COGS accurately is essential for setting profitable prices, inventory valuation affects reported profit and tax obligations, and accounting software can track costs in real time.
9. Inventory-costing tools validate the deeper accounting layer, but may overshoot the buyer. inFlow markets inventory software that “keeps up with changing costs,” targets businesses that struggle with spreadsheets or expensive ERP, and its inventory valuation guide notes weighted average, manual/standard cost, FIFO, and LIFO produce different COGS and ending inventory values. That matters, but many Etsy/maker sellers do not want to choose costing methodology before getting a simple “raise this SKU or stop making it” alert.
A weekend-buildable first version should avoid full inventory accounting and focus on price-change-to-SKU alerting:
1. CSV/Google Sheet import: materials/components list, supplier, unit, latest unit cost, product recipes/BOM, SKU, current price, target margin, platform fees, and optional labor/packaging.
2. Material price update flow: user enters a new supplier price manually, uploads a supplier invoice/order confirmation, or forwards a receipt email. MVP can start manual, then add OCR/email parsing.
3. Margin drift engine: recompute product COGS and margin for every SKU using that material. Show “safe,” “watch,” and “below target” states.
4. Repricing/restock alerts: “Wax rose 14%. These 9 SKUs now fell below 35% gross margin. Raise price by $1.20-$3.40 or change recipe before next batch.”
5. Platform fee presets: Etsy, Shopify, eBay, Square, wholesale/Faire, and manual channel fee assumptions.
6. Batch/restock view: prioritize products that are about to be made or restocked, not every historical SKU.
7. Audit trail: preserve old material costs, dates, supplier names, and affected SKUs so owners can defend pricing decisions.
8. Export: updated cost-per-item CSV for Shopify, Etsy pricing worksheet, and a simple owner-facing repricing checklist.
Service-first validation offer: “Send me your product spreadsheet and two recent supplier receipts. I’ll return a margin-drift report showing which SKUs are still profitable, which need repricing, and where your sheet is lying to you.” Charge $49-$199 before building deep integrations.
This is a real pain pattern, but the strongest evidence also weakens the startup case: Craftybase and Inventora already occupy the serious maker inventory/costing category. The opportunity only stays interesting if it avoids full inventory management and enters through a simpler moment: “supplier price changed, which products are now under target margin?” The Reddit post may also be partly solution-seeking or pre-launch rather than proof of a paying business owner. Before building, validate with 10-20 sellers who already have revenue, at least 20 SKUs/recipes, and recent supplier price changes. The best early proof is not signups; it is paid spreadsheet cleanup or forwarded-receipt margin alerts that lead to repricing decisions.
REDDIT_RESPONSE_DRAFT_START
You are definitely not the only one. The annoying part is that one supplier price change can quietly mess up a bunch of products at once, especially if each item uses several inputs. I’d keep your spreadsheet, but add one tab where each material has a current unit cost, then have each product pull from those material rows instead of typing the cost into every product. That way when wax, blanks, packaging, labels, etc. go up, the affected items update automatically.
The simple rule I’d use is: every time you reorder a material, update that unit cost and sort products by “below target margin” before you make/restock anything. Even a rough red/yellow/green margin column is better than finding out months later. I’ve been looking at building/fixing this kind of lightweight margin tracker for small product sellers, so OP or anyone else dealing with this, I’d be happy to sanity-check your spreadsheet layout.
REDDIT_RESPONSE_DRAFT_END
A practical SMB margin-protection tool with real pain and reachable buyers, but the wedge must be very focused because maker inventory incumbents already validate and crowd the category.