+ Start a Discussion
aaustinaaustin 

Excel connector query of Pricebook2 table will not return Standard Price Book info

I'm trying to use the excel connector to mass insert my standard prices into salesforce's Standard Price Book, so that I can use them in my custom Price Books i will populate later, but the query on Pricebook2 table will not return info (what I really need is the ID number) for the Standard Price Book.  I tried to make my own "Standard Price Book" and set the Is Standard Price Book field to TRUE, but it will not let me set this field (it looks like it is read-only).  What gives?
aaustinaaustin
I figured it out, I had to go to the "Manage Price Book" link at the Bottom of the Products page and "Activate" the Standard Price Book.