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:

WebCatalog2 Feature Feedback (1996) shipcost (1997) Mac 2.1b4 unknown error: BadSuffix (1997) WebCat2.0 [format thousands .0f] no go (1997) form data submission gets truncated (1997) Variable Math (1998) international time (1997) PARAMETER vs. OPERATOR (was The BUG is BACK ...) (1998) OT: WebObjects (2000) [WebDNA] paypal (2009) [Sum] function? (1997) What are SMSI's upgrade policies? (2003) Still ignoring the 3.x bugs? (2000) Checkboxes (1998) Quick ShowIf question (1997) problems with 2 tags (1997) WebDNA HitLogger available (was Signal Raised Error) (1997) Closing Databases (1998) WebCat B13 Mac CGI -- Frames question (1997) displaying 12 results 4 by 3 (2000)