Re: Site / Database Structure
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42301
interpreted = N
texte = Kimberly D Ingram wrote: > Ok, here goes: I need direction for a gourmet chocolate factory. > > They need 2 areas for their website visitors, (retail and wholesale) of > course with separate pricing. > On top of that, some of the products will appear in multiple “Series” under > various “Categories” and “Subcategories” > > UGH!!! > > For example… a chocolate covered Oreo needs to appear in the following > “Series – Category – Subcategory“ > > 1) Year Round Items – Gift & Basket Selections – Oreos > 2) Gift Baskets – Basket Selections – Small Items > 3) Special Occasions – Party Favors – Individually Wrapped > > At this point, I have the database set-up like this: (YE is Year Round > Series, BA is Gift Baskets Series and SP is Special Occasions Series) > > SKU Item YE YECat YESubCat BA BACat BASubCat SP SPCat > SPSubCat Wholesale Retail Case Cost > 123 Chocolate Covered Oreo T Gift & Basket Selections Oreos T > Basket Selections Small Items T Party Favors Individually Wrapped > T T 24 20.40This way lies madness! Seperate your product table from your categories from your pricing:Product.db:SKU Item Wholesale Retail 123 Chocolate Covered Oreo T TCategory.dbSKU SERIES SUBSERIES 123 Gift & Basket Selections Oreos 123 Basket Selections Small Items 123 Party Favors Individually WrappedPrice.dbSKU Wholesale Retail Case 123 16.0 24.0 24or something like that. You then use your Formulas.db to [lookup] the appropriate price from the Price.db based on whether the customer is Wholesale or Retail. I assigned a Wholesale price so you could see that you don't need to store the flag there; keep it in the Product.db just so you can quickly eliminate items from the search for non-wholesale customers...HTHJohn-- 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:
Kimberly D Ingram wrote: > Ok, here goes: I need direction for a gourmet chocolate factory. > > They need 2 areas for their website visitors, (retail and wholesale) of > course with separate pricing. > On top of that, some of the products will appear in multiple “Series” under > various “Categories” and “Subcategories” > > UGH!!! > > For example… a chocolate covered Oreo needs to appear in the following > “Series – Category – Subcategory“ > > 1) Year Round Items – Gift & Basket Selections – Oreos > 2) Gift Baskets – Basket Selections – Small Items > 3) Special Occasions – Party Favors – Individually Wrapped > > At this point, I have the database set-up like this: (YE is Year Round > Series, BA is Gift Baskets Series and SP is Special Occasions Series) > > SKU Item YE YECat YESubCat BA BACat BASubCat SP SPCat > SPSubCat Wholesale Retail Case Cost > 123 Chocolate Covered Oreo T Gift & Basket Selections Oreos T > Basket Selections Small Items T Party Favors Individually Wrapped > T T 24 20.40This way lies madness! Seperate your product table from your categories from your pricing:Product.db:SKU Item Wholesale Retail 123 Chocolate Covered Oreo T TCategory.dbSKU SERIES SUBSERIES 123 Gift & Basket Selections Oreos 123 Basket Selections Small Items 123 Party Favors Individually WrappedPrice.dbSKU Wholesale Retail Case 123 16.0 24.0 24or something like that. You then use your formulas.db to [lookup] the appropriate price from the Price.db based on whether the customer is Wholesale or Retail. I assigned a Wholesale price so you could see that you don't need to store the flag there; keep it in the Product.db just so you can quickly eliminate items from the search for non-wholesale customers...HTHJohn-- 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:
OT: 800x600 (2003)
PROBLEM (1997)
Apache 2.2 (2007)
How do I pass [cart] when user clicks back (2000)
Shipcost lookup? (1997)
listfiles, moving files (1998)
Emailer [cart] file names (1997)
WebCat2 beta 11 - new prefs ... (1997)
Database Advice (1996)
[format xs] freeze (1997)
Test (2003)
PCS Frames-Default page is solution! (1997)
can pull down menu do a ONCHANGE= without Java script? (2000)
SiteEdit NewFile.html ? (1997)
Spreadsheet App pref. [OT] (2001)
Soft return (2001)
Date comparison has serious bug ... (1998)
TCPConnect / Current Temperature (2004)
WebCatalog for Postcards ? (1997)
For those of you not on the WebCatalog Beta... (1997)