.\" Automatically generated by Pod::Man version 1.15 .\" Wed May 5 11:41:30 2004 .\" .\" Standard preamble: .\" ====================================================================== .de Sh \" Subsection heading .br .if t .Sp .ne 5 .PP \fB\\$1\fR .PP .. .de Sp \" Vertical space (when we can't use .PP) .if t .sp .5v .if n .sp .. .de Ip \" List item .br .ie \\n(.$>=3 .ne \\$3 .el .ne 3 .IP "\\$1" \\$2 .. .de Vb \" Begin verbatim text .ft CW .nf .ne \\$1 .. .de Ve \" End verbatim text .ft R .fi .. .\" Set up some character translations and predefined strings. \*(-- will .\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left .\" double quote, and \*(R" will give a right double quote. | will give a .\" real vertical bar. \*(C+ will give a nicer C++. Capital omega is used .\" to do unbreakable dashes and therefore won't be available. \*(C` and .\" \*(C' expand to `' in nroff, nothing in troff, for use with C<> .tr \(*W-|\(bv\*(Tr .ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p' .ie n \{\ . ds -- \(*W- . ds PI pi . if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch . if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch . ds L" "" . ds R" "" . ds C` "" . ds C' "" 'br\} .el\{\ . ds -- \|\(em\| . ds PI \(*p . ds L" `` . ds R" '' 'br\} .\" .\" If the F register is turned on, we'll generate index entries on stderr .\" for titles (.TH), headers (.SH), subsections (.Sh), items (.Ip), and .\" index entries marked with X<> in POD. Of course, you'll have to process .\" the output yourself in some meaningful fashion. .if \nF \{\ . de IX . tm Index:\\$1\t\\n%\t"\\$2" .. . nr % 0 . rr F .\} .\" .\" For nroff, turn off justification. Always turn off hyphenation; it .\" makes way too many mistakes in technical documents. .hy 0 .if n .na .\" .\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2). .\" Fear. Run. Save yourself. No user-serviceable parts. .bd B 3 . \" fudge factors for nroff and troff .if n \{\ . ds #H 0 . ds #V .8m . ds #F .3m . ds #[ \f1 . ds #] \fP .\} .if t \{\ . ds #H ((1u-(\\\\n(.fu%2u))*.13m) . ds #V .6m . ds #F 0 . ds #[ \& . ds #] \& .\} . \" simple accents for nroff and troff .if n \{\ . ds ' \& . ds ` \& . ds ^ \& . ds , \& . ds ~ ~ . ds / .\} .if t \{\ . ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u" . ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u' . ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u' . ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u' . ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u' . ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u' .\} . \" troff and (daisy-wheel) nroff accents .ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V' .ds 8 \h'\*(#H'\(*b\h'-\*(#H' .ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#] .ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H' .ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u' .ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#] .ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#] .ds ae a\h'-(\w'a'u*4/10)'e .ds Ae A\h'-(\w'A'u*4/10)'E . \" corrections for vroff .if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u' .if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u' . \" for low resolution devices (crt and lpr) .if \n(.H>23 .if \n(.V>19 \ \{\ . ds : e . ds 8 ss . ds o a . ds d- d\h'-1'\(ga . ds D- D\h'-1'\(hy . ds th \o'bp' . ds Th \o'LP' . ds ae ae . ds Ae AE .\} .rm #[ #] #H #V #F C .\" ====================================================================== .\" .IX Title "icfoundation 8" .TH icfoundation 8 "Interchange 5.2.0" "2004-05-05" "Interchange" .UC .SH "NAME" icfoundation \- Foundation Store .SH "DESCRIPTION" .IX Header "DESCRIPTION" .SH "The Foundation Store" .IX Header "The Foundation Store" The Foundation store is distributed with Interchange to give you a starting point with which to build your e-business. While the Foundation store is designed to be relatively easy to start with, it is still a full-featured demonstration of a number of Interchange capabilities. Once you understand the Foundation store and how it works you are well on your way to understanding the Interchange software. .PP The following is a list of some popular features: .Ip "Category Searches" 4 .IX Item "Category Searches" Regardless of the number of products in a catalog, categorizing them makes them easier to find. Pick a field in the database, typically named category, and classify the products for search using Interchange. .Ip "Images" 4 .IX Item "Images" You can display a thumbnail image for the items that have images. To do this, add an image field in the database. (See the 'image' field of the products database.) .Ip "Related Items" 4 .IX Item "Related Items" You can embed searches of similar products on an individual product display page with the [query ...] or [loop ...] tags. Or, if customer data is developed, search a past order database and display products that would be of interest to that customer. .Ip "Reviews/Testimonials" 4 .IX Item "Reviews/Testimonials" You can key the placement of a review or testimonial on the existence of a file being in a certain directory. This is reasonable to do when a user is viewing a single product. .Sh "Customizing Foundation" .IX Subsection "Customizing Foundation" The foundation store has been customized to add just about every ecommerce and content management feature under the sun. If you are asking the question \*(L"can I do ....\*(R" the answer is almost assuredly \&\*(L"Yes\*(R". .PP Note that customizing the foundation store will take some experience in web design and database operations. Perl experience is also helpful. Most of all it will take persistence and empowering yourself to make changes and watch what happens. .PP It is usually helpful to make a test store, perhaps just an unmodified copy of foundation, to test out your additions before you make them on your own store. That way you can try anything you want without the chance of causing problems on your own store. .SH "Tree design" .IX Header "Tree design" By determining how users will enter and exit the catalog, complex and intelligent conditional schemes are possible, especially if the Cookies capability is exercised. However, it is recommended that simplicity be used. Consumers will not make purchases if they can't navigate their way around the catalog. .PP It is important to remember that users will lose their session (and items in their shopping cart) if their browser does not accept cookies and they leave the site. Interchange addresses this problem by using the area and page tags. If you are using frames, source all frame panes containing Interchange links from an initial page served by Interchange. If you don't do this, the user may have multiple session IDs depending on which frame generated the link. .PP Note that Interchange can work properly even if the browser doesn't store cookies. In this situation Interchange inserts a session \s-1ID\s0 into each \s-1URL\s0; if the \s-1ID\s0 is preserved as the user navigates from page to page the session will remain intact. .SH "The Catalog Directory" .IX Header "The Catalog Directory" Interchange pages are contained in the catalog directory. Each individual catalog has its own base directory. The catalog directory has the following structure by default: .Ip "catalog.cfg" 4 .IX Item "catalog.cfg" File containing configuration directives for a particular catalog. Configuration settings established in the catalog.cfg directory will not effect any other catalogs running under the version of Interchange you are using. Subcatalogs can have differing information in a file named for that subcatalog. .Ip "config" 4 .IX Item "config" Directory that will be read when directives are set with the filename notation. For example, the file config/static.pages will be read when the following directive is encountered in the catalog.cfg file. .Sp .Vb 1 \& StaticPage foundation \& |----foundation/ \& |----cart \& |----fullwidth \& |----leftonly \& |----leftright \& |----regions/ \& |----LEFTONLY_BOTTOM \& |----LEFTONLY_TOP \& |----LEFTRIGHT_BOTTOM \& |----LEFTRIGHT_TOP \& |----NOLEFT_BOTTOM \& |----NOLEFT_TOP \& |----simple \& |----theme.cfg \& |----fullwidth \& |----leftonly \& |----leftright \& |----regions/ \& |----LEFTONLY_BOTTOM \& |----LEFTONLY_TOP \& |----LEFTRIGHT_BOTTOM \& |----LEFTRIGHT_TOP \& |----NOLEFT_BOTTOM \& |----NOLEFT_TOP \& |----sampledata/ \& |----computers/ \& |----images/ \& |----items/ \& |----generic.gif \& |----gift_certificate_large.gif \& |----yourimage.gif \& |----thumb/ \& |----generic_thumb.gif \& |----gift_certificate.gif \& |----thumb.gif \& |----products/ \& |----inventory.txt \& |----merchandising.txt \& |----mv_metadata.asc \& |----options.txt \& |----pricing.txt \& |----products.txt \& |----userdb.txt \& |----reports/ \& |----download/ \& |----00352as.pdf \& |----11993ab.pdf \& |----22083da.pdf \& |----49503cg.pdf \& |----59330rt.pdf \& |----59402fw.pdf \& |----66548ch.pdf \& |----73358ee.pdf \& |----83491vp.pdf \& |----90773sh.pdf \& |----products/ \& |----mv_metadata.asc \& |----products.txt \& |----userdb.txt \& |----tools/ \& |----etc/ \& |----after.cfg \& |----before.cfg \& |----images/ \& |----items/ \& |----os28004.gif \& |----os28005.gif \& |----os28006.gif \& |----os28007.gif \& |----os28008.gif \& |----os28009.gif \& |----os28011.gif \& |----os28044.gif \& |----os28057a.gif \& |----os28057b.gif \& |----os28057c.gif \& |----os28062.gif \& |----os28064.gif \& |----os28065.gif \& |----os28066.gif \& |----os28068.gif \& |----os28068a.gif \& |----os28068b.gif \& |----os28069.gif \& |----os28070.gif \& |----os28072.gif \& |----os28073.gif \& |----os28074.gif \& |----os28075.gif \& |----os28076.gif \& |----os28077.gif \& |----os28080.gif \& |----os28081.gif \& |----os28082.gif \& |----os28084.gif \& |----os28085.gif \& |----os28086.gif \& |----os28087.gif \& |----os28108.gif \& |----os28109.gif \& |----os28110.gif \& |----os28111.gif \& |----os28112.gif \& |----os28113.gif \& |----os29000.gif \& |----thumb/ \& |----gift_certificate.gif \& |----os28004_b.gif \& |----os28005_b.gif \& |----os28006_b.gif \& |----os28007_b.gif \& |----os28008_b.gif \& |----os28009_b.gif \& |----os28011_b.gif \& |----os28044_b.gif \& |----os28057a_b.gif \& |----os28057b_b.gif \& |----os28057c_b.gif \& |----os28062_b.gif \& |----os28064_b.gif \& |----os28065_b.gif \& |----os28066_b.gif \& |----os28068_b.gif \& |----os28068a_b.gif \& |----os28068b_b.gif \& |----os28069_b.gif \& |----os28070_b.gif \& |----os28072_b.gif \& |----os28073_b.gif \& |----os28074_b.gif \& |----os28075_b.gif \& |----os28076_b.gif \& |----os28077_b.gif \& |----os28080_b.gif \& |----os28081_b.gif \& |----os28082_b.gif \& |----os28084_b.gif \& |----os28085_b.gif \& |----os28086_b.gif \& |----os28087_b.gif \& |----os28108_b.gif \& |----os28109_b.gif \& |----os28110_b.gif \& |----os28111_b.gif \& |----os28112_b.gif \& |----os28113_b.gif \& |----os29000_b.gif \& |----products/ \& |----affiliate.txt \& |----area.txt \& |----cat.txt \& |----inventory.txt \& |----merchandising.txt \& |----mv_metadata.asc \& |----options.txt \& |----orderline.txt \& |----pricing.txt \& |----products.txt \& |----transactions.txt \& |----userdb.txt .Ve .Sh "Themes" .IX Subsection "Themes" This section explains how themes are defined in Interchange via the \&\s-1STYLE\s0 variable and the theme configuration file, theme.cfg. .PP \&\s-1STYLE\s0 .PP The \s-1STYLE\s0 variable in CATROOT/products/variable.txt indicates the template style to be used as the theme for the catalog; the appropriate templates for that theme are found in CATROOT/templates/_\|_STYLE_\|_/. (To change the value of the \s-1STYLE\s0 variable, either edit variable.txt directly or use the table editor feature of the admin interface.) .PP The default theme for Interchange is the Foundation demo; hence, the \&\s-1STYLE\s0 variable is assigned the value 'Foundation' in variable.txt. The theme is defined in catalog.cfg as follows\ (line\ numbers\ added): .PP .Vb 1 \& # Here we set up the catalog theme. .Ve .Vb 1 \& 1 ParseVariables Yes .Ve .Vb 4 \& 2 ifndef STYLE \& 3 Variable STYLE default \& 4 endif \& 5 include templates/__STYLE__/theme.cfg .Ve Variables that make up the look and feel of the \s-1STYLE\s0 (theme) are defined in the file CATROOT/templates/foundation/theme.cfg, which is read by Interchange in line 5 above. .PP theme.cfg .PP The file CATROOT/templates/foundation/theme.cfg serves three purposes: .Ip "1." 4 It defines the \s-1THEME\s0 and \s-1THEME_IMG_DIR\s0 variables, .Ip "2." 4 It defines a cascading style sheet for the theme, and .Ip "3." 4 It defines the location of region templates according to the traffic settings for the Interchange daemon. .PP The \s-1THEME\s0 variable is used to set the location of the region templates in the traffic settings section of the theme.cfg file. It is also used in the cart template definition file (CATROOT/templates/cart) to set the path of an image. The \s-1THEME_IMG_DIR\s0 variable is used to set image paths in the template region files and the template component files. .PP The look and feel of the Foundation theme are defined primarily in the cascading style sheet specified in the theme.cfg file. This .PP The Interchange \s-1TRAFFIC\s0 setting, defined system-wide in interchange.cfg, is described in the ??document??. The settings in theme.cfg pertain to the location of region templates for the high and low traffic settings. For example, if you need to define a separate set of high traffic templates, you would change the ConfigDir variable in theme.cfg to point to the directory containing those templates. .Sh "Template Definition Files" .IX Subsection "Template Definition Files" The template definition files store the name and description of the template as well as components and options for that template. .PP .Vb 4 \& templates/cart \& templates/fullwidth \& templates/leftonly \& templates/leftright .Ve .Vb 5 \& templates/foundation/cart \& templates/foundation/fullwidth \& templates/foundation/leftonly \& templates/foundation/leftright \& templates/foundation/simple .Ve Template Walkthrough \*(-- leftonly .PP This section is best read while viewing the file CATROOT/templates/leftonly and the 'Edit Page' page in the Content Editor of the Interchange Administration Tool. .PP Looking at the example template definition file, all lines located between the [comment] and [/comment] tags (lines 1 and 53) control what is available in the Edit Page screen of the Administration Tool. .PP \&\fBLines 2\-5:\fR Template specification .PP .Vb 4 \& 2 ui_template: Yes \& 3 ui_template_name: leftonly \& 4 ui_template_layout: LEFTONLY_TOP, UI_CONTENT, LEFTONLY_BOTTOM \& 5 ui_template_description: Page with top/left areas. .Ve Line 2 indicates that this file is a template for the user interface. Line 3 names the template, while Line 4 indicates the regions that comprise the template and that will eventually make up the new page that is created from the template. Line 5 provides a description used to identify the template when it appears in a Select Template pull-down menu on the Edit Page of the Administration Tool. This description can be changed or modified to better describe a new template or a template that is created from the stock templates provided with Interchange. .PP \&\fBLines 7\-8:\fR Break .PP .Vb 2 \& 7 break: \& 8 widget: break .Ve This code creates a separation line in the Edit Page between sets of options. In the default Interchange installation the line is grey, but the color can be changed. Note \- Changing this color applies the change to any catalog served by Interchange. .PP \&\fBLines 10\-11:\fR Page Title .PP .Vb 2 \& 10 page_title: \& 11 description: Page title .Ve This code tells Interchange to display a text field on the Edit Page for entering the page title ('Title of New Page' in this example). The value entered is assigned to the scratch variable page_title and is set as a default value at the bottom of the template definition file using the following \s-1ITL:\s0 .PP .Vb 1 \& 54 [set page_title][set] .Ve which, in turn, sets the scratch variable on the new page using the tag .PP .Vb 1 \& [set page_title]Title of New Page[set] .Ve The scratch variable page_title is parsed by the following code in the region template specified in the template definition file and called in the new page: .PP .Vb 1 \& [scratch page_title] .Ve \&\fBLines 13\-15:\fR Page Banner .PP .Vb 3 \& 13 page_banner: \& 14 description: Page banner \& 15 help: Defaults to page title .Ve Assigns a textual title for the page to the scratch variable page_banner, which is assigned by the following \s-1ITL:\s0 .PP .Vb 1 \& 55 [set page_banner][set] .Ve The scratch variable page_banner is set on the new page using the tag .PP .Vb 1 \& [set page_banner]Banner of New Page[set] .Ve The scratch variable can be parsed in the region template by this code: .PP .Vb 5 \& [either] \& [scratch page_banner] \& [or] \& [scratch page_title] \& [/either] .Ve This results in the page banner being displayed if defined. Otherwise, the page title is used. .PP \&\fBLines 17\-20:\fR Members Only .PP .Vb 4 \& 17 members_only: \& 18 options: 1=Yes,0=No* \& 19 widget: radio \& 20 description: Members only .Ve This creates a radio-button form element on the Edit Page with the user can specify whether the page can be accessed if a visitor is logged in (Yes) or not (No). The default is indicated by an asterisk. .PP The scratch variable members_only is assigned by the \s-1ITL\s0 code .PP .Vb 1 \& 56 [set members_only][set] .Ve and set on the new page using the tag .PP .Vb 1 \& [set members_only]0[/set] .Ve if the page can be accessed without logging in or .PP .Vb 1 \& [set members_only]1[/set] .Ve if it can not. .PP The members_only function is handled by the following code within each region template file: .PP .Vb 7 \& [if scratch members_only] \& [set members_only][/set] \& [if !session logged_in] \& [set mv_successpage]@@MV_PAGE@@[/set] \& [bounce page=login] \& [/if] \& [/if] .Ve This code says that if \*(L"members only\*(R" is set to yes, and the visitor is logged in, to display the page. Otherwise, redirect the visitor to the login page. .PP \&\fBLines 22\-23:\fR Break .PP .Vb 2 \& 22 break1: \& 23 widget: break .Ve Another separation line. .PP \&\fBLines 25\-28:\fR Horizontal Before Component .PP .Vb 8 \& 25 component_before: \& 26 options: =none, best_horizontal=Best Sellers, \e \& cross_horizontal=Cross sell, \e \& promo_horizontal=Promotion, \e \& random_horizontal=Random items, \e \& upsell_horizontal=Upsell \& 27 widget: select \& 28 description: Component before content .Ve This allows the inclusion of a defined component (included in the CATROOT/templates/components directory) to be displayed before, or above, the page's content. It provides a pull-down menu on the Edit Page displaying the available components. The components, identified here on line 26, can be assigned a name via the value=name convention. .PP The scratch variable component_before is assigned in the template definition file by the \s-1ITL\s0 code .PP .Vb 1 \& 57 [set component_before][set] .Ve It is called with the following code within the \s-1LEFTRIGHT_TOP\s0, \&\s-1LEFTONLY_TOP\s0, and \s-1NOLEFT_TOP\s0 region templates: .PP .Vb 3 \& [if scratch component_before] \& [include file="templates/components/[scratch component_before]"] \& [/if] .Ve \&\fBLines 30\-33:\fR Horizontal After Component .PP .Vb 8 \& 30 component_after: \& 31 options: =none, best_horizontal=Best Sellers, \e \& cross_horizontal=Cross sell, \e \& promo_horizontal=Promotion, \e \& random_horizontal=Random items, \e \& upsell_horizontal=Upsell \& 32 widget: select \& 33 description: Component after content .Ve Similar to component_before, this allows the inclusion of a defined component after, or below, the page's content. .PP The scratch variable component_before is assigned in the template definition file by the \s-1ITL\s0 code .PP .Vb 1 \& 58 [set component_after][set] .Ve It is called with the following code within the \s-1LEFTRIGHT_BOTTOM\s0 and \&\s-1LEFTONLY_BOTTOM\s0 region templates: .PP .Vb 3 \& [if scratch component_after] \& [include file="templates/components/[scratch component_after]"] \& [/if] .Ve \&\fBLines 35\-38:\fR Horizontal Item Width .PP .Vb 4 \& 35 component_hsize: \& 36 options: 1,2,3* \& 37 widget: select \& 38 description: Component items horizontal .Ve This setting allows you to choose how many items the horizontal components display. For example, the horizontal best sellers component (\*(L"best_horizontal\*(R") uses this setting to randomly select the best sellers. Notice the default is 3 if nothing is defined. It is called by the following code in the promo_horizontal and random_horizontal components in the Foundation demo. .PP .Vb 1 \& random="[either][scratch component_hsize][or]2[/either]" .Ve \&\fBLines 40\-45:\fR Before/After Banner .PP .Vb 9 \& 40 hbanner: \& 41 options: =--custom--, Also see..., Best Sellers, \e \& New items, \e \& Some of our fine products, \e \& Specials, You might also like \& 42 widget: move_combo \& 43 width: 40 \& 44 description: Before/after Banner \& 45 help: Banner for Before/after component .Ve Allows a title for the horizontal components to be defined to be displayed in a header above the component's items. It is called with the [scratch hbanner] tag and used in the Foundation demo in the random_horizontal component. .PP \&\fBLines 47\-51:\fR Special Tag .PP .Vb 5 \& 47 hpromo_type: \& 48 options: specials=Specials, new=New items \& 49 widget: select \& 50 description: Special tag \& 51 help: Only for a horizontal Promotion .Ve This setting is only viable when a promotion is used for a horizontal component. It tells the promotional component which \fIrow\fR\|(s) to evaluate in the merchandising table for display within the component. This setting, used in the promo_horizontal component, typically correlates to the featured column of the merchandising table as follows: .PP .Vb 7 \& [query arrayref=main \& sql=" \& SELECT sku,timed_promotion,start_date,finish_date \& FROM merchandising \& WHERE featured = '[scratch hpromo_type]' \& "] \& [/query] .Ve .Sh "Edit Page Function" .IX Subsection "Edit Page Function" Creating a page with the following specifications using the Edit Page function results in the \s-1HTML\s0 and \s-1ITL\s0 code displayed below. .PP \&\fBSpecifications:\fR .PP .Vb 10 \& Template: Page with top/left areas. \& Page title: test \& Page banner: test \& Members only: No \& Component before content: Best Sellers \& Component after content: Random items \& Component items horizontal: 3 \& Before/after Banner: New items \& Special tag: Specials \& Content:

My first HTML/ITL page! .Ve \&\fBResulting code:\fR .PP .Vb 4 \& [comment] \& ui_template: Yes \& ui_template_name: leftonly \& [/comment] .Ve .Vb 9 \& [set hbanner]New items[/set] \& [set page_title]test[/set] \& [set hpromo_type]specials[/set] \& [set component_hsize]3[/set] \& [set page_banner]test[/set] \& [set members_only]0[/set] \& [set component_before]best_horizontal[/set] \& [set component_after]random_horizontal[/set] \& @_LEFTONLY_TOP_@ .Ve .Vb 3 \& \&

My first HTML/ITL page! \& .Ve .Vb 1 \& @_LEFTONLY_BOTTOM_@ .Ve An important point demonstrated here is the inclusion of the region templates \s-1LEFTONLY_TOP\s0 and \s-1LEFTONLY_BOTTOM\s0 through the \&\f(CW@_VARIABLE_NAME_\fR@ notation. These are included because of line 4 of the leftonly template definition file: .PP .Vb 1 \& 4 ui_template_layout: LEFTONLY_TOP, UI_CONTENT, LEFTONLY_BOTTOM .Ve However, understand that you are free to change the region templates used in the file by editing the file itself or, better yet, using an existing region as a starting point for a region of your own design. .PP The next section explains the structure of region templates. .Sh "Region Templates" .IX Subsection "Region Templates" Interchange region templates (or \*(L"regions\*(R") are portions of \s-1HTML\s0 and \&\s-1ITL\s0 that are included in pages within a catalog. Using regions, along with the cascading style sheet defined in theme.cfg, allows you to control the look and feel of specific parts of each catalog page. .PP The default Foundation region set, found in CATROOT/templates/foundation/regions, includes the following: .PP .Vb 6 \& LEFTONLY_TOP \& LEFTONLY_BOTTOM \& LEFTRIGHT_TOP \& LEFTRIGHT_BOTTOM \& NOLEFT_TOP \& NOLEFT_BOTTOM .Ve The Foundation demo uses the Variable feature extensively to simplify hand page editing. Basically, a Variable is a define that permits the substitution of text for a simple _\|_VARIABLE_\|_ string in a page. For example, in the test page above, the variables \s-1LEFTONLY_TOP\s0 and \&\s-1LEFTONLY_BOTTOM\s0 correspond to region templates that provide a logobar, menubar, leftside menu, and copyright footer. Content, consisting of \&\s-1HTML\s0 and \s-1ITL\s0, is placed within the \s-1BEGIN\s0 and \s-1END\s0 \s-1CONTENT\s0 comments. The following illustration shows how this looks on the page: .PP .Vb 15 \& +--------------------------------------------------------+ \& | LOGOBAR | \& |--------------------------------------------------------+ \& | MENUBAR | \& |--------------+-----------------------------------------+ \& | | | \& | | | \& | | | \& | LEFTSIDE | This is your content | \& | | | \& | | | \& | | | \& | +-----------------------------------------| \& | | COPYRIGHT | \& +--------------------------------------------------------+ .Ve In this diagram, \s-1LEFTONLY_TOP\s0 contributes the \s-1LEFTSIDE\s0, \s-1LOGOBAR\s0, and \&\s-1MENUBAR\s0 sections, while \s-1LEFTONLY_BOTTOM\s0 contributes the \s-1COPYRIGHT\s0 section. .PP The following subsections provide an inventory of where each of the region templates, included with the Foundation demo, are used in the pages and template definition files that make up the catalog. .PP \&\s-1LEFTONLY_TOP\s0 .PP The \s-1LEFTONLY_TOP\s0 template region is used in the following template pages: .PP .Vb 27 \& pages/aboutus.html \& pages/account.html \& pages/affiliate/index.html \& pages/affiliate/login.html \& pages/canceled.html \& pages/contact.html \& pages/customerservice.html \& pages/flypage.html \& pages/help.html \& pages/login.html \& pages/logout.html \& pages/modular_modify.html \& pages/new_account.html \& pages/ord/basket.html \& pages/privacypolicy.html \& pages/process_return.html \& pages/quantity.html \& pages/query/check_orders.html \& pages/query/order_detail.html \& pages/query/order_return.html \& pages/returns.html \& pages/saved_carts.html \& pages/ship_addresses.html \& pages/ship_addresses_added.html \& pages/ship_addresses_removed.html \& pages/stock-alert-added.html \& pages/stock-alert.html .Ve The \s-1LEFTONLY_TOP\s0 template region is used in the following templates: .PP .Vb 3 \& templates/foundation/cart \& templates/foundation/leftonly \& templates/foundation/simple .Ve Region Template Walkthrough \*(-- \s-1LEFTONLY_TOP\s0 .PP .Vb 76 \& 1 \& 2 [if scratch members_only] \& 3 [set members_only][/set] \& 4 [if !session logged_in] \& 5 [set mv_successpage]@@MV_PAGE@@[/set] \& 6 [bounce page=login] \& 7 [/if] \& 8 [/if] \& 9 \&10 \&11 \&12 [scratch page_title] \&13 __THEME_CSS__ \&14 \&15 \&16 \&17 \&18 \&19 \&20 \&21 \&24 \&27 \&28
\&22   \&23 \&25   \&26
\&29 \&30 \&31 \&32 \&33 \&52 \&53
\&34 \e \& \&35 \&36 \&37 [if session logged_in] \&38 Log Out \&39 [else] \&40 Log In \&41 [/else] \&42 [/if] \&43 \&44 \& Your Cart \&45 \&46 \e \& Check Out\e \& \&47 \&48 \& Customer Service \&49 \&50 \& About Us \&51
\&54 \&55 \&56 \&57 \&58 \&66 \& 77 \& 78 .Ve Lines 47\-78 generate a list of links based on the products and product categories identified in the search. .PP cross_horizontal .PP The cross_horizontal component is used in the following pages: .PP .Vb 4 \& pages/browse.html \& pages/index.html \& pages/results.html \& pages/results_big.html .Ve The cross_horizontal component is used in the following templates: .PP .Vb 3 \& templates/foundation/cart \& templates/foundation/leftonly \& templates/foundation/leftright .Ve cross_vertical .PP Not used in Foundation demo pages. .PP The cross_horizontal component is used in the following templates: .PP .Vb 1 \& templates/foundation/leftright .Ve modular_buy .PP The modular_buy component is used in the following pages: .PP .Vb 1 \& pages/flypage.html .Ve The modular_buy component is used in the following templates: .PP .Vb 1 \& templates/components/modular_update .Ve modular_update .PP The modular_update component is used in the following pages: .PP .Vb 1 \& pages/modular_modify.html .Ve promo .PP The promo component is used in the following pages: .PP .Vb 2 \& pages/contact.html \& pages/results_big.html .Ve promo_horizontal .PP The promo_horizontal component is used in the following pages: .PP .Vb 2 \& pages/aboutus.html \& pages/canceled.html .Ve The promo_horizontal component is used in the following templates: .PP .Vb 3 \& templates/foundation/cart \& templates/foundation/leftonly \& templates/foundation/leftright .Ve promo_vertical .PP Not used in Foundation demo pages. .PP The promo_horizontal component is used in the following templates: .PP .Vb 1 \& templates/foundation/leftright .Ve random .PP The random component is used in the following pages: .PP .Vb 7 \& pages/browse.html \& pages/index.html \& pages/ord/basket.html \& pages/privacypolicy.html \& pages/process_return.html \& pages/results.html \& pages/swap_results.html .Ve random_horizontal .PP Not used in Foundation demo pages. .PP The random_horizontal component is used in the following templates: .PP .Vb 3 \& templates/foundation/cart \& templates/foundation/leftonly \& templates/foundation/leftright .Ve random_vertical .PP Not used in Foundation demo pages. .PP The random_vertical component is used in the following templates: .PP .Vb 1 \& templates/foundation/leftright .Ve saved_carts_list_small .PP The saved_carts_list_small component is used in the following pages: .PP .Vb 1 \& pages/ord/basket.html .Ve search_box_small .PP The search_box_small component is used in the following pages: .PP .Vb 30 \& pages/aboutus.html \& pages/account.html \& pages/affiliate/index.html \& pages/affiliate/login.html \& pages/browse.html \& pages/canceled.html \& pages/contact.html \& pages/customerservice.html \& pages/flypage.html \& pages/help.html \& pages/index.html \& pages/login.html \& pages/logout.html \& pages/modular_modify.html \& pages/new_account.html \& pages/ord/basket.html \& pages/privacypolicy.html \& pages/process_return.html \& pages/quantity.html \& pages/query/check_orders.html \& pages/query/order_detail.html \& pages/query/order_return.html \& pages/results.html \& pages/results_big.html \& pages/returns.html \& pages/saved_carts.html \& pages/ship_addresses.html \& pages/stock-alert-added.html \& pages/stock-alert.html \& pages/swap_results.html .Ve The search_box_small component is used in the following templates: .PP .Vb 2 \& templates/regions/LEFTONLY_TOP \& templates/regions/LEFTRIGHT_TOP .Ve upsell .PP Not used in Foundation demo pages. .PP upsell_horizontal .PP The upsell_horizontal component is used in the following pages: .PP .Vb 1 \& pages/flypage.html .Ve The upsell_horizontal component is used in the following templates: .PP .Vb 3 \& templates/foundation/cart \& templates/foundation/leftonly \& templates/foundation/leftright .Ve upsell_vertical .PP Not used in Foundation demo pages. .PP The upsell_vertical component is used in the following templates: .PP .Vb 1 \& templates/foundation/leftright .Ve .SH "The Database Tables" .IX Header "The Database Tables" Interchange catalogs are centralized around the database. You can alter any of the standard databases, add new databases, or remove unneeded databases .PP The foundation catalog includes the following tables, organized here by content: .Ip "\(bu" 4 Your site content data .RS 4 .Ip "" 8 area.txt .Sp cat.txt .Sp downloadable.txt .Sp merchandising.txt .Sp options.txt .Sp pricing.txt .Sp products.txt .RE .RS 4 .RE .Ip "\(bu" 4 Customer data .RS 4 .Ip "" 8 access.asc .Sp gift_certs.txt .Sp userdb.txt .RE .RS 4 .RE .Ip "\(bu" 4 Transaction-related data .RS 4 .Ip "" 8 inventory.txt .Sp orderline.txt .Sp order_returns.txt .Sp transactions.txt .RE .RS 4 .RE .Ip "\(bu" 4 Third-party relationship data .RS 4 .Ip "" 8 affiliate.txt .Sp banner.txt .RE .RS 4 .RE .Ip "\(bu" 4 Site administrative data .RS 4 .Ip "" 8 component.txt .Sp files.txt .Sp ichelp.txt .Sp icmenu.txt .Sp locale.txt .Sp mv_metadata.asc .Sp route.txt .Sp shipping.asc .Sp variable.txt .RE .RS 4 .RE .Ip "\(bu" 4 Shipping and tax .RS 4 .Ip "" 8 2ndDayAir.csv .Sp 450.csv .Sp country.txt .Sp Ground.csv .Sp NextDayAir.csv .Sp salestax.asc .Sp state.txt .RE .RS 4 .RE .PP You may also see symbolic links pointing to index tables, for example products.category.txt linking to products.txt.10. These are automatically generated indexes, in this case into the products table to speed category searches. See \fIDictionary Indexing With \s-1INDEX\s0\fR in the database documentation for details about auto-indexing of text databases. .PP The following dictionary lists and describes each table used in the Foundation demo. .Sh "2ndDayAir.csv" .IX Subsection "2ndDayAir.csv" Shipping table from \s-1UPS\s0 (http://www.ups.com/using/services/rave/rate/). This and all shipping tables should be updated periodically. .Sh "450.csv" .IX Subsection "450.csv" Shipping table from \s-1UPS\s0 for 450xx Zip Code origin. You will probably need to get your own from the \s-1UPS\s0 site (http://www.ups.com/using/services/rave/rate/) and clip the headers. .Sh "Ground.csv" .IX Subsection "Ground.csv" Shipping table from \s-1UPS\s0 (http://www.ups.com/using/services/rave/rate/). .Sh "NextDayAir.csv" .IX Subsection "NextDayAir.csv" Shipping table from \s-1UPS\s0 (http://www.ups.com/using/services/rave/rate/). .Sh "access.asc" .IX Subsection "access.asc" Administrative access table. This table is used by the Administration Tool. For more description on these fields, see the Interchange Administration Tool guide. .PP \&\fBFields\fR .PP .Vb 22 \& Field Description \& username Login name or group name (group names begin with ':') \& password Hashed password \& name Administrator's name \& last_login Last login time \& super Set to 1 if superuser \& yes_tables Tables the user may edit \& no_tables Tables the user may not edit \& upload No Description \& acl No Description \& export No Description \& edit No Description \& pages No Description \& files No Description \& config No Description \& reconfig No Description \& groups Administrator's group memberships \& meta No Description \& no_functions Explicitly disallowed functions \& yes_functions Allowed functions with permission flags \& table_control No Description \& personal_css Administrator's personal CSS (for admin screen presentation) .Ve \&\fIusername\fR .PP Example Data .PP .Vb 5 \& :ausers \& :busers \& BigUser \& goody \& ic .Ve The login name for an administrator or an administration group. Group names are prefixed with a colon (':'). .PP \&\fIpassword\fR .PP Example Data .PP .Vb 1 \& Ksjs65bMNLjPQ .Ve Hashed password. .PP \&\fIname\fR .PP Example Data .PP .Vb 6 \& Interchange Site Administrator \& Interchange Site Associates \& Business Users \& 2nd Shift \& Mr. Jones \& Inbound Sales .Ve Descriptive name for the administrator or administration group. .PP \&\fIlast_login\fR .PP Example Data .PP .Vb 1 \& 989424489 .Ve Last login time (in unix \fItime()\fR format). .PP \&\fIsuper\fR .PP Boolean value. If true (1), the administrator has Interchange Site Administrator privilege. .PP \&\fIyes_tables\fR .PP Example Data .PP .Vb 2 \& affiliate=vcx component=v gift_certs=v inventory=vx ... \& NONE .Ve Tables this administrator or administration group can access. This is a space-delimited list of 'table_name=permission_flags' entries. .PP \&\fIno_tables\fR .PP Example Data .PP .Vb 1 \& access mv_metadata variable .Ve Tables this administrator or administration group can not use. This is a space-delimited list of tables names. .PP \&\fIupload\fR .PP No Description .PP \&\fIacl\fR .PP No Description .PP \&\fIexport\fR .PP No Description .PP \&\fIedit\fR .PP No Description .PP \&\fIpages\fR .PP No Description .PP \&\fIfiles\fR .PP No Description .PP \&\fIconfig\fR .PP No Description .PP Example Data .PP Allowed Values .PP \&\fIreconfig\fR .PP No Description .PP \&\fIgroups\fR .PP Example Data .PP .Vb 2 \& ausers \& busers .Ve Allowed Values .PP Groups the site user belongs to. You can set permissions for groups. .PP \&\fImeta\fR .PP No Description .PP \&\fIno_functions\fR .PP Example Data .PP .Vb 1 \& orderstats trafficstats .Ve Space-delimited list of functions explicitly not allowed for the site user. .PP \&\fIyes_functions\fR .PP Example Data .PP .Vb 2 \& item=lvecd itemtype=lvc order=lvca orderstats trafficstats ... \& NONE .Ve Functions the site user can perform. This is a space-delimited list of functions, with permission flags if appropriate. .PP Usage examples .Ip "\(bu" 4 dist/lib/UI/pages/admin/access_permissions.html .PP \&\fItable_control\fR .PP No Description .PP Usage examples .Ip "\(bu" 4 dist/lib/UI/Primitive.pm .Ip "\(bu" 4 dist/lib/UI/pages/admin/special/key_violation.html .Ip "\(bu" 4 dist/lib/UI/usertag/if_mm .PP \&\fIpersonal_css\fR .PP Used in the Administration Tool screens to make personal changes to the page presentation. This is done by creating your own personal \s-1CSS\s0 (cascading style sheet). .PP Usage examples .Ip "\(bu" 4 dist/lib/UI/pages/admin/preferences.html .Sh "affiliate" .IX Subsection "affiliate" cat_root/products/affiliate.txt .PP This table contains data related to your affiliate programs. See also the \fIaffiliate_receptor\fR component. .PP \&\fBFields\fR .PP .Vb 11 \& Field Description \& affiliate Affiliate ID \& name Name of affiliate organization \& campaigns Campaigns this affiliate participates in \& coupon_amount Discount for customers from affiliate participating in coupon campaign \& join_date When the affiliate signed with you \& url Your default URL to use for customers coming from the affiliate site (not the affiliate's home page) \& timeout Timeout in seconds after which purchases are no longer credited to the affiliate \& active Boolean, set to 1 for active affiliates \& password Affiliate login password \& image Affiliate's logo .Ve \&\fIaffiliate\fR .PP Example Data .PP .Vb 2 \& consolidated \& hardhat .Ve This field contains the unique Affiliate \s-1ID\s0. .PP \&\fIname\fR .PP Example Data .PP .Vb 2 \& Consolidated Diversified \& Hardhat Construction .Ve This is the descriptive name of the affiliate. .PP \&\fIcampaigns\fR .PP Example Data .PP .Vb 1 \& coupon .Ve This field lists the campaigns that the affiliate participates and enables campaign features and tracks traffic from advertising campaigns. The foundation catalog implements a coupon campaign in the affiliate_receptor component. If you want to add campaigns, you will also need to develop the appropriate logic within the affiliate_receptor component and pages that use it. .PP \&\fIcoupon_amount\fR .PP Example Data .PP .Vb 1 \& 5 .Ve This is the discount offered customers from the affiliate participating in the coupon campaign. .PP Note \*(-- This is implemented in the affiliate_receptor component as a flat discount amount. If you wanted a percentage discount instead, you would modify the [discount] tag in catalog_root/templates/components/affiliate_receptor (see the [discount] tag for more detail). .PP \&\fIjoin_date\fR .PP Example Data .PP .Vb 2 \& 20000827 \& 20000910 .Ve This is the date when the affiliate signed with you. .PP \&\fIurl\fR .PP Example Data .PP .Vb 2 \& http://demo.akopia.com/~hardhat \& http://www.minivend.com/consolidated/ .Ve The value in this field is used to direct visitors coming from the Affiliate to your home page or a page you have designed specifically for visitors from that Affiliate's site. Note that this should \fInot\fR be the \s-1URL\s0 of the Affiliate's home site. .PP \&\fItimeout\fR .PP Example Data .PP .Vb 2 \& 0 \& 3600 .Ve The value in this field is used to specify the amount of time a customer has to place an order to still give the Affiliate credit for it. If the customer goes over this amount of time, the Affiliate doesn't get credit for the customer visit. The timeout delay is measured in seconds, with the value of 0 (zero) disabling it. It is recommended that you use a value in the thousands to make sure the customer has enough time to shop. .PP \&\fIactive\fR .PP This is a boolean value indicating whether the affiliate is active. .PP \&\fIpassword\fR .PP Example Data .PP .Vb 1 \& akopia .Ve Password for affiliate login (see catalog_root//pages/affiliate/login.html). Note that the password is stored in plaintext by default. .PP \&\fIimage\fR .PP Example Data .PP .Vb 2 \& http://demo.akopia.com/~hardhat/images/logo.gif \& http://www.minivend.com/consolidated/conslogo.gif .Ve Affiliate's logo image. .Sh "area" .IX Subsection "area" cat_root/products/area.txt .PP This table is used to implement dynamic navigation bars. For example, it is used in the category_horizontal and category_vertical components. Note the similarity to the \fBcat\fR table, since both \&\fBarea\fR and \fBcat\fR tables supply data for building links to results pages. .PP When building entries in a navigation bar, it is the \fBbar_link\fR subroutine in the /dist/catalog_before.cfg configuration file that actually reads and processes the values from the table. .PP See also the following catalog and administrative templates: .Ip "\(bu" 4 cat_root/templates/components/category_horizontal .Ip "\(bu" 4 cat_root/templates/components/category_vertical .Ip "\(bu" 4 dist/lib/UI/pages/admin/layout.html .Ip "\(bu" 4 dist/lib/UI/pages/admin/layout_auto.html .Ip "\(bu" 4 dist/lib/UI/pages/admin/wizard/do_launch.html .Ip "\(bu" 4 dist/lib/UI/pages/admin/wizard/do_save.html .PP \&\fBFields\fR .PP .Vb 18 \& Field Description \& code Unique key \& sel Space-delimited list of navigation bars to contain the entry \& name Display label \& which_page Page class in which the navigation bar may appear \& sort Sorting prefix for entry (preempts standard alphanumeric sort) \& display_type How to label links in the navbar (name, icon, url or image) \& image Image URL (if appropriate) \& image_prop HTML attributes for output tag (if appropriate) \& banner_image Image name for use in target page \& banner_text Text for use in target page \& link_type Type of links in the navbar (external, internal, simple, complex) \& url Target for internal or external link_type \& Database table file to use with 'simple' link_type \& page Results page to use with 'simple' link_type \& search Search spec used with 'complex' link_type \& selector The selector used to scan the products table for products in the category \& link_template Overrides template used for building navbar links. .Ve \&\fIcode\fR .PP Example Data .PP .Vb 3 \& 1 \& 2 \& 3 .Ve Unique key. .PP \&\fIsel\fR .PP Example Data .PP .Vb 1 \& left .Ve Space-delimited list of navigation bars that should contain the entry. Note that comma or null should also work as a delimiter. .PP \&\fIname\fR .PP Example Data .PP .Vb 8 \& Hand Tools \& Hardware \& Ladders \& Measuring Tools \& Painting Supplies \& Safety Equipment \& Specials \& Tool Storage .Ve Label to display. .PP \&\fIwhich_page\fR .PP Example Data .PP .Vb 1 \& all .Ve Page class in which the navigation bar may appear. .PP \&\fIsort\fR .PP Example Data .PP .Vb 5 \& 00 \& 03 \& 04 \& 05 \& 06 .Ve Lexographic (alphanumeric) sorting prefix. Note use of '03' rather than '3', which would sort after '13'. This controls the order of the categories in your navigation bar. .PP If this is not set, your navbar entries will sort in alphabetical order. .PP \&\fIdisplay_type\fR .PP Example Data .PP .Vb 4 \& name \& icon \& url \& image .Ve What to use for the labels in the navigation bar (for example, name, icon, url or image). The navigation bars in the foundation catalog are set up with 'name' display_type. .PP .Vb 5 \& display type Link shown as \& name Displays name only \& icon Displays name and specified image \& image Displays image only \& url Displays link .Ve \&\fIimage\fR .PP Image \s-1URL\s0 for image or icon \fBdisplay_type\fR. .PP \&\fIimage_prop\fR .PP For image or icon \fBdisplay_type\fR, this contains the \s-1HTML\s0 attributes for the \s-1HTML\s0 that will appear in the navbar, for example: .PP .Vb 1 \& namename .Ve \&\fIbanner_image\fR .PP Example Data .PP .Vb 1 \& promo_image.gif .Ve This field is not related to banner ads. It is useful if you want to pass to your results page an image that is specific for the navbar entry (perhaps to display a banner above your results). .PP If you are using an Interchange search for your links (i.e., 'simple' or 'complex' \fBlink_type\fR), then this will add \&'va=banner_image=\fBbanner_image\fR' to the resulting search specification. This puts the contents of \fBbanner_image\fR into the Values hash of your search results page. You can access it with [value banner_image] (see the value tag). You will have to modify the standard results page (or set up and specify your own) in order to display the image. .PP .Vb 1 \& [value banner_text] .Ve The foundation catalog does not implement banner_image in the preconfigured navigation bars. .PP \&\fIbanner_text\fR .PP Example Data .PP .Vb 1 \& This Is A Title For Hand Tools .Ve This field is not related to banner ads. It is useful if you want to pass to your results page some text that is specific for the navbar entry (perhaps to display a title above your results). .PP If you are using an Interchange search for your links (i.e., 'simple' or 'complex' \fBlink_type\fR), then this will add \&'va=banner_text=\fBbanner_text\fR' to the resulting search specification. This puts the contents of \fBbanner_text\fR into the Values hash of your search results page. You can access it with [value banner_text] (see the value tag). You will have to modify the standard results page (or set up and specify your own) in order to display the text. .PP The foundation catalog does not implement banner_text in the preconfigured navigation bars. .PP \&\fIlink_type\fR .PP Example Data .PP .Vb 5 \& none \& external \& internal \& simple \& complex .Ve Link type to create in the navigation bar. .PP .Vb 6 \& Link type Description \& none No link \& external External link. The HTML specified in url will go directly into the navigation bar. \& internal Internal link. This will be highlit if it is the current page. If you specify both a page and a form for the link, the url field should contain "page form". See the Search Engine documentation for more detail on search forms. \& simple Allows you to specify an Interchange search with a few values. See the bar_link subroutine in the /dist/catalog_before.cfg configuration file for more detail. \& complex Allows you to fully specify an Interchange search specification. See the bar_link subroutine in the /dist/catalog_before.cfg configuration file for more detail if you need to use these. .Ve \&\fIurl\fR .PP Target \s-1URL\s0 (external link or internal page/search specification). See \&\fBlink_type\fR . The foundation catalog navigation bars are not set up with link types that use the \fBurl\fR field. .PP \&\fItab\fR .PP Database table file to use with 'simple' \fBlink_type\fR (searchspec fi=\fBtab\fR). The foundation catalog navigation bars are not set up with link types that use the \fBtab\fR field. .PP \&\fIpage\fR .PP Results page to use with 'simple' \fBlink_type\fR (searchspec sp=\fBpage\fR). The foundation catalog navigation bars are not set up with link types that use the \fBpage\fR field. .PP \&\fIsearch\fR .PP Search spec used with 'complex' \fBlink_type\fR. See the Search Engine documentation for more detail on search forms. The foundation catalog navigation bars are not set up with link types that use the \fBsearch\fR field. .PP \&\fIselector\fR .PP The selector that is used to scan the products table for products in the category. Used with 'simple' \fBlink_type\fR. The foundation catalog navigation bars are not set up with link types that use the \&\fBselector\fR field. .PP \&\fIlink_template\fR .PP Overrides the usual \s-1HTML\s0 link template for navbar entries. See the \&\fBbar_link\fR subroutine in the /dist/catalog_before.cfg configuration file if you need to modify link templates. .PP The foundation catalog navigation bars are not set up with link types that use the \fBlink_template\fR field. .Sh "banner" .IX Subsection "banner" cat_root/products/banner.txt .PP The banner ad table. The foundation catalog does not implement any banner ads with this table. .PP You do not need to use this table to display ads served by third parties (for example, doubleclick). Since most banner ads on the internet are served by third parties and are not managed by your catalog, you probably will not need to set up banners here unless you do your own advertising. .PP See \fIBanner/Ad rotation\fR in the template documentation for a detailed description of the columns and content of the banner table. Also, see the banner tag documentation. .PP \&\fBFields\fR .PP .Vb 6 \& Field Description \& code Key for the item. If the banners are not weighted, this should be a category-specific code. \& category Category for set of weighted banners \& weight Display frequency weight for weighted banner \& rotate Boolean: parse banner field for banners to rotate if true (1) \& banner Banner name or list of banners to rotate .Ve \&\fIcode\fR .PP Example Data .PP .Vb 4 \& MyBanner \& MyBanner2 \& MyBanner3 \& default .Ve See \fIBanner/Ad rotation\fR. .PP \&\fIcategory\fR .PP Example Data .PP .Vb 1 \& BannerCat1 .Ve See \fIBanner/Ad rotation\fR. .PP \&\fIweight\fR .PP Example Data .PP .Vb 3 \& 1 \& 2 \& 7 .Ve See \fIBanner/Ad rotation\fR. .PP \&\fIrotate\fR .PP Boolean value. If true (1), rotates banners listed in \fBbanner\fR. See \&\fIBanner/Ad rotation\fR. .PP \&\fIbanner\fR .PP Example Data .PP .Vb 4 \& Default banner 1{or}Default banner 2{or}Default banner 3 \& First MyBanner \& Second MyBanner \& Third MyBanner .Ve See \fIBanner/Ad rotation\fR. .Sh "cat" .IX Subsection "cat" cat_root/products/cat.txt .PP This table contains properties of product categories. Notice the similarity to the \fBarea\fR table, since both the \fBarea\fR and \fBcat\fR tables supply data for building links to results pages. .PP \&\fBFields\fR .PP .Vb 18 \& Field Description \& code Unique key \& sel Space-delimited list of foreign keys into area table \& name Category name \& which_page Page class in which the category may appear \& sort Sorting prefix for entry (preempts standard alphanumeric sort) \& display_type How to label the category links (name, icon, url or image) \& image Image URL (if appropriate) \& image_prop HTML attributes for output tag (if appropriate) \& banner_image Image name for use in target page \& banner_text Text for use in target page \& link_type Type of links in the navbar (external, internal, simple, complex) \& url Target for internal or external link_type \& Database table file to use with 'simple' link_type \& page Results page to use with 'simple' link_type \& search Search spec used with 'complex' link_type \& selector The selector used to scan the products table for products in the category \& link_template Overrides template used for building links .Ve \&\fIcode\fR .PP Example Data .PP .Vb 3 \& 1 \& 4 \& 5 .Ve Unique key. .PP \&\fIsel\fR .PP Example Data .PP .Vb 3 \& 6 \& 8 9 \& 9 .Ve Space-delimited list of foreign \fIkey\fR\|(s) into \fBarea\fR table. The category will appear in each navbar section (defined by a row in the \&\fBarea\fR table) where the key from \fBcat.sel\fR matches the \fBarea.code\fR. .PP For example, the foundation catalog (tools) places Gift Certificates in more than one category of the left navbar. .PP \&\fIname\fR .PP Example Data .PP .Vb 8 \& Breathing Protection \& Eye Protection \& Gift Certificate \& Picks & Hatchets \& Pliers \& Rulers \& Sandpaper \& Toolboxes .Ve Category name for display. .PP \&\fIwhich_page\fR .PP The page class. When building links, you can select categories matching a page class. This means you could set up your catalog to show a different list of links on page 'foo.html' than on page \&'bar.html'. .PP \&\fIsort\fR .PP Example Data .PP .Vb 2 \& 01 \& 03 .Ve Lexographic (alphanumeric) sorting prefix. Notice use of '03' rather than '3', which would sort after '13'. You can use this to control the order of the categories in a list of links. .PP \&\fIdisplay_type\fR .PP Example Data .PP .Vb 4 \& name \& icon \& url \& image .Ve What to use for the labels in the navigation bar (for example, name, icon, url or image). The links in the foundation catalog are set up with 'name' display_type. .PP .Vb 5 \& display type Link shown as \& name Displays name only \& icon Displays name and specified image \& image Displays image only \& url Displays link .Ve \&\fIimage\fR .PP Image \s-1URL\s0 for image or icon \fBdisplay_type\fR. .PP \&\fIimage_prop\fR .PP For image or icon \fBdisplay_type\fR, this contains the \s-1HTML\s0 tag attributes for the links, for example: .PP .Vb 1 \& namename .Ve \&\fIbanner_image\fR .PP Example Data .PP .Vb 1 \& promo_image.gif .Ve This field is not related to banner ads. It is useful if you want to pass to your results page an image that is specific for the navbar entry (perhaps to display a banner above your results). .PP If you are using an Interchange search for your links (i.e., 'simple' or 'complex' \fBlink_type\fR), then this will add \&'va=banner_image=\fBbanner_image\fR' to the resulting search specification. This puts the contents of \fBbanner_image\fR into the Values hash in your search results page. You can access it with [value banner_image] (see the value tag). You will have to modify the standard results page (or set up and specify your own) in order to display the image. For example, you might include the following in your results page: .PP .Vb 1 \& [value banner_text] .Ve \&\fIbanner_text\fR .PP This field is not related to banner ads. It is useful if you want to pass to your results page some text that is specific for the navbar entry (perhaps to display a title above your results). .PP If you are using an Interchange search for your links (i.e., 'simple' or 'complex' \fBlink_type\fR), then this will add \&'va=banner_text=\fBbanner_text\fR' to the resulting search specification. This puts the contents of \fBbanner_text\fR into the Values hash in your search results page. You can access it with [value banner_text] (see the value tag). You will have to modify the standard results page (or set up and specify your own) in order to display the text. .PP \&\fIlink_type\fR .PP Example Data .PP .Vb 5 \& none \& external \& internal \& simple \& complex .Ve The link type to create. .PP .Vb 6 \& Link type Description \& none No link \& external External link. The HTML specified in url will go directly into the link. \& internal Internal link. This will be highlit if it is the current page. If you specify both a page and a form for the link, the url field should contain "page form". See the Search Engine documentation for more detail on search forms. \& simple Allows you to specify an Interchange search with a few values. See the bar_link subroutine in the /dist/catalog_before.cfg configuration file for more detail. \& complex Allows you to fully specify an Interchange search specification. See the bar_link subroutine in the /dist/catalog_before.cfg configuration file for more detail if you need to use these. .Ve \&\fIurl\fR .PP Target \s-1URL\s0 (external link or internal page/search specification). See \&\fBlink_types\fR above. .PP \&\fItab\fR .PP Example Data .PP .Vb 1 \& products .Ve Database table file to use with 'simple' \fBlink_type\fR (searchspec fi=\fBtab\fR). .PP \&\fIpage\fR .PP Example Data .PP .Vb 1 \& swap_results .Ve Results page to use with 'simple' \fBlink_type\fR (searchspec sp=\fBpage\fR). .PP \&\fIsearch\fR .PP Example Data .PP .Vb 2 \& fi=merchandising^Msf=featured^Mse=new \& fi=merchandising^Msf=featured^Mse=special^Msu=yes .Ve Search spec used with 'complex' \fBlink_type\fR. See the Search Engine documentation for more detail on search forms. .PP \&\fBNote: \fRThe '\fI^M\fR' delimiters in the sample data represents a carriage return character (Control-M, or hexadecimal 0x0d). .PP \&\fIselector\fR .PP Example Data .PP .Vb 8 \& category=Breathing Protection \& category=Eye Protection \& category=Gift Certificate \& category=Picks & Hatchets \& category=Pliers \& category=Rulers \& category=Sandpaper \& category=Toolboxes .Ve The element that is used to scan the products table for products in the category. Used with 'simple' \fBlink_type\fR. .PP \&\fIlink_template\fR .PP Overrides the usual \s-1HTML\s0 link template for navbar entries. See the \&\fBbar_link\fR subroutine in the /dist/catalog_before.cfg configuration file if you need to modify link templates. .Sh "country" .IX Subsection "country" A list of countries used to build select boxes, calculate tax, and set shipping mode choices based on the user's country. .PP .Vb 9 \& code Country code \& sorder Used to determine sort order \& region An enumerator to group based on region \& selector The code that should be used (same as code) \& shipmodes Shipping modes to be presented for that country \& name Textual name of the country \& iso ISO three letter code for the country \& isonum ISO numeric code for the country \& tax Tax information (may redirect to a state table) .Ve .Sh "downloadable" .IX Subsection "downloadable" This table controls downloadable products. The Marketing Reports data set for the foundation catalog demonstrates downloadable products. List a product's \fBsku\fR in this table if you want to deliver it through a download. A customer can then download the file specified in the \fBdl_location\fR field after checkout. .PP For reference, see the implementation in the following files: .Ip "\(bu" 4 catalog_root/pages/deliver.html .Ip "\(bu" 4 catalog_root/etc/receipt.html .Ip "\(bu" 4 catalog_root/pages/query/order_detail.html .PP \&\fBFields\fR .PP .Vb 4 \& Field Description \& sku Unique key, matches product.sku \& dl_location Location of downloadable file \& dl_type MIME type of downloadable file .Ve \&\fIsku\fR .PP Example Data .PP Example Data from the Marketing Reports data set: .PP .Vb 8 \& 00352as \& 22083da \& 49503cg \& 59330rt \& 59402fw \& 73358ee \& 83491vp \& 90773sh .Ve This is the unique key for this table that is also the common key into the products table. .PP \&\fIdl_location\fR .PP Example Data from 'reports' catalog .PP .Vb 8 \& download/00352as.pdf \& download/22083da.pdf \& download/49503cg.pdf \& download/59330rt.pdf \& download/59402fw.pdf \& download/73358ee.pdf \& download/83491vp.pdf \& download/90773sh.pdf .Ve File location of downloadable product. .PP \&\fIdl_type\fR .PP Example Data from 'reports' catalog .PP .Vb 1 \& application/pdf .Ve \&\s-1MIME\s0 type of downloadable content. .Sh "files" .IX Subsection "files" A database where files (pages, etc.) can be kept instead of in the Unix filesystem. Not normally used in foundation. .Sh "inventory.txt" .IX Subsection "inventory.txt" .Vb 3 \& sku Quantity info \& quantity Gets decremented after each sale. \& stock_message The usual shipping time of the product. Example choices: .Ve .Vb 4 \& In stock \& Ships in 3-5 days \& Ships in 4-6 weeks \& Special order .Ve .Vb 2 \& account Sales account for accounting links \& cogs_account Inventory account for accounting links .Ve .Sh "locale.txt" .IX Subsection "locale.txt" .Vb 4 \& code \& en_US \& de_DE \& fr_FR .Ve Used to develop localization. Can be used in conjunction with other types of locale information. See \fIInternationalization\fR. .Sh "merchandising.txt" .IX Subsection "merchandising.txt" .Vb 17 \& sku \& featured \& banner_text \& banner_image \& blurb_begin \& blurb_end \& Closer (end text for feature display) \& timed_promotion \& start_date \& Start date \& finish_date \& upsell_to \& Cross-sell SKUs \& cross_sell \& cross_category \& others_bought \& times_ordered .Ve .Sh "mv_metadata" .IX Subsection "mv_metadata" See the following sections in the icadvanced catalog for more information: .Ip "\(bu" 4 \&\fIdisplay tag and mv_metadata\fR .Ip "\(bu" 4 \&\fImv_metadata.asc\fR .Sh "options" .IX Subsection "options" This table contains data for implementing simple, matrix and modular options. .PP Simple options are options that a customer can combine arbitrarily, such as size and color. The selected options might affect price. See the accessories tag for more detail on option values for simple options. .PP Matrix options are preconfigured combinations of options. For example, if you sell titanium and carbon-fiber bike frames, but offer only certain combinations of frame material and color, your checkout page might include a select box with only the following entries: .Ip "\(bu" 4 Silver Titanium: \f(CW$1672\fR .Ip "\(bu" 4 Black Titanium: \f(CW$1672\fR .Ip "\(bu" 4 Red Titanium: \f(CW$1674\fR .Ip "\(bu" 4 Black Carbon Fiber: \f(CW$1290\fR .Ip "\(bu" 4 Yellow Flame Carbon Fiber: \f(CW$1300\fR .PP Note that there is no Yellow Flame Titanium offering, for example. .PP Modular options are like a structured bill of materials, where one product is a master item and other products are subitems for that master item. The subitems can also be master items to subitems at a lower level. In addition, subitems may be designated as 'phantom', which means that they are placeholders in the hierarchy of the structured bill of materials with their own subitems, but are not actual items themselves. .PP The foundation catalog with the computer data set uses modular options. .PP For more information, see the following pages and components in the foundation catalog: .Ip "\(bu" 4 cat_root/pages/flypage.html .Ip "\(bu" 4 cat_root/templates/components/modular_buy .Ip "\(bu" 4 cat_root/templates/components/modular_update .PP \&\fBNote: \fRSubsequent foundation catalog releases may place simple, matrix, and modular option types in separate tables. .PP \&\fBFields\fR .PP .Vb 27 \& Field Description \& code Unique ID for the product option \& o_master SKU of the master item for the option \& sku SKU for the option (foreign key into products table) \& o_group Product grouping code \& o_sort Sorting prefix for list display \& phantom Boolean - Item is a phantom placeholder (as in structured bill of materials) with suboptions. \& o_enable Boolean - enables suboptions for the option \& o_matrix Matrix-type option (preconfigured combinations of attributes) \& o_modular Modular-type option (master/subitem relationship like modular bill of materials) \& o_default Default selection for the option group or suboption for a phantom option \& o_label Short name for option display \& o_value Simple option values (in Interchange option format) \& o_widget The HTML widget to use for displaying the option group \& o_footer Not used in foundation catalog \& o_header Not used in foundation catalog \& o_height Height of widget (if applicable) \& o_width Width of widget \& description Option/Variant description (for description in display) \& price Price of this option/variant \& wholesale Dealer price of this option/variant \& differential Differential to add to the base item price when using a phantom bill of materials \& weight Weight difference with this option/variant (for shipping) \& volume Volume difference with this option/variant \& mv_shipmode No Description \& o_exclude Option groups to exclude (trumped by o_include). Modular only. \& o_include Option groups to include (trumps o_exclude). Modular only. .Ve \&\fIcode\fR .PP Example Data .PP .Vb 4 \& 1002 \& 1003 \& 1004 \& 1005 .Ve Unique \s-1ID\s0 for the option. .PP \&\fIo_master\fR .PP Example Data .PP .Vb 4 \& 00010 \& 999000 \& 999001 \& 999002 .Ve \&\s-1SKU\s0 of the master item for the option. The master item is one level up in the modular hierarchy, and must be one of the following: .Ip "\(bu" 4 An item in the products table (matching \fBproducts.sku\fR) .Ip "\(bu" 4 Another option in the options table (matching \fBoptions.sku\fR) .Ip "\(bu" 4 A \fIphantom\fR item in the \fBoptions\fR table. .PP If an option has a master item, then a customer can not choose that option without having previously selected the master item. .PP The price for a master item is the sum of the master item's price and the price for each of the subitems. Because the subitems are recursively defined, the top-level item reflects the top level price plus the price of all selected options. .PP \&\fIsku\fR .PP Example Data .PP .Vb 4 \& 00010 \& 999000 \& 7000015 \& 7000030 .Ve The sku for the item or option. This may not be unique for matrix options or if an option that belongs to multiple \fBo_master\fRs is listed for each master. .PP \&\fIo_group\fR .PP Example Data .PP .Vb 4 \& A \& B \& C \& I .Ve Product group (scanned to see whether it applies to this product or not) .PP \&\fIo_sort\fR .PP Example Data .PP .Vb 8 \& 01 \& 02 \& 03 \& 04 \& 47 \& 48 \& 49 \& 50 .Ve Sorting prefix for listing order of options. .PP \&\fIphantom\fR .PP Modular options only. .PP Boolean \- if true (1), then this is a phantom item acting as a placeholder for other items rather than an actual product. The item's \&\fBsku\fR will not match an entry in the products table, though the \&\fBo_master\fR will match either the \fBsku\fR of another phantom item in the \fBoptions\fR table or the \fBsku\fR of an item in the \fBproducts\fR table. .PP \&\fIo_enable\fR .PP Boolean \- Enables subitems for this item or option. Note that an option with \fBo_enable\fR false may itself still be a subitem for an option or item above it. .PP \&\fIo_matrix\fR .PP Boolean. Set true (1) for matrix-type options. See the options table in the tools data set for examples of matrix options. Matrix options that are part of a set have the same value for \fBoptions.sku\fR. .PP \&\fIo_modular\fR .PP Specifies a modular option. See main heading for description of modular options. .PP \&\fIo_default\fR .PP Example Data .PP .Vb 4 \& 1 \& 11002 \& 7000062 \& 7000087 .Ve Selects the default option for a group. .PP \&\fIo_label\fR .PP Example Data .PP .Vb 6 \& Add a second hard drive \& Case Color \& Case color \& Case style \& Include tapes \& Red .Ve This is the short name for option display. .PP \&\fIo_value\fR .PP Example Data .PP .Vb 7 \& 1=One 8GB tape,\er2=Two 8GB tapes,\er=None* \& a=One 8GB tape,\erb=Two 8GB tapes,\er=None* \& baby=Baby Tower,\ermid=Mid-tower,\erfull=Full Tower \& baby=Baby tower,\ermid=Mid-tower,\erfull=Full tower \& red=Passion Red,\erblue=Electric Blue,\ergreen=Sea Green,\ergrey=S... \& red=Passion Red,\eryellow=Lemon Yellow,\erblue=Electric Blue,\ergr... \& red=Rage Red,\eryellow=Honey Yellow .Ve This is an Interchange value set for a simple option. It is typically a comma-delimited list of labels and values with '*' indicating the default value. See the accessories tag for more detail. .PP Note that the "\fI\er\fR\*(L" characters in the above example represent carriage returns in the actual data (\*(R"\er" in perl, or Ctrl-M, or hexadecimal 0D), and the ... indicates a line too long to show. .PP \&\fIo_widget\fR .PP Example Data .PP .Vb 1 \& select .Ve This determines the \s-1HTML\s0 Widget type (\fIe.g.\fR, a select box). For example, the [options] tag uses this entry when building \s-1HTML\s0 widgets in a page. See also the [accessories] tag for available widgets. .PP \&\fIo_footer\fR .PP Example Data .PP Allowed Values .PP \&\fIo_header\fR .PP Example Data .PP Allowed Values .PP \&\fIo_height\fR .PP This allows you to set the height of the \s-1HTML\s0 widget, if appropriate. .PP \&\fIo_width\fR .PP This allows you to set the width of the \s-1HTML\s0 widget, if appropriate. .PP \&\fIdescription\fR .PP Example Data .PP .Vb 8 \& ATX Mid Tower-Grey (3)5.25 (2)3.5 & (1)3.5 Hidden \& Enlight ATX Desktop Case (2)5.25 & (2)3.5 \& Enlight ATX Tower Case (4) 5.25 & (2)3.5 \& Micro ATX Tower - Honey Yellow \& Micro ATX Tower - Moody Blue \& Micro ATX Tower - Rage Red \& Micro ATX Tower - Smoky Grey \& Super Tower Case (6)5.25 & (3)3.5 .Ve Longer description to show when displaying the options. .PP \&\fIprice\fR .PP Example Data .PP .Vb 5 \& 0.00 \& 10 \& 20 \& 29 \& 75 .Ve This sets the retail price of the option. .PP \&\fIwholesale\fR .PP Example Data .PP .Vb 2 \& 13 \& 40.00 .Ve This sets the dealer price of the option. .PP \&\fIdifferential\fR .PP Example Data .PP .Vb 3 \& -209 \& -40 \& -79 .Ve The phantom bill of materials for an option group can have a differential, which is an amount to add to the base price of the master product to get to a new base price that accommodates the phantom bill of materials. Note that the differential can be negative. .PP For example, in the computer data set of the foundation catalog, \s-1SKU\s0 00011 in the products table is an \f(CW$849\fR.95 pre-configured Athlon 800MHz computer that includes a 17" monitor (in this case, \s-1SKU\s0 7000087 in the products table). .PP The monitor by itself would otherwise have cost \f(CW$209\fR. It is much more convenient if you can use the same option part number and price for each item. To do this, you need a phantom option (in this case, \s-1SKU\s0 999105 in the options table only) with a differential of \-209 and the available monitors as suboptions. When you include the phantom option in the bill of materials for the computer (\s-1SKU\s0 00011), the $\-209 differential adjustment makes the price work out properly. .PP For instance, suppose that a \f(CW$499\fR computer is configured as follows: .PP .Vb 3 \& 500 MHz Athlon -- $499 \& 32 MB SDRAM -- ZERO \& 10 GB disk -- ZERO .Ve .Vb 1 \& TOTAL -- $499 .Ve Suppose it costs \f(CW$90\fR to upgrade the base computer to 128M of \s-1RAM\s0 and \&\f(CW$150\fR for a 30 \s-1GB\s0 hard disk. .PP If you also sell an 128MB 800 MHz \f(CW$899\fR computer, and the customer upgrades to the 30 \s-1GB\s0 hard disk, .PP .Vb 4 \& 800 MHz Athlon -- $899 \& (memory differential) -- $-90 \& 128 MB RAM -- $90 \& 30 GB disk -- $150 .Ve .Vb 1 \& TOTAL -- $1039 .Ve If you did not have the differential, you would need a different option part number for each item make the number come out right. .PP With the differential, you can use the same part number for 128MB \s-1RAM\s0 no matter what the base part is. The price is always \f(CW$90\fR \*(-- there is just a \-90 differential when ordered with the 800MHz Athlon, making the effective price zero. .PP \&\fIweight\fR .PP Example Data .PP .Vb 1 \& 5 .Ve Shipping weight of the option. Interchange uses this to calculate shipping cost. .PP \&\fIvolume\fR .PP Volume added by the option. .PP \&\fImv_shipmode\fR .PP No Description .PP \&\fIo_exclude\fR .PP Modular options only. .PP Lists the option groups to exclude once the include has been done. Takes the form of a number of wildcard atoms. .PP \&\fIo_include\fR .PP Modular options only. .PP Lists the option groups to include with your item. Takes the form of a number of wildcard atoms. .Sh "order_returns.txt" .IX Subsection "order_returns.txt" .Vb 9 \& code \& order_number \& session \& username \& rma_number \& nitems \& total \& return_date \& update_date .Ve .Sh "orderline.txt" .IX Subsection "orderline.txt" Every line item that is actually ordered is detailed in this table. The order as a whole is one record in the transactions table. .PP See the page query/check_orders.html for how it can be used. See etc/report for how to add to it. .PP .Vb 30 \& code \& store_id \& order_number \& session \& username \& shipmode \& sku \& quantity \& price \& subtotal \& shipping \& taxable \& mv_mi \& mv_si \& size \& color \& options \& order_date \& update_date \& status \& pending = Pending \& shipped = Shipped \& backorder = Back ordered \& credit = Waiting for credit check \& canceled = Cancelled \& parent \& affiliate \& campaign \& description \& mv_mp .Ve .Sh "pricing" .IX Subsection "pricing" This database works in conjunction with the CommonAdjust directive to allow quantity pricing for one product or for a group of products (sometimes known as mix-and-match). The fields q2, q5, q10, etc. are for the quantity levels; the price_group field selects the mix-and-match category for the product. .PP \&\fBFields\fR .PP .Vb 13 \& Field Description \& sku Unique key, shared with products table \& price_group Mix-and-match category \& q2 Retail, 2 or more \& q5 Retail, 5 or more \& q10 Retail, 10 or more \& q25 Retail, 25 or more \& q100 Retail, 100 or more \& w2 Wholesale, 2 or more \& w5 Wholesale, 5 or more \& w10 Wholesale, 10 or more \& w25 Wholesale, 25 or more \& w100 Wholesale, 100 or more .Ve \&\fIsku\fR .PP Example Data .PP .Vb 4 \& os28004 \& os28006 \& os28057c \& os28069 .Ve Unique key, matching the \fBsku\fR for an entry in products table. .PP \&\fIprice_group\fR .PP Example Data .PP .Vb 1 \& general .Ve This field determines mix-and-match categories if you want to allow mix-and-match quantity pricing (i.e., where 5 of \fIthese\fR plus 5 of \&\fIthose\fR afford the \fBq10\fR price for both \fIthese\fR and \fIthose\fR). .PP \&\fIq2\fR .PP If set, this will be the price per item when the order quantity is 2 or greater. .PP \&\fIq5\fR .PP If set, this will be the price per item when the order quantity is 5 or greater. .PP \&\fIq10\fR .PP If set, this will be the price per item when the order quantity is 10 or greater. .PP \&\fIq25\fR .PP If set, this will be the price per item when the order quantity is 25 or greater. .PP \&\fIq100\fR .PP If set, this will be the price per item when the order quantity is 100 or greater. .PP \&\fIw2\fR .PP If set, this will be the dealer price per item when the order quantity is 2 or greater. .PP \&\fIw5\fR .PP If set, this will be the dealer price per item when the order quantity is 5 or greater. .PP \&\fIw10\fR .PP If set, this will be the dealer price per item when the order quantity is 10 or greater. .PP \&\fIw25\fR .PP If set, this will be the dealer price per item when the order quantity is 25 or greater. .PP \&\fIw100\fR .PP If set, this will be the dealer price per item when the order quantity is 100 or greater. .Sh "products" .IX Subsection "products" This is the main table for product data. See also '\fIThe Product Database\fR' section in the database documentation. .PP The \fBsku\fR is also the master key in many of the related tables. .PP \&\fBFields\fR .PP .Vb 21 \& Field Description \& sku Unique product ID \& description Short description for list display \& title Full title for book, CD, artwork, etc. \& template_page Not used in foundation catalog. No description. \& comment Longer description for item display (e.g., flypage.html) \& thumb Thumbnail image \& image Regular-sized image \& price Retail quantity one price \& wholesale Dealer minimum quantity price \& prod_group Product supercategory \& category Product category \& nontaxable Boolean. Set true (1) if nontaxable \& weight Weight in your units. Should match shipping table. \& size List of options used with accessories tag. \& color List of options used with accessories tag. \& gift_cert Boolean. Set true (1) if this is a gift certificate. \& related Deprecated in favor of merchandising.upsell_to \& featured Deprecated. Use merchandising table. \& inactive Boolean. Set true (1) to inactivate a product \& url Not Documented .Ve \&\fIsku\fR .PP Example Data .PP .Vb 4 \& gift_cert \& os28004 \& os28006 \& os28057c .Ve Unique identifier for the product. You should use only characters of the class A-Z a-z 0\-9 _ \- (i.e., matching the regular expression, \&'[\-A-Za-z0\-9_]+'). Although Interchange itself does not impose this restriction, you may have problems with \s-1SQL\s0 databases, file systems, and \s-1URL\s0 encoding if you use other characters. For example, a slash (/) can interfere with URLs and filenames, a colon (:) can interfere with database representations (or file names on some operating systems), i .PP \&\fIdescription\fR .PP Example Data .PP .Vb 8 \& Brush Set \& Disposable Brush Set \& Ergo Roller \& Gift Certificate \& Painters Brush Set \& Painters Ladder \& Spackling Knife \& Trim Brush .Ve A short description for the product that is used for displaying in the shopping cart, receipt, and order report. .PP \&\fItitle\fR .PP Example Data .PP .Vb 8 \& Brush Set \& Disposable Brush Set \& Ergo Roller \& Gift Certificate \& Painters Brush Set \& Painters Ladder \& Spackling Knife \& Trim Brush .Ve This column is not used in the foundation catalog. Previously used in the Art store (simple) demo for a painting title. You probably want to use \fBdescription\fR instead. .PP You should modify the products and other tables to suit your catalog's requirements. You might use this field if you want to show titles for books, music, or other titled merchandise. If you do not use a title that is distinct from the short description, then you probably do not need this column in the table at all. .PP \&\fItemplate_page\fR .PP Not used in foundation catalog. .PP No Description. .PP \&\fIcomment\fR .PP Example Data .PP .Vb 4 \& A must have for all painters! This spackling knife is ergon... \& Enjoy the perfect feel and swing of our line of hammers. Thi... \& This set includes 2" and 3" trim brushes and our ergonomical... \& This set of disposable foam brushes is ideal for any stainin... .Ve This is the field for a long description of the product. If you are using an Interchange text/gdbm database, the field size is unlimited; if using another type of database, the length will be dependent on the field type selected. If you are using a \s-1SQL\s0 database, see the appropriate cat_root/dbconf subdirectory for a place to set \s-1COLUMN_DEF\s0 values. See also the database documentation, '\fIImporting from an \&\s-1ASCII\s0 File\fR', for details about defaults for columns that you do not define. .PP \&\fIthumb\fR .PP Example Data .PP .Vb 4 \& gift_certificate.gif \& os28004_b.gif \& os28005_b.gif \& os28006_b.gif .Ve This is the filename for a small (thumbnail) image of the product. .PP \&\fIimage\fR .PP Example Data .PP .Vb 4 \& gift_certificate_large.gif \& os28004.gif \& os28005.gif \& os28006.gif .Ve This is the filename for a regular-sized image of the product, as it should appear in an \s-1HTML\s0 tag. You do not need to specify the path if the image files are in the usual Interchange image directory. .PP \&\fIprice\fR .PP Example Data .PP .Vb 4 \& 1.00 \& 12.99 \& 14.99 \& 9.99 .Ve The quantity-one price of the product. See the \fBwholesale\fR field and the \fIprice\fR table for dealer and quantity pricing. .PP \&\fIwholesale\fR .PP Example Data .PP .Vb 4 \& 1 \& 10 \& 11 \& 12 .Ve This is the minimum dealer price for the item. For quantity pricing, see the \fIprice\fR table. .PP \&\fIprod_group\fR .PP Example Data .PP .Vb 8 \& Hand Tools \& Hardware \& Ladders \& Measuring Tools \& Miscellaneous \& Painting Supplies \& Safety Equipment \& Tool Storage .Ve Product group (supercategory). This indicates the grouping of product categories, for example in the navigation bars created from the \&\fBarea\fR table (note the match with the \fBname\fR data in the area table). .PP \&\fIcategory\fR .PP Example Data .PP .Vb 8 \& Brushes \& Gift Certificate \& Hammers \& Ladders \& Nails \& Paintbrushes \& Putty Knives \& Rollers .Ve This is the category the product should appear in when you select a list. You can put a product in more than one category, but you may need to accommodate this in display and banner headings. Embedded perl is helpful for this. .PP \&\fInontaxable\fR .PP Boolean value. If true (1), the sales tax calculation for an order will not include the cost of the product. See also the salestax tag. .PP \&\fIweight\fR .PP Example Data .PP .Vb 3 \& 1 \& 2 \& 3 .Ve This is a numeric value of the weight used for determining shipping costs (with \s-1UPS\s0, for example). In the \s-1US\s0, this is typically the weight in pounds in order to match the \s-1UPS\s0, Fed Ex and other standard shipping tables. .PP \&\fIsize\fR .PP Example Data .PP .Vb 8 \& 1", 2", 3" \& 1', 1.5' \& 1/4", 1/2", 3/4", 1", 2", 3" \& 10oz, 15oz, 20 oz \& 2" \& 6' \& set \& standard, metric .Ve This is where the old Construct Something demo store kept the 'size' options for a product. The foundation catalog now uses the \fBoptions\fR table instead to handle product options (also sometimes called product attributes). .PP The accessories tag can build \s-1HTML\s0 widgets from the comma-delimited list of product options. You can use a delimiter other than comma (if compatible with the table) as long as you also set the delimiter in the accessories tag. .PP You probably do not need this field if you use the options table (for example, if you are building from the foundation catalog). .PP \&\fIcolor\fR .PP Another product option column. No longer used in the foundation catalog. See \fBsize\fR above for description. .PP \&\fIgift_cert\fR .PP Boolean value. If true (1), specifies that this product is a gift certificate. See also the \fBgift_certs\fR table. .PP \&\fIrelated\fR .PP Used for displaying \*(L"upsells,\*(R" opportunities to purchase an additional item when this one is purchased. Contains a comma-separated list of SKUs to be offered. .PP The foundation catalog now instead uses the \fBupsell_to\fR field of the \&\fBmerchandising\fR table for upselling. .PP \&\fIfeatured\fR .PP Deprecated in favor of the \fBmerchandising\fR table. .PP \&\fIinactive\fR .PP If true (1), renders the product inactive (i.e., it will not appear in the catalog). .PP \&\fIurl\fR .PP Not Documented .Sh "route.txt" .IX Subsection "route.txt" .Vb 28 \& code \& attach \& continue \& commit \& commit_tables \& counter \& credit_card \& cyber_mode \& email \& empty \& encrypt \& encrypt_program \& errors_to \& increment \& inline_profile \& individual_track \& individual_track_ext \& partial \& pgp_cc_key \& pgp_key \& profile \& receipt \& reply \& report \& rollback \& rollback_tables \& supplant \& track .Ve .Sh "salestax.asc" .IX Subsection "salestax.asc" .Sh "shipping.asc" .IX Subsection "shipping.asc" Shipping methods table .Sh "state.txt" .IX Subsection "state.txt" State/territory/county information .PP .Vb 9 \& code \& sorder \& country \& state \& name \& tax \& postcode \& shipmodes \& tax_name .Ve .Sh "transactions.txt" .IX Subsection "transactions.txt" Each individual customer order has an entry in this table. The line items are not entered here, but in the orderline table. .PP See the page query/check_orders.html for how it can be used. See etc/report for how to add to it. .PP .Vb 60 \& code \& store_id \& order_number \& session \& username \& shipmode \& nitems \& subtotal \& shipping \& handling \& salestax \& total_cost \& fname \& lname \& Last Name \& company \& address1 \& address2 \& Address line 2 \& city \& state \& zip \& country \& phone_day \& Daytime Phone \& phone_night \& Home Phone \& fax \& email \& b_fname \& b_lname \& Billing Last Name \& b_company \& b_address1 \& b_address2 \& Billing Address Line 2 \& b_city \& b_state \& Billing State \& b_zip \& Billing Postcode \& b_country \& Billing Country \& b_phone \& order_date \& order_ymd \& order_wday \& payment_method \& po_number \& avs \& order_id \& update_date \& status \& affiliate \& campaign \& parent \& archived \& deleted \& complete \& comments .Ve .Sh "userdb.txt" .IX Subsection "userdb.txt" The user database used for maintaining customer address information, account information, preferences, and more. See icdatabase for more information. .PP .Vb 71 \& username \& password \& acl \& mod_time \& s_nickname \& company \& fname \& lname \& address1 \& address2 \& address3 \& city \& state \& zip \& Postcode \& country \& Country \& phone_day \& mv_shipmode \& b_nickname \& b_fname \& b_lname \& b_address1 \& b_address2 \& b_address3 \& b_city \& b_state \& b_zip \& b_country \& b_phone \& Billing Phone \& mv_credit_card_type \& mv_credit_card_exp_month \& mv_credit_card_exp_year \& p_nickname \& email \& fax \& phone_night \& fax_order \& Payment method: \& (none) = Credit Card \& 1 = Fax or Mail \& 2 = Purchase order \& 3 = COD \& address_book \& accounts \& preferences \& carts \& owner \& file_acl \& db_acl \& order_numbers \& email_copy \& mail_list \& Mailing lists the customer has joined: \& offer = Special offers \& newsletter = Newsletter \& alert = Alerts and Recalls \& upgrade = Upgrades \& project_id \& account_id \& order_dest \& credit_limit \& inactive \& dealer \& Dealer: \& (none) = No \& 1 = Yes \& b_company \& feedback \& ??? .Ve .Sh "variable.txt" .IX Subsection "variable.txt" Configuration database .PP .Vb 5 \& code \& Variable name \& Variable \& pref_group \& Preferences area .Ve .SH "HTML Hypertext links" .IX Header "HTML Hypertext links" Normally, regular hypertext links are not used in Interchange pages. These kinds of links will not include the session \s-1ID\s0. If the customer follows an external link back to the catalog, the list of products ordered so far will have been lost. The area tag is used to generate a hypertext link which includes a session \s-1ID\s0. .PP Instead of: .PP .Vb 1 \& Shirts .Ve Use: .PP .Vb 1 \& Shirts .Ve .SH "Images" .IX Header "Images" Inline images are placed in Interchange pages in the normal fashion with <\s-1IMG\s0 SRC=\*(L"\s-1URL\s0\*(R">. But since Interchange pages are served by a \s-1CGI\s0 program, it will by default automatically rewrite relative image links as absolute ones based on the ImageDir and ImageDirSecure directives. .SH "Browser Cookies" .IX Header "Browser Cookies" The Foundation store enables the Cookies directive so that users with cookie-capable browsers will retain session context. Then, standard \s-1HREF\s0 and Interchange page links can be intermixed without the fear of losing the shopping basket. Cookie capability is also required to use search caching, page caching, and statically generated pages. If the user's browser does not support cookies, the cache will be ignored. .PP If planning to use more than one host name within the same domain for naming purposes (perhaps a secure server and non-secure server), set the domain with the CookieDomain directive. This must contain at least two periods (.) as per the cookie specification, and must be located in the same server as the domain. .SH "Dependencies in administration" .IX Header "Dependencies in administration" In general, it's a good idea to leave fields empty if you don't want to use them, instead of removing them from the database altogether. That way nothing in the administration interface or the Foundation pages will break. .PP .Vb 1 \& ________________________________________ .Ve Copyright 2002\-2004 Interchange Development Group. Copyright 2001\-2002 Red Hat, Inc. Freely redistributable under terms of the \s-1GNU\s0 General Public License.
\&59 \&60 \&61 [include file="templates/components/[control component none]"][control] \&62 [include file="templates/components/[control component none]"][control] \&63 [include file="templates/components/[control component none]"][control] \&64
\&65 		\&67 [include file="templates/components/[control component none]"][control] \&68 .Ve \&\s-1LEFTONLY_BOTTOM\s0 .PP The \s-1LEFTONLY_BOTTOM\s0 template region is used in the following template pages: .PP .Vb 27 \& pages/aboutus.html \& pages/account.html \& pages/affiliate/index.html \& pages/affiliate/login.html \& pages/canceled.html \& pages/contact.html \& pages/customerservice.html \& pages/flypage.html \& pages/help.html \& pages/login.html \& pages/logout.html \& pages/modular_modify.html \& pages/new_account.html \& pages/ord/basket.html \& pages/privacypolicy.html \& pages/process_return.html \& pages/quantity.html \& pages/query/check_orders.html \& pages/query/order_detail.html \& pages/query/order_return.html \& pages/returns.html \& pages/saved_carts.html \& pages/ship_addresses.html \& pages/ship_addresses_added.html \& pages/ship_addresses_removed.html \& pages/stock-alert-added.html \& pages/stock-alert.html .Ve The \s-1LEFTONLY_BOTTOM\s0 template region is used in the following templates: .PP .Vb 3 \& templates/foundation/cart \& templates/foundation/leftonly \& templates/foundation/simple .Ve \&\s-1LEFTRIGHT_TOP\s0 .PP The \s-1LEFTRIGHT_TOP\s0 template region is used in the following template pages: .PP .Vb 5 \& pages/browse.html \& pages/index.html \& pages/results.html \& pages/results_big.html \& pages/swap_results.html .Ve The \s-1LEFTRIGHT_TOP\s0 template region is used in the following templates: .PP .Vb 1 \& templates/foundation/leftright .Ve \&\s-1LEFTRIGHT_BOTTOM\s0 .PP The \s-1LEFTRIGHT_BOTTOM\s0 template region is used in the following template pages: .PP .Vb 5 \& pages/browse.html \& pages/index.html \& pages/results.html \& pages/results_big.html \& pages/swap_results.html .Ve The \s-1LEFTRIGHT_BOTTOM\s0 template region is used in the following templates: .PP .Vb 1 \& templates/foundation/leftright .Ve \&\s-1NOLEFT_BOTTOM\s0 .PP The \s-1NOLEFT_BOTTOM\s0 template region is used in the following template pages: .PP .Vb 2 \& pages/ord/checkout.html \& pages/splash.html .Ve The \s-1NOLEFT_BOTTOM\s0 template region is used in the following templates: .PP .Vb 1 \& templates/foundation/fullwidth .Ve \&\s-1NOLEFT_TOP\s0 .PP The \s-1NOLEFT_TOP\s0 template region is used in the following template pages: .PP .Vb 2 \& pages/ord/checkout.html \& pages/splash.html .Ve The \s-1NOLEFT_TOP\s0 template region is used in the following templates: .PP .Vb 1 \& templates/foundation/fullwidth .Ve .Sh "Template Page List" .IX Subsection "Template Page List" /home/ic/catalogs/ft/pages/: .PP .Vb 31 \& aboutus.html \& account.html \& browse.html \& canceled.html \& change_password.html \& contact.html \& customerservice.html \& deliver.html \& flypage.html \& help.html \& index.html \& login.html \& logout.html \& lost_password.html \& modular_modify.html \& new_account.html \& privacypolicy.html \& process_return.html \& quantity.html \& results_big.html \& results_either.html \& results.html \& returns.html \& saved_carts.html \& ship_addresses_added.html \& ship_addresses.html \& ship_addresses_removed.html \& splash.html \& stock-alert-added.html \& stock-alert.html \& swap_results.html .Ve /home/ic/catalogs/ft/pages/admin/report_def: .PP .Vb 2 \& Order%20Status.html \& Products%20to%20edit.html .Ve /home/ic/catalogs/ft/pages/admin/reports: .PP .Vb 2 \& Order%20Status.html \& Products%20to%20edit.html .Ve /home/ic/catalogs/ft/pages/affiliate: .PP .Vb 2 \& index.html \& login.html .Ve /home/ic/catalogs/ft/pages/ord: .PP .Vb 2 \& basket.html \& checkout.html .Ve /home/ic/catalogs/ft/pages/query: .PP .Vb 4 \& check_orders.html \& get_password.html \& order_detail.html \& order_return.html .Ve .Sh "Special Page List" .IX Subsection "Special Page List" /home/ic/catalogs/ft/special_pages/: .PP .Vb 16 \& badsearch.html \& canceled.html \& cc_not_valid.html \& confirmation.html \& failed.html \& interact.html \& missing.html \& needfield.html \& nomatch.html \& noproduct.html \& notfound.html \& order_security.html \& reconfig.html \& sec_faq.html \& security.html \& violation.html .Ve .Sh "Components" .IX Subsection "Components" .Ip "\(bu" 4 Added new [control] and [control-set] tags to set series of Scratch- like option areas. Used for components in \s-1UI\s0 content editing. .PP Interchange components are portions of \s-1HTML\s0 and \s-1ITL\s0 that are included in pages within a catalog depending on options set in the Administration Tool. The default component set includes the following: .PP .Vb 23 \& affiliate_receptor \& best_horizontal \& best_vertical \& cart \& cart_display \& cart_tiny \& category_vertical \& cross_horizontal \& cross_vertical \& modular_buy \& modular_update \& none \& promo \& promo_horizontal \& promo_vertical \& random \& random_horizontal \& random_vertical \& saved_carts_list_small \& search_box_small \& upsell \& upsell_horizontal \& upsell_vertical .Ve /home/ic/catalogs/ft/templates/components: .PP affiliate_receptor .PP Not used in Foundation demo .PP best_horizontal .PP The best_horizontal component is used in the following templates: .PP .Vb 3 \& templates/foundation/cart \& templates/foundation/leftonly \& templates/foundation/leftright .Ve Not used in Foundation demo pages .PP best_vertical .PP The best_vertical component is used in the following template: .PP .Vb 1 \& templates/foundation/leftright .Ve Not used in Foundation demo pages .PP cart .PP The cart component is used in the following page: .PP .Vb 1 \& pages/ord/basket.html .Ve cart_display .PP The cart_display component creates a small shopping cart that is displayed on the search results page (pages/results.html). It is displayed after an item in a list of results from a search is added to the shopping cart. cart_display is called in results.html by the following include statement: .PP .Vb 1 \& [include file="templates/components/cart_display"] .Ve The cart_display component is used in the following pages: .PP .Vb 1 \& pages/results.html .Ve Component Walkthrough \*(-- cart_display .PP The remainder of this section is best read in conjunction with the file CATROOT/templates/components/cart_display in a text editor. .PP \&\fBLines 1\-6:\fR Component Specification .PP .Vb 7 \& 1 [comment] \& 2 ui_component: cart_display \& 3 ui_component_group: info \& 4 ui_component_label: Smaller cart for display in content area \& 5 \& 6 [/comment] \& 7 .Ve These lines control what is shown in the Edit page screen of the admin interface. .PP .Vb 1 \& 8 .Ve Line 8 is an \s-1HTML\s0 comment noting the start of the code for the component. (Note that this can serve as a useful debugging tool to help you locate the component in the resulting \s-1HTML\s0 generated by Interchange when you view the source of a page loaded in the browser.) .PP .Vb 1 \& 9 [if items] .Ve Line 9 checks to see if there are items in the shopping basket. If there are, the remaining code up to the closing [/if] tag on line 64 is executed. If not, Interchanges continues executing the remaining code in results.html (the file that calls the cart_display component). .PP .Vb 20 \& 10
\& 11 \& 12 \& 13 \& 14 \& 17 \& 20 \& 23 \& 26 \& 29 .Ve Line 10 centers the table started in line 11. Lines 12\-29 create a header row in the shopping cart consisting of the header titles Action, \s-1SKU\s0, Description, Quantity, Price, and Extension. .PP .Vb 3 \& 30 \& 31 [item-list] \& 32 .Ve Line 30 defines the remainder of the table as a section while the [item-list] tag on line 31 tells Interchange to execute the code up to the closing tag ([/item-list] on line 59 for each item the customer has ordered so far. .PP .Vb 11 \& 33 \& 34 \& 37 \& 38 \& 40 .Ve Line 33 begins the next row in the table. The [item-alternate] tag provided as the value of the class attribute tells Interchange to alternate between displaying the rows according to the \*(L"maincontent\*(R" and \*(L"contentbar1\*(R" styles (gray and white, respectively). .PP Lines 34\-36 create a link to the shopping cart (basket.html) where the customer can remove or change the quantity of the item ordered. .PP Line 37 displays the \s-1SKU\s0 of the item. Lines 38 and 39 provide a link to the product display page (flypage.html) for the item. The [item-description] tag providing the content of the [page] tag enables the item's name to be displayed as the link to the product display page. .PP .Vb 18 \& 41 [if-item-modifier gift_cert] \& 42 \& 43 \& 44 \& 47 [else] \& 48 \& 49 \& 52 \& 55 [/else] \& 56 [/if-item-modifier] \& 57 \& 58 .Ve Line 41 checks whether the item is a gift certificate. If it is it displays \*(L"Amount of gift:\*(R" and the [item-quantity] (number of gift certificates, in this case) under the headings \*(L"Quantity\*(R" and \*(L"Price\*(R", respectively. Otherwise, lines 48 through 50 display the quantity and price of the item ordered. Lines 45 or 53 (depending on whether the item is a gift certificate) display the item subtotal (quantity multiplied by price) for the item under the heading \*(L"Extension\*(R". .PP .Vb 8 \& 59 [/item-list] \& 60 \& 61
Action \& 15 SKU \& 16 \& 18 Description \& 19 \& 21 Quantity \& 22 \& 24 Price \& 25 \& 27 Extension \& 28
\& 35 [page ord/basket]edit \& 36 [item-code][page [item-code]][item-description] \& 39 Amount of gift:[item-quantity] \& 45 [item-subtotal] \& 46 [item-quantity] \& 50 [item-price] \& 51 \& 53 [item-subtotal] \& 54
\& 62 \& 63
\& 64 [/if] \& 65 \& 66 .Ve Lines 59 through 64 close out the tags for the component, and line 66 indicates the end of the component code. .PP cart_tiny .PP The cart_tiny component is used in the following pages: .PP .Vb 18 \& pages/account.html \& pages/browse.html \& pages/canceled.html \& pages/customerservice.html \& pages/flypage.html \& pages/help.html \& pages/index.html \& pages/logout.html \& pages/modular_modify.html \& pages/new_account.html \& pages/privacypolicy.html \& pages/process_return.html \& pages/quantity.html \& pages/query/check_orders.html \& pages/query/order_detail.html \& pages/query/order_return.html \& pages/saved_carts.html \& pages/ship_addresses.html .Ve category_horizontal .PP Not used in Foundation demo pages or templates. .PP category_vertical .PP The category_vertical component provides a listing of all products in the catalog, organized by prod_group (e.g., Hand Tools, Ladders). category_vertical is usually displayed in the \s-1LEFTSIDE\s0 section of the page, under the search_box_small component. .PP The category_vertical component is used in the following pages: .PP .Vb 30 \& pages/aboutus.html \& pages/account.html \& pages/affiliate/index.html \& pages/affiliate/login.html \& pages/browse.html \& pages/canceled.html \& pages/contact.html \& pages/customerservice.html \& pages/flypage.html \& pages/help.html \& pages/index.html \& pages/login.html \& pages/logout.html \& pages/modular_modify.html \& pages/new_account.html \& pages/ord/basket.html \& pages/privacypolicy.html \& pages/process_return.html \& pages/quantity.html \& pages/query/check_orders.html \& pages/query/order_detail.html \& pages/query/order_return.html \& pages/results.html \& pages/results_big.html \& pages/returns.html \& pages/saved_carts.html \& pages/ship_addresses.html \& pages/stock-alert-added.html \& pages/stock-alert.html \& pages/swap_results.html .Ve Component Walkthrough \*(-- category_vertical .PP The remainder of this section is best read while viewing the file CATROOT/templates/components/cart_display in a text editor. .PP \&\fBLines 1\-6:\fR Component Specification .PP .Vb 22 \& 1 [comment] \& 2 ui_component: category_vertical \& 3 ui_component_group: Navigation \& 4 ui_component_label: Vertical category list \& 5 \& 6 page_class: \& 7 label: Page class \& 8 widget: select \& 9 lookup: which_page \& 10 db: area \& 11 help: Defines which sets of items should be displayed \& 12 advanced: 1 \& 13 \& 14 set_selector: \& 15 label: Page area selector \& 16 widget: select \& 17 db: area \& 18 lookup: sel \& 19 help: Defines which sets of items should be displayed \& 20 advanced: 1 \& 21 [/comment] \& 22 .Ve These lines control what is shown in the Edit page screen of the Administration Tool. .PP .Vb 5 \& 23
\& 24
\& 25 \& 26 \& 27 .Ve Lines 23\-25 set up the row and table within that row that will hold the vertical category list. Line 27 identifies the start of the code for the list. .PP .Vb 19 \& 28 [loop \& 29 prefix=box \& 30 search=" \& 31 fi=area \& 32 st=db \& 33 tf=sort \& 34 ac=0 \& 35 ac=0 \& 36 co=yes \& 37 \& 38 sf=sel \& 39 op=eq \& 40 se=[control set_selector left] \& 41 \& 42 sf=which_page \& 43 op=rm \& 44 se=[control page_class all|@@MV_PAGE@@] \& 45 "] \& 46 .Ve Lines 28\-45 build a list of product categories obtained through a search of the area table. .PP .Vb 32 \& 47 \& 48 \& 51 \& 52 \& 53 \& 71 \& 72 [/loop] \& 73 \& 74
\& 49 [box-exec bar_link]area[/box-exec] \& 50
\& 54 \& 55 [set found_cat][/set] \& 56 [loop prefix=cat \& 57 search=" \& 58 fi=cat \& 59 st=db \& 60 tf=sort \& 61 tf=name \& 62 rf=code,name \& 63 sf=sel \& 64 se=[box-code] \& 65 " \& 66 ] \& 67   [cat-exec bar_link]cat[/cat-exec]
\& 68 [/loop] \& 69 \& 70
\& 75
\& 76