Re[2]: SKU number.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28518
interpreted = N
texte = I'm not saying you cannot have a field called [giftSKU], only that you cannot use that field as the unique [SKU] value in the shopping cart. If I understand you correctly, you have a database with some of the items that may have an associated gift. You can easily add the [giftSKU] field to the existing database and fill it in with the appropriate value.Then at the point of adding an item to the shopping cart, put an [AddLineItem] to add another [SKU] (say [SKU]=GIFT), and store the giftSKU value in textA. Depending on how you add line items, this may be a loop on the second page that steps through and adds the main line item followed by any associated gift. Then alter your display page to list any line that has a [SKU]=GIFT with the line Include this FREE GIFT! or whatever. You will need an item in your database that has a [SKU] of GIFT (you can make the Price=0 and UnitShipCost=1.00 if you charge shipping on gifts).The point here being that you need a SKU to add something to the shopping cart, but this is so WebCat has something to lookup a [Price] on. Once it is there, you can display it anyway you like.HTHJohn Peacock ____________________Reply Separator____________________ Subject: Re: SKU number. Author:
(WebCatalog Talk) Date: 3/3/00 12:54 PM>SKU is the unique identifier used by WebCat; you cannot use anything else. >Why >do you need to put this gift certificate into an existing file? Can't you >have >a second database and store the gift certificates there? Are you using >Typhoon, >by any chance?It's really to save time with the data entry people, John, so they don't have to open an additional database file to modify people who take advantage of the gift cert feature. I'll probably just end up making a relational database (but that'll take longer to set up.That original database already has SKU, so I will have to make another one probably, if there's no way around it.CJF> >Read my long message about WebCat design philosophy... > >John Peacock > > >____________________Reply Separator____________________ >Subject: SKU number. >Author: (WebCatalog Talk) >Date: 3/3/00 12:21 PM > >I am storing a products database for a gift certificate database in a file >which already contains a variable called SKU. > >I would like instead for the shopping cart to look for the variable giftSKU. >Anyone know the easiest way to do this? I'm thinking it's something I could >put in the formulas.db ... > >Christopher Feyrer > >Christopher Feyrer >System Administrator >FoodSpot.com >chris@foodspot.com >------------------- >PGP 6.x key available. > > > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >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 > Christopher Feyrer System Administrator FoodSpot.com chris@foodspot.com ------------------- PGP 6.x key available. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
| |
- Re[2]: SKU number. (jpeacock@univpress.com 2000)
|
I'm not saying you cannot have a field called [giftSKU], only that you cannot use that field as the unique [SKU] value in the shopping cart. If I understand you correctly, you have a database with some of the items that may have an associated gift. You can easily add the [giftSKU] field to the existing database and fill it in with the appropriate value.Then at the point of adding an item to the shopping cart, put an [addlineitem] to add another [SKU] (say [SKU]=GIFT), and store the giftSKU value in textA. Depending on how you add line items, this may be a loop on the second page that steps through and adds the main line item followed by any associated gift. Then alter your display page to list any line that has a [SKU]=GIFT with the line Include this FREE GIFT! or whatever. You will need an item in your database that has a [SKU] of GIFT (you can make the Price=0 and UnitShipCost=1.00 if you charge shipping on gifts).The point here being that you need a SKU to add something to the shopping cart, but this is so WebCat has something to lookup a [Price] on. Once it is there, you can display it anyway you like.HTHJohn Peacock ____________________Reply Separator____________________ Subject: Re: SKU number. Author: (WebCatalog Talk) Date: 3/3/00 12:54 PM>SKU is the unique identifier used by WebCat; you cannot use anything else. >Why >do you need to put this gift certificate into an existing file? Can't you >have >a second database and store the gift certificates there? Are you using >Typhoon, >by any chance?It's really to save time with the data entry people, John, so they don't have to open an additional database file to modify people who take advantage of the gift cert feature. I'll probably just end up making a relational database (but that'll take longer to set up.That original database already has SKU, so I will have to make another one probably, if there's no way around it.CJF> >Read my long message about WebCat design philosophy... > >John Peacock > > >____________________Reply Separator____________________ >Subject: SKU number. >Author: (WebCatalog Talk) >Date: 3/3/00 12:21 PM > >I am storing a products database for a gift certificate database in a file >which already contains a variable called SKU. > >I would like instead for the shopping cart to look for the variable giftSKU. >Anyone know the easiest way to do this? I'm thinking it's something I could >put in the formulas.db ... > >Christopher Feyrer > >Christopher Feyrer >System Administrator >FoodSpot.com >chris@foodspot.com >------------------- >PGP 6.x key available. > > > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >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 > Christopher Feyrer System Administrator FoodSpot.com chris@foodspot.com ------------------- PGP 6.x key available. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
jpeacock@univpress.com
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:
Nesting format tags (1997)
IE Cache Problems... (1999)
Eudora Plugin (1999)
Exclamation point (1997)
Format all of a sudden doesn't work (1997)
WebDNA for Dummies (2004)
cookie length (1998)
[WebDNA] Limited Time Discount on WebDNA Server licenses (2013)
send mail problem? (1997)
taxTotal, grandTotal (1997)
WebCatalog on G3 Macs? (1997)
date formatting for CC card expiration date check (1998)
Time code! (2002)
Forcing a NEWCART (1997)
Popup Menu Options (1998)
Dumb Question about Docs (1997)
[SearchString] problem with [search] context (1997)
Order not created error (never mind) (1997)
Include a big block of text (1997)
Blank orders after update to 5.1 (2003)