5 Upload/Download from Spreadsheet

Pricing supports downloading of clearance groups into a spreadsheet to allow you to perform mass maintenance on the data. This data can then be re-uploaded into Pricing to update the events. Additionally, the upload function provides the ability to create new events from a spreadsheet and have them added to an existing group or create a new group. This chapter summarizes the workflow for both download and upload of clearance groups.

Download Clearances

Perform the following procedure to download clearances to a spreadsheet:

  1. Perform a search for the clearance group(s) that you want to update. See Search for a Clearance Group for more information.

  2. From the search results pane, select the clearance groups you wish to download.

  3. Select the Download Selected option from the Action Menu.

  4. In the Download pop-up, select the template to use for downloading the clearance groups. This will automatically generate a process description for the download, which you can update if desired.

    Figure 5-1 Download Pop-Up

  5. Click OK.

  6. When prompted, choose to either open the .ods file that is generated or save the file and open it separately in the spreadsheet application of your choice.

Upload from a Spreadsheet

The Upload Clearances page provides the ability to upload clearances from a spreadsheet (.ods file) into Pricing.

All uploads are done using templates. You can use the default Clearance template or configure a template for use in your business such that certain fields are defaulted or hidden from users to streamline the uploading process. You can download a blank version of your template by selecting the Download Blank Template option under Data Loading in the task list. For more information on blank templates, see the Pricing Do the Basics User Guide.


See the Oracle Retail Merchandising Do the Basics User Guide for information about template configuration.

Perform the following procedure to upload clearances via spreadsheet:

  1. From the Tasks menu, select Upload Clearances under Clearances. The Upload Clearances page opens.

    Figure 5-2 Upload Clearances

    Upload Clearances window
  2. In the Template field, select the template you are using.

  3. The Process Description will default based on the template name and timestamp, but can be updated.

  4. In the Source field, click the Browse button to locate the spreadsheet file (.ods file) you want to upload and click Open.

  5. Select one of the following options:

    • Click Upload to upload the file.

    • Click Revert to clear out the screen inputs.

  6. Click Done to close the Upload Clearances window.


    If any errors occur during the upload, you will receive a notification. Similarly, if the upload involves any status changes or new events created in submitted or approved status, you may receive a notification if the uploaded event conflicts with another event. If there are no issues with the new event, you will not receive a notification. For more information on data loading statuses, see the View Data Loading Status section in the Pricing Do the Basics User Guide.

View Issues

If you receive a notification about an error that occurred in the uploading of a Clearance, you can click on the link in the notification, which will take you to the Data Loading Status page to see the details. Alternatively, this page can be accessed by navigating to the Data Loading -> Review Status option in the task list.

This task flow opens up the Data Loading status page, which lists the status of each upload/download request. Requests that were processed successfully will have their status set to Processed Successfully. Requests that were not processed successfully will have their status set to either Processed with Errors or Processed with Warnings. For such requests, you can access the View Issues page by clicking on the View Issues button to review details of the errors or warnings associated with a selected upload or download request.

Figure 5-3 Clearance Issues Page

The details provided include the worksheet in which the error is encountered, the row and column in the spreadsheet that is in error, and the error description. Errors will need to be fixed in order to successfully create or update a clearance.

Errors in download processing are typically due to the inability to access the data or insufficient privileges to create and write to the specified location. These errors can be resolved by removing any constraints that might have placed a lock on the data or ensuring that any constraints on creation of the spreadsheet are relaxed.

Errors in upload request processing are typically data-related and likely require data correction. You can use the error details in the View Issues screen as a guide to make corrections to the originally uploaded spreadsheet. Once the errors have been corrected, the data can be re-uploaded into Pricing as needed, using the corrected file.