Changing price for a SLU based on options (size, etc.)

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13436
interpreted = N
texte = I have a catalog under construction. There are a small number of SKU's, but a variety of options for each. For a piece of clothing, for example, I have 5 sizes.The basic problem is that the price varies for different sizes. Small, Medium and Large have one price and Xtra Large and Double Xtra Large have another.I've tried to hack the formula.db to put up a different price if it finds that the SKU is a match and the size is Double Xtra Large.No Joy. Does anyone have an example formula.db or advise. I've considered creating seperate SKU's for each price, but would like to avoid that solution as it seems a kludge.-- Larry Lowe webmaster@airspacemag.comAir&Space Magazine http://www.airspacemag.com/Miss America Air Racing http://www.missa.com/Bud Light Air Force http://www.blaf.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Changing price for a SLU based on options (size, etc.) (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  2. Re: Changing price for a SLU based on options (size, etc.) (Kenneth Grome 1997)
  3. Changing price for a SLU based on options (size, etc.) (Larry Lowe 1997)
I have a catalog under construction. There are a small number of SKU's, but a variety of options for each. For a piece of clothing, for example, I have 5 sizes.The basic problem is that the price varies for different sizes. Small, Medium and Large have one price and Xtra Large and Double Xtra Large have another.I've tried to hack the formula.db to put up a different price if it finds that the SKU is a match and the size is Double Xtra Large.No Joy. Does anyone have an example formula.db or advise. I've considered creating seperate SKU's for each price, but would like to avoid that solution as it seems a kludge.-- Larry Lowe webmaster@airspacemag.comAir&Space Magazine http://www.airspacemag.com/Miss America Air Racing http://www.missa.com/Bud Light Air Force http://www.blaf.com/ Larry Lowe

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:

upgrading (1997) Searching multiple Databases (1997) [URL] Context not working (2000) WebCommerce: Folder organization ? (1997) WCS Newbie question (1997) Using Cookie for client specific info? (1997) Re2: frames & carts (1997) Bug? I don't know... (1999) searchable list archive (1997) [TCPConnect] questions/problems (2001) groupfields, popups, etc. (2000) Showif, Hideif reverse logic ? (1997) RE: I have observed and I am gone. (1998) large database (2000) General WebCatalog Questions (1997) Getting URL's entered manually (1997) [WebDNA] Search 2 databases ??? (2009) Sorry I didn't pay attention-but ??? (1997) Dummy Credit Card Number for debug? (1997) WebCat2: multiple currency support (1997)