+ Start a Discussion
jpbenjpben 

Sort Opportunity Product

Is there a way to automatically sort Opportunity Products?  By default, SFDC sorts Oppty product by name (alphabetically).  If i create a number field and populate each Pricebook Entry with the sort order number, can a trigger use that field to sort the Oppty products?   

If someone can share a code, i would greatly appreciate it.  This limitation is a pain in the butt. 
RamuRamu (Salesforce Developers) 
Hi, currently there is no standard feature that you can use to customize the sorting of products. The only way to do it is using visualforce page. The below discussion thread has some information on this

https://success.salesforce.com/answers?id=90630000000guwSAAQ

Below is the link to idea exchange post that you can vote to promote this idea

https://success.salesforce.com/ideaView?id=08730000000H2NfAAK
Dorothy Elaine Mangubat 8Dorothy Elaine Mangubat 8
Sorting by Product Name is now released by Salesforce (Winter '20) but users will have to move the products in to the order they want.

https://releasenotes.docs.salesforce.com/en-us/winter20/release-notes/rn_sales_features_core_products_sort.htm

It doesn't sort automatically in one click. Still not helpful when you have 30+ products to sort.
BoonPlusBoonPlus
The SortOrder field in the Opportunity Product and Quote Line Item objects is now updatable in Winter '20 release (API Version 47.0). I utilized this new updateable field access for the Quote Line Item Sorting in my apps, and the sorted Quote Line Items can now be populated onto a Quote PDF. Below is a video which shows how it works...

Sort Quote Line Items and Create PDF Made Easy in Salesforce

Sort Quote Line Items and Create PDF Made Easy in Salesforce