List products in Norce Commerce
The product list in Norce Commerce Admin is where you work with many products at once. You open it under Products > Products. In the Norce Commerce product list you find products with filters and search, choose which columns to show, save the result as a report or dashboard, export it to Excel, and change many products at once with batch update.
Filter products in the Norce Commerce product list
Filters narrow the Norce Commerce product list down to the products you want to work with. Click Add filter above the list and pick a filter. Type in Search filter to find a filter by name. Each active filter shows above the list, and you remove it with the cross next to its name.
How Norce Commerce combines filters in the product list:
- Different filters combine, so a product must match every active filter to be listed.
- In a filter that takes several values, such as Manufacturer, a product matches if it has any of the selected values.
- In flag filters, a product matches if it has any of the selected flags within one flag group. Flags from different flag groups must all be set on the product.
- The category tree next to the product list filters on categories. Selecting a category also lists the products in its subcategories.
The Variants checkbox above the Norce Commerce product list switches between one row per product and one row per variant. Filters, the Excel export and batch update all work on the rows the Variants checkbox selects.

Product data filters in the Norce Commerce product list
The Norce Commerce product list has these filters for product data and dates:
| Filter | Several values | Description |
|---|---|---|
| Manufacturer | Yes | Manufacturer shows products from the selected manufacturers. |
| Family | Yes | Family shows products that belong to the selected product families. |
| Assortment | Yes | Assortment shows products in the selected assortments. |
| Type | Yes | Type shows products of the selected product types, for example structure products. |
| Status | Yes | Status shows products with the selected product statuses. |
| Activated | No | Activated takes a date range and shows products by the date each SKU first got the status Active, read from the SKU's status history. When a SKU has no status history and is Active now, Norce Commerce uses the date of the SKU's last status change instead. |
| Created | No | Created takes a date range and shows products by the date the product was created in Norce Commerce. |
| Translation Requested | No | Translation Requested takes a date range and shows products by the date a translation was requested for the product. |
| Duplicate url | No | Duplicate url shows products whose unique URL name in the current culture is a duplicate, so Norce Commerce adds a number to make the URL unique, for example {slug}-77239822. |
Price, supplier and stock filters in the Norce Commerce product list
The Norce Commerce product list has these filters for prices, suppliers, competitors and stock:
| Filter | Several values | Description |
|---|---|---|
| Price list | Yes | Price list shows products that have a price in the selected price lists. The price fields in the Missing content filter and the VAT option in the Manually overridden values filter need a Price list filter. |
| Price rule | Yes | Price rule shows products whose price uses the selected price rule, set either on the price or as the default price rule of the price list. |
| Supplier | No | Supplier shows products that the selected supplier supplies. |
| Competitor | No | Competitor shows products that have competitor data from the selected competitor. The Best competitor value shows products that have data from any competitor. |
| Onhand | No | Onhand shows products with an on-hand value greater than zero in the selected warehouse. |
Code list filters in the Norce Commerce product list
The code list filters in the Norce Commerce product list take a list of codes, one code per line. You can paste a column of codes from Excel.
| Filter | Description |
|---|---|
| Part numbers | Part numbers shows the products with the part numbers you enter. |
| Variant codes | Variant codes shows the products with the variant codes you enter. |
| Ean codes | Ean codes shows the products with the EAN codes you enter. |
Content, flag and parametric filters in the Norce Commerce product list
The Norce Commerce product list has these filters for product content:
| Filter | Description |
|---|---|
| Missing content | Missing content shows products that have no value for one selected field, such as Description, Main image or Primary category. Find products with missing content lists the fields. |
| Manually overridden values | Manually overridden values shows products where one selected value is set directly on the product or price. Find products with manually overridden values lists the values. |
| Flags | Each flag group is a filter of its own, listed under FLAGS in the Add filter menu. A flag filter shows products that have the selected flags. |
| Parametrics | Each parametric is a filter of its own, listed under PARAMETRICS in the Add filter menu. Text and HTML parametrics can't be used as filters. Number and date parametrics take a range, yes-or-no parametrics take a yes or no, and list parametrics take one or more values. |
Relation filters in the Norce Commerce product list
The relation filters are listed under RELATIONS in the Add filter menu. They show only when product relations are active for your client, and they take a list of part numbers or variant codes, one per line.
| Filter | Description |
|---|---|
| Relates to part numbers | Relates to part numbers shows products that have a relation to any of the products with the part numbers you enter. Use it to find every product that relates to a product you are replacing. |
| Included in part numbers | Included in part numbers shows products that are related products of the products with the part numbers you enter. |
| Relates to variant codes | Relates to variant codes shows products that have a relation to the products with the variant codes you enter. It shows only when variants are also active for your client. |
Product relations explains how relations are set up.
Find products with missing content in the Norce Commerce product list
The Missing content filter in the Norce Commerce product list shows products that have no value for a field, for example products without a description, a main image or a primary category. Use it to find products that still need content before they go live.
The Missing content filter takes one field at a time. You can't combine two Missing content fields in one filter. To find products that miss two fields, filter on the first field, add the PartNo column and export the list to Excel. Then clear the Missing content filter, paste the part numbers into a Part numbers filter, and add a Missing content filter for the second field. Different filters combine, so the list shows the products that miss both fields.
The Missing content filter offers these fields, grouped as in the filter:
| Group | Fields | Notes |
|---|---|---|
| Text fields | Name, Description, Sub description, Sub header, Description header | Each entry finds products where that text field is empty. |
| Price fields | Purchase cost, Unit cost, Recommended price, Catalog price, Standard price | The price fields need at least one Price list filter. A product that has no price at all in the selected price lists isn't listed. |
| Main image | Main image, Alt text | Alt text finds products whose main image has no alt text. |
| Additional images | One entry per image file type, and Alt text | Each file type entry finds products without an image of that type. |
| Relations | One entry per relation type | Each relation type entry finds products without a relation of that type. |
| Categories | Primary category, Additional categories | Primary category finds products without a primary category. Additional categories finds products without any additional categories. |
| Settings | Activation date, Expiring date, Unit of measurement, Actual weight, GS1-code | Each entry finds products where that setting is empty. |
| Flags | One entry per flag group | Each flag group entry finds products without any flag from that group. |
| Parametrics | One entry per parametric | Each parametric entry finds products without a value for that parametric. |
Find products with manually overridden values in the Norce Commerce product list
The Manually overridden values filter in the Norce Commerce product list shows products where a value is set directly on the product, SKU or price, instead of being left empty so that Norce Commerce uses the inherited or default value. Use it to find products that don't follow your price list or product defaults. The filter takes one value at a time.
The Manually overridden values filter offers these values:
| Group | Values | Notes |
|---|---|---|
| Price fields | VAT Code (current sales area), Is discountable, Is not discountable, Price rule, Supplement charge %, Supplement charge # | VAT Code (current sales area) needs at least one Price list filter. Is discountable finds prices explicitly set as discountable, and Is not discountable finds prices explicitly set as not discountable. The other price values find prices where that field has a value. |
| Settings | Hide in top list, Locked status, Unit of measurement, Actual weight, Commodity code, Stock break point, Dropshipping only | Hide in top list, Locked status and Dropshipping only find products where the setting is turned on. The other settings find products where the setting has a value on the product or SKU. |
Price list inheritance explains how prices inherit values.
Search the Norce Commerce product list
The search box above the Norce Commerce product list finds products by text. Type at least two characters and press Enter, or pick one of the options that show under the search box:
- A plain search lists products where every word you type is in the product's search text for the culture selected in Admin, in any order. It also lists products whose part number starts with the text you type. Misspelled words don't match.
- Part number, Mfr. partno and Id list only the products where that field matches the whole text exactly. The EAN code option works the same way, and its label is the one your client uses for the EAN code field.
The search text in the Norce Commerce product list is built from these fields:
| Field | Source |
|---|---|
| PartNo | SKU |
| Integration Partno | SKU |
| ERP Name | SKU |
| Reference Partno | SKU |
| Name | Product, all cultures |
| Variant Name | Product, all cultures |
| Manufacturer | Product, all cultures |
| Manufacturer Partno | Product, all cultures |
| Synonyms | Product, all cultures |
| EAN codes | Product, all cultures |
| PartNo | Supplier |
| Category Names | Other |
| Category Default Synonyms | Other |
| Product Family Names | Other |
The list of fields in the product list search text is carried over from an earlier version of this page. It requires validation against the current search index.
Customize the columns in the Norce Commerce product list
You choose which columns the Norce Commerce product list shows. Go to Tools > Edit columns, use Add column to add the columns you need, and click Set columns. When a saved report is open, the button is Save columns and saves the columns to the report. Reset to Norce default sets the columns back to the built-in default at any time. The columns you choose are also the columns in the Excel export.
For example, to show stock in the list, add the OnHandValue column. To export product descriptions, add the description column before you export.
Each column can be given one or more styles that control how its value is formatted, aligned or hidden. You can combine several styles on the same column.

Layout and grouping styles for product list columns
These styles control the layout of a column in the Norce Commerce product list:
| Style | Description |
|---|---|
| Group with next column | Merges this column visually with the column to its right. The border between them is removed and the second column's label is hidden. Use it to show related values together, for example a currency code next to a price. |
| Right align | Aligns the cell content to the right. Use it for numeric columns such as prices, counts and percentages. |
Text formatting styles for product list columns
These styles format the text in a column of the Norce Commerce product list:
| Style | Description |
|---|---|
| Bold | Shows the value in bold text. |
| Strike through | Draws a line through the value. It is often used for a recommended or original price that a sale price replaces. |
| Small text | Shows the value in a smaller font size, to de-emphasize secondary information. |
| Capital letters | Shows the text in uppercase. |
| In parentheses | Wraps the value in parentheses, for example (25%). It is often combined with Small text to show a supplementary value. |
Value formatting styles for product list columns
These styles format the value in a column of the Norce Commerce product list:
| Style | Description |
|---|---|
| Integer | Rounds the numeric value to a whole number, with no decimals. |
| Percentage | Rounds the value and adds a % sign, for example 25%. |
| Currency | Formats the value as an amount in the current currency, following the current VAT display setting. |
| Date | Formats the value as a date. |
Special rendering styles for product list columns
These styles change how a column in the Norce Commerce product list renders its value:
| Style | Description |
|---|---|
| Image | Reads the value as one or more image URLs, separated by commas, and shows them as thumbnail images. |
| Badge | Shows the value as a colored badge. For known status fields, such as product status or order status, Admin picks the badge color and icon from the status. |
| Open tab | Shows an external-link icon that opens the related record, such as the product, order or customer, in a new browser tab. |
Conditional visibility styles for product list columns
These styles hide a value in a column of the Norce Commerce product list:
| Style | Description |
|---|---|
| Hide if blank | Leaves the cell empty when the field has no value. |
| Hide if value | Hides this column's value when another column you pick has a value. Use it to avoid redundant data, for example to hide a part number when a variant count is shown. |
Save the Norce Commerce product list as a report or dashboard
A report saves the filters and columns of the Norce Commerce product list, so you can open the same view again or export it. To save a report:
- Set the filters and columns you want in the product list.
- Go to Tools > Save report. The Save as report dialog opens.
- Enter a Name.
- Choose the Access level:
- Private: only you can see the report.
- Application: every user with access to the application can see the report.
- Client: every user in every application of the client can see the report.
- Click the star next to Favorite to show the report as a tab above the product list.
- Optionally, select Use report as standard view under Standard view to open the product list with this report by default. To undo it, open the report again and clear the checkbox. A report that isn't the standard view can use Inherit columns from standard view to take its columns from the standard view.
- Click Save.
To create a dashboard widget from the product list instead, go to Tools > Create dashboard. The Save as dashboard dialog asks for a name, a layout and an access level. The Dashboard page explains the widget layouts.

Export the Norce Commerce product list to Excel
You can export the Norce Commerce product list to an Excel file. The export uses the current filters and columns, and the Variants checkbox decides whether the file has one row per product or one row per variant. To export:
- Set the filters and columns you want to export in the product list. Add a column for every field you need in the file, for example a description or a parametric.
- Go to Tools > Export as Excel. The option shows when the list has products and Excel export is active for your client.
- In the Export as Excel dialog, choose the options:
- Translate fields: { inherit } writes
{inherit}for inherited name and text fields, so a later import of the same file keeps them inherited. Inherited value writes the inherited text instead. - Flags & Parameters: Code exports flags and parametrics as codes, and Name exports them as names in the current culture.
- Value lists: Create value lists in export adds a sheet per list field, so you can pick values from a dropdown in Excel. The file gets bigger.
- Translate fields: { inherit } writes
- Click Export as excel.
The Tools menu of the Norce Commerce product list has two more exports for the products in the list:
- Export relations exports the product relations of the listed products. Variants are not relations, so the file is empty when the products have no relations.
- Export files and images exports the files and images of the listed products. Import and export images and files explains the file.
Batch update
Norce batch update changes many products or variants in the Norce Commerce product list at once, without exporting and importing an Excel file. Batch update opens from the product list when you select products. It isn't in the Tools menu.
Before you batch update products, ensure the following:
- Your Admin role can edit the fields you want to change. Batch update lists only the actions for fields your role can edit.
- You have checked the Variants checkbox if the change should apply to selected variants rather than to whole products.
To batch update products:
-
Go to Products > Products and filter the product list down to the products you want to change.
-
Select the products:
- Tick the checkbox on each row you want to change.
- Or tick the checkbox in the list header, Select all, to select every product in the result set, including products on other pages. If you then untick some rows, batch update skips those rows.
-
When at least one product is selected, the number of selected products and an Update button show above the list. Click Update. The batch update pane opens to the right of the product list.

-
On the Manual tab, open a group under Action and pick the action. Admin lists only the actions for fields your role can edit.
-
Set the values for the action, for example the price list and the price for Set price.
-
To keep the same products selected for another update, select Keep selection for next batch.
-
Click Batch update. Norce Commerce updates the products and shows "All selected products have been updated." Click Cancel to close the pane without changes.
Batch update runs one action at a time. When the Variants checkbox is cleared, the list shows products, and an action on variant-level data changes all variants of the selected products.
When AI enrichment is enabled, the batch update pane also has a Translate tab and an AI Generate tab. These tabs start a background job with Start job instead of Batch update. AI enrichment explains both tabs.
Batch update actions in the Norce Commerce product list
The Manual tab of Norce batch update has these actions:
| Group | Actions |
|---|---|
| Product | Set manufacturer, Set status, Set type, Set width, Set height, Set depth, Set actual weight, Set volume weight, Set commodity code, Set recommended quantity, Set stock break point, Set dropshipping only, Remove main images, Request translations |
| Price | Set price, Inactivate price, Activate price, Set catalog price, Set recommended price, Set previous price, Is discountable |
| Category | Set primary category, Add category, Remove category |
| Family | Set primary family, Add family, Remove family |
| Flag | Set flag, Remove flag |
| Parametric | Set parametric, Remove multiple parametric |
The actions in Norce batch update are fixed, and you can't add your own. Batch update changes product data only: it doesn't change the sort order of products in a category or the settings of a parametric itself.