Re: Need Advice for Setting up a Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25664
interpreted = N
texte = > > > >I am working on a site and need some advice on the best way to set up the > > >database. I have various products (jackets, shirts, etc.) that come in > > >various sizes and various colors. The problem I am running into is the >best > > >way to set it up for varying prices depending on the price. > > > > > >XXX-L and XXXX-L shirts have an automatic price increase. How would you >set > > >up a database to feature this information?Another technique is to set up a second relational table and use it to store the different prices. The storebuilder does this, it might be worth it for you to take a look at those templates too. Your db might look something like this:SKU
MEASURE PRICE 01 1 5 01 2 6 01 3 7 02 1 8 02 2 9 02 3 10You can now use the SKU from the products.db to search this second relational table to get the right price for the SKU and MEASURE. Remember that when you are changing the price of an item after it has been added to the cart you must use the price change password.---------------- Technical Support Smith Micro, Internet Solutions Division Formerly Pacific Coast Software --------------------------------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
> > > >I am working on a site and need some advice on the best way to set up the > > >database. I have various products (jackets, shirts, etc.) that come in > > >various sizes and various colors. The problem I am running into is the >best > > >way to set it up for varying prices depending on the price. > > > > > >XXX-L and XXXX-L shirts have an automatic price increase. How would you >set > > >up a database to feature this information?Another technique is to set up a second relational table and use it to store the different prices. The storebuilder does this, it might be worth it for you to take a look at those templates too. Your db might look something like this:SKU MEASURE PRICE 01 1 5 01 2 6 01 3 7 02 1 8 02 2 9 02 3 10You can now use the SKU from the products.db to search this second relational table to get the right price for the SKU and MEASURE. Remember that when you are changing the price of an item after it has been added to the cart you must use the price change password.---------------- Technical Support Smith Micro, Internet Solutions Division Formerly Pacific Coast Software --------------------------------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Smith Micro Support
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:
[TaxableTotal] - not working with AOL and IE (1997)
Online reference (1997)
FISKARS (2003)
[OT] WebDNA Training (UK) (2003)
OLD ORDERS (1998)
getchars broken? (1997)
Sending E-mail (1997)
Dreamweaver UltraDev (2000)
Banner Ads (2000)
Summing fields (1997)
change the number format (1997)
grabbing xml data with webcat (was: Posting XML data toSSL (2002)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
The List is Changing (1997)
emailer stuck (1997)
WebDelivery: One step closer !! (1997)
Dubble Sku's in a Database (1999)
process SSI (1998)
Requiring that certain fields be completed (1997)
How to Display text in empty fields (1997)