Comparison report

Compare the product status on a sales channel with the status in PIM; find products that should be active but are not.

Comparison report places the product status on a sales channel (marketplace or WEB store) side by side with the status in PIM: whether the product exists on the channel, is salable in PIM, has stock and photo, and what the channel's last response was. E-commerce and catalog teams use this report to find products that "should be on sale but are not" or "remain open although they should not be on sale" and to read the reasons from channel messages.

Report data is prepared periodically; the screen fetches this prepared report. The report does not run automatically: you need to select the channel and press Run report. Once the report is loaded, views, search, column filters, sorting, and grouping are applied instantly on the loaded rows without rerunning.

Accessing the screen

• Follow the path PIM & Catalog › Operations › Comparison report in the left menu.
• The link "You can access transfer results here." in the rules list on the Category mapping screen also opens this screen.

If you do not see it in the menu, your account does not have permission for this screen.

Screen sections

1. Title: Comparison report and its description.
2. Selection card: fields Company, Channel, Barcode, SKU, Option code, with a speed hint below and the Run report button.
3. Report header: When the report loads, shows record count, report date, channel, and duration. If the report is old, a warning strip appears below.
4. Report card: From top to bottom, quick views and search, Group by line, active filters line and buttons Clear selections, Columns, and Export, table and pagination.

Running the report

1. Select Company and Channel.
2. If looking at a specific product, fill one of the fields Barcode, SKU, or Option code. Leave empty to get the entire channel.
3. Press Run report or press Enter while in a code field. The button is disabled if no channel is selected.
4. While loading, a "Downloading report… … sec" counter and, if previously measured, a note "(last time took ~… sec)" appear. Company and Channel fields are locked during this.

If you do not filter, the entire catalog of the channel is loaded and the report may take minutes. Narrowing by barcode, SKU, or option code is much faster.

While loading, the Run report button changes to a red Cancelled button. If cancelled, "Loading cancelled" is shown; you can enter a code and rerun narrowed.

Each run resets quick view, search, filters, sorting, and grouping. Pressing Run report again with the same channel and codes fetches fresh data.

Company, channel, and code fields are kept in the page URL; opening the link brings the same selections but the user must press Run report to see the report. Since view, search, filter, sorting, and grouping reset on each run, these settings are not preserved in the link; the user must reapply them. Reloading the page also requires rerunning the report.

Report header and freshness

When loaded, the table top shows "… records · Report date: … · channel" and "Duration: … sec". If the report date is 1 day or older, a warning "This report was prepared yesterday, may not be current." or "This report was prepared … days ago, may not be current." appears. If rows come from different report days, it is noted below the table that the header date is the first row's day.

View, search, and filters

Quick views

Search

The Search SKU, barcode or message box applies as you type. It searches SKU, barcode, option code, product ID, mapped message, message code, and channel response case-insensitively. The "… / … rows" count on the right shows visible and total rows.

Column filters

Each column header has a filter icon.

1. Click the icon. All distinct values in the column are listed with row counts, most frequent on top. Empty values show as "(empty)". Yes/No columns show Yes and No, date columns list days.
2. Narrow values with the search box in long lists. Up to 300 values show; if more, "… more values; narrow with search." appears.
3. Check desired values. Select all (…) or if searched, Select all matching (…) selects all listed values.
4. Press Apply. Clear removes this column's filter.

Selecting multiple values in one column keeps rows matching any of them; filters on different columns combine with AND logic. Filter options are calculated from rows matching other active filters. The filter icon of active columns is highlighted.

Active filters appear above the table as "Column: values" labels; clicking the × removes that filter. If no filters, a hint on how to filter is shown.

Clear selections

Clear selections resets quick view to All, clears search, column filters, grouping, and sorting. The button shows the count of active filters. The report is not rerun.

List

The table shows 50 rows per page by default (20, 50, or 100 selectable).

Sorting: Clicking a column header sorts ascending, second click descending, third click clears sorting. Empty values appear last in both directions.

Header menu: Right-click a column header to see options Sort ascending, Sort descending, Clear sorting, Group by this column (or Ungroup this column), Clear all grouping, Clear this column's filter, and Hide column.

Columns: Show or hide columns from the Columns menu. Your choice is remembered in your browser.

Default visible columns:

Columns hidden by default but available from Columns menu: Product ID, Product modified, List ID, Channel parameter, Integration, Salability code, Catalog, Locked on channel, Blacklisted on channel, Archived on channel, Suspended on channel, Frozen on channel, Rejected on channel, and Warehouse group.

If Yes/No columns have no value, "—" is shown. This does not mean "No"; it indicates no record exists for that product on the channel.

Row actions

Each row may have two buttons at the end:

• Product detail: Opens the product's PIM detail page in the same tab. Not visible if no product ID in the row. You need to rerun the report after returning.
• Report history: Lists report rows for this barcode on the same channel in a box, newest first. Columns include Report date, Comparison, Exists in PIM, Photo, Stock, Salable in PIM, Salable on channel, Channel response time, Channel response, and Mapped message. You can track how the barcode's status changed across reports. History is fetched separately when the box opens; the main report is not rerun. Not visible if no barcode in the row. If no records, "No history records for this barcode" is shown; if history cannot be fetched, History could not be loaded and Retry appear.

Actions

Grouping

Use to group rows by one or more columns to see distributions. For example, quickly see why products remain passive by grouping by message.

1. In the Group by line, press Add group level and select a column. Up to 4 levels can be added. Right-clicking a header and choosing Group by this column does the same.
2. To group by message with one click, press Group by message; this sets grouping only on the Mapped message column.
3. Added levels appear labeled "1st Column", "2nd Column", etc.; the × on the label removes that level.

When grouping is active, a group table is shown instead of the row table. A summary "… groups · … rows" appears above; if multiple levels exist, Expand all and Collapse all buttons appear. Largest groups are on top.

Export

1. Press the Export button.
2. Under the Entire report (… rows) heading, select Excel (.xlsx) or CSV (.csv).
3. If you narrowed rows by view, search, or filter, a Filtered rows (…) heading appears; select it to export the filtered rows in current sorting.

Only visible columns are written to the file. Entire report rows are exported in the report's original order; Filtered rows are exported in the on-screen order. Yes/No values are exported as text, dates in local format. The file name starts with "compared-" and includes the channel and report date. CSV uses semicolon as delimiter. While preparing the Excel file, the button shows Loading; if the file cannot be generated, a "File could not be generated" notification appears.

Statuses

Common situations

• "Report has not been run yet" is shown. The report does not run automatically; this message also appears when refreshing or returning from another screen. Select a channel and press Run report.
• "Report could not be loaded" is shown. An error occurred while fetching the report. Retry with Retry; if the problem persists for the entire channel, narrow by barcode, SKU, or option code.
• Report takes too long. Running without filters loads the entire channel catalog. Stop with Cancelled and rerun narrowed by barcode, SKU, or option code.
• "No report data" was returned. If run without filters, no report has been prepared yet for the channel; wait for the first run if the channel is new. If narrowed by code, check the value or clear filters and run for the entire channel.
• Channel list is empty. The selected company has no product sending channel ("There is no product sending channel in this company."). Select another company.
• "No rows match filters" is shown. No rows match the combined view, search, and column filters. Use Clear selections to return to the full report.
• The column I want is not in the table. The column may be hidden. Open it from the Columns menu.
• The report looks old. The report is prepared periodically; the freshness warning indicates the report date is older than today. Row statuses reflect that day; check the latest status in product detail.

Related screens

• Products — detail
• Sales status
• Category mapping
• Sending logs