List products
This is the main page of Norce product management. From here you can handle your products in bulk by exporting them, do batch updates or create your own views and dashboards
Filters
First step to working with products in bulk is typically to find the products that you want to work with. This can be done by filters. There are a number of filters that can be applied:
| Filter | Comment |
|---|---|
| Manufacturer | |
| Family | |
| Assortment | |
| Type | |
| Status | |
| Activated | Filter products based on when they where created |
| Price List | |
| Price rule | |
| Supplier | |
| Competitor | Filter products based on which competitors have them in stock |
| Onhand | Filter products that have on hand value greater than zero for a particular warehouse |
| Part numbers | A list of part numbers. Paste from Excel, separated by space or line feed |
| Variant code | A list of variant codes. Paste from Excel, separated by space or line feed |
| EAN codes | A list of EAN codes. Paste from Excel, separated by space or line feed |
| Missing Content | Filter products that lack data on any of the following fields: Name, Description, Sub Description, Sub Header, Description Header, Main Image |
| Created | Filter products based on when they where created |
| Translation requested | Filter products based on when translation was requested |
| Duplicate url | Find products that have duplicated unique urls, and must rely on an id as suffix to make them unique. Example: {slug}-77239822 |
| Flags | All flags can be used to filter products |
| Parameters | All parameters excluding text parameters can be used to filter products |
Customizing columns
In the product listing you can set which columns that you want to display. Go to Tools > Edit Columns to add or remove different columns. You can also Restore to Norce default to reset the column configuration back to the built-in default at any time.
Each column can be given one or more styles that control how its value is formatted, aligned, or conditionally shown. Multiple styles can be combined on the same column.
Layout and grouping
| 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. Useful for showing related values together, e.g. a currency code next to a price. |
| Right align | Aligns the cell content to the right. Typically used for numeric columns such as prices, counts, and percentages. |
Text formatting
| Style | Description |
|---|---|
| Bold | Renders the value in bold text. |
| Strike through | Draws a line through the value. Commonly used for a recommended or original price that is being replaced by a sale price. |
| Small text | Renders the value in a smaller font size, to de-emphasize secondary information. |
| Capital letters | Transforms the text to uppercase. |
| In parenthesis | Wraps the value in parentheses, e.g. (25%). Often combined with Small to show a supplementary value. |
Value formatting
| Style | Description |
|---|---|
| Integer | Rounds the numeric value to a whole number (no decimals). |
| Percentage | Rounds the value and appends a % sign, e.g. 25%. |
| Currency | Formats the value as a monetary amount using the current currency, respecting the current VAT display setting. |
| Date | Formats the value as a date. A DateTime variant also includes the time. |
Special rendering
| Style | Description |
|---|---|
| Image | Interprets the value as one or more image URLs (comma-separated) and renders them as thumbnail images. |
| Badge | Renders the value as a colored badge. For known status fields (product status, order status, etc.) the badge color and icon are chosen automatically based on the status. |
| Open tab | Renders an external-link icon that opens the related record (product, order, customer) in a new browser tab. |
Conditional visibility
| 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 selected column has a value. When enabled, you pick which column to check — if that column contains a value, this cell is left blank. Useful to avoid showing redundant data, e.g. hide a part number when a variant count is present. |
Reports and dashboards
Once you are happy with your filters and columns you can save these as a Report by navigating to Tools > Save Report.
- Give the report a name
- Set the access level
- Private - only visible to you
- Application - accessible for everyone who has access to the application
- Client - accessible for everyone
- Mark the report as Favorite if you want it to show up as a tab in the product listing for easy access
- If you mark it as Standard this will be your default report. To undo this, open the report settings again and uncheck the Standard checkbox.
Dashboards can be created the same way as reports but will show up in the dashboard menu instead
Excel exports
A report can easily be exported to Excel by going to Tools > Export as Excel. This will export all your configured columns to the standard Excel format
Batch update
Batch update allows you to make specific changes to many products or variants simultaneously. This feature enables quick bulk modifications without needing to export and import Excel files.
To use batch update:
- Filter your products to get the desired result set
- Select the products to update. Checkboxes are always available on the product list:
- Check Select All to update all products in your current result set, even if they are not shown on the page.
- Or manually check specific products/variants you want to update.
- An Update button appears on the filter row above the product list. Click Update to open the batch update pane on the right-hand side of the product list.
- The pane contains three tabs:
- Manual: the standard batch update actions, grouped into categories:
- Product: Set manufacturer, product status, type, or other settings
- Price: Change or clear price and price records
- Category: Manage category assignments
- Flag: Set or unset product flags
- Parametric: Update parametric values
- Translate: translate product texts into other cultures using AI. See AI enrichment in batch update.
- AI Generate: generate new product texts using AI. See AI enrichment in batch update.
- Manual: the standard batch update actions, grouped into categories:
- Choose your action and set the desired value
- Click Batch Update to apply changes, or Cancel to undo. Translate and AI Generate jobs instead run in the background and are started with Start Job.
- You can only perform one type of update at a time. Remember to check Keep selection for next batch to not lose your selection if you want to do several updates with the same selection of products.
- When viewing products (Variants checkbox is not set), updating variant-level data will affect all variants within the selected products
Product search
When searching for products the following fields are indexed.
| From SKU | From Product (all cultures) | From Suppliers | Other |
|---|---|---|---|
| PartNo | Name | PartNo | Category Names |
| Integration Partno | Variant Name | Category Default Synonyms | |
| ERP Name | Manufacturer | Product Family Names | |
| Reference Partno | Manufacturer Partno | ||
| Synonyms | |||
| EAN codes |