> 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/dashboard-and-analytics/dashboard-overview/products-management.md).
# Products Management
Manage your complete product catalog with COG (Cost of Goods) tracking, batch management, easy-mode flat costs, shipping-rate assignment, variant grouping, and inventory alert rules. The foundation fo
{% 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 (COG) 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 COG 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, add cost data 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, filters, column presets, sort, and pagination |
| **Product Batches Modal** | COG management, batch creation/editing, and easy-mode flat cost per SKU |
| **Bulk Actions** | Set costs, add batches, assign a shipping rate, or assign tags across many SKUs at once |
| **Inventory Rules** | A toolbar button opening account-wide out-of-stock, low-inventory, and auto-restock rules |
{% hint style="info" %}
**Stock forecasting lives on a separate page.** Projected stockout dates, daily usage, and reorder timing are on the **Inventory Planner**, opened from a product's **Manage** row menu -> **Open in Inventory Planner**. See [Managing Multiple Batches](#managing-multiple-batches) for how batch data feeds those forecasts.
{% endhint %}
***
## Products Table
The main products table lists every product in your connected Amazon catalog.
### Table Columns
The default **Essential** preset shows the columns below. The visible header text is deliberately short; the description explains what each column means.
| Column | Description | Sortable |
| --------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------- |
| **Product** | Product image, title, ASIN (Amazon Standard Identification Number), and SKU (Stock Keeping Unit). Also carries data-quality badges (No batch / No COG / Easy mode) and a clickable **BSR** rank box | No |
| **Fulfillment** | FBA or FBM indicator | No |
| **Condition** | Item condition - **New**, or a used grade such as **Used - Very Good**, **Collectible**, or **Refurbished** | No |
| **Status** | Listing status - **Active** or **No Stock** (other states such as Inactive, Incomplete, or Expired can also appear) | No |
| **Price** | Current listing price | Yes |
| **Batch stock** | Units still attributed to your cost **batches** (your own tracked inventory lots) | Yes |
| **Cost** | Average **COG** (Cost of Goods) per unit, from batch data or an easy-mode flat cost | Yes |
| **Stock** | Live available stock quantity as **Amazon** reports it | Yes |
| **Manage** | The **⋮** row menu (batches, deep-links, and quick actions) | No |
{% hint style="info" %}
**Batch stock vs. Stock** are two different numbers. **Batch stock** counts the units still covered by the cost batches you entered, so SellerMagnet knows which per-unit cost to apply. **Stock** is the live quantity Amazon reports for the listing. They can legitimately differ - for example when Amazon stock changes but you have not recorded a matching batch.
{% endhint %}
Only the four numeric columns - **Price**, **Batch stock**, **Cost**, and **Stock** - are sortable. Click a header to sort.
{% hint style="info" %}
**Fewer columns than you expected?** The default **Essential** preset hides **Fulfillment** and **Condition** and relocates their values into the meta line under the product name, so no data is lost - only its position changes. Switch to the **Full** preset or use the column customizer (see [Choosing Columns](#choosing-columns-view-presets)) to show every column.
{% endhint %}
### Choosing Columns (View presets)
The **View** button (columns icon) in the toolbar opens a small menu to control which columns are shown:
* **Essential** - a compact preset (Fulfillment and Condition hidden, their values moved under the product name).
* **Full** - shows every column.
* **Columns** - a per-column checklist to switch individual columns on or off.
A **"Saved on this device"** note confirms your choice is remembered locally - the preset and column selection persist in this browser across reloads.
### Search and Filtering
* **Search bar:** Filter by product name, ASIN, or SKU.
* **Marketplace filter:** Select a specific marketplace or view all. Marketplace is a **filter only** - it is not a table column.
* **Only active products:** A toggle to hide inactive/closed listings. Your choice is remembered.
* **Fulfillment filter:** Click the funnel icon in the toolbar to filter by **FBA Only** or **FBM Only** (use **Clear All** to reset). An active filter shows a small badge on the funnel.
* **Tag filter:** Filter the catalog by the tags you have assigned to products.
* **Pagination:** Navigate through your product catalog with configurable page sizes.
{% hint style="warning" %}
Products with no batch data will show COG as EUR 0.00, which means profit calculations are overstated. Look for products with a **No COG** badge or suspiciously high margins - they likely need cost data.
{% endhint %}
### Group by Parent ASIN (Variant Grouping)
Products that share a parent ASIN (sizes, colours, and other variations) can be rolled up into a single parent row. Use the **Variants** button (layer-group icon) in the toolbar to toggle grouping:
* **Default view** lists every child SKU on its own row.
* **Grouped view** (button highlighted, icon switches to the grouped state) collapses child SKUs under their **parent ASIN** so you can read catalog performance at the variation-family level.
Your choice is remembered - the toggle state persists across page reloads.
### BSR (Best Sellers Rank) History
Each product tile carries a small **BSR** rank box. Click it to open the **Best Seller Rank** history modal:
* A **Category / Subcategory** toggle switches between the primary and secondary rank.
* Time-range buttons - **30D**, **90D**, **6M**, **1Y**, and **All** - set the window.
* A chart plots the rank over time. Lower is better; Best Seller Rank is captured once per day.
### The Manage row menu
The **⋮** menu in the **Manage** column collects per-product actions and deep-links, including:
* **Manage Batches** - open the Product Batches modal (COG management) for this SKU.
* **Open in Repricer** - jump to the Repricer for this SKU/ASIN.
* **Open in Inventory Planner** - open this SKU's stock forecast (stockout date, daily usage, reorder timing).
* **Select Shipping Rate** - assign an FBM shipping rule to this product.
* Plus quick links such as Open in Listing Optimizer, Open in Sourcer, Listing Performance, Request Review, View Orders/Refunds/Analytics, Open on Amazon (Buyer view), Open in Seller Central, and Copy ASIN / Copy SKU.
***
## Product Batches (COG Management)
The batch system is SellerMagnet's approach to tracking the Cost of Goods 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 COG |
| Margin appears artificially high | Margin reflects actual profitability |
| ROI calculation is meaningless | ROI shows true return on your investment |
| Inventory Planner has no cost basis to project | Batch stock feeds the Inventory Planner forecast |
| 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 **⋮** menu in the **Manage** column and choose **Manage Batches**.
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, and the **Add returns back** toggle |
| **Easy-mode panel** | An optional flat cost per unit (feature-flagged - see [Easy Mode](#easy-mode-flat-cost-per-unit)) |
| **Batch Sidebar** | A list of all existing batches for this product, with a **New Batch** button |
| **Batch Form** | Create or edit a batch with fields for total units, the six per-unit costs (net, tax, shipping, payment fee, customs, additional), arrival date, and currency |
***
## Easy Mode: Flat Cost per Unit
{% hint style="info" %}
**Easy mode is feature-flagged.** It is enabled per account, so the toggle and the bulk **Set cost** action described below may not appear for every account. If you do not see them, batches are your cost source.
{% endhint %}
Near the top of the batch modal is an **"Easy mode: flat cost per unit"** toggle. Turn it **on** to skip inventory batches entirely and enter a **single flat cost per unit** that is used for **all** profit, margin, and ROI calculations for that SKU.
* **Turning it ON** collapses the batch fields and shows one **Cost per unit** input plus a currency selector. While active, this flat cost **overrides any batches** for that SKU.
* **Turning it OFF** (or clicking **New Batch** / an existing batch) returns you to full batch management.
In the products table, an **"Easy mode"** badge marks any SKU using a flat cost, and the flat value appears in the **Cost** column.
### Flat Cost vs. Batches - Which Should I Use?
| Use **flat cost** (Easy mode) | Use **batches** |
| ------------------------------------------------------ | ------------------------------------------------------- |
| Simplest option - one cost per unit, no stock tracking | Track cost per purchase lot and FIFO allocation |
| Your buy price rarely changes | Your buy price changes between reorders |
| You do not need per-lot cost history | You want per-lot cost history and returns-back-to-stock |
{% hint style="info" %}
Start with **Easy mode** if you just want correct profit numbers fast. Switch to **batches** later when you need FIFO cost tracking - no data is lost, the toggle simply changes which cost source is active.
{% endhint %}
### Bulk cost actions for many products
You do not have to open the batch modal one SKU at a time. Tick the row **checkboxes** in the table (or the header checkbox to select the whole page) and a floating **bulk-actions bar** appears with **Set cost**, **Bulk Add Batches**, **Shipping rate**, **Assign tags**, and **Export**. There are **two distinct flat-cost paths**, and it is worth knowing the difference:
{% hint style="info" %}
* **Set cost** (easy mode, per product) - opens *"Easy mode for selected products"*. Each selected SKU **keeps its own cost per unit**; you type a separate cost for each row and leave a field blank to skip it. Use this when the products cost different amounts.
* **Bulk Add Batches** (easy mode, shared cost) - the bulk batch modal has an **"Easy mode: flat cost for all selected"** toggle that writes **one shared flat cost** to every selected SKU at once. Use this when the whole selection costs the same per unit.
{% endhint %}
The same **Bulk Add Batches** modal also lets you create a full **inventory batch** across all selected products (name, units, and the per-unit cost breakdown) when you leave Easy mode off - handy when you received the same lot across several SKUs.
***
## 👣 Step-by-Step: Creating a New Batch
1. Open the **Product Batches modal** for your product.
2. Click the **"New Batch"** button in the modal sidebar.
3. Fill in the batch form. Fields marked **\*** are required; every cost field is **per unit** and combines into the batch's landed COG (a running **Total Cost per Unit** is shown as you type):
| 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 (ex-tax) | EUR 4.75 |
| **Unit Tax Cost** | Tax per unit (VAT, sales tax) | EUR 0.90 |
| **Unit Shipping Cost** | Inbound/freight shipping allocated per unit | EUR 0.35 |
| **Unit Payment Fee** | Payment-processing fee per unit (if applicable) | EUR 0.10 |
| **Unit Customs Cost** | Import duties / customs per unit | EUR 0.20 |
| **Unit Additional Cost** | Any other per-unit cost (inspection, prep, etc.) | EUR 0.15 |
| **Arrival Date** | Date the inventory was received | 2026-03-15 |
| **Currency** | Currency of the purchase prices | EUR |
> **Batch names** are unique within a product and are how you tell purchase lots apart (e.g. "Q2 Main Reorder" vs. "Q3 Restock"). Reusing an existing name for the same SKU updates that lot rather than creating a second one.
4. *(Optional)* Tick **"Apply these costs to past unlinked orders"** - see below.
5. Click **"Create"** to save the batch.
6. The batch appears in the list, and COG 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 COG and lets you see how procurement cost changes affect your margins over time.
{% endhint %}
### Applying a Batch to Past Orders
By default a new batch only covers orders going forward (via FIFO). If you are entering a batch for inventory you have **already been selling**, tick **"Apply these costs to past unlinked orders"** in the create form. SellerMagnet then:
* Applies the batch's per-unit costs to **every past order item that does not yet have a batch attached**, and
* **Auto-expands the batch capacity** so it covers all those linked past orders.
A confirmation dialog ("Apply costs to historical orders?") spells out the scope (SKU, "All past orders without a batch") and warns that it **recomputes historical Profit, Margin, and ROI** for that SKU.
{% hint style="info" %}
This action is **reversible**: deleting the batch from the Manage Batches modal undoes the historical changes. It is the fastest way to back-fill COG for a SKU you started selling before you began tracking batches.
{% endhint %}
### Returns Back to Stock
The batch modal header has an **"Add returns back"** toggle. When **on**, units that customers return are added back to this product's **batch** stock (so the same per-unit cost is re-used for future sales of those units). Leave it off if returns are not resold. The account-wide default for this is set in **Settings > General → Default returns sellable**.
### Editing a Batch
1. Click the **edit button** on an existing batch in the sidebar.
2. Modify any field (total units, per-unit costs, arrival date, or currency).
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 asking you to confirm the deletion.
3. Click **"Delete"** to confirm.
{% hint style="danger" %}
Deleting a batch removes its COG 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 %}
***
## Inventory Rules
Inventory Rules let you configure automatic email notifications when stock levels reach critical thresholds, and an optional auto-restock behaviour.
### Accessing Inventory Rules
Click the **Inventory Rules** button (box icon) in the **top toolbar** of the Products page. The *Inventory Rules & Notifications* modal opens.
{% hint style="info" %}
These rules are **account-wide** - they are **not** scoped per marketplace. There is no marketplace selector in this modal.
{% endhint %}
### Configurable Rules
| Rule | Description | Recommended Setting |
| -------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------- |
| **Notify when product is Out of Stock** | Sends an email when a product's stock reaches zero | Enable for all products |
| **Notify when stock is below:** | Sends an email when stock drops below a threshold. Pick **5**, **10**, **20**, or a **Custom** value | Set to your average 14-day sales volume |
| **Automatically Restock Inventory** (Auto Restock) | When stock hits 0, automatically raises the stock level by a **Restock Amount** so the listing stays available on Amazon. Includes an **exclusion list** to leave discontinued products out | Set an amount that covers your supplier lead time; exclude discontinued SKUs |
{% hint style="info" %}
Auto Restock is not a low-stock reorder-point alert - it maintains availability by topping stock back up when it reaches zero. Use the **exclusion list** ("Exclude specific products") so discontinued items are never auto-restocked.
{% endhint %}
### Setting Up a Rule
1. Open the **Inventory Rules** modal from the toolbar.
2. Toggle each rule **on/off**.
3. For **low inventory**, set the **Threshold** (5 / 10 / 20 / Custom).
4. For **Auto Restock**, enter a **Restock Amount** and add any products to the **exclusion list**.
5. Click **Save Settings** to activate.
{% hint style="info" %}
Inventory alerts are delivered by email. Make sure your notification preferences are configured in **Settings > Notifications** so you receive them.
{% endhint %}
***
## Shipping Rates (FBM)
For FBM products, outbound delivery cost belongs in your profit. Assign a **shipping rule** to a product so that cost is included. Open the shipping-rate modal from a product's **⋮** menu (**Select Shipping Rate**) or via the bulk **Shipping rate** action. The modal has two tabs:
* **Apply one rule** - pick a single shipping rule (from those you created under **Settings → Shipping Rules**) and save it to the selected product(s).
* **Bulk map via CSV** - **Download current mapping (CSV)** of your FBM products, edit the **`new_rule`** column in a spreadsheet, then **Upload edited CSV** to preview and apply. Rules are matched by name; leave `new_rule` unchanged or empty to keep the current rule, or enter **REMOVE** to unassign the rule from a SKU. A preview shows exactly which SKUs will be assigned, changed, cleared, or left unchanged before anything is saved.
{% hint style="info" %}
Create the shipping rules themselves under **Settings → Shipping Rules**. If no rules exist, the modal tells you so and links you there.
{% endhint %}
***
## Tags
Use the bulk **Assign tags** action (visible when you select products) to tag many SKUs at once. Tags can then be used to **filter** the catalog and to slice performance elsewhere in SellerMagnet.
***
## 🎯 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** (⋮ -> Manage Batches) 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 | Open **Inventory Rules** from the toolbar: enable Out-of-Stock and set the low-inventory threshold |
| 5 | After 2 weeks, open **⋮ -> Open in Inventory Planner** to see daily usage trends and the projected stockout date |
| 6 | If daily usage is 15 units/day and supplier lead time is 30 days, plan 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 COG).
***
## 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, COG is allocated from the earliest batch first. Once Batch 1's 500 units are depleted, COG automatically shift to Batch 2's price. This same batch stock is what the **Inventory Planner** uses to project depletion.
{% hint style="warning" %}
If you delete an earlier batch, the COG 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 %}
***
⚠️ Common Mistakes to Avoid
| Mistake | Impact | Better Approach |
| ----------------------------------- | ---------------------------------------------------------- | -------------------------------------------------------------------------- |
| Not entering any cost for a product | All profit numbers are wrong across the entire platform | Add a batch (or an easy-mode flat cost) as part of your receiving workflow |
| Using one batch for all inventory | Cannot track price changes or calculate accurate FIFO COG | Create a new batch for each purchase order |
| Entering COG in the wrong currency | Over/understated costs | Always enter prices in the correct purchase currency |
| Ignoring the Inventory Planner | Running out of stock leads to lost sales and ranking drops | Check the planner 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 COG records | Edit the batch instead of deleting and recreating |
## ✅ Best Practices
1. **Enter costs 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 COG reflects true landed cost.
3. **Name each batch clearly** (e.g. supplier + reorder, "ACME Q2 Reorder") so purchase lots stay easy to tell apart.
4. **Review the Inventory Planner weekly** for your top 20 revenue-generating products.
5. **Set inventory rules** for every product with meaningful sales velocity, and exclude discontinued SKUs from Auto Restock.
6. **Audit COG quarterly** by comparing your batch records against supplier invoices.
***
## Exporting Products
The **Export** button (download icon) in the table toolbar downloads your catalog for use in spreadsheets or for editing and re-importing. Click it to choose a format:
| Format | Use it for |
| --------- | ----------------------------------------------------------------- |
| **CSV** | Editing in any spreadsheet tool, or preparing a file to re-import |
| **Excel** | A ready-to-open `.xlsx` workbook |
* If **no products are selected**, the export covers your **whole catalog** (respecting the current view).
* If you have **selected rows** with the checkboxes, a small dialog asks whether to export **all products** or **only the selected ones**.
{% hint style="info" %}
The export uses the **same column layout as the import template**, so the fastest way to bulk-edit COG is: export -> edit the cost columns in a spreadsheet -> re-import.
{% endhint %}
***
## Bulk Import (CSV)
Instead of entering batches one product at a time, you can update many SKUs at once with the **Import** button (upload icon) in the toolbar. It opens a guided **3-step wizard**.
{% stepper %}
{% step %}
### Upload
Drop a **CSV file** onto the upload area (or click to browse). Two helpers sit above it:
* **Download Template** - a blank CSV with the correct headers.
* **Export Current Products** - exports your existing catalog so you can edit real values and re-upload.
The wizard lists the **expected headers**. Products are matched by **`sku` + `amazon_marketplace`**, and the file can carry the latest batch and shipping data per SKU:
| Column | Meaning |
| ------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------- |
| `sku` | Your seller SKU (required for matching) |
| `amazon_marketplace` | Marketplace the SKU belongs to (required for matching) |
| `returns_sellable` | Whether returns go back into sellable stock |
| `shipping_country_pricing_net_cost_in_cents` / `shipping_currency` | Per-unit shipping cost and its currency |
| `latest_batch_name` | Name of the batch to create/update |
| `latest_batch_total_units` | Units in the batch |
| `latest_batch_unit_net_cost_in_cents` | Net cost per unit (in **whole cents**, e.g. `475` = 4.75) |
| `latest_batch_unit_tax_cost_in_cents` | Tax per unit (cents) |
| `latest_batch_unit_shipping_cost_in_cents` | Inbound shipping per unit (cents) |
| `latest_batch_unit_payment_cost_in_cents` | Payment fee per unit (cents) |
| `latest_batch_unit_customs_cost_in_cents` | Customs/duty per unit (cents) |
| `latest_batch_unit_additional_cost_in_cents` | Any other per-unit cost (cents) |
| `latest_batch_currency` | Currency of the batch costs |
| `latest_batch_arrival_date` | Date the inventory arrived |
| `simple_unit_cost_in_cents` | *Optional.* Sets an **Easy-mode flat cost per unit** (whole cents, e.g. `800` = 8.00) that overrides inventory batches for that SKU |
| `simple_cost_currency` | *Optional.* Currency for the flat cost; defaults to the marketplace currency |
{% hint style="warning" %}
The `simple_unit_cost_in_cents` / `simple_cost_currency` columns only apply on accounts where **Easy mode** is enabled. All cost columns are in **whole cents**, not decimal currency - enter `800` for a cost of 8.00. Make sure your date format matches the format shown in the wizard.
{% endhint %}
{% endstep %}
{% step %}
### Validation
Every row is checked and tagged **Valid**, **Warning**, or **Error**. From this screen you can:
* Filter to **Errors**, **Warnings**, or **Valid** rows.
* **Edit** cells inline, or **bulk-edit** a value across selected rows.
* **Delete** rows you do not want to import.
* **Export error rows** to fix them in a spreadsheet and re-upload.
{% endstep %}
{% step %}
### Import
A final review shows totals (ready to import, warnings, errors that will be skipped) and a marketplace breakdown. Confirm to apply the changes.
{% endstep %}
{% endstepper %}
{% hint style="info" %}
Import **updates existing products** (matched by SKU + marketplace) with new batch, flat-cost, and shipping data. It does **not create new products** - listings appear in SellerMagnet automatically once they are live on Amazon.
{% endhint %}
### Loading several batches for the same product
You are not limited to one batch per SKU. To import **multiple purchase lots for the same product in a single file, add one row per batch**: repeat the same `sku` + `amazon_marketplace` on each row and give every row a **different `latest_batch_name`** with its own units, costs, and arrival date. Each unique batch name becomes its own lot, so a SKU with three restocks is simply three rows.
{% hint style="warning" %}
Two details matter when you do this:
* **The batch name is the key.** Reusing an existing `latest_batch_name` for a SKU **updates that lot** instead of adding a new one. Leaving the name blank falls back to a default (`SM Batch `), so several blank-named rows on the same day collapse into one lot - always give each batch a distinct name when loading more than one.
* **Expect a duplicate warning.** The Validation step tags repeated `sku` + `amazon_marketplace` rows with a **"Duplicate SKU + Marketplace"** warning. When you are intentionally loading several batches this is expected - it is a heads-up, not an error, and the rows still import.
{% endhint %}
***
## 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/COG management** | Yes (primary purpose) | No (read-only COG display) |
| **Inventory Rules** | Yes | No |
| **Tag filtering** | Yes | Yes |
| **Financial breakdown** | Basic P\&L per product | Detailed per-order breakdown |
***
## ❓ FAQ
How does SellerMagnet calculate COG 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?
Yes. Use the **Import** button in the products toolbar to run the **3-step CSV wizard** (Upload -> Validation -> Import). Download the template (or export your current products), fill in the batch and cost columns, and re-upload. On accounts with Easy mode, you can also set a flat cost per SKU via the optional `simple_unit_cost_in_cents` column. To load **several batches for one SKU**, add one row per batch with the same SKU + marketplace and a different `latest_batch_name` - see [Loading several batches for the same product](#loading-several-batches-for-the-same-product). Products are matched by SKU + marketplace and updated in place; import does not create new products.
What if I sell the same product on multiple marketplaces?
Create batches at the product level (per SKU). The batch data applies to that SKU. Inventory Rules are account-wide, not per marketplace.
Where did the Stock Forecast go?
Stock forecasting now lives on its own **Inventory Planner** page rather than inside the batch modal. Open it from a product's **⋮ Manage** menu -> **Open in Inventory Planner** to see the projected stockout date, daily usage, and reorder timing. It uses a rolling average of daily sales, so accuracy depends on how consistent your sales are.
Can I set different alert thresholds per marketplace?
No. Inventory Rules are configured once and apply account-wide - the rules modal does not scope thresholds by marketplace.
What happens if I forget to add a cost for a product?
The product will show EUR 0.00 for COG (and a **No COG** badge), which means all revenue minus Amazon fees appears as "profit." This overstates your actual profitability. We recommend adding a batch or an easy-mode flat cost for all products.
Does the stock level update in real time?
The **Stock** column 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. (**Batch stock** is separate - it reflects the units still covered by the cost batches you entered.)
***
## ➡️ 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 %}