Cloudy Revenue Inventory Knowledge Base

Stock Item Attribute

The Stock Item Attribute object stores configurable attributes and option values associated with a Stock Item. It acts as the bridge between Salesforce CPQ and Cloudy Inventory, preserving product configuration details for inventory, manufacturing, procurement, and order fulfillment.

Each Stock Item can have multiple attributes that describe its configuration, such as Color, Engine Type, Transmission, Storage Capacity, or Material. These attributes enable businesses to manage configurable products while maintaining complete traceability across inventory and production processes.

The Stock Item Attribute is linked to a Stock Item through a Master-Detail relationship and references the parent Product, ensuring that each configured Stock Item accurately represents the selected product options.

Why is it Used?

The Stock Item Attribute object is used to:

  • Store configurable product attributes for each Stock Item.
  • Capture CPQ Product Options and Configuration Attributes.
  • Preserve product configuration during inventory transactions.
  • Support configurable and variant-based products.
  • Improve manufacturing and production accuracy.
  • Enable warehouse users to identify configured inventory.
  • Maintain consistency between Salesforce CPQ and Cloudy Inventory.
  • Provide complete traceability for configurable products.
  • Support reporting and analytics based on product attributes.

Key Features

🏷️ Attribute Management

Stores detailed attribute information such as Attribute Name, Attribute Label, and Attribute Value for each Stock Item.

🔗 Product Association

Maintains a lookup relationship with the parent Product, ensuring attributes are associated with the correct product.

📦 Stock Item Configuration

Each Stock Item can contain multiple configuration attributes, allowing businesses to manage configurable inventory.

⚙️ CPQ Integration

Supports Salesforce CPQ Product Options, Configuration Attributes, Product Option Attributes, and Component Attributes.

🔄 Configuration Traceability

Preserves selected product options throughout procurement, manufacturing, inventory management, and order fulfillment.

📊 Sequence Management

Maintains the display and processing order of attributes using the Sequence field.

🔍 Attribute Matching

Uses Matching Key and Feature information to uniquely identify configuration values.

🏭 Manufacturing Ready

Provides production teams with accurate configuration details required during manufacturing and assembly.

📦 Inventory Visibility

Warehouse users can easily identify configured Stock Items based on their stored attributes.

📈 Reporting & Analytics

Enables reporting on configurable products, feature usage, and product variants.

Picklist Functionality

FieldValuePurpose
TypeCPQ Product Option AttributeStores attributes inherited from a Product Option.
CPQ Product OptionIdentifies the selected Product Option.
CPQ Configuration AttributeStores configuration attributes selected during product configuration.
CPQ Component AttributeStores attributes related to bundle or component items.

Example Business Scenario

Scenario: Configuring a Maruti Dzire Stock Item

ABC Automotive Pvt. Ltd. manufactures Sedan Cars with multiple customer-configurable options

A customer orders a Maruti Dzire with the following configuration:

  • Product: Sedan Car
  • Stock Item: Maruti Dzire
  • Color: Pearl White
  • Engine Type: Petrol
  • Transmission: Automatic
  • Interior: Leather Seats
  • Wheel Size: 17 Inch Alloy
  • Feature Package: Premium Edition

For each selected option, Cloudy Inventory automatically creates Stock Item Attribute records linked to the Maruti Dzire Stock Item.

System Behaviour :

  • The selected product configuration is stored as Stock Item Attributes.
  • Each attribute is linked to the corresponding Product and Stock Item.
  • Configuration details remain available throughout procurement, manufacturing, inventory, and sales.
  • Production teams can identify the exact product configuration during manufacturing.
  • Warehouse users can verify configured inventory using stored attribute values.
  • Order Fulfillment uses the configured Stock Item to deliver the correct product to the customer.

Outcome:

  • Product configurations are preserved throughout the business lifecycle.
  • Manufacturing receives accurate configuration details.
  • Warehouse operations become more efficient.
  • Incorrect product deliveries are minimized.
  • Inventory maintains complete configuration traceability.
  • Salesforce CPQ and Cloudy Inventory remain synchronized.

SEE ALSO :

_____👉Stock Item Attribute Creation