Inventory

What is this page?

The Inventory page is where you manage the cost of your products. Setting accurate Cost of Goods Sold (COGS) is essential for calculating profit metrics like Gross Profit, Operating Profit, Margin, and ROI across all Dashboardly pages. You can set costs at the product level (recommended) or per individual SKU, import costs in bulk, or use FIFO (First In, First Out) tracking for precise cost accounting.

Key Metrics on This Page

Summary Widgets

Configurable metric cards at the top show aggregate inventory and sales metrics. Click "Configure Metrics" to choose which metrics to display.

Unit Cost (COGS per unit)

• What it shows: The cost you pay for one unit of a product.
• Important: This is the foundation for all profit calculations. If not set, COGS defaults to $0 and Gross Profit will equal Net Sales.

Landed Cost

• What it shows: The full cost of getting a product to your warehouse, including additional expenses beyond the base product cost.
• Formula: Unit COGS + Inventory Shipping + Customs Duty + Import VAT
• Important: If you only set the base unit cost, Landed Cost equals COGS. Add shipping, customs, and VAT for a more accurate total cost.

Cost of Goods Sold (Total)

• What it shows: Total cost of all units sold in the selected period.
• Formula: Unit Cost x Units Sold
• Important: COGS for cancelled orders is handled carefully. If a product was shipped but the order was later cancelled without a return, the COGS is still counted because you lost that inventory.

Features

Table Columns Overview

The inventory table displays a rich set of data columns organized into categories. Not all columns are visible by default -- expand column groups by clicking the column header to reveal additional detail.

• Cost columns: Unit COG, FBS Shipping Default, Total COG (Unit COG x Total Stock), Landed Cost components (Shipping, Customs, Import VAT)
• Stock columns: Available Stock (with Campaign, Creator, and In Shop breakdown), Total Stock (Available + Reserved), FBT Stock, FBS Stock
• Performance columns: Estimated Sales, Estimated Profit, ROI, Units Sold (30 and 90 days), Daily Average Units (30 and 90 days)
• Planning columns: Days of Inventory Remaining (estimated days until stockout based on your recent sales velocity), Size Tier, Manufacturer

Editable columns (Unit COG, FBS Shipping Default, FBS Storage and Fulfillment fees) are highlighted with a green background. Click any editable cell to update the value directly.

Product-First Layout

The Inventory page shows products as expandable rows with their SKUs (variants) nested underneath. This makes it easy to manage costs at the product level and drill into individual SKUs when needed.

• Expand a product to see all of its SKUs listed below it.
• Click any product name to go directly to that product's detail page.
• Click a SKU to navigate to the product detail page with that specific SKU pre-selected.

Each row displays key information at a glance:

• Product name and image -- pulled from your TikTok Shop listing
• Unit Cost -- your editable cost per unit (set at the product level or per SKU)
• FBS Shipping Default -- optional default shipping cost for Fulfilled by Seller orders
• Landed Cost components -- Inventory Shipping, Customs Duty, Import VAT
• Sales metrics -- Units sold, revenue, and profit for context
• Status indicator -- shows whether a product is Active, Draft, or Deleted on TikTok

Product-Level Cost of Goods (COGS)

You can now set a default Unit COG at the product level. This default automatically applies to all SKUs under that product, so you do not need to enter the same cost on every variant.

• Inherited from product: The SKU uses the product-level default. This is shown as the COG source.
• Manually set on SKU: You can override the product default for any individual SKU that costs differently. The SKU-level value takes priority.
• Not set: No cost has been entered at either level. COGS defaults to $0.

Recommended workflow: Set the cost once at the product level. Only override at the SKU level when a specific variant costs more or less to produce.

FBS Shipping Cost Default

A dedicated column lets you set a default shipping cost per unit at the product level. This applies to FBS (Fulfilled by Seller) orders when TikTok does not provide shipping data.

• If TikTok's API returns a shipping cost for an order, that value is always used first.
• The FBS default is only applied when no TikTok shipping data exists for the order.
• This is especially useful for sellers who ship orders themselves and want shipping costs reflected in their profit calculations without waiting for settlement data.

Inline Cost Editing

Click on any cost cell to edit it directly in the table. Changes are saved immediately and will be reflected across all pages (Dashboard, Sales & Profit, Profit & Loss) on your next data load.

Active or Sold Filter

Filter the table to show only products that are currently active on TikTok Shop or have had at least one sale. This hides Draft, Deleted, and never-sold products to keep your view focused. The filter is now instant for all shop sizes, including shops with thousands of products. You can also switch to "Active only" or "All products" views.

Without COGS Filter

Toggle this filter to show only products that have no COGS set (unit cost is empty or zero). This is especially useful when you first connect your shop and need to find products that still need cost data entered.

Search

Search for products by name to quickly find the item you want to update.

Export CSV

Download your full inventory data as a CSV file with the current filters and sort applied. Useful for offline analysis or sharing with your team.

Cost Import

Import costs in bulk using a spreadsheet:

1. Click the import button to download a template
2. Fill in your unit costs, shipping costs, customs duties, and import VAT per product
3. Upload the completed file to update all costs at once

This is especially useful when you have many products or when you receive a new shipment with updated costs.

Cost History

View the history of cost changes for any product. Each time you update a cost, the previous value is recorded with a timestamp. This helps you track how your costs have changed over time.

FIFO Tracking

For sellers who purchase inventory at different prices over time, FIFO (First In, First Out) tracking assigns the cost of each unit sold based on the order in which inventory was purchased:

• Record each inventory purchase with its quantity and unit cost
• When units sell, the oldest purchase cost is used first
• This provides the most accurate COGS when your purchase prices vary

Bulk Cost Update

Select multiple products and update their costs simultaneously. Useful for applying the same cost change across a product line.

Cost Comparison

Compare your current costs against previous periods to understand how input costs are trending.

Days of Inventory Remaining

This column estimates how many days your current stock will last based on your recent sales velocity. It helps you plan reorders before running out of stock. If a product has no recent sales data, this value will not display.

Configure Metrics

Click the "Configure Metrics" button to choose which summary metric cards appear at the top of the page.

Common Questions

Why is my Gross Profit the same as Net Sales?

You have not set the Cost of Goods Sold (COGS) for your products. Go to any product row and enter the unit cost. Once set, Gross Profit will correctly subtract COGS from Net Sales.

Do I need to set COGS for every product?

For accurate profit calculations, yes. Any product without a COGS value will show $0 cost, making its Gross Profit equal to its Net Sales. The fastest approach is to set cost at the product level -- this automatically covers all SKUs under that product. You can also use the cost import feature to set costs for many products at once.

When should I use FIFO tracking?

Use FIFO if you buy inventory at different prices over time (e.g., your supplier raised prices, or you sourced from different suppliers). FIFO ensures each sale is matched to the correct purchase cost. If your unit cost is consistent, a simple flat unit cost is sufficient.

What happens when I change a product's cost?

The new cost applies to all future calculations. Historical data will reflect the cost that was set at the time. Cost changes are logged in the cost history so you can always see what the cost was at any point in time. If you change the product-level cost, all SKUs that inherit from that product will update automatically. SKUs with their own manual override are not affected.

Does COGS count for cancelled or refunded orders?

It depends on the situation. If a product was shipped but the order was cancelled without a return (the customer kept the product), COGS is still counted because you lost that inventory. If the product was returned to you, COGS is not counted. Orders cancelled before shipment do not incur COGS.