SellerLegend

Appearance

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.

FIFO products

The COGS import and export files don't cover FIFO costing (beta) yet. Import rows for FIFO products are skipped, and exports list them with their cost periods only. Manage FIFO purchase lots from the product's Cost of Goods window.

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.