> For the complete documentation index, see [llms.txt](https://docs.sellermagnet.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sellermagnet.com/inventory-and-operations/inventory-management.md).

# Inventory Planner

Forecast your inventory needs, track stock levels across warehouses, set replenishment targets, and prevent stockouts, all from a single view.

{% hint style="info" %}
**Difficulty:** 🟡 Intermediate · **Reading time:** \~15 min
{% endhint %}

{% embed url="<https://www.youtube.com/watch?v=_igE0jd0ic4>" %}

{% hint style="success" icon="rocket" %}
**Open this page in your dashboard:** [**Go to Inventory Planner →**](https://dashboard.sellermagnet.com/inventory)
{% endhint %}

## 📋 Overview

The **Inventory Planner** page helps you stay ahead of stockouts and overstocking. It combines real-time stock levels, sales velocity calculations, and demand forecasting to tell you exactly how much inventory to send, and when. Whether you sell via FBA or FBM, across one marketplace or ten, this tool keeps your supply chain healthy.

{% hint style="success" %}
**Why this matters:** Stockouts cost more than just lost sales. Amazon penalizes your organic ranking, your PPC spend is wasted, and competitors capture your Buy Box. A single week out of stock on a top seller can take 2-4 weeks of recovery to regain your previous ranking position.
{% endhint %}

{% hint style="info" icon="circle-info" %}
**Plan requirement:** The Inventory Planner is part of the analytics dashboard. If your current plan does not include it, the whole page appears blurred behind an **"Upgrade Required"** overlay with a **View Plans** link - upgrade to unlock it.
{% endhint %}

***

## 📊 Stock Health Summary

A single **summary card** sits above the table (the old six separate KPI cards are gone). It reflects the products in your **current view** - the active filters - and it splits into three zones:

**1. The "Units to Send · N days" hero (clickable).** The headline number is the total units to send across the view, sized to your replenish window (the "· N days" mirrors the **Replenish for** window). Underneath sits a one-line **verdict**:

* **"{n} products to replenish"** when something needs shipping, or
* **"Nothing to send - covered for the next {n} days"** when the whole view is covered.

Click the hero to filter the table to rows with **Units to Send greater than 0**.

**2. The Stock health zone (clickable).** A segmented **health bar** plus a row of **status chips** - one chip per status actually present in the view (Out of Stock, Critical, Low Stock, Overstocked, Dead stock, Slow mover, No Sales, New listing, Healthy). Click any **chip** or **bar segment** to filter the table to that status. A small count next to "Stock health" shows how many products the bar covers.

**3. The quiet Inbound / Reserved zone.** Two low-emphasis totals - **Inbound** (units en route to Amazon) and **Reserved** (units held by Amazon) - summed across the view. These are context only; they are not clickable filters.

> **Quick win:** If the verdict reads "{n} products to replenish", click the **Units to Send** hero to filter the table to exactly those rows, then sort by "Days left" ascending to prioritize the most urgent items.

{% hint style="success" %}
**Why this matters:** The summary turns the whole card into a one-click triage shortcut. See "12 products to replenish"? Click the hero and you are looking at precisely those SKUs; click a status chip and you jump straight to, say, everything that is Critical, no manual sorting or searching required. Only one summary filter is active at a time, and it stacks on top of the regular filters (Marketplace, Fulfillment, etc.).
{% endhint %}

***

## Inventory Table

![SellerMagnet Inventory Management](https://4139654583-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fih2knSvVpBcq5rIeXVjM%2Fuploads%2Fgit-blob-855d47b7d94e48943f8086836e6d6878b8d9f407%2Finventory-management.png?alt=media)

> **For your first week:** Focus on just 4 columns : **Stock**, **Ø/day** (daily sales average), **Days left**, and **Status**. These tell you what needs restocking now. The remaining columns become useful as you scale.

An **interactive table** with full sorting, search, and pagination. Each **column header carries a "?" tooltip** explaining exactly what it measures. Not every column is shown out of the box - the ones marked "default off" below are added from the **Columns** menu (see [Saved Default View](#saved-default-view)):

| Column                          | Description                                                                                                                                                                                       |
| ------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Product**                     | Product name, image, SKU (Stock Keeping Unit), ASIN (Amazon Standard Identification Number), FNSKU. Also carries the marketplace flag, listing-status badge, and the condition chip when relevant |
| **Status**                      | Color-coded badge (see below)                                                                                                                                                                     |
| **Stock**                       | Units currently sellable in Amazon warehouses                                                                                                                                                     |
| **Inbound**                     | Units in transit to Amazon (shipped but not yet received)                                                                                                                                         |
| **Reserved**                    | Units reserved by Amazon for pending orders, processing, or FC transfers                                                                                                                          |
| **Ø/day**                       | Average units sold per day (based on the lookback period)                                                                                                                                         |
| **Sold ({days}d)**              | Real units actually sold in the selected lookback window - the raw count behind Ø/day, so you can double-check the forecast against actual sales                                                  |
| **Days left**                   | Estimated days of cover until current stock runs out                                                                                                                                              |
| **OOS date**                    | Projected out-of-stock date                                                                                                                                                                       |
| **Level**                       | Segmented stock bar showing inventory composition (see below)                                                                                                                                     |
| **To send ({days}d)**           | Recommended replenishment quantity for the replenish window                                                                                                                                       |
| **Forecast** *(default off)*    | Projected units you will sell during the replenish window (velocity x target days)                                                                                                                |
| **Marketplace** *(default off)* | The Amazon marketplace this stock belongs to                                                                                                                                                      |
| **Condition** *(default off)*   | Listing condition (New, Used, Refurbished, or **Mixed** where a grouped row spans conditions)                                                                                                     |
| **Fulfillment** *(default off)* | FBA or FBM                                                                                                                                                                                        |

{% hint style="info" icon="circle-info" %}
**"Days left" and "OOS date" count stock differently.** **Days left** divides your **available** stock - current stock *plus* inbound already in the pipeline - by daily velocity, so it reflects everything on the way. **OOS date** is deliberately stricter: it projects from your **current on-hand stock only** and ignores inbound, answering "when do I run dry if nothing new arrives?" That is why the OOS date can fall sooner than Days left implies.
{% endhint %}

{% hint style="info" icon="circle-info" %}
**No more "Pending transfers" column.** Units moving between fulfillment centers are no longer a separate column - they are folded into the **Reserved** cell and into the Days-left / To-send math, so the table stays lean without losing them from the calculation.
{% endhint %}

### Status Badges

Nine color-coded statuses can appear in the **Status** column (and as chips in the summary card):

| Status           | Meaning                                                   |
| ---------------- | --------------------------------------------------------- |
| **Critical**     | Stock will run out within days (under \~7d cover)         |
| **Low Stock**    | Stock below target, reorder soon                          |
| **Healthy**      | Stock within target range                                 |
| **Overstocked**  | More stock than needed for the target period              |
| **No Sales**     | Product has no recent sales in the lookback window        |
| **Out of Stock** | Zero units available                                      |
| **Dead stock**   | Sitting in the warehouse with no sales for a long stretch |
| **Slow mover**   | Has stock but very low / sporadic recent sales            |
| **New listing**  | Too little sales history yet for a reliable forecast      |

### Stock Bar Visualization

Each product row includes a **segmented bar** (the **Level** column) showing:

* **Green:** In-stock (current available) units
* **Blue:** Inbound units
* **Purple:** Reserved units
* **Orange:** To send (replenishment needed)

### Listing-status and freshness cues

The product cell surfaces a few at-a-glance signals so you never have to leave the table:

* **Listing-status badge** - a yellow/red badge marks a listing that is **Inactive**, **Incomplete**, or **Expired** on Amazon. Such a listing can still hold stock, so it stays visible unless you filter it out (see [Listing-status filter](#listing-status-filter-all-vs-active-only)).
* **Marketplace flag** - the country flag for the marketplace the row belongs to.
* **Condition chip** - New, Used - Like New, Refurbished, and so on, or **Mixed** when a grouped row spans conditions.
* **"Add product cost →"** - a deep-link shown when a product has no cost (COGS) on file yet, so the money figures in the forecast can be filled in.
* **"Synced" chip** - a freshness stamp in the toolbar showing how long ago the planner's stock data was last updated from Amazon.

### Row Actions (⋮ menu)

Every row ends with a **⋮ (More actions)** menu that jumps you straight to the relevant place:

| Action                                | What it does                                       |
| ------------------------------------- | -------------------------------------------------- |
| **Stock Forecast**                    | Opens the per-product forecast modal (see below)   |
| **Open on Amazon**                    | Opens the public product page on Amazon            |
| **Edit listing (Seller Central)**     | Jumps to the listing in Amazon Seller Central      |
| **Manage inventory (Seller Central)** | Jumps to Manage Inventory in Amazon Seller Central |

### Bulk selection

Each row has a **checkbox**, and a **select-all** control in the header ticks **every product in the filtered set** (not just the current page). Once anything is checked, a floating **"{n} selected"** bar appears with:

* **Export CSV** - export just the selected rows (a shortlist for your supplier), and
* **Clear** - deselect everything.

> **Quick win:** Filter to "Need attention", tick the products you actually intend to reorder this week, then **Export CSV** to send your supplier a clean shortlist instead of the whole catalog.

***

## 👣 Step-by-Step Example: Calculating a Reorder

Here is a realistic scenario showing how SellerMagnet calculates reorder recommendations:

> **Scenario:** You sell a garlic press (ASIN: B09EXAMPLE1) on Amazon.de. Your supplier is based in Shenzhen, China.
>
> **SellerMagnet's calculation:**
>
> * Expected Sales during target period: 8 units/day x 42 days = **336 units**
> * Current Stock + Inbound: 120 + 0 = **120 units**
> * **Units to Send: 336 - 120 = 216 units**
> * Days Left at current rate: 120 / 8 = **15 days** (Status: **Critical**)
> * Expected OOS Date: **15 days from today**

| Parameter                         | Value                           |
| --------------------------------- | ------------------------------- |
| Current Stock                     | 120 units                       |
| Inbound                           | 0 units                         |
| Daily Sales Avg (30-day lookback) | 8 units/day                     |
| Supplier Lead Time                | 21 days (production)            |
| Shipping to Amazon FBA            | 14 days (sea freight + customs) |
| Safety Buffer                     | 7 days                          |
| **Total Target Days**             | **42 days**                     |

{% hint style="danger" %}
**Action required:** In this example, you have only 15 days of stock but your total replenishment cycle is 42 days. You need to place an emergency order immediately, or consider air freight to bridge the gap.
{% endhint %}

***

## Reorder Calculation Template

Use this template to configure your Target Days slider for each product category:

| Component                | Your Value  | Notes                                 |
| ------------------------ | ----------- | ------------------------------------- |
| Supplier Production Time | \_\_\_ days | Time from PO to goods ready           |
| Shipping to Amazon       | \_\_\_ days | Transit + customs + FBA check-in      |
| Safety Buffer            | \_\_\_ days | Extra cushion (7-14 days recommended) |
| **Total Target Days**    | \_\_\_ days | Set your slider to this value         |

{% hint style="info" %}
**Best practice:** Create a spreadsheet with these values for each supplier. Your Target Days should reflect your slowest supplier if you cannot filter by product group.
{% endhint %}

***

## 🔍 Filters

The toolbar keeps the everyday controls in reach - **Search**, the **View** chips, the **Replenish for** window, **Columns**, **Export**, and **Refresh** - and tucks the detail filters behind a **Filters** button. Click **Filters** to open the drawer with Marketplace, Sales lookback, Fulfillment, Condition, and Listing-status controls. When any of those is set to something other than its default, the Filters button shows a small **dot** so you can tell filters are active even while the drawer is closed.

| Filter                    | Options                                                              | Default |
| ------------------------- | -------------------------------------------------------------------- | ------- |
| **Marketplace**           | All Marketplaces, EFN (Pan-EU), or a specific marketplace            | All     |
| **Sales lookback**        | 7, 14, 30, 60, 90, 180, 365 days (for velocity calculation)          | 30 days |
| **Fulfillment**           | FBA, FBM                                                             | All     |
| **Condition**             | New, Used - Like New, Used - Very Good, Used - Good, Refurbished     | All     |
| **Listings**              | All, or Active only (see below)                                      | All     |
| **View**                  | All, Need attention, Fully stocked, Slow movers, Revival (see below) | All     |
| **Replenish for (chips)** | 14, 30, 60, 90 days, or Custom (1-365)                               | 30 days |
| **Hide 0 to send**        | Toggle chip - hides rows where Units to Send is 0                    | Off     |

### Listing-status filter (All vs Active only)

A listing that has gone **Inactive, Incomplete, or Expired** on Amazon can still hold stock, so by default the tool shows **All** listings, that way suppressed listings sitting on inventory stay visible (they carry a yellow/red badge in the product cell).

* **All** - show every listing, including Inactive / Incomplete / Expired ones.
* **Active only** - hide suppressed / incomplete / expired listings and show just the ones currently live on Amazon.

{% hint style="warning" %}
**Why this matters:** Stock trapped on a suppressed listing is easy to forget. Leave the filter on **All** when you audit for stranded inventory; switch to **Active only** when you just want a clean picture of your sellable catalog.
{% endhint %}

### View quick-filter chips

A row of **View** chips slices the table by replenishment urgency in one click. Each chip carries a live **count**:

| Chip               | Shows                                                                                                                                        |
| ------------------ | -------------------------------------------------------------------------------------------------------------------------------------------- |
| **All**            | Every product in the current view                                                                                                            |
| **Need attention** | Rows that need a look - Units to Send greater than 0, out of stock, overstocked, idle stock (no sales / slow / dead), or an inactive listing |
| **Fully stocked**  | Healthy and overstocked rows                                                                                                                 |
| **Slow movers**    | Has stock but **0 sales** in the lookback window - dead inventory                                                                            |
| **Revival**        | Dormant listings that used to sell but have had no sales for 60+ days - candidates to stock and sell again (see below)                       |

> **Quick win:** Click **Slow movers** every few weeks to surface dead stock, units sitting in the warehouse with no recent sales, before they rack up long-term storage fees.

### Revival view

The **Revival** chip opens a dedicated view of **products with no sales for 60+ days that used to sell** - listings worth reconsidering for a restock. Rows are ranked by how fast the product sold **while it was still buyable**, so a strong past seller floats to the top even if it went quiet.

Because the restock decision here hinges on different signals, Revival swaps in its **own filter row** (not the normal Filters drawer) with just the axes that matter:

* **Marketplace** - built from the candidate set (flags + counts); hidden when there is only one.
* **Condition** - built from the candidate set; hidden when there is only one condition.
* **Listing** - All / Active / Inactive - Expired.
* **Last sold** - All / ≤ 6 mo / ≤ 12 mo.

It also brings **its own columns**:

| Column                 | Shows                                                                                                                                |
| ---------------------- | ------------------------------------------------------------------------------------------------------------------------------------ |
| **Last sold**          | When this listing last sold a unit (fresher is better)                                                                               |
| **Active span**        | Days between the first and last sale of the anchored window, and how many of those days actually had sales                           |
| **Sold (active span)** | Units sold in the 90 days before the last sale - the demand that existed while the product was still buyable                         |
| **Ø/day (active)**     | Units sold divided by the active span (a warning icon flags sales concentrated in only a few days)                                   |
| **Potential/mo**       | Estimated units per month if restocked, at the active-span rate (treat it as an upper bound - demand decays with time off the shelf) |

{% hint style="info" icon="circle-info" %}
**Revival loads on demand.** The candidate set is fetched the first time you open the view, so its chip count stays blank until then. Open the [Stock Forecast](#per-product-forecast-chart) on any candidate before you commit - a product that stopped selling long ago may not recover its old rate.
{% endhint %}

> **Pro tip:** Use a **7-day lookback** during fast-moving periods (Prime Day, Black Friday) to capture spikes. Switch back to **30 days** during normal periods for a more stable average.

### Choosing the Right Lookback Period

| Period             | Best For                                   | Watch Out For                               |
| ------------------ | ------------------------------------------ | ------------------------------------------- |
| **7 days**         | Capturing recent trends, during promotions | Overreaction to one-off spikes              |
| **14 days**        | Balanced short-term view                   | May still reflect temporary promotions      |
| **30 days**        | Stable average, most sellers' default      | May lag behind seasonal shifts              |
| **60 days**        | Smoothing out mid-term seasonality         | Slower to react to a genuine trend change   |
| **90 days**        | Long-term trending, slow-moving inventory  | Ignores recent sales velocity changes       |
| **180 / 365 days** | Very slow movers and yearly seasonal SKUs  | Heavily dampens any recent change in demand |

***

## EFN (Pan-European) Mode

If you use Amazon's **European Fulfillment Network (EFN)**, the tool automatically aggregates inventory for the same ASIN across EU marketplaces (DE, FR, IT, ES, NL, SE, PL, BE). Stock levels use the maximum values (shared pool), while sales velocity is summed across all participating marketplaces.

> EFN (European Fulfillment Network) mode ensures your forecasting accounts for the shared inventory pool, preventing duplicate reorder recommendations.

{% hint style="warning" %}
**Pan-European sellers:** If you recently switched from EFN to Pan-EU (where Amazon distributes stock across multiple country warehouses), your inventory data will shift. Allow 2-3 days for SellerMagnet to recalibrate stock positions after a fulfillment network change.
{% endhint %}

### "Group by" control (SKU / Listing / Marketplace)

When you sell on **more than one marketplace**, a **Group by** control appears in the toolbar. It decides how the same product spread across countries is rolled up into table rows:

| Mode            | Rows shown                                              | Best for                                         |
| --------------- | ------------------------------------------------------- | ------------------------------------------------ |
| **SKU**         | One row per origin SKU (aggregated across marketplaces) | Pan-EU / EFN sellers who manage a shared pool    |
| **Listing**     | One row per (SKU, marketplace) listing                  | Reviewing each country's listing individually    |
| **Marketplace** | Raw rows, one per marketplace, no grouping              | Seeing untouched per-marketplace stock and sales |

{% hint style="info" icon="circle-info" %}
**Multi-marketplace columns.** With more than one marketplace connected, the table also gains explicit **Condition** and **Fulfillment** columns so you can tell an FBA row from an FBM row, and a New listing from a Used one, at a glance.
{% endhint %}

***

## Per-Product Forecast Chart

Open the **Stock Forecast** from a row's [⋮ Actions menu](#row-actions-menu) to view a detailed stock forecast for that individual product:

* Historical stock levels
* Projected depletion timeline
* Recommended reorder point
* Expected out-of-stock date

### The decision band

Instead of four separate KPI cards, the top of the modal now reads as **one decision**, stated as a single sentence:

* **"Order {qty} units by {date}"** - place this order by this date to land before you run dry, or
* **"Order {qty} units as soon as possible"** - you are already late, order now, or
* **"No order needed yet - reorder point {date}"** - current stock still covers the lead time; the date is when to revisit, or
* **"Not enough sales to recommend an order"** - too little history to size a reorder.

Next to the sentence sit the **Lead time** and **Safety** day inputs. Both feed the recommendation, so adjusting them re-sizes the order and moves the reorder date immediately.

### The two quiet stat cards

Below the decision, two low-emphasis stat cards turn the forecast into a money decision:

| Stat                    | What it shows                                                                                                                       |
| ----------------------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| **Cost of next batch**  | The recommended order quantity multiplied by your unit COGS (Cost of Goods Sold), i.e. what that batch will cost from your supplier |
| **Lost revenue at OOS** | Projected revenue you would lose if the SKU goes out of stock - the demand during the stock-out gap multiplied by the unit price    |

{% hint style="info" icon="circle-info" %}
**These two need your cost and price data.** **Cost of next batch** only shows a figure once a supplier COGS is on file for the product (otherwise it reads "Needs supplier cost" and offers an **Add product cost** link), and **Lost revenue at OOS** needs a selling price and measurable sales velocity. If current stock already covers the lead time, **Lost revenue at OOS** correctly shows zero - nothing is at risk.
{% endhint %}

> **Why it matters:** The decision band tells you what to order and by when in one line, and the two stat cards show the cash the next purchase order ties up **and** the revenue you stand to lose by not placing it, side by side.

### "What-if" reorder simulator

Below the forecast chart is a **what-if slider** that lets you preview the impact of a reorder before you place it. Drag the slider to a quantity (it starts anchored at the recommended order quantity) and the chart draws a separate **"Simulated (your order)"** series on top of the existing forecast line.

* The simulated order is assumed to **arrive after your configured lead time** - so the bump in the line appears on the day the shipment would land, not today.
* From its arrival day, the simulated stock depletes at the product's daily sales velocity, just like real inventory.
* This lets you see at a glance how a given order size pushes out your projected stock line and your out-of-stock date.

{% hint style="info" icon="circle-info" %}
**It builds on the real forecast.** The simulated line starts from the same baseline as the orange forecast line (which already accounts for inbound shipments and reservations) and adds your hypothetical order on top - so the two lines stay aligned and you only see the difference your order makes. Adjust the **Lead time** and **Safety days** inputs first; they feed both the recommendation and where the simulated order lands.
{% endhint %}

> **Why it matters:** Before committing to a purchase order, slide the quantity up or down to find the smallest order that still clears your out-of-stock gap. Order too little and the line still dips to zero; order too much and you can see the overstock building on the tail of the curve.

### Exporting the forecast series

The per-product forecast modal has its own **Export** menu so you can pull that single SKU's projected curve out as a spreadsheet. Choose **CSV** or **Excel (.xlsx)**, the file is named after the product's SKU and contains the day-by-day series:

| Column                       | Description                                       |
| ---------------------------- | ------------------------------------------------- |
| **date**                     | Each day in the forecast horizon                  |
| **projected\_stock**         | Projected units remaining on that date            |
| **recommended\_order\_date** | Your recommended reorder date (on the first row)  |
| **projected\_oos\_date**     | The expected out-of-stock date (on the first row) |

> **Why it matters:** Export a specific SKU's depletion curve to drop straight into a supplier PO discussion or a reorder spreadsheet, without exporting the whole catalog.

***

## Actions

| Action      | Description                                                                                                                                           |
| ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Search**  | Filter by product name, SKU, ASIN, or FNSKU                                                                                                           |
| **Filters** | Open the drawer with Marketplace, Sales lookback, Fulfillment, Condition, and Listing-status controls (a dot flags active filters)                    |
| **Columns** | Show/hide columns to customize your view, remembered as your default; also sets the separate print layout (see [below](#saved-default-view))          |
| **Export**  | Download the table as CSV or Excel; the [bulk bar](#bulk-selection) exports selected rows only, and the per-product chart exports its forecast series |
| **Print**   | Print-optimized view using its own saved column layout (UI elements removed)                                                                          |
| **Refresh** | Manual data reload                                                                                                                                    |

### Saved Default View

The **Columns** menu lets you tailor which columns appear, and **SellerMagnet remembers your choice as your default view** so you don't have to reconfigure it on every visit.

* Open the **Columns** menu and tick or untick columns, or use a **Quick view** preset: **Default** (the standard column set) or **Print-friendly** (just Product, To send, and Days left on screen for a clean warehouse pick-list).
* A footer in the menu confirms the contract: **"Saved as your default view."**
* Your column choice persists **across sessions and across devices**, it is saved to your account (per user), not just to one browser, so signing in on another machine inherits the same layout.

{% hint style="info" icon="circle-info" %}
**The print-out has its own saved layout.** Printing does **not** copy whatever columns are on screen. Out of the box it prints just **Product, To send, and Days left**. To make the print-out use exactly the columns you have visible right now, open the **Columns** menu and click **"Use current columns for print"** under the **Print layout** section - it confirms with "Print layout saved." The two layouts are independent, so your rich on-screen view and your lean print-out can differ.
{% endhint %}

{% hint style="info" icon="circle-info" %}
**Columns are remembered; filters are not.** Your column layout is a saved display preference. The data filters (Marketplace, Sales lookback, Replenish for, etc.) deliberately reset each visit so you always start from a clean, current view.
{% endhint %}

> **Why it matters:** Set a lean column view once, e.g. Product, To send, Days left for warehouse pick-lists, and save a separate print layout so your printouts stay clean no matter how many columns you add on screen.

***

## 🔄 Before & After: Impact of Using Inventory Management

| Metric                    | Before SellerMagnet     | After SellerMagnet   |
| ------------------------- | ----------------------- | -------------------- |
| Stockout frequency        | 3-5 products/month      | 0-1 products/month   |
| Overstock (excess units)  | 40% of catalog          | Under 10% of catalog |
| Manual spreadsheet time   | 4-6 hours/week          | 0 hours (automated)  |
| Revenue lost to stockouts | \~8-12% monthly         | Under 2% monthly     |
| Storage fee waste         | High (overstocked SKUs) | Minimal              |

{% hint style="success" %}
**ROI example:** A seller doing EUR 50,000/month who reduces stockout-related revenue loss from 10% to 2% recovers **EUR 4,000/month**, that is EUR 48,000/year in revenue that would have otherwise been lost.
{% endhint %}

***

## Seasonal & Timing Advice

{% hint style="warning" %}
**Q4 preparation (September-October):** Increase your Target Days slider by 50-100% starting in September. Supplier lead times stretch during peak season, and Amazon's FBA receiving windows become slower. If your normal target is 45 days, consider setting it to 70-90 days for Q4 SKUs.
{% endhint %}

{% hint style="info" %}
**Post-holiday (January-February):** After the holiday rush, switch your lookback to **90 days** temporarily. A 7- or 14-day lookback in early January will show artificially low sales velocity and cause you to under-order for February/March recovery.
{% endhint %}

{% hint style="info" %}
**Prime Day (typically July):** Two weeks before Prime Day, switch to a **7-day lookback** for any products included in Lightning Deals or promotions. Revert to 30 days one week after the event.
{% endhint %}

***

<details>

<summary><strong>⚠️ Common Mistakes to Avoid</strong></summary>

{% hint style="danger" %}

* **Mistake 1: Using a lookback period that is too short during product launches.** New products with only 7 days of sales history will have unreliable velocity calculations. Wait until you have at least 14-30 days of data before relying on automated reorder recommendations.
* **Mistake 2: Ignoring inbound shipments in your calculations.** If you have 200 units inbound and the tool shows 200 "Units to Send," you do not need to send 200 more. The inbound column already factors into the recommendation, but double-check that your inbound shipment is actually moving (not stuck at "Checked In" for weeks).
* **Mistake 3: Setting the same Target Days for all products.** A product sourced from a local warehouse (3-day lead time) and a product from overseas (45-day lead time) should not share the same Target Days. Use the slider as a global default, but review individual SKUs that deviate from your typical supply chain.
* **Mistake 4: Not accounting for Amazon's receiving delays.** During Q4 or after major sale events, Amazon warehouses can take 1-3 weeks to check in your inventory. Factor this into your Target Days. Your goods are not sellable until they appear as "Available."
* **Mistake 5: Overstocking slow-moving SKUs.** Just because a product is "Low" does not mean you should send 6 months of stock. For slow sellers (under 1 unit/day), overstocking triggers long-term storage fees. Keep target days conservative for these items.
  {% endhint %}

</details>

\## 🔧 Troubleshooting

### Why is my inventory not syncing?

1. **Check your Amazon SP-API (Selling Partner API) connection.** Navigate to Settings > Connections and verify your Amazon marketplace shows a green "Connected" status.
2. **Verify the correct marketplace is selected.** If you are filtering by Amazon.de but your inventory is on Amazon.com, you will see no data.
3. **Allow time after initial setup.** First-time syncs can take 15-60 minutes depending on catalog size. Check the **"Synced"** freshness chip in the toolbar for how long ago the data was last updated from Amazon.
4. **Check Amazon Seller Central.** If Seller Central itself is showing delayed data (common during peak periods), SellerMagnet will reflect the same delays.

### Why does "Units to Send" show zero for a product I know needs restocking?

* Your inbound shipments may already cover the expected demand. Check the "Inbound" column.
* The "Hide 0 to send" filter may be off but the lookback period might show low sales. Try switching from 30 to 14 days.
* The product might have zero sales in the lookback period, resulting in a "No Sales" status.

### Why is my Daily Sales Avg different from what I see in Seller Central?

SellerMagnet calculates the average using the lookback period you selected. Seller Central may use a different time window. Additionally, SellerMagnet excludes days when you were completely out of stock from the velocity calculation (to avoid deflating the average).

### My forecast chart shows a sudden drop: what happened?

A sudden drop usually indicates either: (a) a bulk order or promotion that spiked sales, (b) a shipment that was received and then quickly sold, or (c) an inventory adjustment by Amazon (removed or transferred units). Check your Reimbursements page for any lost/damaged inventory events around that date.

***

## ❓ FAQ

<details>

<summary><strong>Does SellerMagnet account for out-of-stock days when calculating sales velocity?</strong></summary>

Yes. Days when your product had zero available stock are excluded from the Daily Sales Avg calculation. This prevents the average from being artificially deflated by stockout periods and gives you a more accurate reorder quantity.

</details>

<details>

<summary><strong>Can I set different Target Days for different products?</strong></summary>

The Target Days slider applies globally to all products in the current view. For product-level customization, use the per-product forecast chart to manually assess individual SKUs with different lead times.

</details>

<details>

<summary><strong>How often does inventory data refresh?</strong></summary>

Inventory data syncs automatically every 2-4 hours via the Amazon SP-API. You can trigger a manual refresh at any time using the Refresh button.

</details>

<details>

<summary><strong>Does this work for FBM (Merchant Fulfilled) products?</strong></summary>

Yes. Switch the Fulfillment Type filter to FBM. For FBM products, "Current Stock" reflects the inventory count you have reported to Amazon. Sales velocity and forecasting work the same way.

</details>

<details>

<summary><strong>What happens if I sell on multiple EU marketplaces with EFN?</strong></summary>

SellerMagnet automatically detects EFN enrollment and aggregates your inventory. You will see one consolidated row per ASIN instead of separate rows per marketplace, with combined sales velocity across all EU marketplaces.

</details>

<details>

<summary><strong>Can I export the data to share with my supplier?</strong></summary>

Yes. Click Export and choose CSV or Excel. The export includes all visible columns, so use the Columns menu to include or exclude fields before exporting. To send just a shortlist, tick the rows you want and use **Export CSV** on the bulk-selection bar. Many sellers send the file directly to their supplier with the "To send" column highlighted. (For a printout, the Export menu also has a Print option, which uses its own separate saved column layout - set it with "Use current columns for print" in the Columns menu.)

</details>

<details>

<summary><strong>Why does the Expected OOS Date keep changing?</strong></summary>

The Expected OOS Date is recalculated on every data sync based on your current stock level and the most recent sales velocity. If your sales speed up (e.g., a competitor goes out of stock), the OOS date moves closer. If sales slow down, it moves further out.

</details>

***

## 💡 Tips

> **Pro tip:** Set your **Target Days** slider to match your supplier lead time + shipping time. For example, if your supplier needs 15 days to produce and 10 days to ship to Amazon, set the target to 30-40 days (with buffer).

> Filters are **saved between sessions** via local storage, so your preferred view persists when you return.

> **Pro tip:** Export your inventory report every Monday morning and compare it to the previous week. Look for any product that shifted from "Healthy" to "Low", those are your priority reorders for the week.

> **Pro tip:** If you run Lightning Deals or Coupons, temporarily reduce your lookback to 7 days for the week after the promotion ends. This helps you see whether the elevated sales velocity is sustainable or a one-time spike.

***

## ➡️ What's Next?

{% content-ref url="/pages/073kGFTZ9tHJ4G50F2XW" %}
[Fee Audit](/inventory-and-operations/fee-audit.md)
{% endcontent-ref %}

{% content-ref url="/pages/GQTlLpp6bu8z9YBUMb55" %}
[Reimbursements (Lost & Found)](/inventory-and-operations/reimbursements.md)
{% endcontent-ref %}