Re: Site / Database Structure
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42298
interpreted = N
texte = What exactly do you mean by WebCatalog's category structure? Are there some docs that I'm missing?-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Chris List Recipient Sent: Tuesday, August 06, 2002 10:50 AM To: WebCatalog Talk Subject: Re: Site / Database StructureWhy can't you use WebCatalog's category structure to create your category tree and assign the items? I find it very flexible and I think it would easily accomodate your 3-tier heirarchy.Regarding pricing... sounds like you may be better off coding each customer with a markup and then applying that to the price. For example, wholesale customers would be 0% and retail customers 100%. Apply the markup to the price when it is added to the cart. This will give you much better flexibility later on.-Chris-----Original Message----- From: Kimberly D Ingram [mailto:kim@netsourcery.com] Sent: Tuesday, August 06, 2002 7:47 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Site / Database Structure 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 SubcategoriesUGH!!!For example... a chocolate covered Oreo needs to appear in the following Series - Category - Subcategory1) Year Round Items - Gift & Basket Selections - Oreos 2) Gift Baskets - Basket Selections - Small Items 3) Special Occasions - Party Favors - Individually WrappedAt 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.40At the time the visitor starts shopping, they are identified as Retail or Wholesale depending on whether they log into the wholesale area with their account information. Then, to display the appropriate information from the catalog:1) I find all items marked T for the appropriate client (wholesale or retail) 2) Then, I find all items marked T in each of the main Series and display the matching Category and Subcategory names. 3) For pricing, I have math calculations in the formulas.db to determine: Retail= 2*(cost/case) or Wholesale=cost/caseDoes this sound like the best way to go about it, or is there a way to better structure the site and/or database(s)???? My main concern of course is future growth of the site.One added feature that I am already fully aware of is: custom product packaging. For example: the above chocolate covered Oreo, with the new feature, will be available:1) in standard packaging (cellophane bag with raffia tie) 2) in customized packaging for special events (cellophane bag with printed ribbon: Mr. & Mrs. Carlton Walls, August 17, 2002 ) 3) in customized packaging for special events (cellophane bag with printed ribbon: Happy Holidays from ACME, Inc. )My guess would be to incorporate some packaging information to the product database then reference additional costs in a packaging database. But of course, if the Oreos are being purchased as party favors for a wedding, they'll be purchased in bulk quantity therefore there will be a discount to the retail price. And, at the same time, if they're being purchased in bulk quantity for a corporate occasion, they will be sold at a discount to the wholesale price.WHEW!!Anyway, this gets very confusing for me!!! This is by far, the most complex product catalog that I've encountered since starting, and I'm a bit nervous about getting things set-up best in the beginning. I would really like some opinion on this one.Thanks so much!!! Kim ------------------------------------------------------------- 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/------------------------------------------------------------- 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:
What exactly do you mean by WebCatalog's category structure? Are there some docs that I'm missing?-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Chris List Recipient Sent: Tuesday, August 06, 2002 10:50 AM To: WebCatalog Talk Subject: Re: Site / Database StructureWhy can't you use WebCatalog's category structure to create your category tree and assign the items? I find it very flexible and I think it would easily accomodate your 3-tier heirarchy.Regarding pricing... sounds like you may be better off coding each customer with a markup and then applying that to the price. For example, wholesale customers would be 0% and retail customers 100%. Apply the markup to the price when it is added to the cart. This will give you much better flexibility later on.-Chris-----Original Message----- From: Kimberly D Ingram [mailto:kim@netsourcery.com] Sent: Tuesday, August 06, 2002 7:47 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Site / Database Structure 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 SubcategoriesUGH!!!For example... a chocolate covered Oreo needs to appear in the following Series - Category - Subcategory1) Year Round Items - Gift & Basket Selections - Oreos 2) Gift Baskets - Basket Selections - Small Items 3) Special Occasions - Party Favors - Individually WrappedAt 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.40At the time the visitor starts shopping, they are identified as Retail or Wholesale depending on whether they log into the wholesale area with their account information. Then, to display the appropriate information from the catalog:1) I find all items marked T for the appropriate client (wholesale or retail) 2) Then, I find all items marked T in each of the main Series and display the matching Category and Subcategory names. 3) For pricing, I have math calculations in the formulas.db to determine: Retail= 2*(cost/case) or Wholesale=cost/caseDoes this sound like the best way to go about it, or is there a way to better structure the site and/or database(s)???? My main concern of course is future growth of the site.One added feature that I am already fully aware of is: custom product packaging. For example: the above chocolate covered Oreo, with the new feature, will be available:1) in standard packaging (cellophane bag with raffia tie) 2) in customized packaging for special events (cellophane bag with printed ribbon: Mr. & Mrs. Carlton Walls, August 17, 2002 ) 3) in customized packaging for special events (cellophane bag with printed ribbon: Happy Holidays from ACME, Inc. )My guess would be to incorporate some packaging information to the product database then reference additional costs in a packaging database. But of course, if the Oreos are being purchased as party favors for a wedding, they'll be purchased in bulk quantity therefore there will be a discount to the retail price. And, at the same time, if they're being purchased in bulk quantity for a corporate occasion, they will be sold at a discount to the wholesale price.WHEW!!Anyway, this gets very confusing for me!!! This is by far, the most complex product catalog that I've encountered since starting, and I'm a bit nervous about getting things set-up best in the beginning. I would really like some opinion on this one.Thanks so much!!! Kim ------------------------------------------------------------- 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/------------------------------------------------------------- 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/
Kimberly D Ingram
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:
suffix mapping for NT? (1997)
[WebDNA] Secure Cookies (2009)
Listserver problem (1997)
Snake Bites (1997)
how to do multiple prices/item? (1998)
[date] for today's date, while inside old order file (1998)
If Empty ? (1997)
FAX orders (1996)
BUG in [showif] using ^ (contains) (1997)
Emailer choke (1997)
About WebDNA [well, and so the story ended] (2007)
Help formatting search results w/ table (1997)
OT - AppleScript Request (2004)
Snake Bites (1997)
Erotic Sites (1997)
[OT] FTP client (2003)
separate by mont (search) (2002)
WebCat2b15MacPlugin - showing [math] (1997)
F2 to F3 rocky transition (1997)
Webcat/Webmerchant (1998)