How do I insert products into SF.com with the Excel Connector? [ Edited ]

[AMartin]

Hi Christine,

To add products to the Standard Price Book, you have to add entries to the 'PricebookEntry' table.

The table contains three id fields:
Price Book Entry ID
Price Book ID
Product ID

The Pricebook ID is of the Standard Price Book which you can get from querying the Pricebook2 table.
The Product ID is of the Product you want to add and you can get that from the Product2 table.
The Pricebook Entry ID value is 'new'.

Fill out the rest of the table as needed (List Price, Active, Use Standard Price, Currency). If you need a product with 2 currencies, add the product again to the PriceBook Entry book and just change the currency field.

My email address is aiden . martin @ aliant . ca if you want to continue this off the forum.

Aiden

Message Edited by AMartin on 04-26-2005 09:51 PM

Message Edited by AMartin on 10-28-2007 01:03 AM

[chill]

Hi Aiden,

I got everything loaded properly!! Thank you for all your help!

Christine