Products Table: Search, Sort, Filter & Export

The products table in MerchantFlow is the central analytics view that displays detailed performance metrics 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.

What the Products Table Shows

Access the products table at Dashboard > Products.

[Screenshot: Full products table view]

Table Columns

The products table displays these columns by default:

Understanding Column Data

Product Column:

• Product thumbnail (click to enlarge)
• Product title (click to view product details)
• SKU number below title

Revenue Column:

• Shows total dollar amount
• Color-coded: Green for high performers

Trend Indicators:

• Up (Green): Improving performance
• Down (Red): Declining performance
• Stable (Gray): No significant change

How to Sort Products

Sort by Column

Click any column header to sort:

1. Click once: Sort ascending (low to high)
2. Click twice: Sort descending (high to low)
3. Click third time: Remove sort

Most useful sorts:

• Revenue (high to low) - Find top sellers
• Conversion Rate (high to low) - Find best converters
• Clicks (high to low) - Most popular products
• CTR (low to high) - Products needing title or image optimization

[Screenshot: Sorting by revenue]

How to Search Products

Quick Search

Use the search box at the top:

1. Type product name, SKU, or keyword
2. Results filter instantly as you type
3. Clear search with the X button

Search examples:

• "shoes" - All products containing "shoes"
• "SKU-123" - Specific product by SKU
• "$99" - Products at $99 price point (if in title)

[Screenshot: Search box with example]

Advanced Search

Click Advanced Search for more options:

• Product name
• SKU
• Category
• Price range
• Status
• Performance criteria (revenue, clicks, etc.)

How to Filter Products

Basic Filters

Apply filters to narrow down products:

By Status:

• Active
• Out of Stock
• Archived
• Disapproved (Merchant Center)

By Performance:

• Top Performers (top 10% by revenue)
• Under-performers (bottom 10%)
• Zero Revenue
• High Traffic, Low Conversion

By Category:

• Filter by product type or collection
• Select from your catalog's categories

[Screenshot: Filter sidebar]

How to Create Custom Filters

Build complex filters:

1. Click "Add Filter"
2. Select field (Revenue, Clicks, etc.)
3. Choose operator (>, <, =, between)
4. Enter value
5. Click "Apply"

Example custom filter:

Revenue > $1000 AND
Conversion Rate < 2% AND
Clicks > 100

This finds high-traffic, low-converting products worth optimizing.

Product Actions

Individual Product Actions

Click the three-dot menu next to each product for actions:

• View Details - See detailed product analytics
• Edit COGS - Update cost of goods sold
• View in Store - Open product page in your store
• View in Merchant Center - Check feed status

Bulk Actions

Select multiple products and perform actions:

1. Check boxes next to products
2. Click "Bulk Actions" dropdown
3. Choose action:
   • Update COGS
   • Add to collection
   • Export selected
   • Tag products

[Screenshot: Bulk action menu]

How to Export Product Data

CSV Export

Export product data for analysis:

1. Apply desired filters and sorts
2. Click "Export" button
3. Choose what to include:
   • All columns
   • Selected columns only
   • Current page only
   • All filtered results
4. Click "Download CSV"

CSV includes:

• All visible columns
• Additional metadata (created date, updated date)
• Custom fields you have added

Pro Tip: Export regularly for backup and external analysis in Excel or Google Sheets.

For automated product reporting, see Reports.

How to Customize the Table

Show/Hide Columns

Customize which columns appear:

1. Click "Customize Table" button
2. Check/uncheck columns
3. Drag to reorder
4. Click "Save"

Available columns:

• Standard: Product, Revenue, Impressions, Clicks, CTR, CR, Status
• Advanced: ROAS, Ad Spend, Profit Margin, AOV, Units Sold
• Custom: Any custom fields you have created

Column Width

Adjust column widths:

• Hover over column divider
• Drag left or right
• Double-click divider to auto-fit content

How to Identify Top Performers and Opportunities

Finding Top Performers

High Revenue, High Margin:

1. Sort by Revenue (high to low)
2. Add filter: Profit Margin > 30%
3. These are your stars -- invest more in them

High Traffic, High Conversion:

1. Sort by Clicks (high to low)
2. Filter: Conversion Rate > 3%
3. Well-optimized products -- use as benchmarks

Finding Optimization Opportunities

High Traffic, Low Conversion:

1. Filter: Clicks > 100
2. Filter: Conversion Rate < 1.5%
3. These need landing page optimization

Low Traffic, High Conversion:

1. Filter: Clicks < 50
2. Filter: Conversion Rate > 3%
3. Great products -- increase visibility with more ad spend

High Impressions, Low Clicks:

1. Filter: Impressions > 1000
2. Filter: CTR < 0.5%
3. Need better images or titles

Spotting Problems

Zero Revenue Products:

• Filter: Revenue = $0
• Filter: Clicks > 10
• May have pricing issues or broken product pages

Declining Products:

• Filter: Trend = Declining
• Sort by Revenue (high to low)
• Address issues before revenue drops significantly

Performance Visual Indicators

The table uses colors and icons to highlight important information:

Revenue highlighting:

• Dark green: Top 10% revenue
• Light green: Above average
• Gray: Average
• Yellow: Below average
• Red: Bottom 10%

Status badges:

• Green: Active
• Red: Out of Stock
• Warning: Disapproved
• Paused: Archived

Trend arrows:

• Strong growth (>20%)
• Growth (5-20%)
• Stable (within 5%)
• Decline (5-20%)
• Strong decline (>20%)

Troubleshooting the Products Table

Products Not Showing

Check:

• Filters applied (clear all filters)
• Search active (clear search)
• Sync completed successfully
• Time range includes product sales

Incorrect Data

Verify:

• Correct time range selected
• Currency settings
• Last sync time
• Integration connections active

Export Not Working

Try:

• Reduce number of products (use filters)
• Check browser pop-up blocker
• Try different browser
• Contact support if persists

Frequently Asked Questions

How many products can the table display?

The products table supports catalogs of any size. Products load in pages of 50 by default (configurable to 10, 25, 50, or 100 per page). Large catalogs use pagination and lazy loading for performance.

Can I see profit margins in the products table?

Yes. Click "Customize Table" and enable the Profit Margin column. Profit margins require COGS to be set for each product. Products without COGS will show a dash in the margin column.

How do I find products that need optimization?

Use the built-in "High Traffic, Low Conversion" performance filter, or create a custom filter with Clicks > 100 AND Conversion Rate < 1.5%. These are products getting attention but not converting, which typically respond well to product page improvements.

Does the products table update in real time?

The table updates each time a sync completes. Data is cached briefly for performance. To see the latest data, check the Live Updates indicator for the most recent sync time, 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: March 14, 2026