Re: how to do multiple prices/item?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17273
interpreted = N
texte = Look at www.musicianstore.com. I did this for the cables, drumsticks, cymbals and software. Different items may have different prices for specific options, or perhaps just an option with no price delta. Basically you need to add an option.db related to inventory.db by SKU. Each option has its own SKU, which may have a price delta with it. For cables, there can be up to three options chosen, so there's three option.dbs.The option fields are hidden if that item doesn't have options.It gets quite tricky carrying it through the shopping carts and figuring how much is being saved from list. But it can be done.Sandy >Hi all, am seeking advice/tips on how to add the ability to offer multiple >price points on an item. Let me describe where I am and what I'd like to go >briefly... > >CURRENT: one sku = one price (same as General Store example) > >DESIRE: one item may have several versions with different prices > > > Example A: music item has: > * CD version ($15.99) and > * casette version ($9.99) > > > Example B: jewelry item has: > > * silver version > -- sizes A-B ($30) > -- sizes C-D ($35) > > * 14K gold version > -- sizes A-B ($150) > -- sizes C-D ($175) > > * 18K gold version > -- sizes A-B ($225) > -- sizes C-D ($250) > > > I know it would be easy to assign a different SKU to each one (and >shoppers would see multiple versions in the search results), but I'd prefer >to have searches return the item then let shoppers choose the particular >version/price when viewing the details page. > >TIA for advice and tips, > >Dale Stokdyk >World Romance >Romantic Gifts from Around the World >http://www.me2u.com > > > > > >
Associated Messages, from the most recent to the oldest:
Look at www.musicianstore.com. I did this for the cables, drumsticks, cymbals and software. Different items may have different prices for specific options, or perhaps just an option with no price delta. Basically you need to add an option.db related to inventory.db by SKU. Each option has its own SKU, which may have a price delta with it. For cables, there can be up to three options chosen, so there's three option.dbs.The option fields are hidden if that item doesn't have options.It gets quite tricky carrying it through the shopping carts and figuring how much is being saved from list. But it can be done.Sandy >Hi all, am seeking advice/tips on how to add the ability to offer multiple >price points on an item. Let me describe where I am and what I'd like to go >briefly... > >CURRENT: one sku = one price (same as General Store example) > >DESIRE: one item may have several versions with different prices > > > Example A: music item has: > * CD version ($15.99) and > * casette version ($9.99) > > > Example B: jewelry item has: > > * silver version > -- sizes A-B ($30) > -- sizes C-D ($35) > > * 14K gold version > -- sizes A-B ($150) > -- sizes C-D ($175) > > * 18K gold version > -- sizes A-B ($225) > -- sizes C-D ($250) > > > I know it would be easy to assign a different SKU to each one (and >shoppers would see multiple versions in the search results), but I'd prefer >to have searches return the item then let shoppers choose the particular >version/price when viewing the details page. > >TIA for advice and tips, > >Dale Stokdyk >World Romance >Romantic Gifts from Around the World >http://www.me2u.com > > > > > >
Sandra L. Pitner
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:
File Upload (1997)
Summary search -- speed (1997)
[WebDNA] TRIM (2008)
Rendering out a page-test results (1997)
[cart]'s ever get recycled? (2000)
RE: Questions To Answer (1997)
Summing fields (1997)
[WebDNA] WebDNA Crashing or Not **YES** (2008)
[platform] tag? (1998)
[TCPConnect] questions/problems (2001)
Nav. 4 probs with cart (1997)
RE: extended ASCII with middle command (1999)
Cancel Subscription (1996)
case sensitivity in lookups (1997)
Big Databases (1997)
Trouble serving graphics on protected templates (1998)
File Uploads (1998)
Frames and WebCat (1997)
Problem using # in my field names ... (1998)
[Sum] function? (1997)