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.
Show only active products toggle to hide inactive listings.
Inventory Rules button to open stock alert settings for your catalog.
Columns (most relevant)
Product: Main product information, including image, title, marketplace flags, identifiers (SKU/ASIN), and BSR indicators.
Fulfillment: FBA/FBM fulfillment type.
Condition, Status: Item condition and whether the product is Active/Inactive in SellerMagnet.
Listing Price: Current live price on Amazon.
Batch stock: Units available from your cost batches.
COG Avg.: Average unit cost calculated from batches.
Amazon stock: Live FBA/FBM stock synced from Amazon.
Manage product: Three-dot menu with operational tools (manage batches, open in Sourcer, listing performance, etc.).
BSR indicators (category rank)
Next to each product title you may see up to two small rank values:
Primary BSR: Main category Best Seller Rank.
Secondary BSR: Subcategory Best Seller Rank, when available.
Color coding shows the direction of change since the last update:
Green: Rank improved (better position, lower BSR number).
Red: Rank declined (worse position, higher BSR number).
Variants (children)
Rows with a caret ▸ let you expand marketplace variations. Child ASINs inherit marketplace flags and show their own price, stock, and rank 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.
Subpage F - Inventory Rules & Notifications
Use Inventory Rules on the Products page to control when SellerMagnet warns you about low stock or out-of-stock items. Notifications are sent by e-mail when the thresholds you define are met.
When you click Inventory Rules, the Inventory Rules & Notifications window opens:
Notify when product is Out of Stock
Toggle ON to receive an e-mail as soon as Amazon stock reaches 0 units for the selected products.
Toggle OFF if you don’t want out-of-stock alerts for these items.
Notify when stock below:
Toggle ON to enable low-stock alerts.
Use the dropdown to choose a threshold:
5 units
10 units
20 units
Custom – lets you set your own value.
When Custom is selected, enter the exact number of units in the input field (for example, 3 if you want to be notified when stock drops below 3 units).
Once configured, SellerMagnet checks the Amazon stock column and triggers an alert when the available quantity goes below your chosen threshold.
Enable Auto Restock
Optional section reserved for automatic restocking workflows.
When available, you’ll be able to turn this ON and define a target level in “Maintain X units” so SellerMagnet can help you keep stock around that quantity (e.g., via reminders or restock suggestions).
Save / Cancel
Click Save to apply the rules to the selected products.
Click Cancel to close the window without changing your inventory alerts.
Inventory Rules are linked to your Inventory Alerts e-mail setting in the Notifications tab: to actually receive messages, make sure Inventory Alerts e-mails are enabled there as well.
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