Product List: compare, filter and export your products
The Product List shows one row per product with its scores side by side. Use it to find your best and worst products, export them, or pick products for new ads. To open it, go to Insights > Products > Product List.
Problem and intended user
The ecommerce manager (the person who runs the store) needs to compare many products on one screen. The media buyer (the person who runs your paid ads) needs a short list of products worth advertising. The creative strategist (the person who plans and makes ad creatives) needs to hand those products to the next creative batch. The need arises whenever you choose products to push, fix or drop.
Current workflow
Without Commander, a merchant exports product sales from Shopify admin reports into a spreadsheet. They add margin from their own cost sheet and ratings from the review app's dashboard, then filter and sort by hand. They copy product names into the ad tools or send them to an agency.
Prerequisites
- A Shopify catalog that Commander has synced and scored.
- The cost per item on your products in Shopify admin, for the Margin column. Commander has no screen to enter a cost per item. For a product with no cost, Commander uses the Average product margin (%) that you set in Install and first setup.
- GA4 for the GA4 Tier, Recommendation and GA4 CR columns and the Demand score. See Google Analytics 4.
- A review app or NPS data for the CX score. See Review apps and CSV import.
While Commander prepares your data, a notice at the top of the page says what is still in progress, and some numbers can be thin. If your catalog changed in Shopify, open Update data at the top of the page and choose Refresh updated products.
How Commander works
Commander reads your catalog and orders, plus reviews, NPS and GA4 data when connected. Fixed scoring rules, not AI, produce every score. See Product scores.
Sorting, filtering and Export CSV only read data. Generate creatives opens the batch screen. You choose the options there, and nothing is generated before you press Generate creatives on that screen.
Choose and sort columns
Select Columns to show or hide a column. The picker also offers Price, GA4 Tier, Recommendation, GA4 CR and Avg predicted revenue. Your choice stays in your browser. The picker says Repurchase Rate, where the header says Repurchase.
GA4 Tier and Recommendation come from the latest classification. The Classify action in Update data runs a new one.
Click a column header to sort. Click again to reverse. The list opens sorted by Sales Score, highest first, so your best sellers come first. Products without sales data sort last. To rank by how much customers engage with a product instead, sort by Opportunity score.
To change what counts in Opportunity score, select the sliders icon beside its header, Adjust Performance Score weights. You can also select Adjust weights in the Why? panel, or select Update data, then Adjust weights under Analysis. Performance Score weights opens. After you save, the list follows the new scores. Selecting a product's score in that column does not open the weights. It opens a short card that shows how that score was calculated.
Filter the list
The filter bar above the tabs narrows every Product tab at once. It offers:
- A search by product name.
- Collection, Category (when your catalog has categories) and Quadrant.
- Stock: In stock, Low stock or Out of stock.
- Attribute: Gateway, Sticky, Bestseller or Second purchase hero.
A link that names one of your collections opens the list with Collection already set to it. A link that names a collection your store does not have opens the full list.
Select Clear filters to reset the bar. A counter under the bar shows the number of products. When a filter is on, it reads "Showing N of M products". When Commander cannot know the exact result count, it reads "Filtered from M products". This happens with a stock or attribute filter.
Inside the tab, Min. orders hides products with fewer orders than your number. Type a value or use the minus and plus buttons. The highest value is the largest order count in your catalog. Select Reset to clear it.
If you clicked a group of dots on the Quadrant Overview chart, a chip reads "Showing N products selected from the chart". Select its x to see the full list again.
See why a product has its quadrant
- Find the row. Why? sits at the right of the Opportunity score cell, across from the score it explains.
- Select Why?.
- Read the quadrant rule at the top of the panel.
- Read the boxes below it. Each box is one calculation, and its score shows in the top-right corner:
- How the Performance Score was built shows the Performance score. A bar and one row for each counted group follow. A row reads the group score times its weight, and shows the amount it adds. A Total row sums the amounts to the Performance score. The weights are the ones your store uses.
- Composite Sales (X axis) shows this product's Composite Sales score, with the inputs of the Sales score and their fixed weights.
- Composite Popularity (Y axis) shows this product's Composite Popularity score, with the Performance groups and the weights your store uses.
- Where it lands on the chart explains how a score becomes a position. It shows both axis scores in its list and has no score of its own.
- To change the weights, select Adjust weights. Performance Score weights opens with this product in the preview.
A box shows no score when the product has none for that axis. Why? does not show on a row that has no scoring detail.
A dimension with no data source shows "no data source", and Commander shares its weight across the others. A dimension that the score leaves out, for example because your weights set it to 0%, shows Not counted.
For a product with no Performance Score, the panel says that the product has no Performance Score yet. The first box is titled No Performance Score yet and shows a dash in its corner. It lists the score of each group, with no bar and no total, and Adjust weights does not show. Sales, Behavior and Demand show a dash, as in the list, because they need order data from Reveal. Customer Experience keeps its score when the product has reviews.

Open a product
Click a product name to open Product details in a large window. Close it with the X in the title bar. Product detail explains what the window shows. To see the same view as a full page, right-click the product name and open it in a new tab.
Select See Synthesis on a row to open Creative synthesis for that product.
Select, export and make creatives
WARNING
After Select all, Export CSV reads every page in your browser. Keep the tab open until Export ready appears. Leaving the tab stops the export.
- Tick the box on a row to select it. The header box selects every row on the page. The Quick Select buttons tick the products of one quadrant on the page you see.
- Read the bar at the bottom. It reads "N products selected" and offers Select all, Export CSV, Generate creatives (N) and Clear selection.
- Choose an action.
- Select all selects every product that matches your filters, on all pages.
- Export CSV downloads the selected products as a file. After Select all, Commander reads every page first. A progress bar shows the state, and Export ready appears at the end.
- Generate creatives opens the batch screen in Create > Creative batches with your ticked products, in table order. A batch is made for one product, so the screen asks you to choose one: it reads "Choose one product to generate." The number in the button shows how many products it carries, and a limit applies to that number. Select all does not change this. Nothing is generated until you press Generate creatives on the batch screen. See Generate creatives on the batch screen.

Exact output
The table
Each row is a product. The default columns are:
| Column | What it shows |
|---|---|
| Opportunity score | The overall score, from 0 to 100, on the left of the cell. Why? sits on the right of the same cell. Select the score to see how it was calculated. To change the weights, see Performance Score weights. |
| Orders | Delivered orders that contain the product. It counts orders, not units. It covers the last 365 days. On a very large catalog the period can be shorter. Hover the info icon for details. The period is longer than the 30 days of Revenue and Margin. |
| Revenue | Net product revenue for the last 30 days, after refunds. |
| Margin | Gross margin for the last 30 days. The margin percentage shows beside the amount. It shows N/A when your store has no product cost data. |
| Repurchase | Of the customers whose first order held this product, the share who ordered again. The first order must fall in the last 365 days. |
| Return % | The share of order lines for this product that were returned, over the last 365 days. It turns yellow above 8% and red above 15%. |
| Quadrant | Star, Hidden Gem, So & so or Simple Stone. Hover the info icon to see how Commander placed the product. |
| Composite Sales and Composite Popularity | The two quadrant axes. Each product is ranked against your own catalog, from -100 to +100. 0 is the median. A dash means the product is not ranked. In Composite Popularity, it can also mean that Commander had no order data for the product in its latest scoring run. |
| Sales | The score behind Composite Sales, from 0 to 100. It is not part of Opportunity score. |
| CX, Behavior, Demand | The three groups behind Opportunity score, each from 0 to 100. A group shows Not counted when your weights set it to 0%, or when the product has no data for any signal you weighted in it. |
How a quadrant is worked out
Hover the info icon in a Quadrant cell. The card shows the whole chain, from the scores to the quadrant:
- The quadrant and the rule that gives it, for example "Composite Sales is above the median and Composite Popularity is above the median, so this product is a Star."
- A small map with a dot where the product sits.
- Composite Sales (X axis): what share of your selling products the product's Sales score beats, how many selling products Commander ranked, and the sum that turns the share into the axis value.
- Sales score, indented under it: the score that the axis ranks, and the inputs it blends with their weights.
- Composite Popularity (Y axis) and Performance Score, read the same way. When the section scores add up to the Performance Score, the card shows the sum.
The info icons in Composite Sales and Composite Popularity show the same rank and the score behind it. When a product has the top or the bottom rank, the card says why it does not show +100 or -100. Product scores explains this.
A dash in Opportunity score, Sales, Behavior or Demand means Commander has no score for that product. It has not scored it yet, or had no order data for it in its latest scoring run. A dash in CX means the product has no review data. A product with no sales in the last 30 days shows Not scored in Quadrant.

The Why? panel and the selection bar appear on demand. See the steps above.
What to do with it
| What you see | Decision or action | Owner |
|---|---|---|
| Top and bottom rows by Opportunity score | Decide which products to push, fix or drop. | ecommerce manager |
| Star or Hidden Gem in Quadrant | Choose these for ads. Run the ads in Meta Ads Manager or Google Ads, outside Commander. | media buyer |
| Return % in yellow or red | Find out why customers return the product. Act in Shopify admin or with your supplier, outside Commander. | ecommerce manager |
| Margin shows N/A | Add the cost per item to your products in Shopify admin. Commander has no screen to enter it. | ecommerce manager |
| An Opportunity score order that does not match what matters in your store | Change the weights in Performance Score weights. | ecommerce manager |
| Ticked rows and Export CSV | Download the products for a spreadsheet or to share. | ecommerce manager |
| Ticked rows and Generate creatives (N) | Open the batch screen with those products, then choose one and generate. | creative strategist |
| See Synthesis on a row | Open Creative synthesis for that product. | creative strategist |
Expected value and measurement
To check a decision, compare over equal periods:
- Revenue, Margin, Repurchase and Return % for the product in Insights > Products > Product List. Orders covers a longer period than Revenue and Margin.
- Ad results for products you promoted in Performance > Ad performance, grouped By product.
Promotions, price changes, seasons and new ads usually run at the same time. Commander cannot isolate the effect of one action.
Limitations and exceptions
- A dash in a score cell is unknown, not low. Opportunity score, Sales, Behavior and Demand need order data from the latest scoring run. CX needs review data. A product with no sales in the last 30 days shows Not scored.
- Avg predicted revenue is an estimate of lifetime revenue, not profit.
- With no match, the table shows "No products match". Try clearing the search, quadrant, or minimum-orders filters.
- If the list fails to load, the table shows "Couldn’t load products" with the reason. Reload the page.
- If an export fails, the message Export failed gives the reason. Run Export CSV again.
- In Demo Mode, the Update data actions are simulated and do not change the demo data. Generate creatives opens the batch screen on sample data. It makes sample images and stores nothing in your store.