Re: Menu to select product variations

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15750
interpreted = N
texte = This is just one approach, but it works. In your main product database have fields named Sizes and Colors. If that product has different sizes or colors, set the value of the appropriate field to T, if not, F. Create a new color database with three fields sku color, and order. Likewise, create a new size database with sku size order. Enter the sku for your main product as the sku in the color database. If there are more than one colors, use that same product sku multiple times. I use the order field to store a number that sorts the colors (you could just sort alphabetically, but many people like a custom order.On your product page, have a [showif] tag that checks the product color field to see if it's true. If it is, do a search in the color database for all the colors associated with that product, sorted by the order field. Use the [founditems] loop from this secondary search to build the pop-up menu. Essentially you have a search within a search. I hope this helps.John.>What is the best way to handle a product that has different sizes, colors >or other variation? I'm surprised to find that the GeneralStore model >doesn't have any provision for this (or have I missed it?), so I'm trying >to figure out how to handle it without an example. > >I have some general categories of products with a number of products in >each category (so far this fits the GeneralStore model fine) but I also >have various sizes of each product. I'd prefer to have a drop-down menu on >the product detail page to select the product variation which gets put in >the shopping cart. Each variation has it's own SKU but the same name, >description, photo and price as all the other variations. > >Thanks in advance. John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Menu to select product variations (Grant Hulbert 1997)
  2. Re: Menu to select product variations (Jim Turney 1997)
  3. Re: Menu to select product variations (John Hill 1997)
  4. Re: Menu to select product variations (Kenneth Grome 1997)
  5. Menu to select product variations (Jim Turney 1997)
This is just one approach, but it works. In your main product database have fields named Sizes and Colors. If that product has different sizes or colors, set the value of the appropriate field to T, if not, F. Create a new color database with three fields sku color, and order. Likewise, create a new size database with sku size order. Enter the sku for your main product as the sku in the color database. If there are more than one colors, use that same product sku multiple times. I use the order field to store a number that sorts the colors (you could just sort alphabetically, but many people like a custom order.On your product page, have a [showif] tag that checks the product color field to see if it's true. If it is, do a search in the color database for all the colors associated with that product, sorted by the order field. Use the [founditems] loop from this secondary search to build the pop-up menu. Essentially you have a search within a search. I hope this helps.John.>What is the best way to handle a product that has different sizes, colors >or other variation? I'm surprised to find that the GeneralStore model >doesn't have any provision for this (or have I missed it?), so I'm trying >to figure out how to handle it without an example. > >I have some general categories of products with a number of products in >each category (so far this fits the GeneralStore model fine) but I also >have various sizes of each product. I'd prefer to have a drop-down menu on >the product detail page to select the product variation which gets put in >the shopping cart. Each variation has it's own SKU but the same name, >description, photo and price as all the other variations. > >Thanks in advance. John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com John Hill

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:

read and write you own cookies with webcat (1997) [WebDNA] Authenticating with Twitter OAuth API v1.1 (2013) [convertchars] problem... (2000) WebCat 5 Intranet Question (2003) Summing a field full of numbers ... (1997) WebCat2 several catalogs? (1997) Shopping Cart variation... (1997) [BULK] Fwd: [WebDNA] [BULK] WebDNA discovery in the Console - [having many crashes] (2011) MacOS X Server problems (2001) Welcome! (2000) Problems getting parameters passed into email. (1997) b12 cannot limit records returned and more. (1997) IE Cache Problems... (1999) Updating a database once per day - An example (1998) [input] [/input] (1997) Configuring E-mail (1997) totals (1997) Search all Fields in a db (1997) [include] affect on filepaths for links? (1997) Potential Conflicts? (1997)