Site / Database Structure
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42295
interpreted = N
texte = 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 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/
Associated Messages, from the most recent to the oldest:
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 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/
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:
Need relative path explanation (1997)
[WebDNA] OSX users (2009)
&fieldsdir=ra truely random?? (2000)
temporary database? (2000)
Text data with spaces in them... (1997)
Emailer (1997)
PCS Customer submissions ? (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
WebCat2b12 forgets serial # (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Search Form (2000)
I'm Sorry - OFF TOPIC (2000)
Boolean showifs? (2000)
This is an odd error (2001)
Remote Admin Design Question (1998)
Where's Cart Created ? (1997)
cookies (2004)
Req: Array Tags Explained, simple and clear (2004)
Summing fields (1997)
[SHOWIF AND/OR] (1997)