Ecommerce – Related Items Display Using SQL

To support output of  multiple related items sections in the catalogdetail.asp  page, on 09.15.2011 the following changes to the default configuration of the Stream V Ecommerce system were made:

In the system Textdata table:

WBO:CATDETL:RELATEDF was renamed to WBO:CATDRIF:DEFAULT

WBO:CATDETL:RELATEDH was renamed to WBO:CATDRIH:DEFAULT

WBO:CATDETL:RELATEDL was renamed to WBO:CATDRIL:DEFAULT

 

In CatalogDetail.asp:

oCatalogDetail.Call "msg_Output_Related_Items", s_Item

Was changed to:

oCatalogDetail.Call "msg_Output_Related_Items", s_Item, "DEFAULT"

 

The system administrator or web designer may create multiple sections for related items on the catalog detail page by creating additional sets of the WBO records defined above with unique data in the ID field of the Textdata record.

These sections can be displayed by making additional requests to output the related items by using the following call replacing the TEXTDATA.ID in the syntax below with the ID of the section

oCatalogDetail.Call "msg_Output_Related_Items", s_Item, "TEXTDATA.ID"

The SQL query to populate the line detail of each of these sections is stored in the Textdata record WSQ:CATRELIT:TEXTDATA.ID. The third argument in the Textdata record must match that of the third argument of the related items formatting records. For example the default SQL query is defined as WSQ:CATRELIT:DEFAULT.

The SQL query should only return the catalog.recnum. All formatting and fields to display are handled by the WBO formatting records.

Changing the third argument allows the system administrator or web designer to output multiple sections populated by unique queries. For example it may be desirable to output sections for replacement parts, suggested items, what other people are buying, etc.

 

More:

Ecommerce - Excluding Warehouse Locations From Displaying In Catalog Lookup