[ic] gouping items

[johny brabo]

Thank you for the hints Scott and Christopher,

I didn't know that the shopping cart takes care of
assemblies that way, but I'm certainly going to use
it.

kind regards


----- Original Message ----- 
From: scott andreas
<scotta@homer-simpson.learnserv.com>
To: <interchange-users@lists.akopia.com>
Sent: Monday, February 05, 2001 8:26 PM
Subject: Re: [ic] gouping items


> cfm@maine.com wrote:
> > 
> > On Mon, Feb 05, 2001 at 05:59:22AM -0800, johny
brabo wrote:
> > > Hello,
> > > Maybe my last question wasn't very clear since I
> > > didn't get an answer.
> > >
> > > I am looking for a simple way to show an item
and
> > > links to parts of that item, so eg. I show a
computer
> > > and beneath it I show links to the parts. People
can
> > > Buy the whole computer, but they also can see
what
> > > screen it has, what memory and so on...
> > >
> > > The "order groups"-function doesn't seem to fit
my
> > > needs since there is no need to sell multiple
items at
> > > once. Also "accesoires" isn't really what I need
I
> > > guess. Can someone hint me to a solution?
> > 
> > TABLE assemblies (
> >   code varchar
> >   part varchar
> > )
> > 
> > Where code is the big item and "part" is the code
> > for the item that goes into it.  One code in your
> > products table can have any number of records in
> > assemblies.  I'm presuming that each "part" in
assembly
> > is also in your products table so you can pull the
additional
> > information you need.  Alternatively, denormalize
> > assemblies and add the fields to make display
easier/faster.
> > 
> > SELECT * FROM products WHERE code=[item_code]; #
display item
> > 
> > SELECT * FROM assemblies WHERE code=[item_code]; #
for each loop
> > 
> > 
> > >
> > > Any small advice is appreciated
> > >
> > >
__________________________________________________
> > > Get personalized email addresses from Yahoo!
Mail - only $35
> > > a year!  http://personal.mail.yahoo.com/
> > >
> > > _______________________________________________
> > > Interchange-users mailing list
> > > Interchange-users@lists.akopia.com
> > >
http://lists.akopia.com/mailman/listinfo/interchange-users
> > 
> > --
> > 
> > Christopher F. Miller, Publisher                  
          cfm@maine.com
> > MaineStreet Communications, Inc         208
Portland Road, Gray, ME  04039
> > 1.207.657.5078                                    
  http://www.maine.com/
> > Content management, electronic commerce, internet
integration, Debian linux
> > 
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> >
http://lists.akopia.com/mailman/listinfo/interchange-users
> 
> Here's an idea.
> 
> Have the user select the computer. The cart will
display the computer
> with related items all checked beneath it. If the
user unchecks the
> related item the cart will recalculate itself
subtracting the unneeded
> item. Or you can start with a base model and add
related items to it in
> the cart. This way the user check the box and adds
parts to the computer
> hince building a computer.
> 
> Within the cart the user can click on the 
description hyperlink to view
> what that item actually is
> 
> Just a suggestion
> -- 
> J. Scott Andreas :)
> Programmer/Webintegrator 
> e-mail: scotta@homer.learnserv.com
> phone: 1-800-877-9378 ext. 146
> fax: (541) 744-2056
>       ---    __o
>      ---   _-\<,_        
>       --- (_)/ (_)
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/