Inventory

What This Page Does

Inventory is the cost-management workspace for products and SKU variants. It controls product-level defaults, SKU overrides, dated Unit COG and FBS shipping periods, and FIFO inventory lots used in profit reporting.

The summary cards show configurable catalog, stock, cost, sales, and ROI totals. Cards fill the available width and keep monetary values together on one line. Use Configure Metrics above the cards to choose which totals you see. The table below is product-first: products are parent rows, and products with multiple variants can be expanded to show their SKUs.

Money is displayed in your shop's currency. JPY and other zero-decimal currencies do not show a trailing decimal suffix, while currencies with minor units keep their normal decimal places. This changes presentation only; saved costs and profit calculations are unchanged.

For an active connected shop, Dashboardly makes dated-cost controls available automatically after the initial full import and required cost preparation complete. Inventory checks that readiness each time the page loads; no separate support-side activation is needed. Until the data is ready, period-costing controls stay unavailable to prevent partial cost history from being saved.

Stock and Inventory Value

Stock comes from TikTok's inventory sync. Available Stock is the quantity available to sell; Reserved Stock is committed to orders. Total Stock includes both.

Inventory updates received from TikTok are grouped into a five-minute window before the report refresh is queued. Processing or retries can add time; this is not a promise that every product is checked every five minutes. TikTok's low-stock alerts do not cover every restock. The daily catalog sync also requests current inventory for active listings as a fallback when an inventory alert is not received.

Unit COG is a per-unit cost. Total COG (Inventory Cost) values the stock currently held, so having Unit COG set does not by itself establish an inventory value when stock data is missing or zero. This is separate from Profit & Loss COGS, which applies costs to sales in the selected reporting period.

If TikTok shows stock but Inventory does not, the stock sync needs verification. Changing Unit COG is not a correction for missing stock.

When reporting a difference, include the product name or SKU and the available quantity shown in TikTok Shop so support can compare the same item.

Product and SKU Rows

• Set a product default when all variants share the same cost.
• Expand a product and set a SKU override when one variant costs differently.
• SKU-level dated periods take priority over product-level periods for that variant.
• Mixed on a product row means there is no product default, but one or more SKUs have individual costs. A flag beside a product value means some SKUs override that value.
• Seller SKU is the primary identifier on variant rows; product name and TikTok Product ID provide context.

Clicking a product or SKU opens its detail page. On Product Overview, Manage Unit COG follows the selected scope: a specific SKU tab manages that SKU override, while All SKUs manages the product default for current and future SKUs, even if the product currently has only one SKU.

If TikTok deactivates or removes a listing after it has already sold, Dashboardly keeps that sold product available for historical cost work. You can still open its Product Overview and use Manage Unit COG. A removed product with no recorded sales stays hidden because it has no historical profit to correct.

Main Controls

Unit COG

The direct cost of one sold unit. The cost manager shows the current effective value and every earlier or scheduled period. Each period begins on its Effective Date and remains active until the next period starts.

Select All history when one value should cover every historical sale. Dashboardly automatically uses the first qualifying shop-local sale date for the selected product or SKU. Unpaid, on-hold, and cancelled-before-shipment orders are excluded. Any later dated periods remain unchanged.

If there is no qualifying sale yet, choose Immediate to start the value today. Immediate creates a dated cost period starting on today's date in the shop's timezone. Use Custom date for another start date, or All history when the value should also cover earlier sales. When FIFO costing applies, a priced shipment lot remains higher priority than the dated period.

Product and SKU histories are intentionally separate. A product period is the fallback for every current and future SKU. A SKU period remains a higher-priority override for only that SKU, so a child SKU can show a cost while the product row shows Mixed. At product scope, All history searches for the first qualifying sale across every current or historical SKU that belongs to that product.

Shipping Cost / Unit

The dated outbound FBS cost used when TikTok does not provide an authoritative order shipping value. It is separate from Unit COG, TikTok fees, FBT fulfillment charges, and inbound FIFO freight.

The Inventory table and a newly downloaded Export CSV show the value effective today in the shop's timezone, including an explicitly configured zero. Historical profit uses the value applicable to the order date, so compare a past sample against its dated cost history rather than an older Inventory export.

TikTok Shipping Amount

The read-only TikTok Shipping Amount column shows historical shipping-related amounts reported by TikTok for orders containing that product or SKU. Inventory calculates it from its rolling transaction window, which includes up to the last 365 days. Expand the column to see the FBT and FBS TikTok amounts separately.

This is not the editable Shipping Cost / Unit value and it is not your manual carrier cost. An FBS row can still have a TikTok Shipping Amount because TikTok settlement activity can include shipping charges, offsets, discounts, and subsidies even when you fulfill the parcel yourself. Your configured FBS per-order or per-unit cost is resolved separately for Profit & Loss. A specific per-order value takes priority over the per-unit fallback rather than being added on top of it.

Units per bundle

For a multipack SKU, Units per bundle is the number of physical pieces in one transactional TikTok unit. Dashboardly normally reads TikTok's bundle composition. Set a SKU override when the listing metadata does not match what the warehouse ships; entering 1 explicitly treats the SKU as a single piece.

Saving or clearing the override immediately recalculates historical Pieces for that SKU and refreshes its 30-day and 90-day physical-unit velocity. Transactional Units, revenue, order count, per-unit ratios, and regular-order COGS do not change. CSV exports therefore use the same corrected historical piece count as Inventory.

Bulk costs

Apply Unit COG, outbound FBS shipping, or both to several products with All History, Immediate, or a Custom Date. A blank field means “leave this cost unchanged.”

All History starts each selected product on its own first sale, so its past orders get COGS; later dated costs stay unchanged. The dialog starts on All History when none of the selected products has a Unit COG yet, and warns when Immediate or Custom Date would leave uncosted products with zero COGS for earlier sales.

Switch the bulk dialog to Delete dated periods when a dated upload or update started on the wrong day. Select the exact period start date and choose whether to remove Unit COG periods, outbound FBS shipping periods, or both. You can apply the deletion to selected products or to every matching product in the active shop, including products that are not on the current Inventory page.

Large bulk updates and deletions are queued in the background. The dialog closes after Dashboardly accepts the request, and Inventory refreshes automatically when the durable operation completes.

Deleting a dated period does not delete FIFO shipment lots, durable product or SKU defaults, or TikTok FBT warehouse charges. Dashboardly restores the immediately preceding dated value through the next remaining period, so removing a mistaken July 17 period can make the July 1 value apply again until the next valid change.

Import Costs

When you select Import Costs, the button shows Preparing cost import… while Dashboardly confirms the active shop's cost settings and loads the import dialog. Wait for the dialog to open; repeated clicks are disabled during this preparation. If those settings cannot be loaded, the button becomes available again and you can retry.

Download a pre-filled spreadsheet and choose one of three template layouts:

• Products only — one default cost row per product; selected by default.
• Tree view — products with their child SKUs.
• Flat view — SKU rows only.

Enter changes only in New Unit COG and/or New FBS Shipping Cost. Current-value columns are reference-only. A row-level Effective Date always wins. For rows without one, choose how they start:

• Auto (recommended) — products and SKUs without a cost start on their first sale, so past orders get COGS; those that already have a cost change on the date you pick.
• From first sale (all history) — every dateless row starts on its first sale.
• Specific date — every dateless row starts on the date you pick; earlier sales without a cost keep zero COGS.

The preview labels rows that start on a First sale or have No sales yet, and warns when a Unit COG row would still leave earlier sales without a cost.

New means the value you want to apply, not necessarily a different number. To give an existing cost an earlier starting date, copy that value into New Unit COG and set the correct Effective Date. You do not need to delete existing costs first. Rows with both New columns blank are ignored; leaving those rows in the file does not prevent other filled rows from importing.

The template's current-value columns use the Unit COG and FBS shipping periods effective today in the shop's timezone. This lets you download a fresh template after an import and confirm the values Dashboardly is currently using.

The cost template can include a removed SKU when it has historical sales or eligible free-sample orders, because you may still need to add its past product cost. Removed SKUs without either activity stay out of the template. A historical SKU in the template may be absent from the current Inventory table and its regular export. Match its Product ID and SKU ID before entering a rate: a reused Seller SKU name can belong to another product or variant.

The regular Export CSV also includes Product ID plus spreadsheet-safe Product and SKU IDs. A current export can therefore be uploaded through Import Costs after you edit Unit COG or Shipping Cost / Unit. Because every nonblank cost in that CSV is treated as a value to apply on the selected Effective Date, use the dedicated template for normal updates when you want blank New columns and the smallest possible change set.

Inventory exports downloaded before August 31, 2026 do not contain Product ID and cannot be matched safely. Dashboardly stops those files with one recovery message instead of listing an error for every row. Download a new Import Costs template or a current Inventory CSV before retrying.

Dated costs are stored to six decimal places. Formula-generated values with additional decimal places are shown with their rounded value in the preview, and the warning reports how many valid values will be rounded before you confirm the import. Invalid negative or out-of-range values are still rejected.

To upload multiple periods in one file, duplicate the same Product or SKU row and use a different Effective Date on each copy.

Shipping Rules

Configure when uploaded FBS shipping fallbacks apply, including sample-order behavior. These rules do not replace TikTok's imported settlement shipping data.

Filters and Search

Search, product status, Without COGS, and Shipping rate not set appear together above the table. An enabled cost filter is highlighted. Columns sits on the left of the action row, with export and cost-management actions beside it; the controls wrap to fit smaller screens.

On desktop, use the slim horizontal scrollbar above the table headings to view columns to the right while working with the first products. The column headings and top scrollbar stay visible below the app's navigation as you scroll down the Inventory table. Product names and row actions remain fixed while the other columns scroll sideways. The scrollbar appears only when the visible columns are wider than the table.

• Active or sold includes active listings and products with recorded sales, including deactivated listings. Sold products remain available for cost work even when their 30-day and 90-day sales counters have not refreshed or those windows have passed.
• Without COGS keeps a product visible while at least one of its visible SKU variants still lacks a usable cost. Expand a multi-SKU product to see which variants need attention; pricing one variant no longer hides the remaining uncosted variants.
• Shipping rate not set finds SKU variants without a manual FBS rate effective today in the shop's timezone. An explicitly configured zero counts as set, and FBT-only variants are excluded. This checks the configured SKU rate, not whether TikTok has supplied an actual shipping charge for every order. It also does not evaluate a separate per-order shipping rule.
• Choose All products to include inactive listings that have no recorded sales. Removed listings with no recorded sales remain hidden.
• Search accepts product names, Seller SKUs, exact TikTok Product IDs, and exact TikTok SKU IDs.
• Columns controls which metrics are visible.
• Pagination keeps large catalogs responsive.

When you change or clear a search, any product you already expanded shows its SKU rows again once they finish loading, provided that product is still in the results. You do not need to collapse and reopen it. Searching for a SKU keeps its product's other eligible variants visible when expanded, so you can compare them; the CSV still includes only the variants matching your search.

Export CSV uses the same search, visibility, Without COGS, and Shipping rate not set filters that are currently applied to the table. Choose All and leave Without COGS off when you need a complete costed-and-uncosted Inventory file. Large catalogs are included in full rather than stopping at a fixed row limit. The download is assembled from one stable view of your Inventory records, so a sync cannot move a SKU between pages while the file is being created. If Dashboardly cannot confirm that every matching row is present, the download stops and asks you to retry instead of returning a partial file.

Combine Without COGS and Shipping rate not set to show only variants missing both values. With only the shipping filter on, a product remains in the results while at least one eligible variant has no current rate; expand it to inspect the matching variants. The product/SKU counts and downloaded rows follow that same selection. For example, a dated rate of $2.50 starting tomorrow does not fill today's gap, while an active rate of $0.00 does.

Search by an exact Product ID to export that product's eligible SKU rows. Search by an exact SKU ID to export the matching variant. A Seller SKU search also limits the CSV to matching variants, even when expanding the product in the table shows its other variants for context.

Cost Priority in Reports

Dashboardly resolves Unit COG for each sold unit in this order:

1. A priced FIFO lot that covers the unit
2. The SKU period active on the order date
3. The product period active on the order date
4. The durable SKU default
5. The durable product default
6. Zero when no cost applies

This resolver is shared by Inventory, Sales & Profit, Product Overview, Profit & Loss, and exports. Adding or editing a dated period invalidates the affected report data so the next read uses the new cost.

Cost History

The manager lists active, ended, and future periods in date order. Editing a period changes only that dated record. Adding a newer period causes the prior period to end on the preceding day.

Archived SKU variants retain their cost history. You can view and correct a dated Unit COG period for the exact historical SKU without reactivating its TikTok listing. Check both the Product ID and SKU ID; a reused Seller SKU name does not identify the same variant.

Use periods whenever your supplier or outbound shipping cost changes over time. Do not overwrite the current value if the old value must remain valid for historical orders.

For a one-off mistake, use Bulk costs > Delete dated periods instead of overwriting the value again. Choose the exact start date shown in Cost History. Dashboardly removes only matching dated Unit COG and/or outbound FBS shipping periods and reconnects the surrounding timeline automatically.

A SKU can also have a durable fallback cost. When a product or SKU period is active, the manager shows that period as the effective cost and keeps separate Edit SKU default and Reset SKU default actions for the fallback used after no dated period applies.

Common Questions

Where is a product that I relisted on TikTok?

When the product name and Seller SKU set match an earlier listing exactly, Dashboardly keeps the relisting's orders and costs under the original product. Search Inventory by the product name and expand that row to find its SKUs. The row can show the original TikTok Product ID even though the relisting has a newer ID. Turn off Without COGS if the original product already has a cost. The regular CSV export follows the same rule: a hidden relisting does not add a second set of uncosted SKU rows to the file.

Listings with a different name or Seller SKU set are separate products. See Setting Up Cost of Goods for how costs apply to repeat listings.

What does Manage Unit COG edit on Product Overview?

A selected SKU tab opens that SKU's cost periods. All SKUs opens the product default for current and future SKUs, even when the product currently has one SKU. Use Change scope inside the manager to move between the product default and a specific SKU override.

Why did an earlier month not change?

The new period started after that month. Add or edit the period that covers the earlier order dates.

How do I set Unit COG without finding the first sale date?

Add a period and select All history. Dashboardly finds and previews the first qualifying sale date before you save.

Why does a SKU ignore the product value?

That SKU has its own applicable period, which takes priority over the product default.

Why is the value in Inventory different from the SKU default?

Inventory shows the cost that is effective today. A dated SKU or product period can temporarily take priority over the durable SKU default. Open Manage Unit COG to review the period and edit or reset the fallback separately.

Why is FIFO different from the visible Unit COG?

The table shows the current dated fallback. Profit COGS can come from older priced FIFO lots when those lots cover the sold units.

Why is Shipping Cost / Unit blank for FBT?

The editable field is an outbound FBS fallback. TikTok FBT shipping and fulfillment charges are imported and reported separately.

What happens to cancelled or refunded orders?

An order cancelled before shipment does not consume inventory. A shipped item that is not returned keeps its cost. A physically returned item reverses the inventory-cost impact.

Why are Pieces different from Units for a multipack?

Units is TikTok's transactional quantity. Pieces is the physical quantity: Units multiplied by the effective bundle size. Review the SKU's Units per bundle when Pieces unexpectedly equals Units for a multipack.