Skip to main content

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.

The Add filter menu in the Norce Commerce product list with the list of available filters

Product data filters in the Norce Commerce product list​

The Norce Commerce product list has these filters for product data and dates:

FilterSeveral valuesDescription
ManufacturerYesManufacturer shows products from the selected manufacturers.
FamilyYesFamily shows products that belong to the selected product families.
AssortmentYesAssortment shows products in the selected assortments.
TypeYesType shows products of the selected product types, for example structure products.
StatusYesStatus shows products with the selected product statuses.
ActivatedNoActivated 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.
CreatedNoCreated takes a date range and shows products by the date the product was created in Norce Commerce.
Translation RequestedNoTranslation Requested takes a date range and shows products by the date a translation was requested for the product.
Duplicate urlNoDuplicate 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:

FilterSeveral valuesDescription
Price listYesPrice 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 ruleYesPrice 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.
SupplierNoSupplier shows products that the selected supplier supplies.
CompetitorNoCompetitor shows products that have competitor data from the selected competitor. The Best competitor value shows products that have data from any competitor.
OnhandNoOnhand 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.

FilterDescription
Part numbersPart numbers shows the products with the part numbers you enter.
Variant codesVariant codes shows the products with the variant codes you enter.
Ean codesEan 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:

FilterDescription
Missing contentMissing 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 valuesManually 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.
FlagsEach 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.
ParametricsEach 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.

FilterDescription
Relates to part numbersRelates 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 numbersIncluded in part numbers shows products that are related products of the products with the part numbers you enter.
Relates to variant codesRelates 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:

GroupFieldsNotes
Text fieldsName, Description, Sub description, Sub header, Description headerEach entry finds products where that text field is empty.
Price fieldsPurchase cost, Unit cost, Recommended price, Catalog price, Standard priceThe 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 imageMain image, Alt textAlt text finds products whose main image has no alt text.
Additional imagesOne entry per image file type, and Alt textEach file type entry finds products without an image of that type.
RelationsOne entry per relation typeEach relation type entry finds products without a relation of that type.
CategoriesPrimary category, Additional categoriesPrimary category finds products without a primary category. Additional categories finds products without any additional categories.
SettingsActivation date, Expiring date, Unit of measurement, Actual weight, GS1-codeEach entry finds products where that setting is empty.
FlagsOne entry per flag groupEach flag group entry finds products without any flag from that group.
ParametricsOne entry per parametricEach 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:

GroupValuesNotes
Price fieldsVAT 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.
SettingsHide in top list, Locked status, Unit of measurement, Actual weight, Commodity code, Stock break point, Dropshipping onlyHide 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:

FieldSource
PartNoSKU
Integration PartnoSKU
ERP NameSKU
Reference PartnoSKU
NameProduct, all cultures
Variant NameProduct, all cultures
ManufacturerProduct, all cultures
Manufacturer PartnoProduct, all cultures
SynonymsProduct, all cultures
EAN codesProduct, all cultures
PartNoSupplier
Category NamesOther
Category Default SynonymsOther
Product Family NamesOther
Needs Verification

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.

The Edit columns dialog in the Norce Commerce product list with the Add column field list open and the styles of each column

Layout and grouping styles for product list columns​

These styles control the layout of a column in the Norce Commerce product list:

StyleDescription
Group with next columnMerges 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 alignAligns 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:

StyleDescription
BoldShows the value in bold text.
Strike throughDraws a line through the value. It is often used for a recommended or original price that a sale price replaces.
Small textShows the value in a smaller font size, to de-emphasize secondary information.
Capital lettersShows the text in uppercase.
In parenthesesWraps 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:

StyleDescription
IntegerRounds the numeric value to a whole number, with no decimals.
PercentageRounds the value and adds a % sign, for example 25%.
CurrencyFormats the value as an amount in the current currency, following the current VAT display setting.
DateFormats 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:

StyleDescription
ImageReads the value as one or more image URLs, separated by commas, and shows them as thumbnail images.
BadgeShows 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 tabShows 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:

StyleDescription
Hide if blankLeaves the cell empty when the field has no value.
Hide if valueHides 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:

  1. Set the filters and columns you want in the product list.
  2. Go to Tools > Save report. The Save as report dialog opens.
  3. Enter a Name.
  4. 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.
  5. Click the star next to Favorite to show the report as a tab above the product list.
  6. 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.
  7. 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.

The Save as report dialog in the Norce Commerce product list

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:

  1. 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.
  2. Go to Tools > Export as Excel. The option shows when the list has products and Excel export is active for your client.
  3. 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.
  4. 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:

  1. Go to Products > Products and filter the product list down to the products you want to change.

  2. 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.
  3. 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.

    The Norce Commerce product list with one product selected, the Update button and the batch update pane open on the Manual tab

  4. On the Manual tab, open a group under Action and pick the action. Admin lists only the actions for fields your role can edit.

  5. Set the values for the action, for example the price list and the price for Set price.

  6. To keep the same products selected for another update, select Keep selection for next batch.

  7. 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:

GroupActions
ProductSet 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
PriceSet price, Inactivate price, Activate price, Set catalog price, Set recommended price, Set previous price, Is discountable
CategorySet primary category, Add category, Remove category
FamilySet primary family, Add family, Remove family
FlagSet flag, Remove flag
ParametricSet 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.