How to track reseller inventory, fees, and item-level profit
Build one continuous reseller record from purchase cost and storage location through marketplace status, sale price, fees, and item-level profit based on recorded costs.
A revenue total is not profit, and a listing title is not an inventory system. To understand the business, every physical item needs a record that survives from purchase through sale.
The smallest useful record answers four questions: what did this cost, where is it, where is it listed, and what remained after it sold?
Create the record at intake
Attach cost and source when memory is fresh. For a lot purchase, choose and document a consistent allocation method rather than silently treating every item as free.
- Purchase date and source.
- Item cost or documented lot-cost allocation.
- Batch or haul name.
- Temporary or permanent storage location.
- A unique SKU when similar items could be confused.
Keep marketplace status separate from physical status
An item can be photographed, drafted, listed on one marketplace, copied to another, stored, sold, returned, or donated. One generic “active” label cannot describe all of those states.
At minimum, record the listing destinations and whether the physical item is available. This reduces accidental duplicate sales and makes stale inventory visible.
Know which costs your tracker includes
A complete business analysis may account for marketplace fees, promoted listing fees, payment processing, seller-paid shipping, packing materials, cost of goods, and overhead. The exact number depends on which costs you consistently record.
Shelvio calculates item-level profit as sold price minus item cost, recorded fees, and seller-paid shipping. Missing values are treated as zero. Packing materials, mileage, labor, taxes, and general overhead are not included in that built-in calculation.
Use completed-transaction numbers and call the result item-level profit based on recorded costs. Analyze costs outside the built-in formula separately.
Use built-in reports, then export for custom analysis
Shelvio reports summarize performance over time and by source, batch, and marketplace. They also show listing-to-sale timing and inventory aging so you can spot slow-moving stock and compare the selling channels and sourcing groups you recorded.
For analysis that Shelvio does not group in the app, such as category or storage-location comparisons, export the item records to CSV and work with them in a spreadsheet or reporting tool.
- Revenue, recorded costs, fees, and item-level profit over time.
- Performance by source, batch, and marketplace.
- Time from listing to sale and current inventory aging.
- Data-completeness indicators for missing sale inputs.
- CSV export for custom category, storage, and overhead analysis.
Export before tax time becomes a reconstruction project
Maintain records throughout the year and export a copy on a regular schedule. A CSV is useful for backup and analysis, but tax treatment varies by jurisdiction and business structure. Use a qualified tax professional for advice specific to your situation.
Questions about this workflow
What is the basic reseller profit formula?
Shelvio calculates item-level profit as sold price minus item cost, recorded fees, and seller-paid shipping, with missing values treated as zero. It does not include packing materials, mileage, labor, taxes, or general overhead. Tax treatment can differ, so consult a qualified professional.
How should I track items bought in one lot?
Choose a reasonable, consistent allocation method and document it—for example, relative expected value or equal allocation when the items are genuinely similar. Ask a tax professional which method fits your records.
Can Shelvio export reseller records?
Yes. Shelvio keeps cost, source, storage, marketplace status, sale, fees, seller-paid shipping, and item-level profit with the item and supports CSV export for custom analysis elsewhere.
