Re: Database Sizes

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35087
interpreted = N
texte = They should be able to order one product and choose their size and color then add to cart. Pricing remains the same.How would this be reflected in WEBDNA?Thanks.mark > Depends: is the user ever going to be able to order more than one size > or color of a given object at the same time? If the answer is no, you > can use a single SKU for all sizes, and store size and color in texta, > textb, etc. > > If the user can buy the same object in more than one color or size at > the same time, you will need to have a separate SKU for each possible > combination. I would create one table with SKU_COLOR_SIZE and each > column individually, like this: > > SKU_COLOR_SIZESKUCOLORSIZE > > and update it as you add items. Then if all like objects are priced > the same, you can store price/description/etc in a database with one > record for each SKU. The user selects model, color and size, and you > add that to the line items using the above database as the master. > > HTH > > John Peacock > > > Mac Sherwood wrote: >> >> What is the best way to have WebCatalog create sizes/colors within a >> product's field? >> >> Thanks >> >> mark >> >> ------------------------------------------------------------- >> 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/ > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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:

    
  1. Re: Database Sizes (Nicolas Verhaeghe 2000)
  2. Re: Database Sizes (Mac Sherwood 2000)
  3. Re: Database Sizes (Mac Sherwood 2000)
  4. Re: Database Sizes (Nicolas Verhaeghe 2000)
  5. Re: Database Sizes (John Peacock 2000)
  6. Re: Database Sizes (Mac Sherwood 2000)
  7. Re: Database Sizes (Nicolas Verhaeghe 2000)
  8. Database Sizes (Mac Sherwood 2000)
They should be able to order one product and choose their size and color then add to cart. Pricing remains the same.How would this be reflected in WEBDNA?Thanks.mark > Depends: is the user ever going to be able to order more than one size > or color of a given object at the same time? If the answer is no, you > can use a single SKU for all sizes, and store size and color in texta, > textb, etc. > > If the user can buy the same object in more than one color or size at > the same time, you will need to have a separate SKU for each possible > combination. I would create one table with SKU_COLOR_SIZE and each > column individually, like this: > > SKU_COLOR_SIZESKUCOLORSIZE > > and update it as you add items. Then if all like objects are priced > the same, you can store price/description/etc in a database with one > record for each SKU. The user selects model, color and size, and you > add that to the line items using the above database as the master. > > HTH > > John Peacock > > > Mac Sherwood wrote: >> >> What is the best way to have WebCatalog create sizes/colors within a >> product's field? >> >> Thanks >> >> mark >> >> ------------------------------------------------------------- >> 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/ > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/ Mac Sherwood

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] php/mySQL version of WebDNA Speed Test? (2012) Catalog page question (1999) WebCatalog template cache (1998) WebCat b13 CGI -shownext- (1997) BBEdit and WebCatalog 2.0? (1997) Adding multiple items to a DB from a search. (1998) Sorting error (1997) Suffix Mapping (1997) Emailer (1997) 5.0 Pricing (2003) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Windows-based Code Editor (2002) convertWords... NEW (2001) listfiles with large volume of files (2004) Separate SSL Server (1997) WCS Newbie question (1997) Rendering out a page (1997) interactive .pdf files and WebCatalog (2000) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) WebDNA color code chart - oops (2002)