About
Applies to: Finaloop Accounting, InventoryIQ, Margins
Finaloop's SKU Analysis Dashboard, the SKU analysis tab of your Dashboard, gives you visibility into the true profitability of every product you sell across Shopify, Amazon, TikTok Shop, Walmart and your Finaloop invoices.
The dashboard combines sales, discounts, refunds, and product-level cost of goods sold (COGS, what the products you sold cost you), so you can see each SKU's actual profit margin, profit per unit, and overall performance. It helps you:
Identify your most profitable products
Spot loss-making or low-margin SKUs
Understand which SKUs have enough cushion to withstand increasing costs, such as shipping out, ads, fulfillment, or tariffs
Allocate ad spend more strategically
Every SKU behaves differently. This dashboard gives you the visibility you need to make more informed pricing, purchasing, and inventory decisions.
The tab appears once you have Shopify, TikTok Shop, Amazon or Walmart connected, or products in Finaloop (for example from Finaloop invoices). In Finaloop Accounting, it works with Sales based COGS and with InventoryIQ (Finaloop's inventory management product). It's hidden while your COGS method is Purchase based, because unit costs aren't tracked then.
In Margins: Margins (Finaloop's performance analytics product) shows the same tab at SKU analysis, and everything in this article applies there. The COGS method rule doesn't apply, and the Filters panel has Sales channel instead of Shopify sales channel.
1. Where to find the SKU Analysis dashboard
In the left sidebar, click Dashboard.
Click the SKU analysis tab at the top of the page.
The table opens in US$ view, from the start of this year to today. You can view your margins for every source together or filter by a specific source.
If you're still choosing an inventory method, the tab shows No inventory method was selected. Choose your method on the Inventory page (the link on that screen) and the table appears.
Amazon and Walmart sales appear from the date your store moved to Finaloop's updated Amazon or Walmart integration. If you used Purchase based COGS for an earlier period, the dates start after that period ends.
2. What you see in the dashboard
The SKU Analysis Dashboard breaks down all the components that shape your SKU-level profitability. It shows a row for each active SKU in the selected period, with its product name, SKU and the logos of the sources it sold on.
① Filters, ② US$ and Units, ③ Show returns, ④ Export.
Above the table, you can switch between two views:
US$ view: total dollar value profitability
Units view: profit per unit and unit-level behavior
Here's what each column shows and how it's calculated.
US$ view
Source: The sales channel(s) where this SKU was sold.
Sales: Your gross sales, based on the date the order is recognized in your books, which matches the date the items were fulfilled. Your SKU analysis only shows sales from orders that have both sales and COGS data. If COGS isn't recorded for an order, that order's sales won't appear, so the totals may be slightly lower than your actual sales.
For Shopify: Not all brands track fulfillment accurately in Shopify. Since actual fulfillment data is not always accurate, Finaloop supports two fulfillment tracking methods: Order placed date or Order fulfilled date. To learn more, see Tracking and Managing Shopify Orders, Refunds, and Cancellations.
Sales trend: Year-over-year change in sales for the selected period. It appears only if previous-year data is available, and it's hidden while Previous period is on.
Discounts: All product-level discounts for included sales orders.
Net Sales: Sales minus discounts.
Product COGS: The cost of the units sold, synced automatically and dated the same way as Sales (for Shopify, by your fulfillment tracking method). It's based on your:
Average cost per unit (Sales based COGS, and Margins), or
FIFO (first in, first out) cost per unit (InventoryIQ).
Profit: Net sales minus product COGS.
Profit margin (%): Profit divided by net sales. This allows you to compare SKU performance at a glance.
When you turn on the Show returns toggle, you'll see additional columns that include refunds and restocks for a more complete view of SKU profitability over time. With the toggle off, profit leaves refunds and restocked items out.
Refunds: Refund amounts for this SKU during the selected period.
Restocks: The cost of units marked as physically restocked in your warehouse. Restocks reduce product COGS.
Effective profit: Profit minus refunds plus restocks.
Effective profit margin (%): Effective profit divided by net sales. This gives you a more complete picture of true SKU profitability over time.
Units view
Units sold: Total units sold per SKU, dated the same way as Sales (for Shopify, by your fulfillment tracking method).
Units refunded: Total units refunded.
Average units sold per week: Units sold divided by the number of weeks in the selected period, including weeks with no sales. The column follows Show by in Filters, so it can also read per day, month, quarter or year.
Average net sales per unit: Net sales divided by units sold.
Average cost per unit: Product COGS divided by units sold.
Average profit per unit: Profit divided by units sold.
3. Sorting and filtering
You can sort by clicking any column header except Net Sales, including profit margin, units sold, profit per unit, or total profit.
Common use cases:
Sort by profit margin to find SKUs with enough cushion to support increased costs such as ads or tariffs.
Sort by profit per unit to identify cash flow drivers.
Sort by lowest margin to surface loss-making SKUs that require attention.
To narrow the table:
Click Filters.
Choose what to show:
Source: Shopify, Amazon, TikTok Shop, Walmart or Finaloop invoices (your wholesale SKUs billed through Finaloop). Shown when you sell through more than one source.
Shopify sales channel: shown when you have more than one Shopify sales channel.
Show by: Day, Week, Month, Quarter or Year, for the per-period averages in Units view.
Previous period: compares with the same period last year by showing last year's value under each number. It's unavailable when the selected period starts in the year your books start.
Click Apply.
The table updates, and the Filters button shows how many filters are applied. Click Reset All to clear them.
To find one product, type its name or SKU in Search product name or SKU and press Enter. To download the table as a CSV file, click Export in the top right corner of the table.
4. Using SKU Analysis to improve your business
Identify your best performers
Quickly see which SKUs drive profit so you can focus ad spend and replenishment on what actually works.
Spot loss-making or at-risk SKUs
Understand which products are unprofitable or do not have enough margin to support rising fulfillment or landed costs (the full cost of getting a product to your warehouse, including shipping, duties and fees). These are effectively being financed by your profitable SKUs and, in many cases, should be cut.
Adjust pricing, costs, and strategy
With real margins in front of you, you can make more informed decisions about pricing, packaging, supplier costs, or promotions.
Plan for cost changes
Whether the cost increase comes from shipping, freight, platform fees, or tariffs, SKU-level visibility helps you see which products can absorb changes and which ones cannot.
FAQs
What does the "Some costs are missing" banner mean?
It means more than 20% of your active products are missing a cost per unit (Sales based COGS) or have units without a cost (InventoryIQ), so their Product COGS reads too low and their profit and margin read too high. Click Review Products in the banner to open your product list filtered to the products that need attention, then add the missing costs. Rows with a missing cost also show an info icon in Product COGS, and updated costs can take a few hours to appear in the table.
Important: Until every SKU has a cost, its profit and margin in SKU analysis are overstated. Add the missing costs before you make pricing or cut decisions based on those SKUs.
Why don't my SKU sales match Shopify or my P&L?
SKU analysis counts only orders that have both sales and COGS data, dates them by when they're recognized in your books, and shows discounts in their own column. Shopify's reports and your Profit & Loss (P&L) count differently, so the totals won't always match. To learn more, see Why your Dashboard sales and returns differ from your P&L.
Related articles
Need help?
If you have questions about your SKU data or want help interpreting your margins, reach out to our team through chat or at [email protected] (Margins customers: [email protected]).


