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.

Central Warehouse flag (RTC-25257)

A store can be marked as 'Central warehouse' using checkbox in 'General' section on new store/edit store details page. Value is exported to blob as 'IsCentralWarehouse'.

Import of country (RTC-25042)

Country of company imported in Excel or JSON file is saved properly as country of company, company address, company invoice address and store address.

Import Excel with duplicated rows (RTC-25056)

Postal codes are imported properly from Excel file with duplicated rows.

Fix for profiles without profile group (RTC-25538)

When a profile has no profile group, it is always possible to activate it.
In store details page, when a store and assigned profile are inactive, profile and profile group are displayed properly.

Set store group as default (RTC-24702)

Profile, region and team can be set as default using button in three dots menu in store group details view. It is not required to have default store group. Only one store group of each type can be set as default. If there already is another default store group, it will be unset if another store group is set. Default store group cannot be deactivated. Inactive store group cannot be set as default. Price zone cannot be set as default team. Status of default store group is visible in grid with store groups.

Assign stores without or with unsupported country to Norway (RTC-24380)

When store imported from Chain Web on-premise has no country or country that is not supported in cloud modules, it is assigned to company in Norway with matching organization number (or new company in Norway is created). Existing stores and companies in cloud which had no country are assigned to Norway as well.

Re-export stores after (de)activating store group (RTC-25078)

Stores assigned to store group are re-exported after store group is activated/deactivated.

Store search when filtering by profile (RTC-24808)

When managing stores in team, value entered in store search is still applied to grid after profile filter is changed.

Re-export of updated stores (RTC-24111)

Re-export of updated stores is triggered in database in the same way as in other modules. When updating store group, correct user name is displayed in store audit columns.

Hide inactive stores by default (RTC-23778)

Stores grid has a default filter on 'Inactive' column, which shows only active stores.

Filtering store selection by a profile (RTC-22913)

There is a possibility to filter stores by a selected profile when adding stores to the team. New, multi-select field named 'Profile' has been added to the view. "Select all" and "Unselect all" buttons allow selection of all stores currently filtered by profiles. Store search works only for stores filtered by profiles. Also, new column with profile assigned to store has been added to the grid.
If team is a price zone, selection of profiles is disabled and profile's value is set permanently to the profile of the price zone.

Import stores from Excel (RTC-23021)

Stores can be imported from Excel file using 'Import' button in the 'Stores' view. Required columns are 'Store no.', 'Store name', 'Opening date', 'Profile no.', 'Country', 'Company'. Exported file with stores should be used as import file template. Import can be used to create new stores and update active stores. Stores can be deactivated using file, but inactive stores cannot be activated or edited. Stores cannot be assigned to inactive organization, profile, region, price zone. Above is validated with message in modal. When store group from file does not exist, it is created. When no name for store group name is provided, it is autofilled in following pattern "{entityName} # {code}". When an import is finished, the user gets a notification.

File export notifications (RTC-23488)

Notification disappears after pressing 'Download file' button.

Better information about store groups (RTC-23043)

Correct store group name ('Team', 'Profile', 'Region') is used in add store group panel, edit store group modal, message displayed in inactive store group and blocked 'Deactivate' button when store group contains active stores.

Export stores to Excel (RTC-23002)

There is a button 'Export to Excel' in the 'Stores' view. It exports all stores visible in the grid to the Excel file. User can narrow results in the grid by applying filters in columns. Exported fields are:

• Store no.
• Local no. 
• External no. 
• Global location no. 
• Store name
• External name 
• Marketing name
• Is active
• Is webshop
• Opening date
• Closing date
• Email address
• Use inventory 
• Phone no.
• City
• Postal code
• Country
• Address line 
• Address line 2 
• Company name
• Company no. 
• Company prefix
• Profile name
• Profile no.
• Price zone name
• Price zone no.
• Region name
• Region no. 

Stock lookup (RTC-22190)

Users are able to manage related stores in 'Stock lookup' section in Stores view, and for an active store via additional view after clicking 'edit' button. Only active stores can be added to stock lookup. If store from stock lookup becomes inactive, proper information is displayed for the user. Inactive stores can be removed from stock lookup. Related stores are included in the file (blob) export.

Import postal codes from Excel file (RTC-21244)

In postal codes register there is a button which opens modal, in which Excel file can be selected and imported. File must contain Code, City and Country code (same file template as in export). Import can be used to create new postal codes or update existing ones. Postal code will be updated only if code-country pair exists in register - city name will be updated. When code-city pair exists, but country doesn't match - validation error appears. In other cases, postal code is updated.

API for postal codes (RTC-21377)

There is an API endpoint in StoreService, which allows developers of other modules to use data from postal codes register.

Icon (RTC-22445)

Green EG logo is added as icon for Store Management. It is displayed on top of browser and on bookmarks list.

Postal codes register (RTC-21237)

Postal codes register can be exported to Excel file using button on bottom of page. Exported file contains columns: 'Code', 'City' and 'Country'. Export is affected by filters set in register grid.

Activate and edit row in register (RTC-22014)

After activation/deactivation of a row in the register and editing some values without closing the modal, grid is refreshed.

Fix for wrong validation when creating new store (RTC-22664)

When creating new store, validation works properly. It is possible to save new store when required fields have correct values.

Use values from register when editing address (RTC-21378)

When editing postal code in address section, dropdown list appears. It displays pairs of code and city from postal codes register. When company's country is selected, only codes from this country are displayed. Inactive codes from register are ignored. It is possible to search for code by entering code or city. After selecting code from the list, postal code and city fields are updated. It is also possible to manually enter code and city that does not exist in the register.
Above applies to 'Store address', 'Company address' and 'Company invoice address'.

Marketing name (RTC-22191)

'Store details' section has been split into 'Store details' and 'General'. 'Store details' contains 'Global location number' and new field named 'Marketing name'. Column with marketing name has been added to stores grid and it's hidden by default. Export of stores has been extended by marketing name.

Manage stores (RTC-20675)

• Using the 'Edit' button on 'Company details' page, we can manage stores in a company. Page looks same as in other store groups - on left there is a grid with stores, and on right the list of stores assigned to the company. In the grid we see active and inactive stores within the company, and active stores from other companies. Stores within a company are visible, but cannot be unselected in this view. Stores from other companies can be selected - after saving, the store will be moved from the old company to this one.
• Company can be deactivated only if all stores in it are inactive. It is not be possible to add stores to an inactive company. Inactive store cannot be activated if company is inactive.

Edit company (RTC-21032

After editing a company, stores assigned to it are re-exported with new values of the company. This happens only when edited company detail field is included in store export ("Company code", "Company name", "Country", "Organization number").

Active' flag for stores and store groups (RTC-21068)

• A new store is created as active. When creating or editing a store, only active companies, profiles, teams and regions can be selected. When the store is inactive, it is not possible to change selected store groups - these fields are blocked in the store details view. To activate the store, selected store groups must be active.
• When a store group is inactive, it is not possible to change stores assigned to it. In order to deactivate the store group, all stores in it must be inactive.
• In the 'Edit' grid on store group level, we see active and inactive stores assigned to the store group and active stores from other groups. When editing profile or region, selecting store there will result in moving store from another group to this one. In teams, it will result in assigning another team. In profiles, it is not possible to unselect store here, so it won't be left without profile.

Companies for imported stores (RTC-20437))

During import of stores from Chain Web on-premise to cloud, when new company is created, its name is in format "Company - [store name]", organization number is set to same value as in Chain Web, and company code is a random, 3-digit number.

Export of Company code (RTC-19524)

Export of store to JSON file is extended with 'Prefix' value of company ('Company code' in Company details view).

Change tracking on columns (RTC-21188)

Change tracking on columns in dbo.store table is disabled.

Database maitenance job (RTC-21190)

There is a 'StoreServiceJanitor' job in StoreServiceintegration package. By default, in runs once every night. If there were any changes in stores, it rebuilds index on dbo.Store table in StoreService database. This results in a reduction of the StoreService database size.

Company details (RTC-20488)

• 'Country' field is required when updating or creating a company.
• When 'Organization number' is not unique within the country, proper validation message is displayed after trying to save a new company or update an existing one.

Export of store groups (RTC-18805)

When 'External code' of profile/team/region is empty, 'ExternalStoreGroupNo' field is exported to blob with 'null' value.

VAT number (RTC-19762)

When creating or editing company, there is a 'VAT number' field. When selected 'Country' is Norway, VAT number is generated in format "NO<Organization number>MVA". In Sweden, VAT number is "SE<Organization number>01". When other country is selected, user can enter VAT number manually. It is a text field with maximum length of 50 signs.
'Country' dropdown list in company details is contains countries: Norway, Sweden, Finland, Denmark, Austria, Estonia, Poland, Germany, Netherlands, Belgium.

Inventory flag (RTC-18146)

There is a section in store details named 'Inventory' which contains checkbox field 'Inventory management in use'. Status of this field is exported from cloud to blob. It can also be imported from Chain Web On-Prem to Store Management.

Use of breadcrumbs in user interface (RTC-19764)

In store, team, profile, region and company details view, we show breadcrumbs in "<unique id> - <name>" format. When opening store details from the grid in team, profile, region or company details view, breadcrumbs show the correct store group, from which we navigated to this page.

Change tracking (RTC-19983)

Change tracking is retained for 2 days.