Hi Barry,
I would suggest you need 3 tables to handle this.
1. SalesItem
Item_id
Item_desc
etc
2. ProductGrouping
Group_Id
Group_Name
(e.g. audio version 3)
3. GroupedProduct
GroupId
ItemId
All you need to do when you're after related items is to
select groupid from groupedProduct where itemid = salesitem.itemid
select * from groupedProduct where groupid = <groupid from prev select>
and itemid <> salesitem.itemid
I hope that makes sense. I'd have put more detail in, but I need to get
ready to take my son to watch the Aussies thrash the Indians!
Cheers,
Phil.
----- Original Message -----
From: "barry.b" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 1:04 AM
Subject: [cfaussie] RE: thoughts on a "do you want fries with that"
upselling system?
> thanx for the suggestions Gavin and Darren
>
> (LOL, Darren! you've been thru that nightmare yourself before with
> clients, yes?)
>
> Thankfully, the guy is a bit more realistic than most. You can't model the
> real world, so don't try.
>
> The thing only needs to collect the order. Confirmation and sales happen
> via email or phone - there are just too many variables. a customer really
> might want Vers3 audio hardware and Vers2 audio software because it's for
> 2 diff jobs, just placed within the same order. A phone call or email will
> have to sort it out properly.
>
> along the lines of
>
> for each item in cart
> display item details
> query for companion products for that item
> if records returned
> display "here are suitable accessories"
> for each companion product
> display companion product details
> next (companion product)
> end if
> next (item)
>
> Which goes along with what Gavin was suggesting and having a rules table
> with 2 joins to the products table.
>
> Darren, I agree with you that the guy needs to get the rules down pat
> otherwise it'll be a pain in the bum. That's why I think I'll drop the
> exclusion idea (too hard/unnecessary), although it'll be the same process
> as above but use "anti-rules" ("this cannot go with that" rules).
>
> but you're right - keep it simple. you can make things foolproof, but you
> can't make them idiot proof!
>
> thanx again, people
>
> cheers
> barry.b
>
> (PS: My former students would be taking me to task over getting the
> terminology wrong. This is cross-selling. Upselling is talking them into a
> large coke when they wanted a medium. lucky they're not on list - I'd
> never live it down!)
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
[EMAIL PROTECTED]
>
> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> http://www.mxdu.com/ + 24-25 February, 2004
>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
