The following table describes the product item properties in catalog:

Property

How it is set

Description

ancestorCategories

CMS

All the categories that you can navigate through (via category.childCategories and category.childProducts) to this category, regardless of catalog. Used for hierarchical search.

ancestorCategoryIds

Implicitly set by CMS

RepositoryIDs of the ancestor categories. Read-only. This property uses the same database table as ancestorCategories.

auxiliaryMedia

ACC

Additional media to be displayed with this product.

catalogs

Derived (development only)

In development, this is the Collective Union of catalogs for each category in parentCategories. This is not queryable. In production, this value is set by the CatalogMaintenanceService. Used to determine if an end user has permission to view this product.

catalogsRelatedProducts

derived

Generated Set of related products that are only shown to users of a particular catalog. Read-only.

childSKUs

ACC

List of child SKUs of this product. Used by catalog administrator to explicitly set child SKUs of a product.

creationDate

Implicitly set by GSA

Date this product was created. Read-only.

description

ACC

Short descriptive text for display with this product.

displayableSkuAttributes

ACC

List of properties of the product’s SKUs that can be displayed by the DisplaySkuProperties servlet bean.

displayName

ACC

Name used for the product on the site. Required.

dynamicRelatedProducts

derived

List of the products in the content group specified by the relatedProductGroup property. Read-only.

endDate

ACC

Date this product will no longer be available, if a collection filter is implemented to use this property. See the ATG Personalization Programming Guide for information on filtering.

fixedRelatedProducts

ACC

Static list of products related to this product.

id

ACC (optional)

RepositoryID for this category. Can be set in ACC upon creation of product. If it is not set through the ACC, it is implicitly set by GSA

keywords

ACC

Set of words that can be used in searching for this product.

largeImage

ACC

Large image associated with the product.

longDescription

ACC

Detailed descriptive text for display with this product.

manufacturer

parentCategories

Implicit GSA reuse

Reuses the same table as category.fixedChildCategories. Therefore adding a product to another category’s child list automatically updates the parentCategories property.

parentCategoriesForCatalog

CMS

The parentCategory for each catalog. If this property is null and there is more than one possible parent category, the CMS chooses one arbitrarily. Used to derive the value for the parentCategory property.

parentCategory

derived

In development, the product’s ParentCategory is derived by inspecting each category in parentCategories.
In production, the CatalogMapDerivation is used to get the correct parent.

productInfos

ACC

Map from productId to a productInfo.

relatedProductGroup

ACC

Name of the content group that contains the list of dynamicRelatedProducts.

relatedProducts

ACC

List of all products that are children of this product; a merge of fixedRelatedProducts, dynamicRelatedProducts, and the productInfo property catalogsRelatedProducts. Read-only.

siteIds

CMS or derived

If you are using Oracle ATG Web Commerce’s multisite feature, the list of IDs for the sites to which the product belongs. On a production server, this is calculated by the CMS; on an asset management server, it is derived from a union of the siteIds of the parent categories of the product.

smallImage

ACC

Small image associated with the product.

startDate

ACC

Date this product becomes available, if a collection filter is implemented to use this property. See the ATG Personalization Programming Guide for information on filtering.

template

ACC

JSP used to display this product.

thumbnailImage

ACC

Thumbnail image associated with this product.

type

Not used out-of-the-box

Provided for subclassing purposes; use to indicate if an item belongs to the superclass or a subclass. Read-only.

version

Implicitly set by GSA

Integer that is incremented automatically each time the product is updated; used to prevent version conflict. Read-only.