1. Set your grid to view 1000 items per page (which is the maximum)

2. Use the filters to show the information you want (example: selecting Home Depot will show only Home Depot Items) - Video on using Filters https://www.youtube.com/watch?v=7rgvIKCc9KA
3. Use Multi Item Actions to Select All Items on Page - Video on Select All using Multi Item Actions - https://www.youtube.com/watch?v=k3wm33E8e4Q
4. Use Multi Item Actions Add Formula for Selected Items - Video on Adding Formula using Multi Item Actions - https://www.youtube.com/watch?v=Bih3tnTpc8o
5. Force Reprice the Selected Items using Multi Item Actions - Video on Multi Item Actions Force Reprice Selected - https://www.youtube.com/watch?v=-0Jj8k4a3IE
6. If you have more than 1000 items that matched the filter, click on page 2 and repeat the process .... repeat for each page of 1000 items.