Products Table: Search, Sort & Export
Master the MerchantFlow products table. Search, sort, filter, and export product performance data with revenue, profit, margin, and conversion metrics.
Products Table: Search, Sort, Filter & Export
The products table in MerchantFlow is the central analytics view that displays performance and profitability for every product in your Shopify or WooCommerce catalog. Search, sort, filter, and export product data to identify top performers, find optimization opportunities, and track individual product trends over time.
How to Access the Products Table
Navigate to Products > Performance (/dashboard/products). The page is headed Products, subtitled "Product-level analytics and profitability reporting."
The Portfolio Summary
Above the table, two summary panels frame the catalog:
- Top Category -- an All Products tile with your total item count
- Health Score -- a Portfolio Performance bar with a health label, giving you an at-a-glance read on overall catalog profitability
Table Columns
| Column | What it shows | Sortable |
|---|---|---|
| Product Info | Product image, title, and SKU | Yes |
| Revenue | Total revenue for the selected period, with the period-over-period change percentage below it | Yes |
| Profit | Net profit in your store currency, with net margin % below it -- and a returns % line whenever the product sold any units in the last 90 days (a product with no refunds reads 0.0%) | Yes |
| Traffic | Clicks, with impressions below | Yes |
| Conv. Rate | Conversion rate as a percentage | Yes |
| Status | Active, Low Stock, or Inactive | No |
Traffic and Conv. Rate only appear when you have an analytics source connected and either the Search Console or Merchant Center feature is enabled for your workspace. Without them the table shows four data columns rather than six.
Reading the Visual Cues
- Each row's Product Info cell carries a coloured bar on its left edge keyed to net margin -- healthy margins read green, thin margins do not. The bar sits on the pinned cell, so it stays in view while you scroll sideways
- Profit is green when positive and red when negative
- Returns % turns amber at 5% and red at 15%
- The revenue change percentage shows the direction of travel versus the previous period
Scrolling the Table
On desktop the table scrolls inside its own frame rather than with the page. The header row stays pinned at the top while you scroll down, and the Product Info column stays pinned on the left while you scroll across to the traffic and conversion columns, so you always know which product and which column you are looking at. A short list simply takes its natural height. Changing page or sort order returns you to the top of the list. On a phone the table is replaced by a card per product.
How to Sort Products
Click any sortable column header. Each header is a button, so you can also reach it with Tab and press Enter. The first click sorts descending (highest first); clicking the same header again flips to ascending. An arrow marks the active sort column, and sorting takes you back to page 1. Sorting works on every date range, preset or custom.
Most useful sorts:
- Revenue (high to low) -- find top sellers
- Profit (high to low) -- find what actually makes you money, which is often a different list
- Traffic (high to low) -- most-viewed products
- Conv. Rate (low to high) -- products getting attention but not converting
Product Info, Revenue and Profit sort on the server across your whole catalog, so page 1 really is the top of the list. Traffic and Conv. Rate sort only within the rows already on screen -- the page is selected by name first, then reordered in the browser.
How to Search Products
The search box at the top of the filter bar matches on product name or SKU. (The placeholder text also mentions tags, but the query only looks at name and SKU.) Type and the table re-queries; clear the box to return to the full catalog.
How to Filter Products
Click Filters to open the filter panel. It filters by Status:
- All
- Active
- Inactive
- Low Stock
A teal dot on the Filters button indicates a filter is active, and Clear resets it.
Product Actions
Click the three-dot menu at the end of any row:
- View Product Info -- open the full product detail page
- Edit Metadata -- change the product's Name, SKU, Price, or Status (Active or Inactive)
- Open in Shopify -- open the product in your store admin (disabled, showing "No product URL", when MerchantFlow has no link for it)
- Remove Product -- confirm in the dialog and the product's status is set to
deleted. This is reversible: reopen Edit Metadata and set Status back to Active. Note that the row is not currently dropped from the table -- a removed product keeps appearing under the All filter with an Inactive badge
The menu opens below the button, or above it when there is no room below, and is never cut off by the table. Press Esc or click elsewhere to close it. Clicking anywhere else on a row opens that product's detail page.
How to Export Product Data
Click Export CSV to download the current view. The file contains:
Product Name, SKU, Revenue, Profit, Profit Margin %, Impressions, Clicks, Conversion Rate, Change %, Status
Export regularly for backup and for deeper analysis in Excel or Google Sheets. For recurring product reporting, use the Product Performance template in Reports.
Pagination
Products load 50 per page by default, switchable to 25 or 100 with the selector below the table. A "Showing X to Y of Z products" line tells you where you are, with page controls alongside. These sit outside the scrolling area, and changing page returns you to the top of the list.
How to Identify Top Performers and Opportunities
The table gives you two levers -- sorting and the status filter -- so most analysis is a matter of sorting on the right column and reading the secondary lines.
Find your real winners. Sort by Profit rather than Revenue. High-revenue products with thin net margins are common, and the margin line under each profit figure exposes them immediately.
Find the margin leaks. Sort by Revenue descending and scan the colour bar on each product cell. A high-revenue row with a warning-coloured bar is where your money is going.
Find the returns problem. Scan the returns percentage under Profit. Anything red (15%+) is eroding margin invisibly -- the revenue looks fine until you account for what came back.
Find the conversion problem. With traffic columns enabled, sort by Traffic descending and look for low Conv. Rate values. Those products are getting attention but not converting, and usually respond well to product page improvements.
Find the dead stock. Filter to Low Stock to see what needs reordering, or Inactive to review what you have stopped selling.
Troubleshooting the Products Table
Products Not Showing
Check:
- The status filter (clear it back to All)
- The search box (clear it)
- That your last sync completed successfully
- That the selected time range includes the product's sales
Profit or Margin Shows No Value
Profit requires COGS to be set for the product. Products without a cost cannot have a margin calculated.
Traffic Columns Are Missing
They require a connected analytics source, plus Search Console or Merchant Center enabled for your workspace. Check Settings > Integrations.
Incorrect Data
Verify:
- The correct time range is selected
- Your currency settings
- Your last sync time
- That your integration connections are active
Frequently Asked Questions
How many products can the table display?
Any catalog size. Products load in pages of 50 by default, configurable to 25 or 100 per page. Search and the Product Info, Revenue and Profit sorts run on the server, so the full catalog is considered even when you are looking at one page. Traffic and Conv. Rate are the exception -- they reorder the current page only.
Can I see profit margins in the products table?
Yes -- net margin appears directly under each product's profit figure. Margins require COGS to be set for the product.
Can I customize which columns appear?
Not manually. The column set is fixed, and the Traffic and Conv. Rate columns appear automatically when the data behind them is available.
How do I find products that need optimization?
Sort by Traffic descending, then look for rows with a low Conv. Rate. Those products are getting attention but not converting. Also watch the returns percentage under Profit -- a high return rate quietly destroys margin on products that otherwise look healthy.
Does the products table update in real time?
The table refreshes every few minutes while open and reflects your most recent sync. To pull fresh data, check the Live Updates indicator or trigger a Manual Sync.
Related Articles
- Product Detail Analytics - Deep dive into individual products
- Performance Charts - Visualize product trends
- KPI Metrics - Dashboard metric definitions
- Traffic Sources - Channel-level performance
- P&L Overview - Profitability tracking
Last updated: September 9, 2026
Last updated on
Dashboard Customization and Layout
Customize your MerchantFlow dashboard layout, configure North Star KPIs, and show or hide widgets to focus on the metrics that matter most.
Product Detail Analytics & Performance
Analyze individual product performance in MerchantFlow. View revenue, net margin, return rates, revenue attribution by source, search queries, and variant profitability.