# Products Management

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

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

The **Products Management** page is where you manage your entire product catalog, track Cost of Goods Sold (COGS) through the batch system, monitor stock levels, and configure inventory alerts. Accurate product data here is the foundation for every profit, margin, and ROI calculation throughout SellerMagnet.

> Every profit number you see on the Dashboard, Orders, and Reports pages depends on the COGS data entered here. If your profit figures look wrong, this is the first place to check.

{% hint style="warning" %}
**Critical First Step:** Before analysing any profit data, create product batches for your top 10 revenue-generating SKUs. This takes about 15 minutes and unlocks accurate profit calculations across the entire platform.
{% endhint %}

***

## 🎥 Video Walkthrough

{% hint style="info" %}
**Video tutorial coming soon.** A full guided walkthrough of this feature will be available here shortly.
{% endhint %}

***

## 🗂️ Page Structure

| Section                   | Purpose                                                                            |
| ------------------------- | ---------------------------------------------------------------------------------- |
| **Products Table**        | Full catalog with search, sort, and pagination                                     |
| **Product Batches Modal** | COGS management, batch creation/editing, and stock tracking                        |
| **Stock Forecast**        | Projected stockout dates, daily usage, and reorder timing                          |
| **Inventory Alert Rules** | Configurable thresholds for out-of-stock, low inventory, and restock notifications |

***

## Products Table

![SellerMagnet Products Management](/files/2neRAfpu9grYHlmAhFrd)

The main products table lists every product in your connected Amazon catalog.

### Table Columns

| Column          | Description                                                                                      | Sortable |
| --------------- | ------------------------------------------------------------------------------------------------ | -------- |
| **Product**     | Product image, title, ASIN (Amazon Standard Identification Number), and SKU (Stock Keeping Unit) | Yes      |
| **Marketplace** | Amazon marketplace where the product is listed                                                   | Yes      |
| **Fulfillment** | FBA or FBM indicator                                                                             | Yes      |
| **Stock**       | Current available stock quantity                                                                 | Yes      |
| **Price**       | Current listing price                                                                            | Yes      |
| **COGS**        | Cost of Goods Sold per unit (from batch data)                                                    | Yes      |
| **Units Sold**  | Total units sold in the selected period                                                          | Yes      |
| **Revenue**     | Total revenue generated                                                                          | Yes      |
| **Profit**      | Net profit after all costs                                                                       | Yes      |
| **Margin %**    | Profit margin percentage                                                                         | Yes      |
| **ROI %**       | Return on investment percentage                                                                  | Yes      |
| **Actions**     | Batch management and other quick actions                                                         | No       |

### Search and Filtering

* **Search bar:** Filter by product name, ASIN, or SKU
* **Marketplace filter:** Select a specific marketplace or view all
* **Pagination:** Navigate through your product catalog with configurable page sizes

{% hint style="warning" %}
Products with no batch data will show COGS as EUR 0.00, which means profit calculations are overstated. Look for products with suspiciously high margins, they likely need batch data.
{% endhint %}

***

## Product Batches (COGS Management)

The batch system is SellerMagnet's approach to tracking the Cost of Goods Sold for your products. Each "batch" represents a purchase of inventory at a specific price.

### Why Batches Matter

| Without Batches                                  | With Batches                                 |
| ------------------------------------------------ | -------------------------------------------- |
| Profit shows as "Revenue minus Amazon Fees" only | Profit accurately reflects true COGS         |
| Margin appears artificially high                 | Margin reflects actual profitability         |
| ROI calculation is meaningless                   | ROI shows true return on your investment     |
| Stock forecasting unavailable                    | Stock depletion and reorder timing available |
| Cannot track purchase price changes over time    | Full history of procurement costs            |

### Opening the Batches Modal

1. Navigate to **Dashboard > Products**
2. Find the product you want to manage
3. Click the **batch/edit icon** in the Actions column
4. The Product Batches modal opens

### Batch Modal Layout

The modal is organized into these sections:

| Section            | Description                                                                                                                                        |
| ------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Product Header** | Product image, name, SKU, total units sold                                                                                                         |
| **Batch List**     | Scrollable list of all existing batches for this product                                                                                           |
| **Batch Form**     | Create or edit a batch with fields for quantity, unit costs (net, tax, shipping, payment fee, customs), arrival date, currency, and returns toggle |
| **Stock Forecast** | Visual chart and KPIs projecting inventory depletion                                                                                               |

***

## 👣 Step-by-Step: Creating a New Batch

1. Open the **Product Batches modal** for your product.
2. Click the **"Create Batch"** button (or the plus icon).
3. Fill in the batch form:

| Field                               | Description                                                               | Example                          |
| ----------------------------------- | ------------------------------------------------------------------------- | -------------------------------- |
| **Batch Name**                      | A descriptive label for this purchase lot                                 | "Q2 Main Reorder"                |
| **Total Units**                     | Number of units purchased                                                 | 500                              |
| **Unit Net Cost**                   | Net purchase price per unit                                               | EUR 4.75                         |
| **Unit Tax Cost**                   | Tax cost per unit (VAT, sales tax)                                        | EUR 0.90                         |
| **Unit Shipping Cost**              | Inbound shipping cost allocated per unit                                  | EUR 0.35                         |
| **Unit Payment Fee**                | Payment processing fee per unit (if applicable)                           | EUR 0.10                         |
| **Unit Customs or Additional Cost** | Import duties, customs, or other per-unit costs                           | EUR 0.20                         |
| **Arrival Date**                    | Date the inventory was received                                           | 2026-03-15                       |
| **Currency**                        | Currency of the purchase prices                                           | EUR                              |
| **Add Returns to Batch**            | Toggle: whether returned units are added back to this batch's stock count | Off                              |
| **Supplier**                        | (Optional) Supplier name for your records                                 | GlobalSource Ltd.                |
| **Notes**                           | (Optional) Any additional information                                     | "Q2 reorder, 5% volume discount" |

4. Click **"Save"** to create the batch.
5. The batch appears in the list, and COGS calculations update across all dashboards.

{% hint style="success" icon="rocket" %}
**Pro Tip:** Create a new batch every time your purchase price changes, even if it is from the same supplier. This maintains an accurate historical record of COGS and lets you see how procurement cost changes affect your margins over time.
{% endhint %}

### Editing a Batch

1. Click the **edit button** on an existing batch in the list.
2. Modify any field (quantity, price, date, notes).
3. Click **"Edit"** to save changes.
4. All profit calculations that reference this batch update automatically.

### Deleting a Batch

1. Click the **delete button** on the batch you want to remove.
2. A confirmation dialog appears: *"Are you sure you want to delete this batch?"*
3. Click **"Delete"** to confirm.

{% hint style="danger" %}
Deleting a batch removes its COGS data from all historical profit calculations. Only delete batches that were entered in error. If you need to correct a batch, use the Edit function instead.
{% endhint %}

***

## Stock Forecast

The Stock Forecast feature is integrated into the Product Batches modal and provides predictive analytics for inventory management.

### Forecast KPIs

| KPI                | Description                                     | Health Indicator                                           |
| ------------------ | ----------------------------------------------- | ---------------------------------------------------------- |
| **Current Stock**  | Units currently available in Amazon's warehouse | Cyan icon                                                  |
| **Days Remaining** | Estimated days until complete stockout          | Yellow icon; shows "Healthy" / "Warning" / "Critical" pill |
| **Daily Usage**    | Average units sold per day (30-day lookback)    | Green icon                                                 |
| **Stockout Date**  | Projected date when inventory reaches zero      | Red icon                                                   |

### Health Status Indicators

| Status       | Condition                                 | Color       |
| ------------ | ----------------------------------------- | ----------- |
| **Healthy**  | More than 30 days of stock remaining      | Green pill  |
| **Warning**  | Between 14 and 30 days of stock remaining | Yellow pill |
| **Critical** | Fewer than 14 days of stock remaining     | Red pill    |

### Forecast Chart

The chart displays:

* **Blue solid line:** Actual historical stock levels
* **Gray solid line:** Historical daily sales rate
* **Orange dashed line:** Projected future stock depletion
* **Red dotted line:** Stockout threshold (zero inventory)

You can:

* **Hover** over any point to see the exact date and stock level
* **Zoom** in or out to focus on specific time periods
* Click **"Reset Zoom"** to return to the default view

{% hint style="success" icon="rocket" %}
**Pro Tip:** If you have a 60-day lead time from your supplier, set your reorder point at the 60-day mark on the forecast chart. When the projected stock line crosses that point, it is time to place your reorder.
{% endhint %}

***

## Inventory Alert Rules

Inventory Alert Rules let you configure automatic notifications when stock levels reach critical thresholds.

### Accessing Alert Rules

1. Open the **Product Batches modal** for any product.
2. Click the **gear/settings icon** in the modal header.
3. The Inventory Rules modal opens.

### Configurable Rules

| Rule               | Description                                     | Recommended Setting                     |
| ------------------ | ----------------------------------------------- | --------------------------------------- |
| **Out of Stock**   | Alert when stock reaches exactly 0 units        | Enable for all products                 |
| **Low Inventory**  | Alert when stock drops below a custom threshold | Set to your average 14-day sales volume |
| **Restock Needed** | Alert when stock drops below your reorder point | Set to cover your supplier lead time    |

### Setting Up a Rule

1. Open the Inventory Rules modal.
2. For each rule section, toggle the rule **on/off**.
3. Set the **threshold value** (number of units).
4. Select the **marketplace** the rule applies to (or "All").
5. Click **"Save Rules"** to activate.

{% hint style="info" %}
Inventory alerts are delivered through SellerMagnet's notification system. Make sure your notification preferences are configured in **Settings > Notifications** to receive email or in-app alerts.
{% endhint %}

***

## 🎯 Real-World Scenario: Managing a Product Launch

**Situation:** You are launching a new product with 1,000 units of initial inventory at EUR 3.20 per unit.

| Step | Action                                                                                                                            |
| ---- | --------------------------------------------------------------------------------------------------------------------------------- |
| 1    | Navigate to **Products Management** and locate the new product (it appears automatically once listed on Amazon)                   |
| 2    | Open the **Product Batches modal** for the product                                                                                |
| 3    | Create a new batch: Total Units = 1000, Unit Net Cost = EUR 3.20, plus any tax/shipping/customs costs, Arrival Date = launch date |
| 4    | Set up **Inventory Alert Rules**: Low Inventory at 200 units, Restock at 350 units                                                |
| 5    | After 2 weeks, check the **Stock Forecast** to see daily usage trends                                                             |
| 6    | If daily usage is 15 units/day and supplier lead time is 30 days, you need to reorder when stock hits 450 units (15 x 30)         |

**Before batches:** Dashboard shows EUR 12,480 profit on the product (misleading, just revenue minus fees). **After batches:** Dashboard shows EUR 5,280 real profit (revenue minus fees minus EUR 3,200 COGS).

***

## Managing Multiple Batches

When you reorder inventory at different prices, you accumulate multiple batches per product. SellerMagnet handles this using a **FIFO (First In, First Out)** approach by default. You can also assign an average price across all batches for orders not covered by a specific batch's time period:

| Batch   | Qty | Price/Unit | Date       |
| ------- | --- | ---------- | ---------- |
| Batch 1 | 500 | EUR 3.20   | 2026-01-10 |
| Batch 2 | 300 | EUR 3.45   | 2026-03-05 |
| Batch 3 | 700 | EUR 2.95   | 2026-04-01 |

As orders come in, COGS are allocated from the earliest batch first. Once Batch 1's 500 units are depleted, COGS automatically shift to Batch 2's price.

{% hint style="warning" %}
If you delete an earlier batch, the COGS allocation shifts to the next available batch. This can retroactively change profit calculations for historical orders. Always use Edit instead of Delete when correcting batch data.
{% endhint %}

***

<details>

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

| Mistake                              | Impact                                                     | Better Approach                                                   |
| ------------------------------------ | ---------------------------------------------------------- | ----------------------------------------------------------------- |
| Not creating batches for any product | All profit numbers are wrong across the entire platform    | Make batch creation part of your receiving workflow               |
| Using one batch for all inventory    | Cannot track price changes or calculate accurate FIFO COGS | Create a new batch for each purchase order                        |
| Entering COGS in the wrong currency  | Over/understated costs                                     | Always enter prices in your SellerMagnet base currency            |
| Ignoring the Stock Forecast          | Running out of stock leads to lost sales and ranking drops | Check forecasts weekly for your top products                      |
| Setting alert thresholds too low     | Alerts arrive after it is too late to reorder              | Set thresholds that account for supplier lead time + safety stock |
| Deleting batches to "fix" data       | Destroys historical COGS records                           | Edit the batch instead of deleting and recreating                 |

</details>

\## ✅ Best Practices

1. **Create batches immediately** when inventory is received, not when it starts selling.
2. **Record all cost components** per unit: net cost, tax, shipping, payment fees, and customs/import duties. This ensures your COGS reflect true landed cost.
3. **Use notes** on batches to track supplier names, PO numbers, or volume discounts.
4. **Review stock forecasts weekly** for your top 20 revenue-generating products.
5. **Set inventory alerts** for every product with more than 10 units/day sales velocity.
6. **Audit COGS quarterly** by comparing your batch records against supplier invoices.

***

## Comparison: Products Table vs. Ordered Products

| Feature                      | Products Management     | Ordered Products (Orders section) |
| ---------------------------- | ----------------------- | --------------------------------- |
| **Focus**                    | Full catalog management | Sales performance analysis        |
| **Includes unsold products** | Yes                     | No (only products with orders)    |
| **Batch/COGS management**    | Yes (primary purpose)   | No (read-only COGS display)       |
| **Stock Forecast**           | Yes                     | No                                |
| **Inventory Alerts**         | Yes                     | No                                |
| **Tag filtering**            | Via Products            | Yes (filter by tags)              |
| **Financial breakdown**      | Basic P\&L per product  | Detailed per-order breakdown      |

***

## ❓ FAQ

<details>

<summary><strong>How does SellerMagnet calculate COGS when I have multiple batches?</strong></summary>

SellerMagnet uses FIFO (First In, First Out) allocation by default. The oldest batch's cost is used first. When that batch is fully depleted, it moves to the next batch chronologically. For orders not covered by any batch's time period, you can also assign an average cost across all batches.

</details>

<details>

<summary><strong>Can I import batch data in bulk?</strong></summary>

Currently, batches are created individually through the Product Batches modal. Bulk import functionality is on the product roadmap.

</details>

<details>

<summary><strong>What if I sell the same product on multiple marketplaces?</strong></summary>

Create batches at the product level (per ASIN/SKU). The batch data applies across all marketplaces where that product is sold. Inventory alert rules can be set per marketplace.

</details>

<details>

<summary><strong>How accurate is the Stock Forecast?</strong></summary>

The forecast uses a 30-day rolling average of daily sales to project future depletion. Accuracy depends on sales consistency. Products with highly seasonal or promotional sales patterns may see less accurate forecasts.

</details>

<details>

<summary><strong>Can I set different alert thresholds per marketplace?</strong></summary>

Yes. When configuring inventory alert rules, you can select a specific marketplace or set rules that apply to all marketplaces.

</details>

<details>

<summary><strong>What happens if I forget to create a batch for a product?</strong></summary>

The product will show EUR 0.00 for COGS, which means all revenue minus Amazon fees appears as "profit." This overstates your actual profitability. We recommend creating batches for all products.

</details>

<details>

<summary><strong>Does the stock improvedate in real time?</strong></summary>

Stock data is synced from Amazon's API and typically updates multiple times per day. There may be a delay of a few hours between an actual stock change in Amazon and the reflected value in SellerMagnet.

</details>

***

## ➡️ What's Next?

{% content-ref url="/pages/xy8uixvNORGWL0LqDzwf" %}
[Product Tags](/dashboard-and-analytics/dashboard-overview/product-tags.md)
{% endcontent-ref %}

{% content-ref url="/pages/3gqW20LoOHjYA4o7jTeF" %}
[Listing Performance](/dashboard-and-analytics/dashboard-overview/listing-performance.md)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.sellermagnet.com/dashboard-and-analytics/dashboard-overview/products-management.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.