Import

Fix: Collection from import rule is not applied on item (RTC-12850)

Collection and Brand are copied from import rule in PRICAT import.

Timeouts in import validation (RTC-12526)

Validation of large import files are handled without timeout issues.

Item list

Delete item list (RTC-11612)

Item lists can be deleted. It is not possible to restore deleted item lists.

Maintenance and defects

Timeouts in import validation (RTC-12526)

Large import files are processed. Validation and import of that kind of file also succeed.

Import

Whitespace characters in GTIN (RTC-12248)

Whitespace characters are removed from GTIN field when importing new items.

Item list

Select/unselect from file (RTC-11075)

Items can be added to an item list using import of .csv file. In file's first row you must have a header (not hidden): ExternalItemNo (same as hidden key value from exported excel file for item no. ext.).

Support for GTIN and some improvements is coming soon.

Export item list to Excel (RTC-11869)

Items in an item list can be exported to excel, with the same functionality for selecting items and price columns as when exporting from item grid.

Create a copy of the item list (RTC-11614)

Item lists can copied and used as basis for new item lists.

Item search

Pasting values in Item search (RTC-12212)

Results are loaded when values are typed or pasted in the Item text search (ElasticSearch).

Import

Fix for mass-update of items: File failing in generic import (RTC-11832)

Edited Excel files, where some data columns were deleted or partially deleted are processed properly. Notifications return successful messages about import and file being uploaded.

Importing items from RIGAL item file (part 1) (RTC-913)

RIGAL item file is supported for import of new and update of existing items. Models are matched based on externalModelNo (Modellnr), or supplierModelNo (Bestnr) if the first is not provided. Imports can be filtered by RIGAL type in the Imports grid. Import supports the gzipped file type. The following warnings and errors apply in this import type: ImportItemError.ErrorType.ItemGroupMissing, ImportItemWarning.WarningType.BrandWillBeCreated, ImportItemWarning.WarningType.ColorWillBeCreated, ImportItemError.ErrorType.UnknownUnit, ImportItemError.ErrorType.VATCodeMissing.

Not all fields in RIGAL item file is updated, as this will be implemented later. Prices will be updated in release during May.

System

Logout (RTC-796)

When the user logout of Chain, he/she is redirected to the login page.

Import

Unexpected error while uploading Excel file (RTC-11337)

Edited Excel files, where some data rows were deleted or partially deleted are processed properly. Notifications return successful messages about import and file being uploaded.

Import of large files (RTC-711)

When large item files are imported the files will be divided into smaller parts and processed, to increase performance and reduce risk for failures.  

Technical: Includes upgrade to Entify Framework Core 3.1.

Price

Access to store prices (RTC-10097)

Access to the Store prices tab in Item details is given in the View store prices permission in the store type roles and in the SystemAdministrator common role. 

System

Filter out deleted items (RTC-11662)

Items with the flag isDeleted=1 in Item.Item table are not available in the Items and Models grids and in the Item list details.

Delivery dates

Wrong week value in the picker (RTC-7688)

When selecting a delivery date or an order deadline date with the week picker, Monday of the correct week is selected in the date picker.

General

Link columns instead of the arrows (RTC-7843)

In all grids where arrows were used to open line details, link columns are used instead. There are column pickers available for all the grids containing more than four columns. For such grids, columns are resizable and reorderable. 

Notifications

Navigation to all notifications (RTC-11221)

Users can open the notification panel and move to all notification grids (in User Management) from any module (Promotion, Item Management, User Management).

Register

Unique constraints on 'Code' for VatCode, Currency, Brand (RTC-8378)

It is not possible to save duplicated rows of codes for VAT, Currency and Brand.

System

Sign out when a user has no tenant access (RTC-11458)

After a user who has no access to any tenant logs in, they are automatically logged out and shown a message with a link to sign in with a different account. 

EG domains (RTC-3269)

EG cloud modules are prepared for changing the domain base address from LindbakCloud.com to EGRetail-Prod.Cloud.

Maintenance and defects

Fix for export of AllSeasons flag (RTC-10335)

'AllSeasons' flag is exported in boolean instead of number. 'AllSeasonsYear' is not exported anymore.

Mass updater of prices

Export to Excel and Modify file buttons (RTC-3870)

Export to Excel allows exporting selected lines to Excel unless any item contains 'Missing price calculation rule code' or 'Conflicting price calculation rule code' validation errors. In these cases, an error appears. To avoid trying to import lines without price calculation rule, the 'Price calculation rule' checkbox is marked and disabled in the Export prices to Excel view. Updating an import using Modify file results in replacing the existing import file with the new one, therefore the same validation rules apply as for a new import. 

User Management

Error message when user don't have access (RTC-9225)

When a user logs in with a valid Azure AD account that doesn't have access to any module in any tenant, an error message referring to missing access appears.

Concession

Handling of prices duplicated (RTC-846)

If item concession prices for the same item are sent in different files but are combined into one batch, the ChainIntegration job deletes all duplicates and leaves the last price imported (from the latest file) as the correct price.

Export of concession prices (RTC-7021)

In a situation when only a concession for specified stores exists (there is no concession for all stores corresponding to the item group and brand), import works correctly and prices are exported only for the specified stores. When all stores within this concession are inactive, no prices are created. 

Export

Export of dynamic price calculation (RTC-3569)

Export to blob (JSON) of items with price calculation is extended with priceCalculationRuleCode (code value of calculation rule). All prices despite the price calculation rule value are exported now. Also, store prices export enables the export of all prices (all calculation rules are also handled).

Extended also Import contract, including now 9 cost price amounts.

Price

Bugfix: Create store price on different store group (RTC-10869)

It is possible to create store prices with the same starting date for different store groups.

Import

Search for item in import using Supplier ModelNo (RTC-966)

Search for item in import using filter on Supplier ModelNo is fast due to index on SupplierModelNo in PricatImport.ImportItem table.

Import of RIGAL item file (RTC-9756)

RIGAL item file from any ERP system can be imported in Item Management, using the same standard flat-file format as defined for Chain Classic, with mapping to Item JSON. The first version of the import supports only basic item attributes. This will be extended in the coming months.

RIGAL file may be imported with or without the header as both cases are supported and the header is simply ignored by the GenericImport job. Corresponding VAT code is matched based on the VAT rate given in the RIGAL file selecting the first VAT code with the same active rate and Norwegian country code. If no such VAT code exists, the line fails.  For now, mapping is:

RIGAL -> Item Gateway

Nummer -> identifier.gtin (mandatory)
Artnr -> identifier.externalItemNo 
Varetek -> itemText (mandatory)
Bongtek -> itemReceiptText
Etitekst1 -> labelText1
Pakn -> unit (mandatory)

Modellnr -> modelNo
Farge -> color.text 
Storrelse -> size.text 
Variantnr -> VariantSequenceNo 
Fabrikat -> brand.externalNo 
Hgr -> itemGroupNo (mandatory)
MvaPercent -> VAT[0].Rates[0].Rate (mandatory)
Grossist -> itemSuppliers[0].identifier.externalNo 
Bestnr -> itemSuppliers[0].supplierModelNo, itemSuppliers[0].supplierItemNo (only if Grossist is defined)

Price

Use correct initial selection of price calculation rule (RTC-9738)

When creating a new price calculation, and the price calc. rule of the currently active price is inactive, the default register value is used as initial selection in the price calculation rule dropdown instead of the inactive rule in the dropdown.

Currency column is mandatory in mass update of prices (RTC-9966)

When exporting prices to Excel the currency column will be checked and locked automatically when checking any of the "Wholesale price in supplier currency" columns. Currency value is required for mass update of prices. If the currency is not present in the Excel file during import, it will result in an error.

Export

Ordering of data in export (RTC-9792)

Export procedures are modified to prevent potential problems related the ordering of data.

Price

Filter 'store group level' based on user permissions (RTC-9658)

When creating new store prices, values showed in the 'Store group level' section, and specific stores, teams, and profiles are filtered based on user permissions.

Register

Supplier register grid (RTC-921)

Added locked grid for Supplier register, with more columns displayed by default (GLN, Supplier, Manufacturer, Default).

Inactive item group (RTC-10188)

Fixed: The panel informing about an item group being inactive appears as expected when a group is deactivated. 

System

Column picker in grids (RTC-921)

In column picker the the ordering of fields is alphabetically. When adding a column to a grid it will be added at the end.

Column resize in all grids (RTC-811)

Column picker is available in all grids with are more than 4 columns. This allows users to select displayed columns from the column picker, change their size displayed in the grid and change their order in the grid.

Export

Export concession price (RTC-9791)

A bug related to sorting of data in export of concession prices (ItemConcessionPrice) is fixed.

Import

Date format from Excel (RTC-9527)

We support specifying dates with the "Date" cell-type, and with the "Text" cell-type using the date format "dd.mm.yyyy" (NO standard). For other "Text" formats it will fail.

In the future this will be handled more properly as part of validation of import file.

Price

Warnings when copying and editing prices (RTC-962)

When copying or editing prices, warnings in the variant selection modal are displayed the same as when creating prices. It affects three validation rules for wholesale price calculation:

• Missing planning code

• No ordinary price

• Different price calculation rule

and validation rules for store prices:

• No ordinary price

• Different price calculation rule

Price

User-friendly improvements for price calculation rules (RTC-729)

Improvements includes:

• In item registers, Price calculation setup view includes

  • Sorting and filtering.

  • Validation for rows in rules

  • Handling long names.

• Price calculation rule columns are added in Price calculation and Store prices grids

• The Price calculation rule field is filled out with a default rule if there is no price on an item or with a rule from an active price when creating new prices.

Access control for store prices (RTC-754)

Permissions for view, edit and create prices are defined per role in User Management. Roles are also assigned on store level, either to profile(s), team(s) and/or store(s). When working with store prices these role settings control what users have access to do.

Price

Price calculation rules in export and import of prices (RTC-3347)

Export prices to Excel includes price calculation rules. The rule that is set as default in the register appears by default in the Price calculation rule dropdown and can be changed. Whenever the price calculation rule is changed, columns change to reflect the rule. 

Price calculation rule must be provided in the imported file when mass updating prices. For now, prices using different rules can be created or updated in one file regardless of the column names - only keys are considered and are matched with columns in the corresponding rule. Prices must be updated using the same rule as the one on the existing price. 

Related validation errors:

• When price calculation rule column is not included in the excel file: "Missing price calculation rule code" 

• When trying to update an existing price with mass update using different price calc. rule: "Existing item cannot be updated with a different price calculation rule".

System

Using dropdown filter (Work ID: 189973)

When clicking in dropdown filter and the clicking outside the filter, this will not result in logging a bad request/failure.

Horizontal scroll in grids (Work ID: 190061)

The horizontal scroll in for example the item grid is improved for the non-locked area of the grid.

System

Update to .NET Core 3.1 (Work ID: 185890)

Item Management app is upgraded to development framework .NET Core 3.1. Security is improved by using Tenant API.

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.

System

Logic for obsolete permissions when doing rollback (Work ID: 182937)

If any module is upgraded and includes new user permissions, and a rollback of the upgrade is required due to for example bugs in the new release, the new permissions will not cause any problems for the old version of the module.

System

Information about inactive values (Work ID: 187040)

Text in panel for (example) deactivated user is displayed. Before it was white text on white background so user couldn't see it. It is fixed for inactive panels etc. in all places.

Import

Keep profile discounts when importing (Work ID: 183779)

In price calculation tab in import rule there is a flag for 'Keep profile discounts'. When using PRICAT import with the flag checked, profile discounts are taken from the previously existing ordinary prices for the same planning code on an item. Profile discounts are always copied from an ordinary price which is/will be active at the time when the imported price starts. It applies only for ordinary prices. If there exists only an expired price for given planning code, then values are copied from it. The flag has no effect on Temalogic import since import rules are not taken into account in this case.

Note: In case of adding a new size to an existing color by import, prices from a different (existing) item are copied to this newly created item. If the new item is imported together with new price info, discounts for this new price will be applied from the import rule just like there would be no other prices on this item. To have discounts copied from a different price (existing on different item and copied to this newly created item) new item must be created first with no new price info and the new price must be then added in a separate import.

Export

Export of external store number in Concession file (Work ID: 185943)

Export of concession contains external store number.

Item details

Mandatory fields (Work ID: 180492)

When creating/editing items it is required to add values for item name (item text, receipt text, label text 1), unit, VAT code, item group and supplier.

User management

Swedish language (Work ID: 174185)

User management module supports languages English, Norwegian and Swedish.

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.

Export to Excel

Export prices with supplier details to Excel (Work ID: 180524)

When exporting prices to Excel, supplier details like supplier name, supplier model number etc. can be included as columns in the export.

Import

Notifications when import is ready (Work ID: 181008)

When an import is validated the user will be notified. The notification will inform about the import status and result of the validation, and the user can click on the notification link to navigate to the import details view.

The following notifications are supported:

Success:

• Import of {Import name} has been finished (with info of number of imported items)

• {Import name} has been revalidated (with info of number of validated items)

Warning:

• {Import name} has been revalidated (with info of number of validation errors/warnings)

Error:

• Import of {Import name} has not been done

• {Import name} has not been updated

• {Import name} has not been revalidated

• Import of {Import name}  has been partially completed (with info of how many items were imported and not)

• {Import name} has been partially revalidated (with info of not validated items, validated ones, validation errors and warnings)

Export

Export of concession store prices (Work ID: 168102)

When concession is configured, store prices for concession items are exported from the Concession.ItemConcessionPrice table to the Gateway.ItemConcessionPrice blob. Any 3rd party can subscribe to these store prices, but standard we use the ChainIntegration package (OnPrem) in Integration Platform to receive store prices and update them in Chain Classic.

Export of concession register (Work ID:168101)

When change tracking is configured, concession register with commission percent per group of brand/stores/item groups is exported to 3rd party subscriber (Gateway.Concession blob). For contract description, see Concession in https://itemservice.lindbakcloud.com/.

System

Application header (Work ID: 173781)

An information bar at the top of screen is shown when using Test or UAT environment. The application header is default hidden in production environment. Edit user profile and select 'Show application header' to show or hide. For EG Retail employees it is recommended to always show the application header to indicate which tenant (customer) the user is logged in to.

Import

Import of concession price files (Work ID: 168104)

Price files from suppliers of brands with concession setup can be imported to create stores prices that will be exported and used in POS.

Such import has ApprovalRulesetId=5 in PricatImport.Import table. If an applicable concession does not exist, validation fails with "concession setup missing"-message. Validation fails also when no brand is added to item or item is not found. Imported lines are stored in Concession.ItemConcessionPrice table. VAT rate and commission percentage for stores are needed for price calculation. If no VAT code is added to an item, it is assumed to be 25%. Commission percentage is taken from the concession. Since concession overlapping is possible, a priority hierarchy is used when searching for the right concession to be applied. The most important within a brand is concession for a specific store and item groups. Then, for specific item group and all stores, and then for specific store and all item groups. The least important is concession for all store and item groups. Concession price imports are visible in Imports grid with new price type - Concession, and not all buttons are available in such import details. 

Validation errors possible when importing concession prices:

1. Item not found - if there is no item with given identifiers in the database.

2. Unknown brand  - if there is no brand on an item for which price was imported.

3. Concession setup is missing - if there is no concession setup for given configuration of brand, item group and store.

System

Save changes dialogue (Work ID: 179413)

When leaving filter group in Segmentation or Supplier details in the Supplier register, we display “save changes” dialogue to let users save changes before leaving. When clicking save and some validation is triggered - we display correctly red frame and validation error in the grid.

Import

Bugfix: Duplicate prices (Work ID: 183020)

Fixed an issue with duplicated prices when importing items to existing colors with same price date from.

Import file without values for supplier color/size (Work ID: 180500)

When creating new items from import or adding new items to existing model, both color/size and supplier color/size is set to the same value if only color/size has a value in the import file.

System

Synchronization of stores (Work ID: 179533)

In EG Cloud the StoreService is master for stores. For now the store register is synchronized from Chain Web OnPrem to StoreService. ItemService is subscribing to changes in StoreService, and will keep a synchronized register of stores that is used for example when defining store groups for concession.

Price

Validation of store prices (Work ID: 178776)

It is not allowed to set retail price to 0. It is allowed to set 0,01.

Filtering in price tab (Work ID: 177988)

In price tab it is possible to filter also on price type and order type. Filters in these grids are persistent when changing items using drop downs in breadcrumbs. They are cleared when tab is changed or page is refreshed. 

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.

Import

Bugfix for import of own brands (Work ID: 179890)

Own brand files can be imported without failing.

Import

Filtering in Size control (Work ID:177677)

Fixed two issues in Size control view of Import details (Imports > Import details > button 'Size control'):

• All filters filter when you press the "ENTER" key after typing in a value.

• The "Status" column filter no longer causes all other filters to be ignored.

Item details

From Product information to Product classification (Work ID: 177680)

The field section containing 'EN standard', 'Healthy' etc. is renamed from Product information to Product classification in item details and when exporting to Excel.

System

No auto-complete (Work ID: 147387)

Autocomplete has been removed from all fields in Item management.

Logging of failures when exporting to Excel (Work ID: 173755)

When exporting to Excel we log metadata in Application Insights that makes it easier to identify what caused the problem, for example the SQL query that was used.

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.

Error

EN Translation

NO Translation

ItemNoFound 

EN: Item not found

NO: Varen ble ikke funnet

PlanningCodeNotFound 

EN: Unknown planning code

NO: Ukjent planleggingskode

StoreGroupNotFound 

EN: Unknown store group

NO: Ukjent butikkgruppe

CollectionNotFound 

EN: Unknown collection

NO: Ukjent kolleksjon

MarketingExclusivityNotFound 

EN: Unknown marketing exclusivity

NO: Ukjent markedseksklusivitet

AssortmentNotFound 

EN: Unknown assortment code

NO: Ukjent sortimentskode

SalesPurposeNotFound 

EN: Unknown sales purpose

NO: Ukjent salgsformål

SeasonNotFound 

EN: Unknown season

NO: Ukjent sesong

MarketingCodeNotFound 

EN: Unknown marketing code

NO: Ukjent markedsføringskode

ReplenishmentCodeNotFound 

EN: Unknown replenishment code

NO: Ukjent etterfyllingskode

ProcurementRuleNotFound 

EN: Unknown procurement rule

NO: Ukjent innkjøpsregel

UnitNotFound 

EN: Unknown unit

NO: Ukjent enhet

ItemTypeNotFound 

EN: Unknown item type

NO: Ukjent varetype

SupplierNotFound 

EN: Unknown supplier number

NO: Ukjent leverandornummer

VATCodeNotFound

EN: Unknown VAT code

ItemGroupNotFound 

EN: Unknown item group number

ReportCategoryNotFound 

EN: Unknown report category

NO: Ukjent rapporteringskategori

ManufacturerNotFound 

EN: Unknown manufacturer

NO: Ukjent produsent

BreakBulkCodeNotFound 

EN: Unknown break bulk code

NO: Ukjent anbrekkskode

SeasonCodeNotFound

EN: Unknown season code

NO: Ukjent sesongkode

ServiceLevelNotFound 

EN: Unknown service level 

NO: Ukjent servicenivå

Error

EN Translation

NO Translation

SubstitutionItemNotFound 

EN: Unknown substitution item

NO: Ukjent erstatningsvare

BrandNotFound 

EN: Unknown brand

NO: Ukjent varemerke

SerialNumberTypeNotFound 

EN: Unknown serial number type

NO: Ukjent serienummertype

CountryOfOriginNotFound 

EN: Unknown country of origin

NO: Ukjent opprinnelsesland

ClassificationNotFound 

EN: Unknown classification

NO: Ukjent klassifisering

SpecialGroupNotFound 

EN: Unknown special group

NO: Ukjent spesialgruppe

OriginalPlanningCodeNotFound 

EN: Unknown original planning code

NO: Ukjent opprinnelig planleggingskode

Warning

EN Translation

NO Translation

CostCarrierModified

EN: Cost carrier is modified

NO: Kontohenvisningskode er endret

ColorModified

EN: Color is modified

NO: Farge er endret

SizeModified

EN: Size is modified

NO: Størrelse er endret

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

Export

Export currency rate to cash register

Active currency sales rate can be exported. Cash registers (POS) are standard receivers of this export type.

161183

Import

Fix for filtering in validation errors and warnings

Filtering in import item grid is again working as it should when navigating between pages

173780

Item details

Export items to Excel

When exporting items to Excel from the item grid, the query to the database is split into batches of 1500 items, making it possible to export large amount of items without causing a timeout in the export job. Export of items will be quite fast when filtering by brand, item group and cost carrier in the item grid.

168106

System

Swedish language

User can select between Norwegian, English and Swedish language in Item Management module.

Swedish language in User Management module will be implemented soon.

172663

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

171868

Item details

Colours with spaces in primary colour

If you create an new model item and you select a colour from the list in the field ”Primary colour”, and the primary colour 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 colour”, the user could create the new item.  New items gets the value defined in display colour.

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

166424

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.

173125

Register

Item hierarchy

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

171101

Item details

Faster opening of item details view

Opening item details from item grid should normal take approx. 1 second. Depending of how many model-color and sizes it might take slightly more time.

170289

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.

172298

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.

169398

System

Export to Excel

Export to Excel is running a an asynchronuous 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.

164602

170333

168898

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.

169174

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.

170836

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.

170517

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.

168097

171116

Import

Delete import

When deleting an import the user is redirected to the item grid.

Selecting supplier for an import

After selecting supplier for an import, the import grid is refreshed.

169590

170332

Item details

Deactivation of item

Minor improvement in user interface related to buttons.

170246

System

External item number

'External item number' has been renamed to 'Item number' in all views and export Excel file. 'Subst. Item no. ext' has been renamed to 'Subst. Item no.' and 'Item in package ext. no' to 'Item in package no' in export Excel file.

169233

Item details

Removing a planning code

It is not possible to remove a planning code using edit item generation dialog. Error message appears for colors that had the planning, but are now deselected from all profiles in this edit popup. The save button is disabled until at least one profile is selected for the color. It is possible to save if selected profile is a 'new' profile which was not marked for this color previously. 

169422

Price

Missing planning code

A warning 'Missing planning code' will appear if there are no planning codes linked to the item. Minor improvements to performance and error handling.

170175

Import

UTC time format

Database server can be in a different time zone than the uploaded files.

Error handling of duplicate items in import file

If an import file contains duplicates of the same item it will not cause any error when importing, but only one of the rows will be imported.

Column for supplier model number in item import

Columns for 'Supplier Model Number' and 'Current Supplier Model Number' are available for all types of import when viewing items within the import.
Column 'Supplier Model Number' is hidden by default for PRICAT type of import and is not hidden by default for other types of import (Default/Temalogic/Mass Update-Item Details). In this case user has to choose it from column picker to see it in the grid. 
Column 'Current Supplier Model Number' is hidden by default for all types of Import (PRICAT/Default/Temalogic/Mass Update-Item Details) and user has to choose it from column picker to see it in the grid.

169640

169390

169435

Item details

Validation of bundle quantity

Bundle quantity field is validated. If user adds value higher than 2147483647 a warning is shown to the user, and there will be no error in the application logs.

170034

System

Logging of user activity

We use Azure Application Insights for logging and tracing of all processes and user activity. The users e-mail address is logged as AuthId parameter in AppInsights and name and surname in user interface and audit columns in the database (CreatedBy, ModifiedBy).

Update of translations

After a new release a refresh of the page is enough for new translations to appear correct for the user.

155416

169102

Import

Validation when item has fixed item identifier error (TFS: 169175)

Don't link items when non-model item has fixed item identifier error.

When there is an import file with fix item identifier (with update existing items option) for item, and there are new items with same model identifier (supplier model number), it won't try to connect/merge non-model items with other items into same model. Model items will be added to different model (new model number will be created).

169175

Item details

Caching of data in item grid (TFS: 167390)

To improve usability the item grid is cached so that loading the grid is not requested when navigating back from item details to both Items and Model-Color grid. After adding new items they will appear at the top of the grid even if filters are applied. Although the grid is not loaded again, any changes made to items are visible right after going back from Item details.

167390

Import

Split of supplier models

When Pricat import results in split on items within supplier model, all items from the same model in this import will be imported, even when only one item is selected.  A warning message is displayed when this happen.

Faster loading of items in import view

Added index to load the items much faster in import details view.

156740

Price

Clearing currency field and validation of discount

When clearing currency field and choosing another currency, the price is created without any errors.

It is not possible to set supplier discount value greater than wholesale price, or set wholesale price lower than the supplier discount value. The same rule applies to discount and sales price.

Recalculation when changing currency

A recalculation of prices is triggered when the currency is changed.

169884

169404

Export

Item export is faster

When items are updated this triggers an export to all subscribing systems. The performance is increased significantly, especially when there are many planning codes/prices per item.

If the export fails the job will be displayed with status Faulted, and tracked in our monitoring of the item module.

169177

Import

PRICAT import from Excel file

When import of PRICAT is done by uploading an Excel file, it will get filetype PRICAT and use the same import rules as PRICAT from EDI/suppliers.

168446

Price

Handling of exceptions in browser

When trying to create a price for an item with no planning code we show a warning (instead of a browser error).

165176

Import

Price when using text format in Excel

If price columns in Excel are formatted as text, the price will be updated correct.

169451

Item details

Improved error handling

Buttons for 'Select model' and 'Cancel' are greyed out when the view is loading, to prevent starting new requests while previous request is taking place.

Validation of GTIN

When 'GTIN already exists on another item' validation message appears on the lines with the same GTIN while adding new model or items to existing model, it disappears when the first/second GTIN is edited. When creating model/item, adding new item to existing model or updating GTIN, validation for GTIN field works correctly now - negative values are handled and 'The minimum value for this field is {value}' validation error appears.

Setting supplier as main

When setting supplier as main, store group level field becomes disabled in Edit item supplier popup.

169125

166901

168521

Price

Copy calculation to other profiles

"Copy price" button has been relabeled when creating or editing new price calculation.

Improved user experience in Price calculation

Price calculation details view is optimized to improve the user experience.

168090

164583

Import

Use mass update to set fields to blank value

The item fields Serial number type, Report category, Item category and Substitution item can be set to blank value (cleared) by using the value NULL in the mass update.

168605

Item details

Bugfix in 'Add item generation'

The function for adding item generations to for example other variants for given model is fixed.

169154

Import

Profile is mandatory in import rule

For import rules it is mandatory to select at least one profile before saving. This prevents error situations where items are updated without profile prices.

Improved error handling

Import job will not create alerts when validating imported files (often from mass update) and the file for example has the wrong format or there is a missing item group. Such import jobs will have status completed.

165551

167642

Item details

Sorting when adding a new color

When adding an item to an existing model, the size sorting will be copied from existing size in other variants (colors) if all sizes within model have the same sorting number), otherwise sorting number is copied from size register. The same business rule is used when importing items.

162849

Price

Warning when planning code does not exist

When editing price and selecting to save for (model/color) items without the given planning code, user will get error message; “The item must contain planning code {planning code}. The price will not be edited if the planning code is missing”.

Performance improvement when changing price type

The user should not experience any delay in the user interface when creating new price and changing price type from ordinary to campaign price.

167405

167812

Import

Validation of supplier when main supplier is changed

When the item that is imported has a new supplier, you will get validation failed/supplier deviation. If you change the main supplier in item details to the same supplier as in the file and re-validate the import file, the item will be ready for import. Alternatively, you can use the function for 'fix item identifier errors for selected items.' 

Import supports items with many suppliers in the same file, but only one main supplier (if not, import will fail with validation error). If none of the suppliers in the import file has IsMain-flag set to True, it is assumed that the first one listed is the main supplier. 

165625

Mass update

Update of original planning code

After bugfix it is possible to modify original planning by using mass update with import of Excel file.

168425

System

Improved startup of item management

Loading of configuration after login is optimized, and time from login to opening item grid is reduced by 100-500 ms.

163962

Export

Export of delivery dates

When items with item generations are exported, delivery dates are sorted by ascending delivery dates numbering (delivery dates externalNo in ItemService API).

168267

Item details

Alphanumeric descending sorting of planning codes

When adding item generation and selecting planning code, the planning code is sorted alphanumeric descending.

166846

Import rules

Add freight is default

When creating Import rule, 'Add freight' is default set to True.

166132

Item details

Set main supplier

When the user selects the main supplier, the supplier window/page is kept open so other values can be edited before closing and returning to item details. 

Supplier color code when adding items to variant

When adding new items to an existing variant (model-color) supplier color code is copied to item details.

Deleting item generation

Deleting an item generation (planning code and related planning code attributes) could be necessary when created by mistake. When deleting an item generation this also triggers deletion of prices with this planning code.

166370

166383

166675

Import

Improve error handling when importing marketing codes

Import with marketing codes is possible when import rule flag 'Copy attributes from previous item generation' is set to True.

Better performance when updating existing items

The performance is improved for update of existing items when importing Pricat file. In test environment we measured the performance to be improved from less than 1 item per second to 16,4 items per second after the change.

164379

164733

Item search

Only active items in search dialog

When searching for items in free text search only active items are shown.

163835

System

Logging of failed imports

When any approval import fails the logging is providing important details in the log in Application Insights.

We have added details for error on validation scheduled: SupplierModelNo, ImportId, ScheduledFor, ApprovalRuleset, FlatBatchId.

When we get error on import scheduled we have added details for: ImportItemId, UpdateType, ItemId, ModelId, ImportRuleId, ImportId, ScheduledFor, ApprovalRuleset, FlatBatchId.

165860

JSON example:

  "identifier": {
    "sku": "0012342938470",
    "gtin": "7012342938479",
    "externalItemNo": "0748392432100"
  },
  "stockStatus": [
    {
      "unitInStock": true,
      "storeGroupLink": {
        "type": "Private",
        "name": "Store group name",
        "externalNo": "Wholesaler 1234"
      }
    }
  ]
}

Work ID

Import rules

Change of supplier or supplier model number in Pricat file

Improved error handling for change of supplier or supplier model number when GTIN is missing from import file.

Deactivated import rule

An error message is shown when the user tries to import items with a deactivated import rule (which was active previous in the validation process).

162209

166802

System

Technical: Removed spam from logs in Application Insights

Internet robots will not create failures in our logs.

Improved performance when releasing new version

When releasing a new version we swap from old version to the version without any down-time. The new version is “warmed up” before the swap if finished, so users should experience very little performance decrease.

Duplicated results in grid when filter/refresh

Users should not experience that duplicated results in for example item or import grid when filtering or refreshing fast (before first query if finished).

165581

164639

165918

Work ID

Export

Expired prices are exported for 72 hours

Expired prices are exported for 3 days after expiration. This should be enough for subscribing systems if error situations should occur at 3rd party side.

158810

Import

Planning attributes are copied from newest planning code

When new items are added to a variant (model-color) which has a planning code, it will copy planning attributes from the newest planning code. The same business logic is used both when adding items manually or importing.

163014

Item details

Fix when saving item subgroup

Item subgroup can be saved and modified without problems.

Package code shows TU/CU in model-color grid

Problems fixed so it does not show value 1 or 2.

Information message when deactivating item that is linked to another item

If the item you try to deactivate is either:

• A related (alternative or any other type) item to some other item (which is active)

• A part/’child’ of a bundle (which is active)

• A substitution item to some other item (which is active)

• An item in a package (which is active)

Then you are not allowed to deactivate this item and a message is shown in deactivation popup.

164893

165493

164045

Item search

Start search in grid by pressing Enter or clicking on filter icon

When filtering/searching in grid columns the search will be performed after leaving field/pressing Enter key or clicking on filter/search icon.

164586

Item details

Improved performance when opening item

Opening item/model from item grid is much faster, especially when scrolling down before opening a selected item.

Manage item generations

When opening manage item generations, we show available planning codes for given item/model. By default only “Current” planning codes are visible. In colors column we show which colors that are linked to the planning code, with specific colors or “All colors”.

Improved performance when searching in drop-down fields

When searching several times in register values in drop-down fields user should not experience slowness.

Validation of external item number

When models have duplicated items due to migration of data (same size & color), it is possible to update them, change size etc. Adding new items is still impossible, and will create error situations in import of PRICAT that must be handled by support.

Import

Import of item relations

Import of item relations is re-implemented to optimize further maintenance of the code. All of add/edit/remove related items works the same way. It is possible to remove related items reference with empty list, and the same for bundle content. For Excel import user needs to add parent item with empty value for content or add NULL value. It is not possible to add a related item which are in the same model, nor duplicates within same type or the same item. It is possible to add the same item for different relation types.

'Update items from file' in Import

'Update items from file' button is disabled for imports with status Imported. When status is Partially imported, only not yet imported items are updated.

Error handling for items without GTIN

Items can be added to a model where one of the items are missing GTIN.

Item details

Saving models with many items

We have fixed performance issues related to item plannings and supplier details, and verified that models with 500 items can be modified and saved without problems.

Item search

Scrolling in item grid

Scrolling in item grid is improved to handle filtering with locked columns.

System

New design for Item Management

The Lindbak logo is replaced by the EG logo. Design is modified to use EG green color in the top bar.

Export

Decimals in currency rate

Currency rates are exported with 4 decimals (not rounded to 2 decimals).

Item search

Cost carrier column in item grid

Cost carrier columns added to item grid, directly after brand column and by default hidden. Filter on this column with default sorting can be done with good performance.

Item details

The first supplier on item is automatically set as main supplier

When adding supplier for the first time, it will be common and added as main supplier. When user goes back from 'item suppliers' (3rd level) grid, we have removed loading of item again, so it moves much quicker back to item details grid.

Import

Validation for currency in imports

Currency is validated in item imports preventing imports of currencies that are not existing in currency register. If a user imports an item that has a currency that does not exist, the validation will fail with the message "Unknown currency".

Import: All sizes are updated with new color even if they are not in the import file

When updating color in import, but not for all items, there will be displayed a warning 'Color for variant will be updated' and after the import the whole variant's color will be updated. For size validation still works as before.

Price calculation

Validation of price calculation fields

Validation has been added to the following fields:

• Wholesale price

• Recommended retail price

If invalid values are added to these two fields (0) the box will turn red. If a user still attempts to create a price with invalid values, a warning will be displayed at the top of the price calculation and the price will not be created.

Item details

Validation message if reaching highest value for external item number when adding new items

When creating new items and external item number is reaching it’s highest value, a validation message will be displayed both in “New item” and item import.

Error messages:

Highest number for size in external item number, XXXXXXXXX990, is reached
Highest number for color in external item number, XXXXXX999XXX, is reached

Show cost carrier

Fixed bug preventing cost carrier to be visible in item details.

Timeout when saving large models

After fixes it doesn't time out when saving values on model level or item-level to all items for large models (350+ items).

System

Change in database model: Attributes moved from model to item level

Supplier is defined per variant (item level in database).

Attributes 'Can be ordered', 'Country of Origin', 'Manufacturer' are saved on item-level. The user must now select to save these attributes to all items within the model.

Import

Handling of size issue between variants in same model

When there are colors or sizes which have for different colors/sizes same color/size number parts (Parts of external item number - 7-9 for color and 10-12 for size), item will be added with next possible value.

Mass update

Fix for mass update from Excel

Critical bug is fixed.

Price calculation

Time zone

When working with prices, the user will see dates in the configured timezone, and be able to see the prices as they will be effective in stores, without the users local time zone interfering.

Validation of mandatory price fields

When saving a price, user will be notified if wholesale price or recommended retail price is 0.

Mass update

Preventing new planning codes for items being created from mass update

If planning code in Excel file for mass update does not exists for given item, the validation will result in an Error, preventing the item planning from being created.

Price calculation

Create price: Warning when planning code deviation within model

When creating a new price the user will see which colors that do not contain the planning code, so the user will know beforehand which items will not contain the price.

Mass update

Preventing new items from being created from mass update

• When updating items from items grid with 'Update items from file' (excel), the file is handled as Pricat import and uploaded in the Import view.

• The user needs to open the file and confirm import - same as for Pricat import. 

• For now we have only one validation rule: Only existing items can be imported.

Import

Color can be removed in PRICAT file

Problem fixed: When removing color from imported PRICAT file, the imported items will be created without color.

Item search

Better performance when opening item grid

Performance tuning.

Item details

Item subgroup can be added to item

Problem fixed: No error message when saving after adding item sub-group.

Price calculation

Copy price triggers export of item

Copying a price triggers export of the targeted item and it's new prices.

System

Simultaneously import and export of the same items

Problem fixed: Ordering of items will be correct when doing mass update of the same items that is being exported (due to a previous mass update).