Apttus CPQ has been enhanced to create and configure an unlimited number of attributes, overcoming the 800 record limit of Salesforce. You can create custom Product Attribute Value extension objects that are a replica of the Product Attribute Value object. All of these attributes created under the extension object can be used as normal attributes for your products.  These objects are an extension to the Product Attribute Value object through a combination of master-detail and look-up relationships. 

The fields from the extension objects are displayed in the Product Console to be associated as attributes with the products.

  • This enhancement is available in the CPQ Admin UI only.
  • The attributes added in the Product Attribute Value Extension object are not available for Price Dimensions (Pricing engine). Only the first 800 attributes will be visible for the pricing.

Follow the steps below.

To create a custom extension object

  1. Navigate to Setup > App Setup > Create > Objects and click New Custom Object to create a new extension object.
  2. Enter the desired label, such as Product Attribute Value Ext 1 to indicate that this object is an extension to Product Attribute Value object.

  3. Fill in the requisite details and click Save.
  4. Navigate to the Custom Fields & Relationships section and click New to create a new custom relationship.
  5. Choose Master-Detail Relationship as the Field Type and click Next.
  6. From the Related To drop-down list, choose Product Attribute Value and click Next.
  7. In the Field Label, type ProductAttributeValueId and click Next.
  8. Choose necessary Field level security for the reference field and click Next.
  9. Choose the page layouts where you want to reference this field and click Next.
  10. Verify the Related List label for your field and click Save.

    Ensure that the API name for the newly created custom relationship is ProductAttributeValueId__c, as shown in the figure below.


After you have created the extension object, follow the same steps mentioned here to create the attributes for this object in the form of custom fields.

To create a lookup relationship with the Product Attribute Value extension object

For each extension object, a lookup relationship must be created so that the objects are connected.

  1. Navigate to Setup > App Setup > Create > Objects and search for Product Attribute Value object.
  2. Under the Custom Fields & Relationships section and click New to create a new custom relationship. 
  3. Choose Lookup Relationship as the Field Type and click Next
  4. From the Related To drop-down list, choose the object you created in the above procedure. In our example, choose Product Attribute Value Ext 1 and click Next.
  5. In the Field Label, type ProductAttributeValueId. In the Field Name, type ProductAttributeValueId1 and click Next.
  6. Choose necessary Field level security for the reference field and click Next.
  7. Choose the page layouts where you want to reference this field and click Next.
  8. Verify the Related List label for your field and click Save.
    Ensure that the API name for the newly created custom relationship is ProductAttributeValueId1__c.
     

To configure Custom Settings for the custom extension object

For each lookup relationship, you create with the custom extension object, you must make an entry in a custom setting.

  1. Navigate to Setup > App Setup > Develop > Custom Settings and click Manage next to Config System Properties.
  2. Next to System Properties, click Edit.
  3. In the Product Attribute Extension Tables field, type the API name of the lookup field you have created in the above procedure. In our example, type ProductAttributeValueId1__c.
    Ensure that you have specified the API names of all your lookup relationships here, separated by a comma. For example, if you have 4 extension objects and have their corresponding 4 lookup relationships, you must specify 4 API names in this field.
  4. Click Save.

You can create attributes in Product Attributes Value Extension object the same way you create attributes in the Product Attribute Value object, just select extension object that you created in the above-mentioned steps. Refer to Creating Product Attribute Values.