You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 25 Next »

Coming next release

Module

Description

Import 

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.



Release 08.07.21

Module

Description

Import 

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 details

Warranty type and ID requirements (RTC-8124)

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

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. 

Price

Validation message when editing price dates (RTC-7752)

When editing "valid from" date and the date is not correct, a validation message is shown (instead of an error).


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.



Release 30.06.21

Module

Description

Export to Excel 

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.

Item details

Ready for sale (RTC-13301)

The Ready for sale flag is default set to true. Other systems like POS can use this flag to change status in the item status.



Release 23.06.21

Module

Description

Item details

Nonsale type in item details ( RTC-12569)

It is possible to add nonsale type (register) values to items. They are saved on the model level.


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 

Import items from file to item list (RTC-12646

It is possible to add items to the item list with a .csv file with an External item number (ExternalItemNo), GTIN (MainGtin), or SKU (Sku) identifier (Columns names equal hidden key value from Excel files). Only one identifier can be used at a time (one per file).


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.

Import 

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. 


User interface styling and improvements in RIGAL import (RTC-13382)

The 'Difference...' columns in the RIGAL import have a special styling. Values in these columns are presented in different colors depending on their sign: 

  • Difference net price: red for positive, green for negative.
  • Difference retail price: green for positive, red for negative.
  • Difference gross profit: green for positive, red for negative.

When value is 0, then the standard black color is used.


Export to Excel when importing RIGAL files (RTC-11554)

When opening a RIGAL import file, the items can be exported to Excel, including current values for existing items. New/current prices etc. will be added to the export later.


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. 

Price

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.

Register

Update of imported supplier fails (RTC-14039)

Suppliers created automatically through import of items can be modified in the Supplier register. 



Release 09.06.21

Module

Description

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. 



Release 07.06.21

Module

Description

Import

Outdated validation of import (RTC-13665)

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


Release 02.06.21

Module

Description

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.



Release 21.05.21

Module

Description

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.



Release 18.05.21

Module

Description

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. 


Items with allergens

(RTC-12360)

Allergens can be defined in item details All allergens by default have "undefined" status. There are four statuses to select: 

  • Undefined

  • Does not contain

  • Might contain

  • Contains

Allergens are common for all items within a model.

Sections for Allergens and Nutrition in item details:






If you select Edit allergens you can edit allergens. You can select if the item contains allergens or not. Click Save to save your changes, changes is updated in item details view.

Items with nutrition

(RTC-11046)

Nutrition fieldset is available in Item details. Values from the Nutrition register are visible and values can be defined for them in a third level page accessible by clicking 'Edit nutrition'. 

If you select Edit nutritions you can edit nutritions. You can add items nutritional contents per 100 g. Click Save to save your changes, changes is updated in item details view.







Release 14.05.21

Module

Description

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.



Release 11.05.21

Module

Description

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.

Import store prices from RIGAL

(RTC-11765)

Ordinary store prices can be imported using RIGAL item file. To import a price, Engros (7.1.20) field must be filled out. If fromDate is not given or is in the past, today's date is set. Time within the file is in the "local price zone" and is converted to UTC using the PriceLocalTimezoneId configuration parameter. If the file's name format is correct, storeGroupLink.externalNo is taken from it. If not, it is taken from the Filial (7.1.54) field in the file. "VAT" percent is filled out using the one specified in the RIGAL (so the same that is set on the item). VAT amount and Retail price WO/VAT on prices are calculated accordingly. 

RIGAL -> Item Gateway

Fradato (7.1.8) -> fromDate
Engros (7.1.20) -> wholesalePrice
Netto (7.1.21) -> netPrice
Utpris (7.1.22) -> retailPrice
Veil (7.1.23) -> retailPriceRecommended
file name / Filial (7.1.54) -> storeGroupLink.externalNo



Release 10.05.21

Module

Description

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.



Release 04.05.21

Module

Description

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




Release 26.04.21

Module

Description

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.



Release 16.04.2021

Module

Description

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.



Release 08.04.2021

Module

Description

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.


Item lists

(RTC-11021)

"Item lists" is a concept that can be used for doing 'actions' on multiple items. These actions can for example be Create promotion, Mass update or Export to Excel (functionality for these actions will be released later).

Create item lists by using 'New item list' button in the Items grid or the Item lists view accessible through menu. Item lists can be created based on all the items available in Items grid. Items within the lists can be selected manually by marking checkboxes or using the 'Select all' button when some filters are applied. 'Unselect all' button is also available. Name and description of a list can be edited. Access to Items lists requires permissions.

Button to open the Item lists view:






Item list view when some filter is added:





Select the items that should be included in the item list and click on the Create button. Give the list a name and click Save.




The Item list is created and you can find it in the Item lists view.




Item hierarchy drilldown

(RTC-10972)

In the Items view, a panel is available which contains all the active item groups. It is possible to filter by these item groups and combine this filtering with the grid filters. The panel is not available if the (text) search is used.

Screenshot show item view when filter is closed:






Screenshot show Item view when filter is used, and group is selected:





Allergens register

(RTC-11465)

Allergens can be added in the Allergens register using the add panel. Rows can be edited, deactivated, and activated back if needed. 

Register overview, with new registers:










Allergens register:

Nutrition register

(RTC-11464)

Food nutrition can be added in the Nutrition register using the add panel. Rows can be marked as mandatory and their sorting must be provided. They can be deactivated and activated back if needed. 





Release 18.03.2021

Module

Description

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.



Release 15.03.21

Module

Description

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.



Release 03.03.21

Module

Description

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.



Release 22.02.21

Module

Description

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.



Release 12.02.21

Module

Description

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. 



Release 04.02.21

Module

Description

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.



Release 29.01.21

Module

Description

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



Release 27.01.21

Module

Description

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



Release 21.01.21

Module

Description

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.



Release 18.01.21

Module

Description

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



Release 22.12.20

Module

Description

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.



Release 17.12.20

Module

Description

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.



Release 09.12.20

Module

Description

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.


Select price calculation rule in import rule

(Work ID: 183186)

In the import rule setup you can select which price calculation to use.  The default rule is configured per tenant. 








Price calculation input fields appears for each input field type to be filled out for Preorder and Replenishment sections in the import rule. These values are used when importing prices with import type which uses import rules. If fields are empty, they are set to 0 for new prices or omitted for existing prices. Since fields for prices may differ between price calculation rules and are now taken from import rules, if cost price values are specified in imported file when doing PRICAT import, the item is not imported and status changes to 'Error' for such line. Imports which do not use import rules will use the tenant default price calculation rule.



Release 07.12.20

Module

Description

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.



Release 17.11.20

Module

Description

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.

Copy user settings

(Work ID: 171873)

When creating a new user, it might be faster to copy settings/roles from an existing user. Use the more button ('...') in the bottom right when editing the existing user. All properties of the existing user will be copied apart from user details.











Select "Create copy of the user". Dialog "Create a copy" opens.




Start writing name of new user in the "New user" field. Search result is displayed.






Select the wanted user from the search result. New user is added to the "Create copy" dialog.









Click on the Create button to create a new user of a copy the existing user's properties. New user is created, and user details view opens.

Copy user settings is only available for users with permission "Create new user".


Release 06.11.20

Module

Description

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.



Release 04.11.20

Module

Description

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.


Show status of the process

(Work ID: 183046)

A progress bar is shown when validating an import or updating the import. When the validation/import is done, then the progress bar disappears.






Progress bar when updating the import






Import is done

Show recalculation status

(Work ID: 183045)

A progress bar is shown when recalculation the segment, and the status is refreshed every 4th second. When the recalculation is done, the progress bar disappears and the segmentation is refreshed.


User region

(Work ID: 187230)

Available regions in User Management are: Norway, Sweden, Denmark, Finland, Island, Great Britain, Netherlands, Belgium, Germany, Austria, Estonia, Poland, Lithuania, Luxembourg). Date or decimal separator setting is dependent on region. The side effect for now is that date picker gets translations according to it's region. 

Language can be defined on user in User Management (Norwegian, English, Swedish).  

Change of language in one module or user details setting in User Management applies across all modules.





Select Region from drop-down list






Select Region from drop-down list


Release 30.10.20

Module

Description

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.



Release 23.10.20

Module

Description

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.



Release 16.10.20

Module

Description

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.



Release 07.10.20

Module

Description

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.



Release 30.09.20

Module

Description

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.



Release 24.09.20

Module

Description

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.



Release 16.09.20

Module

Description

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.



Release 11.09.20

Module

Description

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.



Release 08.09.20

Module

Description

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.


Show progress for segment calculation

(Work ID: 179542)

When calculating a segment the percentage progress is shown in the breadcrumb. The progress indicator is based on the number of filter groups processed. Processing time for last calculation provides the user approx. time for next calculation.



Release 02.09.20

Module

Description

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)


View all notifications

(Work ID: 176600)

Notifications panel is opened by clicking the "bell" icon in the right top corner. When selecting 'View all notifications' the user is navigated to a view showing all of the users notifications (including dismissed). For support purposes there is a permission that makes it possible for system users to view notifications for all users.



Release 31.08.20

Module

Description

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.



Release 27.08.20

Module

Description

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.



Release 25.08.20

Module

Description

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.



Release 14.08.20

Module

Description

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. 




Release 24.07.20

Module

Description

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.



Release 17.07.20

Module

Description

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.



Release 10.07.20

Module

Description

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.



Release 01.07.20

Module

Description

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.



Release 30.06.20

Module

Description

Import

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

Own brand files can be imported without failing.



Release 29.06.20

Module

Description

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.



Release 11.06.20

Module

Description

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.



Release 29.05.20

Module

Description

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.



Release 25.05.20

Module

Description

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.


Validation of import

(Work ID: 170968)

For validation of mass update from Excel the following 28 validation messages for error and 3 validation messages for warnings are added:

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

In addition:

  • Brand can be cleared when importing (from PRICAT, Temalogic, mass update)

  • Validation of empty Brand code (when only Brand name is provided in the import)

  • Validation of Manufacturer (in PRICAR import)

  • Validation of unknown season code (from Temalogic)


Release 11.05.20

Module

Description

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.



Release 30.04.20

Module

Description

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 of prices to Excel

(Work ID: 154434)

From item grid you can export either items or prices to Excel. Prices are exported for items filtered in the items grid. Please note that we have tested export of 100.000 prices, and that exporting more prices could result in a timeout and invalid Excel file. It is possible to filter prices to be exported by the newest planning code or selected planning codes, price type and dates between which prices are valid. Templates can be created and updated, similar as for export of items. Lines for items that are filtered out in the grid but do not contain any planning code (or price) are not exported to Excel.

When I choose «Export prices to Excel”, Export prices to Excel opens in a new view. In this view you select what you should export.

In top of this view you could select Price type, Valid from/to, if the prices should be exported for the newest planning code or selected planning code, and you could select an Excel template.

Columns in Excel

In this part of the view you define columns that should be available in the Excel file. 

You select columns in the same way as in the Export to Excel view, by selecting the columns you want to export to the Excel file. See Export to Excel description for details.


Release 21.04.20

Module

Description

Work ID

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


Release 08.04.20

Module

Description

Work ID

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


Release 02.04.20

Module

Description

Work ID

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


Release 23.03.20

Module

Description

Work ID

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



Release 13.03.20

Module

Description

Work ID

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

Select item fields and create templates for export to Excel

(Work ID: 168239)

When exporting items information to Excel, you can select which columns to export. Speed up to export process by creating and selecting templates.

When I choose «Export to Excel” in the item details view, Export to Excel opens in a new view.

In the “Export to Excel” view you define what the export should contain.    

First you have to define what planning codes should be exported. You could choose between “The newest planning code”, “Selected planning codes” or “Do not export planning code”

Then you define Excel layout. You define columns that should be available in the Excel file. You could use a Excel template or select columns manually.

To select columns you select the checkbox by the column you want to add to the Excel file. You could also select a category, then all the columns in the category is selected, but you could choose to deselect some of the columns.  

You write a search text in the search field to find the columns quicker. Then you get all the columns with the given text in the name, and you could select the columns that you want.

Under det search field you have to buttons: Select all and Unselect all.

Select all

If you choose Select all, all the columns are chosen. If you have performed a search, this button selects all columns matching the search.

Unselect all

If you choose Unselect all, then all columns are unselected.

Use template

You could use an existing Excel template. Select “Use Excel template”,  and choose the template you want to use from the list. Then you get a list of the columns that are selected in the given template. You could modify the selection.

Create new Excel template

When you have made your selection you could Create a new Excel template. Press the “more-button” (…), and choose “Create a new Excel template”.

The dialog “New template” opens.

Give the template a name and possibly a description. Choose Create to create a new template.

The template name is displayed in the view under the field “Use Excel template”.

Update existing template with modifications

If you have modified a existing template, you could Update existing template with modifications to update the template.  Press the “more-button” (…), and choose “Update existing template with modifications”.

The dialog Update existing template with modifications opens. You could change name or description. Choose Save to save the changes.

Export to Excel

When you have defined which columns you want to export to Excel. You select the Export to Excel button to export the selection to Excel.


Release 05.03.20

Module

Description

Work ID

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


Release 28.02.20

Module

Description

Work ID

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


Release 21.02.20

Module

Description

Work ID

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

Concession flag on item

(Work ID: 168098)

An item can be marked as a concession item. This attribute can be set both when creating and editing. Default value is false. The concession flag is available in both import/export and Excel export/mass update.

Concession flag on brand

(Work ID: 168098)

A brand can be marked as concession. This attribute can be set both when creating and editing. Default value is False.



Release 14.02.20

Module

Description

Work ID

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


Release 11.02.20

Module

Description

Work ID

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

Import status and work status

(Work ID: 168149)

Column 'Status' shows the system import status of the file, with statuses New, Pending, Ready for import, Partially imported, All items imported, or Error. In addition the user can manually mark a file as 'Done' by selecting the button 'Work done' in Import details.

This improves the workflow and makes it easier to filter on imported files 'Not done'.

A file that is marked as ‘Done' can be set back to 'In progress' by using the button '...' and choose 'Set back in progress’ in Import details.


Release 10.02.20

Module

Description

Work ID

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


Release 31.01.20

Module

Description

Work ID

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


Release 24.01.20

Module

Description

Work ID

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


Release 22.01.20

Module

Description

Work ID

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 grid with file types

(Work ID: 166771)

The import grid shows import files of type PRICAT, Temalogic and Mass update with the following columns default:

Import ID, File type, Name, Status, Scheduled for, Season ID, File suppl. no, File suppl. GLN, Supplier, Created date, Created by, Modified date and Modified by.


Release 15.01.20

Module

Description

Work ID

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



Release 14.01.20

Module

Description

Work ID

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



Release 13.01.20

Module

Description

Work ID

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 of stock/order status

(Work ID: 153007)

ItemService API contains an endpoint for update of stock status per store/wholesaler from systems that are master of stock. The status updates the In stock/order flag in item details, and only a change in status (from true->false or false->true) will trigger an export of item changes.

API documentation can be found here: https://itemservice.lindbaktest.com/index.html.

JSON example:


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



Release 03.01.20

Module

Description

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

Export inactive items to Excel in item details view

(Work ID: 166888)

In Item details 'Export to Excel' popup there is a checkbox 'Export inactive items’. When it is checked, inactive items are exported together with active items. When exporting single item, checkbox is disabled and checked or unchecked depending if item is inactive or active.



Release 18.12.19

Module

Description

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

Import rule with checkbox for ‘Overwrite existing lead time’

(Work ID: 166676)

Checkbox 'Overwrite existing lead time' is available in Import rule details. If it is checked, value in 'Lead time' field in item register is overwritten by value in import rule or import file (if Import rule is empty) if such is given when updating item using approval import. If it is unchecked, value in item register is never overwritten. 



Release 16.12.19

Module

Description

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.



Released 11.12.19

Module

Description

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.



Released 09.12.19

Module

Description

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.



Released 05.12.19

Module

Description

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.



Released 04.12.19

Module

Description

Export

Decimals in currency rate

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



Released 03.12.19

Module

Description

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.



Released 29.11.19

Module

Description

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.



Released 26.11.19

Module

Description

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



Released 22.11.19

Module

Description

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.



Released 21.11.19

Module

Description

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.



Released 20.11.19

Module

Description

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.



Released 14.11.19

Module

Description

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

  • No labels