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:
Why do extra quotation marks sometimes appear in my databases? (1998)
Online reference (1997)
can webcat determine an image's pixel dimensions? (2000)
Prices coming up 0.00 (2001)
Help! WebCat2 bug (Ben's input) (1997)
urls (2005)
Clearing orders and database help! (1997)
(2006)
SiteGuard Admin Feature ? (1997)
Re:listfiles-looking for slick solution (1997)
Sorting Numbers (1997)
"top" Clarification ( for apache ) (2008)
Re:2nd WebCatalog2 Feature Request (1996)
Further tests with the infamous shipCost (1997)
Exists? (1997)
taxrate - off by 1 cent (1997)
bug in [SendMail] (1997)
Nested tags count question (1997)
OT: zipcodes (2002)
[carts] and databases (1997)