Update Product prices

Resolution:  

To update prices, you need the PriceBookEntry Salesforce ID. The only way you can get that is by exporting the ID using Data Loader or another 3rd party tool such as Workbench or DataLoader.io.  The following walkthrough shows you how to obtain the Salesforce ID and update the product prices.

Step 1:  Export Price Book Entries 

1. Launch Data Loader.
2. Click the Export button.
3. Select OAuth or Password Authentication as your login method.
4. Log in.
5. Click the Next button.
6. Select the check box that reads Show all Salesforce objects.
7. Scroll down to select the Price Book Entry object.
8. Click the Browse button and enter a file name (suggestion would be pricebookentry.csv) and select a location for the file (suggestion would be desktop). Files should end with ".csv."
9. Click the Next button.
10. Click the Select All button.

Note:
This tutorial will download all Price Book Entries. If you would like to filter the Price Book Entries based on specific products, you can use a selective query in the query editor box by adding the WHERE condition expression and then the product id values that we want to filter on. In the example below, we want to only export Price Book Entries for Products that have the ID 01t1I000000CqeK or 01t1I000000CqeL. You can find the Product ID by viewing the desired product in Salesforce and then copying the value from the URL located in the browser's address bar. Example URL: https://na73.salesforce.com/01t1I000000CqeL, the product ID is listed after the .com/

Example SOQL query :
Select Id, Name, Pricebook2Id, Product2Id, UnitPrice, IsActive, UseStandardPrice, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById,  SystemModstamp, ProductCode, IsDeleted FROM PricebookEntry WHERE Product2Id='01t1I000000CqeK' OR Product2Id='01t1I000000CqeL'

11. Click Finish.
12. Click OK.

If suggestions have been followed there will be a file called pricebookentry.csv on your desktop.

Step 2: Update the prices in the Price Book Entry CSV Files

1. Open the CSV file.
2. Update the Unit Price field for each Price Book Entry.
3. Save the CSV file.

Step 3: Import the CSV file as an update 

1. Launch Data Loader .
2. Click the Update button.
3. Select OAuth or Password Authentication as your login method.
4. Log in.
5. Click the Next button.
6. Select the check box that reads Show all Salesforce objects.
7. Scroll down to select the Price Book Entry object.
8. Click the Browse button.
9. Select the CSV file just saved.
10. Click the Next button.
11. A dialog box will pop up confirming the number of records that are to be imported. Click the OK button.
12. Click the Create or Edit a Map button.
13. Click the Auto-Match Fields to Columns button.
14. Click the OK button.
15. Click the Next button.
16. Click the Finish button.

Prices should now be updated.