Products & insights lists the products in your catalog, each with its health color, how fast it sells, what it earns and when its stock runs out. You filter and sort the table to find the products that need a decision, choose the columns you want to see, and add missing cost prices without leaving the page.
You will learn #
- How to narrow the table to the products you need to act on
- How to choose your columns, or start from a ready set
- What the less obvious columns and marks mean
- How to add cost prices in the table, or from a CSV file
- How to export the table, and open a product’s own page
Before you begin #
- Run an analysis first. The table shows your products as your last analysis saw them, and Last calculated … ago, above the table, says when that was. If it says Not calculated yet, click Re-scan store at the top of the page.
- To add cost prices from the table, WooCommerce’s cost field has to be on. If you hover a simple product in the Cost / Margin column and see no Add cost, switch on Cost of Goods Sold under WooCommerce → Settings → Advanced → Features.
Open the table #
- In your WordPress admin, open Tendlio → Inventory → Products & insights.
- The table opens with your whole catalog, sorted by Revenue/mo, highest first.
At the top of the page, See score & next steps opens your Inventory Score and the first three inventory cards from your to-do list. While you have no Inventory Score, it’s called See next steps.
Find the products that need a decision #
Start with the health colors #
The buttons over the table group your products by health color: Fast, Steady, Slow, Dead, New and Seasonal, plus Out of stock, each with a count. Click one to show only that group, and All to go back. Seasonal shows only the seasonal products that are out of season right now. Hover a button for what its color means.
Under the buttons, Revenue / month by selling speed shows roughly what each group brings in per month.
When your store has had too few orders in the last year to tell a slow product from a quiet month, the colors are on hold, and a note above the table says so.
Search and filter #
- In Search name, SKU or brand…, the table narrows as you type. The search looks at product names, SKUs (a variation’s SKU too), brands and suppliers, and every word you type has to match.
- The filters next to the search box apply when you click Apply filter:
- ABC shows class A, B or C products.
- Catalog has three lists, and a fourth appears while the Views (30d) column is on screen. No sales in 12 months shows the products that haven’t sold at all in that time. Stopped selling shows products that sold in the last year but have gone quiet: the time since their last sale is longer than they usually take to sell three units. Long tail (B + C, still selling) shows your class B and C products that still sell.
- Category: tick the categories you want, then choose Show only these or Hide these. When you have many categories, you can type in the box above the list to find one.
- Brand and Supplier appear when your products have them.
- Stock shows In stock or Out of stock products, or Overstocked ones: products that still sell, but that you hold several months of stock for. The option names how many months. Stop reordering these rather than discounting them.
- Margin has three lists. Below cost shows simple products in stock whose price is under their real cost. Underpriced (thin margin) shows your top earners, class A, with a thin margin on their real cost. Missing cost shows products with no cost yet, or only an estimated one.
- Reset clears the search and every filter.
Sort by a column #
Click a column title with a dotted line under it to sort by that column, and click it again to reverse the order. Cost / Margin has two titles, Cost and Margin, so you can sort by either.
Choose your columns #
- Click Columns, next to Export CSV.
- Tick the columns you want, or click one of the Ready sets: Restock, Clear stock, Money or Storefront. A ready set ticks the columns for that job and sorts the table for it: Restock by what runs out first, Clear stock by stock value, Money by profit, and Storefront by page views.
- Click Save.
Your choice is saved to your login, so everyone on your team keeps their own. The product, its picture and the health dot always stay. Reset to default ticks the standard columns again. Click Save to keep them. Cancel closes the list without changes.
A column that has nothing to show yet is gray in the list, with the reason and a link to the setting that fills it. For example, Season is gray while seasonal detection is off, and Rating while product reviews are switched off in WooCommerce.
If you sort by a column and then hide it, the table keeps that order, and a line above the rows says so.
Read the columns #
Hover a column title for what the column means. These columns and marks need a short explanation, and some of them aren’t in the table until you add them under Columns:
- The dot before each product is its health color. RESTOCK next to a name means the product is out of stock and was making you money.
- Sales/mo is units sold per month in the last 12 months, counted only for the time the product was in stock. An h next to a figure means the product is out of stock now, and the figure is what it did while it was in stock.
- vs last year compares the units sold in the last 30 days with the same 30 days a year ago.
- Days to OOS counts down to the day the product runs out at the forecast pace. A red number means an order placed today would arrive too late. A yellow one means it runs out within your Stockout warning: 30 days, unless you’ve changed it under Settings → General → Inventory, where it shows in Advanced mode.
- Forecast 30d is the units the product is expected to sell in the next 30 days. 6 mo next to it opens a six-month forecast.
- Missed so far is what the current stockout has cost you in sales up to today.
- A * after the cost in Cost / Margin means the cost is estimated, from your average margin or from the margin you set for the product’s category. est. marks money figures that rest on an estimated cost.
- Tied up is the cash in stock you won’t sell soon. The line under the amount gives the reason, such as No sale in 12 months, Some variations are not selling, More than one season of stock, or how many months of stock you hold. It’s the money behind your Dead Stock score.
- Last sold counts the days since the product last sold. A seasonal product outside its season is marked off-season, because a quiet stretch is expected then.
- Views (30d) counts how often shoppers opened the product’s page. While it’s on screen, two filters come with it: Views at least, and No recorded views in 30 days in the Catalog filter.
Add cost prices #
Profit, stock value and the money tied up in stock all need a cost for each product. You can add costs one at a time in the table, or many at once from a CSV file.
One product at a time #
- If the Cost / Margin column isn’t on screen, add it: it’s in Columns, under Money, and in the Money and Clear stock ready sets.
- In the Margin filter, choose Missing cost, and click Apply filter. The table lists the products that have no cost yet, or only an estimated one.
- Hover a row, and click Add cost in its Cost / Margin cell. A product that already has a real cost shows Edit instead.
- Type the cost and press Enter, or click Save. Escape closes the box without saving.
The cost is saved in WooCommerce’s own cost field, as if you had typed it on the product’s edit screen, and the margin next to it updates straight away. The product’s profit, stock value and tied-up money show the new figures when the page reloads, and your Inventory Score takes the new cost in at your next analysis. To remove a cost, clear the box and save.
A variable product shows Per variation instead of Add cost, because each variation keeps its own cost. Set each variation’s cost on the product in WooCommerce.
Many products at once, from a CSV file #
- Under the table, open Import costs from a CSV.
- Prepare a file with two columns, headed sku and cost. Other common header names work too, such as sifra, nabavna cena or cogs. Save the file as CSV UTF-8. A file saved another way is turned away with a note, because accented letters wouldn’t survive the import.
- Choose the file, and click Import costs.
Tendlio matches each row to a product by its SKU. An empty cost cell is skipped, so a half-filled file never clears a cost you already have. A row with a variation’s SKU is skipped too: Tendlio matches it to the variable product, and a variable product’s costs have to be set on each variation in WooCommerce. When the import finishes, the table shows the products still missing a cost, and a message says how many costs were saved, how many rows were skipped, and which SKUs Tendlio couldn’t find. The file can be up to 5 MB.
Export the table #
Export CSV downloads the products your search and filters show, in the same order, with every column, including the ones you’ve hidden. An export stops at 5,000 rows, and when it does, the file ends with a note that says so. To export the rest, narrow the filters and export again.
Open one product’s page #
Under every product name, Insights opens that product’s own page: what to do about it next, its figures, the units it sold each month, a six-month forecast, how shoppers reach it, and its price changes. Clicking the product name itself opens the product in WooCommerce.
Boost a product, or hide it from recommendations #
Boost, under a product name, moves that product up for two weeks: on your shop and category pages, and in the recommendation rows it already belongs to. To change several products at once, tick the box next to their names, and a bar appears with Boost, Hide from recommendations and Back to normal. If Tendlio can’t boost a product, for example because three products in the same category are already boosted, the message you get after clicking says why. Once you’ve boosted a product, a Boosted button over the table lists every boost, running or ended, with what changed during it.
Check whether the bottom of your catalog pays its way #
Above the health colors, Catalog concentration shows how many of your products had no sales in the last 12 months, and how many products bring in 80% of your revenue. Show unsold products lists the first group. Show slow sellers lists your class B and C products that still sell, the Long tail list from the Catalog filter.
To weigh what your slowest products earn against what it costs you to keep them, open Is the bottom of your catalog worth its cost?:
- In Your bottom … slowest products, type how many products to look at.
- In cost you about … /mo to carry (rent, storage), type what carrying them costs you per month.
- Click Compare.
Tendlio sets the monthly profit of those products against that cost, and says whether trimming them could pay. The comparison needs cost prices, or an average margin, to work out the profit.
Why the table works this way #
It shows selling pace, not lifetime sales #
A product you’ve listed for years has had years to sell, so lifetime totals would put it above a newer product that sells faster today. Sales/mo and Revenue/mo measure a month’s pace instead, over the time the product was in stock, so a product you listed last year and one you’ve carried for five years are compared by the same measure, their sales per month.
An out-of-stock product keeps its old pace #
A product that ran out a month ago sold nothing that month because there was nothing to sell, not because nobody wanted it. The table shows what it did while it was in stock, marked h, so a best-seller that ran out still looks like one.
Estimated costs are marked #
An estimated cost comes from your average margin, or from the margin you set for the product’s category, so its margin and profit repeat that margin and say nothing about the product itself. The marks show you which figures to trust less until you enter the real cost.
Additional resources #
- How to read a product’s Insights page: everything about one product.
- Product health colors (Fast / Steady / Slow / Dead)
- ABC class (A / B / C)
- Selling pace (Sales/mo)
- Forecast & “runs out in”
- How to give Tendlio your product costs
- How to discount products yourself with Manual outlet
- How to boost a product, or hide it from recommendations
- Sales velocity
Frequently asked questions #
Why doesn't a product show a cost I entered today? #
If you typed it in this table or imported it by CSV, the Cost / Margin cell shows it right away. A cost entered on the product's WooCommerce screen reaches the table at your next analysis. Either way, the Inventory Score takes it in at the next analysis.
Why is a column gray in the Columns list? #
It has nothing to show yet. The list gives the reason and a link to the setting that fills it, such as seasonal detection for Season.
Does Export CSV follow my columns? #
No. The file always has every column, and it follows your search, your filters and your sort.