Re: Setting up WebCatalog with Retail Pro data
This WebDNA talk-list message is from 1996
It keeps the original formatting.
numero = 10154
interpreted = N
texte = >Can someone pls advise me of the best way to setup my Webcatalog database >so that when a customer searches for shirts it returns only one result for >each type of shirt and then when they go to get details on the shirt the >color and size options are available for selection? I'm not clear on howIf there are lots of products with identical color and size options, you could just put the name of a static HTML file into a text field for those records, and link to that.Assuming the color and size options can be different for each product, you may want to do one of the following:You could put the HTML text for a popup that contains all the size options directly into a text field in the record. The when you display that text field in a search result, the popup appears.Or, you could mark the 'master' record with something special, like setting int1 to 1 for that record, and 0 for the 'sub-records' that have the different color and size options. Then when you search for products, add an extra criteria that will only show 'master' records: eqint1data=1. When they click the detail link, show them the 'sub-records' by doing eqint1data=0Hope this helpsGrant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>Can someone pls advise me of the best way to setup my Webcatalog database >so that when a customer searches for shirts it returns only one result for >each type of shirt and then when they go to get details on the shirt the >color and size options are available for selection? I'm not clear on howIf there are lots of products with identical color and size options, you could just put the name of a static HTML file into a text field for those records, and link to that.Assuming the color and size options can be different for each product, you may want to do one of the following:You could put the HTML text for a popup that contains all the size options directly into a text field in the record. The when you display that text field in a search result, the popup appears.Or, you could mark the 'master' record with something special, like setting int1 to 1 for that record, and 0 for the 'sub-records' that have the different color and size options. Then when you search for products, add an extra criteria that will only show 'master' records: eqint1data=1. When they click the detail link, show them the 'sub-records' by doing eqint1data=0Hope this helpsGrant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Corruption in images (2004)
Duplicate Carts (2006)
where to put code (1998)
Robert Minor duplicate mail (1997)
Anyone awake? Newby moves deeper! Sitesearch & Customer DB Append Context or Command? (2000)
SiteEdit NewFile.html ? (1997)
Date search - yes or no (1997)
WebCat for Unix?? (1997)
Re:Copyright ? (1997)
Grant, please help me ... (1997)
Almost a there but..bye bye NetCloak (1997)
japanese characters (1997)
more ! testing (1997)
international time (1997)
Database changes (1998)
SMSI FTP - calander system (2002)
Applescript, WebDNA, and PDF (1997)
New command suggestion (1997)
Free pack for the New UPS ratings and services tool (2000)
WebCat2 Append problem (B14Macacgi) (1997)