Coming next release
Area | Description |
---|---|
Price lock | 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. |
...
Release 10.09.2024
...
Area | Description |
---|---|
Offer group items | 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. |
Promotion API | 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. |
System | 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. Improved performance of exporting promotion. |
...
Release 03.09.2024
Register and new field for offer
...
When a user tries to add a locked item to a promotion, an information is displayed about how many items have not been added due to the price lock. If the price lock period no longer applies, it is necessary to manually re-add items to the promotion by editing the item list, importing items by Excel file or importing items by third party. To be able to add, edit or delete price locks, a user needs 'manage price locks' permission which depends on 'view promotion' permission. If a user does not have permission to manage price locks but has access to the store/team/profile, locked items are visible in the grid but only in read mode. Offer group item that has not been added to the offer because of the price lock is exported to 3rd party with the status deleted.
Improvements
Area | Description |
---|---|
Export | 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'. |
Offer item price | 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. |
Promotion API | 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. |
...
There is a side panel in the promotion grid that allows to filter the grid based on the profile, store, team that user wants to see. Only promotions that are inside the selected scope are visible to the user.
Improvements
Area | Description |
---|---|
Offer | 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. |
System | Fix: ItemSelectionItemImport (RTC-36697) ItemSelectionItemImport is not stuck when processing the offer groups. This could happen before in some special cases. Apart from the exception in the database and log in the Integration Platform, the execution of job is 'Completed with warnings'. |
...
Status is changed by 'OfferScheduler' integration job, which by default runs at 01:00 UTC. It starts schedule of offers with matching 'Valid from', and offers with 'Valid to' set to day before (offer scheduled to be active from 01.05.2023 to 08.05.2023 is activated on 01.05.2023 01:00 UTC and deactivated on 09.05.2023 01:00 UTC).
'Activate'/'Deactivate' button on offer is removed. It is no longer possible to manually deactivate or activate offer without setting a schedule.
Improvements
Module | Description |
---|---|
Offers | Copying offers (RTC-31729) It is possible to directly copy an offer into the same promotion the offer is in. 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. |
System | Item name and item group name (RTC-31164) Item names with up to 255 characters can be stored in the Promotion and Procurement databases. The same applies to item groups stored only in the Promotion database. When the item names are too long when importing OrderDespatchAdvice or PurchaseOrder via a third party, a validation error will appear. |
...
Offers cannot be deactivated when it is incomplete. Changes are saved in promotion history. An inactive offer and its items are exported (to POS) as 'Deleted', and 'Active' when (re-)activated.
Improvements
Module | Description |
---|---|
Offers | Promotion price in bundle (RTC-30324) 'Promotion price' offers marked as 'Bundle offers' are exported as 'soldInBundle' on item level. |
Promotion | Removing an offer or promotion when items are imported (RTC-30048) Deleting and editing the offer in which an item import is in progress is not possible. The user sees message in the offer details that this offer cannot be edited when import of items is ongoing. Deleting promotions during item import is also not possible. |
...
- 'Manage items' page can be entered both from promotion view, and offer details page.
- Changes in offer can be discarded using Cancel button.
- 'Description of changes' is added and required when adding new offer to active promotion.
- When Voyado API is not available when marking offer as coupon offer, coupon is not created in Promotion database as well, which makes it possible to retry Voyado request by trying to add coupon later.
Improvements
Module | Description |
---|---|
Export | Planned offers (RTC-29990) When promotion is planned, removed items are exported with status 'deleted'. |
Offer items | Supplier model/item number (RTC-29038) Supplier model/item numbers are displayed in the offer item grid. Supplier item number column is hidden when using model items (system parameter). |
Promotion | Long offer name (RTC-29034) Offer with long name is displayed properly on promotion details page. |
System parameters | Model items parameter (RTC-26188) When 'model items' dropdown list is expanded, current value is highlighted. |
...
Offer items can be added, updated and removed by 3rd party using JSON file import via File Service. Promotion and offer are identified by external numbers. Item can be imported by SKU, GTIN or Item number (items and prices must exist in Item Service). Details of file content are documented in EG Cloud Swagger. Items are validated with same rules as in Excel import. Validation errors are logged in database. Items can be added only to 'Promotion price' offers on item level.
Improvements
Module | Description |
---|---|
Segmentation | 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. |
Voyado integration | 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. |
...
Promotions can be created, updated and deleted by 3rd party using JSON file import via File Service. Required format of data is documented in Swagger. File content is validated before saving it (same rules as in user interface). Only 'Promotion price' offers are supported. Validation errors are saved as StagingMerger job warning or in [staging].[FlatBatchJson] table. When updating/deleting promotion/offer, external number is used. If 'Promotion type' does not exist, it is added to register.
Improvements
Module | Description |
---|---|
Promotion report | Better looking report (RTC-22847) Sections in promotion report are grey with rounded corners and columns in the 'Bestsellers' section have titles. |
...
Item groups can be used to define an offer group. This means an offer will apply to all items within the item group. Item group list is available for all price rules with item selection, except 'Promotion price'. Price panel (kickbacks) is not available for item group. Default kickback values cannot be set if all offer groups within offer use item groups. These offer groups are not available in 'Import' modal in Promotion view. Data in report for offer on item group level is fully based on Reporting API response. Offer is exported to file (blob) with item group numbers.
Using a link above grid in 'Items in promotions' view, user can choose offers based on their selection level: Item or Item group. Overlapping modal for an item shows offers where this item or its item group was used. Modal for item group shows only offers where this item group was used.
Improvements
Module | Description |
---|---|
Offers | 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'. |
Price rules | 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. |
...
There is a possibility to choose item, model or variant level when importing items to the offer. File exported from 'manage items' view can be used as a template. For model level models are recognized by "ModelNo" field and for Variant both "ColorText" and "ModelNo" fields must be present.
Improvements
Module | Description |
---|---|
Offers | Default kickback values (RTC-13033) "Kickback supplier" and "Kickback chain default" values can be defined on offer level. These values are used to calculate promotion net price for an item when it is added to the offer. Values can be defined for all mixtypes except 'All items' ones. Values are not applied when items were already added to offer and when importing offer items excel file which contains kickbacks. Values are also ignored when sum of amounts is greater than net price. |
Promotion report | Bestsellers section width (RTC-22748) Bestsellers section is two times wider, so items with long name, color and size are fully displayed. |
...
There are two new columns in the 'Items in promotion' grid - 'Model name' and 'Selection level'.
Modal window for overlapping promotions looks different for items/models/variants. Modal for models contains modal name and model number. Modal for variants contains model name, color and model number.
Improvements
Module | Description |
---|---|
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.
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. |
System | 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. |
...
In promotion view, there is a 'Report' tab. In this tab, there is section with total sales for the promotion. Users can see number of items sold, sales amount and gross profit total. Data shown there is obtained from Reporting API. When data cannot be received, there is "Could not get sales statistics message".
View with promotion details is moved to 'Setup' tab:
'Report' tab:
Improvements
Module | Description |
---|---|
Offers | Coupon offer ID (RTC-20395) "Coupon offer ID" input field is visible only when "Coupon offer" checkbox is checked. This applies to view when creating promotion from item list, adding offer to promotion or editing offer modals. 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'.
Offer with this mix have one group of offer items. Parameters of this mix are exported with offer to POS. Mix 10/13/39 (RTC-19140) Mix type number 10/13/39, 'Buy N or more items and get a discount per piece'.
Offer with this mix have one group of offer items. Parameters of this mix are exported with offer to POS. |
Price | Store prices in promotion on store group level (RTC-20743) When promotion is created on team or profile level, and item has price in store that belongs to selected store group, this price will be used in offer. |
...
For draft, pending approval and planned promotions there is a possibility to mark offer as 'Coupon offer' and add coupon offer ID. Coupon offer ID should start with 99 and be minimum 4 digits long. When ID is present on another offer, warning appears. Coupon offer ID is exported on offer level.
Also 'Reserved for members' field has been renamed to 'Member offer'.
Improvements
Module | Description |
---|---|
Export | Incomplete offers (RTC-17458) Removed incomplete offers are skipped when approving promotion so export job works successfully. Export of offers (RTC-18854) When discount type of mix type 35 is percent, discount is exported as a fraction on PromotionOfferItem level. |
Price rules | Mix 35/41 (RTC-19511) Mix type 30 is replaced by mix type 35/41. |
...
If the processing of offer group fails, the job retries to process it again. If it fails three times the offer group's flag ItemsProcessed is set to True and the user gets a notification. This offer group is not processed anymore.
Improvements
Module | Description |
---|---|
Export | 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. |
Offer | 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. |
Offer view | 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. |
Price rules | 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. |
System | 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:
User permissions (RTC-14566) Access to store/store groups is limited for an user in a more performant way. |
...
Discounted item in the offer (mix types 4 and 5) is displayed in a grid with columns and kickback, and price panel can be used for setting kickback. Kickback for discounted item is exported. Adding item without active price in the same store provide modal window with information that this item cannot be added. Clearing selection in active promotion leads to modal with description that offer without items is not available in the POS.
Improvements
Module | Description |
---|---|
Export | 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. |
Offer | 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. |
Promotion | Promotion grid (RTC-16897) In the promotions grid there are 'Store group code' and 'Store group name' columns. They show code and name of store, team or profile assigned to promotion. For promotions available in all stores, no value is shown. |
...
Rounding rules are applied for the promotion price in the Promotion price panel. A button appears under the price when a rounding rule can be applied. After it is clicked, the price is overwritten with the rounding values.
Improvements
Module | Description |
---|---|
Price panel | Promotion price panel (RTC-15477) Multiple quality of life improvements and fixes for the promotion price panel. Prices are calculated correctly and validation messages are displayed for invalid input values. |