Oracle® Retail Pricing Cloud Service Oracle Retail Pricing Cloud Service User Guide 16.0.029 E99964-01 |
|
Previous |
Next |
A clearance is designed to move out-of-date merchandise and slow-selling merchandise out of a store. A clearance markdown is considered a permanent price change, and inventory is consequently revalued. Once the reset date for a clearance has passed, the item's price and inventory value is returned to the regular price. The following clearances can be created:
Markdown - The clearance is occurring at the retailer's initiative.
Reset - The Clearance Reset will close out the clearance event, setting the item(s) back to the last regular retail price.
When a clearance 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 clearance to the next status. A clearance may be in any of the following statuses:
Table 7-1 Clearance Status
Status | Definition |
---|---|
Worksheet |
The clearance has been started, but not reviewed or sent out. |
Submitted |
The clearance has been completed and is pending review. Conflict checking may have occurred (if the run for submit system option was set) for the price change. |
Approved |
The clearance has been reviewed and accepted. The clearance is communicated to the locations for which the clearance is effective. |
Executed |
The clearance prices established are effective for the item/location. |
Rejected |
The clearance has been reviewed and declined. |
Processing |
The clearance is being processed in conflict checking. |
After you create a clearance, you can maintain different aspects of the clearance.
Perform the following procedure to create a clearance.
From the Pricing tab Tasks list, click the Quick Create icon.
The Quick Create pane appears.
From the Quick Create pane, select Clearance 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 7-2 Clearance 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 Clearance Group or part of an Existing Clearance Group. |
Clearance Group |
The Group field is a radio button which allows users to select if they are creating a clearance under an existing clearance group or a new clearance 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 to create a new clearance group. This description may then be used to search for a clearance or group of clearance 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 Clearance Group ID is entered instead of the description. |
Markdown |
The Markdown field contains the markdown for the new clearance that the user wants to create. This field can be left blank. |
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. |
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 a zone within a single zone group. The user may enter a single zone or multiple zones. 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. Note: Either a Zone(s) or Location(s) must be entered, but not both. |
Effective Date |
The Effective Date is the date when the clearance 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. There is a system option default that may display for the Change Type if it exists. The default value can be overridden. Change Type 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 clearance record. Users are allowed to enter a single Rounding Rule. A rounding rule helps users create a uniform pricing strategy. |
Reason |
The Reason field defines the reason the clearance is being created. This field is optional. |
Once you have entered all information for the newly created price change record, click Apply, Submit, or Approve. The new clearance is created.
The Clearance Group screen allows you to maintain markdowns within a clearance group. Each markdown will contain items selected for the markdown along with the locations where the markdown should be executed.
The Clearance Group screen has three modes; Add, Edit and View. If the user enters this screen in View mode, all maintenance options are disabled and the Save, Save and Close, and Cancel buttons are replaced with Done. If the user enters in Edit mode the following maintenance options are supported:
Perform the following procedure to search for an existing clearance group.
From the Tasks menu, select Manage Clearance Groups under Clearances. The Clearance Group Search tab appears.
Enter your clearance search criteria using the following fields:
Note: In order to conduct a clearance search, users must enter at least one of the following; Department, Clearance Group, Description, or Item. |
Table 7-3 Clearance Search Fields
Field | Description |
---|---|
Clearance Group |
The Clearance 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, Executed, and Processing. |
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 clearance markdowns can be added to a new clearance group or an existing clearance group. Creating a new clearance group can be done by selecting the Create Clearance Group task from the Task List, or selecting the 'Create' action from the Clearance Group Search screen. Either of these steps create a new Clearance Group into which markdown can be added by following the steps below (starting with step 3). Adding a markdown is performed using the Markdown Wizard. There are four potential stops within the wizard:
To add markdowns to an existing Clearance group, perform a search for the clearance group that you want to edit. See Search for a Clearance Group.
From the search results pane of the Clearance Group Search tab, highlight the clearance group to which you want to add a clearance markdown and select Edit from the Actions menu. The Clearance Group tab appears.
From the Item Markdowns table, select Add from the Actions menu. The Add Markdown Wizard launches. Continue with the Items Page.
Items Page
The initial page in the Markdown Wizard allows you to select the items that you want to add to the markdown.
From the Add Markdown Items page, enter the items to add to the new markdown using the following criteria:
Table 7-4 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 markdown. 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 markdown. |
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 markdown. |
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 markdown, click Next. The Add Markdown Locations page appears. Continue with Locations Page.
Locations Page
The Locations page of the Markdown Wizard allows you to define the locations associated with the markdown.
From the Add Markdown Location page, select the location type you want to use for adding locations using the following criteria:
Table 7-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 markdown. 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 create events for the entire zone and markdowns can be created for all locations under the zone after exploding the zone. |
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 markdown. |
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 markdown. |
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 markdown. |
From the search results pane, select the location(s) to add to the markdown and click Apply.
Once all your locations are added to the markdown, click Next. The Add Markdown page appears. Continue with Markdown Page.
Markdown Page
The Markdown page of the Markdown Wizard allows you to define the markdown itself.
From the Markdown page, define the information for the markdown(s) being added using the following criteria:
Table 7-6 Markdown Page Fields
Field | Description |
---|---|
Markdown |
The Markdown field contains a predefined identifier for the Markdown. This field can be left blank.
|
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 Percent Off value. For Amount Off and Fixed Price decimal placement is based on currency of selected locations. |
Effective Date |
The date on which the markdown is set to take effect. Users have the option to key in a date or select one using the calendar widget. |
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. |
Reason |
The Reason value defines the reason the markdown is being created. Users have the option to update this field or remove the value in this field. |
Once all your markdown information is entered, click Next. The Add Markdown 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 markdown before it is added to the Clearance Group.
Confirm the markdown settings and double click on Finish or select Submit or Approve from the Finish drop down menu. You are returned to the Clearance Group screen. Your new markdown is listed in the Item Markdowns table.
Note: The Summary Page allows individual markdowns to be removed before they are added to the Clearance Group. |
Editing clearances can be performed on clearances in multiple statuses with the following conditions:
If the Effective Date is in the past, no changes are allowed unless the status of the Clearance is Worksheet, then users 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 Event Processing Days, updates are only allowed for users with emergency security privileges.
Perform the following procedure to edit a markdown:
Perform a search for the clearance group that you want to edit. See Search for a Clearance Group.
From the search results pane of the Clearance Group Search tab, highlight the clearance group you want to edit and select Edit from the Actions menu. The Clearance Group tab appears.
From the Clearance Group tab, you can select either item markdowns or locations to edit. Highlight the item markdown(s) or location(s) you want to edit (locations shown are associated with the row in the item markdown table which has focus) and select Edit from that tables' respective Action menu. The Edit Clearances dialog appears.
Note: If a single location is selected for editing, the Clear Markdown, Clear Reason Codes, and Clear Rounding Rule check boxes will not appear. |
From the Edit Clearances dialog, use the following fields to edit the clearance details:
Note: When multiple clearances are selected for editing, fields in the popup may show up as empty. This indicates that the value may vary across the selected clearances. Entering a value and updating will update all the rows, leaving the value empty will leave the values unchanged on the individual clearances. |
Table 7-7 Edit Clearances Fields
Field | Description |
---|---|
Markdown |
The Markdown field contains the markdown identifier for the markdown that the user wants to edit. This field can be left blank. |
Effective Date |
The date on which the clearance 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 Change Type value. Change Type options:
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 Percent Off value. For Amount Off and Fixed Price decimal placement is based on currency of selected locations. |
Reason |
The Reason value defines the reason the clearance 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 user chooses to remove a Reason code for the Clearances the Clear Reasons checkbox can be clicked. The value for Reasons will be removed from Clearances 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. |
Clear Markdown |
The Clear Markdown checkbox displays when multiple items or locations are selected for Edit. When the Clear Markdown checkbox is clicked the value for the Markdown field is removed. |
Note: If you select multiple clearances 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 clearances to edit and the Value field in both clearances is 10.00 then the Value field will be populated with 10.00. However, if the clearances have different values (like 10.00 and 11.00,) then the value field in the dialog is blank. If you enter a value, both clearances 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 Clearances dialog, click OK. The Edit Clearances dialog closes and you are returned to the Clearance Group tab.
Users will have options to perform Delete maintenance at Item markdown level for one or many item markdowns or at the Item markdown/location level for one or more locations tied to an item markdown.
Item Markdown Level: Users highlight one or more rows on the Item Markdowns table and click Delete on the Item Markdowns table
Location Level: Users will highlight a single row on the Item Markdowns table and then highlight one or many rows on the Locations table and click Delete on the Locations table
Perform a search for the clearance group that you want to delete. See Search for a Clearance Group.
From the search results pane, select the Clearance Group from which you want to delete an item markdown or location and select Edit from the Actions menu. The Clearance tab appears.
From the Clearance 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 Clearance Group tab.
Users will have options to perform Status maintenance at Item markdown level for one or many item markdowns, at the Item markdown/Location level for one or more Locations tied to an item markdown or they have the option to update for all displayed records using the page level buttons.
Updating Clearance Status from Group Level
Perform the following procedure to update the clearance status for all item markdowns in the clearance group:
Perform a search for the clearance group that you want to update. See Search for a Clearance Group.
From the search results pane, select the clearance group for which you want to update status. and select Edit from the Actions menu. The Clearance Group tab appears.
From the Clearance 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 Clearance Group tab. Click Save and Close to save the updated status and return to the Clearance Group Search tab.
Note: If a clearance is selected for a status change and the new status is not valid, the clearance will be ignored and will not be updated. |
Updating Clearance Status from Item Markdown Level
Perform the following procedure to update the clearance status on item markdowns for all the locations:
Perform a search for the clearance group that you want to update. See Search for a Clearance Group.
From the search results pane, select the clearance group for which you want to update status. and select Edit from the Actions menu. The Clearance Group tab appears.
From the Clearance Group tab, from the Item Markdowns table, highlight the item markdown(s) for which you want to update status.
With the item markdown(s) 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 Clearance Group tab. Click Save and Close to save the updated status and return to the Clearance Group Search tab.
Note: If a clearance is selected for a status change and the new status is not valid, the clearance will be ignored and will not be updated. |
Updating Clearance Status from Location Level
Perform the following procedure to update the clearance status on item markdowns at the location level:
Perform a search for the clearance group that you want to update. See Search for a Clearance Group.
From the search results pane, select the clearance group for which you want to update status. and select Edit from the Actions menu. The Clearance Group tab appears.
From the Clearance Group tab, from the Items Markdown table, highlight the item markdown for which you want to update status.
From the Clearance Group tab, from the Locations table, highlight the location(s) 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 tab. Click Save and Close to save the updated status and return to the Clearance Group Search tab.
Note: If a clearance is selected for a status change and the new status is not valid, the clearance will be ignored and will not be updated. |
Additional markdowns for items already on markdown can be added to a clearance group through the Clearance Group tab.
Perform the following procedure to add a Markdown:
Perform a search for the clearance group that you want to update. See Search for a Clearance Group.
From the search results pane, select the clearance group for which you want to add a markdown. and select Edit from the Actions menu. The Clearance Group tab appears.
From the Clearance Group tab, highlight the item markdown in the Item Markdowns table to which you want to add an additional markdown and select Add Next Markdown from the Action menu. The Add Next Markdown dialog appears.
Table 7-8 Add Markdown Fields
Field | Description |
---|---|
Markdown |
The Markdown field contains the markdown identifier for the markdown that the user wants to edit. This field can be left blank. |
Effective Date |
The date on which the clearance 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. Value options:
Users will enter the Change Value based on the Change Type entered, including Percent Off, Amount Off, or Fixed Price. This field is required entry for every Change Type. The field supports up to four decimal places for Percent Off value. For Amount Off and Fixed Price decimal placement is based on currency of selected locations. |
Reason |
The Reason value defines the reason the clearance is being created. This field is optional. |
Rounding Rule |
The Rounding Rule field provides the ability to smooth retails for an item or location. This field is optional. |
Once updates are complete on the Add Next Markdown dialog, click Apply, Submit, or Approve. The Add Next Markdown dialog closes and you are returned to the Clearance Group tab.
A clearance reset ends the clearance for a set of items at a set of locations which are presently on clearance. A clearance with a change type of Reset (also known as a clearance reset or a reset) ends the clearance on the user defined effective date. The clearance reset is displayed in the Item Markdowns and Locations tables like any other clearance records.
Perform the following procedure to add a Clearance Reset:
Perform a search for the clearance group that you want to update. See Search for a Clearance Group.
From the search results pane, select the clearance group for which you want to add a clearance reset. and select Edit from the Actions menu. The Clearance Group tab appears.
From the Clearance Group tab, highlight the item markdown or location to which you want to add a clearance reset and select Add Reset from the Action menu. The Add Reset dialog appears.
Table 7-9 Add Reset Fields
Field | Description |
---|---|
Effective Date |
The date on which the clearance reset is set to take effect. Users have the option to key in a date or select one using the calendar widget. |
Reason |
The Reason value defines the reason the clearance reset is being created. This field is optional. |
Markdown |
The Markdown field defines the markdown number for the reset. This field is defaulted as NULL, but the user can provide a markdown number if desired. |
Once updates are complete on the Add Reset dialog, click OK. The Add Reset dialog closes and you are returned to the Clearance Group tab.
There are three methods of uploading Clearances into the Pricing system:
The Upload Clearances window provides the ability to upload Clearances via induction. In this process, the user uploads clearance 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 clearance 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 clearances via spreadsheet:
From the Tasks menu, select Upload Clearances under Clearances. The Upload Clearances tab opens.
In the Template field, select Clearance.
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 Clearances window.
For the batch upload, clearance data is present in XML format with the data formatted similar to the standard clearance 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 clearance 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 clearance 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.