Stores

Store Service API

System

System

Fix bug: Translations (RTC-39728)
Translations are correct after removing local storage.

Import from Chain Web

New company for store (RTC-39641)
New company is properly created when store is imported with organization number and country that does not match any already existing company in Store Service.

Turkey (RTC-38817)

Turkey can be selected as a country of company, store, profile, team or postal code. Country can be set through import and is exported with code TR.

Fix: Description of fields marked as optional (RTC-37753)

In store import contract schema, description of field marked as optional is displayed (currently it is only replenishmentEnabled, other fields are only nullable).

Fix: Exception handling (RTC-28779)

If there is an error related to the database, the error is written in the error text field in FlatBatchJson table, 10 times retry and then FlatBatch and FlatBatchJson have a status of 4.

New framework for user interface (RTC-37797)

Store management is upgraded to framework versions Angular 16 and Kendo 12.

Inventory related translations (RTC-35163)

'Inventory' and 'Inventory management in use' Swedish translations are changed.

Replenishment flag (RTC-36275)

'Replenishment' flag is set to 'True' by default. It is displayed in 'Inventory' section of store details page, when creating new or editing existing store. Value is exported to Excel file and blob storage. Value can be set through import of Excel file and import from 3rd party (it is optional in both, set to True if not specified).

Create price suggestions flag (RTC-34337)

'Create price suggestions' flag is set to 'False' by default. It is displayed and can be set/edited only on Profiles. Value is exported to blob/file.

Fix: External store number validation (RTC-34864)

It's possible to update the store with (not empty) external store number using Excel import.

Fix: Exception handling (RTC-35478)

Apart from the exception in the database and log in the Integration Platform, the execution of job is 'Completed with warnings'.

United Kingdom and Iceland (RTC-34482)

United Kingdom and Iceland can be selected as a country of company, store, profile, team or postal code. Countries can be set through import and are exported with codes GB and IS.

ExternalStoreNo and storeNo in 3rd party import (RTC-32637)

If at least one of the 'storeNo' and 'externalStoreNo' is correctly specified when importing the store and the other is null, the null value is ignored.

Import file with thousands of rows (RTC-34237)

StagingImport job does not fail when one imported file contains over 4000 of JSON rows.

External store number (RTC-31286)

There is a validation while importing Excel file with stores: External store number must be unique within a company. If there are two or more shops with the same company and the same external store number in the file then only the first record from the file will be added.

Global location number is unique (RTC-33526)

Global location number of store is globally unique value. Validation occurs when value is already used, when creating or updating store. In case of existing duplicates, global location number is set only for the first store, for the remaining null is assigned. In import from BackOffice, duplicates are saved with null value. In import from 3rd party, row with duplicate is validated and not imported. In import of Excel, validation in user interface happens if duplicate exists in database, and row is ignored if there are duplicates in one file (to be handled with warning notification in future).

GLN translations (RTC-32596)

Global location number (GLN) translation to Norwegian and Swedish is changed.

Database compatibility level (RTC-32039)

Compatibility level on databases is set to 150.

Upgrade to LibBackEnd 5.4.0 (RTC-33212)

LibBackEnd updated in order to support notifications and Azure SignalR.

Migration to .NET 6 (RTC-28896)

Store Service module is migrated to .NET 6.

Opening hours in Store export contract (RTC-28717)

Opening hours are added to export documentation in Swagger as 'storeHours' field. Export is not yet extended.

Import companies from Excel (RTC-26694)

Companies can be imported from Excel file using 'Import' button in the 'Companies' view. Required columns are "Company code", "Company name", "Country", "Organization no.". Exported file with companies should be used as import file template. Import can be used to create new and update existing companies. Companies are identified by "Country" and "Organization no." pair ("Organization no" unique within "Country". "Company code" and "Ext. company no." must be unique. Companies can be deactivated using file when all stores within company are inactive. "VAT no." column is ignored in Norway and Sweden - value is generated as in user interface. Existing values can be cleared by importing "NULL" in cell. When an import is finished, the user gets a notification.

Remove obsolete validation when importing stores from OnPrem (RTC-25000)

Stores are imported properly when: post code is empty, city is empty, close date is before opening date, local store number is 0, phone is not valid for given country code.
Phone is validated to be a number. Spaces are removed from number to make it valid. Country calling code prefix is added.
Store groups with type 'Common' and 'Default' are skipped instead of failing.

Export companies to Excel (RTC-27807)
There is a button 'Export to Excel' in the 'Companies' view. It exports companies from register to the Excel file. User can narrow results by applying filters in columns in the grid. Exported fields are:

• Company code
• Company name
• Country
• Organization no.
• Ext. company no.
• VAT no.
• Is active
• Company address line
• Company address line 2
• Company postal code
• Company city
• Invoice address line
• Invoice address line 2
• Invoice postal code
• Invoice city

Store groups country (RTC-27849)

Country of store group is exported as CountryCode for each store group assigned to store. Store groups without country are exported with null value. Re-export of stores is triggered when country of assigned store group is edited.

Special dates (RTC-25596)

There is a 'Special days' section in the 'Opening hours' page. It shows all days from the current year when store is not open as defined in standard opening hours. After pressing 'edit special days' button, another page is opened, where special days can be set. New special day can be added by a panel at the top of the page and existing special days are visible in the grid below. Future days from the grid can be edited by clicking a pencil button in the row. Then 'edit' modal shows up where changes can be entered. Future days can be also removed by clicking a bin button in the row. Then 'delete' modal shows up where confirmation of deleting is needed. If selected day has breaks, there is a question in the modal whether remove all breaks from this day or only currently selected break. Working special day can contain maximum 4 time breaks and must contain date, open time and close time. If special day is set as not working day, there is no possibility to set time or breaks.

In order to view and edit special dates following common roles are needed:

• View opening hours and special days: required to view 'Opening hours' page.
• Edit opening hours and special days: required to create, edit and remove special days. This role cannot be selected without view permission.

Assign store to opening hours register (RTC-25784)

On store details page there is a section for 'Opening hours', which contains 'Use opening hours schedule' checkbox. By default, stores are not using any opening hours register. Once checkbox is checked, dropdown appears, where user can choose one of active opening hours schedules from the register. When a schedule is selected, its data is displayed below dropdown: opening hours for each weekday and special dates in current year (same as in opening hours register details page).
Opening hours and special dates in register and store details are displayed in user region format. Dates from current year are displayed in ascending order.