COGS Bulk Upload Details

SellerLegend enables bulk management of Cost of Goods Sold (COGS) for products using Excel spreadsheets in two formats: Simple View (for basic cost tracking) and Detailed View (for granular cost components like manufacturing, packaging, and shipping).

The Bulk COGS Management Workflow

1. Select the Marketplace — Choose your Amazon marketplace
2. Download the COGS Template — Use Import/Export in Product List to get the Excel template
3. Update COGS in Excel — Enter cost values, dates, and cost elements
4. Upload the Updated File — Re-upload via Import/Export panel
5. Check for Errors — Review results in Imported Reports screen
6. Repeat if Needed — Fix errors and reupload until status shows DONE

Downloading the COGS Template

Navigate to Products & Inventory > Product List, then click the Import/Export button. Under EXPORT, select your preferred format:

• COST_OF_GOODS_SIMPLE_VIEW_FORMAT
• COST_OF_GOODS_DETAILED_VIEW_FORMAT

Select your Amazon account and optionally exclude hidden/ignored products. Click Export to generate the file.

Retrieving Your File

If you miss the download prompt, go to Reports > Exported Reports and locate your export request. Wait for status to show DONE (may take up to 20 minutes), then download from the Actions menu.

Updating COGS in Simple View Format

The Simple View Excel includes these columns:

Field	Header	Required	Example
Product SKU	Product Sku	Yes	BackApplicator
ASIN	Asin	Optional	B00MNNKXYZ
Parent ASIN	Parent Asin	Optional	B08KLMMRBD
Internal Name	Internal Name	No (reference only)	Large Applicator
Product Title	Title	No (reference only)	Large Back Applicator, Adult Size
From Date	From Date	Yes	2023-01-01
To Date	To Date	Optional	2023-06-30
Total Cost Per Unit	Total Cost Per Unit	Optional (auto-calculated)	2.80
Cost Elements	Column headers I-ZZ	Yes (at least one)	Manufacturing, Shipping

Important: Do not manually enter values in the Total Cost Per Unit column — it auto-calculates from cost elements.

Entering COGS Values

• Columns A-C and E auto-populate with product data
• Column D populates only if you've assigned an internal nickname
• Define cost periods using From Date and To Date
• Start cost entries from Column I onward (e.g., Manufacturing, Inspection Fees)
• Column H automatically sums all cost elements

Adding Multiple Cost Periods

Copy Row 2 downward to create additional periods. Each row with the same SKU/ASIN represents a different cost period. Adjust the From Date, To Date, and cost values for each period. Periods need not be in chronological order.

Updating COGS in Detailed View Format

The Detailed View includes additional fields for tracking supplier information, notes, currency, and exchange rates:

Field	Header	Required	Example
Product SKU	product_sku	Yes	Back Applicator (Large)
Cost Element Name	cost_element	Yes	Shipping
Provider	provider	No	DHL
Notes	notes	No	https://myinvoice.eu
Total Amount Paid	total_amount	Yes	410.26
Currency	currency	Optional	USD
Conversion Rate	conversion_rate	If non-marketplace currency	1.12
Units	units	Optional	200
Amount Per Unit	amount_per_unit	Computed (do not override)	2.00

Each row represents a cost element for a specific cost period. Rows with the same SKU and date range bundle into one cost period.

Re-Uploading Modified COGS Files

1. Navigate to Products & Inventory > Product List
2. Click Import/Export
3. In the IMPORT section, select your format (Simple or Detailed)
4. Choose your account and select the updated Excel file
5. Click Import

Correcting Errors

Go to Reports > Imported Reports and check the STATUS column:

• DONE — Upload successful with no errors
• DONE_WITH_WARNINGS — Some rows contain errors (download error file to review)
• FAILED — Invalid format or file exceeds 10,000-row limit

When reviewing error files, green rows indicate valid definitions, while grey rows with red comment ticks show errors. Hover over the red tick to see error details.

File Handling Rules

• Do not change column order or headers
• File must have only one tab
• No formulas allowed (use static values only)
• Dates must be formatted as yyyy-mm-dd
• Header row must contain exact column titles
• Products without COGS display with a value of 0
• Downloaded/uploaded files are retained for 30 days
• In Detailed View, each row represents a cost element for a cost period

Common Error Causes

• End dates earlier than start dates
• Dates not in yyyy-mm-dd format
• Number of units = 0
• SKU not found in SellerLegend
• Spreadsheet with multiple tabs
• Formulas present (only static values allowed)
• File exceeds 10,000 rows

Tips and Best Practices

• COGS can apply to past and future periods
• Upload COGS per marketplace (see EU propagation documentation)
• Enter values in marketplace currency
• Split large datasets into multiple uploads (max 10,000 rows each)
• Switch between Simple and Detailed formats without data loss

Critical Warning

• If you enter a Parent ASIN (omitting SKU and Child ASIN), the update propagates to all child ASINs
• If you upload only new cost period rows without previous ones, all prior periods are deleted for that product (this cannot be undone)

Upload Behavior

When uploading multiple cost periods, SellerLegend will retroactively adjust all historical orders to reflect the correct COGS for each order date. The system evaluates all orders since marketplace start and adjusts accordingly. Propagation typically takes up to 30 minutes for large product/order volumes.