AddOpportunityProduct
Creates a new Opportunity Product
Stored Procedures Specific Information
Process of adding opportunity product
Act! CRM allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available columns for AddOpportunityProduct are OpportunityId, ProductName, ProductCost, ProductDiscount, ProductDiscountPrice, ProductItemNumber, ProductPrice, ProductQuantity and ProductTotal. For example:
EXECUTE AddOpportunityProduct OpportunityId = '123456', ProductName = 'Sample Opportunity Product'
Input
| Name | Type | Description |
| OpportunityId | String | The unique identifier (id) for a given opportunity. |
| ProductName | String | The name of the product |
| ProductCost | String | The cost of the product |
| ProductDiscount | String | The discount value |
| ProductDiscountPrice | String | The discount price value |
| ProductItemNumber | String | The item number of the product |
| ProductPrice | String | The price of the product |
| ProductQuantity | String | The product quantity |
| ProductTotal | String | The product total |
Result Set Columns
| Name | Type | Description |
| Status | String | Stored Procedure Execution Status |