Re: Color options for items
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23747
interpreted = N
texte = >Hey guys! Has anyone had to deal with color options for database items >with WebCatalog? > >I have a database (~200 items) of items that each have their own color >options (2-6 colors for each item). When someone wants to buy an item, >they have to choose the color. Each item has unique colors, and each has >a different number of color options as well. Hi Teresa,Here's a simple solution that will serve your needs very well. It's based on creating a new db with one unique record for each unique item. In other words, where you now have a single record with 5 different color options to choose from, you *could* have 5 different items in the db, each with its own color. Here's how to do everything you need:1- Add two new fields to your db, one called itemGroup and another called color.2- Duplicate each record in your original database as many times as necessary to create one record for each available color option. In other words, let's say you have an item in your original db with 5 different color options, but everything else about these items is exactly the same. Duplicate that item 4 times, so now you have the original record and 4 duplicates -- and each of these 5 records looks exactly the same.3- Change the SKU values in these 5 records so they are different from each other, and different from every other record in the db as well. No matter what, you must always make sure that the SKU value for each and every record in your db is unique.4- Create a name for this itemGroup and enter that name into each of the 5 records in the ItemGroup field. For example, if this is the only coffee maker in your store, you can call this group the coffee maker group.5- Enter the color for each item into the color field, so each item has a different color in it.6- When you're done, you should have a db with values something like this:SKU itemGroup color1 coffee maker blue 2 coffee maker black 3 coffee maker green 4 coffee maker orange 5 coffee maker white7- Now you have 5 records in your db instead of just one record. Each item is uniquely identified by it's SKU, just like before ...But each item is ALSO identified by its itemGroup value, which means you can summarize the items in your search results by using itemGroupSumm=T in your search parameters. This will let you display just one of the 5 available coffee maker items on your results page, instead of displaying 5 separate items which are exactly the same except for color ...And of course, by searching on the unique itemGroup value you can ALSO display a popup menu of available colors for this item, allowing the visitor to choose a color simply by selecting the proper color from the Colors popup menu on your results or detail page.:)Sincerely, Ken Grome WebDNA Consultant
Associated Messages, from the most recent to the oldest:
>Hey guys! Has anyone had to deal with color options for database items >with WebCatalog? > >I have a database (~200 items) of items that each have their own color >options (2-6 colors for each item). When someone wants to buy an item, >they have to choose the color. Each item has unique colors, and each has >a different number of color options as well. Hi Teresa,Here's a simple solution that will serve your needs very well. It's based on creating a new db with one unique record for each unique item. In other words, where you now have a single record with 5 different color options to choose from, you *could* have 5 different items in the db, each with its own color. Here's how to do everything you need:1- Add two new fields to your db, one called itemGroup and another called color.2- Duplicate each record in your original database as many times as necessary to create one record for each available color option. In other words, let's say you have an item in your original db with 5 different color options, but everything else about these items is exactly the same. Duplicate that item 4 times, so now you have the original record and 4 duplicates -- and each of these 5 records looks exactly the same.3- Change the SKU values in these 5 records so they are different from each other, and different from every other record in the db as well. No matter what, you must always make sure that the SKU value for each and every record in your db is unique.4- Create a name for this itemGroup and enter that name into each of the 5 records in the ItemGroup field. For example, if this is the only coffee maker in your store, you can call this group the coffee maker group.5- Enter the color for each item into the color field, so each item has a different color in it.6- When you're done, you should have a db with values something like this:SKU itemGroup color1 coffee maker blue 2 coffee maker black 3 coffee maker green 4 coffee maker orange 5 coffee maker white7- Now you have 5 records in your db instead of just one record. Each item is uniquely identified by it's SKU, just like before ...But each item is ALSO identified by its itemGroup value, which means you can summarize the items in your search results by using itemGroupSumm=T in your search parameters. This will let you display just one of the 5 available coffee maker items on your results page, instead of displaying 5 separate items which are exactly the same except for color ...And of course, by searching on the unique itemGroup value you can ALSO display a popup menu of available colors for this item, allowing the visitor to choose a color simply by selecting the proper color from the Colors popup menu on your results or detail page.:)Sincerely, Ken Grome WebDNA Consultant
Kenneth Grome
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:
taxTotal, grandTotal (1997)
WebDNA Solutions ... sorry! (1997)
[protect] on NT? (1997)
Emailer and encryption (1997)
Pass a form (2003)
syntax question, not in online refernce (1997)
WebMerchant 3.0 for Mac shipping now (1998)
Webcatlog server not running (2008)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Followup question re: checksum for credit cards? (1997)
AccountAuthorizer doesn't seem to work (1997)
[WebDNA] Feature Request: [returnhtml] (2016)
P2: How to make webcatalog more stable. - LONG (1999)
OT: Several requests (2003)
Email within tmpl ? (1997)
Emailer Error Question (1998)
[WebDNA] Dreamweaver Tag Libraries and Snippets (2011)
turning every 5th line red (1998)
Great product and great job ! (1997)
NT or Mac (1997)