COGS Bulk Upload Summary

This guide provides an overview of managing Cost of Goods Sold (COGS) data in bulk within SellerLegend, spanning the complete workflow from retrieval to verification.

Step 1: Download Current Data

Navigate to Products and Inventory > Products List, then select Import/Export to retrieve existing COGS information. Two export formats are available:

• COST_OF_GOODS_SIMPLE_VIEW_FORMAT — for basic data
• COST_OF_GOODS_DETAILED_VIEW_FORMAT — for comprehensive details including currency and notes

Step 2: Update the Spreadsheet

The downloaded Excel file can be edited to modify existing cost periods or add new entries. Critical requirements:

• Match SKU spelling exactly
• Use YYYY-MM-DD date formatting exclusively
• Avoid formulas — use static values only
• Simple View requires SKU, Start Date, End Date (optional), and Unit Cost columns

Step 3: Upload Changes

Submit the updated file through the Upload tab via file browsing or drag-and-drop functionality, with marketplace selection if necessary.

Step 4: Review Results

SellerLegend provides feedback showing one of three statuses:

• DONE — upload successful with no errors
• DONE_WITH_WARNINGS — partial upload with row-level issues
• FAILED — complete rejection requiring format review

Row-by-row feedback identifies issues such as invalid SKUs, overlapping date periods, or formatting errors.

Step 5: Correct and Resubmit

Failed rows are corrected and the file is re-uploaded until all data passes validation.

Step 6: Confirm Success

Verify updates by editing a product and checking the Cost of Goods section displays new periods with correct values. Profit calculations in reporting sections confirm proper application.

For detailed procedural information on the bulk upload process, see the COGS Bulk Upload Details page.