Fix: Export of Order points (RTC-37152)

Adding, updating or deleting order points via user interface on store level triggers export to 3rd party in blob Item.ItemStoreOverride.Export. When performing these actions on order points on common level, blob Gateway.ItemChanges is exported. Export is triggered also when items are updated by import.

Fix: Excel import and export improvements (RTC-37263)

The store number field is not always checked by default in the export view. 
The Stores field and the Include common values option in the export view are hidden and appear when the Include values per store option in the Store local fields section is checked. Active assortment and Scale fields also appear as selectable for export after the above action. Store local values on the common level are not updated when the user does not have Update existing items permission.

Fix: ItemService package stopped after release (RTC-36451)

In a situation that ItemService package is restarted while there is a long execution of a job, it finishes with status 'CompletedWithWarnings' and is resumed after package is correctly started. 

Translation corrections (RTC-36650)

Translations for Quantity in supplier package, Min.ord quantity and Auto replenishment are correct.

Fix: Duplicated prices in the same file (RTC-36159)

When importing a file in which there are prices for the same item and store group, but with valid from date in the past, only one active price will be created. Its price value will be taken from last row imported (with valid from date set in the past). 

Fix: Currency and active status in wholesale price tab (RTC-34589)

Wholesale prices are shown with their supplier currency and amount. By default only active price is visible, but the user can change filter on 'status' column. There is only one active wholesale price for item, even when there are created multiple different prices with the same ValidFrom, then one of them will have status 'active' and the rest 'expired'.

Fix: Removed scales (RTC-35993)

In Excel export, which includes column 'scale', only those scales which are currently assigned to item are exported. Removed scales are not exported.

Fix: Moving items between models (RTC-36812)

Two situations in which it is possible to move model items are additionally supported:

First is importing file with updated items from the same model, but first is moved (by external model number) to another model and second stays in original model. Then items are correctly updated and moved accordingly to imported external model number.

Second is importing file, where item is found by alternative GTIN and is moved to model (by external model number) with the same color/size variant. Item is moved to model correctly, merged with duplicated item and alternative GTIN is assigned as main (previous main GTINs are now alternative). 

Fix: Filter item grid by item group hierachy (RTC-35674)

It is possible to open side panel for filtering on item groups in items grid. User can select item groups to filter on from dropdown checkboxes segregated according to group hierarchy. Deactivating certain element of group hierarchy is possible only if all 'children' elements contained in it are inactive. There is an error message shown on the bottom of the page when the user tries to deactivate element when there are active 'children'.

Fix: Item-store link is created when a store is added to a profile (RTC-32934)

When creating prices for profiles or price zones (with system parameter 'active assortment' disabled) item-store links are created for every active store, which is contained in 'higher level' store group. If a new store is created and added to an existing profile, for which prices are already created, item-store links on items with these prices are created for this store. The same happens if an inactive store is activated or already existing store is moved to a profile. When the system parameter 'active assortment' is enabled, for newly added store item store-links are only created when the item is added to this store's active assortment. 

Break bulk flag instead of break bulk code register (RTC-34512)

Break bulk code is obsolete and not visible in the user interface, both in the register and item details. Break bulk is a flag, by default set to false, that can be defined on item. Break bulk flag can be exported to Excel and 3rd party, as well as imported (via Excel, Item.Item and RIGAL). Segments in item segmentation, which use break bulk filter can be counted. If item was created when register was still in use, in database in BreakBulkCodeId column in Item.Item table, there will be an old value, but for new items, there will be NULL.

Order proposal attributes and email for purchase orders (RTC-36339)

Supplier registers have following fields in the procurement section: Text field 'Email for purchase order', decimal  'Free freight' and flags 'Replenishment' and 'Generate order proposal'. Values can be imported and exported via Excel in accordingly named columns from supplier registers view. 'Free Freight' value cannot be lower than 0 and validation for 'Email for purchase order' to be in mail format is added. Export of Supplier register for 3rd party also contains these fields.

Currency rate (RTC-36058)

In contract CurrencyRate the flag 'isDefaultForCountry' indicates if exported currency is set as default one for country in which the store is located in.

Sales unit in Orderability details (RTC-36430)

API GetOrderabilityDetails includes 'localizedSalesUnits', which contains information on sales unit of scanned item (item, which is sent in request) in all languages that the unit has name in the registers.

Assortment code (RTC-36083)

Assortment code column is available in Label Printing grid (hidden by default). Only values on item level are shown. User can filter upon this column.

Export items and prices for new stores (RTC-22481)

All exports from Item Management are maintained via Export.BlobType table. After export we save data in the tables [Export].[ExportHistory] and [Export].[ExportHistoryBlob]. The data stored in the database is: start and end time of export, number of exported entities, type of the entity, blob url. This data is saved after the export of changes for which GenericExport job is responsible.

Import of stock status from Inventory (RTC-35573)

Database is extened with table Item.ItemStock, where information on item, store, different type of stock quantities and audit columns are stored. Stock changes are imported by job 'ItemStockImport' whenever Inventory.StockStatus.Export blob is exported. This blob contains maximum 500 rows and the job can process all of them in one execution. If stock is exported for an item or store, that does not exist in database, the job finishes with status 'CompletedWithWarnings'. 

Fix: Store Local Attributes cannot insert duplicate keys (RTC-36408)

It is possible to import multiple import items with store local attributes for the same item and store. Also, if item already exist in database with store local attributes for certain store, then user can update them and import new attributes for another store. When in import, there are different values for the same attributes on item, the last one imported is set on an item. 

ShelfLabel1 adjustments (RTC-35611)

Long supplier names are cut, if they exceed the length of barcode. Label text, supplier name and assortment code fonts are smaller, to not cut bottom parts of characters. Margins of labels were moved to fit perforated paper. 

Fix: Profile country code (RTC-36374)

Country code in profile is updated in database after changes in StoreManagement user interface. 

Fix: Import file with the same new items multiple times (RTC-36288)

The import can handle creating new items when the file contains copies of the same item.

Missing translations in Price Control and notifications (RTC-34620)

Norwegian and Swedish translations are added to Price control columns and side panel. Default name of the exported file is translated to correct language, depending on language settings when exporting 'Item and price' to excel. In price calculation view previously Margin(GP) is renamed to Margin(Gross Profit) and translated.

Fix: Showing the same row for multiple stores (RTC-35207)

In active assortment grid rows for each item-store pair are shown only once.

Moving items between models (RTC-34500)

Items can be moved between models using import (Excel mass update and Item API), according to the following rules:

• When importing already existing items and assigning external model number, which is already in database, these items are move to model with following external model number.
• If in model there exist item with the same size and color, GTIN from moved item is assigned as Main Gtin, while existing one becomes an alternative GTIN (tandem)
• When an item is imported with a new external model number and that number is available in our system - a new model is created and the item is moved to that model

These rules apply when creating new items as well. Models can consist of combination of variants, that does not follow the same pattern of having size, color or both.

Logging exceptions per item in import (RTC-36042)

If faulted data is imported, ApprovalImport job is finished with status 'CompletedWithWarnings'. Exception is not logged per item in job logs, but is saved in database.

Filtering on supplier number (RTC-36205)

Default filter operator for columns in items grid, which have 'number' in name has been changed to 'is equal to'. This results in faster searching for item by default filter.

Segmentation on external model number (RTC-35182)

The InList operator is available for string fields when creating groups in segmentation.

Database, Import and Export (3rd party) (RTC-19907)

Auto-replenishment, Can be ordered, Stop sale, Weight declaration are in Item.Item contract store local attributes section. 
Store local values can be imported by importing Item.Item. 
Store local values are exported via Item.ItemStoreOverride.Export blob type, values for order points on the common level are exported to Item.Changes. 
It is possible to import order points, edit and delete them. 
Order points imported with a valid fom date in the past will be imported with today's date and the user will receive warning about this during import. Order points imported with a valid from date in the past, when there is already an active value for a store/item pair, will be ignored during import and the user will be notified about it. Valid To date is ignored.
There is a validation in import that order point min must be greater than order point max and values must be greater than 0, the user is informed via an import error.
A table storing store local vales for store-item pairs is added to the database under the name [Item].[StoreLocalAttributes].

Price contract includes total supplier discount (RTC-35003)

Gateway.ItemPrice contract includes total supplier discount. This value is a sum of negative discounts based on wholesale price. Positive values are not included and in a situation, when price calulation rule has only positive discounts, in contract there is exported 'null' value. 

Performance when importing items and prices (RTC-18385)

Import performance is improved by around 50%. When importing from import grid or items in an import grid, validation and automatic import is done without the user having to perform an additional action.  If the validation ends with an error, the import is not carried out. If the validation contains warning, items are imported automatically. The button for PRICAT import and this type of import is removed. 
Files with duplicate new items are imported correctly.

Fix: Update of GTIN in import (RTC-35678)

GTIN can be updated only by users with "update existing items" permission.

Product series (RTC-34663)

Product series column is added in three grids: items grid, items in item list grid and store assortment. Column is hidden by default. It is possible to sort and filter on this column.

Fix: Item grid performance (RTC-35928)

Item grid query is faster.

Fix: Loading of store prices (RTC-35414)

Store prices are loading correctly and request is sent only once when opening StorePrices tab. Changing items between model results in showing correct prices (assign to correct item from this model). 

SKU without leading zeros (RTC-35799)

For new items, SKU is generated with no leading zeros. Next available number is assigned to an item. Updating already existing items has no influence on their SKU.

Order in export from Item Master (RTC-35867)

Whenever item with price is created and activated, the order of blobs exported from ItemManagement is Item, Price, Store link.

Item Order details (RTC-34627)

There is an API GetOrderabilityDetails to the ItemService endpoint, which returns information about whether an item is a consumer unit or a trading unit and information, item properties such as sales unit, whether item can be ordered, quantity in supplier packages, as well as link of linked consumer or trading unit items. When list of trading unit items is returned, default order unit is marked.

Import of wholesale price changes (RTC-34144)

In import details and items in import, there are columns "Wholesale price in supplier currency", which shows the price that is imported, and "Current wholesale price in supplier currency", which shows the price currently active for the given store/store group.  Wholesale prices are shown in these views with the currency code in which they are imported or exist.     
The Pre.Wholesale price column is still visible in the item details view, but will not be used so it is empty.

Fix: Performance when creating price (RTC-35567)

For systems containing big amount of labels, performance of inserting prices is improved. 

Fix: User can't add rows to price calculation setup (RTC-35103)

New rows can be added to the price calculation setup.

Fix: Allowing more filter groups than 32 (RTC-35181)

Segemntations can be created with more filter groups, limit of filter groups in one segmentation is set to 500. Old segmentations containing exactly or more than 32 groups cannot be accessed or changed, new segmentations must be created. For ones containing less filter groups, they can be accessed and calculations are correct. 

Fix: Assigning existing GLN to supplier (RTC-33221)

SupplierNO and GLN must be unique so the user sees a corresponding notification when these values do not meet the requirements.  Error 500 is no longer displayed and the user sees the message "This field must be unique".

Fix: Supplier web address (RTC-32191)

Adding a website address when creating a new supplier is possible.

Fix: Avoid copies of the price created at the same time (RTC-31566)

Updating active and future price does not create duplicate future price for an item.

Fix: Wholesale prices tab timeout (RTC-33359)

Opening wholesale prices tab, as well as filtering on columns is fast. There are no timeouts when loading wholesale prices for item. 

Creating new VAT codes (RTC-33528)

When user creates VAT code which is a first active VAT code for a specific country, this VAT code is automatically set as a default VAT code. Then, when creating prices for that country for new item, user does not need to fill-in field in item details regarding VAT codes.

Stability and performance of item imports (RTC-23586)

Working jobs interrupted by a package restart via Integration Platform management or via Integration Platform package release or via webjob restart (in Azure), is resumed afterwards and completes its work.

Fix for: Assortment code per profile (RTC-33740)

Item is exported after change in assortment code per profile.

Fix: Letters typed in product information fields (RTC-33724)

Product information fields in item details can be filled with "w" and "r" without being taken to price calculation window. Other fields in item details can also be filled with hotkeys letters. 'W' and 'R' takes user to price calculation view with focus on accordingly wholesale and retail price fields, when user is not in any input field.

Order of labels in item lists (RTC-32816)

When printing labels from item lists, it is possible to set order. Items added to item list via user interface have order '0' and will be printed in order by created date ascending. User can add items to item list also by 'use file' option in item list view, then order of labels to print will be set the same as the order of items in the file. Every item added by import gets next available number and will be printed after all items with order '0'. In a situation that user adds the same item multiple times, the order will be set as the last action of adding the item. When excluding items, the rest of the items stays in the same order. Order is not visible in the grid, only when user prints labels from item list. When including items to item list by 'use item list' option, the order of all added items is '0'.

Fix: Searching by Store Number in Store Assortment (RTC-33603)

It is possible to filter on store number in Active Assortment per store view. When the user has permissions to access only one store there is no store number column, so search on store is not possible.

Fix: Timeout when searching in item text column (RTC-33501)

Searching for items by item text column returns results within 30 seconds. Filtering in item texts includes item texts for multicountry localized text (for all system countries).
Following operators are available during the search: is equal to, starts with and contains.

Fix: Searching by GTIN (RTC-33563)

It is possible to search by GTIN in Items in import grid. 

New shelf label types (RTC-30500)

ShelfLabel1 label type is available for use in Item Management. Labels can be generated manually from item details, or when added to label type of specific item, they are triggered by changes in price, GTIN, LabelText1, UnitPriceFactor, UnitPiceUnit, Supplier Name and Assortment Code. On label there is visible unit price, which if is equal to zero ( no UnitPriceFactor and UnitPriceUnit) is shown as retail price value. Layout for printing on vertical sheet is 3 columns of labels and maximum 11 rows on single sheet.

Fix: Creating store price for an item that has a new VAT code (RTC-33555)

Prices are created correctly when VAT rate starts today.

Export currency rates (RTC-32361)

When a new store is created, export of a blob CurrencyRate with all currencies per store is triggered. If currency's End Date is in the past, it will not be exported.

Fix: Excel cannot be exported with VAT code and rate (RTC-33498)

Item is correctly exported to Excel file, when user is exporting VAT code and VAT rate.

Fixed price columns (RTC-18946)

In import items grid (both in items in import and in details of a specific import), user can add to view columns 'Current Fixed Price' and 'New Fixed Price'. Values of those columns are checkboxes, which if checked signify that imported price is fixed. 'Current Fixed Price' shows existing value of flag on an item or on store price and 'New Fixed Price' value of a flag after import of selected file. In import grid 'New Fixed Price' value is either taken from current store price or if there is no previous price for imported store number - from item. The value shown is the same which will be on an item/price after import.

Fix: Multi-language item text: truncate item and model name (RTC-33366)

Item text and model name are truncated to 255 characters when a longer value is imported. 
Items are correctly visible in the item grid and it is also possible to enter item details when there is no default language, or when the default language is different from the language for which the item text is saved.

Fix for gap in vat code rate validity (RTC-30494)

Start date and end date is created with an offset corresponding to the time zone of the country for which the vat rate was created. It is also possible to edit the vat rate if its start date is today or is in the future. Vat rate must be a whole number not a decimal value. The registry only shows vat codes for countries that may be system countries, this also applies to the creation of new ones.

Fix: Performance and filtering in Store Assortment grid (RTC-32926)

It is possible to filter on store number in active assortment view. Default value of filter is set to 'is equal to'. If user has access to only one store, store columns are not visible so it is not possible to filter upon it. Item area values are visible in the grid. 

Changes on item via import (RTC-31620)

Fix for multicountry item text (RTC-33231)

CountryLanguage does not duplicate in the cache, so importing items is possible. 
ItemText containing special characters is correctly processed and exported by GenericExport job.

Wholesale price (RTC-31867)

Wholesale price table contains columns as: Valid from, Status,Valid to, Wholesale price and Net price. 
The table displays the wholesale price that is created during the creation of store price. Unique wholesale prices are shown, which means that even if several stores have the same price, it will be shown only once.
Clicking on the valid from corresponding to the wholesale price will take user to the store price, the open store price is the oldest one (that matches Validfrom date).

Supplier register: Export to Excel (RTC-23340)

It is possible to export supplier registers from supplier register's view by 'Export to excel' button. They can be filtered on and file contains only visible in user interface suppliers and columns (except for audit columns). 'View registers' permission needed. Nulls instead of empty cells are allowed only for 'Lead time (days)' and 'Transport time (days)' columns.

Fix: Brand register: Export to Excel (RTC-23340)

Null brand category values ​​are exported as empty strings. 'View registers' permission is needed to export Excel file with brand.

'Manage assortment codes' button (http://RTC-32121)

Button name is translated to Norwegian and Swedish accordingly to user's choice of used language. 

Export to Excel (RTC-28823)

User can export items from store assortment from 'edit' view. Clicking on the Export items to excel button open a view where user can select store group level, and desired columns. Prices existing on the item for only chosen store group level will be exported, for the rest fields will be empty. Checkbox 'Include value per store' in store local fields is checked as default. For exporting items user has to have permissions 'export to excel from items grid'. If user has access to limited amount of  stores and does not choose which store to export prices or store local values from, they will be exported for all stores item has prices on and user has access to. 

FIX: Removing ID requirement in import (RTC-32757)

Entering 'null' as a value of idRequirement in Item. Item import results is removing it from an item.  When user uses 'mass update' import  'code' columns of Id Requirement have to be NULL in order to remove the values from an item.

FIX: Currency rate at the same day (RTC-32143)

It is possible to edit sales and cost rates in the currency register, when the start date is on today's date.

External model number and ID requirement (RTC-31591)

'External model number'  and 'ID requirement' can be used to create groups in segmentation

API for label printing (RTC-24130)

Sending a request GET api/gateway/Labels/labelType - without store specified - results in receiving a message with all registered label types. The same results will be returned when there is an incorrect store number in the request. In a situation that a store is chosen in request parameters, only label types registered for that store are returned. Sending a non-existing number will show no label types in results. API can choose a language to translate the names of label types by setting parameter 'culture' to nb-NO, en-US, sv-SE, but default language is set to English.

It is possible to add labels to label printing by sending request POST /api/gateway/Labels/print. Label of specified type can be created or be ready to be printed  by request, only when the item has an active price and label type assigned to the item. If the same label has already been printed, it would be set as not printed, but if it was not existing yet, new label will be created.

StagingBatchExecutor job (RTC-32242)

When there is a timeout in StagingBatchExecutor job, it finishes with status 'Faulted' and resumes on the next trigger. In essence, when processing big imports and reaching a timeout - job will be only faulted and resume with processing unprocessed rows in import. 

Import prices with 0 (RTC-32571)

User can import prices, where retail price, net price or both are equal to zero. There is a warning shown when retail price is equal to zero. 

Fix: Filtering on GTIN column with different values of checkboxes (RTC-32616)

User can filter on GTIN column - using GTIN or alternative item (tandem) as value - with all of the options of the checkbox in item lists. Correct results are returned based on filtering in the column and value of the checkbox.

Fix: Sticker 2/3 barcode problem (RTC-32342)

The barcode on Sticker1 and Sticker 2 labels is larger and therefore more visible and scannable.

Filtering on GTIN  (RTC-31155)

Default filtering on GTIN column in: Label printing, Import details, Items in import, Item lists view is "is equal to". User can look for an item using GTIN value in this column, as well as Tandem GTIN value.

Mass update import: Deleting prices (RTC-31884)

Importing item with price in mass update containing column "Price is deleted" will have following impact on prices: If value is set to TRUE, all of the prices for given store group (profile/price zone/store) are deleted for this item. When prices are deleted for profile or price zone and item has also price on store level - and store is part of that profile/price zone - store prices are deleted as well. Importing value FALSE is not deleting any of prices, as well as leaving values in column empty.

Fix: Item area column (RTC-32069)

Item area column shows correct values on items,  both in items grid and items lists view. It can be filtered and sorted upon. 

Use file (RTC-31872)

Including or excluding items in the item lists can be done using alternative GTIN (Tandem) as values in column GTIN. Tandem GTIN values are used only as a lookup for an item.

Multicountry: Store prices with time / Always create new price (not edit) (RTC-30820)

• Valid from date and time is displayed in store price details and in store price grid. It is possible to create a price with the selected time. 
• In the user interface it is not possible to edit active price. Only the future price can be edited via user interface. If the user wants to edit active price for given store, user creates a new price.
• When importing price that has valid from in the past (past = can be the same date, but 2 hours earlier) new price is created.
• Future prices can also be edited via import.

Price control grid (RTC-31424)

Column informing of price suggestion status is named 'Update type' and can have values such as 'New' or 'Price change'. There are links in price control and price control history grids, on the 'item text fields', that open item view for selected item. User can also click on a link on 'active' and 'new' retail price in price control grids, it will take it accordingly to a current store and source profile price view. In both price control and price control history grid, there are 3 frozen columns always visible to a user - 'Valid from', 'Gtin' and 'Item text'.

Brand register: Export to Excel (RTC-31001)

It is possible to export brand registers from brand registers view. They can be filtered on and file contains only visible in user interface brands and columns (except for columns containing dates/users). 

Fix: Item search modal (RTC-32232)

When selecting an item in item search modal (deposit and substitution item), the form is updated with it.

InternalSupplierNo in export of item changes (RTC-28310)

InternalSupplierNo value is added to supplier in export of item changes.

Barcode on sticker labels (RTC-31465)

• The barcode on sticker labels is taken from Sales code
• The barcode is encoded in code 128
• The labels are scannable

Price calculation (RTC-29715)

Margin (GP) % is calculated as (Retail Price excluding VAT-Net Price)/Retail Price excluding VAT. Boundary conditions for values are +100% and -10000%, when they are reached system parameter set in system is used for calculating its value. Very high or low values of margin percentage are rounded in UI to +100% or -10000%, but in calculations they're below this value (user can click on margin percentage and it's visible).

Import performance (RTC-27780)

Database queries are optimized to improve performance when importing items.

Weight declaration (RTC-31224)

Weight declaration field is 50 characters of width (more or less it depends on the characters). When editing this field user sees a horizontal scroll bar that informs about reaching the limit, the words that are behind the scroll bar are moved to the next line.

Database maintenance fix (RTC-27620)

ItemServiceJanitor: Deleting indexes in nightly trigger of jobs is refrased, so the job is not faulted.

Price import (RTC-31167)

When sending an Item.ItemPrice blob with 'deleted' status on price: if any prices for this storegroup exist on the item, they are removed. If there isn't any price for presented storegroup, contract is ignored and price is not created.

FIX: Fixed price on store price (RTC-31167)

If sent store price has ValidFromDate in the past and price is the same as it was before, but the flag on Fixed Price is different from current store price, price is updated.

Active Assortment (RTC-30823)

Columns in Active Assortment view can be filtered and sorted upon.

Fix: Print labels as store user (RTC-30196)

There is no 'Store' dropdown in print label modals if the user has access to only one store.

Changes have been made to the manual printing labels from item details and item list.

Better performance when exporting to Excel (RTC-30016)

When exporting all items/all store prices the performance is much faster.

FIX: New price created all the time when ValidFrom is in the past (RTC-30993)

• A new price is not created when it is the same as the currently existing price.  If the price in the system has a validFrom of 2021 and we update it with a price with a validFrom of 2022 but the prices are identical, new price is not created.
• A new price is created when it is different from the existing one. If the price in the system has a validFrom of 2021 and we update it with a price with a validFrom of 2022 but the prices are other than existing one, a new price is created. 
• A future price is always created.
• In case there are multiple prices within a single file for the same item/store/store group, where all of the prices have validFrom in the past, the last one (by order of appearance within the file) will be used.

Store prices in local time (RTC-25902)

Valid from in local time is exported with price in FromDate field. Obsolete version of valid from date is still exported in FromDateUtc field.

FIX: Keeping values when Excel import does not contain values (RTC-30617)

When updating item via mass update (Excel file doesn't contain following columns) values from these fields are not removed:

• substitutionItem
• riskItem
• categoryManager
• productSeries
• scaleLabel
• treatmentType

Price control (RTC-12193)

Price control entry can be found in main menu, under "Item" section. In right top corner there's Price control and price control history switch grid button. It is possible to navigate to price control history from price control grid. To access this grid user needs permission "Approve prices" on store level. 

Improved performance of Swagger user interface (RTC-30314)

Performance of Swagger user interface is improved. Loading of docs takes visibly less time. There is a new button that copies file-type name to clipboard. 

Import of unit price factor (RTC-29077)

If any of the fields unit price factor or unit price unit are specified, both are required. When importing, there is a validation error if there is only one field specified in the import file.

Generation of model number (RTC-27887)

The smallest value of generated ModelNo is 100 000, and the biggest value is 99.999.999.

Label types for stickers (RTC-29281)

• Three label types: Sticker 1, Sticker 2, Sticker 3.
• It is possible to print the labels on a stickers in a roll.
• Label size is 75x33mm.
• Sticker size is 45x23mm.
• Information on the label (Sticker1):
  • Price
  • Item text
  • Barcode (Code128) containing Sales Code
  • Sales code
  • Comparing price (price/liter, price/Kilo etc.) when that exist
• Information on stickers (Sticker2 and Sticker3):
  • Sales code
  • Barcode (Code128) containing Sales Code
  • Printing date (Sticker2 only)
• The currency symbol on the labels is Euro.
• Number of sheets required in printing modal doesn't appear for Sticker1, Sticker2 and Sticker3. 

Revert to "ready for import" (RTC-29703)

Reverting import to "ready for import" changes status of an import and triggers revalidation. 

Label types section (RTC-29834)

When there is more than five stores in the label types section, only top five of them are shown. There is a button underneath them, which takes the user to another view with list of label types per store. Label types that are on 'All stores' level are shown first.

Printing labels from item list (RTC-24213)

• User can print/create labels for all items in the item list.
• When not all items within the item list have prices for the selected store, user will see a warning that X out of Y items don't have prices for selected store. 
• User can print/create max 1000 labels from one item list
• Stores in the model are filtered by the user permission 'Manage store local values'
• Label types are filtered by the label type register. 
• Items that do not have a price for the store, their number is shown to the user in the notification. It is still possible to create/print label for the remaining items.

Import of franchise store flag (RTC-29209)

Price control is used for franchise stores. The FranchiseStore flag is updated based on changes in Store Management. 

Import of supplier item number (RTC-28902)

Import of RIGAL format supports RIGAL field 7.1.125 as an alphanumeric supplier item number.

FIX: Update of Item name (RTC-29313)

In non-model items, the model name is changed to the value imported in the item text field.

Model name for non-model items is updatable after changing item text manually in item details view.

FIX: VAT code when switching items within model (RTC-29313)

VAT code does not disappear when moving between model items.

Warranty type (RTC-29463)

The maximum value for warranty months is 999.

FIX: Large number of rows in label printing grid (RTC-29787, RTC-29907))

There is no timeout when opening label printing grid, and filtering is fast.

FIX: Alternative GTINs (RTC-29827)

• To manage GTINs/alternative tandems user needs 'Update existing items' permission or 'Manage local items' permission and item needs to be manage in store (where user has permission).
• Managed by store checkbox is visible on non-model items.

Permissions for alternative GTINs (RTC-28462)

User that does not have 'Update items' permission cannot add or remove GTINs/alternative GTINs. User that has this permission or Manage local item (and the item is managed by store), can add or remove GTINs for items.

Grid in model/variant/item level (RTC-24923)

State of grid is kept when changing 'browsing by' levels and after a page refresh.

Weight declaration (RTC-28385)

• Weight declaration is shown in its own section (one column).
• The whole text is visible in the preview.
• Text is editable in modal, in a text area roughly 40 characters wide and 20 lines in height. If the text is longer scrolling appears.
• Modal has the ability to decide whether to save the change on all elements/sizes/colors of the model.

Processing of labels (RTC-29689)

LabelProcessor perfomence is slightly better.

Export of alternative GTINs (RTC-29328)

• Deleted alternative GTINs are exported as 'Deactivated'.
• When an alternative GTIN is 'moved' from item A to item B, then alternative GTIN is exported with item B and item A has null value.
  
  

Stability in approval import (RTC-23108)

When a long running job is running, and a package is restarted via Integration Platform Manager or via release of Integration Platform package there is no exception and validation/import is resumed in next job execution.

FIX: Export of labels to 3rd party (RTC-29473)

Only the latest labels are exported (if there are more labels not exported). Next job execution doesn't export older labels.

FIX: Converting PLU field (RTC-29401)

When converting scale labels to Myhrvold in ItemServiceOnPremIntegration package, field PLU contains digits 3-8 from the GTIN. When these digits have leading zeros, they are removed. 

FIX: Manually printing label (RTC-29349)

When manually printing a label, the generated label is compared to the latest one, not the first one created.

FIX: CountryCode in profile/team (RTC-29383)

StagingBatchExecutor job is not aborted when a store is imported from Store Service with CountryCode = '' (empty string) in profile or team.

Printing future labels (RTC-25130)

Import of country linked to stores (RTC-23087

• CountryCode is updated only when storeGroup has 'Profile' type 
• New column in Chain.Store table - AddressId
• Store address is saved in the dbo.address table. The correct address id is assigned to the store
• All stores have AddressId (possibility to assign address to it)

Export of external model number (RTC-29023)

ExternalModelNo is exported from Item Management to JSON file.

FIX: Print of amount on labels (RTC-28948)

When store price amount is in whole kroner, the .00 øre is printed.

Fix for Myhrvold scales (RTC-28851)

ConvertItemLabelToMyhrvold job doesn't fail when exporting labels on items that don't have unit price unit and unit price unit different than stk.

FIX: New item without supplierNo (RTC-28459)

• SupplierNo is a mandatory element of the imported new item. If it is not in the import, there is a validation error informing the user about it.
• ItemGroupNo is a mandatory element of the imported new item. If it is not in the import, there is a validation error informing the user about it.

Export to Myhrvold scales (RTC-27932)

• Unit and calculateUnitPriceInScale flag are exported in lowercase.
• Unit piece is exported as stk.
• The delete action is sent for items that have deleted item store links and for items that have been deactivated.

Multi country VAT code (RTC-22544)

• List for VAT codes for countries appears when there are multiple system countries in the country register
• Only system countries are exported (both Excel and blob)
• If there is no attached VAT for the country in the import of the item, the default is set. If VAT exists in the import, it is assigned to the item, (non-system countries are skipped, with an appropriate warning)
• The default VAT code for a country is assigned when creating a new item. If the default VAT code is not set in the registry, the field remains without VAT value
• VAT code is required only for the default country when editing item.

Print label from item details (RTC-28033)

• User can print labels for a specific item from the item details view.
• The button is visible only when the user has the label printing permission
• The store picker in the modal shows only the stores that the user has permission
• User can manually create label or add it to label printing
• Label can only be created for a store that has a price
• Store that has 'None' label type or no label type assigned in the register is unable to create a label (the choice of label type is blocked)
• The label type picker in the modal shows only the label types that are in label type register
• Labels created manually have a Manual label trigger reason

Fix: Import from Promotion module (RTC-28648)

There is no timeout in StagingBatchExecutor  when importing  and staging a lot of OfferItems from Promotion Module. The promotion package is updated to 1.6 and new type of offer mix type (100) is supported.

Export of item status to 3rd party (RTC-26850)

• Scale labels are exported with Item Status.
• Exported scales have their status exported as well (Active or Deleted).
• When scale link is deleted from item, their scale status is exported only once.

View and manage labels for store users (RTC-26783)

• For label printing there are permissions: 'Manage store local attributes' and 'View store local attributes'.
• In order to view label types on the item, user needs 'View store local attributes'. No matter the level of role with this permission, user will always see the label types on the 'all level'. For other levels, the visibility should be filtered by the access of that permissions.
• If the user does not have the manage store local attributes, the 'manage label types' button is hidden.
• In order to modify label types on item, user needs 'Manage store local attributes'.
• User needs the permission on 'all stores' to be able to add the attribute on 'all stores level'. Otherwise, he can only manage it on stores that he has access to. 
• When a user has 'Manage store  local attributes' on store 100 (and no 'View store local attributes') he should still be able to view the store local attributes on store 100. I.e. 'Manage' permission should implicitly give 'view' on all stores (that have the manage permission + labels on all store level).
• Without those permissions, user does not see label types on item at all. 

Fix: Change ValidFrom to today (RTC-28194)

Fixed import when importing file without price.

RIGAL import of supplier discount and fixed price (RTC-27561)

EkoPallet label type (RTC-27824)

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.

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.

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.

Performance for dynamic segments (RTC-27540)

• The method GET ItemSegmentations/GetItemsWithPrices [id] returns results faster, there's no timeouts when requesting prices (if they are, they're related to bug in Promotion that will be fixed in: RTC-27395 [Promotion] Add indexes to the views)
• Method return top price for an item (in list)
• The hierarchy for returning prices when making promotion is (the same):
  • When filtering by store - store price, with fallback to profile and then price zone.
  • When filtering by team - Price zone price with fallback to store.
  • When filtering by profile - Price zone price with fallback then store.
  • When no filtering (promotion on all stores)- Price zone price -> profile -> store. 

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.

Import of alternative GTINs from Excel (RTC-26789)

Excel can be used to import and export (mass update) alternative GTINs.

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.

Avoid generating labels for specific items and specific stores (RTC-25063)

• Label type 'None' can be added to specific stores (both in item details and in label type register).
• If an item has label type none, no labels are created for it.
• By adding none label type to the store, it can be the only label type for that store. If there are other label types in the store, there should be validation error when trying to add 'none'. 
• The label type 'none' can be added on the item level, even if it doesn't exist in the register.
• When adding 'none' to register for a given store, it is always added as default (and must be the only 'default' label type for the given store).
• 'None' label type can be exported only per store. 
• When importing items and Excel/file has 'None' in store, it wins over any other label types (i.e. ignore the rest). 'None' imported as common will be ignored.

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.

Import status (RTC-23195)

• When validation/import is in progress, there is a percentage next to 'Validating... 10%' or 'Importing...'. The percentage shown is updated after validation/import of each batch is processed (500 items).
• Validation/import percentage is visible for all users.
• The percentage updates automatically, same as "No of rows not imported". 

Fix: Managing scale links (RTC-27428)

User that has 'Edit items' permission can add/remove scale links to/from item.

3rd label type (RTC-26757)

Label type EkoPallet is added to label type register

Scale register (RTC-26376)

Scale can be added to scale group from scale group register view.

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.

FIX: Creating register values during import (RTC-26933)

• When importing file with many items that has brand that is not in the register and there's space in one of the brand codes (for e.g. 'CODE1' and 'CODE1 '), space is removed and new brand in register is created.
• When importing model item with new subgroup or new item group and subgroup that are not in registers, they are created during import.

Search for item/price imported for given item (RTC-26793)

When searing for an item in imports, available columns also includes:

• Created by
• Created date
• Modified by
• Modified date
• Store group code
• Store group level
• Store group name

Keeping good performance on filtering and sorting on these columns will be developed later.

Print label from item details (RTC-24121)

• User can print labels for a specific item from the item details view.
• The button is visible only when the user has the label printing permission.
• The store picker in the modal shows only the stores that the item has labels for (+ filtered by user permissions).
• When the label is printed, it's marked as printed/current.

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:

• When imported item has GTIN with 13 digits and starts with 20-25, then second digit is set to 0 and last 5 digits is set to 00000
• When importing item with GTIN 2x and item with GTIN 2x exists, the 2x GTIN is moved to tandem and set main GTIN to 20x. The last five digits are also set to 00000
• When importing item with GTIN starts from 20-25x and item with GTIN 20x exists, the existing item will be updated.  
• In the import items view, the GTIN visible in the grid is the original GTIN. 

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.

Import of alternative items (RTC-27188)

Fix: In case of alternative GTINs for an item and scale links per store for an item.

• When applying changes to item with many alternative GTINS, search indexing job works properly
• When exporting item with many scale links to Excel, file is exported with all scale links

Create item with 20-code (RTC-25881)

The check digit is not validated when manually creating item has GTIN starting with 20.

Fix: Filtering in label printing grid (RTC-26984)

• When filtering a column user can input the value and filter by clicking 'Enter'.
• Store number is not decimal.
• EAN/PLU in heading is changed to GTIN.

Supplier's internal identifier (RTC-24871)

Supplier export to blob contains supplier id as 'internalSupplierNo' field.

Fix: Items in import (RTC-26383)

Item in import can be searched easily without a timeout.

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.

Fix: View items (RTC-26788)

User needs only 'view items' permission to see items (there is no server side error).

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.

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.

Label type register and manage label type view (RTC-26389)

When adding label type on item:

• The default selection is 'All stores'
• Label types are not be preselected
• When label type in register is on 'All stores' level, user can add any store for that label type on item
• If user selects a label type that already exists, there is an error that this is already added.
• Available label types are shown based on chosen store
• When in register there are two types of label types A,B  with 'All stores', but there is also label type A on specific store, then on item level when adding the label type A with this specific store, it's not possible to add label type B for this specific store

Use Excel to link item to scales (RTC-25743)

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

Export item and price changes to scales and 3rd party label system (RTC-25745)

• When a scale is added to an item, an export row (label) of the corresponding label type is created.
  • When another scale within the same store/labeltype is added, a new export row (label) is created (in order to export the label with a new scale code). 
  • When the scale is deactivated, export rows are no longer created (or include it in the export).
• Export rows (Labels) are created per item/store.
• Item.Label.Export blob is extended with a list of scale codes.
• LTG label type is added.
• Myhrvold label type is visible in Scale register instead of Label Type register.
• When filtering by label type in the label printing grid, only EkoMini and EkoMaxi label type are visible.

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.

Fix: Scale links (RTC-26513)

Scale links are saved on item when user clicks save button in scale links view.

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.

Applied only for non-model items so far.

Better performance when exporting from ItemService (RTC-25985)

• Export of items and item prices are using row version instead of using ChangeTracking. There are indexes on RowVersion for these tables
• SearchIndexing (Elastic search) is completed after export of Item changes
• Changes are exported in batches of value established in GenericExport AppSettings
• Fix for paging on ItemPrice, now it does a scan on StorePrice table if there are many rows in changetable.

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

Labe type register (RTC-24129)

Label types register is used for defining what label types is used by all stores or by specific stores.

• When adding label type on item, only pairs of Label Type and Store that are in the register can be added.
• • When label type in register is on all stores level, in item details it can be added on all stores as well as for specific store.
  • When label type is registered is for a specific store, in item details the label type can be added only for this store.

Myrhvold label is removed from register (it's has scale Category), LTG label is added to 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'.

Export labels (RTC-24210)

Labels with Myhrvold label type are exported to blob.

Creating labels (RTC-25057)

• When a label type is added to an item (common or store), new labels (including current and future) are automatically created.
• When a label type is removed from an item (common or store), all future labels (of that type) are removed.
• When a label type Z is added on store A and an item has a common label type Y, all future labels on of type Y on store A are removed (and of course new labels of type Z are created). 
• Labels that are of type ESL (Breece), are not removed when label types for printing are removed (common or store, current or future).

Imports set as Done (RTC-24238)

All existing imports that have all imported or rejected rows are marked as done.

Label type (RTC-25061)

EkoMini label type can be selected when managing label types.

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.

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.

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.

Fix: Uploading an image to non-model item (RTC-24538)

Uploading an image to a non-model item works fine again.

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:

• Item list: Sku, MainGtin, ExternalItemNo,
• Item group list: ItemGroupNo.

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

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.

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

Fix: Excel template are duplicated in Excel view (RTC-24495)

"Excel template" text is not duplicated in export wholesale prices to Excel view.

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.

Cleanup of imported items (RTC-20464)

• Janitor job continiously runs every minute (on 18th second).
• The 100 oldest rows of import, that are older than 180 days, are deleted from database, including empty imports.

Notifications during import (RTC-22004)

When validation/import of an item in import is done, the status header disappears and notification shows up automatically.

Item attributes: Product ID, sales code and bonus flag (RTC-23854)

• Product Id (Item section)
• Sales Code (Item section)
• Bonus (Sales section)

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 printing view (RTC-24118)

Label printing grid shows all items with changes available for export or print. The grid contains columns such as:

• Valid from, Store, Item text, Brand, Promotion price, Label text1, EAN/PLU - which are shown in default view.
• Brand, Member Price, Label text 2, Supplier name, Supplier item no., Volume, Weight, Eco label, Created/Modified date, Created/Modified by.

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 perfom any action. This functionality will be released later.

Fix for import 'default' file type staging (RTC-24157)

• When sending file with blobtype 'item' and with 'default' ApprovalRuleset (or without ApprovalRuleset) import is created in db and scheduled for ValidationAndImport.
• When sending file with blobtype 'item' and with filename containing text 'swisslog' directly import contents of the file without creating import in db.

Integration documentation (RTC-24074)

Fixed swagger documentation for import, so that it can be used for code generation. 

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:

1. Item ("Default" approval ruleset is named "Item")
2. Store price (BlobType ItemPrice)

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.

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. 

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.

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.

Unit register for multiple countries (RTC-22475)

• When a country is set as a system country, it adds two inputs (from this country) in the unit register. 
• Only a subset of countries can be set as a system country + English
• When exporting Excel there is only one column with 'Unit' and exported trading unit is the one that is set to default country.
• When exporting JSON contract there is field 'UnitWithTranslations', it is exporting an array with values for each language.

Validation of import file (RTC-8437)

An "invalid file"- message is displayed when a user tries to import an invalid file. 
This occurs during imports:
Item / Model grid -> New mass update
Import grid -> New mass update
Import grid -> RIGAL import
Import grid -> Bladcentralen import
Import grid -> New manual import
Import item grid -> Modify file

The original error is logged as a warning in the Performance tab in Azure AppInsight.

Renaming of browsing level in item grid (RTC-22993)

'Model-color view' switch in main Items grid is renamed to 'Variant view'.

Minor fixes (RTC-22553)

User interface in the selection view for Export to Excel is modified to make it look better.

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.

Cleanup of expired data (RTC-22749)

Cleanup from ItemServiceJanitor is carried out by Lifecycle Management in Azure.

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 status set to done (RTC-22345)

When imported items are:

• all imported or
• all rejected or
• both imported and rejected

import status is automatically changed to done.

New item attributes in item details (RTC-19899)

The following item attributes are added to item details:

• Weight declaration
  • Type: Long text (similar as Product information)
  • Placement: Product information section
  • Purpose: Used for export to fresh food weights for label printing
• Alarm item
  • Type: True/False
  • Placement: Sales section
  • Purpose: Whether the item has a special security (anti-theft) tag. Mainly used so that store staff is notified and can detach the tag in self-service cash registers.
• Exclude from gross profit report
  • Type: True/False
  • Placement: Sales section
  • Purpose: Used to mark the items that usually have wrong gross profit, so they can be excluded from sales reports.
• Self-service weights
  • Type: True/False
  • Placement: Food section, after shelf life
  • Purpose: Specifies if the given item needs to be weighted by the customer during self-checkout
• Ordering blocked
  • Type: True/False
  • Placement: Procurement section
  • Purpose: If true, means the item cannot be ordered from the supplier. 
• Supplier sales start
  • Type: Date
  • Placement: Sales date section
  • Purpose: Specifies when the item can be ordered from the supplier.
• Scale label
  • Type: Register
  • Placement: Food section
  • Purpose: Specify preferable temperature for each type of food from frozen food -18 C to grilled chicken which should be warm for some time in +60 C. We send this info in the file to scale system.
• Treatment type
  • Type: Register
  • Placement: Sales section
  • Purpose: Some special handling of the item
• Risk item
  • Type: Register
  • Placement: Category section
  • Purpose: To inform customer about related risks when buying this item
• Manufacturer item no
  • Type: Alfa numeric text
  • Placement: Procurement section
  • Purpose: Item identifier when communicating with manufacturer
• Product series
  • Type: Register
  • Placement: Category 
  • Purpose: Grouping of items, for example different drink glasses in the same series
• Product category
  • Type: Register
  • Placement: Category
  • Purpose: Grouping of items for managing/reporting purposes
• Category manager
  • Type: Register
  • Placement: Category
  • Purpose: Identify who 'own' the product in the organization
• Update in POS
  • Renamed from 'Ready for sale', if set to false the item will be deleted in POS
• Can be sold
  • Type: True/false
  • Placement: Sales section
  • Purpose: Block from sale
• Publish to web
  • Type: True/false
  • Placement: Product information section
  • Purpose: Used to confirm all item information is correct and item can be sold in web shop

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.  

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.

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.

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.

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

Move between items in the items grid (RTC-19019)

During moving between items with keyboard system shows correct item hovered when selecting it.

Print QR codes for item list (RTC-18523)

PDF file with QR codes can be generated for items within item list. It can be done using button at the bottom of item list view. Button is available only when browsing item list on item level. File is generated for first 100 items currently displayed in the grid (filters can be applied). File contains item name, color, size, GTIN and item GTIN as QR code. There are 12 items on each page. On the top of each page there is an item list name and page number on the bottom.

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.

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.

Rounding fix for sales statistics (RTC-21610)

Item sales statistics on item overview page are rounded to integer.

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.

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.

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.

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.

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

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.

Bladcentralen import (RTC-20991)

Support both separators for decimal values: comma and dot.

Item status (RTC-20534)

Active status is not displayed in item details. 

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.

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.

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

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.

Fix for long texts (RTC-17928)

Long texts are wrapped inside the multiselects field

RIGAL import (RTC-20692)

Three new values of Vtype in RIGAL import files: 

• If value is W, Y or Z - set item type code to "MBXPwebsale"
• If value is Y,  also set "fixed price" to True, 
• If value is Z,  also set "open price" to True, 

Create store price based on wholesale price (RTC-19865)

• When creating a store price, if there is a wholesale price in the selected period and price calculation ruleset, wholesale price and cost price section of calculation is copied from preorder wholesale price. Margin is copied from item details, active price or default value of ruleset. VAT is always the same as defined in item details.
• If there is no wholesale price in the selected period and ruleset, wholesale price, cost price section and margin are filled with value from item, active store price or default.
• When we create another price, VAT is copied from item details, not from existing active store price.
• Margin % can be correctly set when creating a store price. When editing Margin amount, Margin % is adjusted properly.
• When there is no active store price, in new price view, all cells in 'active price' columns are empty.

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.

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.

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

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.

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.

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.

Integration with Breece ESL (RTC-20459)

Standard configuration creates labels every 5 minute and export every 2 minute.

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)

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

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.

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.

'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.
When we use non-model items, 'External model number' cannot be set in item details. 'Supplier size' can't be used to define item segmentation rule. 'Supplier color' column is removed from item list grid.

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.

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.

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 when planning codes are not in use (RTC-14137)

It is possible to use item segmentation with no planning codes parameter set (UsePlanningCodes=False).

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.

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 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.
To access 'System parameters' page, the user must have 'Manage system parameters' permission that is in 'Item management administrator' permission group. This is for a common role.

Mass update of item subgroup (RTC-18877)

Mass update includes update of item subgroup.

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.

Fix for large item lists (RTC-19252)

There is no timeout when filtering and sorting an item list with many items selected.

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.
Price calculation of an item group is selected by default when creating new store price. Calculation is filled with default values, but when there already exists a price in given store and time period, values of new price calculation are copied from existing price.
VAT and margin values defined in item details have priority over price calculation default values.

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

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.
If first name and last name are filled in Azure AD, then display name will be created from these two names.
If first name in Azure AD is empty, then user will get first name from the first part of the display name. If display name in AzureAD has only one word, then first name is empty. If last name in Azure AD is empty, then user will get last name from the last part of the display name. If there is only one word in Azure AD display name, it is used as the last name.

Fixed store prices (RTC-17870)

Mass update can be used for updating fixed store prices.

Import of RIGAL files (RTC-18192)

When importing RIGAL file we have such rules:

• Value defined in the file must be set as active rate for minimum one of the VAT codes active in registers. The import will then be done without any errors.
• If value defined in the file is not used by any of VAT codes, the line is skipped (validated with error in [staging].[FlatBatchJson]). 
• If value is not defined in the file (empty space), the line is skipped (validated with error in [staging].[FlatBatchJson]). 

Update of Modified date and modified by in currency register (RTC-18042)

Adding a new currency/sales rate updates Modified by and Modified date on the currency.

Fix: Some items could not be exported to Excel (RTC-18989)

It is possible to export items to excel with planning codes for profiles without ExternalReference value.

Improved performance when calculating item segments (RTC-12680)

Segmentation calculation starts immediately after requesting recalculation. It happens when adding item segmentation to promotion offer in promotion management and recalculating segmentation in item management.

Item subgroup column in export to Excel (RTC-17842)

When an item subgroup is defined on an item, it will be exported to excel in "Item subgroup no." and "Item subgroup name" columns"

Select stores when doing mass-update of store prices (RTC-16803)

Mass-update of store prices allow choosing if user wants to use stores/profiles/teams from the excel file or select the stores/profiles/teams for prices in the new grid. Then you can set item prices for selected stores, teams, or profiles and create the import. Next it can be imported from the Imports grid.

Alternative GTINs (RTC-18692)

Alternative GTIN can be added to new and existing items.

Fix for tandem (RTC-17881)

After changing size or color via picker in breadcrumbs, tandem GTINs are reloaded and updated according to the main GTIN.

Creating store price with same date as active price (RTC-18271)

When creating new store price with 'Valid to' date that is already used, validation error is displayed immediately.
Updated store prices are exported to POS properly after updating existing store prices.

RIGAL Import - Update prices in the past (RTC-18344)

All store prices can be updated with RIGAL import. It can be today-price, planned or price with date in the past.

Upload images for an item (RTC-17615)

It is possible to upload images for an item in item details ("Upload image" button). It is possible to change the image ("Change image" button in place of the "upload image" button).
Only jpg format is supported. Image displayed is in square 240x240 pixels.

Price per unit (RTC-17885)

Only active price is used to calculate unit price. Price used for calculation is the newest active profile price, and when not available, the newest team price followed by the newest store price.

Validation error (RTC-16846)

Store price improvement (RTC-17353)

-When creating a price only active currencies are available to be selected.
-Expired prices don't have 'edit' button.
-When creating new price, manually entered values are overwritten only when an active price changes.

RIGAL Import of MBXP items (RTC-17641)

Import 'item type' (7.1.48 Vtype) is possible in RIGAL files in import.

There are selected values supported:

E - MBXP item

P - MBXP item + fixed price flag set to true

G - MBXP item + open price flag set to true

O - Open price flag set to true

X - Ready for sale flag set to false

F - fixed price flag set to true

N, K, B, S - normal item (no changes to the imported item)

Fixed price import works the same as in manual selection (User interface) - value is taken from active price or from the flag on item (if the active price doesn't exist).

Fix: Active prices not exported for valid from = today (RTC-17938)

The time selected in the Export store prices to Excel view takes into account the winter and summertime difference. 

Import alternative GTIN (tandem) (RTC-14428)

Alternative GTINs can be imported using RIGAL import (fields Salgskode3 - 7.1.62 and Salgskode4 - 7.1.64).

Items can be matched by alternative GTIN in import, if there is a match then imported GTIN becomes Main GTIN and the existing GTIN changes to an alternative one (tandem)

It is possible to lookup deposit items, substitution items, related items, Item in package (CU item link) and bundle content items with alternative GTIN as well.

Fix when deselecting and reselecting (RTC-17400)

There is no error message when deselecting and re-selecting items in an item list. Problem still exists and complete fix of this issue will come in [RTC-18226] Item list is not refreshed after select/unselect all - EG A/S.

Export unit on ItemPrice (RTC-17718)

Store prices are exported to POS with "Sales unit".

Eat in/out: Change VAT flag (RTC-17403)

There is a 'Change VAT' flag in the Price section in Item details. It is exported to POS and can be exported to Excel and imported using Mass update - items details. 

Fixed price flag (RTC-16462)

Fixed price can be set on model/item and on store prices.

Value of "fixed price" is exported in Item file/blob and in ItemPrice file/blob.

When creating new store price, default value of "fixed price" is taken from model or from active store price (active store price is more important).

Export item register (RTC-16201)

Item registers for ID requirements, warranty types and active substances are exported from ItemService. Flag isActive is not exported.

See https://itemservice.egretail.cloud/index.html for detailed API contract for blob types ActiveSubstance, IdRequirement and WarrantyType.

Export items to Excel without using item generations (RTC-14136)

It is possible to export items to Excel when "Item generations" for season attributes is deactivated (with UsePlanningCodes parameter is set False). The columns available in the Export items to Excel view correspond to the fields visible in Item details. 

Import rules renamed to PRICAT import rules (RTC-16821)

Import rules used for PRICAT import are named more user-friendly: PRICAT Import rules.

Permissions are re-named to:

• View PRICAT import rules
• Create new PRICAT import rule
• Edit existing PRICAT import rules

Unit price factor (RTC-12139)

There is "Unit price factor" flag in Unit register, which is False by default. It can be selected when creating new unit or editing existing one. In item details view, there is new field "Unit price factor". User can select unit from dropdown list. Only units with "Unit price factor" flag set True can be selected there. There is also a field to enter quantity of selected unit in this item. When both quantity and unit are selected, "Price per unit" field appears. It shows price per unit, which is sales price of item divided by unit price factor. Price used for calculation is active Profile price, and when not available, team price followed by the store price.

Faster to create store prices manually (RTC-15796)

After creating store price, the store selection is saved in local storage. Therefore the same store selection is set by default when creating another store price. Default store selection doesn't break user's permissions.

Import of ExternalStoreNo from StoreService (RTC-16228)

External store number is supported as string value with maximum of 50 characters in Item Management.

Order of planning codes in Item details (RTC-17441)

Planning codes are sorted on code ascending.

Non-approval RIGAL import (RTC-17227)

RIGAL files can be sent with ApprovalReqired flag in FileProperties. If the flag is not given at all, it is handled as True. 

Missing active price when creating campaign price (RTC-17531)

 'Active...' columns are filled out when creating a campaign price and there exists an active price on the item. Columns are not visible if there is no active price. 

Export of register names (to POS) (RTC-15090)

Supplier name, Manufacturer name, Model name, Special group name are exported in the item export.

Mass update of store prices (RTC-15494)

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

• Store group level
• Store group code
• Store group name

Warranty type code (RTC-15557)

Warranty type code field in the Warranty Type register must be unique. Warranty types in item details are displayed ['code' - 'name']. Warranty type code is available for export to Excel.

Import ExternalStoreGroupNo from StoreService (RTC-13822)

Profile number and team number is updated in Item Management when modified in Store Management.

Technical description: Changes to External code in StoreService are imported to ItemService and ExternalStoreGroupNo column is updated in the database. 

Validation errors when importing store prices (RTC-15486)

When importing a file with store prices, the validation will result in error when mandatory fields are missing: Fields which cannot be empty are: Identifier, Stores/Profiles/Teams, Valid from and Retail price.

If user imports file with more than one store, profile or team, error and validation message also occur. User is able to check validation messages in the Import view.

Export of additional item attributes (RTC-15017)

New attributes will be exported to (file/blob) for external systems to use it. Any change will also be exported for them.

List of additional exported attributes:

1. Default margin
2. Deposit item
3. Deposit quantity
4. Nonsale type 
5. Ready for sale
6. Warranty type name
7. ID requirement
8. Healthy
9. Ecological
10. Environmental friendly
11. Shelf life
12. Tara
13. Active substance

Export of item attributes to Excel  (RTC-15007)

When exporting to Excel, the following additional attributes can be exported to Excel file:

1. Default margin
2. Deposit item GTIN
3. Deposit quantity
4. Nonsale type (code, name)
5. Ready for sale
6. Warranty type
7. ID requirement (code/name)
8. Healthy
9. Ecological
10. Environmental friendly
11. Country of origin
12. Shelf life
13. Tara 
14. Active substances (code / name)

Breadcrumbs looking a little better (RTC-14512)

When displaying breadcrumbs in item management and promotion modules, second level text has the same color as main text.

Logout fix (RTP-13060)

Fixed an issue where logout from Mobile POS caused an internal server error.

''All stores" option in store roles (RTC-15018)

There is an option to select all stores in Store level when adding new store role to the user. This option is only visible if user has access to all stores in the user's details tab.

Missing supplier on import items (RTC-13958)

Missing supplier on items in PRICAT import results in exception during validation. The displayed exception has a message clearly informing that the supplier number is missing.

Tara (RTC-14621)

Tara can be registered in item details (saved on item level) in kilograms.

Bundle item (RTC-14169)

Link to bundle content item in Bundle section in item details directs to the correct item.

Change size/color in model for many items (RTC-14069)

When GenerateExternalItemNo is set to False and color/size is being changed on item, it can be changed on 'this item' or 'all items with this color/size' in the model.

Warranty type and ID requirements (RTC-8124)

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

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.

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.

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

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.

Update of imported supplier fails (RTC-14039)

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