The fields every Etsy inventory tracker needs
Etsy gives sellers order totals, listing status, and marketplace activity. Resellers still need item-level records that explain whether a vintage find, handmade supply lot, or curated sourcing trip produced real profit after COGS, fees, shipping, and promotion.
| Field | Why it matters | Example |
|---|---|---|
| SKU and storage location | Connects each Etsy listing to the physical item so sold inventory can be found, packed, and removed from active stock. | ETSY-0087 · Shelf C2 |
| Category, condition, and source | Shows which vintage categories, estate sales, thrift stores, or supplier lots create repeatable margin. | Vintage brass decor · estate sale |
| Purchase cost or material cost | Creates real COGS before a sale happens instead of reconstructing cost basis from old receipts later. | $12 item cost + $1.20 packaging |
| List date and renewal count | Shows stale listings and renewal drag before small fees quietly eat into the expected margin. | Listed Aug 12 · renewed twice |
| Sale price, discounts, shipping charged | Separates top-line order value from the money the seller actually keeps. | $54 sale · 10% coupon · buyer-paid shipping |
| Fees, ads, profit, margin, ROI | Turns each order into sourcing feedback for categories, styles, price points, and acquisition channels. | $24.80 profit · 46% margin · 183% ROI |
A workflow from sourcing to Etsy sale
1. Log the item before listing
Record title, category, SKU, source, storage location, condition notes, purchase cost, prep cost, and photos before the item joins your active shop.
2. Set a profitable floor
Estimate sale price after Etsy transaction fees, payment processing, shipping, packaging, offsite ads risk, and renewal drag.
3. Track renewals and promotions
Note listing renewals, Etsy Ads, coupons, and free-shipping adjustments so you know which listings need repricing or retirement.
4. Close the loop after sale
Record final sale price, fees, shipping, sold date, profit, ROI, days held, and whether the source/category should go on your buy-again list.
The point is not to make Etsy selling feel like bookkeeping homework. It is to turn every order into a better sourcing decision.
Separate Etsy fees from real profit
An Etsy sale can include listing fees, renewal fees, transaction fees, payment processing, optional ads, offsite ads, discounts, shipping labels, and packaging. If those costs sit outside your inventory tracker, revenue will look healthier than the business actually is.
- Track COGS at item creation: do not wait until tax time to remember what the vintage lot cost.
- Separate marketplace fees from shipping costs: this makes it easier to spot listings where shipping policy is hurting margin.
- Log ad and renewal drag: a slow-moving item may still sell, but repeated promotion changes the buy-again decision.
- Use days held: a 50% margin item that takes 240 days to sell may be worse than a lower-margin item that turns every month.
Reports that tell Etsy sellers what to restock
Once every Etsy listing has a clean item record, the useful reports become simple:
- Profit by category: which vintage, handmade, craft, or supply categories create the best net profit?
- ROI by source: which estate sales, thrift stores, wholesale lots, or local buys deserve more budget?
- Days held by price point: which items tie up cash too long before selling?
- Fee and ad drag: which listings look good until renewals, ads, discounts, and shipping are included?
- Active inventory cost basis: how much money is currently sitting unsold in your Etsy shop?
Track your Etsy inventory like a real resale business.
stokd tracks inventory, cost basis, sources, listing age, sale price, fees, expenses, profit, ROI, and stale stock across Etsy plus every other resale channel.
Start tracking free →Etsy inventory tracker FAQ
What should an Etsy inventory tracker include?
Track SKU, title, category, purchase cost or material cost, source, storage location, list date, renewal fees, transaction fees, payment processing, ads, shipping, sold date, profit, ROI, and status.
How do Etsy sellers track COGS?
Assign cost of goods when the item is sourced or made. For lots, bundles, supplies, or vintage hauls, split the total cost across individual SKUs before items sell so profit is not guessed later.
Why track Etsy listing renewals and ads?
Renewal fees and Etsy Ads can turn a good-looking order into a thin-margin sale. Tracking them by SKU shows which listings deserve more promotion and which ones should be repriced or retired.
Can stokd track Etsy inventory?
Yes. stokd is built for resellers tracking inventory, fees, expenses, profit, and sourcing ROI across Etsy, eBay, Poshmark, Mercari, Depop, Facebook Marketplace, Whatnot, and more.