Re: Size/Color Options
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43393
interpreted = N
texte = Unfortunately, the example I gave below was pulled directly from my a$$. I have idea how the SKUs are organized in the client's actual inventory right now. I'll try to find out ASAP to see how complicated this is going to get. On 9/13/02 12:01 PM, John Peacock
wrote:> Clint Davis wrote: >> >> SKUs for item 1314 >> -------------------------------------- >> Red/M = 131401 >> Red/L = 131403 >> Red/XL = 131405 >> Red/XXL = 131407 >> Blue/M = 131421 >> Blue/L = 131423 >> Blue/XL = 131425 >> Blue/XXL = 131427 >> Gray/M = 131431 >> Gray/L = 131433 >> Gray/XL = 131435 >> Gray/XXL = 131437 >> White/M = 131441 >> White/L = 131443 >> White/XL = 131445 >> White/XXL = 131447 >> >> > > It would appear that the following relations hold > > Color Code > Red 0 > Blue 2 > Gray 3 > White 4 > > Size Code > M 1 > L 3 > XL 5 > XXL 7 > > so store only the base SKU (in your example 1314) in the product database (so > there is only a single record for each type/style of shirt). When you add a > line item to the shopping cart, use an [addlineitem] context on the target > page which combines the SKU, COLOR, and SIZE into the SKU that is stored in > the cart. > Use a formulas database to calculate the price based on the style and size > (being the first 4 characters and last 1 character of the cart SKU). I'm > assuming that color is not a price differential. > > Be thankful that your client has sensible SKU's, or else you would be > hard-pressed to do it this way... > > John --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Unfortunately, the example I gave below was pulled directly from my a$$. I have idea how the SKUs are organized in the client's actual inventory right now. I'll try to find out ASAP to see how complicated this is going to get. On 9/13/02 12:01 PM, John Peacock wrote:> Clint Davis wrote: >> >> SKUs for item 1314 >> -------------------------------------- >> Red/M = 131401 >> Red/L = 131403 >> Red/XL = 131405 >> Red/XXL = 131407 >> Blue/M = 131421 >> Blue/L = 131423 >> Blue/XL = 131425 >> Blue/XXL = 131427 >> Gray/M = 131431 >> Gray/L = 131433 >> Gray/XL = 131435 >> Gray/XXL = 131437 >> White/M = 131441 >> White/L = 131443 >> White/XL = 131445 >> White/XXL = 131447 >> >> > > It would appear that the following relations hold > > Color Code > Red 0 > Blue 2 > Gray 3 > White 4 > > Size Code > M 1 > L 3 > XL 5 > XXL 7 > > so store only the base SKU (in your example 1314) in the product database (so > there is only a single record for each type/style of shirt). When you add a > line item to the shopping cart, use an [addlineitem] context on the target > page which combines the SKU, COLOR, and SIZE into the SKU that is stored in > the cart. > Use a formulas database to calculate the price based on the style and size > (being the first 4 characters and last 1 character of the cart SKU). I'm > assuming that color is not a price differential. > > Be thankful that your client has sensible SKU's, or else you would be > hard-pressed to do it this way... > > John --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Clint Davis
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:
WebDNA Grep assistance [lowercase] (2003)
RE: [WebDNA] XML Help (2009)
Editing the search string (1997)
Passing Variable (was How to add product size) (1997)
What happened to the archives? (1999)
The Guru Speaks-Is That Really the Only Manuel? (1998)
Domain serial issue (2008)
[WebDNA] Writefile size limit? (2011)
[math date] with non-US date format (2000)
syntax question, not in online refernce (1997)
url .. (2003)
Truncated value after space - refresh my memory.... (1997)
Cart Question: The Epic Saga (1998)
suggestion (1997)
Problems getting parameters passed into email. (1997)
multiple databases (1997)
Sort Order on a page search (1997)
Random Number Generator works for Ranges of Numbers (1997)
Re:2nd WebCatalog2 Feature Request (1996)
[WebDNA] Middle Question (2015)