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
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 |
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
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
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 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
Go to Tools > Batch Update
A new menu bar appears with different action categories:
- Products: Set manufacturer, product status, type, or other settings
- Price: Change or clear price and price records
- Categories: Manage category assignments
- Flags: Set or unset product flags
- Parameters: Update parametric values
Choose your action and set the desired value
Select products to update:
- Check Batch 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, can only be done on the first result page.
Click Batch Update to apply changes, or Cancel to undo.
- You can only perform one type of update at a time, but
- Your product selections remain active between batch operations until you exit the product list result. This makes it possible to make several updates after each-other.
- When viewing products (Variants checkbox is not set), updating variant-level data will affect all variants within the selected products
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 |