ccdl_product

Default refresh frequency: Daily.

Primary Key: productId.

This table contains the union of:

• Goods Products: Hard goods that can be purchased. Goods products contain inventory records. B2C Commerce product types considered goods products include standard products, variation products, and options products.
• Master Products: Containers for some types of products. Master products don't have inventory records. B2C Commerce product types considered master products include master variations and master variations with product options.
• Bundle Products: Products that can be purchased as a group. Bundle products can contain independent inventory records for the bundle and the products that make up the bundle. B2C Commerce product types that represent bundle products include product bundles and product bundles with product options.

Column Reference

Column Name	Data Type	Description
brand	String	Brand name
bundledProduct	Boolean	Whether product is part of a bundle
createdDate	Date	Record creation timestamp
ean	String	European Article Number
longDescription	String	Detailed product description
manufacturerName	String	Manufacturer name
manufacturerSKU	String	Manufacturer's SKU
mastered	Boolean	Whether product is a variant of a master
masterProductId	String	Parent master product identifier for variants
minOrderQuantityUnit	String	Unit for minimum order quantity
minOrderQuantityValue	BigDecimal	Minimum order quantity value
modifiedDate	Date	Last modification timestamp
name	String	Product name
optionProduct	Boolean	Whether product has configurable options
productId	String	Unique product identifier
productType	String	Type of product (for example, ITEM, MASTER, BUNDLE)
shortDescription	String	Brief product description
simpleProduct	Boolean	Whether this is a simple (non-variant) product
sku	String	Stock keeping unit
stepQuantityUnit	String	Unit for quantity step
stepQuantityValue	BigDecimal	Quantity increment step value
taxClassID	String	Tax classification identifier
tenantId	String	Tenant identifier
unit	String	Product unit
unitMeasure	String	Unit of measure
unitQuantityUnit	String	Unit for quantity
unitQuantityValue	BigDecimal	Unit quantity value
upc	String	Universal Product Code
validFrom	Date	Product availability start date
validTo	Date	Product availability end date
version	String	Schema version identifier