Re: Size/Color Options
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43378
interpreted = N
texte = 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 holdColor Code Red 0 Blue 2 Gray 3 White 4Size Code M 1 L 3 XL 5 XXL 7so 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-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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:
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 holdColor Code Red 0 Blue 2 Gray 3 White 4Size Code M 1 L 3 XL 5 XXL 7so 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-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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/
John Peacock
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:
New Site Announcement (1998)
WebCatalog for guestbook ? (1997)
So Simple (2005)
File Uploads... (1997)
Bug Report, maybe (1997)
Expected behavior? (1998)
[table] strange behaviour REAL solution (2003)
Major Security Hole IIS NT (1998)
[WebDNA] Mixed Content (2009)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
please unsubscribe me! (2000)
osx 10.3,webcat,permissions (2004)
Webcat interfering with Webstar? (1998)
Searchable WebCat (etc.) Docs ? (1997)
Explorer 3.0 (1997)
2.0 Info (1997)
# of real domains on 1 web server (1997)
Further on formula.db failure to calculate shipCost (1997)
Web Catalog vs. ICAT (1997)
problems with 2 tags (1997)