Release 15.12.2022
Import - Fix: Change ValidFrom to today (RTC-28194)
Fixed import when importing file without price.
Release 13.12.2022
Module | Description |
---|---|
Import | RIGAL import of supplier discount and fixed price (RTC-27561)
Handling of price date from (RTC-27418) Valid From date for price is changed to today's date when:
User is informed, that ValidFromDate is set to today's date. |
Label printing | EkoPallet label type (RTC-27824)
Printing of deposit price (RTC-26545) Store price of deposit item is printed on labels to print, next to "+pant" text.
|
Price | Fix: Item store links (RTC-28098) When creating a profile price (for a new item), item store links are created for all stores that profile has. |
Release 07.12.2022
Module | Description |
---|---|
Import | Import of 20-codes (RTC-27461) Alternative GTINs are converted to 20xxxxxx00000 format when the parameter "EAN20 conversion" is enabled. The original and converted alternative GTINs are added to the item. |
Item details | Permissions to view prices (RTC-27422) User that has store access and view prices permission on store level, can see price calculation on profile/price zone level, if store is in profile/price zone. Length of item text fields (RTC-27135) The ItemText, ItemReceiptText, LabelText1, LabelText2, and ItemGroupName fields are 255 characters. |
Item segmentation | Performance for dynamic segments (RTC-27540)
Segmentation on item hierarchy (RTC-27619) Segmentation can be done on all item hierarchy levels: Department, Item area, Item group and Item sub group. |
Label printing | Label printing grid (RTC-27764) Columns "Item group number" and "Item Group Name" are available in the printing label grid. The label printing grid is sorted in the following order: LabelType, StoreId, ItemGroupNumber, SupplierId, ValidFrom. |
Release 28.11.2022
Select and process multiple import files
It is possible to mark multiple imports in the import grid. Marked imports can be validated, imported, work done, and deleted.
The "Refresh" button in the import grid and import details are used for refreshing the results without removing filtering and sorting.

Import grid when multiple imports are selected
Improvements
Module | Description |
---|---|
Import | Import of alternative GTINs from Excel (RTC-26789) Excel can be used to import and export (mass update) alternative GTINs. |
Item details | Alternative GTINs (RTC-27349) There are buttons that allows to collapse and expand list of alternative GTINs and scale groups, if there's more than 5 of them linked to an item. |
Label printing | Avoid generating labels for specific items and specific stores (RTC-25063)
|
Release 22.11.2022
Module | Description |
---|---|
Fresh food scale integration | Handling of item status (RTC-26848) When item status is changed (to inactive, active, stopped form sale) and label has already been exported, a new change (label type Myhrvold) is created and exported. Handling of scale links (RTC-26846)
|
Import | Import status (RTC-23195)
Fix: Import price with ValidFrom before the Vat rate ValidFrom (RTC-26977) When importing a price that has a ValidFrom in the past (before the first vat rate) the newest active vat rate is used. Fix: No timeout when importing profile prices (RTC-27063)
Item type column in Item import details (RTC-26773) Columns "Item type" and "CurrentItemType" is available in the import details view. By default, they are hidden. Item type imported with the item, is entered into the "ItemType" column. The "CurrentItemType" column shows the item type currently existing in the item (if any). |
Item details | Fix: Managing scale links (RTC-27428) User that has 'Edit items' permission can add/remove scale links to/from item. |
Label printing | 3rd label type (RTC-26757) Label type EkoPallet is added to label type register |
Register | Scale register (RTC-26376) Scale can be added to scale group from scale group register view. |
Release 16.11.2022
Module | Description |
---|---|
Fresh food scale integration | Export to Myhrvold scales (RTC-27273) FixedWeight in exported labels has a value from UnitPriceFactor in item details or 0 if there is no value there. |
Import | FIX: Creating register values during import (RTC-26933)
Import of deposit quantity (RTC-26746) If an item has a deposit item, but deposit quantity is not given in import (or is set to 0), the default deposit quantity is set to 1 during import. This applies to mass update and item contract type of import. |
Items in import | Search for item/price imported for given item (RTC-26793) When searing for an item in imports, available columns also includes:
Keeping good performance on filtering and sorting on these columns will be developed later. |
Label printing | Print label from item details (RTC-24121)
|
Release 10.11.2022
Module | Description |
---|---|
Import | Import of 20-codes (RTC-27109) Parameter EnableEan20Conversion must be set for retailers using 20-codes with price or weight. When the parameter is enabled:
|
Item details | Fix: View price permission (RTC-26795) User that has view prices permissions on store level, can see store prices on profile/price zone level that contains this store. |
Release 04.11.2022
Module | Description |
---|---|
Import | Import of alternative items (RTC-27188) Fix: In case of alternative GTINs for an item and scale links per store for an item.
|
Item details | Create item with 20-code (RTC-25881) The check digit is not validated when manually creating item has GTIN starting with 20. |
Label printing | Fix: Filtering in label printing grid (RTC-26984)
|
Release 28.10.2022
Module | Description |
---|---|
Export | Supplier's internal identifier (RTC-24871) Supplier export to blob contains supplier id as 'internalSupplierNo' field. |
Import | Fix: Items in import (RTC-26383) Item in import can be searched easily without a timeout. Fix: Exception when manually validating/importing auto-approval import (RTC-22520) Import scheduled for ValidationAndImport ends successful. FIX: Ignore 0 for Trykkbilde in RIGAL (RTC-26898) When fields Trykkbilde (scale label), Frigr2 (risk item), Behandlingstype (treatment type), Fra_og_med_tid has value 0, import is correctly processed. Scale label with non-existing code is created during import. |
Label printing | Default label type (RTC-26103) It is possible to set the default label type in the label type register (both common and per store). The default label type is used when creating a new item manually. If an item that is created during import has a label type specified in the imported file, the label type is taken from the file, otherwise, label type is set from the default value in the register. In import: If a label type specified on the item does not exist in label type register the value is ignored and system show a validation warning. Reason for created label (RTC-25059) When a label is created, the trigger reason is stored on the label. In the label printing grid the user can filter on the column for 'Label trigger' if for example price increases should be printed out first.
|
Permissions | Fix: View items (RTC-26788) User needs only 'view items' permission to see items (there is no server side error). |
Release 19.10.2022
Module | Description |
---|---|
Export | Export performance and stability (RTC-26405) For Generic Export there is a log of exported rows of Items, ItemPrices, ItemStoreLinks. MemoryGrant is reduced and query plan is more stable. |
Fresh food scale integration | Export to Myhrvold scales (RTC-24620) Item and price information (Labels) that are exported and sent to a blob are converted to Myhrvold format and put on a specified (configurable) folder. Every Myhrvold XML file is named after StoreID, by which labels inside XML are grouped. Fix: Export to Myhrvold (RTC-25928) OnPrem integration package: BackOfficeIntegration - ItemServiceOnPremIntegration When getting a file from Item Management a label that has scale link, the code of the scale links is mapped to weightGroup, in comma-separated list) in the XML file converted by ConvertItemLabelToMyhrvold job. Fix: Export to Myhrvold (RTC-26255) Convert label to Myhrvold On-premises job is correctly processed when there is no value in UnitPriceFactor field in the label. |
Label printing | Label type register and manage label type view (RTC-26389) When adding label type on item:
|
Release 17.10.2022
Module | Description |
---|---|
Fresh food scale integration | Use Excel to link item to scales (RTC-25743)
|
Import | Import performance and stability (RTC-26412) Merging of ImportItem is split into Inserting and Updating, ApprovalImport is more stable (no timeout during validation when comparing to old version). Fix: Case insensitive reading of properties from FlatBatch MetaData (RTC-26499) Reading properties from metadata is case insensitive. The size of the letters in the metadata does not cause any problems during the import FIX: Import of alphanumeric GTINs (RTC-25443) It is not possible to import items with alphanumeric GTIN. When importing default item file, item is deleted and an invalid GTIN error appears in the StagingFlatBatchJson table. When importing store price file, in the Import item table, the imported item appears with the error status and the error message about incorrect GTIN. |
Item details | Fix: Item/scale links (RTC-26531) When removing all scale links (within the scale group) from the item it can be done by unselecting scale group checkbox. |
Release 10.10.2022
Module | Description |
---|---|
Fresh food scale integration | Export item and price changes to scales and 3rd party label system (RTC-25745)
|
Import | Fix: Export Excel from import view (RTC-25168) Default item file type (JSON) that has been imported, can be exported to Excel from import view. |
Item details | Fix: Scale links (RTC-26513) Scale links are saved on item when user clicks save button in scale links view. |
Label printing | Link items to scales (RTC-25742) There is a view in item details, under the Scale section, where scales can be linked to an item (scales group are displayed). Only active scales can be added/removed to an item, when scales group is inactive, user cannot link scales from this group to an item. Maximum labels to print (RTC-26404) Maximum quantity of labels to print is 1000. If user chooses more labels to print, there is a warning that only 1000 labels will be printed. Marking labels as printed is slightly faster than before. Labe type register (RTC-24129) Label types register is used for defining what label types is used by all stores or by specific stores.
Myrhvold label is removed from register (it's has scale Category), LTG label is added to register. |
Release 03.10.2022
Module | Description |
---|---|
Export | Better performance when exporting from ItemService (RTC-25985)
|
Import | Fix: Units import when default country is Sweden (RTC-25511) During item import via JSON contract with new unit register, new Swedish unit is displayed in unit register and has correct LanguageCode for Sweden (SV). |
Label printing | Labe type register (RTC-24129) Label types register is used for defining what label types is used by all stores or by specific stores.
Myrhvold label is removed from register (it's has scale Category), LTG label is added to register. Changes for label view (RTC-24565) There is a new view of EkoMaxi and EkoMini labels during printing. Unit price is shown correctly, ConsumerUnitQuanity as well, there is Kr/UnitPrice under the price. |
Register | Scale group register (RTC-25740) Scales can be grouped to make it easier to maintain the link between items and scales. Scale groups can for example be 'Bakery' and 'Fruit and vegetables'. Scale register (RTC-25741) Items can be linked to a scale to export item and price changes to 3rd party fresh food scales. In scale register user specifies the scales available in the store (along with the scale group that they belong to). It is also possible to add scales from scale group register. |
Release 22.09.2022
Module | Description |
---|---|
Labels | Export labels (RTC-24210) Labels with Myhrvold label type are exported to blob. |
Label printing | Creating labels (RTC-25057)
Change tracking rules for label type EKOMaxi (RTC-25060)
|
Release 17.09.2022
Import performance (RTC-25861)
During import, the imported items are inserted in way that improve performance of StagingBatchExecutor and ApprovalImport jobs, so they are less likely to timeout.
Rows in PricatImport.ImportItem table are updated correctly.
Release 13.09.2022
Deleting store prices from RIGAL import (RTC-25468)
Store prices (past, active and future) are deleted when price on active store price is marked as 'U' in import for given store. It's applied for profile prices, as well, when profile price is marked as 'U' in import for given profile.
Release 12.09.2022
Module | Description |
---|---|
Import | Item import performance (RTC-22701) The performance of import tables is improved, and ImportItems fetch queries has also become faster. JsonContent is moved to another table, and the new table record only appears when import row is modified the first time. |
Label printing | Print labels for changed items/prices (RTC-24126)
|
Release 29.08.2022
Imports set as Done (RTC-24238)
All existing imports that have all imported or rejected rows are marked as done.
Label printing- Label type (RTC-25061)
EkoMini label type can be selected when managing label types.
Release 19.08.2022
Module | Description |
---|---|
Export to Excel | Export of VAT to Excel (RTC-24214) When exporting items with a different system country and default country than Norway (e.g. Sweden) VAT code and rate are correctly exported to Excel. Mass update of Label type (RTC-24897) It is possible to export label type. When "Include store local values" checkbox is selected it, the label types for all stores are also exported. It is possible to import label types. When importing a file with no store local values, only default label types are updated. Importing a file from store local values allows you to change all label types. |
Import | Fix: Mass update export and import of sorting code (RTC-24862) It is possible to export and import via mass update sorting code without any other values from the assortment category. |
Item API | Supplier number filter (RTC-24672) There is a possibility to search for an item assigned to supplier, using Item Service API. Requests with new parameter (supplierNo) returns only items assigned to correct supplier. |
Item details | Fix: Uploading an image to non-model item (RTC-24538) Uploading an image to a non-model item works fine again. Set Label type for item (RTC-24550) In item details you can define which label types should be used for given item. Label types can also be defined specific on store level. |
Item lists | Use Excel file to manage lists (RTC-13667) Excel file can be used to manage selection in item list and item group list. Item/item group list exported to Excel file can be used as a template. CSV files are also supported. At least one column with identifiers is required in the file:
|
Release 19.08.2022
Module | Description |
---|---|
Export to Excel | Export of VAT to Excel (RTC-24214) When exporting items with a different system country and default country than Norway (e.g. Sweden) VAT code and rate are correctly exported to Excel. Mass update of Label type (RTC-24897) It is possible to export label type. When "Include store local values" checkbox is selected it, the label types for all stores are also exported. |
Import | Fix: Mass update export and import of sorting code (RTC-24862) It is possible to export and import via mass update sorting code without any other values from the assortment category. |
Item API | Supplier number filter (RTC-24672) There is a possibility to search for an item assigned to supplier, using Item Service API. Requests with new parameter (supplierNo) returns only items assigned to correct supplier. |
Item details | Fix: Uploading an image to non-model item (RTC-24538) Uploading an image to a non-model item works fine again. Set Label type for item (RTC-24550) In item details you can define which label types should be used for given item. Label types can also be defined specific on store level. |
Item lists | Use Excel file to manage lists (RTC-13667) Excel file can be used to manage selection in item list and item group list. Item/item group list exported to Excel file can be used as a template. CSV files are also supported. At least one column with identifiers is required in the file:
|
Release 03.08.2022
Module | Description |
---|---|
Item | Fix: Deactivated item becomes active when pressing save (RTC-24815) When saving a deactivated item user gets a modal window asking whether to activate the item. The 'submit' (aka default) button is 'No'. There are also Yes and 'Cancel' buttons. When user click 'No', the window with saving changes should appear and after saving changes selected items should still be inactive. When user click 'yes', the window with saving changes should appear and after saving changes selected items should become active. When user click 'cancel' the window should close and nothing happens. |
Label printing | Label types (RTC-24128) Label types valid for item and items for given store can be specified. Label type specified for store level has priority over the label type on the item level. There is always created a label in Breece label type, when store is configurated as Breece store, even if there is no ItemLabelType with this type. |
Price | Fix: Update button when editing price (RTC-24824) It is possible to edit price that are active and have a valid from date in the past. |
System | Fix: Configuration cleared when switching between tenants (RTC-22045) Configuration browser cache is cleared each time the user logs in. Fixes issue when switching tenants that have different configuration (user needs to log out and log in, in order to switch tenants). |
Release 22.07.2022
Module | Description |
---|---|
Export to Excel | Fix: Excel template are duplicated in Excel view (RTC-24495) "Excel template" text is not duplicated in export wholesale prices to Excel view. |
Segmentation | Fix: Scheduled update of promotion offer (RTC-24602) During scheduled update of segmentation in Promotion Management, there is no issue in communication between Item Service and Segmentation Service. |
System | Cleanup of imported items (RTC-20464)
|
Release 13.07.2022
Module | Description |
---|---|
Import | Notifications during import (RTC-22004) When validation/import of an item in import is done, the status header disappears and notification shows up automatically. Import/export of ProductID, Sales code and Bonus flag (RTC-23855) Item attributes ProductID, Sales code and Bonus can be:
|
Item details | Item attributes: Product ID, sales code and bonus flag (RTC-23854)
From 3rd party we can get items with Product ID as item identifier. Sales code is used when different items represents the same item from a customer perspective (for example two oil filters with the same price can used in the same car). Bonus flag is used to mark items that should not give any bonus. All the fields above can be segmented upon. |
Label | Label printing view (RTC-24118) Label printing grid shows all items with changes available for export or print. The grid contains columns such as:
All the columns can be filtered and sorted upon. Permission can be defined on store role level - 'Labels', when role with Label permission is assigned to a store, the user can only see labels created for this store. 'Print Labels' button is shown, but do not perform any action. This functionality will be released later. |
Release 30.06.2022
Validation of VAT when creating store price
In case the item does not have a vat code (or the vat code on the item does not come from the default country or the vat code does not have an active rate), the system displays an error saying "Can not create a price. The item does not have a valid vat code. " when a user tries to create a store price.
During import, there is a validation error informing about unknown VAT code in cases where in the imported file no VAT code is defined:
the given VAT code does not exist in the database
VAT code does not have VAT rate at date defined in import
VAT code undefined:default VAT code for default country not found in db
VAT code does not have VAT rate at date defined in import
Improvements
Module | Description |
---|---|
Import | Fix for import 'default' file type staging (RTC-24157)
|
ItemService | Integration documentation (RTC-24074) Fixed swagger documentation for import, so that it can be used for code generation. |
Release 27.06.2022
Module | Description |
---|---|
Import | Default import of items and prices (RTC-22414) The two file types in the "File type" in imports view that are default when importing from 3rd party:
In the file type "Store price" you can import items with store prices, you can create a new price that will be created with the default price calculation, and update the existing price. You cannot create a new item of this type. RIGAL import files set to Done (RTC-23741) When importing item that does not exist in Item Management (or its price), and if RIGAL file contain rows with 'U', they are rejected and import is set as 'Done' |
Item details | When changing image the new image is displayed for user (RTC-23127) Clicking 'Save' after changing image, does not reset the image back to the previous one. |
Release 22.06.2022
Module | Description |
---|---|
Import | Special characters in RIGAL file (RTC-22777) When uploading RIGAL file with special characters, the system can handle both the UTF-8 and iso8859-1 encodings. Applies to import via import grid and Postman/API. Do not lookup model based on externalItemNo if we don't generate it (RTC-20987) If the "generateExternalItemNO" parameter is enabled and the item has size/color/ExternalItemNO (12 characters) then the imported item is a model. First 6 digits of the identifier.externalItemNo is used to lookup against the modelNo of existing models. |
Item details | Draft item status (RTC-23281) When modifying a draft item, it's status is kept as Draft, both in user interface and import. Draft status is removed when store/wholesale price is set for an item. Image for model items (RTC-23125) Image can be uploaded to model and applied for all sizes/colors or all items. |
Registers | Unit register for multiple countries (RTC-22475)
|
Release 08.06.2022
Module | Description |
---|---|
Import | Validation of import file (RTC-8437) An "invalid file"- message is displayed when a user tries to import an invalid file. The original error is logged as a warning in the Performance tab in Azure AppInsight. Fix for import of RIGAL files (RTC-23691) It is possible to import RIGAL file when the import has StoreGroupId and the content of the file has store prices connected to that store group. |
Item details | Renaming of browsing level in item grid (RTC-22993) 'Model-color view' switch in main Items grid is renamed to 'Variant view'. |
Release 07.06.2022
Module | Description |
---|---|
Export to Excel | Minor fixes (RTC-22553) User interface in the selection view for Export to Excel is modified to make it look better. |
Import | Fix for import of RIGAL files (RTC-23631) It is possible to import RIGAL file when the import has StoreGroupId and the content of the file has store prices connected to that store group. |
System | Cleanup of expired data (RTC-22749) Cleanup from ItemServiceJanitor is carried out by Lifecycle Management in Azure. |
Release 02.06.2022
Module | Description |
---|---|
Import | Use CSV file to manage lists (RTC-23170) CSV file is validated properly when using it to manage selection in item list and item group list. Performance for RIGAL import (RTC-23490) Performance of validation of RIGAL files is improved. Fix for timeout issue (RTC-23341) Sometimes users have had to wait a long time for the import to be validated due to timeout that has be related to system tasks (health checks). Import/export of item attributes (RTC-21946) All attributes described below are exported to Excel and automatically to export file (blob). All attributes described below can be imported via standard JSON import/mass update, and some of them via RIGAL import.
|
Item segmentation | Additional item attributes in Item segmentation (RTC-21943) Item segmentation includes additional item attributes:
|
System | Fix potential security vulnerabilities (RTC-23397) Updated number of libraries to newer versions with patched potential security vulnerabilities (Nothing that would affect us directly though). Updated build definitions to fail when a new security vulnerabilities is discovered. |
Release 24.05.2022
Module | Description |
---|---|
Export to Excel | Fix for users without view store price permission (RTC-22633) When a user without View Prices permission opens export to Excel view, the user does not see 'Price details' section at all, and there is no error message either. |
Import | Import status set to done (RTC-22345) When imported items are:
import status is automatically changed to done. Mass update import with both item attributes and store prices (RTC-17345) The user can import items and prices at the same time using mass update. It is possible to import new items with store prices during mass update import type. Import of store prices with wholesale price = 0 changes the price to 0.01. When creating new store prices, and wholesale price or cost price elements are not provided, they are copied from the active store price at a given date. When calculation rulesets differ, a copy should not occur. "Fixed price" is copied always, regardless of calculation ruleset compatibility. Fix for validation of PRICAT (RTC-23169) Validation during PRICAT import is triggered immediately after following actions:
There is also new parameter TenantServiceBus in tenant admin. |
Item details | New item attributes in item details (RTC-19899) The following item attributes are added to item details:
Permission to manage items and store prices (RTC-18758) Permission 'Manage local items' is a part of store level role. On model level we have a flag that is called 'Managed by store'. A user with Manage local items permission can create only local items (managed by store flag set to true). The user needs to have View items permission and View register permission to make it work properly. Modify item Item with 'Managed by store' flag set to True and without any price can be modified by:
Item with 'Managed by store' flag set to True and with price for store X can be modified by:
Item with 'Managed by store' flag set to False and without any price can be modified by:
Manage prices Price for item with 'Managed by store' flag set to True and without any price can be created by:
Price for item with 'Managed by store' flag set to True and with price for store X can be created/modified by:
Price for item with 'Managed by store' flag set to False and without any price can be created by:
|
Item segmentation | Segmentation on assortment code with multiple profiles (RTC-20912) Users can create a segmentation group with selected assortment codes per profile. When the UseAssortmentPerProfile config parameter is disabled or UsePlanningCode is enabled, profile filters are not displayed. Please note that old segmentations with assortment code filters will not work anymore. |
Register | Activate and edit row in register (RTC-22013) After activation/deactivation of a row in the register and editing some values without closing the modal, grid is refreshed. |
System | Export to Breece ESL (RTC-22644) The field 'alternativeGtin' field is included in the export to Breece. Items with many alternative GTINs, are exported with rows for main GTIN and every alternative GTIN. |
Release 13.05.2022
Module | Description |
---|---|
Register | Import of item hierarchy register (RTC-21554) Item hierarchy can be imported to register by an Excel file. This can be done using 'import' button in the registers view. Import can be used to create new item hierarchy or update existing ones. File should contain every element's number and name (same file template as in export). Fields in the imported file are validated the same way as in the user interface. If there is a gap in the hierarchy, the 'children' are skipped. If 'parent' element is inactive, it's activated after import. |
System | Keyboard navigation on checkboxes (RTC-21168) It is possible to focus on checkboxes using keyboard (Tab key). Checkboxes can be selected/unselected using spacebar key. This applies to all checkboxes in the Item Management module. |
Release 06.05.2022
Module | Description |
---|---|
Export | Retail prices equal 0,01 is exported as 0,00 (RTC-21906) When store price is equal to 0.01 the Item Price export have 0.00 as value. |
Import | RIGAL import of MBXP items (RTC-22809) MBXP item type in import has code that matches MBXP item type in POS - "MxbpWeb". It includes "X","Y" and "Z" item type import. |
Release 28.04.2022
Module | Description |
---|---|
Import | RIGAL import with price deletion (RTC-22086) When importing items from RIGAL file with status=U, and import rows will be set to status Rejected, we will still show any validation error. This is due to the item being updated when a store price is deleted or the item is set as inactivated (when there are no stores with price). |
Item details | Move between items in the items grid (RTC-19019) During moving between items with keyboard system shows correct item hovered when selecting it. |
Item list | Print QR codes for item list (RTC-18523) |
Offer | Segmentation on variant and model level (RTC-20639) Items can be added to the offer using item segmentation on item, model or variant level. After selecting item segmentation and clicking 'add to the offer' button, there is a modal window which asks on what level user wants to add segmentation. The default selected value is item level. After adding items, variants or models to the offer, in the 'Manage items' view, there is a message above the table about what level is used in the item segmentation. Columns in this view match selected level. Export to blob:
|
Register | Product series register (RTC-22147) "Product series" register with fields code, name and description is available at the end of the Category section. Product series are for grouping items together, for example series of drink glasses. Category manager register (RTC-22151) "Category manager" register with fields code, name and description is available the end of the Category section. The register allows defining who is responsible for the given item. Risk item register (RTC-17629) "Risk Item" register with fields code, name, description is available at the end of the Category section. The register allows to define what item is categorized with risks that customer should be notified about when buying the item. |
System | Endpoint for item group lists (RTC-22233) There is an endpoint in ItemService, which allows developers of other modules to get item groups assigned to item group list. Export promotions to Breece ESL (RTC-19994) When a label has a promotion price, both promotionStartDateUtc and promotionEndDateUtc are exported and visible in Breece. No changes to promoitonEndDateUtc (i.e. it's not an actual end date of the promotion, but rather the end date of the label). |
Release 25.04.2022
Module | Description |
---|---|
Item group list | Activate/deactivate item group list (RTC-21540) Item group lists can be activated and deactivated. Column 'Inactive' is added to the item group lists grid. If item group list is inactive, there is a message about it in the item group list details. Such list cannot be used in other item group list. Copy of inactive item group list is also inactive. |
System | Showing date and time in grids (RTC-21537) Time (in grey font) is visible in 'Created date', 'Modified date' in every grid in Item Management and in 'Last updated' column in Items in import view. Filtering in these columns is at the date level. Import promotions and offers (RTC-22463) List of mix types in Item Service database is updated, so 'StagingBatchExecutor' job does not fail when importing blob with promotion which contains one of recently added mixes (6, 10, 11, 31, 34). |
Release 21.04.2022
Module | Description |
---|---|
Export | Stop sale reason code (RTC-22207) Stop sale reason code is exported when changes are done in Item (Gateway.Item). |
Export to Excel | Merging export of items and store prices (RTC-17349) It is possible to export item details and store prices at the same time. User can select only one planning code during export of item details with store prices. When exporting data where items have multiple store prices, the items have multiple rows in Excel file. |
Import | Manual import of RIGAL file (RTC-17388) RIGAL files can be imported directly from Item Management. The import must be approved. It is possibly to add and update assortment code in item via RIGAL import. Immediate trigger of revalidation (RTC-21177) Approval import job is scheduled for running every 30 minutes. We have topic in ServiceBus that is called ExecuteApprovalImport. When creating new import or revalidating existing rows or importing selected lines revalidation is performed right away without any delay. |
Item group list | Public and private item group lists (RTC-21562) Item group list can be marked as private. Then only the user who marked it as private can see it, edit, copy and use in other list. Same as in item lists, item group list can be marked as private when creating new list or in 'Edit name and description' modal in item list view. When user is viewing a private list, a message about this is displayed in breadcrumbs. Private lists owned by the user are marked in the item group lists grid in 'Private column'. Lists owned by other users are not displayed in grid. |
Item list | Activate/deactivate item list (RTC-19909) Item lists can be activated and deactivated. Column 'Inactive' is added to the item list grid. If item list is inactive, there is a message about it in the item list details. Such list cannot be used in other item list or to create a promotion. Copy of inactive item list is also inactive. |
Registers | Export of item hierarchy register (RTC-17635) Item hierarchy register can be exported to Excel file. This can be done using button in registers view. Export is confirmed in modal, and exported file appears in notification when it is ready to download. File contains number and name of Department, Item area, Item group and Item subgroup. When group does not have any lower level group assigned, it will be exported as row with empty cells, e.g. Department without assigned Item areas is exported with only Department value in row - rest of cells are empty. |
System | Fix for SearchIndexing on new tenants (RTC-22300) SearchIndexing was developed when the latest Elasticsearch version was 7.x. Now, when installing new tenants, version 8.x is used for new instances - this caused problems and the job started to fail. |
Release 07.04.2022
System parameters
In System parameters view, user can check and change parameters.
To change parameters you must click on the Edit button to edit settings.
Improvements
Module | Description |
---|---|
Import | Fix for showing current price in import items view (RTC-19915) These changes affect Store price mass update and Bladcentralen so imports where user defines store groups in the dialog. In Imports page user should see 'current prices' for the store group selected when importing file. If there is more than one store group then we show values for the first store group from the list. Notifications when importing (RTC-18543) There is no validation notification when import is auto-approval. After non-approval import of only one item, import-success-notification shows button "View item" In non-approval import of multiple items, after successfully imported items, system shows notification that "X items were imported successfully". |
Item details | Rounding fix for sales statistics (RTC-21610) Fix for nutritons (RTC-17908) The nutrition table and button in 'food' fieldset have been improved |
Price | Show currency in active store price column (RTC-20208) Currency from active store price is visible in active price column, when user creates new store price with other currency than in active price. Fix for create store price with currency SEK (RTC-21918) If in db no currency has IsDefault=1 then set IsDefault=1 on currency which is set on MainCurrencyCode configuration parameter. |
Release 30.03.2022
Module | Description |
---|---|
Export to Excel | Templates for export to Excel (RTC-19532) Checkbox for applying template is removed so template field is visible right away after opening Export to excel page. There is a 'Recently used' section that shows last used 3 templates. They are stored in the web browser. After clicking template from this section list is reordered so the last used template is displayed on top. |
Import | Item control for Bladcentralen files (RTC-21191) 'Total number of rows' and 'Not imported' are displayed in the breadcrumb after opening an import file from Bladcentralen. Import of items with wholesale price = 0 (RTC-21492) When importing a RIGAL file which has wholesale price = 0 (Engros field), store price is created and wholesale price is set to 0.01. Fix for import of UnitPriceFactor in RIGAL import (RTC-21691) Import RIGAL file with 0 in UnitPriceFactor value does not make any changes in value. Filtering of import row status (RTC-18224) Only statuses that exist in the given import are visible in the status column. Import (and export) of assortment codes per profile (RTC-19693) UseAssortmentPerProfile config parameter == true, profile sub-columns are available for "AssortmentCode" and "AssortmentName" columns. All profiles that are active in the system are included Sorti field (7.1.47) is added to RIGAL import (assortment code) "Unknown store group" validation error is added when profile not found during RIGAL import. |
Item details | Stop sale (RTC-19274) In Sales section there is a Stop sale field. It`s used for stopping sale of items that are not good (for example Salmonella in food). When this flag is set to true then we get mandatory field 'Reason code'. Item with new flag checked gets status 'Stopped'. For draft items this flag is disabled. |
Price | Use default values for price calculation when creating wholesaler price (RTC-20309) The wholesale price is created according to the following priorities: The calculation ruleset is copied from: Existing wholesale price (should set price calculation) > Item group (should set price calculation) > price calculation (from default price calculation). |
System | VAT codes (RTC-20754) VAT codes field depends on the setup in Country register. VAT codes get list of possible values for country marked as default. It affects field in item details, PRICAT import rule and RIGAL import. |
Release 14.03.2022
Module | Description |
---|---|
Import | Bladcentralen import (RTC-20991) Support both separators for decimal values: comma and dot. Validation of multiple imports (RTC-21134) When multiple imports are being validated in one job execution (e.g. two files uploaded at the same time), the 2nd file should no longer fail with an exception. |
Item details | Item status (RTC-20534) Active status is not displayed in item details. Long texts in product information (RTC-21366) Fields in Product information section are defined as long field. It means there is not limit of characters and full text is displayed when viewing item. There is no need to change size of the field manually as before. Field height is set automatically. Show QR code in item details (RTC-18522) In the 'Item' section on 'Item details' view, there is a 'Show QR code' link. After clicking it, QR code appears. It contains GTIN of the item. When QR code is displayed, there is a 'Hide QR code' link to hide it. By default, a QR code is hidden. |
Item group list | Export to Excel (RTC-19925) There is a button in the Item Group List view named 'Export group to Excel'. By clicking on it, user is able to export item groups that match filters in the grid. After export, notification with link to exported file is displayed. Import item groups from file (RTC-19404) In item group list view, there is a 'Use file' button on bottom of the screen. It opens a modal in which the user can select a CSV file. Item group numbers in this file can be used to include or exclude item groups from the selection. Imported CSV file must contain one column with 'ItemGroupNo' header, and item group numbers as values in this column. When a file is invalid, a validation error is displayed. When a file contains item groups that do not exist in the system, there is a message at bottom of screen. |
Item list | Select/unselect items in model/variant/item level (RTC-20673) State of checkbox in the first column in item list grid, which shows selected/unselected/all items, is kept when changing 'browsing by' levels. Public and private item lists (RTC-19624) An item list can be marked as 'Private'. When item list is private, only owner can view and manage it. User can mark item list as private and assign it to himself using checkbox in 'Create item list' and 'Edit name and description' modals. Privacy of item lists is shown in 'Private' column in item lists grid. Item lists assigned to other users are not displayed in the grid. When editing item list, information about item list being private is displayed in breadcrumbs. When copying private item list, copy is private as well. |
Price | Price zones (RTC-17797) Store prices can be created on the following levels: store, profile and price zones. (All labels in Item Management are renamed from 'team' to 'price zone'. |
Registers | Treatment Type (RTC-19928) 'Treatment Type' register contains fields: code, name, description. It is possible to add, edit, deactivate and set as default rows in the register. |
System | Fix for long texts (RTC-17928) Long texts are wrapped inside the multiselects field |
Release 03.03.2022
Module | Description |
---|---|
Import | RIGAL import (RTC-20692) Three new values of Vtype in RIGAL import files:
RIGAL import with deleted store prices (RTC-20772) RIGAL file with value "U" in 7.1.5 field delete active store price in existing item. In cases when existing item does not have a store prices or item not exist, import is mark as rejected and does not make any changes. Label Processor does not create a label when store price is deleted. Edit import row (RTC-18566) Edit row function is available for the following imports: PRICAT, Temalogic, Mass update-item details, RIGAL and Bladcentralen. This function lets the user modify the following values in the file without importing a new file: Item text, Color text, Size, Sales unit, Item group, Item subgroup and Brand. Clearing values is not supported. After saving changes (Done) the row is revalidated. Null values when UsePlanningCodes is False (RTC-17801) When UsePlanningCodes is set to "False" then two attriubtes get Null value: Planningid and Storegroupid (season.itemplanning table). Storegroupid gets Null regardless of defined value in system parameters (SingleWholesalerStoreGroupExternalReference) |
Price | Create store price based on wholesale price (RTC-19865)
|
Register | Scale label register (RTC-19904) Scale label register is placed under Food section. It is a simple register where user defines code, name and description. User can manage existing rows. Available actions: update, deactivate and set as default. |
Release 24.02.2022
Import control
5 columns are added in the Import grid: 'Total no. of rows', 'No. of rows not imported', 'Store group level', 'Store group code', and 'Store group name'.
'Total number of rows' and 'Not imported' are displayed in the breadcrumb after opening an Import.
Wholesaler prices without using planning code
(RTC-14138)
When UsePlanningCode=False, planning code field is not visible in import grid, prices grid, wholesale prices, and exported Excel files. It is also not possible to create discount per profile in wholesale prices.
In a view where the user selects column to export, fields store group retail price excl. VAT, store group discount percent, store group discount amount, store group net price, store group margin percent, store group margin amount, store group campaign discount percent, store group gross profit for stores percent, store group recommended retail price are not visible.
Improvement
Store prices in promotion on store group level (RTC-20743)
When promotion is created on team or profile level, and item has price in store that belongs to selected store group, this price will be used in offer.
Release 22.02.2022
Module | Description |
---|---|
Import | Search & import item (RTC-18379) There is an 'Import selected item' button that allows user to import a specific item from Items in imports view. It is also possible to open details of the given item directly from this view (overflow button). Label text fields in RIGAL import (RTC-20649) LabelText2 field is imported from the RIGAL file. |
Item details | Delete GTIN (RTC-19831) If an item has more than one GTIN the user can manage existing GTINs, and use function Delete GTIN. This action cannot be reverted, as GTIN is deleted from database. |
Item lists | Browse by variant level (RTC-20007) In the top right corner of the item list view, there is a link to browse items on variant level. In this mode, items in are grouped by colors within the model. Using this mode user can select and unselect all items from the variant. When not all items from the variant are selected, variant appears with '-' symbol in the checkbox. In variant level, only columns with values per variant are displayed in the grid. Last selected mode of browsing is remembered by the browser. |
Item group list | Use existing item group list (RTC-19405) When managing new or existing item group list, user is able to define selection by using existing item group list. After clicking 'Use item group list' button, user is moved to the a view with existing item group lists. Lists can be used for removing or adding item groups to the selection. |
System | Integration with Breece ESL (RTC-20459) Standard configuration creates labels every 5 minute and export every 2 minute. |
Release 14.02.2022
Handling of gross profit in imports (RTC-18124)
Importing store prices with very big gross profit will not fail the entire import.
(Gross profit bigger than 999999%, caused by low net price and high retail price provided in the file)
Item details - Assortment codes per profile (RTC-16844)
Configuration parameter: UseAssortmentPerProfile: True/False (default is False). When True, the user can set a different value for the assortment for all the profiles in the system.
User interface is looking a a bit different when there is more than 5 profiles in the system.
When planning codes are enabled, the value of the parameter above doesn't have any effect on the system.
VAT amount in store prices (RTC-20409)
When overwriting existing store price, VAT value is taken from item details, and its amount is calculated properly.
When browsing existing store price, correct VAT value is displayed (the one which was assigned to item when creating this price).
Release 09.02.2022
Non-model items system parameter
If model items are used, "Supplier item number" column is hidden in "Items", "Item segmentation - edit group" and "Item list" views.
If non-model items are in use, columns with values which are set per model are hidden in "Items", "Item details", "Item list", "Import details", "Items in import" views. "Model-color view" is removed from "Items" view. It is not possible to use model values to define item segmentation. Model values cannot be exported to Excel. Model cannot be created using "New item" button in "Items" view. "Model" section is hidden in "Registers" view. Grid in "Find item" modal have "GTIN" column instead of "Color" and "Size".
Example on dialog when non-model system parameter is set:
When you set the parameter you must do this after the parameter is set:
Item group lists
In Item Management, there is a 'Item group lists' view. Item group lists work in similar way as for "Item lists". Instead of items, this type of list contains whole item groups.
On the "Item group lists" page, there is a grid with existing lists. Use Create button to create a new group list. Clicking on the list name in grid, opens "Item group list" view. There is a grid with item groups. Using checkbox, groups can be added or removed from the list. Using buttons at the bottom, it is possible to select or unselect all elements filtered and shown in the grid, or create a copy of the list. To view item group lists, "View items" permission is needed. To create lists and manage existing ones, user must have "Manage item group lists" permission granted. In User Management, "Manage item lists" and "Manage item group lists" permissions are placed in "Lists" section on the list.
Improvements
Module | Description |
---|---|
Import | Time in import grid (RTC-18462) We display time in Created date and Modified date column. It`s only information element so filtering is only available on date level. Import in Bladcentralen/Interpress format (RTC-15474) New items/prices can be imported by uploading a CSV file in the Bladcentralen/Interpress format. The user must manually select the profiles/teams/stores for which the prices will be created. The functionality requires permission for "Bladcentralen import". |
Item details | Draft status for items (RTC-18459) Items without any store prices will have a Draft status. The flag 'Ready for sale' can't be changed on items with status Draft and by default is set to false. All items with at least one store price (Active or Planned) get status Active. The flag 'Ready for sale' can be changed on those items. Adding a store price to a Draft item changes the status to Active and the flag 'Ready for sale' to true. For both statuses, there is an option to deactivate an item. It sets the Inactive status on that item. In the Items grid there is a column Status which have replaced the 'Active' column. Model export and bundle items (RTC-20344) Model and color can be exported to Excel properly using button in 'Item details' view. |
System | 'Use model items' parameter (RTC-20225) When we are using model items, 'Supplier item no.' is hidden in item details and cannot be exported to Excel. Certificate handling (RTC-20381) Modules will refresh issuer (Shell) signing keys every 24h. |
User Management | User details in User Management (RTC-17757) After updating user details of logged in user, changes are saved without any problems. Loading indicator is visible only for a very short time. |
Release 28.01.2022
Creating data for label printing and export to ESL systems
When configured, the system will create labels for each item in each store.
In case of multiple prices being available on the item in given store, the system will pick:
For ordinary price, the one on the lowest level (store/price zone/profile)
For promotion price, the lowest price.
Required configuration:
LabelProcessorJob enabled, with a scheduler. Default run once a day at 00:15.
Rows inserted into Label.LabelStoreConfiguration, which specifies that the given store is using labels. For now, only Breece ESL is supported.
Export labels to Breece ESL
When configured, a job will export labels created by LabelProcessor to Breece Cloud.
Required configuration
Insert a row to Label.LabelStoreConfiguration (row per store) that enables creation/export of labels to Breece. Requires to provide Breece config for given store (see technical release notes).
Improvement
Module | Description |
---|---|
Import | Duplicated alternative GTIN (RTC-18171) Items with stolen GTIN by another items during import are exported in JSON file. When item A steals item B alternative GTIN, item B's audit columns are updated. |
Item lists | Browse by model level (RTC-19249) In top right corner of the item list view, there is a link to browse items on model level. In this mode, items in are grouped by model. Using this mode we can select and unselect all items within a model. When not all items in the model are selected, the model appears with '-' symbol in the checkbox. In model level, only columns with values per model can be displayed in the grid. Last selected mode of browsing is remembered by the browser. |
Item segmentation | Item segmentation when planning codes are not in use (RTC-14137) It is possible to use item segmentation with no planning codes parameter set (UsePlanningCodes=False). |
Release 20.01.2022
Item overview tab
Overview tab is divided into two sections:
On the left side, there is a panel with the item image. This section can be collapsed using the arrow button in the corner of the panel. When collapsed, the panel can be opened using the arrow on the edge of the screen, or by clicking 'Show image' link.
On the right side, there is a list of model colors, item details and stock and sales statistics. By default, the colors list displays up to 3 colors. The list can be expanded to show all colors using 'More colors' link, and collapsed using 'Less colors' link. The color list is not visible for non-model items.
Improvement
Module | Description |
---|---|
Export to Excel | Store group name column in Excel store price export (RTC-18921) Excel files created as a result of export store prices include store/team/profile name column. This column is analogical to checked store group level checkbox. |
Import | Duplicate supplier item no. (RTC-19013) Items match when they have the same ItemSupplierNumber and Supplier no (ExternalNumber) or ItemSupplierNumber and GLN. In these situations, existing item will be updated. If an item has the same SupplierItemNumber but a different supplier, a new item is created. The specific error message which includes the details about item being imported and duplicated SupplierItem appears when a duplicate SupplierItem No exists in the database. |
System | System parameters for retailers not using model items (RTC-15632) In Item Management menu, there is a link to 'System parameters' page. On this page, we can select system parameter that specifies what kind of items we want to use: model, or not model items. By default, current parameter value is selected in dropdown list. Selection is saved by clicking 'Save' button. 'Cancel' button brings back current selection of parameters. Permissions for view items (RTC-18670) If logged user does not have "View prices permission" then we don`t send request for checking price when viewing item. It means that for such users 'Price per unit' field is hidden. |
Release 13.01.2022
Module | Description |
---|---|
Import | Mass update of item subgroup (RTC-18877) Mass update includes update of item subgroup. Import of alternative GTIN (RTC-19012) When importing items we check if defined alternative GTINs is not used as main GTIN for existing items. If so then GTIN defined in file is skipped and rest of changes is imported. If GTIN is already used by another item then user gets such validation warning: Tandem GTIN is already used. RIGAL Import (RTC-19015) Item attributes for 'Change VAT'-flag and unit price factor are supported in RIGAL item import.
While importing file we use such fields:
|
Item details | Alternative GTINs (RTC-18688) In item details, user can deactivate GTIN that was added as alternative GTIN. The validation message is hidden after the user has fixed the typed value. |
Item list | Fix for large item lists (RTC-19252) There is no timeout when filtering and sorting an item list with many items selected. |
Price | Default values for price calculation defined per item group (RTC-13304) Price calculation default values can be selected for an item group when creating or editing it. It is not required to select price calculation. Default values of selected price calculation can be defined. |
Shelf labels | Import promotion prices (RTC-18130) Promotion prices are imported (along with promotions/offers as described in swagger) to Item Management (Item Service database) for approved campaigns. Deleting or updating is also supported. Only "Promotion price" price rules items are imported (for other price rules only offer is imported). |
User Management | Updating users from Azure AD (RTC-17261) When a first/last/display name is changed in Azure Active Directory it is always updated in User Management. |