auxiliaryMedia

ACC

Additional media to be displayed with the SKU.

bundleLinks

ACC

List of SKU links that make up the SKU bundle; if null, SKU is not a bundle.

catalogs

CMS or Derived

In development this is the Collective Union of catalogs for each product in parentProducts. 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 SKU.

catalogsReplacementProducts

Derived

Replacement products that are only shown to users of a particular catalog. Read-only.

computedCatalog

Derived

creationDate

Implicitly set by GSA

Date the SKU is created. Read-only.

derivedCatalog

Derived

description

ACC

Short descriptive text for display with the SKU.

discountable

ACC

This property indicates whether or not the item is eligible to receive discounts through promotions. The default is true.

displayName

ACC

Name used for the SKU on the site. Required.

dynamicAttributes

ACC

Additional attributes of the SKU.

endDate

ACC

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

fixedReplacement
Products

ACC

Static list of products related to this SKU.

fulfiller

ACC

Fulfiller who will ship the item.

id

ACC

Repository ID for this SKU. Can be set in ACC upon item creation, otherwise implicitly set by GSA.

largeImage

ACC

Large image associated with the SKU.

listPrice

ACC

Default price of the SKU before any discounts or promotions.

manufacturer_part_
number

nonreturnable

ACC

Indicates if the SKU is not returnable.

onlineOnly

ACC

Flag indicates that the SKU is not available for in-store pickup, but can only be purchased online.

onSale

ACC

Boolean property that indicates if the item is on sale.

parentProducts

implicit
GSA
reuse

Reuses the same table as product.childSkus. Therefore adding a SKU to a product’s child list will automatically update the parentProducts property. 

quantity

ACC

replacementProducts

derived

Products to suggest as replacements if the item is out of stock. Read-only.

salePrice

ACC

Price of the SKU if onSale property is true.

siteIds

CMS or derived

If you are using Core Commerce’s multisite feature, the IDs of the sites to which the SKU belongs. On the production server, this is calculated by the CMS; on the asset management server, it is derived from the union of the siteIds of the SKU’s parent products.

skuInfos

ACC

Map from SKU to a SKUInfo.

smallImage

ACC

Small image associated with the SKU.

startDate

ACC

Date on which the SKU is available, if a collection filter is implemented to use this property.

template

ACC

JSP template used to display the SKU.

thumbnailImage

ACC

Thumbnail image associated with the SKU.

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.

unit_of_measure

ACC

version

Implicitly set by GSA

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

wholesalePrice

ACC

Wholesale price of the SKU.