Import in Bladcentralen/Interpress format (RTC-15474)

New items/prices can be imported by uploading a CSV file in the Bladcentralen/Interpress format. The user must manually select the profiles/teams/stores for which the prices will be created. 

The functionality requires permission for "Bladcentralen import".

Model export and bundle items (RTC-20344)

Model and color can be exported to Excel properly using button in 'Item details' view.
Inactive items cannot be added to bundle item content.

Certificate handling (RTC-20381)

Modules will refresh issuer (Shell) signing keys every 24h.
There is no need to restart the module when the certificate used for signing tokens is changed (thus no 401 errors).

Permissions for view items (RTC-18670)

If logged user does not have "View prices permission" then we don`t send request for checking price when viewing item. It means that for such users 'Price per unit' field is hidden.

Import of alternative GTIN (RTC-19012)

When importing items we check if defined alternative GTINs is not used as main GTIN for existing items. If so then GTIN defined in file is skipped and rest of changes is imported.

If GTIN is already used by another item then user gets such validation warning: Tandem GTIN is already used.

RIGAL Import (RTC-19015)

Item attributes for 'Change VAT'-flag and unit price factor are supported in RIGAL item import.

• Change VAT - True / False
• Unit price factor - value and unit (for example 100 pcs)

While importing file we use such fields:

• Conversion factor is field 7.1.79 (Konvfak) in RIGAL file.
• Conversion unit is field 7.1.92 (Konvenh) in RIGAL file (For Unit we have such predefined units: 1 = piece, 2 = kg, 3 = liter, 4 = meter). 
• Change vat is field 7.1.149 (Chgmva) in RIGAL file.

Alternative GTIN in RIGAL import (RTC-18481)
Tandem (alternative) GTINs can be activated and deactivated using RIGAL import.

General performance improvement (RTC-17678)

Improved performance for uploading the Import files. Page cache is no longer loaded for ApprovalItemHandler.

Alternative GTIN problem (RTC-18773)

Duplicated alternative GTINs can be imported with RIGAL files.

Upload image from Item Management to EG POS (RTC-17338)

When uploading image in Item details in Item Management, a job in the Integration Platform (MediaBankIntegration package) will automatically upload the image to POS Mediabank.

A new validation error is added - 'Planning code cannot be created'. It appears when trying to create a new item with a planning code given in the file. 

Export store prices to Excel (RTC-15314)

Currency of 'Wholesale price in supplier currency' in store price can be exported to Excel. 'Wholesale price in supplier currency' cannot be exported without 'Currency' column.

Export of item file when item generations is not used (RTC-14141)

Export of item JSON blob works for both values of the parameter UsePlanningCodes (True/False).

Stability in import jobs (RTC-17209)

Jobs in Item management can be run together, also for longer runs.

Export prices to Excel based on price status RTC-16003)

There are two checkboxes in the Price state section in Export wholesale/store prices to Excel views: 'Include future prices' and 'Include historic prices'. When they are not checked, only active prices are exported. If they are checked, they are set to one year in the future/past by default. When they are used, prices from the selected date range are exported. Both checkboxes can be checked at the same time.

Mass-update of items with parameter UsePlanningCodes set to False (RTC-15621)

Import of mass-update items works with Parameter UsePlanningCodes=False. It means attributes related to item generations (planning code) can be imported without planning code value. 

Empty Break bulk code in RIGAL import (RTC-17487)

RIGAL import supports empty value in field 7.1.89 (Anbrekk) - Break bulk code. Empty value won't affect Break bulk code.

RIGAL import supporting more attributes (RTC-16410)

RIGAL import is extended with new fields: 

• Sub group
  7.1.19 Undergruppe
• Deposit item
  RIGAL: 7.1.58 Linknr We don't get quantity in the RIGAL, so qty = 1.
• Warranty type
  RIGAL: 7.1.93 Garantiklasse
• Quantity in supplier package
  RIGAL: 7.1.15 Antpkn
• Special group
  RIGAL 7.1.71 Seletering3
• Environmentally Friendly
  7.1.74 Miljøkode
• Ecological
  7.1.76 Økologisk
• Measures (width/depth/height)
  7.1.83 Bredde (width)
  7.1.84 Dybde (depth)
  7.1.85 Høyde (height)
  Values are in meters and kilograms
• Break bulk
  7.1.89 Anbrekk
  If True, the break bulk code in IM is set to default break bulk code
• ID Requirements
  7.1.94 IDkrav
• Shelf life
  7.1.98 Holdbarhet
• Tara
  7.1.99 Taranetto
  Kg
• Season code
  7.1.112 Sesongnr
• Product information
  7.1.128 Beskrivelse
• Active substance
  7.1.138 Fritekst5.

Show values from active store price (and price refactor) ( RTC-15276)

Columns 'Active %' and 'Active amount' are visible when creating new store prices. They are filled out if there exists an active store price for the same store/team/profile and price calculation rule on the item. When several stores/teams/profiles are selected, values are taken from the first one with the existing active store price. Currency is also copied from the active price. Currency rate, VAT code, and VAT rate, however, are taken from the item (two latter ones based on the selected 'Valid from'). 

Export alternative GTIN's (RTC-14427)

Alternative GTIN's are exported together with all item attributes to Gateway.ItemChanges. They are exported with their status active or inactive. Inactive alternative GTINs are included in the export for 14 days (are not exported if they were modified 14 days ago or earlier). This should be enough time for any subscribing system to update/delete data in their system. 

Hide item generations (planning codes) when not using season related attributes (RTC-14140)

Parameter UsePlanningCodes (set to True) allows using planning codes for all planning code attributes and wholesale prices. When the parameter is disabled (set to False) it is possible to use planning code related attributes without defining the planning code. There are available selected attributes of Procurement setting, Sales date, Assortment, Product information fieldsets (attributes, which are available: Procurement rule, Auto replenishment, Backorder allowed, Replenishment code, Service level, Consumer sales start, Consumer sales end, Supplier sales end, Base assortment, Collection, Assortment code, Sales purpose, Sorting code, Product information, Advertisement information, Technical information).

The field "Original planning code" is hidden.

The button "Manage item generations" is hidden.

Include code for store group (RTC-16305)

Store group's code (Reference in Chain.StoreGroup) is exported when changes are done in store prices (Gateway.ItemPrice) or in item details of an item using planning code (Gateway.ItemChanges).

Export item subgroup (RTC-16340)

Item subgroup's code and name are exported together with the other attributes when item changes are exported to blob.

Export of item hierarchy (RTC-15088)

Department, item area, item group and item subgroup are exported to file/blob. Active status flag is not exported.

Configurable price calculation rule in RIGAL import (RTC-15464)

The Price calculation setup register's default value for price calculation rules is used when importing RIGAL store prices. If no rule is set as default, the Default price calculation is used. It is possible to update a store price with RIGAL only if the same price rule is used while importing as the one set on the price. 

Mass update of item details (RTC-15737)

Additional item attributes which can be updated by import of Excel file:

• Default margin
• Deposit item
• Nonsale type
• Ready for sale
• Warranty type
• ID requirement
• Healthy
• Ecological
• Environmental friendly
• Country of origin
• Shelf life
• Allergens
• Nutritions
• Tara
• Substances

Some of these are registers values (Warranty type, Nonsale type, ID requirement and Substances). New register values will be created by import if register's code is unknown (before update user is informed that new register value will be created).

Manage tandem/alternative GTIN's (RTC-14421)

Alternative (tandem) GTIN's can be added to the item, and be deactivated, activated and set as main GTIN. It is not possible to add GTIN which is already used by another item.

Fix: Add supplier on store level (RTC-15446)

It's possible to add supplier on any level: store, store group or common, as well as edit supplier on any level. Dropdown for stores, store groups display data in format reference + name.

Tandem - change main GTIN (RTC-14429)

When GTIN is changed on an item, the old GTIN is saved as an alternative GTIN (in the Item.GTIN table, isMain=0). GTIN visible on the item in Item details is saved as the main GTIN (in Item.GTIN, isMain=1, visible in the Item.Item table). When a new item is created using a GTIN which is an alternative GTIN for existing item, this GTIN is removed from the old item and set as main GTIN on the newly added one. 

Mass update of store prices (RTC-15757)

There are 12 new columns in grid during import via mass update of store prices:

• New net price
• Current net price
• Difference net price
• Difference net price %
• New retail price
• Current retail price
• Difference retail price
• Difference retail price %
• New gross profit
• Current gross profit
• Difference gross profit
• Difference gross profit %

Creating users from Azure AD (RTC-15608)

First name and Last name, split from Display name, are added automatically to the user when creating it in User management. 

First name, Last name, Display name of existing users can be edited.

Users removed from Azure AD (RTP-13388)

When a user is removed from the Azure AD Group in source AAD the user is blocked from logging in in the destination AD. If the user is added to the Azure AD group again in the source AD we did not unblock the user in the destination AAD. This is fixed and we are checking the "Block sign in" flag on the user from the destination AAD. 

Store/team/profile name and number (RTC-15754)

Both number/reference and name of store group is displayed in views: "Export store prices to Excel" and "New/edit price calculation". New column "Store group code" is added to the store prices grid.

Correct signs in exported store prices (RTC-15923)

When exporting store prices to Excel correct positive/negative values are preserved.

Mass update of store prices from Excel (RTC-15756)

In case of duplicated store prices in the same import file, the last one is imported. In import items grid the duplicates will be still visible but only the last one will be imported.

Filtering store prices by permissions (RTC-14068)

All store prices, which the user has access to shown in the price grid. Same for store groups in multi-selects.

Exporting items after store price update (RTC-15577)

Items are not exported (to blob storage) after store prices are created or modified.

Active substance (RTC-14796)

There is a dropdown field Active substance visible as the last field before the checkboxes in the Sales section in Item details. Values visible in the dropdown are taken from the Active substances register. Only active values are available there.

ID requirements (RTC-15491)

ID requirements dropdown values in item details are displayed as 'code-name'.

Select Stores/Profiles/Teams when exporting store prices to Excel (RTC-14214)

It is possible to export store prices to Excel for desired stores, profiles or teams. The multiselect field placed below store level user can filter within stores, profiles or team (depending on the level and user roles) and choose which store prices should be exported and viewed in Excel sheet. 

Mass update of store prices from Excel (RTC-13234)

When selecting mass update from Item details grid or Import grid, you can select to update store prices. Use same Excel template as you get when exporting store prices to Excel.

There are a few validation rules:

• Item not found
• Price/Wholesale price is not defined
• Price/Wholesale price must be above 0
• "Valid to" in the past will be ignored.
• Only today or future dates are allowed for "Valid from".

Currency column in the export will be available in the coming weeks.

 There are mandatory fields, which if any is missing will cause exception and status "Error" on validation. Proper messages will be added later.

Mandatory fields:

• Item identifier (GTIN, Item number or SKU)
• Stores/Profiles/Teams
• Valid from date
• Wholesale price
• Retail price

Commission percentage (RTC-13046)

It's possible to enter/edit commission percentage with maximum of 2 decimal numbers. 

Active substances register (RTC-14797)

Active substance register is visible in Sale column in Item registers. It is possible to add new active substance by using Add-panel. Active substances can be deactivated or reactivated. One of the substances can be selected as default. Code of every record must be unique. It is possible to set max number of items in one receipt in "Allowed number in receipt" field.

Display price per CU in TU items (RTC-12087)

When an item is a TU item and Quantity in supplier package is provided, the store prices include an additional column with price values per CU item.

Users with pending invitations to Azure Active Directory (RTC-15096)

If a user has a pending invitation to a tenant and is added to User Management of this tenant, they will be granted access to this tenant when they try to login. When they select the tenant in the tenant selector, they will be presented with the window to accept the invitation and they will be immediately logged in after accepting it. 

Spaces not allowed in externalItemNo (RTC-14257)

Spaces at the beginning or end of the value for External Item Number (identifier) will be trimmed during Import. Same for "Use file" in item lists.

Columns in RIGAL export to Excel (RTC-13280)

The columns containing price information are exported together with item information columns when exporting 'Item details from import file' from a RIGAL import file. 

Reject items (RTC-14243)

There is a confirmation dialog before rejecting selected items in import.

Add size when creating new model (RTC-13918)

When creating new model or adding items to existing model, and when adding new size in size wizard, the'display size' field is set same as size name by default.

Save changes question in item list (RTC-13765)

Save changes question appears only when trying to leave the view using breadcrumbs or the browser's 'back' button while creating a new item list. 

Notifications for mass-update of prices (RTC-12237)

Notifications are displayed when uploading, revalidating, or importing a file for mass-update of prices. 

Import of profile prices in RIGAL format (RTC-13390)

RIGAL format with profile prices can be imported. Store groups of type profiles are matched with RIGAL store numbers. If the profile is not found, it will use store with this RIGAL store number. If both store and profile have the same value, the profile is taken.

Performance in import (RTC-14330)

The batch size is set to 6000 rows for inserts into staging tables to reduce the risk of timeouts.

Item fields 'Warranty type' and 'ID requirement' are added to the Sales section in Item details. Both fields are saved on the model level and are not mandatory. The fields are dropdowns containing active values from the corresponding registers. 

Shelf life (RTC-13430)

A field for "Shelf life" (saved on model level) is available in the "Food" section, below the "Country of origin" field.

External model number (RTC-11907)

External model number is shown in the 'Model' section in the item details view. This field can be edited using the manage model button, then selecting the option to change external model no. The value must be unique amongst all models.

Default margin (RTC-13261)

The field "Default margin (%)" field (item level) is available in "Price" section, below "VAT code" field. The value defined here will be used as default margin when creating a new price. Please note that business logic for the price functionality will be added later.

Adding new items to an only-color, only-size model (RTC-14067)

It is not possible to add a new item with color and size to only-color/only-size model. Missing size/color needs to be added first to an existing model. It is possible to add new items, which are the same type (only-color/only-size).

Item list from file (RTC-12687)

A validation message appears in the "Use file" popup when creating or updating an item list to inform a user that the header of the file is incorrect or missing. A message appears at the bottom of the page to inform that some items included in the file do not exist in the system. 

Export store prices to Excel (RTC-13232)

Store prices can be exported to Excel from Items grid, Item lists, Item segmentations, and Promotion offers. "Export prices" button expands into two options: "Export wholesale prices to Excel" and "Export store prices to Excel". 

Date and time picker (RTC-12971)

There is a date picker without a time picker in Export wholesale/store prices to Excel views and New wholesale/store price views when ordinary price type is selected. There is a date and time picker in New wholesale/store price views when campaign or member price type is selected.

Export to Excel of mass update files older than 14 days (RTC-13966)

Export to Excel for mass updates of price calculations that are older than 14 days are blocked. This is due to an automatic cleanup job which runs after 14 days and cleans up the data, resulting in the file being empty upon export.

Changes in Item details page (RTC-13685)

'Customs tariff no.' is moved above checkboxes in Procurement section. All checkboxes are moved to the bottom of the Product classification section. Sale section is split into Price section and Sale section. Food section is displayed as the last section (after Product information section).

Item list 

Item list/Item segmentation API - Include price (RTC-13019)

Requests including both store price and item information can be performed for Item lists and Item Segmentations. It can be filtered by date and store/store group.
Items without prices are also returned.

Reject rows in import (RTC-11553)

It is possible to set the 'Rejected' status on rows that were not imported in the Import details view of all import types using the button 'Reject items' placed in the toolbar. Rejected rows are hidden by default and can be seen separately from active rows when the Status filter is set to 'Rejected'. Rejected rows cannot be imported directly but they can be revalidated and then imported. 

Item and price control for RIGAL files (RTC-11551) 

When opening item details for RIGAL files the columns includes Store number, New retail price, Current retail price, Difference retail price, Difference retail price %, New net price, current net price, Difference net price, Difference net price %, New gross profit, Current gross profit, Difference gross profit, and Difference gross profit %. Values for 'Current...' columns are filled out only if there exists a currently active price for the same store on the item. 

Rounding rules for store prices (RTC-14058)

Rounding 0 (set in the rounding rules register) rounds prices to the closest value with 0 at the end of the price value. When 5 is the last digit it will round to the higher value. If for example you want to round to the nearest whole value for all prices below 10,5, set the rounding rule to be 1,2,3,4,5,6,7,8,9,0.

It won't be possible to round to the exact 0 value (price=0).

All roundings for a price will work with standard mathematic rules.

Import

Deposit item (RTC-12225)

The field named 'Deposit item' is visible at the end of the Sale section. In this field you can search and add a link to any item. After selecting an item from the dialog, the item name is displayed as a link and the 'Quantity' field appears. By default, this field is set to 1 and can be edited. After pressing ‘x’ icon on the item name, the 'Quantity' field is hidden and the search is available again.

Changing supplier on import items (RTC-7886)

Changing supplier in the Import grid is possible only for file type PRICAT. The main supplier for import items is taken from the whole import. OriginalJsonContent shows the original import file and JsonContent is updated with the import supplier when any change is applied. 

Item list

Permissions for item lists (RTC-11610)

Permission 'Manage item lists' is available under 'Item - item > 'Item list' section. This permission is required to create and update item lists in Item management. Export of prices and items within Item lists can be done without this permission. Item lists are accessible in read-only mode with the 'View items' permission. Item lists can be used in Promotion without the 'Manage item lists' permission. 

Import

Outdated validation of import (RTC-13665)

Import is counted as outdated when the last validation time is more than one day (24 hours).

Import

Validation improvement (RTC-13141)

Manual revalidation of import works. Revalidation of a partially imported model keeps status of already imported items.

Outdated validation of import (RTC-8074)

Any kind of import, which was revalidated 30 minutes or more from the moment of import will be stopped. If part of items selected to import was validated they will be imported. Outdated items (modified after validation time) will not be imported, and notification will be displayed. To get import done the user must revalidate before importing the items.

Item list

Edit item lists / Unsaved changes (RTC-11613)

Existing item lists are by default filtered to show only the selected items. After a list is created and reloaded, it also shows only the selected items. 

When creating an item list and trying to leave without saving the list, the 'Unsaved changes' modal appears. 

Item register

Nonsale type (RTC-12571)

Nonsale type register is available in item registers. It is possible to add, edit and deactivate rows in the register.

Price

Rounding of store prices (RTC-8438)

A button "Round price to {amount}" is available in store price details view, below the “Retail price” field, displaying the retail price amount after it will be rounded. The rounding is defined in Item register\Rounding rules.

Import

Show warning when modifying size (RTC-13250)

Modifying the size on an existing item with any kind of import will show the warning "Size is modified". Same for color with the warning "Color is modified".

Item details

Allergens and nutrition (RTC-13123)

Item details sections for allergens and nutrition is placed at the bottom of item details.

Item list

Use another item list to select or unselect (RTC-11457)

By using button 'Use item list', it is possible to include or exclude items within an item list that is being created or edited.

System

Delete items from database (RTC-12620)

Index is added to improve performance when deleting items manually from the database.

Item details

Items with multiple distribution packages (RTC-11873)

Items can have multiple distribution packages, for example boxes and pallets.  In item details it is shown which TU items a given CU item is linked to. If CU item is not linked to any TU item, Quantity in supplier package field is visible for defining packages without barcodes. Whenever a CU item is linked to a TU item, the field disappears and the number is taken from the TU item. Units of the packages visible in item details of a CU item are fetched from the TU item. 

Item list

Edit item list (RTC-12053)

Item lists added to promotions can be edited. Clearing selection changes ToDelete flag in the database to true so that unused lists and segments can be permanently deleted. 

Import

Allow store prices with date in the past (RTC-12992)

Store prices with the starting date in the past can be imported when using RIGAL import. 

Item details

Fix: Can't open or find items when text attributes contains a date format (RTC-12961)

Values with date format (XXXX-XX-XX) can be saved on every string field.

Item list

Create promotion from item list (RTC-11030)

It is possible to create a promotion from a new or an existing item list by clicking Create and Promotion in the Item list details view. Please note that you should not use this feature unless you are using the Promotion module.

Item segmentation

Bugfix: Segmentation fails when filtering with item group (RTC-12613)

A segment in item segmentation can include (and be recalculated) filter group with Item group or Subgroup as an attribute.

Import

Bugfix: SupplierDiscount from price rule not used (RTC-12884)

All discounts are added from the import rule when importing with PRICAT.

Import updates will always export the items to external systems.

Item details

Unsaved changes (RTC-698)

When there are unsaved changes in item details and user selects function to Add new items, Change color or Change size, unsaved changes dialog is shown (with 'Discard changes', 'Cancel' and 'Save changes').

Item segmentation

Failed calculation of segments (RTC-961)

When the segmentation calculation fails, the status of the segment will be reverted to the one before calculation. The user will get a notification that the calculation failed.

Mass update

Dynamic price calculation: Change price calculation rule of existing prices (RTC-915)

Mass update can be used to update an existing price with a new price calculation rule. All lines in one import file must contain the same price calculation rule. If not, a validation error appears saying: "Conflicting price calculation rule code".  If a price is exported with one rule and this rule is updated in the exported file to be imported as an update, field mapping takes place and values are one by one assigned to the subsequent cost price fields corresponding to the new price calculation rule. In Mass update summation rows are also mapped but they are not filled out. This will be changed in RTC-3569 [Dynamic price] Export. All cost price fields for the new rule must be provided in the file. 

Price

All price calculation values are required when importing (RTC-718)

All cost price values corresponding to the used price calculation rule must be provided when importing prices using Mass update or import through API (for example from Temalogic). If some values are not given in the import file, price is not imported and validation error appears: "Missing cost price values". Imports that use import rules work as before.  

System

Logging of tenant ID (RTC-764)

Logging in Application Insights for API calls (both OK and Failed) includes tenant ID, which will make it easier to identify and analyze error situations for different retailers.

User management

Hide disabled stores in user details view (RTC-971)

Inactive profiles, teams and stores will not show up in the store access list in user details view. When editing store access, it's not possible to select inactive stores, although they will still be visible in the dropdown menu. 

System administration

Support for cashier login with on premise as identity provider (RTC-878)

EG Cloud (Chain Web Shell) support a locally installed IdentityServer as identity provider in addition to Azure Active Directory. This can enables the feature of accessing Chain modules in the cloud by using simple cashier login on premise. The security is maintained since the device needs access to the store local network to log in. The access token issued by Chain Web Shell contains information that this login was done by cashier authentication and the different cloud modules can allow or disallow usage based on this information. Initially this feature will be used by Mobile POS app to make it more efficient for several users to share mobile devices, just using cashier logout/login when switching user.

Import

Min/max validation for price input fields in import rules (RTC-911)

For import rules, fields in the price calculation tab (item import rules details) have limited values. For positive fields it's a range between 0 - 9999% and for negative fields it's a range between -99% - 0%.

If the user tries to add a value above this range it will change it to boundary value, so no validation message needs to be displayed.

Mass-update of prices - wholesale price in currency (RTC-830)

It is possible to create/update currency on price calculations using mass-update.

The price will be counted for the field "Preorder Wholesale price in supplier currency".

If currency column is not included in the in mass-update import file or the value is empty, currency value will be set by default to MainCurrencyCode (NOK).

For now, it also affects updating planned prices with a different currency value (causing change of currency in planned price), which will be resolved separately (will be fixed in: RTC-9966)

Item details

Error message when saving item with inactive values (RTC-766)

When there is some deactivated register value which is used for an item, the user will get  information: validation "Inactive value selected". When the item has some inactive values it cannot be saved, and the user will get an error message.

Fix for item details in mobile view (RTC-725)

When opening item details in in mobile view, buttons etc. are displayed properly. 

User interface design for profile attributes (RTC-877)

Design for profile attributes in Item details view and Import rule details view is improved: Display of attribute fields is more clear and easer to read.

System

User interface improvements for notifications (RTC-819)

• Shadow around the notification panel

• The bell icon is lined up with 'Username'

• Hover on the bell icon works the same way as in the case of 'Username'.

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

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

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

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

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.

Export to Excel

Inactive status and inactive date

Columns for inactive status and date for inactivating are added to export to Excel. To get inactive items exported to Excel the user must first select to view inactive items in the grid.

Item search

Improved performance when filtering on item number

Searching/filtering on (external) item number is faster.

Import

Improved error handling

When there is something wrong with an item import we create error for given item without affecting the whole batch of items. Error handling for PRICAT files with more than 10.000 items is also improved.

System

Date in UTC-format

The system handles dates in UTC-format for currency rate dates, delivery dates and season dates.

Import

PRICAT import: Fix item identifier when new items and update for same supplier model number

When importing new items and in the same import there are updates for existing items as well as same supplier model number and this files get 'item identifier' error, then from now all items get error. Until all 'item identifier' errors are fixed, it is not possible to import new items. They get error: Item identifier error. Supplier deviation for other variant.

Temalogic - compare price values in import.

Compare price values for Temalogic import

Import from Temalogic can be exported to Excel for comparison of existing price calculation values with values from the import file.

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