function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RhondaBRhondaB 

Maintaining Products in DB or Spreadsheet (Please Help)

Is it possible to generate the list of products from a database or a spreadsheet. We have very large pricelists for multiple products in multiple currencies and it would be nice to be able to maintain those lists in a db or spreadsheet and have salesforce read them from there.

If it is possible, can someone provide some instructions for implementing?

Thanks,

Rhonda
adamgadamg
Hmm - have you tried using the Excel connector?
RhondaBRhondaB
No but that sound promising. Where would I find that?

Thanks,

Rhonda
RhondaBRhondaB
I found the Excel Connector and it seems to work well with one exception. I am trying to import Products that should display in different Pricebooks with different currencies and having some trouble with those.

can anyone help me?

Thanks.
RhondaBRhondaB

RhondaB wrote:
I found the Excel Connector and it seems to work well with one exception. I am trying to import Products that should display in different Pricebooks with different currencies and having some trouble with those.

can anyone help me?

Thanks.




There error I get is Insert Row failed: Pricebookid: id value of incorrect type

thanks.

Rhonda
ScotScot
A few thoughts ...
     The price book id should start with "01s" ... if the value you're using doesn't, that's probably the problem.
     Is your problem with loading the pricebookentry?
 
If you haven't already found them, there are some discussions about this process in both the customer success forum and here.  Some of these can be found at:

Scot
RhondaBRhondaB
Thanks. Through perserverance I was able to get this all working great.

Rhonda