Products — Overview & Management
This section explains the Products area in SellerMagnet and how to manage every product from one place: variants, batches/COGS, shipping rates, stock forecasting, and listing performance.
Quick Preview
One searchable table for all products across marketplaces.
Per–row actions menu to manage: Batches, Shipping Rate, Stock Forecast, Open in Sourcer, Listing Performance.
Built‑in export/import tools and filters for “active only” and marketplace.
Variant support: collapse/expand child ASINs directly in the table.
Page Anatomy
Top bar
Search by title, SKU, or ASIN.
Export products / Import products buttons.
Marketplace selector and active filter.
Columns (most relevant)
Fulfillment (FBA/FBM), Condition, Status (Active/Inactive).
Listing Price (current live price).
Batch stock (units from batches), COG Avg. (average unit cost from batches), Amazon stock (live FBA/FBM stock).
Manage product: three‑dot menu with operational tools.
Variants (children)
Rows with a caret ▸ allow expanding marketplace variations. Child ASINs inherit marketplace flags and show their own metrics.
Amazon Stock vs Batch Stock (Reconciliation)
Amazon stock is the live quantity that Amazon shows for your offer in Seller Central (FBA or FBM). Batch stock is the sum of quantities you have recorded across all open batches for that product. Keeping these two aligned enables:
Real‑time stock valuation (Amazon stock × COG Avg.).
Accurate profit reporting that includes write‑offs and returns.
Early detection of inbound/receiving issues.
How to reconcile
In the Products table, compare Amazon stock with Batch stock.
If Amazon stock > Batch stock: add a New batch (e.g., a receipt Amazon already counted) or increase units in the most recent batch.
If Amazon stock < Batch stock: create an adjustment in the batch (e.g., damages, unfulfillable write‑off) or disable "Add returns back to batch" for non‑sellable returns.
Recheck COG Avg. and the profit in the Repricer/Reports after the fix.
When a return is restockable, keep Add returns back to batch enabled so the unit goes back into the last batch at the original cost. For non‑restockable returns, log them as write‑offs so COGS stay realistic.
Bulk Export & Import
Use Export products to download the filtered view of your catalog for auditing and bulk updates. The CSV includes key columns such as: SKU, ASIN, Title, Fulfillment, Status, Listing price, Batch stock, COG Avg., Amazon stock, plus marketplace flags.
Typical workflows
Cost audit: export, verify COG Avg. vs purchase records, adjust batches where needed.
Ops review: export stock for a single marketplace to plan reorders.
Data cleanup: normalize titles/SKUs offline, then re‑import.
Import products (CSV)
Click Import products and upload a UTF‑8 CSV that follows the exported header.
The validator highlights unknown columns and malformed values before anything is changed.
Confirm to apply. Only rows with differences are updated.
Always keep dates in ISO format (YYYY‑MM‑DD) and decimals with a dot. If you maintain costs in an external ERP, export from SellerMagnet first and use the same header to avoid mapping errors on re‑import.
Subpage A — Manage Batches (COGS)
Batches, or Cost of Goods Sold (COGS), represent procurement events and are critical for calculating margins, ROI, and profit in SellerMagnet.
What a Batch Represents
A batch corresponds to a specific shipment or purchase and includes detailed unit costs. Multiple batches can coexist for the same product — SellerMagnet automatically computes the weighted average cost.
Creating or Editing a Batch
Open Manage Product → Manage Batches.
Review existing batches (name, units, unit costs).
Click New Batch and complete the fields below.
Required Fields:
Batch Name: e.g., “June Shipment”.
Total Units: Number of units received.
Unit Net Cost: Cost per unit excluding tax.
Unit Tax Cost: VAT or sales tax (optional).
Unit Shipping Cost: Freight or courier cost per unit.
Unit Payment Fee: Payment processor fees (optional).
Unit Customs or Additional Cost: Duties, packaging, or labeling.
Arrival Date and Currency.
Add Returns to Batch (toggle): When enabled, returned units automatically re-enter the most recent batch.
Reconciliation and Adjustments
Losses or Damaged Units: Decrease the batch quantity to maintain accurate COG values.
Shipments already processed by Amazon: Add a small batch with the same unit cost to align stock data.
Multi-marketplace: Maintain a unified cost history per SKU to prevent fragmented COG data.
Why Detailed Batch Data Matters
Accurate Average COG → realistic margins and profits in Repricer and Reports.
Reliable Stock Valuation → useful for accounting and planning.
Full Traceability → supports audits and internal controls.
Batches determine COG Avg. shown in the Products table and feed profit in the Repricer/Reports. Keep them updated for every procurement.
Subpage B — Select Shipping Rate (FBM)
Map a product to a saved FBM Shipping Rate so the correct outbound cost is used in profitability and repricing.
Steps:
Manage product → Select shipping rate.
Choose a predefined rate and Save.
Subpage C — Stock History & Forecast
Forecast when you will run out of stock based on historical usage.
Top KPIs
Current stock: live FBA/FBM units.
Estimated months remaining: projected sell‑through time.
Average monthly usage: recent average units sold per month.
Chart
Historical stock (blue), Historical sales (black), Forecasted stock (orange dashed).
Hover any point to see the forecast for that date.
Use this to time purchase orders and avoid stockouts.
Subpage E — Listing Performance (per product)
See the performance of a single product over a selected time frame.
Metrics & graph
Total impressions, Total sessions, Total units ordered, Total orders (Revenue).
Interactive timeline plus a daily breakdown table.
Power Tips
Bulk export to spreadsheet, adjust costs or metadata, then import back to update many products at once.
Keep batches consistent across marketplaces when the same SKU is sold in multiple regions.
Use Listing performance to validate the effect of title/image updates or promotions.
Last updated