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
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 (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.
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.
🎥 Video Walkthrough
🗂️ Page Structure
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
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.
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
Only the four numeric columns - Price, Batch stock, Cost, and Stock - are sortable. Click a header to sort.
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.
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.
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
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
Navigate to Dashboard > Products.
Find the product you want to manage.
Click the ⋮ menu in the Manage column and choose Manage Batches.
The Product Batches modal opens.
Batch Modal Layout
The modal is organized into these sections:
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)
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
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
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:
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
Open the Product Batches modal for your product.
Click the "New Batch" button in the modal sidebar.
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):
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.
(Optional) Tick "Apply these costs to past unlinked orders" - see below.
Click "Create" to save the batch.
The batch appears in the list, and COG 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 COG and lets you see how procurement cost changes affect your margins over time.
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.
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
Click the edit button on an existing batch in the sidebar.
Modify any field (total units, per-unit costs, arrival date, or currency).
Click "Edit" to save changes.
All profit calculations that reference this batch update automatically.
Deleting a Batch
Click the delete button on the batch you want to remove.
A confirmation dialog appears asking you to confirm the deletion.
Click "Delete" to confirm.
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.
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.
Configurable Rules
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
Setting Up a Rule
Open the Inventory Rules modal from the toolbar.
Toggle each rule on/off.
For low inventory, set the Threshold (5 / 10 / 20 / Custom).
For Auto Restock, enter a Restock Amount and add any products to the exclusion list.
Click Save Settings to activate.
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_rulecolumn in a spreadsheet, then Upload edited CSV to preview and apply. Rules are matched by name; leavenew_ruleunchanged 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.
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.
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 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.
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.
✅ Best Practices
Enter costs immediately when inventory is received, not when it starts selling.
Record all cost components per unit: net cost, tax, shipping, payment fees, and customs/import duties. This ensures your COG reflects true landed cost.
Name each batch clearly (e.g. supplier + reorder, "ACME Q2 Reorder") so purchase lots stay easy to tell apart.
Review the Inventory Planner weekly for your top 20 revenue-generating products.
Set inventory rules for every product with meaningful sales velocity, and exclude discontinued SKUs from Auto Restock.
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:
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.
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.
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:
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
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.
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.
Two details matter when you do this:
The batch name is the key. Reusing an existing
latest_batch_namefor a SKU updates that lot instead of adding a new one. Leaving the name blank falls back to a default (SM Batch <date>), 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_marketplacerows 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.
Comparison: Products Table vs. Ordered Products
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
➡️ What's Next?
Product TagsListing PerformanceLast updated