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:
A multi-processor savvy WebCatalog? (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Too Much Rootbeer Free Offer (1997)
Cancel Subscription (1996)
Smith Micro - no competition (2000)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
all records returned. (1997)
Summing fields (1997)
WebCatalog for Mac 2.0.1 Released (1997)
W* 4.2 / WebCat (TPro) 3.0.5b / OS 8.5.1 / BW G3 (2000)
WebCatalog2 Feature Feedback (1996)
Nav. 4 probs with cart (1997)
[taxRate] [TaxTotal] ? (1997)
Users and groups for local directories (1999)
Help!!!! (1997)
includes and cart numbers (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
[ShowCart] and GET vs. POST (1997)
WebCommerce: Folder organization ? (1997)