Option #1 - Microsoft Access will do this properly if you have access to the database itself. Unless you want to write a sql statement from the ground up. I would suggest you modify the product table and add an extra field for the price back-up just in case something goes wrong, you can always restore from this field.

Option #2 - Microsoft Excel spreadsheet, (and you don't have access to the database itself) export your item with you're chosen category into a spreadsheet. Make a copy of the sheet itself, so now you have two copies of the same information. One will be your back-up just in case you need to roll back, rename the tabs, so they make sense to you. You can modify the pricing on the spreadsheet and reimport back into the system.

-Ray

Edited by user Monday, November 7, 2022 6:56:16 PM(UTC)  | Reason: Not specified