[ic] RV: interchange-users Digest, Vol 22, Issue 27

Fri Apr 29 18:21:24 EDT 2005

Dear Andre,

I am subscribing to the list:

   1. RE: Changing multiple SKu (Andre Bunting)  
   2. RE: Multiple product layout on flypage.html (Andre Bunting)  
   3. Different input screen for different product groups  
      (Andre Bunting)

Best,

Jorge.
----------
De: 	interchange-users-request at icdevgroup.org[SMTP:interchange-users-request at icdevgroup.org]
Responder a: 	interchange-users at icdevgroup.org
Enviado el: 	Viernes, 29 de Abril de 2005 11:05 a.m.
Para: 	interchange-users at icdevgroup.org
Asunto: 	interchange-users Digest, Vol 22, Issue 27

Send interchange-users mailing list submissions to
	interchange-users at icdevgroup.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.icdevgroup.org/mailman/listinfo/interchange-users
or, via email, send a message with subject or body 'help' to
	interchange-users-request at icdevgroup.org

You can reach the person managing the list at
	interchange-users-owner at icdevgroup.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of interchange-users digest..."

Today's Topics:

   1. RE: Changing multiple SKu (Andre Bunting)
   2. RE: Multiple product layout on flypage.html (Andre Bunting)
   3. Different input screen for different product groups
      (Andre Bunting)

----------------------------------------------------------------------

Message: 1
Date: Thu, 28 Apr 2005 23:38:50 -0400
From: "Andre Bunting" <andreb at techess.com>
Subject: RE: [ic] Changing multiple SKu
To: <interchange-users at icdevgroup.org>
Message-ID: <20050429033755.3FA1393A9A at ns58.tstt.net.tt>
Content-Type: text/plain;	charset="us-ascii"

IT works :) 

Yippy :) .. fixed this.. 

I Love SQL :)

Andre
PS Mysql rocks

-----Original Message-----
From: Andre Bunting [mailto:andreb at techess.com] 
Sent: Thursday, April 28, 2005 8:45 AM
To: interchange-users at icdevgroup.org
Subject: [ic] Changing multiple SKu

Guys I believe I have found a way to update the sku's of products in my
products table.. since those that are clocks missing a c infront the watches
only missing a C infront of them... this sql statement I came across .

update products set sku = concat('c',sku) where product_catagory = 'clock'

I just wanted to know if anyone had done it before ?

Anyways no one got back to me on the "PageSelectField" .. where I was asking
if anyone had a working setup of it.. and also how did they modify their add
item fields for the different groupings..

Andre

_______________________________________________
interchange-users mailing list
interchange-users at icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

------------------------------

Message: 2
Date: Fri, 29 Apr 2005 00:48:25 -0400
From: "Andre Bunting" <andreb at techess.com>
Subject: RE: [ic] Multiple product layout on flypage.html
To: <interchange-users at icdevgroup.org>
Message-ID: <20050429044733.7BA1B93A95 at ns58.tstt.net.tt>
Content-Type: text/plain;	charset="us-ascii"

Good day all

I am do add this to my catalog.cfg

PageSelectField prod_group

And it send all the request for clocks to clocks.html (instead of
flypage.html) and for watches watches.html .. since these are the 2 groups
in my prod_group table ? once those pages exist (clocks.html and
watches.html) that will happen ?

Is that what you are saying once I set that up ?

If so at which point in my catalog.cfg should I put the PageSelectField . ?

Andre

-----Original Message-----
From: Paul Jordan [mailto:paul at gishnetwork.com] 
Sent: Tuesday, April 26, 2005 11:18 PM
To: interchange-users at icdevgroup.org
Subject: RE: [ic] Multiple product layout on flypage.html

Kevin Walsh wrote:
> Andre Bunting [andreb at techess.com] wrote:
>> I was wondering .. in my case I have clocks and watches..
>> now on the flypage.html.. I was wondering if I can have an if
>> statement to tell the flypage which layout to show, either the layout
>> for clocks or the layout for watches..
>> 
>> [snip: example code]
>> 
>> Is the approve possible ? if so how to do it.. secondly .. what would
>> I have to do so that in the admin section I would have two sets of
>> input screens.. one for clocks.. others for watches ?
>> 
> You could code two completely different layouts into one
> flypage.html but what would happen, in the future, when you
> decide that you want three types of layout (perhaps a new one
> for grandfather clocks)?  The code could become very
> difficult to maintain after a while.
> 
> A cleaner solution be to use a different flypage for each product
> type. See the "PageSelectField" configuration directive:
> 
>     http://www.interchange.rtfm.info/docs/rtfm_icconfig.html

[corrected post]
Andre Bunting [andreb at techess.com] wrote:
> Hi.. I have read this topic.. on that page..
> 
> I wish to know if anyone has done this before..
> 
> I would like to get their feed back on how effective it has
> work.. as well as a working example..
> 

Many people do this, and it works perfect. You can set the flypage to
"change" based on any field you want, usually in the products DB. So,
lets say you choose "prod_group", then each prod_type can have a
separate flypage made, falling back on just flypage.html (I believe) if
none exists for a particular prod_type value.    

I use it, but my flypages look the same. I use it to run different
queries based on certain things, but visually, its almost the same. 

> Does this also mean that each item ended, one will have to
> set what flypage to use ?(dumb quesito.. but I want to make sure)

Well, it can be transparent, as you would "base" it on a field, say
'prod_group', or 'category', so you are setting those anyways. Of
course, if you based them upon whim, then yes, you'd have to set it
manually each time.   

If the value of prod_group is "watches", then it would appear on the
"watches.html" flypage, if the value was tools, then it would appear on
the "tools.html" flypage.  

Paul

[snip top posting]

_______________________________________________
interchange-users mailing list
interchange-users at icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

------------------------------

Message: 3
Date: Fri, 29 Apr 2005 00:51:27 -0400
From: "Andre Bunting" <andreb at techess.com>
Subject: [ic] Different input screen for different product groups
To: <interchange-users at icdevgroup.org>
Message-ID: <20050429045030.2074893A96 at ns58.tstt.net.tt>
Content-Type: text/plain;	charset="us-ascii"

Good day all

Is it possible to have multi input screens for my different product groups
in the admin GUI ?

If so how?

Andre

PS thanks for all the tons of help..

------------------------------

_______________________________________________
interchange-users mailing list
interchange-users at icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

End of interchange-users Digest, Vol 22, Issue 27
*************************************************