A set of operating principles and tactical fixes for managing Doodla Farms' Amazon FBA inventory, developed through ongoing weekly reviews. The core goal is to keep every SKU in a healthy 6–12 month supply window while preventing algorithm failures on slow-moving products.
The agreed target is 6–12 months of supply on hand at FBA at all times.
For any SKU carrying more than 12 months of inventory, a 25% coupon has been applied to drive velocity. Current campaign details:
Monitor sell-through weekly. Once a product drops into the 6–12 month window, evaluate whether to let the coupon expire or end it early.
When a slow-moving SKU temporarily goes out of stock or sells fewer than a handful of units, the inventory planning tool records a near-zero velocity. The algorithm then recommends shipping zero additional units — which can cause a product to stay perpetually out of stock even after restocking.
Manually hard-code a minimum velocity of 6 units/month for any SKU whose recorded velocity falls below 10 units/month.
=IF(actual_velocity < 10, 6, actual_velocity).Setting a velocity floor will cause the tool to recommend gradual inventory builds for slow movers. Watch these SKUs closely to ensure stock doesn't creep back above the 12-month ceiling.
| SKU | Status | Notes |
|---|---|---|
| White Old World Popcorn | Out of stock | ~$2k shipment en route to FBA |
| Pinto Beans 25lb | Low stock (6 units en route) | New order sent to Jason; pickup scheduled |
These two SKUs were identified as the most urgent gaps during the [1].
Inventory levels directly affect PPC performance. When stock dips, organic rank suffers and PPC sales decline even if bids are unchanged. The Yellow Cornmeal SKU is a clear example: PPC sales have been flat since December due to an earlier inventory gap. Once stock is stable, bids should be edged up to recapture lost momentum.
See also: [2] for the parallel advertising review conducted in the same session.