With 98% of Amazon sales flowing through the Buy Box (Knight-Georgetown Institute, January 2026), winning it matters. But winning it at a price that destroys your margin is worse than not winning it at all. This guide shows you how to build a SKU-level price floor for every ASIN in your catalog so your repricer competes aggressively without triggering the race to the bottom that drains profit even as order volume climbs.
Who this is for: FBA sellers managing multi-SKU catalogs who use automated repricing and want margin protection baked into their rules.
Prerequisites: Access to your COGS data, Amazon Seller Central fee schedule, and either Google Sheets or Excel.
Difficulty: Intermediate. Time: 1–2 hours to set up the template; 10–15 minutes per SKU batch update.
Why a SKU-level price floor protects your margins
When a repricer matches a competitor's price drop without any guardrail, it can execute dozens of cuts per hour. Gross sales hold steady or even improve. Net margin quietly collapses. That's the race to the bottom mechanism: volume goes up, profit per unit goes down, and by the time you notice, you've trained the market to expect a lower price point.
A price floor is the minimum selling price at which you still hit your target net margin after every cost is accounted for. Not just COGS plus shipping. Every cost: referral fees, FBA fulfillment, storage, returns, disposal, and your ad spend allocation.
A floor built on COGS alone is not a safe floor. Before you trust any minimum price, run this quick check:
- Does it include monthly FBA storage (both Jan–Sep and Oct–Dec rates)?
- Does it include an estimated return rate and associated disposal/removal fees?
- Does it include a per-unit ad and promo cost allocation?
- Does it include inbound placement service fees?
If any answer is no, the floor is understated.
Every cost component you need to include
Build your floor from these line items:
- Product cost (COGS + inbound shipping): Your per-unit cost of goods plus the allocated cost of shipping inventory to Amazon fulfillment centers, split across expected units in that shipment.
- Inbound placement service fee: Amazon charges a per-unit inbound placement service fee depending on your shipment split configuration. Check the "FBA inbound placement service fee" page in Seller Central for current rates.
- Referral fee: Per Amazon Seller Central, referral fees are "calculated as a percentage of the total sales price... or the applicable per-item minimum (typically $0.30), whichever is greater." Rates vary by category, so pull the current fee schedule for each ASIN's category.
- FBA fulfillment fee: Pick, pack, and ship fees determined by size tier and unit weight. These change periodically, so use Seller Central's fee schedule as your source of truth.
- Storage allocation: Amazon's standard-size monthly storage fees are commonly cited at $0.78 per cubic foot (January through September) and $2.40 per cubic foot (October through December). Multiply by the unit's cubic footage and your expected months in the fulfillment center. If you carry slow-moving inventory, add aged inventory surcharges.
- Returns and disposal: Estimate your return rate by category (electronics and apparel run much higher than consumables). Per returned unit, include: the lost COGS value (if Amazon deems it unsellable), any disposal/removal order fees (billed per unit by size tier per Amazon's "FBA disposal order fees" page), and any repackaging cost.
- Ad and promo cost per unit: Divide your last-30-day Sponsored Products spend for that ASIN by units sold in the same period. This gives you a blended per-unit ad cost. Add coupon face value if you run them regularly.
- Risk buffer (recommended): Add 3–5% of your candidate price as a buffer for storage overruns, ad efficiency swings, and return rate variance. This prevents your floor from being exactly at breakeven.
Common omissions that produce dangerously low floors: ignoring seasonal storage spikes, applying a catalog-wide average return rate instead of a category-specific one, and forgetting that the referral fee applies to the full selling price including any shipping you charge.
Step-by-step: calculating the floor for a single SKU
Step 1: Gather inputs in a spreadsheet
Set up columns for: ASIN, product category, size tier, unit weight (lbs), unit dimensions, COGS, inbound shipping per unit, inbound placement fee per unit, estimated months in FC, return rate (%), disposal approach (removal vs. disposal), and last-30-day ad spend per unit.
Step 2: Compute fully loaded landed cost
Landed Cost = COGS + Inbound Shipping Per Unit + Inbound Placement Fee Per Unit
Step 3: Compute Amazon fee components at a candidate price
Pull the referral fee percentage for the category. Calculate:
Referral Fee = MAX(Candidate Price × Referral Fee %, $0.30)
FBA Fee = [from Seller Central size tier table]
Storage Allocation = (Unit Cubic Footage × Monthly Storage Rate) × Estimated Months in FC
Step 4: Estimate returns cost per unit sold
Return Cost Allocation = Return Rate % × (COGS + Disposal/Removal Fee Per Unit)
Step 5: Calculate ad cost per unit
Ad Cost Per Unit = (Last 30-Day Ad Spend for ASIN) ÷ (Units Sold Last 30 Days)
If the SKU is new, use a conservative ACoS estimate (e.g., 25–30%) applied to your target price.
Step 6: Set your target profit constraint
Decide: do you want a target dollar profit per unit (e.g., $3.00) or a target net margin percentage (e.g., 15% of selling price)? This drives the floor formula differently, so pick one and be consistent across your catalog.
Step 7: Solve for the minimum selling price
For a dollar profit target:
Floor Price = (Landed Cost + FBA Fee + Storage Allocation + Return Cost + Ad Cost + Target Profit $)
÷ (1 - Referral Fee %)
The division by (1 - Referral Fee %) corrects for the fact that the referral fee is a percentage of the price you're solving for.
For a net margin % target:
Floor Price = (Landed Cost + FBA Fee + Storage + Return Cost + Ad Cost)
÷ (1 - Referral Fee % - Target Margin %)
Both formulas are best implemented with Excel/Sheets iteration (set the candidate price cell as the circular reference input and let Solver or GOALSEEK resolve it) because FBA fee tier boundaries and referral fee minimums create non-linear jumps.
Step 8: Enter the floor into your repricer and Seller Central
Set the computed floor as the minimum price in your repricing rule for that ASIN. Also set a backup minimum in Seller Central's "Manage Pricing" to catch any edge case where the repricer rule doesn't apply.
Step 9: Run a competitor undercut scenario test
Drop your competitor's simulated price below your computed floor and confirm your repricer holds the floor rather than following. Verify the unit economics: at the floor price, net profit should still meet your target.
Step 10: Set a review cadence
Update floors when: Amazon revises fees (typically announced several weeks in advance), your storage velocity changes with seasonality, your ad spend efficiency shifts by more than 20% over 30 days, or your COGS changes due to supplier pricing.
Three worked examples
Low-price consumable ($8.99 target price)
| Input | Value |
|---|---|
| COGS | $2.50 |
| Inbound shipping | $0.35 |
| Inbound placement fee | $0.15 |
| Referral fee (15%) | $1.35 |
| FBA fulfillment fee | $3.22 |
| Storage allocation | $0.12 |
| Return cost (5% rate) | $0.14 |
| Ad cost per unit | $0.60 |
| Total loaded cost | $8.43 |
| Target profit ($0.75) | $0.75 |
| Floor price (solved) | ~$9.30 |
The floor is $9.30, not $8.99. If you'd entered $8.99 as your minimum, you'd be selling at a loss after ad spend and storage. Common failure mode: sellers ignore the referral fee minimum floor ($0.30) on very low-priced consumables, which can make some SKUs economically non-viable to FBA at any competitive price.
Mid-price durable ($42.00 target price)
| Input | Value |
|---|---|
| COGS | $14.00 |
| Inbound shipping | $1.20 |
| Inbound placement fee | $0.50 |
| Referral fee (8%) | $3.36 |
| FBA fulfillment fee | $5.40 |
| Storage allocation (3 months) | $0.55 |
| Return cost (8% rate) | $1.24 |
| Ad cost per unit | $4.80 |
| Total loaded cost | $31.05 |
| Target margin (20%) | $8.40 |
| Floor price (solved) | ~$38.20 |
Ad spend dominates here. A seller running at 25% ACoS who ignores it builds a floor $4–$5 too low. Common failure mode: using a 30-day average ACoS during a low-traffic period, then running a Prime Day campaign at 3x spend without updating the floor.
High-price oversize item ($189.00 target price)
| Input | Value |
|---|---|
| COGS | $55.00 |
| Inbound shipping | $8.00 |
| Inbound placement fee | $2.50 |
| Referral fee (8%) | $15.12 |
| FBA fulfillment fee (large oversize) | $22.00 |
| Storage allocation (2 months, peak season) | $4.80 |
| Return cost (6% rate + $5.25 disposal) | $3.62 |
| Ad cost per unit | $9.50 |
| Total loaded cost | $120.54 |
| Target margin (15%) | $28.35 |
| Floor price (solved) | ~$175.00 |
A $14 repricing error on a bulky item (e.g., wrong size tier applied) translates directly to $14 of vanished margin per unit. Common failure mode: measuring dimensions in centimeters, entering them as inches in the fee calculator, and landing in the wrong size tier.
Spreadsheet structure for bulk SKU floor calculations
Build your Google Sheets calculator with four tabs:
Tab 1, Inputs: One row per ASIN. Columns: ASIN, category, size tier, weight, dimensions, COGS, inbound shipping, placement fee, months in FC, storage season (Jan–Sep vs Oct–Dec), return rate %, disposal method, last-30-day ad spend, units sold last 30 days, target margin type ($ or %), target margin value.
Tab 2, Fee Components: Pulls from Inputs. Calculates referral fee (using =MAX(Inputs!price * rate, 0.30)), FBA fee (lookup table by size tier), storage allocation (cubic footage derived from dimensions × rate × months), return cost, and ad cost per unit.
Tab 3, Price Floor: Uses GOALSEEK or a circular reference with manual iteration enabled. Formula: =(LandedCost + FBAFee + StorageAlloc + ReturnCost + AdCost) / (1 - ReferralFeeRate - TargetMarginRate). Output is the floor price per ASIN.
Tab 4, Scenario Simulation: Enter a competitor's price. Confirm the repricer floor holds. Show the resulting net margin at floor vs. if price were dropped to match.
For bulk catalog input, export your Seller Central inventory report as CSV, paste ASINs and cost data into Tab 1, and let the fee lookup tables populate automatically.
Troubleshooting floor jumps:
- Unexpected jump of $2–$5: usually a size tier boundary. Recheck weight and dimensions.
- Jump after updating shipment: inbound placement fee changed with split configuration.
- Jump in Q4: storage rate shifted to the Oct–Dec rate. Expected behavior; don't override it.
Enforcing the floor in your automatic repricer
Once you have floor prices per ASIN, the configuration workflow is:
- Upload floors to your repricer as minimum prices per SKU. Most tools support bulk CSV upload. Map the floor price column to the "minimum price" field, not to a rule-level default.
- Assign each ASIN to the correct rule group. A common misconfiguration: a SKU gets assigned to a rule group with no minimum price set, so the tool ignores the SKU-level floor and drops to an unprotected default. Audit rule group assignments when you bulk upload.
- Run a 7–14 day simulation or backtest before going live. Confirm that no ASIN's simulated price dipped below its floor during recent competitor activity.
- Go live with monitoring alerts. Set an alert to trigger if any ASIN's live price drops within 3% of its floor. That's your signal to investigate whether a competitor is pricing below your economics or whether your floor needs recalculating.
- Sync floors when costs change. Floors not updated after a fee change are worse than no floors: they give you false confidence. Build a reminder into your workflow each time Amazon announces a fee revision.
Set a backup minimum in Seller Central's "Automate Pricing" or "Manage Pricing" interface as a secondary guardrail. If the repricer ever misfires, Seller Central's own minimum prevents the listing from going below a hard stop.
Informed Repricer's Price Reset and Smart Max features are designed exactly for this use case: they prevent a race to the bottom by holding or resetting prices rather than chasing every competitor drop. With repricing that reacts in under one second, the tool can compete for the Buy Box continuously while the margin floors you've calculated here prevent any downward spiral. Sellers using this approach have reported a 63% average increase in Buy Box ownership within the first two weeks, without sacrificing the per-unit profitability that makes that Buy Box worth winning.
The goal isn't the lowest price. It's the right price: competitive enough to win the Buy Box, high enough to hit your margin target every time the order ships.