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 suppressed Mount Spring International http://www.msihosting.com ----- Original Message ----- From: <suppressed> To: <suppressed> 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: <suppressed> > > To: <suppressed> > > 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 > > > suppressed > > > http://www.icdevgroup.org/mailman/listinfo/interchange-users > > > > > > > > > > _______________________________________________ > > interchange-users mailing list > > suppressed > > http://www.icdevgroup.org/mailman/listinfo/interchange-users > > _______________________________________________ > interchange-users mailing list > suppressed > http://www.icdevgroup.org/mailman/listinfo/interchange-users > > _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.