QP Modifier Copy Upload copies Oracle Advanced Pricing modifier lists from Excel, one row per modifier list, as the Copy Modifier List window (Modifiers > Copy) does. A row copies a modifier list with its qualifiers and lines to a new modifier list and can end-date the source list, so preparing next year’s discounts, promotions, surcharges and freight charges across many modifier lists becomes one upload.
When to use it
- Prepare next year’s modifier lists: copy each list to a new list that starts on a later date.
- End-date the old modifier lists the day before the new ones start.
- Copy a modifier list to another operating unit, or to a global list.
- End-date modifier lists without copying them.
Before you start
- Access to Blitz Report from a responsibility with the Copy window of Modifiers in Advanced Pricing.
- The numbers of the new modifier lists must not exist yet in the version of the source list.
- A modifier list can be end-dated when your pricing security allows you to update it.
Choose a template
The default template is Default.
| Template | Use it for |
|---|---|
| Default | Copy modifier lists and end-date the source modifier lists. |
| End Date Only | End-date modifier lists without copying them. It downloads the selected modifier lists and shows only their own columns. |
Step 1 – Set the parameters
Open QP Modifier Copy Upload in Blitz Report, choose the template and set the parameters. The modifier lists offered are the discount lists, deals, freight and special charge lists, promotions and surcharge lists you can view.
| Parameter | Meaning |
|---|---|
| Upload Mode | Create (the default) opens an empty sheet to paste modifier lists into. Create, Update downloads the modifier lists selected by the other parameters. |
| List Type | One or more list types. The list number parameters then offer only modifier lists of these types. |
| List Number | One or more modifier list numbers. Tick Multiple Values to enter several, separated by semicolons. |
| List Number Like | A number pattern, for example SUMMER%. |
| List Number From / List Number To | The modifier lists whose numbers are from List Number From to List Number To, compared as text. |
| Effective Date | The modifier lists effective on this date. |
In the example, Upload Mode is Create, Update, List Type is Discount List and the list numbers are Gold List #1 and Silver List #1.
Step 2 – Run to download the Excel file
Click Run. The Excel file opens with one row per modifier list and the Blitz Report tab. List Type, List Version, List Name, List Currency and the effective dates show the modifier list; New Global List and New Operating Unit default from it. List Number is required (yellow), and the columns describing the modifier list are read-only (grey), except List Effective To.
Step 3 – Enter the changes
Fill in what each modifier list should get. The add-in marks each changed row Update and each new row Create.
- Copy: enter a New Modifier Number and a New Modifier Name to copy the row’s modifier list with its qualifiers and its lines that have not ended. The copy keeps the list type and version of its source. New Effective From and New Effective To set the new list’s dates, and New Global List or New Operating Unit its scope. Retain Effective Dates keeps the effective dates of the copied lines.
- End-date: enter List Effective To to end-date the source modifier list, for example the day before the new list starts. This works for a modifier list without an end date.
- Versions: a list number can exist in several versions. List Version then selects the modifier list, and a row without it is rejected.
- New rows: type or paste a list number in List Number on an empty row; the other source columns fill in from it, List Version when the number has a single version.
In the example, Gold List #1 and Silver List #1 are copied to Gold List 2027 and Silver List 2027, starting 1-Jan-2027, and both source lists end on 31-Dec-2026.
Step 4 – Validate and Save
Click Validate and Save on the Blitz Report tab. It checks for missing required values and values that are not in their lists, marks the rows Valid and saves the file. Correct any rows it flags before uploading.
Step 5 – Upload
Click Upload on the Blitz Report tab. The add-in sends the valid rows to Oracle and submits the upload request, and a progress window shows it running. Each row first copies the modifier list, then end-dates the source modifier list.
Step 6 – Review the result
When the request completes, the add-in writes the result to the sheet: every row with its status and a message saying what was done, for example Modifier list Gold List 2027 created. List Effective To updated.
What’s produced
- New modifier lists with the number, name, dates and scope you entered, the type, version and qualifiers of the source list, and its lines that have not ended, with their pricing attributes.
- Source modifier lists end-dated on the List Effective To you entered.
- The result in the Excel file: every row with a status (success or error) and a message.
Common questions
Which modifier lists can be copied?
Discount lists, deals, freight and special charge lists, promotions and surcharge lists. A copy keeps the list type of its source.
Are the qualifiers copied?
Yes. The qualifiers of the list and of its lines are copied as they are.
Can I change or remove the end date of a modifier list?
No. List Effective To only end-dates a modifier list that has no end date. A blank List Effective To leaves the modifier list unchanged, so rows pasted without it never reactivate a list. Change an existing end date in the Modifier Setup window.
What if a row fails after the modifier list was copied?
The copy is saved as soon as it runs. If end-dating the source fails afterwards, the new modifier list stays and the message says so: end-date the source in a separate row instead of uploading the row again.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Please enter the Name of the modifier list to copy from. | No modifier list of the copied list types has this List Number, or none with the List Version entered. | Correct List Number or List Version. |
| Modifier list … exists in several versions. Enter the List Version to copy or end-date. | The list number exists in more than one version and List Version is blank. | Enter the List Version. |
| Please enter the name of a new Modifier list to copy to. | New Modifier Name, the new dates or Retain Effective Dates are entered without a New Modifier Number. | Enter the New Modifier Number, or clear the copy columns. |
| Missing values for required field/s: New Modifier Name | A New Modifier Number is entered without a name. | Enter the New Modifier Name. |
| You cannot copy to a Modifier list that already exists. … | A modifier list with the New Modifier Number exists in the version of the source list. | Enter a unique number. |
| Missing values for required field/s: New Operating Unit | New Global List is blank and no New Operating Unit is entered. | Set New Global List to Yes, or enter the operating unit. |
| Start Date must start before End Date. | New Effective From is after New Effective To, or List Effective To is before the start date of the source modifier list. | Correct the dates. |
| The source modifier list already ends on …, so its List Effective To cannot be changed. | The source modifier list already has an end date. | Clear List Effective To or leave the downloaded date, and change the end date in the Modifier Setup window. |
| You do not have privileges to update this Modifier List. | Your pricing security does not allow you to update the source modifier list. | Ask for update access to the list, or leave List Effective To blank. |





