Deprecated featureDeprecated feature

Attribute definitions in the search space creation XML file

Product Advisor supports usage of all of the attributes defined in the ATTRIBUTE table.

The general rule for adding these to a search space via the XML file used with the PACreateSearchSpaceBatchCmd scheduler command is as follows:

  • For a base search space, the <columnName> is the English version of the value in the NAME column in the ATTRIBUTE table. The name must adhere to all rules imposed by the database for column names. In particular, the <columnName> cannot contain spaces. The <attrName> is the value from the NAME column for the language identified. This value is case sensitive.
  • For a separate search space, the <columnName> is the English version of the value in the NAME column, with F_ prepended to it, for example, F_Size for Size. The name must adhere to all rules imposed by the database for column names. In particular, the <columnName> cannot contain spaces. The <attrName> is the value in the NAME column for the language identified. This value is case sensitive.

Product Advisor also supports a selection of attributes from other tables, such as CATENTRY and CATENTDESC, in addition to prices. The general rule for adding these to a search space via the XML file used with the PACreateSearchSpaceBatchCmd scheduler command is as follows:

  • For a base search space, the <columnName> and <attrName> should be the column name from the base table. For example, use shortdescription for the SHORTDESCRIPTION column in CATENTDESC. This value is not case sensitive.
  • For a separate search space, the <columnName> value can be found in the table below. The <attrName> is the column name from the base table. This value is not case sensitive.

The table below illustrates the selection of attributes supported beyond those in the ATTRIBUTE table. The italicized rows are mandatory when using the PACreateSearchSpaceBatchCmd scheduler command. Otherwise, the metaphors will not operate properly. This is true even if the attributes are not exposed to customers.

Search Space Attribute <columnName> value <attrName> value
Separate Catentry_Id PRRFNBR CATENTRY_ID
SKU (part number) PRNBR PARTNUMBER
Short description PRSDESC SHORTDESCRIPTION
Thumbnail PRTHMB THUMBNAIL
XML Detail XMLDETAIL XMLDETAIL
Price PPPRC LISTPRICE or PRICE
Availability AVAILABLE AVAILABLE
Base Catentry_Id CATENTRY_ID CATENTRY_ID
SKU (part number) PARTNUMBER PARTNUMBER
Short description SHORTDESCRIPTION SHORTDESCRIPTION
Thumbnail THUMBNAIL THUMBNAIL
XML Detail XMLDETAIL XMLDETAIL
Price LISTPRICE LISTPRICE or PRICE
Availability AVAILABLE AVAILABLE