---
schema_version: "1"
id: 82169ba1d256b7ab797e931649926aa23c433958588232e282e3cb50f1ca9240
title: Store Product Summary DMO
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-storeproductsummarydmo-dmo.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-storeproductsummarydmo-dmo.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 16d5ef7e2baa64d155a1b702b90107d794e387f0c821dde2487a20c2e50a9b72
products:
  - Data 360 DMO and Mapping Guide
  - Data 360 Developer Documentation
---
# Store Product Summary DMO

Represents a product's summary information at a specific store, including pricing, inventory, and localized details. Links to different store types through a polymorphic relationship.

## Object Properties

**Object API Name:** `StoreProductSummary_std__dlm`  
**Category:** Unassigned  
**Availability:** Available in 262 and later versions  
**Primary Key Field:** Id  

## Relationships

- **ProductId** has a FOREIGNKEY relationship with the [Product DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productdmo-dmo.md) `Id` field.
- **StoreReferenceObjectId** has a FOREIGNKEY relationship with the [Web Store DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-webstoredmo-dmo.md) `Id` field.
- **StoreReferenceObjectId** has a FOREIGNKEY relationship with the [Retail Store DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-retailstoredmo-dmo.md) `Id` field.
- **StoreReferenceObjectId** has a FOREIGNKEY relationship with the [Sales Store DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesstoredmo-dmo.md) `Id` field.
- **GoodsProductId** has a FOREIGNKEY relationship with the [Goods Product DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-goodsproductdmo-dmo.md) `Id` field.
- **ProductTranslationId** has a FOREIGNKEY relationship with the [Product Translation DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-producttranslationdmo-dmo.md) `Id` field.
- **PriceBookEntryId** has a FOREIGNKEY relationship with the [Price Book Entry DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-pricebookentrydmo-dmo.md) `Id` field.
- **LocaleId** has a FOREIGNKEY relationship with the [Locale DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-localedmo-dmo.md) `Id` field.
- **CreatedById** has a FOREIGNKEY relationship with the [User DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.
- **LastModifiedById** has a FOREIGNKEY relationship with the [User DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.


## Fields

- [AvailableInventoryQuantity](#availableinventoryquantity)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedById](#createdbyid)
- [CreatedDateTime](#createddatetime)
- [Currency](#currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [GoodsProductId](#goodsproductid)
- [Id](#id)
- [ImageUrl](#imageurl)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_CreatedById](#kq_createdbyid)
- [KQ_GoodsProductId](#kq_goodsproductid)
- [KQ_Id](#kq_id)
- [KQ_LastModifiedById](#kq_lastmodifiedbyid)
- [KQ_LocaleId](#kq_localeid)
- [KQ_PriceBookEntryId](#kq_pricebookentryid)
- [KQ_ProductId](#kq_productid)
- [KQ_ProductTranslationId](#kq_producttranslationid)
- [KQ_StoreReferenceObjectId](#kq_storereferenceobjectid)
- [LastModifiedById](#lastmodifiedbyid)
- [LastModifiedDateTime](#lastmodifieddatetime)
- [LocaleCode](#localecode)
- [LocaleId](#localeid)
- [PriceAmount](#priceamount)
- [PriceBookEntryId](#pricebookentryid)
- [ProductId](#productid)
- [ProductSku](#productsku)
- [ProductTranslationId](#producttranslationid)
- [ProductUrl](#producturl)
- [StoreReferenceObjectId](#storereferenceobjectid)
- [StoreReferenceObjectName](#storereferenceobjectname)

### AvailableInventoryQuantity

- **Field API Name:** `AvailableInventoryQuantity__c`
- **Data Type:** DOUBLE
- **Description:** The quantity of the product currently available at the store, expressed at the configured locale level.

### cdp_sys_record_currency

- **Field API Name:** `cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### CreatedById

- **Field API Name:** `CreatedById__c`
- **Data Type:** TEXT
- **Description:** The ID of the user who created the record.

### CreatedDateTime

- **Field API Name:** `CreatedDateTime__c`
- **Data Type:** DATETIME
- **Description:** The date and time when this record was created.

### Currency

- **Field API Name:** `Currency__c`
- **Data Type:** TEXT
- **Description:** The ISO currency code in which the price is expressed.

### DataSourceId

- **Field API Name:** `DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### GoodsProductId

- **Field API Name:** `GoodsProductId__c`
- **Data Type:** TEXT
- **Description:** The identifier of the goods record that defines merchandise-specific attributes (SKU, packaging, dimensions, weight, sellability) for the product.

### Id

- **Field API Name:** `Id__c`
- **Data Type:** TEXT
- **Description:** The unique identifier of the store product summary record.

### ImageUrl

- **Field API Name:** `ImageUrl__c`
- **Data Type:** URL
- **Description:** The URL of a representative product image used for display in marketing communications.

### InternalOrganizationId

- **Field API Name:** `InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### KQ_CreatedById

- **Field API Name:** `KQ_CreatedById__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for CreatedById

### KQ_GoodsProductId

- **Field API Name:** `KQ_GoodsProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for GoodsProductId

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_LastModifiedById

- **Field API Name:** `KQ_LastModifiedById__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LastModifiedById

### KQ_LocaleId

- **Field API Name:** `KQ_LocaleId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LocaleId

### KQ_PriceBookEntryId

- **Field API Name:** `KQ_PriceBookEntryId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for PriceBookEntryId

### KQ_ProductId

- **Field API Name:** `KQ_ProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductId

### KQ_ProductTranslationId

- **Field API Name:** `KQ_ProductTranslationId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductTranslationId

### KQ_StoreReferenceObjectId

- **Field API Name:** `KQ_StoreReferenceObjectId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for StoreReferenceObjectId

### LastModifiedById

- **Field API Name:** `LastModifiedById__c`
- **Data Type:** TEXT
- **Description:** The ID of the user who most recently changed the record.

### LastModifiedDateTime

- **Field API Name:** `LastModifiedDateTime__c`
- **Data Type:** DATETIME
- **Description:** The date and time when a user last modified this record.

### LocaleCode

- **Field API Name:** `LocaleCode__c`
- **Data Type:** TEXT
- **Description:** The locale code (for example, en_US) for which this price and product information apply.

### LocaleId

- **Field API Name:** `LocaleId__c`
- **Data Type:** TEXT
- **Description:** The identifier of the locale to which this product summary is scoped.

### PriceAmount

- **Field API Name:** `PriceAmount__c`
- **Data Type:** CURRENCY
- **Description:** The most recent known price of the product at the store.

### PriceBookEntryId

- **Field API Name:** `PriceBookEntryId__c`
- **Data Type:** TEXT
- **Description:** The identifier of the price book entry that backs the price amount on this summary.

### ProductId

- **Field API Name:** `ProductId__c`
- **Data Type:** TEXT
- **Description:** The identifier of the product that this summary describes.

### ProductSku

- **Field API Name:** `ProductSku__c`
- **Data Type:** TEXT
- **Description:** The SKU code for the product as inventoried at the store.

### ProductTranslationId

- **Field API Name:** `ProductTranslationId__c`
- **Data Type:** TEXT
- **Description:** The identifier of the translated product display content used for the locale of this summary.

### ProductUrl

- **Field API Name:** `ProductUrl__c`
- **Data Type:** URL
- **Description:** The URL of the product detail page at the store.

### StoreReferenceObjectId

- **Field API Name:** `StoreReferenceObjectId__c`
- **Data Type:** TEXT
- **Description:** The identifier of the store-specific record (RetailStore, SalesStore, or WebStore) backing this summary.

### StoreReferenceObjectName

- **Field API Name:** `StoreReferenceObjectName__c`
- **Data Type:** TEXT
- **Description:** The display name of the store (web, retail, or sales) where this product summary applies.