[ic] Returning products with various default options...
D Zhang - msi
interchange-users@icdevgroup.org
Sun Jan 5 04:11:01 2003
let me try to see if I can understand
You have
(1) shoes in different sizes (so, need to select which size)
(2) one size of the shoes from different manufacturers that are labeled
differently, but equivalent among them.
Currently:
In your products table, you have one field specifies common, or default
sizes, which is optional for customers to select at time of "buy now"
Your difficulty is:
The manufacturer or their equivalent size number is not specified, and thus,
you don't know which product to ship, or not available for custumer to
choose which manufacturer's product
What you are trying to accomplish is:
give one "buy now" bottom that tells both the size and the manufacuterer (or
the equivalent size given by that manufacterer)
If my understanding is correct, then, I think you'll have to have two
options for customer to specify: size and manufacturer (or their equivalent
size). It's a (x,y) two dimenssion issue that can't be determined by just
giving (x) or (y). This is the same as selecting sizes and colors. No way
can one tell the color from the size. So, adding one more optional field
(manufacture) in the results page should be the easy way. .
To do this, in the "another field", list manufacturer name, instead of the
equivalent size number. Operationally, take the "default" size just as a
reference rather than actual shoe size. Keep a table that maps the "default"
to actual sizes giving by different manufaturers
default size 1 2 3 4 5 6
size of M.A 3 5 6 8 9 12
size of M.B 2 4 6 8 10 12
size of M.C (what ever the equivalent size number)
size of M.D ......
......
If you want to make it easy yourself, simply give the table to your people,
tell them to prepare orders according that table. To avoid confusing, give
"size reference" as the field name of the "default size", rather than simply
"size". So, when your people read the order sheet, they'll know it's a
"reference number", and they have to pick up the right size according the
table.
To be perfect, you can implement that table in your database, bring up the
actual size as a hidden field when customer select a specific manufacterer.
Then, you get "products with various default options", e.g. manufacturer and
actual size given by that manufacturer.
Hope, this is helpful.
David
dzhang@msihosting.com
Mount Spring International
http://www.msihosting.com
----- Original Message -----
From: <music@labyrinth.net.au>
To: <interchange-users@icdevgroup.org>
Sent: Saturday, January 04, 2003 11:15 PM
Subject: Re: [ic] Returning products with various default options...
> > > I am wondering if I can return a results page with various sizes
> returned
> > > based on a value in another field in the products database.
> >
> > Simply add one more display field in your current results page. Make the
> > added display field as a link to (or search for) other product(s) based
> on
> > the "value in another field"
>
>
> I just knew that my question was a bit unclear.
>
> What I am needing is a page of search results that will include 'buy now'
> buttons. (easy enough)
> but clicking 'buy now' will add the item to the cart with a size 'option'
as
> pulled from the query, not the default option value.
>
> I guess my first question should have been:
>
> Can I create a 'buy now' button that adds an item to the cart with an
option
> selected other than the default?
>
> Is there an IC tag that allows me to specify a value for an option before
an
> item is added to a cart?
>
> Thanks in advance
>
> Simon
>
>
>
>
> >
> >
> > ----- Original Message -----
> > From: <music@labyrinth.net.au>
> > To: <interchange-users@icdevgroup.org>
> > Sent: Friday, January 03, 2003 5:26 AM
> > Subject: [ic] Returning products with various defaul options...
> >
> >
> > > I have a store that has many items that all have different 'size'
> options.
> > >
> > > I am wondering if I can return a results page with various sizes
> returned
> > > based on a value in another field in the products database.
> > >
> > > i.e. Click here to see related products with recommended sizes to fit
> your
> > > show size.
> > >
> > > (Manufacturer marked sizes (in the product options) is not always same
> as
> > > the real size so we have given a hidden value for these in the
products
> > > table)
> > >
> > > Typical Results should yield links to:
> > >
> > > Manufacturer - Product - default option
> > > Manufacturer X - shoe Z - size 9 (hidden value 9)
> > > Manufacture Y - show A - size 10 (hidden value 9)
> > > Manufacturer Z - shoe C - size 9 1/2 (hidden value 9)
> > >
> > >
> > > Another shoe sized person might yield results like:
> > > Manufacturer - Product - default option
> > > Manufacturer X - shoe Z - size 8 - (hidden value 8)
> > > Manufacture Y - show A - size 9 - (hidden value 8)
> > > Manufacturer Z - shoe C - size 8 1/2 - (hidden value 8)
> > >
> > >
> > > I hope this is clear?
> > >
> > > Maybe the question could be better asked, can I create a search for
> > products
> > > which present a link to a product where the default size option
changes
> > > based on a hidden value in the products database?
> > >
> > > I hope this is now too way obscure a question; please let me know.
> > >
> > > Using 4.8.6/mysql
> > >
> > > Many thanks in advance for any guidance or yes no answers!!!!
> > >
> > > Simon
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > interchange-users mailing list
> > > interchange-users@icdevgroup.org
> > > http://www.icdevgroup.org/mailman/listinfo/interchange-users
> > >
> > >
> >
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@icdevgroup.org
> > http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>