• Knowledge Base
  • Release Notes
  • Glossary
  • Knowledge Base
  • Release Notes
  • Glossary
Home/KnowledgeBase/COGS/Defining COGS Via The User Interface

Defining COGS Via The User Interface

15 views 0

๐Ÿ’ก TL;DR

In SellerLegend, you define the Cost Of Goods Sold (COGS) by specifying the cost of one unit of a product for a defined period. You can enter costs

  • Manually, one product at a time via the user interface,
  • In bulk, 100’s of products simultaneously via a spreadsheet, and
  • Choose between Simple and Detailed entry modes.

๐ŸŽฏ What Youโ€™ll Learn

  • Where to go to enter COGS

  • How to define a cost period

  • The difference between Simple and Detailed views

  • How to handle multiple cost periods

  • Common use cases & tips


๐Ÿ” Why It Matters

COGS is essential to calculating your true profit in SellerLegend. Without accurate COGS, your Profit & Loss Reports, Dashboards, and financial insights will be off.

SellerLegend uses period-based COGS accounting. This means:

  • For any given product, you can define different unit costs for different time ranges.

  • Your actual product costs (and thus your profit) are based on the cost of goods at the time the product was sold.


๐Ÿงญ Step 1: Navigate to the COGS Editor

  1. Go to the Products and Inventory section via the main menu.

  2. Select Products List.

  3. Locate the product whose cost you want to define.

  4. Click on the kebab menu (three dots on the far left).

  5. Choose Enter Cost Of Goods.

An alternative way to get to the COGS editor is to click on the column COGS for the desired product in Product List

Using either of these 2 methods will land you on the COGS Timeline View.

Please refer to Screen Print below.


๐Ÿงฑ Step 2: Understand the COGS Timeline

The timeline shows:

  • Existing cost periods for the selected product (If any COGS have already been specified).

  • Gaps between periods (which mean โ€œno cost definedโ€).

  • Overlaps (which are not allowed).

  • A choice between Simple View and Detailed View.


โœ๏ธ Step 3: Choose Entry Mode โ€” Simple vs Detailed

Feature Simple View Detailed View
Total Cost Per Unit โœ… Required โœ… Required
Currency โœ… Optional (defaults to marketplace) โœ… Required
Units in Shipment โŒ โœ… Required
Total Paid โŒ โœ… Optional (calculated if omitted)
Exchange Rate โŒ โœ… Optional
Provider/Notes โŒ โœ… Optional

You can switch between views at any time. Your data will persist โ€” no loss of information.


โž• Step 4: Add a Cost Period

  1. Click the + Add New Period button.

  2. In the popup, enter:

    • Start Date (inclusive)

    • End Date (inclusive) โ€” or leave blank for open-ended period

    • Cost per unit

    • Optional: Currency, Exchange Rate, Notes, Provider, Units, Total Paid

  3. Click Save.

โš ๏ธ You cannot have overlapping date periods. SL will warn you if periods conflict.


๐Ÿ” Step 5: Edit or Delete Periods

  • To edit, click the pencil icon on any period row.

  • To delete, click the trash can icon.

    • Deleting a period will recalculate profit retroactively for affected dates.


๐Ÿ“š Examples

Example 1 โ€“ Single Cost Period

  • Product: Garlic Press

  • Start Date: 01-Jan-2024

  • End Date: (blank)

  • Cost Per Unit: $3.75

Example 2 โ€“ Multiple Periods

Period Start End Cost/unit
A 01-Jan-2024 31-May-2024 $3.75
B 01-Jun-2024 $4.25

SL will automatically use:

  • $3.75 for units sold between Janโ€“May.

  • $4.25 from June onward.


Screen Print

Here’s a screen-print of a detailed view, multiple cost-period and multiple cost element per period.

The top cost period is the most current, followed by the previous cost periods in descending chronological order.

The most recent cost period is shown expanded, the old cost periods are shown compressed to one row, that displays the cost period date range and the total for the cost period.

 


๐Ÿ“ˆ What Happens After You Save?

  • SellerLegend immediately starts recalculating all affected reports. It may take up to 15-20 minutes to propagate all COGS for large accounts.

  • COGS are used in:

    • Profit & Loss Report

    • Sales Per Day Per Product

    • Dashboard Profit Widgets

    • Settlement Analysis

  • Calculations apply in the currency of the marketplace, unless otherwise specified in the Detailed View.


๐Ÿ› ๏ธ Need to Do This for Many Products?

โ†’ Use the Bulk Upload method via Excel to define costs for multiple products or multiple cost periods per product at once.


๐Ÿง  Best Practices

    • Use future-dated costs to avoid manual updates when pricing changes.

    • Donโ€™t leave gaps โ€” SL canโ€™t calculate profit for those periods.

    • Switch to Detailed View if your team needs audit trails or vendor tracking.

    • Switch to Simple View for expedited, basic COGS details.
    • Use Excel bulk upload for 10+ products โ€” itโ€™s faster and more scalable (see separate KB).


โ“FAQs

Q: What happens if I donโ€™t define COGS?
A: Your profit numbers will be meaningless. SL will display $0 as cost of goods and overstate your profit.

Q: Can I copy COGS from one EU marketplace to another?
A: Yes, but only in the EU region โ€” and the exchange rate wonโ€™t be automatically adjusted.

Q: Can I see what cost was used for a specific order?
A: Yes. Go to Product Dashboard > Order List to see cost applied per order.

Was this helpful?

Yes  No

No luck finding what you need? Contact Us

  Real-World Examples: Defining COGS with Multiple Elements and Date Ranges

COGS Bulk Upload (Summary – Read This first)  

  • Copyright 2025 SellerLegend Limited. All Rights Reserved.