Price a whole inventory, not one listing at a time.
Individual fee calculators are useful when you are deciding whether to buy one item or how to price a single listing. They are slow when you have a shelf of 80 items and need to know which ones are worth listing, which need a price change and which should be bundled or donated. That is a spreadsheet problem, not a calculator problem.
A CSV workflow lets you apply the same arithmetic to every row in seconds. It also exposes patterns that are hard to see one item at a time: the low-priced items whose fixed fees eat the margin, the categories where postage is too high, the listings that are profitable only at a price the market will not pay. This guide shows a simple six-column file, a worked table and the mistakes that make bulk numbers lie.
The six columns that matter
A useful bulk file does not need every field in your inventory system. It needs the inputs that change the profit calculation: the item name, the price you plan to list at, the item cost, the shipping you charge the buyer, the shipping and packaging you pay, and the marketplace fee percentage. Those six columns are enough to produce an estimated fee and profit for each row.
| Column | What it means | Example |
|---|---|---|
| name | Item or SKU label | Vintage jacket |
| price | Listing price | 48 |
| item_cost | What you paid, including allocated sourcing cost | 12 |
| shipping_charged | Shipping the buyer pays | 0 |
| shipping_paid | Label + packaging you pay | 5.25 |
| platform_fee_percent | Variable marketplace fee | 13.6 |
Keep the file in the currency you actually use. Do not mix dollars and euros in one column unless you also add an exchange-rate column and convert every row. If you sell on several platforms, add a platform column and use the correct fee percentage per row rather than a single global rate. A mixed file with one average fee is worse than no file, because it looks precise while hiding the variation.
A worked table
The table below applies a 13.6% variable fee to each row. The estimated fee is (price + shipping_charged) × 13.6%. Profit is price + shipping_charged − fee − item cost − shipping paid. These numbers exclude the fixed order fee, promotion and tax, which is exactly the simplification a bulk file often makes. The next section shows why that simplification matters.
| Item | Price | Ship charged | Fee | Profit | Margin |
|---|---|---|---|---|---|
| Vintage jacket | $48.00 | $0.00 | $6.53 | $24.22 | 50.5% |
| Denim shorts | $22.00 | $0.00 | $2.99 | $8.91 | 40.5% |
| Running shoes | $65.00 | $0.00 | $8.84 | $27.76 | 42.7% |
| Ceramic vase | $35.00 | $0.00 | $4.76 | $11.04 | 31.5% |
| Book lot | $18.00 | $0.00 | $2.45 | $7.65 | 42.5% |
| Phone case | $8.00 | $0.00 | $1.09 | $1.66 | 20.8% |
The phone case looks marginally profitable at 20.8%, but that is where the fixed fee bites. eBay’s model adds a $0.40 order fee above $10 and $0.30 at or below $10. On an $8 sale, the real modeled fee is $1.09 + $0.30 = $1.39, not $1.09. Profit falls to $1.36, and the margin falls to 17.0%. The fixed fee consumed $0.30, which is 3.75% of the sale price. On a $48 jacket, $0.30 is 0.6% and easy to ignore.
| Item | Price | Fee at 13.6% only | Fee with order fee | Profit difference |
|---|---|---|---|---|
| Vintage jacket | $48.00 | $6.53 | $6.93 | −$0.40 |
| Phone case | $8.00 | $1.09 | $1.39 | −$0.30 |
| Book lot | $18.00 | $2.45 | $2.85 | −$0.40 |
| Running shoes | $65.00 | $8.84 | $9.24 | −$0.40 |
Add the fixed fee to the file
If you want a more accurate bulk model, add a fixed_fee column and a fee_threshold column. For eBay, fixed_fee is $0.30 when price plus shipping is at or below $10, and $0.40 above it. For Etsy, the fixed component is roughly $0.45 ($0.25 processing plus $0.20 listing), and the variable rate is 9.5% for the US. For Poshmark, the model is not percentage-plus-fixed; it is $2.95 below $15 and 20% at or above, so a single percentage column cannot represent it correctly.
The practical compromise is to use the bulk file for ranking and screening, then run the final price through a platform-specific calculator. The file answers “which items deserve attention?” The calculator answers “what exactly will this sale net?” That two-step process is faster than calculating every row precisely and more accurate than trusting a single average rate for every platform.
Set a floor for every row
A bulk file becomes a pricing tool when you add a target profit and compute a minimum price. For a percentage-plus-fixed model with no buyer-paid shipping, the floor is (item cost + shipping paid + fixed fee + target profit) ÷ (1 − variable rate). For a $12 item, $5.25 shipping, $0.40 fixed fee, 13.6% variable rate and $8 target, the floor is ($12 + $5.25 + $0.40 + $8) ÷ 0.864 = $29.69. Any listing below that floor needs a higher price, a lower cost, a lower shipping cost or a different platform.
For Poshmark, use the piecewise rule. If the computed price is below $15, the fee is $2.95; if it is at or above $15, the fee is 20%. Compute both and check which one is valid. A formula that assumes 20% on a $12 item will overstate the fee and may push you above the threshold unnecessarily. A formula that assumes the flat fee on a $20 item will understate the fee and overstate profit.
Add a “status” column with three values: list, fix, liquidate. “List” means the item clears the floor at a marketable price. “Fix” means the item could clear the floor with better photos, a bundle, a lower shipping cost or a price test. “Liquidate” means the item does not clear the floor and should be bundled, donated or sold as a lot. This turns a spreadsheet into a decision queue.
Segment by margin and velocity
Profit per item is only half the picture. A $40-profit item that sits for six months ties up cash and storage; a $8-profit item that sells in a week may be the better use of capital. Add two columns if you have the data: expected days to sell and monthly units. Then compute profit per month of inventory holding. A simple proxy is profit × monthly units, or profit ÷ expected days to sell. The exact formula matters less than comparing items on the same basis.
| Item | Profit/unit | Days to sell | Profit per 30 days |
|---|---|---|---|
| Designer bag | $80 | 90 | $26.67 |
| Vintage tee | $12 | 7 | $51.43 |
| Running shoes | $28 | 30 | $28.00 |
| Ceramic vase | $11 | 21 | $15.71 |
The designer bag has the highest profit per unit and the lowest profit per month of holding. That does not make it a bad item; it may be worth the wait if you have capital and storage. But the comparison is more honest than sorting by unit profit alone. Bulk pricing should optimize the portfolio, not just the individual row.
Common CSV mistakes
- Mixing currencies without a conversion column, which makes every total meaningless.
- Using one average fee percentage for platforms with different fee bases and fixed fees.
- Forgetting that shipping charged to the buyer is part of the fee base on eBay, Etsy and Mercari.
- Treating the marketplace fee as the only cost and omitting packaging, returns and promotion.
- Including sales tax collected by the marketplace as revenue.
- Using a stale postage rate from last year’s carrier card.
- Letting a spreadsheet formula divide by zero when the price or cost is blank.
- Uploading a file with customer names or addresses to a tool that does not need them.
The privacy point is worth emphasis. A pricing file needs item names, costs and prices, not buyer data. Remove names, addresses, order numbers and anything else that identifies a customer before you paste the file into a browser tool or share it with a collaborator. The BidRush bulk calculator processes rows in your browser; it does not upload them to a server, but the same discipline applies to any spreadsheet you email or store in the cloud.
A repeatable monthly workflow
Once a month, export or assemble your active listings and recent sales. Add the six core columns plus a fixed-fee column and a target-profit column. Sort by profit per 30 days, flag the bottom quartile, and decide whether each item needs a price change, a bundle, a platform change or liquidation. Then update the listings. The whole exercise should take less time than pricing ten items one at a time, and it produces a consistent floor across the catalog.
Do not try to automate the judgment. The spreadsheet can tell you that an item is below its floor; it cannot tell you whether the market will bear a higher price, whether the photos are weak, or whether the item is worth keeping for a seasonal buyer. Use the file to focus your attention, then apply the judgment. That is the right division of labor between a calculator and a reseller.
Frequently asked questions
What columns should a bulk profit CSV have?
At minimum: item name, price, item cost, shipping charged, shipping paid and platform fee percentage. Add a fixed fee, fee threshold and target profit column for a more accurate floor. Add platform and currency columns if you sell across markets.
Why is my bulk estimate higher than the calculator?
The most common reason is a missing fixed fee, such as eBay’s $0.30/$0.40 order fee or Etsy’s $0.25 processing and $0.20 listing fees. Other reasons include a different shipping base, a promotion rate, or a fee on buyer-paid shipping that the spreadsheet omitted.
Can I use the bulk calculator for Poshmark?
Not with a single percentage column. Poshmark charges $2.95 below $15 and 20% at or above, so the fee is piecewise. Use the Poshmark calculator for the final price, or add a formula that checks both regimes.
Is my CSV uploaded anywhere?
The BidRush bulk calculator parses and calculates the rows in your browser. It does not send the file to a server. Still, remove customer names, addresses and order numbers before using any online tool or sharing a file.
Official sources
- eBay — Selling fees (official) ↗
- Etsy — Fees & Payments policy (official) ↗
- Poshmark — Seller fees (official support) ↗
Fee schedules change. The rates in this guide are the ones recorded in the BidRush dataset on the date shown, with the linked official page as the primary source. Confirm the amount in your seller account before pricing.
BidRush is independent and not affiliated with any marketplace. This guide is general information, not financial, legal or tax advice.