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
orzikorzik 

Sforce Connector - Opportunities with Product

Does anyone know how to access products attached to opportunities via SForce Connector?
The idea is to update Sales Prices and Quantities via the tool... Sounds easy but not sure where is the table...
Any help appreciated,

greg
ScotScot

The sale prices and quantities are located in the OpportunityLineItem object.

Logically you've got:

       Opportunity ->> OpportunityLineItem ->> OpportunityLineItemSchedule

Two tricky issues to watch out for:
  • You can update either Sales Price or Total Price ... but not both at the same time
  • Assuming that you're working with pricebooks, ignore the Product ID field. This is an old one, left for compatibility, that refers to the earlier Product table, not the new Product2 table.

    If you do want to work with the products, you need to follow the "PriceBookEntryID" field to the pricebook entry, and then get the product from there.