Item Management 2020

Item segmentation

Filtering improvements (Work ID: 189194)

Filtering on measures are using centimeters. A problem with time range in date fields is fixed.

System

Item free-text search error handling (Work ID: 185966)

The item free-text search is using the search engine ElasticSearch. If updating ElasticSearch fails, the indexing job will retry to make sure the search data is updated.

Import

Using price calculation rules in import (Work ID: 188805)

Import of Pricat both from supplier and own brands, and import from Temalogic, are using price calculation rules defined in import rule or included in import file. The same business rules are applied as described in relation to price calculation in import rules.

• Pricat for suppliers (itemUnplanned): Prices created from an import rule use the specified price calculation rule, and cost price values are applied from the used import rule. Wholesale price, rec. retail price (sales price) and supplier discount (cost price) are taken from import file. If the calculation rule does not have supplier discount, then this value is ignored. Prices can be updated using import when the same price calculation rule is applied. It is not possible to update price using different price calculation rule since validation error appears on an import line. 

• Pricat for own brands (Pricat itemPlanning): Creating and updating all types of prices is possible when importing Pricat for own brands. When creating new price, price calculation rule is taken from the import rule. When updating existing prices, the same rule must be set in the import rule used as the one used to create this price. If not, validation error will appear. Value1, value2, etc. in the price contract are mapped one-one with the rank of our rule set rows (e.g. value5 is mapped to the fifth rule set row), however, summation rows are skipped.

• Import from Temalogic (using API, with only planning code and no price from date): Creating new ordinary prices is not possible with import from Temalogic. It is, however, possible to create campaign/member prices and for these the same calculation rule as on the existing ordinary price (active in time of campaign/member price start) is applied. Difference between planning code on the imported campaign/member price and the existing ordinary price does not matter - rule from the ordinary price with corresponding date range is used. When updating existing prices using Temalogic, the same rule is automatically applied as the one used to create this price. Value1, value2, etc. in the price contract are mapped one-one with the rank of our rule set rows (e.g. value5 is mapped to the fifth rule set row), however, summation rows are skipped.

System

Showing long texts in user interface (Work ID: 189234)

Long texts without spaces in fields will be wrapped.

User management

Access to stores for new users (Work ID: 191567)

Self provisioned users will by default not get access to any stores. This has to be given by administrator users.

Changing language (Work ID: 189149)
When user selects to change language and saves, the language will change immediately.

Item details

Item image in Item details overview tab (Work ID: 180985)

Images that do not fit the frame will be resized to fit the frame but without changing proportions or being truncated.

Item image in Item details overview tab (Work ID: 181986)
When there is only one color (variant) with image the same image will be displayed for all other items with no image in Color section. It takes the first item by size order and displays thumbnail image on all items in this color.

Item segmentation

Permission for item segmentation (Work ID: 182485)

Item segmentation has permission for "View item segmentation" and "Manage item segmentation". With "View item segmentation" permission the user can only view and export the segmentations, but cannot modify or recalculate (re-run the segment).

Price

Valid from filter with 'is equal to' operator (Work ID:182080)

When filtering with valid from the local time-zone is used.

System

Notification activity (Work ID: 184946)

In the notification grid the activity value shows what initiated the notification. Current values are Segmentation, Import and Export.

User management

System administrator role (Work ID: 188686)

All permissions are available for the System administrator role.

Export

Message about export (Work ID: 186894)

When the user starts exporting to Excel, an information message about starting export is shown and disappears after 5 seconds.

Segmentation

Fix for filter with 'Equals' (Work ID: 188350)

Segmentation with 'Equals' filter is again working as expected.

Item details

Fix for 'Change GTIN' button (Work ID: 187153)

'Change GTIN' button is available after clicking 'Manage item' button.

Bugfix for related items (Work ID: 187993)
Related items can be removed from both non-model items and model items with only one item.

Register

Rounding rules (Work ID: 178811)
Name of Rounding rec. retail price register is changed to Rounding rules, and is used for both Recommended retail price and store retail price. Prices can be rounded to for example 9,99 (two decimals). 

System

Multi-select (Work ID: 180096)
When searching and adding values to multi-select fields it is not possible to add/select the same value twice.

Price

Overlapping campaign period (Work ID: 185158)

Overlapping price of same price type is not allowed, but for example member price and campaign price can have overlapping campaign period.

System

Web framework upgraded (Work ID: 185135)

Item Management is using Angular 10.

Export to Excel

Notification when Excel file is ready to download (Work ID: 181014)

When exporting items or prices to Excel the user will get a notification when the file is ready to download, or if an error occurred. The file can also be downloaded (later) when selecting view all notifications. This new feature makes it possible to export larger files with many items, without getting a timeout after 10 minutes. Please note that large export will take some time. A test with export of all item attributes for a given brand with 161.000 items resulted in a file of 96MB (161K rows x 180 columns), and took approx. 90 minutes to generate.

Export to Excel (Work ID: 175090)
The generated Excel file will get file name with date and hour based on the local PC settings. Date is generated based on time when clicking 'Export to Excel', not when the file is ready for download (in notifications).

Price

Column picker in price calculation and store prices grid (Work ID: 178775)

Column picker and new columns is added to Price calculation and Store prices grids. Locked columns feature has been implemented for them with drag and drop and resize columns functionalities. There is a navigation link (same as in item grid) on column 'Valid From' (both in Price calculations and Store prices). 'Valid From' column must always be visible and it is not possible to hide it. 

System

Fix for loading of menu (Work ID: 185083)

A minor issue related to loading the menu is fixed.

Global design change for buttons (Work ID: 178485)
Design and texts for buttons are modified to handle many buttons in a mobile view. Only buttons with enough space are displayed. New 'expand' button is added, which expands buttons grid and displays all of them.

User management

Synchronizing stores to User Management (Work ID: 183199)

Permission can be defined for specific stores or groups of stores. Stores are therefore synchronized from Store Management module (StoreService), using jobs in integration package IdentityServiceIntegration. The jobs are responsible for getting changes on stores from blob and moving them to staging tables in Identity database (StagingImport). Then from staging tables stores are imported to the actual store tables (StagingMerger). StagingMerger is run on Cron trigger with every 10 seconds as default. Default we do 10 retries when a data row is not processed first time. Default batch size is 5000 rows. StagingImport is triggered on change in blob (batchtoprocess > store).

Store permissions (Work ID: 180487)
Users can get access to selected stores, teams or profiles. User roles can be defined as common or for specific profiles, teams or stores. After access to a store is taken away from user, roles with access to this store are automatically deleted from this user. Role type cannot be changed after being created. 

This feature will not be in use before permissions for store prices is released later in October/November.

Import

Copy import rules (Work ID: 177676)

When copying import rules, all profile attributes (including price calculation values) are copied to a new import rule. 

Item segmentation

Filter on blank values (Work ID: 180519)

When creating segmentation groups it is possible to filter by blank values. Blank values means NULL and empty string. User can include or exclude on all attributes (except boolean attributes with value True/False).

Price

Fix for date validation conflict (Work ID: 182715)

When editing an existing member or campaign price (both for price calculation and store prices), the date validation triggered on the price itself saying there was already a price on this date. This is fixed.

System

Translations to Norwegian and Swedish (Work ID: 182138)

Several translations to Norwegian and Swedish in Item Management are reviewed and modified.

Import

Bugfix for ‘More’-button for imports (Work ID: 184014)

User can change supplier for import with permission 'Manage imports' and view error text for Import with permission 'Access to system tasks and information'.

Item details

Notification when segment is calculated (Work ID: 182833)

Calculation a segment may take several minutes. User will be notified when the calculation of a segment is finished.

Register

Fix for brand registration (Work ID: 183709)

Fix for registration of many brands without leaving the registration screen.

Import

Validation of concession import files (Work ID: 183935)

When concession price file is imported, we validate to identify duplicate prices. Validation error appears in case of a duplicate: "Duplicate price" on all lines except the first for a given item in a file. If the import status is reverted to Ready for import, then it is possible to import the same price again. Concession flag on item is checked after an item concession price is imported for this item. The flag can be edited in Item details. It is not possible to import prices for items whose brand is not a concession brand. New validation error appears in such case: "Item brand is not marked as concession".

Item details

Functions in Model-color view (Work ID: 182142)

“New mass update" button is visible both in "Item view" and the "Model-color” view.

Color and size in save dialog (Work ID: 182148)
After fix, the format is: {color} {size} when items are listed in Save/Edit dialog.

Leading and trailing spaces in item text (Work ID: 183203)
When there are leading or trailing spaces in the fields Item text, Label text 1, Label text 2, Receipt text or Brand text, the spaces will be removed during import.

(We have run a script to fix existing items with leading or trailing spaces).

System

Field validation (Work ID: 179410)

When validating fields we display both red frame and error text after changing focus from field.

Import

Faster opening of import rules (Work ID: 173751)

Opening of import rules takes approx. 1 second. Previously it often took more than 10 seconds.

Validation when adding new size to existing model (Work ID: 179447)
When adding new size to an existing model, a warning is displayed in import details: "New size will be added to model". This will for example help the user to avoid creating new size 6.5 when size 6,5 already exists.

Non-model items (Work ID: 169105)
It is not allowed to add color or size to a non-model item when importing or mass updating items. After validation of import the error message "Cannot add color or size to a non-model item" is shown in import details. Note that it is possible to change color on items which already have color or size.

Item details

Item overview tab (Work ID: 145956)
Core information and color section is added to overview tab. For model items it is possible to navigate between items by clicking on color names. When navigating to a color, the item with the selected color and the same size as we were on is opened, if the size exists. When selecting a color where the previously viewed size does not exist, the first size in the list is opened. Also, navigation from Model-color view in Items grid to Item details has been improved and now item with the correct color (selected in the grid) and size (the lowest sorting number) is opened. 

Item Segmentation

Attribute search (Work ID: 179536)

There will be displayed information when searching for attributes, which are part of item planning attributes, and planning code is not selected ("Your search criteria match attributes that require that planning code is selected. Please define a planning code before selecting these attributes.").  

Price

Percent conversion in filter columns (Work ID: 178599)

Percentage filters are fixed and show correct values (not multiplying with 100).

Register

Register descriptions (Work ID: 180955)

To improve usability all registers are described.

System

Improved upgrade process (Work ID: 177570)
Item Management is dependent on other common services (Shell and Tenant API) during startup. When such common services are not available, the module will retry to reach the services every 30 seconds until they become online.

Open menu in new tab (Work ID: 144121)
It is possible to right click on menu elements and open web page in a new tab or a new window.

Item Segmentation

Validation of attributes (Work ID: 179538)

When adding new attributes to a group, a red frame is shown when leaving the field without selecting any value with 'In list' operator.

System

Cleanup of staging tables (Work ID: 156124)

Staging tables are used when importing items. The ItemServiceJanitor job is running continuously to delete old staging data. The job deletes default maximum 100 rows, using maximum 10 seconds, older than 14 days .

User Management

View permissions (Work ID: 171661)

When selecting 'Edit...' permissions in user role details, check boxes for corresponding 'View...' permissions are selected automatically so the user does not need to remember to add them. The view permission cannot be unchecked until dependent permissions are unchecked.

Item details

Default selection of variant (Work ID: 178790)

When creating, editing, copying or deleting price, the currently opened color will be selected by default in the variant selection when working with a standard model or a model without sizes. When working with a model without color, the current size will be selected by default.

Show item images in Item overview (Work ID: 145955)
Item images can be fetched from a product management information system (PIM). This requires configuration of the integration that is based on a URL in combination with item identifiers.

Price

Ordinary price must exist before other price type can be created (Work ID: 176409)

It is not possible to create a member or campaign price for a date period for which there is no ordinary price calculation already added. When creating a new campaign/member price and some items in the model do not have an ordinary price in the period, a warning icon and message appears in the variant selection modal (same pattern as missing planning code on some items) and it is not possible to select these items since checkboxes are be disabled. For now, however, it is possible to have a situation where member/campaign price exists with no ordinary price in the same time period and for store prices also profile/team/store by deleting ordinary prices after member/campaign prices are created. This will be handled in the future.

System

Permissions (Work ID: 173753)

Permissions for exporting to Excel can be defined per user role, both for exporting to Excel from Item grid, from Item details and from Imports.

Export to Excel

Performance when exporting prices to Excel (Work ID: 179703)

Performance when exporting to prices to Excel from Segmentation and Import, and when there is a large amount of items in the item grid, is significantly improved

Import

Warnings and errors in import (Work ID: 174734)

In item import we can have up to 192 different validation errors and 192 different validation warnings.

Price

Store prices (Work ID: 159222)

In items details there is a tab for store prices. Later this will be used by price managers and store users to manage prices that will be exported to POS.

Register

Concession store register (Work ID:168099)

Register of store groups that is used in concession setup.

Export

Export of dangerous goods flag (Work ID: 164929)

Export data type is changed to boolean (True/False), and the export will no longer result in value NULL for dangerous goods.

Price

Filter by valid from (Work ID: 176237)

In price calculation tab it is possible to filter by valid from date.

Item details

Deleted planning codes excluded from Excel export (work ID: 175134)When exporting items to Excel, all rows with deleted planning codes are excluded from the export.

Faster update of existing items (Work ID: 173973)

Database indexed is modified to improve update of item fields on model level. We have not been able to measure the improvement, but users should experience that saving models with many items is a bit faster now than before.

Price

Business rules for proposed price calculation values when adding a new price calculation (Work ID: 173131)

• When adding next price while having one or more active prices, proposed price values are fetched from the the most recent active price, and in case prices that have the same Valid from date the values are taken from the one which was added first regardless of the planning code.

• When adding next price while having one ore more active and planned prices, proposed price values are fetched from currently active price.

• When adding next price while having one or more planned prices, proposed price values are fetched from the earliest price on the newest planning code (alphanumeric order on code value of planning code), and in case that prices have the same Valid from date and the same planning code, values are fetch from the one which was added first.

• When adding next price while having only an expired price, proposed price values are fetched from the expired price.

Preventing duplicate prices (Work ID: 175270)
A constraint is added to prevent possible duplicate entries in prices for profiles/stores.

Import

Create new item when GTIN must be changed on existing item (Work ID: 174423)

When importing file with already existing GTIN, but different supplier/supplier model number, and supplier model number value already exists on other item, the user can select to fix item identifier. This means that we will auto-generate a new GTIN for the existing item, and that the new item will be added to the same model as existing item with same supplier model number and same supplier.

When importing file with already existing GTIN, but different supplier/supplier model number, and supplier model number value already exists on other item, the user can select to fix item identifier. This means that we will auto-generate a new GTIN for the existing item, and that the new item will be added to the same model as existing item with same supplier model number and same supplier.

Validation of duplicate size sorting number (Work ID: 172299)
When there are items with duplicate size sorting value, it will not be possible to import new or update existing items for the model. In item import validation error is shown: 'Sorting number overlaps within color'.

System

Better performance when creating new items (Work ID: 173163)

New items added to existing variants are created much faster. Before improvements, adding new items to variant which caused copying planning codes, prices etc. took a lot, up to 10 seconds measured on the development environment. Now it is reduced to 0.2 seconds.

Item details

Export to excel and mass update of sorting and display size (Work ID: 166697)

When exporting items to Excel, columns for size sorting (variant sorting) and display size (consumer-friendly size) are included in the Excel file. Sorting and display size fields can be updated in item import, for example when using mass update with Excel file. Sorting cannot be empty and is omitted when importing file with NULL or empty field and its value stays unchanged in case of updates or is taken from size in case of creating new items. 

Import item details: Columns are hidden by default and can be added using the column picker. All columns are visible in exported Excel only when 'Item details from import file' option is selected in Export to Excel popup. Display size and Sorting columns are visible when all fields are exported for Item details from active items' option, but not visible when selecting 'Limited fields'.

Item details export: Check-boxes for Display size and Sorting are added at the end of Model section in Export to Excel view.

System

Permission for viewing exception messages (Work ID: 172838)

Users that should be able to view system exception messages must have permission 'Access to system tasks and information' added to user roles together in permission group 'System'. User without this permission is not able to see error messages when status on the whole import or an import item is 'Error'. Please note that this is mainly used by EG Retail (DevOps role).

Import

User interface changed in import details view
Toolbar in Import details view has been improved. Buttons have been re-arranged. 'Update items from file' button has been renamed to 'Modify file'.

Item details

Colours with spaces in primary color
If you create an new model item and you select a color from the list in the field ”Primary color”, and the primary color you choose contains spaces, the user get a message telling that spaces in front or end of the text are not allowed. To register this colour on the new item the user needs to edit the value of “Display colour” (copied from primary colour) and remove spaces. When the user edit the value in “Display color”, the user could create the new item.  New items gets the value defined in display color.

Earlier you wasn’t able to create new item if you selected a primary color with spaces.

Price

Bugfix: Wholesale price not set to null
Correct wholesale price (also in currency) is shown when 'Valid from/to date' is modified and 'Planning code' is changed.

Register

Item hierarchy

When adding a line from Group/Area/Department details view, values in Parent hierarchy section are read-only.

Import

Notification when last import failed

If the import fails when the user selects 'Import selected items', a notification with 'Error' is displayed in the breadcrumb in the top of screen.

Item details

Add related items

Related items are by default always added on 'this item'. User can still select to also save it on selected colors/sizes or all items within model.

System

Export to Excel

Export to Excel is running a an asynchronous system job. Files will be saved for user on created date order (first user gets first file). Files won't be exported in parallel. Once one file is exported, export of another one is started. 

Timeout set in job for database query is configured to 5 minutes. Timeout for response to users download it is set to 10 minutes. 

Persistant grids 
Validation filter in import grids are kept (persistent) during tab session between pages. Filter is cleared when refreshing the page. Selection of Item/Model-color view and search/filters option is persistent per user. Switching between search and filters in item grid clears previously chosen filtering option and applies to both views at the same time.

Finding import file that failed
Logging in Application Insights includes FlatBatchJsonId which makes it easier to identify the file that caused the error.

Import

Truncate of item text, color and size

When item text, color or size is longer then 50 characters (maximum value in database and user interface) only the first 50 characters of these values will be saved. 50 characters is also the maximum value for supplier color and supplier size.

Item details

Fix for item subgroup

Subgroup is added as separate column to model, and export of item group value is correct when subgroup is added to item.

Price

Formatting of price calculation

Formatting has been improved in price calculation tab when creating next new price so that the view is clearer for user.

System

Update of grid component

The grid component (Kendo) is updated to the latest version which supports virtual columns and other performance improvements. "Change detection" time is now dependent on number of visible columns and increases with the increase in visible columns number.

Message logging when validation has failed
When validation fails in StagingBatchExecutor job we log a user-friendly error message (and not the whole stack of failure) to make it easier to read the alerts from Application Insights.