Re: Help me...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19046
interpreted = N
texte = >I have a small online store I am developing. Of the 7 or 8 products we will >sell, one of them will have a size/price option. ie 6lb. costs $10 2lb. >costs $4. All the items have photos, but I want this item to share a >single photo and use a pop-up for the selection of the size/price option.The simplest approach is to have 2 separate unique SKUs, one for each version of the product. But this seems to be bad for you because you don't want the picture showing twice.>What is te best way to go at this? Do I make a field in my database >called HasPopUp and if it is true display the pop-up? If I do this how do >I have it work with multiple size/price options?I like your idea of a HasPopup field, because it means you can add this feature to other products in the future. The next hard part will be getting the price right, because if there's only one SKU, it thinks there's only one price.The solution is to use the formulas.db file to modify the [price] formula so that it looks for your extra popup information.Here't what I'd do if I knew there was only going to be 1 alternate price:Add another field to your database called something like price2 and put the alternate price in thatMake your popup field named textA (because there are 5 spare fields per lineitem into which you can store some extra information, such as color or size, and they're named textA-E). Make the alternate price popup value something like Alt.Change your price formula to look for the value of [textA] so it knows which price to look at, such as:-- formulas.db -- price [ShowIf [textA]=Alt][price2][/ShowIf][ShowIf [textA]!Alt][price][/ShowIf]That way if textA is Alt, then it looks in the price2 field instead of the price field.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- Re: Help me... (PCS Technical Support 1998)
|
>I have a small online store I am developing. Of the 7 or 8 products we will >sell, one of them will have a size/price option. ie 6lb. costs $10 2lb. >costs $4. All the items have photos, but I want this item to share a >single photo and use a pop-up for the selection of the size/price option.The simplest approach is to have 2 separate unique SKUs, one for each version of the product. But this seems to be bad for you because you don't want the picture showing twice.>What is te best way to go at this? Do I make a field in my database >called HasPopUp and if it is true display the pop-up? If I do this how do >I have it work with multiple size/price options?I like your idea of a HasPopup field, because it means you can add this feature to other products in the future. The next hard part will be getting the price right, because if there's only one SKU, it thinks there's only one price.The solution is to use the
formulas.db file to modify the [price] formula so that it looks for your extra popup information.Here't what I'd do if I knew there was only going to be 1 alternate price:Add another field to your database called something like price2 and put the alternate price in thatMake your popup field named textA (because there are 5 spare fields per lineitem into which you can store some extra information, such as color or size, and they're named textA-E). Make the alternate price popup value something like Alt.Change your price formula to look for the value of [textA] so it knows which price to look at, such as:--
formulas.db -- price [ShowIf [textA]=Alt][price2][/ShowIf][ShowIf [textA]!Alt][price][/ShowIf]That way if textA is Alt, then it looks in the price2 field instead of the price field.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
store builder / categories / products.db (2003)
WebDNA for Dummies (2004)
Locking up with WebCatalog... (1997)
RE: WebDNA-Talk searchable? (1997)
TRAINING videos - Prove IT. (1998)
mass mailing (1998)
3.0 to 4.0 (2000)
Banner DNA (1997)
Searching Multiple Databases (2000)
Initiating NewCart (1997)
WebCat2b15MacPlugin - showing [math] (1997)
WC2b15 File Corruption (1997)
[WebDNA] Image Magick and Webdna (2009)
SOLVED: [WebDNA] [lookup..] returning nothing at all.. not even the notfound param. (2010)
Emailer (WebCat2) (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
PIXO support (1997)
WebDNA 5.0 freeBSD?!!? (2003)
WebMerchant 1.6 and https (1997)
Invisible file issue now a real 'bug' (1999)