How COGS Work in MRP
COGS (Cost of Goods Sold) represents your landed product cost per unit — this includes the product cost, shipping to Amazon, duties, and any prep fees. Once entered, MRP subtracts COGS from revenue to calculate your true profit per ASIN. COGS are entered by date range, so you can update them whenever your costs change.
How to Upload COGS
1. Go to Products & COGS in the left sidebar.
2. Click Export (top right) to download your current COGS file. Always start from the export — never from a blank sheet.
3. Open the exported CSV. Edit only the columns listed below — do not modify PARENT, CHILD, SKU, TITLE, or STATUS.
Column | What it is | Should you edit it? |
PARENT | Parent ASIN | ❌ Do not edit |
CHILD | Child ASIN | ❌ Do not edit |
SKU | Product SKU | ❌ Do not edit |
TITLE | Product name | ❌ Do not edit |
STATUS | Active / Inactive | ❌ Do not edit |
PRODUCT COST | Your landed cost per unit | ✅ Edit this |
START DAY / START MONTH / START YEAR | When this cost takes effect | ✅ Edit this |
END DAY / END MONTH / END YEAR | When this cost expires (optional) | ✅ Edit if needed |
4. Enter your cost in the PRODUCT COST column as a plain number with no currency symbols (e.g., 3.45, not $3.45).
5. Set the Start Date using the three START columns (START DAY, START MONTH, START YEAR). By default, the export pre-fills today's date — if you don't change it, the COGS will only apply to orders from today onward. To apply costs historically, set the Start Date to the earliest date you want reflected.
6. Set the End Date (END DAY / END MONTH / END YEAR) only if this cost expires on a specific date. See the date logic table below.
Start Date | End Date | Result |
✅ Filled | ☐ Blank | ✅ Cost applies from that date forward, including all future orders |
✅ Filled | ✅ Filled | Cost applies only within that date range — will not apply to new orders after End Date |
☐ Blank | ☐ Blank | Cost applies across all historical periods |
7. Check for duplicate SKUs — the same SKU should not appear more than once in the file. This is the #1 cause of failed uploads.
8. Save the file as Comma Separated Values (.csv) — not .xlsx or .xls.
9. Click Import to upload. You'll see a confirmation message when successful. If there's an error, the system will display the specific reason.
COGS Are Date-Specific
COGS apply from the Start Date you specify. They do not backfill automatically — you must explicitly set the date range. To update historical data, set the Start Date in your file to the earliest date you want the cost reflected.
COGS Currency by Marketplace
Upload COGS in the local currency of the marketplace. For Mexico (MX), use MXN. For EU marketplaces, use EUR. Mixing currencies in a single file causes incorrect profit calculations.
Still Failing?
Contact the MRP support team with: seller account name, marketplace, and the specific error message shown after the upload attempt.