numero = 15795
interpreted = N
texte = >In your main product database have fields named Sizes and Colors, set >the value of the field to T, if not, F. Create a new color database >with three fields sku color, and order. Likewise, create a new size >database. Enter the sku for your main product as the sku in the database.I've done this except I also created a field called Title. I can't use SKU as you have because every color/size variation uses a different SKU, but all variations share the same product name, ie Title field. One catch I'm running into is that the SKU for the variation needs to be passed to the shopping cart.>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.The Title field in my Size.db is same data as Title field in my Catalog.txtHow do I get the variations' SKU from the Size.db to the shopping cart?Here what I have now that puts the sizes on the page but not in a menu and apparently not sorted:[showif [Size]=T] [search db=Size.db&eqtitledata=[title]&Ordersort=de] [/search] [/showif]Any more suggestions?
Associated Messages, from the most recent to the oldest:
>In your main product database have fields named Sizes and Colors, set >the value of the field to T, if not, F. Create a new color database >with three fields sku color, and order. Likewise, create a new size >database. Enter the sku for your main product as the sku in the database.I've done this except I also created a field called Title. I can't use SKU as you have because every color/size variation uses a different SKU, but all variations share the same product name, ie Title field. One catch I'm running into is that the SKU for the variation needs to be passed to the shopping cart.>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.The Title field in my Size.db is same data as Title field in my Catalog.txtHow do I get the variations' SKU from the Size.db to the shopping cart?Here what I have now that puts the sizes on the page but not in a menu and apparently not sorted:[showif [Size]=T] [search db=Size.db&eqtitledata=[title]&Ordersort=de] [/search] [/showif]Any more suggestions?
Jim Turney
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...