Oracle® Retail Pricing Cloud Service Oracle Retail Pricing Cloud Service User Guide 16.0.029 E99964-01 |
|
Previous |
Next |
A price change is the permanent change in the price of an item. You can use the rounding rules to move the new price to established price points or round the price.
When a price change is added, it must go through a series of checks before it can be applied to an item/location. Depending on your user role, you may not be able to move the retail price change to the next status. A change to submitted or approved status, or from approved back to worksheet, results in a conflict check. A price change may be in any of the following statuses:
Table 6-1 Price Change Status
Status | Definition |
---|---|
Worksheet |
The price change has been started, but not reviewed or sent out. |
Submitted |
The price change has been completed and is pending review. Conflict checking may have occurred (depending on the run for submit system option) for the price change. |
Approved |
The price change has been reviewed and accepted. The price change is communicated to the locations for which the price change is effective. |
Executed |
The new prices established are effective for the item/location. |
Rejected |
The price change has been reviewed and declined. |
Processing |
While the price change is being processed through conflict check the status will be listed as Processing. |
After you create a price change, you can maintain different aspects of the price change.
The Price Change Quick Create feature is designed as a key entry path for users to create a regular price change. The Quick Create feature supports grouping multiple price changes for different items and locations into a single Price Change Group. Mass maintenance can then be performed on this group later in the workflow through the Price Change Group Maintenance workflow.
Use the following procedure to quick create a price change:
Note: The Quick Create feature is available in the left pane menu and can be opened at any time regardless of what screens are open. |
From the Pricing tab Tasks list, click the Quick Create icon.
The Quick Create pane appears.
From the Quick Create pane, select Price Change from the Quick Create drop down list.
From the Quick Create pane, enter information for the following fields:
Note: Fields marked with an asterisk are required. Fields marked with a double asterisk means that one of the fields needs to be populated. |
Table 6-2 Price Change Quick Create Fields
Field | Description |
---|---|
Group |
This radio button allows the user to decide whether the price change entered will be part of a new Price Change Group or part of an Existing Price Change Group. |
Group Description |
If the user selected the New option in the Group field, this field allows for entry of a description that can be used on a new Price Change group. This description may then be used to search for the price change or price change group for maintenance purposes. If the user has selected the Existing option in the Group field, this field changes to a list of values field where the Price Change Group ID is entered instead of the description. |
Item |
The Item field allows for entry of a parent item or transaction level item. Users may enter a single item or multiple items. If multiple items are entered a semicolon is used to separate values. The field will accept up to 4000 characters. |
Diff |
The Diff field allows for entry or selection of a single Diff Value. Users have the option to use the list of values to search on Diff Type to find the Diff value. |
Zone |
The Zone field allows for entry of one or more zones within a single zone group If multiple zones are entered a semicolon is used to separate values. Note: Either a Zone(s) or Location(s) must be entered, but not both. |
Location |
The Location field allows for entry of a location. The user may enter a single location or multiple locations. If multiple locations are entered a semicolon is used to separate values. The field will accept up to 4000 characters. Note: Either a Zone(s) or Location(s) must be entered, but not both. |
Effective Date |
The Effective Date is the date when the price change will go into effect. Users have the option to key in a date or select one using the calendar widget. |
Change Type |
The Change Type field provides the options that will derive the new retail price. Options are:
|
Change Value |
The Change Value field contains the change by percent, change by amount, or fixed price value depending on the change type selected.
|
Rounding Rule |
The Rounding Rule field allows the user to associate a specific rule with a price change record. Users are allowed to enter a single Rounding Rule. A rounding rule helps users create a uniform pricing strategy. |
Reason |
The Reason field value defines the reason the price change is being created. |
Once you have entered all information for the newly created price change record, click Apply, Submit, or Approve. The new price change is created.
Note: If you select locations (or zones) with multiple currencies, you can only choose to create a price change by percent or to reset the point of sale (POS) price. You cannot create price changes by amount or for a fixed price across multiple currencies. |
The Price Change Group screen allows you to add or maintain price changes within a price change group. Each price change will contain items needing a change along with the locations or zones where the change should be made.
The Price Change Group tab has three modes; Add, Edit, and View. If you enter this screen in View mode, all maintenance options are disabled and the Save, Save and Close, and Cancel buttons are replaced with Done. If you enter in Edit mode the following options are supported:
Perform the following procedure to search for an existing price change group.
From the Tasks menu, select Manage Price Change Groups under Price Changes. The Price Change Group Search tab appears.
Enter your price group search criteria using the following fields:
Note: In order to conduct a price group search, users must enter at least one of the following; Department, Group, Group Description or Item. |
Table 6-3 Price Group Search Fields
Field | Description |
---|---|
Price Change Group |
The Price Change Group field allows the user to enter a Group ID to be used in search criteria. |
Description |
The Description field allows the user to enter a description to be used in search criteria. |
Status |
The Status field allows the user to select a Status to be used in search criteria. Values for the drop down include: Worksheet, Submitted, Approved, Rejected, Processing, or Executed. |
Effective Date |
The Effective Date field allows the user to enter or select an effective date to be used in search criteria. |
Conflicts |
The Conflicts field allows the user to select one of the following values; Yes, No or NULL (Blank) to be used in search criteria. |
Department |
The Department field allows the user to enter or select a Department to be used in search criteria. The Department list of values queries all Departments. Note: The Department, Class, and Subclass fields display the translated names if they exist. |
Class |
The Class field allows the user to enter or select a Class to be used in search criteria. The Class list of values queries all Classes or all Classes for the entered Department. |
Subclass |
The Subclass field allows the user to enter or select a Subclass to be used in search criteria. The Subclass list of values queries all Subclasses or all Subclasses for the entered Class. |
Item |
The Item field allows the user to enter or select an Item(s) to be used in search criteria. Users have the option to go directly to the search icon to look up items. |
Diff |
The Diff field allows the user to enter or select a Diff value to be used in search criteria. The Diff list of values includes both Diff Type and Diff Value. |
Once your search criteria are entered, click Search. The search results are displayed in the Results pane.
New price changes can be added to a new price change group or an existing price change group. Creating a new price change group can be done by selecting the Create Price Change Group task from the Task List, or selecting the 'Create' action from the Price Change Group Search screen. Either of these steps create a new Price Change Group into which price changes can be added by following the steps below (starting with step 3). Adding a price change is performed using the Price Change Wizard. There are four potential stops within the wizard:
Items Page
Locations Page
Price Change Page
Summary Page
To add price changes to an existing Price Change group, perform a search for the price change group that you want to edit. See Search for a Price Change Group.
From the search results pane of the Price Change Group Search tab, highlight the price change group to which you want to add a price change and select Edit from the Actions menu. The Price Change Group tab appears.
From the Item table, select Add from the Actions menu. The Add Price Change Wizard launches. Continue with the Items Page.
Items Page
The initial page in the Price Change Wizard allows you to select the items that you want to add to the price change.
From the Add Price Change Items page, enter the items to add to the new price change using the following criteria:
Table 6-4 Price Change Items Page Fields
Field | Description |
---|---|
Add Items by |
The Add Items by field allows you to select a category by which you can narrow the list of things to add to the price change. Options are:
|
Item |
The Item field is active if you select Item in the Add Items by field. Click the magnifying glass to search for an item to add to the price change. |
Parent/Diff |
When Parent/Diff is selected for 'Add Items by' the display of the screen changes, showing an item field and diff type field as the top row, with a Diffs table directly below. Entering an Item and Diff type will populate the diff table where diffs can then be selected. Combinations of the entered parent item and the selected diffs are added to the Selected Items table when the apply button is selected. |
Diff Type |
The Diff Type field is active if you select Parent/Diff in the Add Items by field. |
Item List |
The Item List field is active if you select Item List in the Add Items by field. Click the dropdown to select a defined list of items to add to the price change. |
Source File |
Source File is active if you select Upload List in the Add Items by field. Click Browse to select the file to upload. |
Once you have entered your criteria, click Apply to move entered or selected data for the item selection option to the Selected Items table. In the case of an Item List or Upload List, the items in the list are populated into the Selected Items table. Once all your items are added to the price change, click Next. The Add Price Change Locations page appears. Continue Locations Page.
Locations Page
The Locations page of the Price Change Wizard allows you to define the locations associated with the price change.
From the Add Price Change Location page, select the location type you want to use for adding locations using the following criteria:
Table 6-5 Locations Page Fields
Field | Description |
---|---|
Add Locations by |
The Add Locations by field allows you to select a category by which you can narrow the list of locations to add to the price change. Options are:
Note: The Warehouse option is only displayed if the Recognize Warehouses as Locations option is set to Yes. |
Zone Group |
The Zone Group field is active if you select Zone in the Add Locations by field. |
Zone Table |
The Zone Table is active if you select Zone in the Add Locations by field. When a zone group is entered, the Zone Table will be populated with the zones in the zone group. |
Apply Locations within Selected Zones |
The Apply Locations within Selected Zones check box is active if you select Zone in the Add Locations by field. This checkbox allows exploding the zone into stores and warehouses for populating the Selected Locations table. If you have access to one location in a zone, you can use the zone to create events. |
Location List |
The Location List dropdown list is active if you select Location List in the Add Locations by field. Click the dropdown to select from a defined list of locations to add to the price change. |
Store |
The Store dropdown list is active if you select Store in the Add Locations by field. Click the dropdown to select from a defined list of stores to add to the price change. |
Warehouse |
The Warehouse dropdown list is active if you select Warehouse in the Add Locations by field. Click the dropdown to select from a defined list of warehouses to add to the price change. |
From the search results pane, select the location(s) to add to the price change and click Apply.
Once all your locations are added to the price change, click Next. The Add Price Change page appears. Continue with Price Change Page.
Price Change Page
The Price Change page of the Price Change Wizard allows you to define the price change itself.
From the Price Change page, define the information for the price change(s) being added using the following criteria:
Table 6-6 Price Change Page Fields
Field | Description |
---|---|
Effective Date |
The date on which the price change is set to take effect. Users have the option to key in a date or select one using the calendar widget. |
Value |
The Value field provides the options that derive the new retail price. Users have the option to modify the value. Options are:
After selecting the change type, users will enter the actual value for the change. This field is required entry for every change type. The field supports up to four decimal places for Change by Percent value. For Change by Amount and Fixed Price, decimal placement is based on the currency of selected locations. |
Reason |
The Reason value defines the reason the price change is being created. Users have the option to update this field or remove the value in this field. |
Rounding Rule |
The Rounding Rule field provides the ability to smooth retails for an item or location. Users have the option to update this field or remove the value in this field. |
Once all your price change information is entered, click Next. The Add Price Change Summary page appears. Continue with Summary Page.
If you want to skip the Summary Page, you can double click on Finish or select Submit, or Approve options from the Finish drop down menu.
Summary Page
The Summary page displays the details of the price change before it is added to the Price Change Group.
Confirm the price change settings and double click on Finish or select Submit or Approve from the Finish drop down menu. You are returned to the Price Change Group screen. Your new price change is listed in the Item table.
Note: The Summary Page allows individual price changes to be removed before they are added to the Price Change Group. |
Editing price changes can be performed on price changes in multiple statuses with the following conditions:
If the Effective Date is in the past, no changes are allowed unless the status of the Price Change is Worksheet. If the status is Worksheet, you have the option to update the Effective Date.
If the date that the update is being performed falls within the Effective Date minus the Price Change Processing Days updates are only allowed for users with emergency security privileges.
Perform the following procedure to edit a price change:
Perform a search for the price change group that you want to edit. See Search for a Price Change Group.
From the search results pane of the Price Change Group Search tab, highlight the price change group you want to edit and select Edit from the Actions menu. The Price Change Group tab appears.
From the Price Change Group tab, you can select either items or locations to edit. (Locations shown are associated with the row in the items table which has focus.) Highlight the item(s) or location(s) you want to edit and select Edit from that tables' respective Action menu. The Edit Price Changes dialog appears.
Note: If a single location is selected for editing, the Clear Reasons and Clear Rounding Rules check boxes will not appear. |
From the Edit Price Changes dialog, use the following fields to edit the price change details:
Note: When multiple price changes are selected for editing, fields in the popup may show up as empty. This indicates that the value may vary across the selected price changes. Entering a value and updating will update all the rows, leaving the value empty will leave the values unchanged on the individual price changes. |
Table 6-7 Edit Price Changes Fields
Field | Description |
---|---|
Effective Date |
The date on which the price change is set to take effect. Users have the option to key in a date or select one using the calendar widget. |
Change Type |
The Change Type field provides the options that derive the new retail price. Users have the option to modify the Change Type value. Change Type options:
|
Change Value |
Users enter the Change Value based on the Change Type entered, including Change by Percent, Change by Amount, or Fixed Price. This field is required entry for every Change Type other than Reset POS Price. The field supports up to four decimal places for Change by Percent value. For Change by Amount and Fixed Price, decimal placement is based on the currency of the selected locations.
|
Per (Selling UOM) |
Users have the option to update this field if the Change Type is currently set to Fixed Price or the Change Type field is updated to Fixed Price. For all other change types this field is hidden. |
Reason |
The Reason value defines the reason the price change is being created. Users have the option to update this field or remove the value in this field. |
Rounding Rule |
The Rounding Rule field provides the ability to smooth retails for an item or location. Users have the option to update this field or remove the value in this field. |
Clear Reasons |
The Clear Reasons checkbox displays next to the Reasons field when multiple items or locations are selected for Edit. If a users chooses to remove a Reason code for the price change the Clear Reasons checkbox can be clicked. The value for Reasons will be removed from price changes selected to edit. |
Clear Rounding Rules |
The Clear Rounding Rules checkbox displays when multiple items or locations are selected for Edit. When the Clear Rounding Rules checkbox is clicked the value for the rounding rule is removed. |
Note: If you select multiple items or locations to edit, some fields on the screen will not show a value if there are multiple values for a particular field. For example, if you select two price changes to edit and the Value field in both price changes is 10.00 then the Value field will be populated with 10.00. However, if the price changes have different values (like 10.00 and 11.00,) then the value field in the dialog is blank. If you enter a value, both price changes are changed to the new value. If you do not enter a value, then the original values stay. |
Once updates are complete on the Edit Price Changes dialog, click OK. The Edit Price Changes dialog closes and you are returned to the Price Change Group tab.
Users will have options to perform Delete maintenance at Item level for one or many items or at the Item/Location level for one or more Locations tied to an item.
Item Level: Users highlight one or more rows on the Items table and click Delete on the Items table
Location Level: Users will highlight a single row on the Items table and then highlight one or many rows on the Locations table and click Delete on the Locations table
Perform a search for the price change group that you want to delete. See Search for a Price Change Group.
From the search results pane, select the Price Change Group from which you want to delete an item or location and select Edit from the Actions menu. The Price Change Group tab appears.
From the Price Change Group tab, you can select either items or locations to delete. Highlight the item or location you want to delete and select Delete from that tables' respective Action menu. The Delete Confirmation dialog appears.
From the Delete Confirmation dialog, click OK to confirm the deletion. You are returned to the Price Change Group tab.
Users have options to perform status maintenance at Item level for one or many items, at the Item/Location level for one or more Locations tied to an item or they have the option to update for all displayed records using the page level buttons.
Updating Group Level Price Change Status
Perform the following procedure to update the price change status:
Perform a search for the price change group that you want to update. See Search for a Price Change Group.
From the search results pane, select the Price Change Group for which you want to update status. and select Edit from the Actions menu. The Price Change Group tab appears.
From the Price Change Group tab, use the buttons at the bottom of the page to update the price change group status. Options are:
Submit All
Approve All
Worksheet All (Select from the More Actions button menu.)
Reject All (Select from the More Actions button menu.)
After selecting the status change, click Save to save the updated status and remain on the Price Change Group Maintenance tab. Click Save and Close to save the updated status and return to the Price Change Group Search tab.
Note: If a price change is selected for a status change and the new status is not valid, the status change is ignored and the price change will not be updated. |
Updating Item Level Price Change Status
Perform the following procedure to update the price change status:
Perform a search for the price change group that you want to update. See Search for a Price Change Group.
From the search results pane, select the Price Change Group for which you want to update status. and select Edit from the Actions menu. The Price Change Group tab appears.
From the Price Change tab, from the Items table, highlight the item or items for which you want to update status.
With the item highlighted, select the desired status update from the Actions menu.
After selecting the status change, click Save to save the updated status and remain on the Price Change Group Maintenance tab. Click Save and Close to save the updated status and return to the Price Change Group Search tab.
Note: If a price change is selected for a status change and the new status is not valid, the status change is ignored and the price change will not be updated. |
Updating Location Level Price Change Status
Perform the following procedure to update the price change status:
Perform a search for the price change group that you want to update. See Search for a Price Change Group.
From the search results pane, select the Price Change Group for which you want to update status. and select Edit from the Actions menu. The Price Change Group tab appears.
From the Price Change tab, from the Locations table, highlight the location or locations for which you want to update status.
With the location highlighted, select the desired status update from the Actions menu.
After selecting the status change, click Save to save the updated status and remain on the Price Change Group Maintenance tab. Click Save and Close to save the updated status and return to the Price Change Group Search tab.
Note: If a price change is selected for a status change and the new status is not valid, the status change is ignored and the price change will not be updated. |
There are three methods of uploading Price Changes into the Pricing system:
The Upload Price Changes window provides the ability to upload price changes via spreadsheet. In this process, the user uploads price change events using a spreadsheet (.ods file). The template for the spreadsheet should be configured using the Template Configuration screen in RMS. A standard template is available to the user for uploading price change events. The template that is explained in this document is the standard template that is available in Cloud Pricing.
Perform the following procedure to upload price changes via spreadsheet:
From the Tasks menu, select Upload Price Changes under Price Changes. The Upload Price Changes tab opens.
In the Template field, select Price Changes.
The Process Description field displays the default process name with the date and timestamp. You can edit the name of the upload process in this field.
In the Source field, click the Browse button to locate the spreadsheet file you want to upload and click Open.
Select one of the following options:
Click Upload to upload the file. If errors occur during the upload process, you will get a notification.
Click Revert to clear out the screen inputs.
Click Done to close the Upload Price Changes window.
For the batch upload, price change data is present in XML format with the data formatted similar to the standard price change upload template layout. A batch process is used for uploading the data into Cloud Pricing.
See the Oracle Retail Pricing Operations Guide for additional details.
This method is available to support the integration of price changes from other applications such as Oracle Retail Store Inventory Management (SIM). Similar to the bulk load, this method is used to trigger the creation, update, or deletion of a price change from an external source, such as a store or an optimization solution. If there are any validation errors, they are returned to the calling systems.
See the Oracle Retail Pricing Operations Guide for additional details.