Data / Import COGS
LO
Import COGS
Cost of Goods Sold — the single most important number for accurate profit reporting. Without it, every margin and profit figure is wrong.
What is COGS and why does it matter?
COGS is what you paid your supplier for each unit — your landed cost. Amazon tells us revenue and fees, but only you know your cost per unit. Without COGS, your profit tiles show "N/A" and every margin calculation is meaningless. Import once, update whenever your costs change.
Dismiss
Bulk Import (CSV / XLSX)
Manual Entry (per SKU)
Download Template
2
Upload File
3
Review & Confirm
CSV Template
Pre-filled with your SKUs
Your 6 active SKUs are already listed. Just add the cost per unit in the COGS column and save.
SKU, ASIN, and product name pre-filled
Opens in Excel, Google Sheets, Numbers
Supports effective date for historical COGS
Excel Template (.xlsx)
Formatted with dropdown helpers
Same data as CSV but with formatting, column validation, and dropdown menus for currency selection.
Column formatting and data validation
Auto-calculated margin preview column
Recommended for large catalogs (50+ SKUs)
Already have your costs in a spreadsheet? Skip the template — just make sure your file has columns named sku or asin and cogs or cost. We'll map the rest automatically.
Template downloaded? Fill in your costs and come back to upload.
Drop your file here
or click to browse your computer
.CSV
.XLSX
.XLS
COGS_Template.csv
12.4 KB
Uploading...
6
SKUs detected
6
New costs
0
Updates
0
Skipped
0
Errors
Reviewing 6 SKUs — edit any cost before importing
Product / SKU Current COGS New COGS Change
COGS imported successfully
Your cost data is now applied to all historical and future orders.
Profit figures across your entire account are now accurate.
6
SKUs updated
30.1%
Avg blended margin
$24,502
Recalculated net profit
View Profits & P&L