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. It's possible to format the output depending on the data it contains. It is also possible to merge several data fields in one "cell" by using the Group with the Next Column
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
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 at least one product by clicking the checkbox by the product. You can select all at once with the Select all checkbox at the top of the list.
Click the new Update button to open the menu on the right side of the screen, which includes several batch update options:
- Product: Set manufacturer, product status, type, or other settings
- Price: Change or clear price and price records
- Category: Manage category assignments
- Family: Assign family to the products
- Flag: Set or unset product flags
- Parametric: Update parametric values
Choose your action and set the desired value
Optionally you can check Keep selection for next batch to preserve your selection of products after the action has taken effect.
Click Batch Update to apply changes, or Cancel to undo.
- 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 |