This article is for a situation where you have entered a price change in NPC Publisher with a future start date and need to change the price value. This only works if the price change date is in the future.
Note: once a price has Release to Pool = RESPONSE, you cannot delete (purge) the price; you can only correct as per the steps below.
1. Open up NPC Publisher and go to your 'Item' List.
2. If you have the list of your GTINs, copy and paste your list into the 'Text Search' and hit 'Search'. You can search for up to 1000 at once.
3. Select the tick box at the top of the list to select all your items. Select the 'Download as' button and then 'Excel'.
4. Ensure that you have ticked the box 'Include Prices' and that you are downloading the 'Released Prices'. Then select 'Start Download'.
5. Remove all sheets excluding the 'Price' sheet by selecting the other tabs, right clicking, and pressing 'Delete'.
6. In the 'Price' sheet you should find two pricing records against each GTIN - the old price that is being end dated, and the new price that is being corrected. It should appear as below. Note that other columns have been hidden in the screenshot, you can do this also using the 'Hide Column' function. The highlighted fields are those that require editing.
7. In order to make a correction to the future price:
- Update the 'Price Action Code' for the future prices from 'ADD' to 'CHANGE'.
- Update the 'Price Value' for the future price
In the below example the price value has changed from $66 to a $64
8. Once completed, save your document. To upload your changes, return to the NPC and press the 'Upload button', choose your file and 'Start Upload'. It will indicate that the file has been processed when complete.
9. To complete the job you will need to 'Release' your prices. To do this, navigate to the 'Prices' tab and 'Release' the prices you have just updated which are in a 'WORKING' state.
You have now completed the process!
Created: 12 May 2025