---
schema_version: "1"
id: 292be498461e59a956530f8d0e796f4ba2d1599f03521ea4e0c2ec3d185edd53
title: Assortment
collection: legacydeveloper
version: current
locale: en-us
portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/retail_api/sforce_api_objects_assortment.md
canonical_url: https://developer.salesforce.com/docs/atlas.en-us.retail_api.meta/retail_api/sforce_api_objects_assortment.htm
source_site: developer.salesforce.com
content_type: documentation
content_hash: 9618534a3873b09d7f9d3dbd71b648e3b49562b92b93660817af694a1d53cd99
description: Represents a list of products that are eligible for sale in a store. This object is available in API version 47.0 and later.
---
# Assortment

Represents a list of products that are eligible for sale in a store. This object is available in API version 47.0 and later.

## Supported Calls

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()

## Fields

### Description

- **Type**: textarea
- **Properties**: Create, Filter, Nillable, Sort, Update
- **Description**: User-defined description of an assortment of products.

### LastReferencedDate

- **Type**: dateTime
- **Properties**: Filter, Nillable, Sort
- **Description**: The most recent date on which a user referenced this record.

### LastViewedDate

- **Type**: dateTime
- **Properties**: Filter, Nillable, Sort
- **Description**: The most recent date on which a user viewed this record.

### Name

- **Type**: string
- **Properties**: Create, Filter, Group, idLookup, Sort, Update
- **Description**: User-defined name of an assortment of products.

### OwnerId

- **Type**: reference
- **Properties**: Create, Defaulted on create, Filter, Group, Sort, Update
- **Description**: ID of the assortment owner.

### cgcloud\_\_Description\_Language\_1\_\_c

- **Type**: string
- **Properties**: Create, Filter, Group, Nillable, Sort, Update
- **Description**: The description of language 1. This field is available in API version 55.0 and later.

### cgcloud\_\_Description\_Language\_2\_\_c

- **Type**: string
- **Properties**: Create, Filter, Group, Nillable, Sort, Update
- **Description**: The description of language 2. This field is available in API version 55.0 and later.

### cgcloud\_\_Description\_Language\_3\_\_c

- **Type**: string
- **Properties**: Create, Filter, Group, Nillable, Sort, Update
- **Description**: The description of language 3. This field is available in API version 55.0 and later.

### cgcloud\_\_Description\_Language\_4\_\_c

- **Type**: string
- **Properties**: Create, Filter, Group, Nillable, Sort, Update
- **Description**: The description of language 4. This field is available in API version 55.0 and later.

### cgcloud\_\_Description\_\_c

- **Type**: string
- **Properties**: Filter, Nillable, Sort
- **Description**: Description based on the user specific language.
    
    This field is a calculated field.
- **Formula**:
    
    CASE($User.cgcloud\_\_Language\_Postfix\_\_c,
    "Language1", cgcloud\_\_Description\_Language\_1\_\_c,
    "Language2", BLANKVALUE(cgcloud\_\_Description\_Language\_2\_\_c,cgcloud\_\_Description\_Language\_1\_\_c),
    "Language3", BLANKVALUE(cgcloud\_\_Description\_Language\_3\_\_c,cgcloud\_\_Description\_Language\_1\_\_c),
    "Language4", BLANKVALUE(cgcloud\_\_Description\_Language\_4\_\_c,cgcloud\_\_Description\_Language\_1\_\_c),
    cgcloud\_\_Description\_Language\_1\_\_c)

### cgcloud\_\_Distribution\_\_c

- **Type**: picklist
- **Properties**: Create, Filter, Group, Nillable, Sort, Update
- **Description**: This field is not used in Consumer Goods Cloud.

### cgcloud\_\_Facings\_\_c

- **Type**: double
- **Properties**: Create, Filter, Nillable, Sort, Update
- **Description**: This field is not used in Consumer Goods Cloud.

### cgcloud\_\_Listing\_Module\_\_c

- **Type**: picklist
- **Properties**: Create, Defaulted on create, Filter, Group, Nillable, Sort, Update
- **Description**: Value of the Listing Module. This field is available in API version 55.0 and later.
- **Default value**: Base Module
- **Possible values**:
    - Base Module

### cgcloud\_\_Obligatory\_\_c

- **Type**: boolean
- **Properties**: Create, Defaulted on create, Filter, Group, Sort, Update
- **Description**: Denotes whether this is a closed listing. Used by the system.
    
    This field is available in API version 55.0 and later.
- **Default value**: false

### cgcloud\_\_Price\_Survey\_\_c

- **Type**: double
- **Properties**: Create, Filter, Nillable, Sort, Update
- **Description**: This field is not used in Consumer Goods Cloud.

### cgcloud\_\_Product\_Assortment\_Template\_\_c

- **Type**: reference
- **Properties**: Create, Filter, Group, Nillable, Sort, Update
- **Description**: References to the name of product assortment template. This field is available in API version 55.0 and later.
    
    This field is a relationship field.
- **Relationship Name**: cgcloud\_\_Product\_Assortment\_Template\_\_r
- **Relationship Type**: Lookup
- **Refers To**: cgcloud\_\_Product\_Assortment\_Template\_\_c

### cgcloud\_\_Sales\_Org\_\_c

- **Type**: string
- **Properties**: Filter, Nillable, Sort
- **Description**: Describes the sales org which the product assortment belongs to. This field is available in API version 55.0 and later.
    
    This field is a calculated field.
- **Formula**:
    
    TEXT(cgcloud\_\_Product\_Assortment\_Template\_\_r.cgcloud\_\_Sales\_Org\_\_c)

### cgcloud\_\_Sync\_Pending\_\_c

- **Type**: boolean
- **Properties**: Defaulted on create, Filter, Group, Sort
- **Description**: Flagged to be relevant for this sync process. This field is available in API version 55.0 and later.
    
    This field is a calculated field.
- **Formula**:
    
    IF( cgcloud\_\_Version\_\_c <>  cgcloud\_\_Version\_Off\_Platform\_APL\_\_c ,
    cgcloud\_\_Product\_Assortment\_Template\_\_r.cgcloud\_\_Consider\_For\_APL\_Generation\_\_c, false )

### cgcloud\_\_Valid\_From\_\_c

- **Type**: date
- **Properties**: Create, Defaulted on create, Filter, Group, Nillable, Sort, Update
- **Description**: The starting date of the valid period for the Assortment. This field is available in API version 55.0 and later.

### cgcloud\_\_Valid\_Thru\_\_c

- **Type**: date
- **Properties**: Create, Defaulted on create, Filter, Group, Nillable, Sort, Update
- **Description**: The end date of the valid period for the Assortment. This field is available in API version 55.0 and later.

### cgcloud\_\_Version\_Off\_Platform\_APL\_\_c

- **Type**: double
- **Properties**: Create, Defaulted on create, Filter, Nillable, Sort, Update
- **Description**: Stores the off platform version number of Account product list. This field is available in API version 55.0 and later.

### cgcloud\_\_Version\_\_c

- **Type**: double
- **Properties**: Create, Filter, Nillable, Sort, Update
- **Description**: Stores the version number of Authorization list. This field is available in API version 55.0 and later.

## Associated Objects

This object has the following associated objects. Unless noted, they’re available in the same API version as this object.

- **[AssortmentFeed](https://developer.salesforce.com/docs/atlas.en-us.retail_api.meta/retail_api/sforce_api_associated_objects_feed.htm "StandardObjectNameFeed is the model for all feed objects associated with standard objects. These objects represent the posts and feed-tracked changes of a standard object.")**: Feed are available for the object.
- **[AssortmentHistory](https://developer.salesforce.com/docs/atlas.en-us.retail_api.meta/retail_api/sforce_api_associated_objects_history.htm "StandardObjectNameHistory is the model for all history objects associated with standard objects. These objects represent the history of changes to the values in the fields of a standard object.")**: History is available for the object.
- **[AssortmentShare](https://developer.salesforce.com/docs/atlas.en-us.retail_api.meta/retail_api/sforce_api_associated_objects_share.htm "StandardObjectNameShare is the model for all share objects associated with standard objects. These objects represent a sharing entry on the standard object.")**: Sharing is available for the object.