Print this page

How can I modify existing Price Book data through the Data Loader?

Knowledge Article Number 000025265
Description How can I modify existing Price Book data through the Data Loader?
Resolution Please note that this solution is applicable if:

-You have already loaded Products into the "Products2" Table (via another solution) and
simply need to change which Price Books in which they appear in.
-You have products in one Price Book and now want them in other Price Books.
-You have products in listed in one currency in one Price Book and now want to add these
products in other currencies to one or many Price Books.

Please see the attached PDF file (formatted - easy to read version of solution)


Step 1  EXPORT the "Price Book Entry" Table
To give us a file to work with your existing data you will need to export this table.

1. Open the Data Loader
2. Export the "Price Book Entry" table
3. Include all fields except: Id, Created Date, Created By ID, Last Modified Date, Last Modified By, System Mod Stamp, Product Code or Product Name.

NOTE: These fields are not map-able in the next steps.

NOTE: You will not need "Id" because you will be inserting new entries in the Price Book Entry table.

NOTE: You can export Name, to help you work with the file preparation but this field will not be map-able in the Price Book Entry table.

Step 2 PREPARE file for Standard Price Book

Take the file from Step 1 and modify it to reflect changes to the Standard Price Book.
(See attached sample file:Price Book Entry_Template _Step2.xls)

NOTE: Any new entries made in a custom Price Book will first need to be made in the Standard Price Book, so this step needs to be followed.

1. Identify existing data in the Standard Price Book
-Open and Sort the Price Book Entry export file (from Step 1) by the Price Book2ID column.

NOTE: To find what Pricebook2ID relates to which Price Book Name quickly export the Pricebook2 table via the AppExchange Data Loader. This will show you the names and ids together.

-Identify Standard Price Book data
-Delete non Standard Price Book data
-Save As to keep both files

2. Modify other columns to contain desired changes to the Standard Price Book:
-PriceBook2ID: Standard Price Book ID
-Product2ID: do not modify
-CurrencyIsoCode: modify if necessary
-Unit Price: modify if necessary (this is the List Price/Standard Price field for the product)
-UseStandardPrice: this indicates whether to use the price from Standard Price Book or not.
---FALSE (only option for Standard Price Book)
---TRUE (is not an option because Use Standard Price field is not available in the Standard Price Book)
-IsActive: TRUE (must be TRUE to insert this can be changed to FALSE after Step 5 is complete)


Step 3 - INSERT into Price Book Entry Table
To add new entries into the Standard Price Book

1. Open the Data Loader
2. Insert to Price Book Entry table
3. Save success and error files in a folder for this project


Step 4  PREPARE file for custom Price Book
Take the file from Step 1 and modify it to reflect the changes to the custom Price Book.

1. Identify existing data in the Standard Price Book
-Open and Sort the original Price Book Entry export file (from Step 1) by the Price Book2ID column.

NOTE: To find what Pricebook2ID relates to which Price Book Name quickly export the Pricebook2 table through the AppExchange Data Loader. This will show you the names and ids together.

-Identify custom Price Book data
-Delete all other Price Book data
-Save As to keep both files

2. Modify the file to contain desired changes to the custom Price Book:
-PriceBook2ID: custom Price Book ID
-Product2ID: do not modify
-CurrencyIsoCode: modify if necessary
-Unit Price: modify if necessary (this is the List Price/Standard Price field for the product)
-UseStandardPrice: this indicates whether to use the price from Standard Price Book or not.
---FALSE (this choice means you will use the Unit Price from the custom Price Book and NOT the Unit Price from the Standard Price Book)
---TRUE (this option only works if this Product has been added to the Standard Price Book. This choice will use the Unit Price from the Standard Price Book)
-IsActive: TRUE


Step 5 - INSERT into Price Book Entry Table
To add new entries into the custom Price Book
MAKE SURE your Custom Price Books are Active in SFDC.

1. Open the AppExchange Data Loader
2. Insert to Price Book Entry table
3. Save success and error files in a folder for this project

Step 6 (optional)
If you only want the Products that are not in the Standard Price Book available for selection as a line item, you must deactivate the Price Book Entry where the Pricebook2ID is the Standard Price Book.

INACTIVATE Standard Products in Standard Price Book

1. Take the original file from Standard Price Book Entry insert in Step 3b
2. Change the values in IsActive from TRUE to FALSE
3. Map only the PriceBooks2ID and IsActive fields
4. UPDATE Price Book Entry Table




Attachments
Name Type Size
How.pdf
146KB
Solution5654-.xls
23KB

promote demote