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

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13442
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. It is NOT a kludge, it is the proper way to do things. Go into any retail store and look at any two items that are identical except for size or color and you will clearly see two different SKU's.Size and color are defining factors that make items different, so you should have a different SKU for every item that has a different size or color from another item ...Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html 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. It is NOT a kludge, it is the proper way to do things. Go into any retail store and look at any two items that are identical except for size or color and you will clearly see two different SKU's.Size and color are defining factors that make items different, so you should have a different SKU for every item that has a different size or color from another item ...Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Kenneth Grome

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:

Kaaaaahhhhhhhnnnnnnn! (1997) WebCat2b15MacPlugin - showing [math] (1997) [Sum] function? (1997) Multiple Users.db Possible? (1997) Random Generator (2005) webmerch and serials - almost there (1997) Setting up shop (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) WebCat2b12 Mac.acgi--[searchstring] bug (1997) zip code vs tax rate database request (2002) TCPconnect and send (2001) emailer (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Smith Micro - no competition - Feedback (2000) [ListFiles] Within [LineItems] (2001) Problems getting parameters passed into email. (1997) [ConvertChars] problem (1997) Limiting user access to .tmpl files (1997) webcatalog developers in W. Pa. (1998) LOOP and IF statements (1997)