Offer deleted on status planned (RTC-42666)

Export of promotions and offer items contain data from offers deleted not only on status 'Active' but also 'Planned'. In database, there is 'IsDeletedWhileApproved' flag instead 'IsDeletedWhileActive'.

VAT rate decimals (RTC-43453)

When item price has decimal value as a VAT rate, it is saved with no rounding on offer group item row. As a result, Margin (GP) and Promotion price WO/VAT are correct in price panel.
For existing offer group items with incorrect VAT rate, it is needed to re-add item selection to the offer (to trigger update of ordinary price used in offer group item row).

Fix: order of fields in export of promotion to blob (RTC-42404)

In Promotion.Promotion.Export offers, 'mixType' is first field in 'mixDetails' entity (to ensure backwards compatibility with old package versions).

Deleted offers (RTC-39591)

Offers deleted before approving promotion are not exported. The same for offer items from such offers.

Promotion and offer item, logs (RTC-39974)

No exception is thrown when importing not existing promotion with status 'deleted'. Such promotion is skipped in import. Log about failed offer item import contains information about external offer number, offer item identifier and flat batch JSON id.

Show offers as grid (RTC-40576)

The user can display offers as a list (by clicking 'Show offers in a grid') or as cards ('Show offers as cards'). The first view is a grid with the following columns: offer id, offer name, price rule, active, incomplete, coupon offer, external offer id, coupon offer id, member offer and bundle offer. Incomplete offer means that mix details are not defined correctly or offer doesn't have items. In the second view, in which user can view offers as cards, 'Active offers' filter is renamed to 'Active and complete offers'. When trying to submit or confirm promotion with incomplete offer, validation message contains identifiers of incomplete offers. When the user enters the details of the promotion, sees the offers as cards by default. Then, offer view type (grid or cards) selection is remembered in browser - after entering any promotion, page in lastly used offer view type is displayed.

Number of times the offer can be used in coupon offer (RTC-39868)

'Number of times the offer can be used' value is editable in offer or displayed as defined in price rule regardless of whether offer has coupon added or not. Removed 'Once per unique coupon' text that was previously displayed as value when offer had added coupon.

Get requests for promotions and offers (RTC-41205)

GET requests in Promotion Service are supported:

• get promotion by external promotion identifier
  /promotion/?externalNo=[ExternalPromotionIdentifier]
• get promotion by internal promotion identifier
  /promotion/[EgPromotionIdentifier]
• get promotion offer by external offer identifier
  /promotions/[EgPromotionIdentifier]/offers/?externalNo=[ExternalOfferIdentifier]
• get promotion offer by internal offer identifier
  /promotions/[EgPromotionIdentifier]/offers/[EgOfferIdentifier].

Authorization token is required. If promotion or offer is not found, 404 (not found) status code is returned. If no identifier is specified, 400 (bad request) status code is returned. When fetched offer belongs to another promotion than specified by promotion id, 400 (bad request) status code is returned. Incomplete offers (with missing mix details fields) are returned with default values.

Promotion API documentation in Swagger (RTC-41203)

Contracts for Promotion API endpoints are documented in Swagger:

• Put upsert promotion,
• Get promotion by external promotion identifier,
• Get promotion by internal promotion identifier,
• Put upsert offer to the specified promotion,
• Get promotion offer by external offer identifier,
• Get promotion offer by internal offer identifier,
• Put upsert items to the offer.

OfferGroupProcessor job replaces ItemSelectionItemImport job (RTC-37763)

Items are added to the offer group by OfferGroupProcessor job. Compared to ItemSelectionItemImport, item and prices lookup is done in Promotion database instead of requests to Item Service API.

When item, model or variant that is part of selection is not found in Promotion database, then job completes with warning. Processing is retried 3 times (each 10 minutes by default).
Import of items to single item offer groups (mix type 4 and 5) supports GTIN and ExternalItemNo.
When creating offers on model or variant level, the selected item from the model/variant must have an ordinary price.

Performance of promotion approval (RTC-39966)

Improved performance of approving promotion, editing approved promotion, update of promotion through 3rd party import.

Fix: offer trigger code (RTC-41748)

When creating new offer with voyado coupon, offer id is saved as offer trigger.

Coupons on offers (RTC-41435)

When only one offer trigger type can be selected (for offers created by third party import) or if previously selected offer trigger type cannot be changed, radio buttons are not displayed in the offer details view.
Fix: User can change coupon offer for offer imported from third party.

Documentation (RTC-39713)

Mix types are visible in contract schema for promotion.

Discount code (RTC-41528)

The discount code field (named offerTriggerCode in import) can have up to 30 characters.

External identifiers in export to blob (RTC-24502)

ExternalPromotionNo/ExternalOfferNo are exported as ExternalPromotionNo/ExternalOfferNo in export of Promotion.Promotion.Export.

Import of offers with mix 101 (RTC-39061)

Offer with mix type 'PromotionDiscount' (mix 101) can be imported from 3rd party or from Excel file. It is marked as supported in the Swagger documentation. Excel with offer items exported for mix 101 offer contains 'Promotion discount' column. When uploading Excel, promotion discount field is ignored for offers using mix other than 101. When exporting Excel for mix 100, the 'Promotion net price' column is no longer present in the file.

One item offer group validation rule (RTC-39736)

Removed SKU validation for importing items to offers with single item (no error message when import contains only GTIN or ExternalItemNo). Note that such item will still not be added to the offer (for now SKU must be defined when importing item to one item offer group in mixes 4 and 5).

Coupons on offers (RTC-38665)

ExternalCouponId is obsolete in import. If provided, works as before but OfferTriggerType and OfferTriggerCode must be null then. ExternalCouponId has value of OfferTriggerCode in export.

Possible values for OfferTriggerType:

• 'DiscountCode' ('General coupon' in UI),
• 'Coupon' ('3rd party integration coupon' in UI),
• 'Standard' (no 'Coupon offer' in UI).

'Coupon' is not supported in import. 'OfferTriggerCode' must be specified when OfferTriggerType is 'DiscountCode' and must be null if OfferTriggerType is 'Standard'. If OfferTriggerType and OfferTriggerCode are not specified, we have 'Standard' offer without coupon.

Import of offers with mix 26 (RTC-39131)

Offer with mix type 'SubtotalDiscount' (mix 26) can be imported from 3rd party. It is marked as supported in the Swagger documentation. Offer items cannot be imported for such offers (this mix type affects all items).

Import of offers with mix 4 (RTC-39034)

Offer with mix type 'DiscountOnWeightItem' (mix 5) can be imported from 3rd party. It is marked as supported in the Swagger documentation. Only a single item can be imported to such offer (with logic as in mix 4).

Import of offers with mix 4 (RTC-39035)

Offer with mix type 'BuyOneItemFromSelectionAAndGetDiscountOnItemB' (mix 4) can be imported from 3rd party. It is marked as supported in the Swagger documentation. When importing PromotionOfferItem for the offer, selection to which item should be added can be specified using OfferItemType field: 'Condition' and 'Reward'.
Only a single item can be imported to 'Reward' offer group of offer using mix 4 - for each import to 'Reward' group, only 'newest' item (based on created date) is added to offer (new imported item removes previous one, and only item from last line is added if there are multiple in one file).

Import of offers with mix 28 (RTC-39033)

Offer with mix type 'discount on selected items' (mix 28) can be imported from 3rd party. It is marked as supported in the Swagger documentation.

Fix: Edit external offer without coupon (RTC-39449)

It is possible to save changes when editing an offer that was created from 3rd party, without the need to touch 'coupon' checkbox.

Choose type of coupon (RTC-38615)

When tenant is not configured to use Voyado integration, coupon can be added as before.
When tenant is configured to use Voyado integration, user can choose type of coupon creating new or editing existing offer. When '3rd party integration coupon' chosen, offer is created in Voyado. This type of coupon cannot be changed or removed once created. '3rd party integration coupon' cannot be added for offer that was created by import from 3rd party. User can now also choose 'General coupon'. In this option, coupon can be defined by input field, same as when not configured to use Voyado. This coupon can be removed or replaced by 3rd party one.
Coupon input field now allows text, no spaces, and maximum of 10 signs. Validation is changed in import of promotions from 3rd party as well.

Mix 101: Promotion discount (RTC-38232)

There is a general discount on whole offer which can be defined in price rule or editable in offer. In items in promotions view it's possible to adjust promotion discount per item.

Export documentation (RTC-38276)

Swagger contains documentation regarding export of promotions, available mix types and examples of Promotion and PromotionOfferItem exports for various offers and offer items.

Import of prices (RTC-37762)

All item prices from Item Service are imported to Promotion database by new ItemPriceMerger job.

Import of item groups (RTC-38300)

All item groups are imported from Item Service to Promotion database (extended functionality of StagingMerger job).

Access control - copy offer, copy promotion (RTC-30144)

Both 'Copy promotion' and 'Copy offer' buttons are visible when user has access to manage any store or store group.

Performance of active promotions in user interface (RTC-39251)

Improved performance of approving promotion, editing and stopping active promotion in user interface (fix related to marking offer items to be exported).

Import of items (RTC-37761)

All item changes from Item Service are imported to Promotion database by new ItemMerger job. Items are saved in table that already contained items that were part of offers. When useModelItems=true, for each imported item, variant and model level rows are updated (they are used for offers on those levels). When useModelItems=false, only item rows are created.

Description of changes, history, info about changes exported to POS (RTC-36677)

Information for planned promotions that changes will be immediately exported to POS is visible when editing promotion or offer details and when managing items. Description of changes are required. There is a note in the history section after creating promotion, adding and copying offer, updating promotion or offer details and after managing items.

Mix 104: Buy from group 1, get discount on group 2 (RTC-35721)

Fields to define in this mix type are:

• Reward - Discounted price

Offer with mix type 104 has two offer groups. Rules: buy from group 1, get discount on group 2. Discounted price for group 2 can be editable in offer or defined in price rule. When creating a new offer with this mix, always two groups are created with quantity 1. Mix details for offer using mix 104 are properly exported.

Documentation for mix 101 'Promotion discount' (RTC-37334)

Business rules, import example and schema is added for upcoming mix type 101 - Promotion discount (mixType: PromotionDiscount in Promotion import and PercentDiscount value added in PromotionOfferItem import).
Import of this is not yet supported.

Fix: Promotion Price update (RTC-38292)

Excel and 3rd party imports support update of Promotion Price value. Change of this value result in export of updated order line to blob.

Performance when adding items to the offer group (RTC-37691)

Added database index to improve performance when adding items to offer group. Size of batch that is saved to the database is set to 2000 by default and can be changed using parameter in configuration of ItemSelectionItemImport job.

Export only changed rows after recalculation (RTC-36798)

After item selection update (e.g. after segmentation recalculation at night), only rows with changed values are exported. This increases the promotion update performance from Promotion module to POS.

Promotion grid side panel (RTC-37256)

Side panel in promotions grid is closed by default and its state is saved in local storage.

Fix: Promotion exported before PromotionOfferItems (RTC-36675)

In every blob export situation, the active/planned Promotion is exported before PromotionOfferItems.

Fix: Add segmentation to offer through 'Edit offer' page (RTC-34391)

Offer processing is started properly after user opens 'Edit offer' page, clicks 'Manage items' and creates new segmentation.

Fix: ItemSelectionItemImport (RTC-36697)

ItemSelectionItemImport is not stuck when processing the offer groups. This could happen before in some special cases.

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

Fix: Missing items in export after approval of promotion (RTC-36216)

All offer items from all offer groups in promotion are included in export execution after promotion approval is finished. Before this fix, some items could be missing from export due to approval request being handled at the same time as the export job was running.

Mix 40 (RTC-34083)

Offer with mix type ''Combine from groups and get collective discount" (mix 40) can be imported from 3rd party. It is marked as supported in the Swagger documentation. Import of discount on offer level is not supported.

Fix: Add segmentation to offer through 'Edit offer' page (RTC-34391)

Offer processing is started properly after user opens 'Edit offer' page, clicks 'Manage items' and creates new segmentation.

Fix: Segmentation recalculation in night (RTC-35260)

During night recalculation of active offers, existing segmentations are recalculated and unnecessary copy of segmentation is not created.

Parameter for ItemSelectionItemImport (RTC-35197)

There is a parameter 'Timeout per offer group (in minutes)' with default value equal to 60 min. After this time offer group with problematic segmentation is skipped but other groups are processed.

Performance improvement (RTC-35199)

Improved performance of export job to prevent its failure, especially in case of re-exporting all offer items to POS.

Offer items from deleted offer group (RTC-35136)

After removing offer group, items from this group are exported with status 'Deleted'.

Logs and fix of offer items export (RTC-35802)

Export job executions (Promotions and PromotionOfferItems) save logs with row versions that are exported as well as number of exported rows.
Missing rows export of offer items is fixed (bug in comparison of row versions to be exported).

Deleted offer group (RTC-35136)

There is no validation message after import of promotion as JSON file with offer group which have 'Deleted' status, when this group was already deleted before.

Mix 35/41 (RTC-34082)

Offer with mix type 'combine from groups and get discount per group' (mix 35/41) can be imported from the 3rd party. It is marked as supported in the Swagger documentation. If the mix has several groups and we provide not unique identifier, there is validation.

Offers with mix 21 (RTC-34080)

Offer with mix type 'Import of buy N selected items and get a discount' (mix 21) can be imported from 3rd party. It is marked as supported in the Swagger documentation.

Faster filtering and search (RTC-34087)

Fetching data and filtering for 'Items in promotions' page for offers (grid for item level and for item group level offers) is faster. Sorting on status, store group code, store group name, period overlaps columns in grid for offers on item level is not possible.

Fix: Adding hundred thousands of items to offer (RTC-35572)

Reduced page size when fetching items and prices from Item Service to avoid errors when item list or segmentation contains hundred thousands of items.

Export after update from 3rd party import (RTC-34351)

Promotion is exported properly after offer is added to existing promotion or updated through 3rd party import. Offer items are always exported after such import as well.

Performance of export of offer items (RTC-30142)

There is no timeout when there are many offer item changes exported (e.g. after approving promotion with 100+ thousands of items or manually re-exporting all promotions to POS with SQL script).

Import file with thousands of rows (RTC-34237)

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

Documentation for mix 10/13/39 (RTC-34227)

Business rules and import example in Swagger are added for 'Buy N or more items and get a discount per piece' mix type.

Access control - filter promotions in grid (RTC-14422)

In Promotions grid user sees only those promotions for which he has access to view (e.g. promotions in this store, but also profile and team promotions of store for which he has permission and profile promotion of store from team for which he has access etc). When copying offer, list of promotions show only those to which he has manage permission.

Model name (RTC-33204)

Model names with up to 255 characters are correctly stored in the Promotion database.

Database compatibility level (RTC-32039)

Compatibility level on databases is set to 150.

Fix: Remove unnecessary "Save changes" dialog (RTC-32922)

Dirty modal does not appear if the user wants to go to the previous view and has not edited offer details / price rule. It's also not visible when leaving offer details / price rules which are in read-only mode.

Fix: ItemSelectionItemImport job logs (RTC-33069)

ItemSelectionItemImport logs contain number of items added to offer group and items with no prices. Example: 'Offer groups with succeeded state (offer group id (items with prices / items with no prices)): 1234 (5/1)'. At the end of each section containing information on a single segmentation/list is such message: 'Offer group processed: 0 items and 1 item without price.' Above messages are visible only for groups that were processed 10 seconds or longer and their processing was successful. If the job has status 'CompletedWithWarnings', the user sees the text 'Offer groups with failed state: 1234'.

Number of times the offer can be used if 'Coupon offer' checked (RTC-28451)

When 'Coupon offer' checkbox is selected then 'Number of times the offer can be used' input is replaced with text 'Once per unique coupon'. Reuse condition is saved in database based on previous values and price rule settings. If ' Number of times the offer can be used' is editable in offer and the user does not enter a value and select 'Coupon offer' checkbox, the value 1 is saved in the Promotion database. Regardless of value in Promotion database, in POS the coupon offer is treated as 'Once per unique coupon'.

Offer items

Process manually updated offer groups before externally imported ones (RTC-32502)

ItemSelectionItemImport job (responsible for adding items into offer groups) first process changes triggered in user interface and then changes triggered by external import of JSON file. When there is ongoing import of items, and user adds items to some other offer group using user interface, this offer group is first in processing queue so user does not need to wait till import of data is finished.

Upgrade to LibBackEnd 5.4.0 (RTC-33205)

LibBackEnd updated in order to support notifications and Azure SignalR.

External model number (RTC-32735)

'External Model Number' is added as column in the 'Items in promotions' grid in item view and in the offer group items grid. New column appears when an item list or segmentation at item, variant or model level is added to an offer group. This is visible by default only on model and variant level. Column cannot be shown when tenant is using non-model items (system parameter). 

Fix: no duplicates of items (RTC-33160)

Fixed issue in ItemSelectionItemImport job, which caused duplicated item rows in Promotion database after adding non-model item to offer on variant level (then such duplicates were added to offers anytime when adding such SKU to offer on any level).
During release, existing duplicates are removed. Unique indexes added to prevent duplicated items in future.

Performance of adding items to offer group (RTC-32248)

Improved performance of adding items to offer group. Improved performance of fetching data for 'Items in promotions' page.

Database maintenance job (RTC-32287)

There is a 'PromotionServiceJanitor' job in PromotionIntegrationPackage package. By default, in runs once every night. If there were any changes in database, it rebuilds index on tables in Promotion database. This results in a reduction of the database size and improves performance of external data processing.

Integration job cancellation (RTC-32247)

Integration package has a handling for cancellation of job (e.g. during package restart).

Fix: Segmentation in offer on model/variant level (RTC-28577)

Offer group items are added on item, variant or model level according to what was selected in modal when adding new segmentation to offer/ editing segmentation used in offer.
When creating new offer, there is possibility to choose selection level in new modal after selecting existing segmentation from the list.

Item lists' 'browse by' variant is remembered and used when adding item lists to promotion.

Segmentation on item hierarchy (RTC-27619)

Segmentation can be done on all item hierarchy levels: Department, Item area, Item group and Item sub group.

Collapse offers in promotion details view (RTC-26944)

Each offer in promotion details view can be collapsed by clicking in offer header. Offers are not collapsed by default. When offer is collapsed, only offer name and code (if specified) are displayed.
When at least one offer is collapsed by user, default state for this user changes to all offers collapsed.
If all offers are not collapsed, default state is not collapsed.
Width of offer details in promotion details view is constant for all mix types.

Sorting of offers (RTC-26945)

Offers' headers contain offers' names and offers are sorted by offer name in promotion view and report tab. If offer has coupon, coupon id is displayed in the offer view.

ItemSelectionItemImport job logs (RTC-26961)

Execution of 'ItemSelectionItemImport' job shows detailed logs in Integration Platform Management, what makes it easier to investigate flow of item import from Item Service to offer.

Store group price in store promotion and prices import timeout (RTC-27247)
Items with store group price, when added to promotion in store assigned to store group, will be added with store group price (removed feature is added again, as it was not cause of issue).
Timeout of request for segmentation items prices is extended due to low performance of database query (until faster solution is developed).

Sales unit of an item (RTC-26987)

'Sales unit' value set on an item is imported from Item Service when item is added to offer.
PromotionOfferItem export to blob contains 'unitOfMeasureShortNameEN' field, which is 'Code (EN)' value in Unit register in Item Management.

Rollback: Store group price in store promotion (RTC-27200)
Items with store group price, when added to promotion in store assigned to store group, won't be added with store group price due to low performance. Fix will come in future.

(Changes only in item service, promotion is affected).

Columns in the grid (RTC-26350)

Promotions grid is extended with the following columns:

• Visible by default:
  • 'Member offers' flag
  • 'Coupon offers' flag
• Hidden by default:
  • Promotion ID
  • Ext. promotion no
  • 'External promotion' flag
  • Promotion type code
  • Promotion type name
  • Category

Main page of Promotion Management is Promotions grid page.

Store group price in store promotion (RTC-26078)

Items with store group price, when added to promotion in store assigned to store group, will be added with store group price. Prices of an item are fetched in hierarchy: store, price zone, profile.

Update of price in offers on store group level (RTC-24361)

When an item with store price is added to an offer on store group level, and then a store group price is added and item selection is reloaded, ordinary price is updated with correct store group price. When the new price is higher than the previous, the promotion price is not updated. When the new price is lower than the previous, the promotion price is set to ordinary price.
In case of promotion on all stores or store group, when an item has prices only in stores, price in store with smallest number is used when adding price to offer (store numbers sorted as text).
In 'All stores' offers, the price is selected in hierarchy: profile, price zone, store.

Documentation (RTC-24949)

DayPeriod (timeFrom and timeTo fields) is displayed properly in examples of import and export file.

Documentation (RTC-26496)

Contract of promotion and items export is extended with fields related to mix type 100 - 'Combine from groups and get a specified price' (new values in mixDetails on promotion level, and 'bundleAddOnPrice' on offer item level).

Import API for mix type 23 (RTC-25940

Offer with mix type 23 ("BuyNSelectedItemsAndGetDiscountOnTheYCheapestItems") can be imported from blob sent by 3rd party. Contract and business rules are documented in Swagger. Default values of mix type parameters define "3 for 2" offer. Imported offer uses 'Generic 23' price rule, which is not available when manually creating new offer.
Items can be imported to offer with mix type 23, but sales price cannot be set.
"Number of times the offer can be used" field in relevant mix types can be set to "Unlimited" when editable in offer.

Promotion and offer code in offer item export (RTC-25223)

Offer item export contains promotion code and offer code values.

Promotion id (RTC-25871)

'Promotion id' is visible in promotion details view and edit modal.

Set promotion type parameter in user interface (RTC-24761)

'IsPromotionTypeRequired' parameter value is displayed on 'System parameters' page and can be updated there.

Mix 41 limitation (RTC-24796)
Mix 35/41 has an information that it supports only a few items due to complex price calculation. It's displayed in  the following places:

• 'Promotion details' view
• 'Manage items for offer' view
• 'Edit offer' modal
• 'Create offer' modal

Mix 23 (RTC-25532)

Radio buttons are independent from each other in price rule view for mix 23.

Fix for mix types 11, 23, 25 (RTC-25949)

Only 'Percent' discount is available when managing offer using mix 11, 23 or 25, when value is editable in offer.
In mix type 23, 'Number of items' value in 'Conditions' section must equal 2 or more.

Showing date and time in grids (RTC-25449)

Time (in grey font) is visible in every date column in every grid in Promotion Management. Filtering in these columns is at the date level.

Description of dynamic selection (RTC-24951)

Description of dynamic selection displayed when choosing item selection type says that this selection will be updated every night, only when promotion is planned or active.

Spaces validation in blob import (RTC-24732)

Spaces at beginning and end of text in promotion/offer item import from blob are validated properly.

Fixes for time period (RTC-24753)

Focus is always set on the right button which can be used to specify time period.
Items in 'Bestsellers' section are cached when user goes to item sales. Therefore after coming back to report, this section looks the same and there are no loading circles.

Offer items update (RTC-24656)

• When adding, updating or removing item from an offer, offer is found by "externalOfferNo" (external unique identifier). "ExternalPromotionNo' is not supported.
• Promotion with status 'Active' or 'Finished' cannot be deleted through blob import (status 'Deleted'). When promotion is updated with 'ValidTo' value in past, current date is used and promotion is set to 'Finished'.

Validation for mix type 5 (RTC-24009)

If there is the same value in 'min kg' and 'max kg' fields in the modal for mix type 5, validation message is shown that maximum value must be greater than minimum value.

Export offer on model/variant level (RTC-24099)

Offers on model or variant level can be exported to Excel file. File contains same identifiers as in offer grid on each level, kickbacks and prices. File can be used as a template for import on these levels (import of kickback and prices on model/variant levels are not yet supported).

External Offer Number and Offer Code (RTC-24230)

Offer Code values are separated from External Offer Number. Offer Code is an input field on offer level. If offer has offer code, it is shown in the offer's details. External offer number is 3rd party unique identifier of offer, which is used when managing promotions and offers through API. If offer has external number, it is displayed in the offer's details.
Import and export of JSON file is extended with a new 'offerCode' field. In export, both these values have value of offer code (until changes in POS are done).

External Promotion Number and Promotion Code (RTC-24231)

Promotion Code values are separated from External Promotion Number. Promotion Code is an input field on promotion level. If promotion has promotion code, it is shown in the promotion details. External promotion number is 3rd party unique identifier of promotion, which is used when managing promotions through API. If promotion has external number, it is displayed in the promotion details.
Import and export of JSON file is extended with a new 'promotionCode' field. In export, both these values have value of promotion code (until changes in POS are done).

Documentation (RTC-24233)

Swagger documentation for import has been added.

Fix: Offer Code (RTC-24737)

Offer code and promotion code can be duplicated. There is possibility to open and edit promotion/offers with duplicated offer code.

Approval for imported promotions (RTC-23958)

If promotion is created by importing a blob, it is automatically created as approved in user interface and exported to blob. There is a possibility to create active promotions ('valid from' date set in the past) or planned promotions ('valid from' date set in the future). If promotion has status 'planned', changing 'valid from' date to the past makes this status active.

Fix: Scheduled update of promotion offer (RTC-24602)

During scheduled update of segmentation in Promotion Management, there is no issue in communication between Item Service and Segmentation Service.

Use offer id as coupon value (RTC-24501)

When Voyado integration is enabled, and offer is marked as coupon offer, offer id is used as coupon (without 'Promotion-' prefix). This value is sent to Voyado as external promotion code (POS external offer redemption channel value) and to blob as externalCouponId.

Disable update of store/store group (RTC-23725)

It is not possible to change selected store/store group in existing promotion. If needed, it can be done by creating a copy of the promotion.

Filter for Not finished promotions (RTC-22896)

'Status' column in Promotions grid has a 'Not finished' filter. It shows promotions with statuses other than 'Finished'. This filter is set by default when opening promotions grid.

Time period (RTC-22848)

There is a 'Time period' section in the 'Promotion Report' view. User is able to set 'start date' and 'end date' in order to get data only from this period. It applies to whole report view and item sales grids. At the bottom of this section there are buttons which can be used to specify time period: 'date choice' (manually defined period), 'yesterday', 'this week', 'last week', 'last month'. A progress bar in the 'Sales' section shows promotion sales from selected period and percentage of total sale.

Remove and add offer groups in mixes 34, 35/41, 40 (RTC-23609)

Offer group identifier within offer is unique, so offers are updated in POS properly after one of offer groups is deleted and new one is added (new offer group has new identifier instead of using identifier of removed group).

Swedish translations (RTC-23832)

Swedish translations of mix types names and descriptions are updated.

Removed offers and items (RTC-22211)

Item search and item sales grid works for deleted offers. Items removed from the offer when promotion was active are also displayed in item search and item sales grid.

Identifier of offer group item (RTC-23558)

Export of offer items to POS contains "offerItemNo" field, which is globally unique identifier (GUID) of offer group item.

Switch between offer groups (RTC-23740)

Items/models/variants/item groups in offer view are displayed properly when switching offer group using buttons in top right corner.

Better looking report (RTC-22847)

Sections in promotion report are grey with rounded corners and columns in the 'Bestsellers' section have titles.

Promotion price can equal 0 (RTC-22770)

'Promotion price' value can be set to 0 in the price panel in 'Manage items' view.

Removing offer group from the offer (RTC-23081)

There is a possibility to remove an offer group from the offer with multiple offer groups. Deleted offer group is exported to file (blob) with status 'deleted'.

Discount on discount (RTC-23556)

It is possible to submit promotion which uses mix type without 'Discount on discount' flag.

Discount on discount (RTC-21867)

Discount on discount can be defined in the price rule or marked as editable in the offer. If a price rule is used in a promotion, 'discount on discount' field can no longer be edited in the price rule view.

Offers

Promotion report

Export

Promotion report

Show item attributes from Reporting Service (RTC-22076)

Bestsellers and sales per item shows item attributes received from Reporting API. This is also the source of data in item sales grid when there are over 5000 items in offer or offer applies to all items. In other cases, item attributes in item sales grid are displayed from promotion database.

SKU column is removed from item sales grid.

System

Loading sign in grids (RTC-22411)

Loading sign is added to all grids in promotion module. It is displayed when data is being loaded to grid.

Offer

Segmentation on variant and model level (RTC-20639)

Items can be added to the offer using item segmentation on item, model or variant level. After selecting item segmentation and clicking 'add to the offer' button, there is a modal window which asks on what level user wants to add segmentation. The default selected value is item level.

After adding items, variants or models to the offer, in the 'Manage items' view, there is a message above the table about what level is used in the item segmentation. Columns in this view match selected level.

Export to blob:

• Items are exported with 'gtin', 'externalItemNo', 'sku' fields in the 'itemIdentifier' section.
• Models are exported with 'modelNo' field in 'modelIdentifier' section.
• Variants are exported with 'variantIdentifier' section which contains 'colorText' field and 'modelIdentifier' section.

Price rules

Fix for mix 21/22 (RTC-21930)

It is no longer required to always update 'Min. receipt amount of other items' field when editing price rule with Mix 21/22.

Promotion type

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.

Price rules

Define discount type in price rule, and discount rate in offer (RTC-19795)

Discount rate and discount type are specified separately on price rule level. It is possible to create price rule with defined discount type, but discount rate editable in offer.

Promotion report

View item sales (RTC-20115)

In each of the sections in 'Report tab', there is a 'View item sales' button. It opens grid with sales of items within promotion/offer. By default, it contains columns: GTIN, Item text, Quantity sold, Sales amount, Gross profit total and Brand. Grid is sorted by Sales amount by default. Other columns that can be added to grid are: SKU, Color, Size and Item group no/text.

• When promotion/offer consists of less than 5000 items, all of them are displayed in grid, including never sold ones.
• When promotion/offer has more than 5000 items, only 5000 items with highest number of sold amount are shown.
• When offer applies to all items, only sold items are in the grid.
• Report received from Reporting API is cached for one hour. It makes data load faster when re-opening page, but also means that new sales statistics may not be visible until hour passes.
• Offers on model and variant level are not yet supported.

Item search for offers on model/variant level (RTC-21646)

When offer is created on model/variant level, it is possible to search for an item from this model/variant in the item search in promotion report.

Deleted offers sections (RTC-21305)

Section for the offer deleted from an active promotion is displayed on report tab, so it is possible to see sales statistics for all offers that were active in the past.

Labels for items in promotion on variant level (RTC-21265)

After creating a promotion on variant level, all items from this variant are imported with prices to the table [Promotion].[OfferGroupItem]. Also these items get labels with the promotion price. Labels are always taken from the offer where price for specific item is the smallest.

Promotion

"Promotions" grid on small displays (RTC-21349)

Columns in "Promotions" grid are divided into two sections - locked and scrollable one. By default, in section on left there are "Code", "Name" and "Status" columns. These columns are always displayed. Other columns are in section on the right side of the page. When columns are too wide to be displayed, this section is scrollable horizontally. Columns can be moved by user between those two sections.

Fix for mixes 34, 35/41, 40 (RTC-21499)

Export of offer items does not fail after the first offer group is removed from an offer. This applies to mixes in which we can add and remove offer groups: 34, 35/41, 40.

Combine from groups and get discount per group (RTC-21896)

Name and description of mix type 35/41 is changed to 'Combine from groups and get discount per group'. Discount can be specified for all groups in the offer with this mix type.

Offer items on model level (RTC-19251)

Items can be added to the offer using item list on item level or on model level. After selecting items/models and clicking 'add to the offer' button, there is a modal window which asks on what level user wants to add these items. The default selected value is the same as the level user used for browsing items.

After adding items or models to the offer, in the 'Manage items' view, there is a message above the table about what level in item list is used. Columns in this view match selected level.
Items are exported to POS with 'gtin', 'externalItemNo', 'sku' fields in the 'itemIdentifier' section and models are exported with 'modelNo' field in 'modelIdentifier' section.

Offer items on variant level (RTC-20131)

Items can be added to offer on variant level. When editing offer item list, in modal after selecting items/variants/models, there is an option to add items on variant level. Variants with at least one item from it selected, will be added to the offer group. When viewing offer group created on variant level, grid shows values that define variant. Each row is one variant. Variants added to an offer are exported to file (blob) with same fields as model, extended with color value.

Offer name in description in Promotion history (RTC-17304)

If user updates offer details or item selection in an active promotion, description of changes is automatically saved in the promotion's history and contains offer name.

Bestseller (RTC-20061)

In 'Promotion total' part of promotion report, there is a 'Bestsellers' section. It contains a list of 10 best selling items for the promotion. Each item is represented by its name and sales quantity. Each item in list can be selected. By default, the first item in the list is selected.
To the right of 'Bestsellers', there is a 'Sales per item' section. It shows sales quantity, amount and gross profit of the item selected in the bestsellers list.

When an item cannot be found in the Promotion database, its GTIN is displayed instead of the name.

Offer sections (RTC-20111)

Below 'Promotion total' section, there are sections for each offer that is in this promotion. By default, all those sections are closed. Closed sections show the number of items sold. After opening it, there are sales statistics same as in promotion total, but only for items within this offer.

Mix: Buy N items (from all items in the store) and get a discount (RTC-19537)
Mix type number 31, 'Buy N items (from all items in the store) and get a discount'.
Fields to define in this mix type are:

• Conditions - minimum number of items and discount on discount
• Reward - Discount on items in the receipt (percent or amount).

Offer with this mix applies to all items, so there is no possibility to select offer items. Parameters of this mix are exported with offer to POS.

Mix: Buy for X amount and pay Y amount per piece for N items (RTC-18593)

Mix type number 6b, 'Buy for X amount and pay Y amount per piece for N items'.
This mix extends Mix 6 from Chain Classic and replaces Mix 29.
Fields to define in this mix type are:

• Conditions - Min. receipt amount
• Reward - Number of discounted items, New price per discounted item.

Offer with this mix have one group of offer items. Parameters of this mix are exported with offer to POS.
When discount of an offer is New price = 0, 'Item for free (0.00)' message is displayed in offer details. This applies to mixes 4, 5, 6b, 21/22 and 40.

Mix 10/13/39 (RTC-19140)

Mix type number 10/13/39, 'Buy N or more items and get a discount per piece'.
Fields to define in this mix type are:

• Conditions - Min. number of items
• Reward - Discount per item (percent, amount or new price).

Offer with this mix have one group of offer items. Parameters of this mix are exported with offer to POS.

Export of offers (RTC-18854)

When discount type of mix type 35 is percent, discount is exported as a fraction on PromotionOfferItem level.

Mix 23 (RTC-18841)

Mix 23 can have multiple discounted items. Number of items in reward section can be defined per price rule, or be editable in offer. Price rules and offers created before have number of discounted items set to 1. Name and description of Mix 23 is updated. Export of promotions and offers to JSON file updated with new mix name and numberOfDiscountedItems value.

Mix 21/22 (RTC-15874)

Mix type number 21/22, 'Buy N selected items and get a discount', replaces old mix 21.

Fields to define in this mix type are:

• Number of items
• Min. receipt amount of other items
• Number of times the offer can be used
• Discount on discount
• Discount.

Offers migrated from mix 21 have these values applied:

• Min. receipt amount of other items = 0,00
• Discount on discount - false
• Discount - New price.

JSON files from export have been extended. New fields on offer/item level are:

• 'DiscountedPrice'
• 'MinReceiptAmountOfOtherItems'
• 'DiscountOnDiscount'
• 'DiscountType'.

New field on promotion level is:

• 'MinReceiptAmountOfOtherItems'.

Promotion type can be required (RTC-16582)
There is a parameter in the database named 'IsPromotionTypeRequired'. It's set to False by default and it specifies whether Promotion type is visible and mandatory.

• If parameter is set to True, Promotion type is required when creating, editing or copying promotion.
• If parameter is set to False, Promotion type field isn't visible when creating a promotion and it's optional when editing. When copying a promotion, visibility of this field depends on promotion - if promotion has promotion type, this field is visible but if promotion hasn't promotion type, this field isn't visible.

When changing the parameter in the database there is need to delete the record from local storage in the browser to see changes.

Export of promotion with deleted offers (RTC-19346)

When removing 'Promotion price' offer in an approved promotion, offer items are re-exported with status 'Deleted'.

Access control for manage promotions (RTC-13288)

There are store roles in user management which limits access to promotion management:

• 'View promotions' allows user to view promotions which affects prices in selected store (e.g. user can view promotions in selected store, store groups where it belongs, and all store promotions'.
• 'Create promotion and manage draft promotions' allows user to manage draft promotions in selected store/store group. 'View promotions' permission is required.
• 'Approve promotion and manage approved promotions' allows user to approve promotions and manage approved promotions in selected store/store group. Both of the above permissions are required.

Permissions are checked in promotion management and in item management (when creating promotion from item list view).

Mix 26 (RTC-18837)

Mix 26 has correct description in 'create price rule' view and in price rule details.

Recurrence parameters validation (RTC-18465)

When a field has an validation error and the user unselects and selects the checkbox, error on the field is displayed properly. This applies to 'Select available hours' and 'Excluded dates' checkboxes in create, edit and copy promotion views.

Promotion notifications (RTC-18663)

Notifications disappear after pressing 'View segmentation' or 'View offer' button in notification.

Permission to view promotions (RTC-19242)

• If user has access to one or more stores from promotion (store role 'view promotions'), there is a possibility to view items in this promotion. There isn't any possibility to edit promotion or offers. If offer has offer groups which do not have any items, user is not able to open the offer. If offer includes both offer groups - with and without items, user is able to open the offer and in empty offer groups there is a message: "No items selected."
• Offer groups without any items are handled in the same way for finished promotions.
• If user has access to all stores from promotion, there is possibility to view items, manage them and edit details of promotion and offer.
• If user has access to one or more stores from promotion's team/profile, it works the same as described in the first subsection.

Daily updates of dynamic offers (RTC-12338)

Once a day at 1AM all offers containing dynamic segments will be recalculated, so that items will be added or removed automatically. After start of 'Segmentation Scheduler' job, offers with item segmentation from active/planned promotions are marked for recalculation. When Segmentation Scheduler job is finished, the 'Item Selection Import' job will run and update the segments.

Copying offers with single item (RTC-18467)

Offers with only a single item can be copied to another promotion. If the item does not have a price in the promotion's store, proper information is displayed above the offer group's grid. After clicking 'view more info', modal with instruction how to update offer is displayed.

Availability details export on item level (RTC-18687)

Promotion availability details are exported to a JSON file with each item that is part of the 'Promotion price' offer. Editing details of an approved promotion triggers re-export of all offer items.

Manage items in offer (RTC-18448)

When filters in the offer items view are set and there are no items in the grid as a result, the price panel shows no data.

Single item in the offer (RTC-18144)

When 'single item' in mix 4 and 5 is not selected there is no "clear selection" and "export to excel" buttons in toolbar.

Audit columns (RTC-15500)

In offer view, there are audit columns 'Created by', 'Created date', 'Modified by' and 'Modified date'. Columns display information about who and when added or modified item in an offer. These columns are hidden by default.

Mix types (RTC-18181)

At the end of description of mix types 21, 23, 26, 28 and 40 there are information about what mix types from Chain Classic that these mix type replaces.

Mix type descriptions (RTC-18186)

On 'new price rule' view, mix types descriptions wraps when there is not enough space to display text in one row. Description is displayed properly on screens of any size, including mobile devices.

Keyboard navigation in modals (RTC-18392)

Space can be used in names and description input fields in modals. If modal is opened, keyboard navigation does not affect grid behind the modal. Applies to modals:

• 'Import items' and 'clear selection' in the offer view
• 'Use file' in the item list view
• 'New segment' in the item segmentation view

User permissions (RTC-14566)

Access to store/store groups is limited for an user in a more performant way.

Adding items to the offer (RTC-18145)

Performance of adding items to the offer has been improved. Loading items takes a few seconds. After user gets notification, the page is refreshed.

Offer view (RTC-17479)

When applying filter to the grid in offer view, grid does not automatically scroll to the left. If price panel was closed when applying filters, it stays closed after filtering as well.

Item selection for an offer (RTC-17791)

Keyboard can be used to navigate in offer view after adding items to new item selection or updating existing one.

Export of items in the offer (RTC-18055)

Discount type is exported in JSON file for items from all groups in mix type 35/41.

Export of kickback (RTC-17454)

After updating item selection for an offer, kickback values are exported to POS properly for all items with store price.

Selection type for offer (RTC-17201)

Types of item selection that can be selected for an empty offer are described on type selection view with short title above description.

Offer view improvements (RTC-17161)

In offer view, focused button in side panel can be triggered by clicking Enter. Margin change p.p. in items grid is displayed in percentage points. Validation errors for percentage columns are displayed properly.

Performance when adding items to promotion (RTC-16867)

For user who triggered import of items to promotion, loading page is refreshed immediately after import is finished. For other users who are waiting on loading page, refresh will happen in less than 4 seconds after items are added.

Copy of promotion (RTC-17340)

Category field is copied when copying promotion. If source promotion has category, its value can be changed on 'copy promotion' page.

Promotion type (RTC-15420)

There is Promotion type field in promotion details view. It is visible only when Promotion type is set for promotion. Promotion types are specified in 'Promotion type' register. If a Promotion type is set as default in register, it will be chosen when creating new promotion. Promotion type can be changed in 'Edit promotion details' modal but it is not a required field. When copying promotion, Promotion type can be selected, and saved to the copy. This field is exported to POS.

Name of new segment in offer (RTC-16025)

When creating new segment for an offer, the segment name is prefilled with offer name

Export and import of items to the offer (RTC-16737)

Columns with kickback amounts have been added to the exported Excel file. During import of items, when both values are given (kickback percentage and kickback amount), kickback amount is ignored and values are calculated based on kickback percentage. Kickback amounts given in imported file should be less than 0 and value of -(kickback supplier amount + kickback chain amount) should be less than ordinary net price.

Export of offers (RTC-17446)

Fields for specific mix types in export after updating the offer:

• Mix type 4: Discount(Price/Amount/Percent), RequiredQuantity and MaxCountInReceipt
• Mix types 21, 23: Discount (Percent), NumberOfItemsCustomerBuys and MaxCountInReceipt
• Mix type 28: Discount (Amount/Percent) and MinReceiptAmount.
• Mix types 35(41), 41: Discount (Price/Amount/Percent) and MaxCountInReceipt

If offer has unlimited number of times it can be used, 'MaxCountInReceipt' field isn't exported.

Kickbacks for all mix types (RTC-13363)

Price panel is displayed for all mix types. For mix types other than promotion price there is a possibility to change Kickback supplier, Kickback chain and Promotion supplier net price values. Only items with store prices are shown in the offer's grid and only these items can be exported to the Excel or blob.

Notifications when adding items to promotion price offers (RTC-14805)

Notification about the update is displayed when items are added to a Promotion with "promotion price" offer. If some of the items don't have store prices, text about not adding them to the offer is displayed in the offer view. There is also a possibility to export these items to an Excel file.

Rounding of promotion price values (RTC-16286)

All values in the promotion price side panel are rounded to two decimals. After clicking on Kickback supplier or Kickback chain field, all digits are displayed. All values in grid's columns are also rounded to two decimals.

Copy offer price (RTC-15517)

Values for Kickback supplier, Kickback chain, and Promotion price are copied per item when an offer using promotion price rule is copied. If a price on an item was updated in the meantime or is different for a different store or time period and it's lower than the promotion price, the promotion price is set equal to the new ordinary price.

Performance when adding items from item list (RTC-12703)

Items added to offer don't wait for ((ItemSelectionItemImport) job trigger anymore. They are processed right away.

Display time in promotion details (RTC-16022)

Time and recurrence if promotion is recurring are displayed in 'Valid period' section in submit and approve promotion modal. Time is displayed in 'Valid from' section when editing promotion. When creating promotion first Offer has 'Promotion price' rule selected by default.

Promotion price panel default opened (RTC-16019) 

When user enters promotion prices "Manage Items" view, panel for defining promotion price is open by default. When user enters some values into the panel all values are bold and there is "Modified" sub-title added.

Promotion price panel (RTC-13032)

It's possible to navigate promotion panel using keyboard: by using SPACE we can open the panel ESC closes it. There are buttons Save(ENTER), Save + Next (SHIFT + ENTER), and UNDO {CTRL + Z) which are also accessible through keyboard. By using arrow up and down keys it's possible to navigate through grid of items.