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_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/ 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)
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:

time sort question (2005) The EMailer and the Blank menu bar? (1999) Navigator 4.01 (1997) What am I missing (1997) WebCat hosting providers? (1997) webcatalog [date] bug...not (1999) Viewing/Editing Databases Online (1999) Re requiredFields parameter (1998) Re:2nd WebCatalog2 Feature Request (1996) [WebDNA] Unexpected search results (2014) Browsername (1998) A question on sub-categories (1997) WebCat2 - Getting to the browser's username/password data (1997) Same Database needed on two machines (2002) RE: [WebDNA] An unknown error occured // Deadlock avoided (2011) Problems passing [SKU] with $Replace in 2.0 (1997) Upgrade to 4.0 (2001) Apoligy (1997) [ShowIf] and empty fields (1997) b12 cannot limit records returned and more. (1997)