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 blue2 coffee maker black3 coffee maker green4 coffee maker orange5 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 GromeWebDNA Consultant Associated Messages, from the most recent to the oldest:

Re: Color options for items (Kenneth Grome 1999)
Re: Color options for items (Josh Knauer 1999)
Re: Color options for items (M�che�l O S� 1999)
Re: Color options for items (charles kline 1999)
Re: Color options for items (Tim Taylor 1999)
Color options for items (Teresa L. Schmidt 1999)

>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 blue2 coffee maker black3 coffee maker green4 coffee maker orange5 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 GromeWebDNA Consultant Kenneth Grome

DOWNLOAD WEBDNA NOW!

Re: Color options for items

1999

Top Articles:

Related Readings: