Re: Opinion Poll Please
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41449
interpreted = N
texte = Kimberly D Ingram wrote: > When dealing with product databases that entail various prices based on > color and/or size, etc. do you find it most efficient to: > > a) Unique Product ID for each size > b) Calculated Price > c) Other, please explain.... > The key is to understand is that the SKU in the product database does not need to be the same as the SKU in the orderfile. Once you move into the realm of using a formula to calculate your pricing, you can go wild.So, for example, I order a red shirt, size extra large. The SKU in the product database is SHIRT, but when the order is added to the cart, the SKU entered is SHIRT-RED-XLand the formula picks out those three things to calculate the price: SHIRT's are $10 (product database [lookup]) RED is the normal color, subtract $2 (color database [lookup]) XL is more fabric, add $4 (size database [lookup])for a total price of $12.John-- 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: > When dealing with product databases that entail various prices based on > color and/or size, etc. do you find it most efficient to: > > a) Unique Product ID for each size > b) Calculated Price > c) Other, please explain.... > The key is to understand is that the SKU in the product database does not need to be the same as the SKU in the orderfile. Once you move into the realm of using a formula to calculate your pricing, you can go wild.So, for example, I order a red shirt, size extra large. The SKU in the product database is SHIRT, but when the order is added to the cart, the SKU entered is SHIRT-RED-XLand the formula picks out those three things to calculate the price: SHIRT's are $10 (product database [lookup]) RED is the normal color, subtract $2 (color database [lookup]) XL is more fabric, add $4 (size database [lookup])for a total price of $12.John-- 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:
Big Databases (1997)
file browser. (2002)
Reversed words (1997)
missing records (1998)
Sort of a Dilema! (1998)
SAVECART (1997)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
How To Install (2003)
Assigning carts (1998)
[LOOKUP] (1997)
serial number generation (1997)
COST? WebCatalog Training Class July 23-24 in San Diego (2001)
Trying to loop for letters (1999)
[TaxableTotal] - not working with AOL and IE (1997)
WebTen Memory Error with Plug-In (1998)
WebCat2 - many [carts] on one template page? (1997)
OT: Limit on # of Pulldown entries (1997)
[WebDNA] TCPConnect Problem (2010)
Email notification to one of multiple vendors ? (1997)
Logical and or in [hideif] (1997)