Products Management

Manage your complete product catalog with COGS (Cost of Goods Sold) tracking, batch management, stock forecasting, variant grouping, and inventory alert rules. The foundation for accurate profit calcu

Difficulty: 🟡 Intermediate · Reading time: ~10 min

Open this page in your dashboard: Go to Products Management →

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.

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.

---

🎥 Video Walkthrough

Video tutorial coming soon. A full guided walkthrough of this feature will be available here shortly.

---

🗂️ 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

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

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.

---

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"

1. Click "Save" to create the batch.

2. The batch appears in the list, and COGS calculations update across all dashboards.

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.

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.

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.

---

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

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.

---

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.

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.

---

🎯 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.

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.

---

⚠️ Common Mistakes to Avoid

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

## ✅ 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

How does SellerMagnet calculate COGS when I have multiple batches?

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.

Can I import batch data in bulk?

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

What if I sell the same product on multiple marketplaces?

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.

How accurate is the Stock Forecast?

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.

Can I set different alert thresholds per marketplace?

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

What happens if I forget to create a batch for a product?

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.

Does the stock improvedate in real time?

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.

---

➡️ What's Next?

Product TagsListing Performance