Re: Database Sizes
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35068
interpreted = N
texte = 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_SIZE
SKUCOLORSIZEand 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.HTHJohn 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/
Associated Messages, from the most recent to the oldest:
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_SIZESKUCOLORSIZEand 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.HTHJohn 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/
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:
Dummy Credit Card Number for debug? (1997)
Cancel Subscription (1996)
Web requests in que... (2007)
Re:Why did PCS send me this? (1999)
Encrypt (2000)
Authenticate (1999)
Dumb Question about Docs (1997)
Webcat interfering with Webstar? (1998)
autocommit problem (1998)
Beta List (1998)
startat param not working (2008)
Location of Browser Info.txt file (1997)
how to check for no value while using [URL] to prevent cr (1999)
Dates (1996)
[WebDNA] Setting up a new server, hierarchy question (2014)
Running _every_ page through WebCat ? (1997)
Another question (1997)
French characters in variables (2001)
Repeating Fields (1997)
FEW QUESTIONS (1997)