User-defined Property and Catalog Attributes

  • Article

The maximum number of user-defined property and catalog attributes is 100. Commerce Server 2002 allows you to define additional attributes to associate user-specific information with properties and catalogs. For example, you can create a user-defined catalog attribute to associate vendor information with a catalog.

You can use the AddPropertyAttribute and AddCatalogAttribute methods of the CatalogManager object to add property and catalog attributes. The following character restrictions apply for the indicated properties.

Item Name and size restrictions
CatalogProperty
  • There is no numeric limit.
  • The maximum number of Catalog Properties that can be used in any one catalog is 1000. (SQL Server has a limit of 1024 columns in any table.)
  • These properties are also the names of the columns in the per-catalog tables.
PropertyAttribute
  • The maximum number of user-defined Property Attributes that can be added to the Product Catalog System is 100. These are not related to the CatalogProducts table.
  • These properties are the additional user-defined columns in the CatalogAttributes table.
CatalogAttribute
  • The maximum number of user-defined Catalog Attributes that can be added to the Product Catalog System is 100. These are not related to the CatalogProducts table.

See Also

Best Practices for Catalogs

Copyright © 2005 Microsoft Corporation.
All rights reserved.