Fix: offer group processing stuck when changing from item to model level (RTC-45198)

Offer group processor job is not stuck when offer group level changes after import. Improved performance of processing offer group on model level, when model contains a lot of items.

Offer group items processing is retried properly (RTC-45066)

When item is missing in Promotion database, offer group items processing is properly retried by 3 executions of OfferGroupProcessor job, even when missing items are in more than one batch. After 3 retries, manage items page in UI is not stuck on loading screen and properly found items are displayed.

Remove offer group items duplicates (RTC-43718

Offer group items duplicates are removed. Database index is added to ensure there are no duplicates of offer group item.

Export manual price locks to Excel (RTC-44292)

There is 'Export manual price locks' button in toolbar of 'Items with price lock' page. It triggers export of Excel file that can be downloaded from notification after FileExport job run. Grid filter and store group scope of 'View promotions' permission affects which rows are exported. Only manually created price locks are exported (not price locks on offer level). File has columns: 'SKU', 'GTIN', 'Item no.', 'Item text', 'Model no.', 'External model no.', 'Color text', 'Size text', 'Brand text', 'Locked from', 'Locked to', 'Manual', 'Store level', 'Store group code', 'Store group name'.

'Locked from' and 'Locked to' values are not filtered and values are not exported properly. This will be fixed as separate issue.

Grid columns (RTC-44497)

In 'Promotion offers' grid, 'Offer ID' and 'Offer code' columns are hidden by default. 'External promotion no' and 'External offer no' columns are added and hidden by default. 'Offer name' column values have a clickable link that opens 'Edit offer' view.

Offer group processor (RTC-43443)

Long segmentation processing does not block the entire offerGroupProcessor package. Offer groups with item lists are processed before segmentations. The segmentationTimeoutInMinutes parameter is changed from an hour to 5 minutes.

Trigger promotion and offer items export (RTC-44254)

In promotion grid, in first column there is three dots button with 'Export promotion' button. It triggers export of selected Promotion and related PromotionOfferItem blobs to other systems.

Image Added

Button 'Export offer items' is added to three dots menu in offer details card, offer details grid and offer details modal. It triggers export of PromotionOfferItem that are part of offer groups within selected offer.

Image Added

Button is available for promotions on statuses: Planned, Active, Finished. In order to use the both buttons, user needs to have permission 'Access to system tasks and information'. Export is done in next scheduled execution of Export job.

Fix: navigation (RTC-44413)

Clicking on offer name navigates to offer details view and clicking on offer group name navigates to offer group items grid view.

Image Added

Validation (RTC-44261)

There can be only one manual price lock per item and given store or store group. If a user tries to add a new, repeating record or edit the price lock in such a way that duplicates would be created, there is message in the modal that this is not possible. Existing duplicates are deleted. Only the latest manual price lock (according to created date) is left.

Image Added

Fix: valid date change after editing other promotion details (RTC-44853)

Valid from/to date and time are properly saved in database. Dates are not changing on its own when editing other details of promotion.

Performance of import of items from Item Service (RTC-40521)

Improved performance of ItemMerger job, which is responsible for importing ItemChanges from ItemService.

Item search (RTC-43529)

User can scroll, add columns or remove them from item search. Modal contains model related columns: 'model number' and 'External model no.'

Grid improvements (RTC-43198)

Store group reference' column is split into 'store group code' and 'store group name' columns. 'Item text' column is in locked section of the grid. Store related columns in locked section are smaller. Button with delete is not displayed when creating a price lock.

Image Added

Concurrent request (RTC-43777)

If there is an attempt by the API to modify a resource by multiple requests at the same time, 409 code is visible for the user. A description of this code is in the swagger: '409 - conflict, resource desired to update has been modified by the concurrent request. In such scenario it is advised to fetch the desired resource once again, compare it with the request data and try to update the resource once again'.

Validation for 'validTo' field (RTC-43719)

There is a validation when creating new promotion with ValidFrom to in the past. When such request is sent, ValidFrom remains unchanged and promotion is updated, 200 status code is returned.

Export promotion blob after item selection change (RTC-43240)

After items are added/removed from bundle offer group, promotion blob is exported as well as offer group items blob.

Item search return items that are in Promotion database (RTC-42558)

Item search result does not show items which are not yet imported to Promotion database from Item Service.

Price lock processor job (RTC-41916)

There is new PriceLockProcessor job that adds or removes items from offer groups, based on setup in price lock register. Job triggers after manual price lock is created/edited/deleted and when valid dates of promotion are changed. Additionally job triggers every night (default 3 AM UTC) to automatically add/remove.

Not existing service bus topic handling in user interface (RTC-43781)

User interface requests do not completely fail when service bus topic is not found. Exception is thrown but rest of request works properly (changes saved in database). For example, when PriceLockProcessor job was not yet enabled (so job cannot be triggered), it is still possible to manage price locks and edit promotion details - changes are saved in database.

Price with status deleted (RTC-42891)

OfferGroupProcessor job does not match deleted ordinary price when price lookup for offer group item. If item in planned promotion was added with planned price, but then price was deleted, after reprocessing of offer group, item will have new price valid in correct date, or is deleted from an offer if no active price was found.

Swagger documentation improvements (RTC-42769)

'Promotion Service Gateway API' section of Swagger has description of rules regarding promotions, offers, offer mix type, offer items and API limitations. Within each PUT request, there are multiple examples of request body, that cover different use cases of API. Each example is described by its custom name. Additionally there is example of responses for item upsert request, that contain error texts.

Item group number (RTC-38886)

Table with items has ItemGroupId instead of itemGroup-related fields. Item groups with duplicated item group numbers are removed. Item group number cannot be null. If ItemGroup is not found in the import of items, it is created.

Performance of promotion export (RTC-42899)

Improved performance of exporting promotion.

Fix: error message when promotion does not exist (RTC-42986)

404 status code and proper error message is returned when referencing not existing promotion in upsert promotion offer request or referencing not existing promotion or offer in upsert offer items request.

Fix: promotion price can be set to 0 (RTC-41237)

Promotion price of offer item can be set to 0. When one of items has price set to 0, offer items grid is loaded properly. It is possible to export such offer item to Excel file.

Changing the item list in the Promotion module when there is no connection to the Item Service (RTC-41204)

If the user want to edit item list through user interface but there is no connection with Item Service, the user receives a message in the red bar. The item list does not change in the promotion offer in order not to lose information about previously added items but there is an information that the selection contains 0 items/variants/models. The display will change if the selection has changed but the items do not change, e.g. the items will be displayed as models. In this case, the columns in the grid will change

If the user wants to edit the item list via an Excel file while the Item Service is not working, the result is as follows: The notification 'Items in offer could not be synced with Item Service' top right corner and message 'Manage item list is not available until offer items are synced. You will be notified once the items are synced.' at the top of the grid are visible. 'Edit item list' button is not available. Imports from 3rd parties work very similarly. The only difference is the lack of notification.

Only offer groups with processed and synced items can be copied.

It's possible to import Excel if model number is not specified but there is external model number in the file.

OfferGroupProcessor job is triggered by default every 5 minutes.

Put request for adding items to the offer (RTC-41208)

PUT request /promotions/[EgPromotionIdentifier]/offers/[EgOfferIdentifier]/items in Promotion Service is supported.
Request body must be as documented in Swagger. For more information and rules regarding API, please refer to description and endpoint schema in 'Promotion Service Gateway API' part of Swagger, as well as 'File-import documentation' (all the business rules of import apply to API).
Items can be imported to offers with mix type supported in 'PUT Offer' request. Maximum 500 items can be sent. Each request with items to offer group result in removing items which were in offer previously. Items and prices lookup is done only in Promotion database. Logic of all lookups is as in OfferGroupProcessor job (it means this work the same as imports and user interface actions). Items are added to offer as 'offline item list' and data is exported to POS. Then, during next scheduled OfferGroupProcessor job run (default 5 minutes cron), such new item list is synced to item service, and previous one is deleted. Offer group items cannot be updated in user interface until item list in item service is synced.
Errors regarding promotion, offer, item, price lookup and contract schema are returned as a part of request response. It also contains upsert status, count of items without price and count of not found items.

Fix: duplicates of ExternalModelNo (RTC-42961)

Import of items from Item Service saves item on model level with empty ExternalModelNo if received value is already used by other model in Promotion database. Additionally, release of RTC-41204 does not fail when there are ExternalModelNo duplicates in database (suffix is added to duplicate).

Manage offer in grid view (RTC-41924)

In promotion details, in grid with offers, there are three dots and eye icons for each offer row.
With three dots menu, it is possible to manage offer like in cards view (edit offer, manage items, import items, copy offer, remove).
With eye icon, modal with offer details is opened (same information as in card view). From modal it is also possible to make any of listed actions. Options available in these menus are affected by same rules and permissions as in the card view.
By clicking on link in 'Offer id' column in the grid, 'Edit offer' page is opened.

Image Added

Validation of incomplete mix 31 offer (RTC-42015

When promotion is created containing price rule with mix 31 that has values editable in offer, 'incomplete' flag is set properly until user fills in the missing values. It is not possible to submit and approve promotion with incomplete mix 31 offer.

Ordinary price column (RTC-41555)

Ordinary price column is visible in manage items grid in the offer on item/variant/model levels.

Put request for creating/updating offer (RTC-41207)

PUT request /promotions/[EgPromotionIdentifier]/offers in Promotion Service is supported.
Request body must contain JSON entity as documented in schema in Swagger.
For more information and rules regarding API, please refer to description and endpoint schema in 'Promotion Service Gateway API' part of Swagger, as well as 'File-import documentation' (all the business rules of import apply to API).
Mix types supported in this request are:
PromotionPrice
BuyNSelectedItemsAndGetDiscountOnTheYCheapestItems = 23
BuyNSelectedItemsForXAmount = 21
BuyOneItemFromSelectionAAndGetDiscountOnItemB = 4
DiscountOnWeightItem = 5
DiscountOnSelectedItems = 28
SubtotalDiscount = 26
PromotionDiscount = 101

Fields validation errors are returned as a message with status code 422. Code 400 with description is returned on rule violation. Correctly upserted offer is returned with code 201 (created) or 200 (updated), and response contains all the schema values of offer.

Image Added

Mix 101: Use item group list (RTC-39529)

Item group list can be added to the Mix 101 (Promotion discount) offer. It's possible to create promotion with this mix from item group list view. Percentage discount can be modified for each item group in side panel which contains percentage discount. Default percentage discount is added to all item groups when adding them to the offer. If value is not specified, is equal to 0 % by default.

Image Modified

Put request for creating/updating promotion (RTC-41206)

PUT request /promotions in Promotion Service is supported.
Request body must contain JSON entity as documented in schema in Swagger.
Fields validation errors are returned as a message with status code 422. Code 400 with description is returned on rule violation. Correctly upserted promotion is returned with code 201 (created) or 200 (updated), and response contains all the schema values of promotion. Promotion is always created as approved. Promotion is not exported until there is at least one offer in it.

Image Modified

Fix: ignore wrapping spaces in import of items and item groups from Item Service (RTC-42246)

When there are wrapping spaces in a text type of field in ItemChanges (item) or GroupHierarchy (item group) file from Item Service, there is no validation message during import and data is saved in Promotion database without wrapping spaces.