Coming next release
Module | Description |
---|---|
Export | Export item subgroup (RTC-16340) Item subgroup's code and name are exported together with the other attributes when item changes are exported to blob. |
Item details | Tandem - change main GTIN (RTC-14429) When GTIN is changed on an item, the old GTIN is saved as an alternative GTIN (in the Item.GTIN table, isMain=0). GTIN visible on the item in Item details is saved as the main GTIN (in Item.GTIN, isMain=1, visible in the Item.Item table). When a new item is created using a GTIN which is an alternative GTIN for existing item, this GTIN is removed from the old item and set as main GTIN on the newly added one. Fix: Add supplier on store level (RTC-15446) It's possible to add supplier on any level: store, store group or common, as well as edit supplier on any level. Dropdown for stores, store groups display data in format reference + name |
Release 17.09.21
Module | Description |
---|---|
Export | 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 | 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. |
Price | Store/team/profile name and number (RTC-15754) Both number/reference and name of store group is displayed in views: "Export store prices to Excel" and "New/edit price calculation". New column "Store group code" is added to the store prices grid. Correct signs in exported store prices (RTC-15923) When exporting store prices to Excel correct positive/negative values are preserved. |
Release 10.09.21
Module | Description |
---|---|
Export | 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:
Export of item attributes to Excel (RTC-15007) When exporting to Excel, the following additional attributes can be exported to Excel file:
|
Price | Mass update of store prices from Excel (RTC-15756) In case of duplicated store prices in the same import file, the last one is imported. In import items grid the duplicates will be still visible but only the last one will be imported. |
Release 31.08.21
Module | Description |
---|---|
Price | Filtering store prices by permissions (RTC-14068) All store prices, which the user has access to shown in the price grid. Same for store groups in multi-selects. |
Release 27.08.21
Module | Description |
---|---|
Export | Exporting items after store price update (RTC-15577) Items are not exported (to blob storage) after store prices are created or modified. |
Item details | Active substance (RTC-14796) There is a dropdown field Active substance visible as the last field before the checkboxes in the Sales section in Item details. Values visible in the dropdown are taken from the Active substances register. Only active values are available there. ID requirements (RTC-15491) ID requirements dropdown values in item details are displayed as 'code-name'. |
Price | Select Stores/Profiles/Teams when exporting store prices to Excel (RTC-14214) It is possible to export store prices to Excel for desired stores, profiles or teams. The multiselect field placed below store level user can filter within stores, profiles or team (depending on the level and user roles) and choose which store prices should be exported and viewed in Excel sheet. |
System | 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. |
User Management | ''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. |
Release 16.08.21
Module | Description |
---|---|
Import | 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. Mass update of store prices from Excel (RTC-13234) When selecting mass update from Item details grid or Import grid, you can select to update store prices. Use same Excel template as you get when exporting store prices to Excel. There are a few validation rules:
Currency column in the export will be available in the coming weeks. There are mandatory fields, which if any is missing will cause exception and status "Error" on validation. Proper messages will be added later. Mandatory fields:
|
Item details | Tara (RTC-14621) Tara can be registered in item details (saved on item level) in kilograms. |
Registers | Commission percentage (RTC-13046) It's possible to enter/edit commission percentage with maximum of 2 decimal numbers. Active substances register (RTC-14797) Active substance register is visible in Sale column in Item registers. It is possible to add new active substance by using Add-panel. Active substances can be deactivated or reactivated. One of the substances can be selected as default. Code of every record must be unique. It is possible to set max number of items in one receipt in "Allowed number in receipt" field. |
Store prices | Display price per CU in TU items (RTC-12087) When an item is a TU item and Quantity in supplier package is provided, the store prices include an additional column with price values per CU item. |
User Management | Users with pending invitations to Azure Active Directory (RTC-15096) If a user has a pending invitation to a tenant and is added to User Management of this tenant, they will be granted access to this tenant when they try to login. When they select the tenant in the tenant selector, they will be presented with the window to accept the invitation and they will be immediately logged in after accepting it. |
Release 28.07.21
Module | Description |
---|---|
Import | Spaces not allowed in externalItemNo (RTC-14257) Spaces at the beginning or end of the value for External Item Number (identifier) will be trimmed during Import. Same for "Use file" in item lists. Columns in RIGAL export to Excel (RTC-13280) The columns containing price information are exported together with item information columns when exporting 'Item details from import file' from a RIGAL import file. Reject items (RTC-14243) There is a confirmation dialog before rejecting selected items in import. |
Item details | 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. Add size when creating new model (RTC-13918) When creating new model or adding items to existing model, and when adding new size in size wizard, the'display size' field is set same as size name by default. |
Item list | Save changes question in item list (RTC-13765) Save changes question appears only when trying to leave the view using breadcrumbs or the browser's 'back' button while creating a new item list. |
Price | Notifications for mass-update of prices (RTC-12237) Notifications are displayed when uploading, revalidating, or importing a file for mass-update of prices. |
Release 08.07.21
Module | Description |
---|---|
Import | Import of profile prices in RIGAL format (RTC-13390) RIGAL format with profile prices can be imported. Store groups of type profiles are matched with RIGAL store numbers. If the profile is not found, it will use store with this RIGAL store number. If both store and profile have the same value, the profile is taken. Performance in import (RTC-14330) The batch size is set to 6000 rows for inserts into staging tables to reduce the risk of timeouts. |
Item details | Warranty type and ID requirements (RTC-8124) Item fields 'Warranty type' and 'ID requirement' are added to the Sales section in Item details. Both fields are saved on the model level and are not mandatory. The fields are dropdowns containing active values from the corresponding registers. Shelf life (RTC-13430) A field for "Shelf life" (saved on model level) is available in the "Food" section, below the "Country of origin" field. External model number (RTC-11907) External model number is shown in the 'Model' section in the item details view. This field can be edited using the manage model button, then selecting the option to change external model no. The value must be unique amongst all models. Default margin (RTC-13261) The field "Default margin (%)" field (item level) is available in "Price" section, below "VAT code" field. The value defined here will be used as default margin when creating a new price. Please note that business logic for the price functionality will be added later. Adding new items to an only-color, only-size model (RTC-14067) It is not possible to add a new item with color and size to only-color/only-size model. Missing size/color needs to be added first to an existing model. It is possible to add new items, which are the same type (only-color/only-size). |
Item list | Item list from file (RTC-12687) A validation message appears in the "Use file" popup when creating or updating an item list to inform a user that the header of the file is incorrect or missing. A message appears at the bottom of the page to inform that some items included in the file do not exist in the system. |
Price | Validation message when editing price dates (RTC-7752) When editing "valid from" date and the date is not correct, a validation message is shown (instead of an error). Export store prices to Excel (RTC-13232) Store prices can be exported to Excel from Items grid, Item lists, Item segmentations, and Promotion offers. "Export prices" button expands into two options: "Export wholesale prices to Excel" and "Export store prices to Excel". Date and time picker (RTC-12971) There is a date picker without a time picker in Export wholesale/store prices to Excel views and New wholesale/store price views when ordinary price type is selected. There is a date and time picker in New wholesale/store price views when campaign or member price type is selected. |
Release 30.06.21
Module | Description |
---|---|
Export to Excel | Export to Excel of mass update files older than 14 days (RTC-13966) Export to Excel for mass updates of price calculations that are older than 14 days are blocked. This is due to an automatic cleanup job which runs after 14 days and cleans up the data, resulting in the file being empty upon export. |
Item details | Ready for sale (RTC-13301) The Ready for sale flag is default set to true. Other systems like POS can use this flag to change status in the item status. |
Release 23.06.21
Module | Description |
---|---|
Item details | Nonsale type in item details ( RTC-12569) It is possible to add nonsale type (register) values to items. They are saved on the model level. Changes in Item details page (RTC-13685) 'Customs tariff no.' is moved above checkboxes in Procurement section. All checkboxes are moved to the bottom of the Product classification section. Sale section is split into Price section and Sale section. Food section is displayed as the last section (after Product information section). |
Item list | Import items from file to item list (RTC-12646) It is possible to add items to the item list with a .csv file with an External item number (ExternalItemNo), GTIN (MainGtin), or SKU (Sku) identifier (Columns names equal hidden key value from Excel files). Only one identifier can be used at a time (one per file). Item list/Item segmentation API - Include price (RTC-13019) Requests including both store price and item information can be performed for Item lists and Item Segmentations. It can be filtered by date and store/store group. |
Import | Reject rows in import (RTC-11553) It is possible to set the 'Rejected' status on rows that were not imported in the Import details view of all import types using the button 'Reject items' placed in the toolbar. Rejected rows are hidden by default and can be seen separately from active rows when the Status filter is set to 'Rejected'. Rejected rows cannot be imported directly but they can be revalidated and then imported. User interface styling and improvements in RIGAL import (RTC-13382) The 'Difference...' columns in the RIGAL import have a special styling. Values in these columns are presented in different colors depending on their sign:
When value is 0, then the standard black color is used. Export to Excel when importing RIGAL files (RTC-11554) When opening a RIGAL import file, the items can be exported to Excel, including current values for existing items. New/current prices etc. will be added to the export later. Item and price control for RIGAL files (RTC-11551) When opening item details for RIGAL files the columns includes Store number, New retail price, Current retail price, Difference retail price, Difference retail price %, New net price, current net price, Difference net price, Difference net price %, New gross profit, Current gross profit, Difference gross profit, and Difference gross profit %. Values for 'Current...' columns are filled out only if there exists a currently active price for the same store on the item. |
Price | Rounding rules for store prices (RTC-14058) Rounding 0 (set in the rounding rules register) rounds prices to the closest value with 0 at the end of the price value. When 5 is the last digit it will round to the higher value. If for example you want to round to the nearest whole value for all prices below 10,5, set the rounding rule to be 1,2,3,4,5,6,7,8,9,0. It won't be possible to round to the exact 0 value (price=0). All roundings for a price will work with standard mathematic rules. |
Register | Update of imported supplier fails (RTC-14039) Suppliers created automatically through import of items can be modified in the Supplier register. |
Release 09.06.21
Module | Description |
---|---|
Import | Deposit item (RTC-12225) The field named 'Deposit item' is visible at the end of the Sale section. In this field you can search and add a link to any item. After selecting an item from the dialog, the item name is displayed as a link and the 'Quantity' field appears. By default, this field is set to 1 and can be edited. After pressing ‘x’ icon on the item name, the 'Quantity' field is hidden and the search is available again. Changing supplier on import items (RTC-7886) Changing supplier in the Import grid is possible only for file type PRICAT. The main supplier for import items is taken from the whole import. OriginalJsonContent shows the original import file and JsonContent is updated with the import supplier when any change is applied. |
Item list | Permissions for item lists (RTC-11610) Permission 'Manage item lists' is available under 'Item - item > 'Item list' section. This permission is required to create and update item lists in Item management. Export of prices and items within Item lists can be done without this permission. Item lists are accessible in read-only mode with the 'View items' permission. Item lists can be used in Promotion without the 'Manage item lists' permission. |
Release 07.06.21
Module | Description |
---|---|
Import | Outdated validation of import (RTC-13665) Import is counted as outdated when the last validation time is more than one day (24 hours). |
Release 02.06.21
Module | Description |
---|---|
Import | Validation improvement (RTC-13141) Manual revalidation of import works. Revalidation of a partially imported model keeps status of already imported items. Outdated validation of import (RTC-8074) Any kind of import, which was revalidated 30 minutes or more from the moment of import will be stopped. If part of items selected to import was validated they will be imported. Outdated items (modified after validation time) will not be imported, and notification will be displayed. To get import done the user must revalidate before importing the items. |
Item list | Edit item lists / Unsaved changes (RTC-11613) Existing item lists are by default filtered to show only the selected items. After a list is created and reloaded, it also shows only the selected items. When creating an item list and trying to leave without saving the list, the 'Unsaved changes' modal appears. |
Item register | Nonsale type (RTC-12571) Nonsale type register is available in item registers. It is possible to add, edit and deactivate rows in the register. |
Price | Rounding of store prices (RTC-8438) A button "Round price to {amount}" is available in store price details view, below the “Retail price” field, displaying the retail price amount after it will be rounded. The rounding is defined in Item register\Rounding rules. |
Release 21.05.21
Module | Description |
---|---|
Import | Show warning when modifying size (RTC-13250) Modifying the size on an existing item with any kind of import will show the warning "Size is modified". Same for color with the warning "Color is modified". |
Item details | Allergens and nutrition (RTC-13123) Item details sections for allergens and nutrition is placed at the bottom of item details. |
Item list | Use another item list to select or unselect (RTC-11457) By using button 'Use item list', it is possible to include or exclude items within an item list that is being created or edited. |
System | Delete items from database (RTC-12620) Index is added to improve performance when deleting items manually from the database. |
Release 18.05.21
Module | Description |
---|---|
Item details | Items with multiple distribution packages (RTC-11873) Items can have multiple distribution packages, for example boxes and pallets. In item details it is shown which TU items a given CU item is linked to. If CU item is not linked to any TU item, Quantity in supplier package field is visible for defining packages without barcodes. Whenever a CU item is linked to a TU item, the field disappears and the number is taken from the TU item. Units of the packages visible in item details of a CU item are fetched from the TU item. |
Item list | Edit item list (RTC-12053) Item lists added to promotions can be edited. Clearing selection changes ToDelete flag in the database to true so that unused lists and segments can be permanently deleted. |
Items with allergens
Allergens can be defined in item details All allergens by default have "undefined" status. There are four statuses to select:
Undefined
Does not contain
Might contain
Contains
Allergens are common for all items within a model.
Sections for Allergens and Nutrition in item details:
If you select Edit allergens you can edit allergens. You can select if the item contains allergens or not. Click Save to save your changes, changes is updated in item details view.
Items with nutrition
Nutrition fieldset is available in Item details. Values from the Nutrition register are visible and values can be defined for them in a third level page accessible by clicking 'Edit nutrition'.
If you select Edit nutritions you can edit nutritions. You can add items nutritional contents per 100 g. Click Save to save your changes, changes is updated in item details view.
Release 14.05.21
Module | Description |
---|---|
Import | Allow store prices with date in the past (RTC-12992) Store prices with the starting date in the past can be imported when using RIGAL import. |
Item details | Fix: Can't open or find items when text attributes contains a date format (RTC-12961) Values with date format (XXXX-XX-XX) can be saved on every string field. |
Item list | Create promotion from item list (RTC-11030) It is possible to create a promotion from a new or an existing item list by clicking Create and Promotion in the Item list details view. Please note that you should not use this feature unless you are using the Promotion module. |
Item segmentation | Bugfix: Segmentation fails when filtering with item group (RTC-12613) A segment in item segmentation can include (and be recalculated) filter group with Item group or Subgroup as an attribute. |
Release 11.05.21
Module | Description |
---|---|
Import | Bugfix: SupplierDiscount from price rule not used (RTC-12884) All discounts are added from the import rule when importing with PRICAT. Import updates will always export the items to external systems. |
Import store prices from RIGAL
Ordinary store prices can be imported using RIGAL item file. To import a price, Engros (7.1.20) field must be filled out. If fromDate is not given or is in the past, today's date is set. Time within the file is in the "local price zone" and is converted to UTC using the PriceLocalTimezoneId configuration parameter. If the file's name format is correct, storeGroupLink.externalNo is taken from it. If not, it is taken from the Filial (7.1.54) field in the file. "VAT" percent is filled out using the one specified in the RIGAL (so the same that is set on the item). VAT amount and Retail price WO/VAT on prices are calculated accordingly.
RIGAL -> Item Gateway
Fradato (7.1.8) -> fromDate
Engros (7.1.20) -> wholesalePrice
Netto (7.1.21) -> netPrice
Utpris (7.1.22) -> retailPrice
Veil (7.1.23) -> retailPriceRecommended
file name / Filial (7.1.54) -> storeGroupLink.externalNo
Release 10.05.21
Module | Description |
---|---|
Import | Fix: Collection from import rule is not applied on item (RTC-12850) Collection and Brand are copied from import rule in PRICAT import. Timeouts in import validation (RTC-12526) Validation of large import files are handled without timeout issues. |
Item list | Delete item list (RTC-11612) Item lists can be deleted. It is not possible to restore deleted item lists. |
Maintenance and defects | Timeouts in import validation (RTC-12526) Large import files are processed. Validation and import of that kind of file also succeed. |
Release 04.05.21
Module | Description |
---|---|
Import | Whitespace characters in GTIN (RTC-12248) Whitespace characters are removed from GTIN field when importing new items. |
Item list | Select/unselect from file (RTC-11075) Items can be added to an item list using import of .csv file. In file's first row you must have a header (not hidden): ExternalItemNo (same as hidden key value from exported excel file for item no. ext.). Support for GTIN and some improvements is coming soon. Export item list to Excel (RTC-11869) Items in an item list can be exported to excel, with the same functionality for selecting items and price columns as when exporting from item grid. Create a copy of the item list (RTC-11614) Item lists can copied and used as basis for new item lists. |
Item search | Pasting values in Item search (RTC-12212) Results are loaded when values are typed or pasted in the Item text search (ElasticSearch). |
Release 26.04.21
Module | Description |
---|---|
Import | Fix for mass-update of items: File failing in generic import (RTC-11832) Edited Excel files, where some data columns were deleted or partially deleted are processed properly. Notifications return successful messages about import and file being uploaded. Importing items from RIGAL item file (part 1) (RTC-913) RIGAL item file is supported for import of new and update of existing items. Models are matched based on externalModelNo (Modellnr), or supplierModelNo (Bestnr) if the first is not provided. Imports can be filtered by RIGAL type in the Imports grid. Import supports the gzipped file type. The following warnings and errors apply in this import type: ImportItemError.ErrorType.ItemGroupMissing, ImportItemWarning.WarningType.BrandWillBeCreated, ImportItemWarning.WarningType.ColorWillBeCreated, ImportItemError.ErrorType.UnknownUnit, ImportItemError.ErrorType.VATCodeMissing. Not all fields in RIGAL item file is updated, as this will be implemented later. Prices will be updated in release during May. |
System | Logout (RTC-796) When the user logout of Chain, he/she is redirected to the login page. |
Release 16.04.2021
Module | Description |
---|---|
Import | Unexpected error while uploading Excel file (RTC-11337) Edited Excel files, where some data rows were deleted or partially deleted are processed properly. Notifications return successful messages about import and file being uploaded. Import of large files (RTC-711) When large item files are imported the files will be divided into smaller parts and processed, to increase performance and reduce risk for failures. Technical: Includes upgrade to Entify Framework Core 3.1. |
Price | Access to store prices (RTC-10097) Access to the Store prices tab in Item details is given in the View store prices permission in the store type roles and in the SystemAdministrator common role. |
System | Filter out deleted items (RTC-11662) Items with the flag isDeleted=1 in Item.Item table are not available in the Items and Models grids and in the Item list details. |
Release 08.04.2021
Module | Description |
---|---|
Delivery dates | Wrong week value in the picker (RTC-7688) When selecting a delivery date or an order deadline date with the week picker, Monday of the correct week is selected in the date picker. |
General | Link columns instead of the arrows (RTC-7843) In all grids where arrows were used to open line details, link columns are used instead. There are column pickers available for all the grids containing more than four columns. For such grids, columns are resizable and reorderable. |
Notifications | Navigation to all notifications (RTC-11221) Users can open the notification panel and move to all notification grids (in User Management) from any module (Promotion, Item Management, User Management). |
Register | Unique constraints on 'Code' for VatCode, Currency, Brand (RTC-8378) It is not possible to save duplicated rows of codes for VAT, Currency and Brand. |
System | Sign out when a user has no tenant access (RTC-11458) After a user who has no access to any tenant logs in, they are automatically logged out and shown a message with a link to sign in with a different account. EG domains (RTC-3269) EG cloud modules are prepared for changing the domain base address from LindbakCloud.com to EGRetail-Prod.Cloud. |
Item lists
"Item lists" is a concept that can be used for doing 'actions' on multiple items. These actions can for example be Create promotion, Mass update or Export to Excel (functionality for these actions will be released later).
Create item lists by using 'New item list' button in the Items grid or the Item lists view accessible through menu. Item lists can be created based on all the items available in Items grid. Items within the lists can be selected manually by marking checkboxes or using the 'Select all' button when some filters are applied. 'Unselect all' button is also available. Name and description of a list can be edited. Access to Items lists requires permissions.
Button to open the Item lists view:
Item list view when some filter is added:
Select the items that should be included in the item list and click on the Create button. Give the list a name and click Save.
The Item list is created and you can find it in the Item lists view.
Item hierarchy drilldown
In the Items view, a panel is available which contains all the active item groups. It is possible to filter by these item groups and combine this filtering with the grid filters. The panel is not available if the (text) search is used.
Screenshot show item view when filter is closed:
Screenshot show Item view when filter is used, and group is selected:
Allergens register
Allergens can be added in the Allergens register using the add panel. Rows can be edited, deactivated, and activated back if needed.
Register overview, with new registers:
Allergens register:
Nutrition register
Food nutrition can be added in the Nutrition register using the add panel. Rows can be marked as mandatory and their sorting must be provided. They can be deactivated and activated back if needed.
Release 18.03.2021
Module | Description |
---|---|
Maintenance and defects | Fix for export of AllSeasons flag (RTC-10335) 'AllSeasons' flag is exported in boolean instead of number. 'AllSeasonsYear' is not exported anymore. |
Mass updater of prices | Export to Excel and Modify file buttons (RTC-3870) Export to Excel allows exporting selected lines to Excel unless any item contains 'Missing price calculation rule code' or 'Conflicting price calculation rule code' validation errors. In these cases, an error appears. To avoid trying to import lines without price calculation rule, the 'Price calculation rule' checkbox is marked and disabled in the Export prices to Excel view. Updating an import using Modify file results in replacing the existing import file with the new one, therefore the same validation rules apply as for a new import. |
User Management | Error message when user don't have access (RTC-9225) When a user logs in with a valid Azure AD account that doesn't have access to any module in any tenant, an error message referring to missing access appears. |
Release 15.03.21
Module | Description |
---|---|
Concession | Handling of prices duplicated (RTC-846) If item concession prices for the same item are sent in different files but are combined into one batch, the ChainIntegration job deletes all duplicates and leaves the last price imported (from the latest file) as the correct price. Export of concession prices (RTC-7021) In a situation when only a concession for specified stores exists (there is no concession for all stores corresponding to the item group and brand), import works correctly and prices are exported only for the specified stores. When all stores within this concession are inactive, no prices are created. |
Export | Export of dynamic price calculation (RTC-3569) Export to blob (JSON) of items with price calculation is extended with priceCalculationRuleCode (code value of calculation rule). All prices despite the price calculation rule value are exported now. Also, store prices export enables the export of all prices (all calculation rules are also handled). Extended also Import contract, including now 9 cost price amounts. |
Price | Bugfix: Create store price on different store group (RTC-10869) It is possible to create store prices with the same starting date for different store groups. |
Release 03.03.21
Module | Description |
---|---|
Import | Search for item in import using Supplier ModelNo (RTC-966) Search for item in import using filter on Supplier ModelNo is fast due to index on SupplierModelNo in PricatImport.ImportItem table. Import of RIGAL item file (RTC-9756) RIGAL item file from any ERP system can be imported in Item Management, using the same standard flat-file format as defined for Chain Classic, with mapping to Item JSON. The first version of the import supports only basic item attributes. This will be extended in the coming months. RIGAL file may be imported with or without the header as both cases are supported and the header is simply ignored by the GenericImport job. Corresponding VAT code is matched based on the VAT rate given in the RIGAL file selecting the first VAT code with the same active rate and Norwegian country code. If no such VAT code exists, the line fails. For now, mapping is: RIGAL -> Item Gateway Nummer -> identifier.gtin (mandatory) Modellnr -> modelNo |
Price | Use correct initial selection of price calculation rule (RTC-9738) When creating a new price calculation, and the price calc. rule of the currently active price is inactive, the default register value is used as initial selection in the price calculation rule dropdown instead of the inactive rule in the dropdown. Currency column is mandatory in mass update of prices (RTC-9966) When exporting prices to Excel the currency column will be checked and locked automatically when checking any of the "Wholesale price in supplier currency" columns. Currency value is required for mass update of prices. If the currency is not present in the Excel file during import, it will result in an error. |
Release 22.02.21
Module | Description |
---|---|
Export | Ordering of data in export (RTC-9792) Export procedures are modified to prevent potential problems related the ordering of data. |
Price | Filter 'store group level' based on user permissions (RTC-9658) When creating new store prices, values showed in the 'Store group level' section, and specific stores, teams, and profiles are filtered based on user permissions. |
Register | Supplier register grid (RTC-921) Added locked grid for Supplier register, with more columns displayed by default (GLN, Supplier, Manufacturer, Default). Inactive item group (RTC-10188) Fixed: The panel informing about an item group being inactive appears as expected when a group is deactivated. |
System | Column picker in grids (RTC-921) In column picker the the ordering of fields is alphabetically. When adding a column to a grid it will be added at the end. Column resize in all grids (RTC-811) Column picker is available in all grids with are more than 4 columns. This allows users to select displayed columns from the column picker, change their size displayed in the grid and change their order in the grid. |
Release 12.02.21
Module | Description |
---|---|
Item details | Unsaved changes (RTC-698) When there are unsaved changes in item details and user selects function to Add new items, Change color or Change size, unsaved changes dialog is shown (with 'Discard changes', 'Cancel' and 'Save changes'). |
Item segmentation | Failed calculation of segments (RTC-961) When the segmentation calculation fails, the status of the segment will be reverted to the one before calculation. The user will get a notification that the calculation failed. |
Mass update | Dynamic price calculation: Change price calculation rule of existing prices (RTC-915) Mass update can be used to update an existing price with a new price calculation rule. All lines in one import file must contain the same price calculation rule. If not, a validation error appears saying: "Conflicting price calculation rule code". If a price is exported with one rule and this rule is updated in the exported file to be imported as an update, field mapping takes place and values are one by one assigned to the subsequent cost price fields corresponding to the new price calculation rule. In Mass update summation rows are also mapped but they are not filled out. This will be changed in RTC-3569 [Dynamic price] Export. All cost price fields for the new rule must be provided in the file. |
Price | All price calculation values are required when importing (RTC-718) All cost price values corresponding to the used price calculation rule must be provided when importing prices using Mass update or import through API (for example from Temalogic). If some values are not given in the import file, price is not imported and validation error appears: "Missing cost price values". Imports that use import rules work as before. |
System | Logging of tenant ID (RTC-764) Logging in Application Insights for API calls (both OK and Failed) includes tenant ID, which will make it easier to identify and analyze error situations for different retailers. |
User management | Hide disabled stores in user details view (RTC-971) Inactive profiles, teams and stores will not show up in the store access list in user details view. When editing store access, it's not possible to select inactive stores, although they will still be visible in the dropdown menu. |
Release 04.02.21
Module | Description |
---|---|
System administration | Support for cashier login with on premise as identity provider (RTC-878) EG Cloud (Chain Web Shell) support a locally installed IdentityServer as identity provider in addition to Azure Active Directory. This can enables the feature of accessing Chain modules in the cloud by using simple cashier login on premise. The security is maintained since the device needs access to the store local network to log in. The access token issued by Chain Web Shell contains information that this login was done by cashier authentication and the different cloud modules can allow or disallow usage based on this information. Initially this feature will be used by Mobile POS app to make it more efficient for several users to share mobile devices, just using cashier logout/login when switching user. |
Release 29.01.21
Module | Description |
---|---|
Import | Min/max validation for price input fields in import rules (RTC-911) For import rules, fields in the price calculation tab (item import rules details) have limited values. For positive fields it's a range between 0 - 9999% and for negative fields it's a range between -99% - 0%. If the user tries to add a value above this range it will change it to boundary value, so no validation message needs to be displayed. Mass-update of prices - wholesale price in currency (RTC-830) It is possible to create/update currency on price calculations using mass-update. The price will be counted for the field "Preorder Wholesale price in supplier currency". If currency column is not included in the in mass-update import file or the value is empty, currency value will be set by default to MainCurrencyCode (NOK). For now, it also affects updating planned prices with a different currency value (causing change of currency in planned price), which will be resolved separately (will be fixed in: RTC-9966) |
Item details | Error message when saving item with inactive values (RTC-766) When there is some deactivated register value which is used for an item, the user will get information: validation "Inactive value selected". When the item has some inactive values it cannot be saved, and the user will get an error message. Fix for item details in mobile view (RTC-725) When opening item details in in mobile view, buttons etc. are displayed properly. User interface design for profile attributes (RTC-877) Design for profile attributes in Item details view and Import rule details view is improved: Display of attribute fields is more clear and easer to read. |
System | User interface improvements for notifications (RTC-819)
|
Release 27.01.21
Module | Description |
---|---|
Export | Export concession price (RTC-9791) A bug related to sorting of data in export of concession prices (ItemConcessionPrice) is fixed. |
Import | Date format from Excel (RTC-9527) We support specifying dates with the "Date" cell-type, and with the "Text" cell-type using the date format "dd.mm.yyyy" (NO standard). For other "Text" formats it will fail. In the future this will be handled more properly as part of validation of import file. |
Price | Warnings when copying and editing prices (RTC-962) When copying or editing prices, warnings in the variant selection modal are displayed the same as when creating prices. It affects three validation rules for wholesale price calculation:
and validation rules for store prices:
|
Release 21.01.21
Module | Description |
---|---|
Price | User-friendly improvements for price calculation rules (RTC-729) Improvements includes:
Access control for store prices (RTC-754) Permissions for view, edit and create prices are defined per role in User Management. Roles are also assigned on store level, either to profile(s), team(s) and/or store(s). When working with store prices these role settings control what users have access to do. |
Release 18.01.21
Module | Description |
---|---|
Price | Price calculation rules in export and import of prices (RTC-3347) Export prices to Excel includes price calculation rules. The rule that is set as default in the register appears by default in the Price calculation rule dropdown and can be changed. Whenever the price calculation rule is changed, columns change to reflect the rule. Price calculation rule must be provided in the imported file when mass updating prices. For now, prices using different rules can be created or updated in one file regardless of the column names - only keys are considered and are matched with columns in the corresponding rule. Prices must be updated using the same rule as the one on the existing price. Related validation errors:
|
Release 22.12.20
Module | Description |
---|---|
Item segmentation | Filtering improvements (Work ID: 189194) Filtering on measures are using centimeters. A problem with time range in date fields is fixed. |
System | Item free-text search error handling (Work ID: 185966) The item free-text search is using the search engine ElasticSearch. If updating ElasticSearch fails, the indexing job will retry to make sure the search data is updated. |
Release 17.12.20
Module | Description |
---|---|
Import | Using price calculation rules in import (Work ID: 188805) Import of Pricat both from supplier and own brands, and import from Temalogic, are using price calculation rules defined in import rule or included in import file. The same business rules are applied as described in relation to price calculation in import rules.
|
System | Showing long texts in user interface (Work ID: 189234) Long texts without spaces in fields will be wrapped. |
User management | Access to stores for new users (Work ID: 191567) Self provisioned users will by default not get access to any stores. This has to be given by administrator users. Changing language (Work ID: 189149) When user selects to change language and saves, the language will change immediately. |
Release 09.12.20
Module | Description |
---|---|
System | Using dropdown filter (Work ID: 189973) When clicking in dropdown filter and the clicking outside the filter, this will not result in logging a bad request/failure. Horizontal scroll in grids (Work ID: 190061) The horizontal scroll in for example the item grid is improved for the non-locked area of the grid. |
Select price calculation rule in import rule
(Work ID: 183186)
In the import rule setup you can select which price calculation to use. The default rule is configured per tenant.
Price calculation input fields appears for each input field type to be filled out for Preorder and Replenishment sections in the import rule. These values are used when importing prices with import type which uses import rules. If fields are empty, they are set to 0 for new prices or omitted for existing prices. Since fields for prices may differ between price calculation rules and are now taken from import rules, if cost price values are specified in imported file when doing PRICAT import, the item is not imported and status changes to 'Error' for such line. Imports which do not use import rules will use the tenant default price calculation rule.
Release 07.12.20
Module | Description |
---|---|
System | Update to .NET Core 3.1 (Work ID: 185890) Item Management app is upgraded to development framework .NET Core 3.1. Security is improved by using Tenant API. |
Release 17.11.20
Module | Description |
---|---|
Item details | Item image in Item details overview tab (Work ID: 180985) Images that do not fit the frame will be resized to fit the frame but without changing proportions or being truncated. Item image in Item details overview tab (Work ID: 181986) When there is only one color (variant) with image the same image will be displayed for all other items with no image in Color section. It takes the first item by size order and displays thumbnail image on all items in this color. |
Item segmentation | Permission for item segmentation (Work ID: 182485) Item segmentation has permission for "View item segmentation" and "Manage item segmentation". With "View item segmentation" permission the user can only view and export the segmentations, but cannot modify or recalculate (re-run the segment). |
Price | Valid from filter with 'is equal to' operator (Work ID:182080) When filtering with valid from the local time-zone is used. |
System | Notification activity (Work ID: 184946) In the notification grid the activity value shows what initiated the notification. Current values are Segmentation, Import and Export. |
User management | System administrator role (Work ID: 188686) All permissions are available for the System administrator role. |
Copy user settings
(Work ID: 171873)
When creating a new user, it might be faster to copy settings/roles from an existing user. Use the more button ('...') in the bottom right when editing the existing user. All properties of the existing user will be copied apart from user details.
Select "Create copy of the user". Dialog "Create a copy" opens.
Start writing name of new user in the "New user" field. Search result is displayed.
Select the wanted user from the search result. New user is added to the "Create copy" dialog.
Click on the Create button to create a new user of a copy the existing user's properties. New user is created, and user details view opens.
Copy user settings is only available for users with permission "Create new user".
Release 06.11.20
Module | Description |
---|---|
Export | Message about export (Work ID: 186894) When the user starts exporting to Excel, an information message about starting export is shown and disappears after 5 seconds. |
Segmentation | Fix for filter with 'Equals' (Work ID: 188350) Segmentation with 'Equals' filter is again working as expected. |
Release 04.11.20
Module | Description |
---|---|
Item details | Fix for 'Change GTIN' button (Work ID: 187153) 'Change GTIN' button is available after clicking 'Manage item' button. Bugfix for related items (Work ID: 187993) Related items can be removed from both non-model items and model items with only one item. |
Register | Rounding rules (Work ID: 178811) Name of Rounding rec. retail price register is changed to Rounding rules, and is used for both Recommended retail price and store retail price. Prices can be rounded to for example 9,99 (two decimals). |
System | Multi-select (Work ID: 180096) When searching and adding values to multi-select fields it is not possible to add/select the same value twice. |
Show status of the process
(Work ID: 183046)
A progress bar is shown when validating an import or updating the import. When the validation/import is done, then the progress bar disappears.
Progress bar when updating the import
Import is done
Show recalculation status
(Work ID: 183045)
A progress bar is shown when recalculation the segment, and the status is refreshed every 4th second. When the recalculation is done, the progress bar disappears and the segmentation is refreshed.
User region
(Work ID: 187230)
Available regions in User Management are: Norway, Sweden, Denmark, Finland, Island, Great Britain, Netherlands, Belgium, Germany, Austria, Estonia, Poland, Lithuania, Luxembourg). Date or decimal separator setting is dependent on region. The side effect for now is that date picker gets translations according to it's region.
Language can be defined on user in User Management (Norwegian, English, Swedish).
Change of language in one module or user details setting in User Management applies across all modules.
Select Region from drop-down list
Release 30.10.20
Module | Description |
---|---|
Price | Overlapping campaign period (Work ID: 185158) Overlapping price of same price type is not allowed, but for example member price and campaign price can have overlapping campaign period. |
System | Web framework upgraded (Work ID: 185135) Item Management is using Angular 10. |
Release 23.10.20
Module | Description |
---|---|
System | Logic for obsolete permissions when doing rollback (Work ID: 182937) If any module is upgraded and includes new user permissions, and a rollback of the upgrade is required due to for example bugs in the new release, the new permissions will not cause any problems for the old version of the module. |
Release 16.10.20
Module | Description |
---|---|
System | Information about inactive values (Work ID: 187040) Text in panel for (example) deactivated user is displayed. Before it was white text on white background so user couldn't see it. It is fixed for inactive panels etc. in all places. |
Release 07.10.20
Module | Description |
---|---|
Export to Excel | Notification when Excel file is ready to download (Work ID: 181014) When exporting items or prices to Excel the user will get a notification when the file is ready to download, or if an error occurred. The file can also be downloaded (later) when selecting view all notifications. This new feature makes it possible to export larger files with many items, without getting a timeout after 10 minutes. Please note that large export will take some time. A test with export of all item attributes for a given brand with 161.000 items resulted in a file of 96MB (161K rows x 180 columns), and took approx. 90 minutes to generate. Export to Excel (Work ID: 175090) The generated Excel file will get file name with date and hour based on the local PC settings. Date is generated based on time when clicking 'Export to Excel', not when the file is ready for download (in notifications). |
Price | Column picker in price calculation and store prices grid (Work ID: 178775) Column picker and new columns is added to Price calculation and Store prices grids. Locked columns feature has been implemented for them with drag and drop and resize columns functionalities. There is a navigation link (same as in item grid) on column 'Valid From' (both in Price calculations and Store prices). 'Valid From' column must always be visible and it is not possible to hide it. |
System | Fix for loading of menu (Work ID: 185083) A minor issue related to loading the menu is fixed. Global design change for buttons (Work ID: 178485) Design and texts for buttons are modified to handle many buttons in a mobile view. Only buttons with enough space are displayed. New 'expand' button is added, which expands buttons grid and displays all of them. |
User management | Synchronizing stores to User Management (Work ID: 183199) Permission can be defined for specific stores or groups of stores. Stores are therefore synchronized from Store Management module (StoreService), using jobs in integration package IdentityServiceIntegration. The jobs are responsible for getting changes on stores from blob and moving them to staging tables in Identity database (StagingImport). Then from staging tables stores are imported to the actual store tables (StagingMerger). StagingMerger is run on Cron trigger with every 10 seconds as default. Default we do 10 retries when a data row is not processed first time. Default batch size is 5000 rows. StagingImport is triggered on change in blob (batchtoprocess > store). Store permissions (Work ID: 180487) Users can get access to selected stores, teams or profiles. User roles can be defined as common or for specific profiles, teams or stores. After access to a store is taken away from user, roles with access to this store are automatically deleted from this user. Role type cannot be changed after being created. This feature will not be in use before permissions for store prices is released later in October/November. |
Release 30.09.20
Module | Description |
---|---|
Import | Keep profile discounts when importing (Work ID: 183779) In price calculation tab in import rule there is a flag for 'Keep profile discounts'. When using PRICAT import with the flag checked, profile discounts are taken from the previously existing ordinary prices for the same planning code on an item. Profile discounts are always copied from an ordinary price which is/will be active at the time when the imported price starts. It applies only for ordinary prices. If there exists only an expired price for given planning code, then values are copied from it. The flag has no effect on Temalogic import since import rules are not taken into account in this case. Note: In case of adding a new size to an existing color by import, prices from a different (existing) item are copied to this newly created item. If the new item is imported together with new price info, discounts for this new price will be applied from the import rule just like there would be no other prices on this item. To have discounts copied from a different price (existing on different item and copied to this newly created item) new item must be created first with no new price info and the new price must be then added in a separate import. |
Release 24.09.20
Module | Description |
---|---|
Export | Export of external store number in Concession file (Work ID: 185943) Export of concession contains external store number. |
Item details | Mandatory fields (Work ID: 180492) When creating/editing items it is required to add values for item name (item text, receipt text, label text 1), unit, VAT code, item group and supplier. |
User management | Swedish language (Work ID: 174185) User management module supports languages English, Norwegian and Swedish. |
Release 16.09.20
Module | Description |
---|---|
Import | Copy import rules (Work ID: 177676) When copying import rules, all profile attributes (including price calculation values) are copied to a new import rule. |
Item segmentation | Filter on blank values (Work ID: 180519) When creating segmentation groups it is possible to filter by blank values. Blank values means NULL and empty string. User can include or exclude on all attributes (except boolean attributes with value True/False). |
Price | Fix for date validation conflict (Work ID: 182715) When editing an existing member or campaign price (both for price calculation and store prices), the date validation triggered on the price itself saying there was already a price on this date. This is fixed. |
System | Translations to Norwegian and Swedish (Work ID: 182138) Several translations to Norwegian and Swedish in Item Management are reviewed and modified. |
Release 11.09.20
Module | Description |
---|---|
Import | Bugfix for ‘More’-button for imports (Work ID: 184014) User can change supplier for import with permission 'Manage imports' and view error text for Import with permission 'Access to system tasks and information'. |
Item details | Notification when segment is calculated (Work ID: 182833) Calculation a segment may take several minutes. User will be notified when the calculation of a segment is finished. |
Register | Fix for brand registration (Work ID: 183709) Fix for registration of many brands without leaving the registration screen. |
Release 08.09.20
Module | Description |
---|---|
Import | Validation of concession import files (Work ID: 183935) When concession price file is imported, we validate to identify duplicate prices. Validation error appears in case of a duplicate: "Duplicate price" on all lines except the first for a given item in a file. If the import status is reverted to Ready for import, then it is possible to import the same price again. Concession flag on item is checked after an item concession price is imported for this item. The flag can be edited in Item details. It is not possible to import prices for items whose brand is not a concession brand. New validation error appears in such case: "Item brand is not marked as concession". |
Item details | Functions in Model-color view (Work ID: 182142) “New mass update" button is visible both in "Item view" and the "Model-color” view. Color and size in save dialog (Work ID: 182148) After fix, the format is: {color} {size} when items are listed in Save/Edit dialog. Leading and trailing spaces in item text (Work ID: 183203) When there are leading or trailing spaces in the fields Item text, Label text 1, Label text 2, Receipt text or Brand text, the spaces will be removed during import. (We have run a script to fix existing items with leading or trailing spaces). |
System | Field validation (Work ID: 179410) When validating fields we display both red frame and error text after changing focus from field. |
Show progress for segment calculation
(Work ID: 179542)
When calculating a segment the percentage progress is shown in the breadcrumb. The progress indicator is based on the number of filter groups processed. Processing time for last calculation provides the user approx. time for next calculation.
Release 02.09.20
Module | Description |
---|---|
Export to Excel | Export prices with supplier details to Excel (Work ID: 180524) When exporting prices to Excel, supplier details like supplier name, supplier model number etc. can be included as columns in the export. |
Import | Notifications when import is ready (Work ID: 181008) When an import is validated the user will be notified. The notification will inform about the import status and result of the validation, and the user can click on the notification link to navigate to the import details view. The following notifications are supported: Success:
Warning:
Error:
|
View all notifications
(Work ID: 176600)
Notifications panel is opened by clicking the "bell" icon in the right top corner. When selecting 'View all notifications' the user is navigated to a view showing all of the users notifications (including dismissed). For support purposes there is a permission that makes it possible for system users to view notifications for all users.
Release 31.08.20
Module | Description |
---|---|
Export | Export of concession store prices (Work ID: 168102) When concession is configured, store prices for concession items are exported from the Concession.ItemConcessionPrice table to the Gateway.ItemConcessionPrice blob. Any 3rd party can subscribe to these store prices, but standard we use the ChainIntegration package (OnPrem) in Integration Platform to receive store prices and update them in Chain Classic. Export of concession register (Work ID:168101) When change tracking is configured, concession register with commission percent per group of brand/stores/item groups is exported to 3rd party subscriber (Gateway.Concession blob). For contract description, see Concession in https://itemservice.lindbakcloud.com/. |
System | Application header (Work ID: 173781) An information bar at the top of screen is shown when using Test or UAT environment. The application header is default hidden in production environment. Edit user profile and select 'Show application header' to show or hide. For EG Retail employees it is recommended to always show the application header to indicate which tenant (customer) the user is logged in to. |
Release 27.08.20
Module | Description |
---|---|
Import | Import of concession price files (Work ID: 168104) Price files from suppliers of brands with concession setup can be imported to create stores prices that will be exported and used in POS. Such import has ApprovalRulesetId=5 in PricatImport.Import table. If an applicable concession does not exist, validation fails with "concession setup missing"-message. Validation fails also when no brand is added to item or item is not found. Imported lines are stored in Concession.ItemConcessionPrice table. VAT rate and commission percentage for stores are needed for price calculation. If no VAT code is added to an item, it is assumed to be 25%. Commission percentage is taken from the concession. Since concession overlapping is possible, a priority hierarchy is used when searching for the right concession to be applied. The most important within a brand is concession for a specific store and item groups. Then, for specific item group and all stores, and then for specific store and all item groups. The least important is concession for all store and item groups. Concession price imports are visible in Imports grid with new price type - Concession, and not all buttons are available in such import details. Validation errors possible when importing concession prices:
|
System | Save changes dialogue (Work ID: 179413) When leaving filter group in Segmentation or Supplier details in the Supplier register, we display “save changes” dialogue to let users save changes before leaving. When clicking save and some validation is triggered - we display correctly red frame and validation error in the grid. |
Release 25.08.20
Module | Description |
---|---|
Import | Bugfix: Duplicate prices (Work ID: 183020) Fixed an issue with duplicated prices when importing items to existing colors with same price date from. Import file without values for supplier color/size (Work ID: 180500) When creating new items from import or adding new items to existing model, both color/size and supplier color/size is set to the same value if only color/size has a value in the import file. |
System | Synchronization of stores (Work ID: 179533) In EG Cloud the StoreService is master for stores. For now the store register is synchronized from Chain Web OnPrem to StoreService. ItemService is subscribing to changes in StoreService, and will keep a synchronized register of stores that is used for example when defining store groups for concession. |
Release 14.08.20
Module | Description |
---|---|
Price | Validation of store prices (Work ID: 178776) It is not allowed to set retail price to 0. It is allowed to set 0,01. Filtering in price tab (Work ID: 177988) In price tab it is possible to filter also on price type and order type. Filters in these grids are persistent when changing items using drop downs in breadcrumbs. They are cleared when tab is changed or page is refreshed. |
Release 24.07.20
Module | Description |
---|---|
Import | Faster opening of import rules (Work ID: 173751) Opening of import rules takes approx. 1 second. Previously it often took more than 10 seconds. Validation when adding new size to existing model (Work ID: 179447) When adding new size to an existing model, a warning is displayed in import details: "New size will be added to model". This will for example help the user to avoid creating new size 6.5 when size 6,5 already exists. Non-model items (Work ID: 169105) It is not allowed to add color or size to a non-model item when importing or mass updating items. After validation of import the error message "Cannot add color or size to a non-model item" is shown in import details. Note that it is possible to change color on items which already have color or size. |
Item details | Item overview tab (Work ID: 145956) Core information and color section is added to overview tab. For model items it is possible to navigate between items by clicking on color names. When navigating to a color, the item with the selected color and the same size as we were on is opened, if the size exists. When selecting a color where the previously viewed size does not exist, the first size in the list is opened. Also, navigation from Model-color view in Items grid to Item details has been improved and now item with the correct color (selected in the grid) and size (the lowest sorting number) is opened. |
Item Segmentation | Attribute search (Work ID: 179536) There will be displayed information when searching for attributes, which are part of item planning attributes, and planning code is not selected ("Your search criteria match attributes that require that planning code is selected. Please define a planning code before selecting these attributes."). |
Price | Percent conversion in filter columns (Work ID: 178599) Percentage filters are fixed and show correct values (not multiplying with 100). |
Register | Register descriptions (Work ID: 180955) To improve usability all registers are described. |
System | Improved upgrade process (Work ID: 177570) Item Management is dependent on other common services (Shell and Tenant API) during startup. When such common services are not available, the module will retry to reach the services every 30 seconds until they become online. Open menu in new tab (Work ID: 144121) It is possible to right click on menu elements and open web page in a new tab or a new window. |
Release 17.07.20
Module | Description |
---|---|
Item Segmentation | Validation of attributes (Work ID: 179538) When adding new attributes to a group, a red frame is shown when leaving the field without selecting any value with 'In list' operator. |
System | Cleanup of staging tables (Work ID: 156124) Staging tables are used when importing items. The ItemServiceJanitor job is running continuously to delete old staging data. The job deletes default maximum 100 rows, using maximum 10 seconds, older than 14 days . |
User Management | View permissions (Work ID: 171661) When selecting 'Edit...' permissions in user role details, check boxes for corresponding 'View...' permissions are selected automatically so the user does not need to remember to add them. The view permission cannot be unchecked until dependent permissions are unchecked. |
Release 10.07.20
Module | Description |
---|---|
Item details | Default selection of variant (Work ID: 178790) When creating, editing, copying or deleting price, the currently opened color will be selected by default in the variant selection when working with a standard model or a model without sizes. When working with a model without color, the current size will be selected by default. Show item images in Item overview (Work ID: 145955) Item images can be fetched from a product management information system (PIM). This requires configuration of the integration that is based on a URL in combination with item identifiers. |
Price | Ordinary price must exist before other price type can be created (Work ID: 176409) It is not possible to create a member or campaign price for a date period for which there is no ordinary price calculation already added. When creating a new campaign/member price and some items in the model do not have an ordinary price in the period, a warning icon and message appears in the variant selection modal (same pattern as missing planning code on some items) and it is not possible to select these items since checkboxes are be disabled. For now, however, it is possible to have a situation where member/campaign price exists with no ordinary price in the same time period and for store prices also profile/team/store by deleting ordinary prices after member/campaign prices are created. This will be handled in the future. |
System | Permissions (Work ID: 173753) Permissions for exporting to Excel can be defined per user role, both for exporting to Excel from Item grid, from Item details and from Imports. |
Release 01.07.20
Module | Description |
---|---|
Export to Excel | Performance when exporting prices to Excel (Work ID: 179703) Performance when exporting to prices to Excel from Segmentation and Import, and when there is a large amount of items in the item grid, is significantly improved |
Import | Warnings and errors in import (Work ID: 174734) In item import we can have up to 192 different validation errors and 192 different validation warnings. |
Release 30.06.20
Module | Description |
---|---|
Import | Bugfix for import of own brands (Work ID: 179890) Own brand files can be imported without failing. |
Release 29.06.20
Module | Description |
---|---|
Import | Filtering in Size control (Work ID:177677) Fixed two issues in Size control view of Import details (Imports > Import details > button 'Size control'):
|
Item details | From Product information to Product classification (Work ID: 177680) The field section containing 'EN standard', 'Healthy' etc. is renamed from Product information to Product classification in item details and when exporting to Excel. |
System | No auto-complete (Work ID: 147387) Autocomplete has been removed from all fields in Item management. Logging of failures when exporting to Excel (Work ID: 173755) When exporting to Excel we log metadata in Application Insights that makes it easier to identify what caused the problem, for example the SQL query that was used. |
Release 11.06.20
Module | Description |
---|---|
Price | Store prices (Work ID: 159222) In items details there is a tab for store prices. Later this will be used by price managers and store users to manage prices that will be exported to POS. |
Register | Concession store register (Work ID:168099) Register of store groups that is used in concession setup. |
Release 29.05.20
Module | Description |
---|---|
Export | Export of dangerous goods flag (Work ID: 164929) Export data type is changed to boolean (True/False), and the export will no longer result in value NULL for dangerous goods. |
Price | Filter by valid from (Work ID: 176237) In price calculation tab it is possible to filter by valid from date. |
Release 25.05.20
Module | Description |
---|---|
Item details | Deleted planning codes excluded from Excel export (work ID: 175134) When exporting items to Excel, all rows with deleted planning codes are excluded from the export. Faster update of existing items (Work ID: 173973) Database indexed is modified to improve update of item fields on model level. We have not been able to measure the improvement, but users should experience that saving models with many items is a bit faster now than before. |
Price | Business rules for proposed price calculation values when adding a new price calculation (Work ID: 173131)
Preventing duplicate prices (Work ID: 175270) A constraint is added to prevent possible duplicate entries in prices for profiles/stores. |
Validation of import
(Work ID: 170968)
For validation of mass update from Excel the following 28 validation messages for error and 3 validation messages for warnings are added:
Error | EN Translation | NO Translation |
ItemNoFound | EN: Item not found | NO: Varen ble ikke funnet |
PlanningCodeNotFound | EN: Unknown planning code | NO: Ukjent planleggingskode |
StoreGroupNotFound | EN: Unknown store group | NO: Ukjent butikkgruppe |
CollectionNotFound | EN: Unknown collection | NO: Ukjent kolleksjon |
MarketingExclusivityNotFound | EN: Unknown marketing exclusivity | NO: Ukjent markedseksklusivitet |
AssortmentNotFound | EN: Unknown assortment code | NO: Ukjent sortimentskode |
SalesPurposeNotFound | EN: Unknown sales purpose | NO: Ukjent salgsformål |
SeasonNotFound | EN: Unknown season | NO: Ukjent sesong |
MarketingCodeNotFound | EN: Unknown marketing code | NO: Ukjent markedsføringskode |
ReplenishmentCodeNotFound | EN: Unknown replenishment code | NO: Ukjent etterfyllingskode |
ProcurementRuleNotFound | EN: Unknown procurement rule | NO: Ukjent innkjøpsregel |
UnitNotFound | EN: Unknown unit | NO: Ukjent enhet |
ItemTypeNotFound | EN: Unknown item type | NO: Ukjent varetype |
SupplierNotFound | EN: Unknown supplier number | NO: Ukjent leverandornummer |
VATCodeNotFound | EN: Unknown VAT code | |
ItemGroupNotFound | EN: Unknown item group number | |
ReportCategoryNotFound | EN: Unknown report category | NO: Ukjent rapporteringskategori |
ManufacturerNotFound | EN: Unknown manufacturer | NO: Ukjent produsent |
BreakBulkCodeNotFound | EN: Unknown break bulk code | NO: Ukjent anbrekkskode |
SeasonCodeNotFound | EN: Unknown season code | NO: Ukjent sesongkode |
ServiceLevelNotFound | EN: Unknown service level | NO: Ukjent servicenivå |
Error | EN Translation | NO Translation |
SubstitutionItemNotFound | EN: Unknown substitution item | NO: Ukjent erstatningsvare |
BrandNotFound | EN: Unknown brand | NO: Ukjent varemerke |
SerialNumberTypeNotFound | EN: Unknown serial number type | NO: Ukjent serienummertype |
CountryOfOriginNotFound | EN: Unknown country of origin | NO: Ukjent opprinnelsesland |
ClassificationNotFound | EN: Unknown classification | NO: Ukjent klassifisering |
SpecialGroupNotFound | EN: Unknown special group | NO: Ukjent spesialgruppe |
OriginalPlanningCodeNotFound | EN: Unknown original planning code | NO: Ukjent opprinnelig planleggingskode |
Warning | EN Translation | NO Translation |
CostCarrierModified | EN: Cost carrier is modified | NO: Kontohenvisningskode er endret |
ColorModified | EN: Color is modified | NO: Farge er endret |
SizeModified | EN: Size is modified | NO: Størrelse er endret |
In addition:
Brand can be cleared when importing (from PRICAT, Temalogic, mass update)
Validation of empty Brand code (when only Brand name is provided in the import)
Validation of Manufacturer (in PRICAR import)
Validation of unknown season code (from Temalogic)
Release 11.05.20
Module | Description |
---|---|
Import | Create new item when GTIN must be changed on existing item (Work ID: 174423) When importing file with already existing GTIN, but different supplier/supplier model number, and supplier model number value already exists on other item, the user can select to fix item identifier. This means that we will auto-generate a new GTIN for the existing item, and that the new item will be added to the same model as existing item with same supplier model number and same supplier. When importing file with already existing GTIN, but different supplier/supplier model number, and supplier model number value already exists on other item, the user can select to fix item identifier. This means that we will auto-generate a new GTIN for the existing item, and that the new item will be added to the same model as existing item with same supplier model number and same supplier. Validation of duplicate size sorting number (Work ID: 172299) When there are items with duplicate size sorting value, it will not be possible to import new or update existing items for the model. In item import validation error is shown: 'Sorting number overlaps within color'. |
System | Better performance when creating new items (Work ID: 173163) New items added to existing variants are created much faster. Before improvements, adding new items to variant which caused copying planning codes, prices etc. took a lot, up to 10 seconds measured on the development environment. Now it is reduced to 0.2 seconds. |
Release 30.04.20
Module | Description |
---|---|
Item details | Export to excel and mass update of sorting and display size (Work ID: 166697) When exporting items to Excel, columns for size sorting (variant sorting) and display size (consumer-friendly size) are included in the Excel file. Sorting and display size fields can be updated in item import, for example when using mass update with Excel file. Sorting cannot be empty and is omitted when importing file with NULL or empty field and its value stays unchanged in case of updates or is taken from size in case of creating new items. Import item details: Columns are hidden by default and can be added using the column picker. All columns are visible in exported Excel only when 'Item details from import file' option is selected in Export to Excel popup. Display size and Sorting columns are visible when all fields are exported for Item details from active items' option, but not visible when selecting 'Limited fields'. Item details export: Check-boxes for Display size and Sorting are added at the end of Model section in Export to Excel view. |
System | Permission for viewing exception messages (Work ID: 172838) Users that should be able to view system exception messages must have permission 'Access to system tasks and information' added to user roles together in permission group 'System'. User without this permission is not able to see error messages when status on the whole import or an import item is 'Error'. Please note that this is mainly used by EG Retail (DevOps role). |
Export of prices to Excel
(Work ID: 154434)
From item grid you can export either items or prices to Excel. Prices are exported for items filtered in the items grid. Please note that we have tested export of 100.000 prices, and that exporting more prices could result in a timeout and invalid Excel file. It is possible to filter prices to be exported by the newest planning code or selected planning codes, price type and dates between which prices are valid. Templates can be created and updated, similar as for export of items. Lines for items that are filtered out in the grid but do not contain any planning code (or price) are not exported to Excel.
When I choose «Export prices to Excel”, Export prices to Excel opens in a new view. In this view you select what you should export.
In top of this view you could select Price type, Valid from/to, if the prices should be exported for the newest planning code or selected planning code, and you could select an Excel template.
Columns in Excel
In this part of the view you define columns that should be available in the Excel file.
You select columns in the same way as in the Export to Excel view, by selecting the columns you want to export to the Excel file. See Export to Excel description for details.
Release 21.04.20
Module | Description | Work ID |
---|---|---|
Export | Export currency rate to cash register Active currency sales rate can be exported. Cash registers (POS) are standard receivers of this export type. | |
Import | Fix for filtering in validation errors and warnings Filtering in import item grid is again working as it should when navigating between pages | |
Item details | Export items to Excel When exporting items to Excel from the item grid, the query to the database is split into batches of 1500 items, making it possible to export large amount of items without causing a timeout in the export job. Export of items will be quite fast when filtering by brand, item group and cost carrier in the item grid. | |
System | Swedish language User can select between Norwegian, English and Swedish language in Item Management module. Swedish language in User Management module will be implemented soon. |
Release 08.04.20
Module | Description | Work ID |
---|---|---|
Import | User interface changed in import details view Toolbar in Import details view has been improved. Buttons have been re-arranged. 'Update items from file' button has been renamed to 'Modify file'. | |
Item details | Colours with spaces in primary colour If you create an new model item and you select a colour from the list in the field ”Primary colour”, and the primary colour you choose contains spaces, the user get a message telling that spaces in front or end of the text are not allowed. To register this colour on the new item the user needs to edit the value of “Display colour” (copied from primary colour) and remove spaces. When the user edit the value in “Display colour”, the user could create the new item. New items gets the value defined in display colour. Earlier you wasn’t able to create new item if you selected a primary colour with spaces. | |
Price | Bugfix: Wholesale price not set to null Correct wholesale price (also in currency) is shown when 'Valid from/to date' is modified and 'Planning code' is changed. | |
Register | Item hierarchy When adding a line from Group/Area/Department details view, values in Parent hierarchy section are read-only. |
Release 02.04.20
Module | Description | Work ID |
---|---|---|
Item details | Faster opening of item details view Opening item details from item grid should normal take approx. 1 second. Depending of how many model-color and sizes it might take slightly more time. |
Release 23.03.20
Module | Description | Work ID |
---|---|---|
Import | Notification when last import failed If the import fails when the user selects 'Import selected items', a notification with 'Error' is displayed in the breadcrumb in the top of screen. | |
Item details | Add related items Related items are by default always added on 'this item'. User can still select to also save it on selected colors/sizes or all items within model. | |
System | Export to Excel Export to Excel is running a an asynchronuous system job. Files will be saved for user on created date order (first user gets first file). Files won't be exported in parallel. Once one file is exported, export of another one is started. Timeout set in job for database query is configured to 5 minutes. Timeout for response to users download it is set to 10 minutes. Persistant grids Validation filter in import grids are kept (persistent) during tab session between pages. Filter is cleared when refreshing the page. Selection of Item/Model-color view and search/filters option is persistent per user. Switching between search and filters in item grid clears previously chosen filtering option and applies to both views at the same time. Finding import file that failed Logging in Application Insights includes FlatBatchJsonId which makes it easier to identify the file that caused the error. |
Release 13.03.20
Module | Description | Work ID |
---|---|---|
Import | Truncate of item text, color and size When item text, color or size is longer then 50 characters (maximum value in database and user interface) only the first 50 characters of these values will be saved. 50 characters is also the maximum value for supplier color and supplier size. | |
Item details | Fix for item subgroup Subgroup is added as separate column to model, and export of item group value is correct when subgroup is added to item. | |
Price | Formatting of price calculation Formatting has been improved in price calculation tab when creating next new price so that the view is clearer for user. | |
System | Update of grid component The grid component (Kendo) is updated to the latest version which supports virtual columns and other performance improvements. "Change detection" time is now dependent on number of visible columns and increases with the increase in visible columns number. Message logging when validation has failed When validation fails in StagingBatchExecutor job we log a user-friendly error message (and not the whole stack of failure) to make it easier to read the alerts from Application Insights. |
Select item fields and create templates for export to Excel
(Work ID: 168239)
When exporting items information to Excel, you can select which columns to export. Speed up to export process by creating and selecting templates.
When I choose «Export to Excel” in the item details view, Export to Excel opens in a new view.
In the “Export to Excel” view you define what the export should contain.
First you have to define what planning codes should be exported. You could choose between “The newest planning code”, “Selected planning codes” or “Do not export planning code”
Then you define Excel layout. You define columns that should be available in the Excel file. You could use a Excel template or select columns manually.
To select columns you select the checkbox by the column you want to add to the Excel file. You could also select a category, then all the columns in the category is selected, but you could choose to deselect some of the columns.
You write a search text in the search field to find the columns quicker. Then you get all the columns with the given text in the name, and you could select the columns that you want.
Under det search field you have to buttons: Select all and Unselect all.
Select all
If you choose Select all, all the columns are chosen. If you have performed a search, this button selects all columns matching the search.
Unselect all
If you choose Unselect all, then all columns are unselected.
Use template
You could use an existing Excel template. Select “Use Excel template”, and choose the template you want to use from the list. Then you get a list of the columns that are selected in the given template. You could modify the selection.
Create new Excel template
When you have made your selection you could Create a new Excel template. Press the “more-button” (…), and choose “Create a new Excel template”.
The dialog “New template” opens.
Give the template a name and possibly a description. Choose Create to create a new template.
The template name is displayed in the view under the field “Use Excel template”.
Update existing template with modifications
If you have modified a existing template, you could Update existing template with modifications to update the template. Press the “more-button” (…), and choose “Update existing template with modifications”.
The dialog Update existing template with modifications opens. You could change name or description. Choose Save to save the changes.
Export to Excel
When you have defined which columns you want to export to Excel. You select the Export to Excel button to export the selection to Excel.
Release 05.03.20
Module | Description | Work ID |
---|---|---|
Import | Delete import When deleting an import the user is redirected to the item grid. Selecting supplier for an import After selecting supplier for an import, the import grid is refreshed. | |
Item details | Deactivation of item Minor improvement in user interface related to buttons. | |
System | External item number 'External item number' has been renamed to 'Item number' in all views and export Excel file. 'Subst. Item no. ext' has been renamed to 'Subst. Item no.' and 'Item in package ext. no' to 'Item in package no' in export Excel file. |
Release 28.02.20
Module | Description | Work ID |
---|---|---|
Item details | Removing a planning code It is not possible to remove a planning code using edit item generation dialog. Error message appears for colors that had the planning, but are now deselected from all profiles in this edit popup. The save button is disabled until at least one profile is selected for the color. It is possible to save if selected profile is a 'new' profile which was not marked for this color previously. | |
Price | Missing planning code A warning 'Missing planning code' will appear if there are no planning codes linked to the item. Minor improvements to performance and error handling. |
Release 21.02.20
Module | Description | Work ID |
---|---|---|
Import | UTC time format Database server can be in a different time zone than the uploaded files. Error handling of duplicate items in import file If an import file contains duplicates of the same item it will not cause any error when importing, but only one of the rows will be imported. Column for supplier model number in item import Columns for 'Supplier Model Number' and 'Current Supplier Model Number' are available for all types of import when viewing items within the import. | |
Item details | Validation of bundle quantity Bundle quantity field is validated. If user adds value higher than 2147483647 a warning is shown to the user, and there will be no error in the application logs. | |
System | Logging of user activity We use Azure Application Insights for logging and tracing of all processes and user activity. The users e-mail address is logged as AuthId parameter in AppInsights and name and surname in user interface and audit columns in the database (CreatedBy, ModifiedBy). Update of translations After a new release a refresh of the page is enough for new translations to appear correct for the user. |
Concession flag on item
An item can be marked as a concession item. This attribute can be set both when creating and editing. Default value is false. The concession flag is available in both import/export and Excel export/mass update.
Concession flag on brand
A brand can be marked as concession. This attribute can be set both when creating and editing. Default value is False.
Release 14.02.20
Module | Description | Work ID |
---|---|---|
Import | Validation when item has fixed item identifier error (TFS: 169175) Don't link items when non-model item has fixed item identifier error. When there is an import file with fix item identifier (with update existing items option) for item, and there are new items with same model identifier (supplier model number), it won't try to connect/merge non-model items with other items into same model. Model items will be added to different model (new model number will be created). | |
Item details | Caching of data in item grid (TFS: 167390) To improve usability the item grid is cached so that loading the grid is not requested when navigating back from item details to both Items and Model-Color grid. After adding new items they will appear at the top of the grid even if filters are applied. Although the grid is not loaded again, any changes made to items are visible right after going back from Item details. |
Release 11.02.20
Module | Description | Work ID |
---|---|---|
Import | Split of supplier models When Pricat import results in split on items within supplier model, all items from the same model in this import will be imported, even when only one item is selected. A warning message is displayed when this happen. Faster loading of items in import view Added index to load the items much faster in import details view. | |
Price | Clearing currency field and validation of discount When clearing currency field and choosing another currency, the price is created without any errors. It is not possible to set supplier discount value greater than wholesale price, or set wholesale price lower than the supplier discount value. The same rule applies to discount and sales price. Recalculation when changing currency A recalculation of prices is triggered when the currency is changed. |
Import status and work status
(Work ID: 168149)
Column 'Status' shows the system import status of the file, with statuses New, Pending, Ready for import, Partially imported, All items imported, or Error. In addition the user can manually mark a file as 'Done' by selecting the button 'Work done' in Import details.
This improves the workflow and makes it easier to filter on imported files 'Not done'.
A file that is marked as ‘Done' can be set back to 'In progress' by using the button '...' and choose 'Set back in progress’ in Import details.
Release 10.02.20
Module | Description | Work ID |
---|---|---|
Export | Item export is faster When items are updated this triggers an export to all subscribing systems. The performance is increased significantly, especially when there are many planning codes/prices per item. If the export fails the job will be displayed with status Faulted, and tracked in our monitoring of the item module. | |
Import | PRICAT import from Excel file When import of PRICAT is done by uploading an Excel file, it will get filetype PRICAT and use the same import rules as PRICAT from EDI/suppliers. | |
Price | Handling of exceptions in browser When trying to create a price for an item with no planning code we show a warning (instead of a browser error). |
Release 31.01.20
Module | Description | Work ID |
---|---|---|
Import | Price when using text format in Excel If price columns in Excel are formatted as text, the price will be updated correct. | |
Item details | Improved error handling Buttons for 'Select model' and 'Cancel' are greyed out when the view is loading, to prevent starting new requests while previous request is taking place. Validation of GTIN When 'GTIN already exists on another item' validation message appears on the lines with the same GTIN while adding new model or items to existing model, it disappears when the first/second GTIN is edited. When creating model/item, adding new item to existing model or updating GTIN, validation for GTIN field works correctly now - negative values are handled and 'The minimum value for this field is {value}' validation error appears. Setting supplier as main When setting supplier as main, store group level field becomes disabled in Edit item supplier popup. | |
Price | Copy calculation to other profiles "Copy price" button has been relabeled when creating or editing new price calculation. Improved user experience in Price calculation Price calculation details view is optimized to improve the user experience. |
Release 24.01.20
Module | Description | Work ID |
---|---|---|
Import | Use mass update to set fields to blank value The item fields Serial number type, Report category, Item category and Substitution item can be set to blank value (cleared) by using the value NULL in the mass update. | |
Item details | Bugfix in 'Add item generation' The function for adding item generations to for example other variants for given model is fixed. |
Release 22.01.20
Module | Description | Work ID |
---|---|---|
Import | Profile is mandatory in import rule For import rules it is mandatory to select at least one profile before saving. This prevents error situations where items are updated without profile prices. Improved error handling Import job will not create alerts when validating imported files (often from mass update) and the file for example has the wrong format or there is a missing item group. Such import jobs will have status completed. | |
Item details | Sorting when adding a new color When adding an item to an existing model, the size sorting will be copied from existing size in other variants (colors) if all sizes within model have the same sorting number), otherwise sorting number is copied from size register. The same business rule is used when importing items. | |
Price | Warning when planning code does not exist When editing price and selecting to save for (model/color) items without the given planning code, user will get error message; “The item must contain planning code {planning code}. The price will not be edited if the planning code is missing”. Performance improvement when changing price type The user should not experience any delay in the user interface when creating new price and changing price type from ordinary to campaign price. |
Import grid with file types
(Work ID: 166771)
The import grid shows import files of type PRICAT, Temalogic and Mass update with the following columns default:
Import ID, File type, Name, Status, Scheduled for, Season ID, File suppl. no, File suppl. GLN, Supplier, Created date, Created by, Modified date and Modified by.
Release 15.01.20
Module | Description | Work ID |
---|---|---|
Import | Validation of supplier when main supplier is changed When the item that is imported has a new supplier, you will get validation failed/supplier deviation. If you change the main supplier in item details to the same supplier as in the file and re-validate the import file, the item will be ready for import. Alternatively, you can use the function for 'fix item identifier errors for selected items.' Import supports items with many suppliers in the same file, but only one main supplier (if not, import will fail with validation error). If none of the suppliers in the import file has IsMain-flag set to True, it is assumed that the first one listed is the main supplier. | |
Mass update | Update of original planning code After bugfix it is possible to modify original planning by using mass update with import of Excel file. | |
System | Improved startup of item management Loading of configuration after login is optimized, and time from login to opening item grid is reduced by 100-500 ms. |
Release 14.01.20
Module | Description | Work ID |
---|---|---|
Export | Export of delivery dates When items with item generations are exported, delivery dates are sorted by ascending delivery dates numbering (delivery dates externalNo in ItemService API). | |
Item details | Alphanumeric descending sorting of planning codes When adding item generation and selecting planning code, the planning code is sorted alphanumeric descending. | |
Import rules | Add freight is default When creating Import rule, 'Add freight' is default set to True. |
Release 13.01.20
Module | Description | Work ID |
---|---|---|
Item details | Set main supplier When the user selects the main supplier, the supplier window/page is kept open so other values can be edited before closing and returning to item details. Supplier color code when adding items to variant When adding new items to an existing variant (model-color) supplier color code is copied to item details. Deleting item generation Deleting an item generation (planning code and related planning code attributes) could be necessary when created by mistake. When deleting an item generation this also triggers deletion of prices with this planning code. | |
Import | Improve error handling when importing marketing codes Import with marketing codes is possible when import rule flag 'Copy attributes from previous item generation' is set to True. Better performance when updating existing items The performance is improved for update of existing items when importing Pricat file. In test environment we measured the performance to be improved from less than 1 item per second to 16,4 items per second after the change. | |
Item search | Only active items in search dialog When searching for items in free text search only active items are shown. | |
System | Logging of failed imports When any approval import fails the logging is providing important details in the log in Application Insights. We have added details for error on validation scheduled: SupplierModelNo, ImportId, ScheduledFor, ApprovalRuleset, FlatBatchId. When we get error on import scheduled we have added details for: ImportItemId, UpdateType, ItemId, ModelId, ImportRuleId, ImportId, ScheduledFor, ApprovalRuleset, FlatBatchId. |
Import of stock/order status
(Work ID: 153007)
ItemService API contains an endpoint for update of stock status per store/wholesaler from systems that are master of stock. The status updates the In stock/order flag in item details, and only a change in status (from true->false or false->true) will trigger an export of item changes.
API documentation can be found here: https://itemservice.lindbaktest.com/index.html.
JSON example:
|
Release 03.01.20
Module | Description | Work ID |
---|---|---|
Import rules | Change of supplier or supplier model number in Pricat file Improved error handling for change of supplier or supplier model number when GTIN is missing from import file. Deactivated import rule An error message is shown when the user tries to import items with a deactivated import rule (which was active previous in the validation process). | |
System | Technical: Removed spam from logs in Application Insights Internet robots will not create failures in our logs. Improved performance when releasing new version When releasing a new version we swap from old version to the version without any down-time. The new version is “warmed up” before the swap if finished, so users should experience very little performance decrease. Duplicated results in grid when filter/refresh Users should not experience that duplicated results in for example item or import grid when filtering or refreshing fast (before first query if finished). |
Export inactive items to Excel in item details view
(Work ID: 166888)
In Item details 'Export to Excel' popup there is a checkbox 'Export inactive items’. When it is checked, inactive items are exported together with active items. When exporting single item, checkbox is disabled and checked or unchecked depending if item is inactive or active.
Release 18.12.19
Module | Description | Work ID |
---|---|---|
Export | Expired prices are exported for 72 hours Expired prices are exported for 3 days after expiration. This should be enough for subscribing systems if error situations should occur at 3rd party side. | |
Import | Planning attributes are copied from newest planning code When new items are added to a variant (model-color) which has a planning code, it will copy planning attributes from the newest planning code. The same business logic is used both when adding items manually or importing. | |
Item details | Fix when saving item subgroup Item subgroup can be saved and modified without problems. Package code shows TU/CU in model-color grid Problems fixed so it does not show value 1 or 2. Information message when deactivating item that is linked to another item If the item you try to deactivate is either:
Then you are not allowed to deactivate this item and a message is shown in deactivation popup. | |
Item search | Start search in grid by pressing Enter or clicking on filter icon When filtering/searching in grid columns the search will be performed after leaving field/pressing Enter key or clicking on filter/search icon. |
Import rule with checkbox for ‘Overwrite existing lead time’
Checkbox 'Overwrite existing lead time' is available in Import rule details. If it is checked, value in 'Lead time' field in item register is overwritten by value in import rule or import file (if Import rule is empty) if such is given when updating item using approval import. If it is unchecked, value in item register is never overwritten.
Release 16.12.19
Module | Description |
---|---|
Item details | Improved performance when opening item Opening item/model from item grid is much faster, especially when scrolling down before opening a selected item. Manage item generations When opening manage item generations, we show available planning codes for given item/model. By default only “Current” planning codes are visible. In colors column we show which colors that are linked to the planning code, with specific colors or “All colors”. Improved performance when searching in drop-down fields When searching several times in register values in drop-down fields user should not experience slowness. Validation of external item number When models have duplicated items due to migration of data (same size & color), it is possible to update them, change size etc. Adding new items is still impossible, and will create error situations in import of PRICAT that must be handled by support. |
Import | Import of item relations Import of item relations is re-implemented to optimize further maintenance of the code. All of add/edit/remove related items works the same way. It is possible to remove related items reference with empty list, and the same for bundle content. For Excel import user needs to add parent item with empty value for content or add NULL value. It is not possible to add a related item which are in the same model, nor duplicates within same type or the same item. It is possible to add the same item for different relation types. 'Update items from file' in Import 'Update items from file' button is disabled for imports with status Imported. When status is Partially imported, only not yet imported items are updated. Error handling for items without GTIN Items can be added to a model where one of the items are missing GTIN. |
Released 11.12.19
Module | Description |
---|---|
Export to Excel | Inactive status and inactive date Columns for inactive status and date for inactivating are added to export to Excel. To get inactive items exported to Excel the user must first select to view inactive items in the grid. |
Item search | Improved performance when filtering on item number Searching/filtering on (external) item number is faster. |
Import | Improved error handling When there is something wrong with an item import we create error for given item without affecting the whole batch of items. Error handling for Pricat files with more than 10.000 items is also improved. |
System | Date in UTC-format The system handles dates in UTC-format for currency rate dates, delivery dates and season dates. |
Released 09.12.19
Module | Description |
---|---|
Import | PRICAT import: Fix item identifier when new items and update for same supplier model number When importing new items and in the same import there are updates for existing items as well as same supplier model number and this files get 'item identifier' error, then from now all items get error. Until all 'item identifier' errors are fixed, it is not possible to import new items. They get error: Item identifier error. Supplier deviation for other variant. Temalogic - compare price values in import. Compare price values for Temalogic import Import from Temalogic can be exported to Excel for comparison of existing price calculation values with values from the import file. |
Released 05.12.19
Module | Description |
---|---|
Item details | Saving models with many items We have fixed performance issues related to item plannings and supplier details, and verified that models with 500 items can be modified and saved without problems. |
Item search | Scrolling in item grid Scrolling in item grid is improved to handle filtering with locked columns. |
System | New design for Item Management The Lindbak logo is replaced by the EG logo. Design is modified to use EG green color in the top bar. |
Released 04.12.19
Module | Description |
---|---|
Export | Decimals in currency rate Currency rates are exported with 4 decimals (not rounded to 2 decimals). |
Released 03.12.19
Module | Description |
---|---|
Item search | Cost carrier column in item grid Cost carrier columns added to item grid, directly after brand column and by default hidden. Filter on this column with default sorting can be done with good performance. |
Item details | The first supplier on item is automatically set as main supplier When adding supplier for the first time, it will be common and added as main supplier. When user goes back from 'item suppliers' (3rd level) grid, we have removed loading of item again, so it moves much quicker back to item details grid. |
Released 29.11.19
Module | Description |
---|---|
Import | Validation for currency in imports Currency is validated in item imports preventing imports of currencies that are not existing in currency register. If a user imports an item that has a currency that does not exist, the validation will fail with the message "Unknown currency". Import: All sizes are updated with new color even if they are not in the import file When updating color in import, but not for all items, there will be displayed a warning 'Color for variant will be updated' and after the import the whole variant's color will be updated. For size validation still works as before. |
Price calculation | Validation of price calculation fields Validation has been added to the following fields:
If invalid values are added to these two fields (0) the box will turn red. If a user still attempts to create a price with invalid values, a warning will be displayed at the top of the price calculation and the price will not be created. |
Released 26.11.19
Module | Description |
---|---|
Item details | Validation message if reaching highest value for external item number when adding new items When creating new items and external item number is reaching it’s highest value, a validation message will be displayed both in “New item” and item import. Error messages: Highest number for size in external item number, XXXXXXXXX990, is reached Show cost carrier Fixed bug preventing cost carrier to be visible in item details. Timeout when saving large models After fixes it doesn't time out when saving values on model level or item-level to all items for large models (350+ items). |
Released 22.11.19
Module | Description |
---|---|
System | Change in database model: Attributes moved from model to item level Supplier is defined per variant (item level in database). Attributes 'Can be ordered', 'Country of Origin', 'Manufacturer' are saved on item-level. The user must now select to save these attributes to all items within the model. |
Import | Handling of size issue between variants in same model When there are colors or sizes which have for different colors/sizes same color/size number parts (Parts of external item number - 7-9 for color and 10-12 for size), item will be added with next possible value. |
Released 21.11.19
Module | Description |
---|---|
Mass update | Fix for mass update from Excel Critical bug is fixed. |
Price calculation | Time zone When working with prices, the user will see dates in the configured timezone, and be able to see the prices as they will be effective in stores, without the users local time zone interfering. Validation of mandatory price fields When saving a price, user will be notified if wholesale price or recommended retail price is 0. |
Released 20.11.19
Module | Description |
---|---|
Mass update | Preventing new planning codes for items being created from mass update If planning code in Excel file for mass update does not exists for given item, the validation will result in an Error, preventing the item planning from being created. |
Price calculation | Create price: Warning when planning code deviation within model When creating a new price the user will see which colors that do not contain the planning code, so the user will know beforehand which items will not contain the price. |
Released 14.11.19
Module | Description |
---|---|
Mass update | Preventing new items from being created from mass update
|
Import | Color can be removed in PRICAT file Problem fixed: When removing color from imported PRICAT file, the imported items will be created without color. |
Item search | Better performance when opening item grid Performance tuning. |
Item details | Item subgroup can be added to item Problem fixed: No error message when saving after adding item sub-group. |
Price calculation | Copy price triggers export of item Copying a price triggers export of the targeted item and it's new prices. |
System | Simultaneously import and export of the same items Problem fixed: Ordering of items will be correct when doing mass update of the same items that is being exported (due to a previous mass update). |