[ic] Active / Inactive Items

Peter peter at pajamian.dhs.org
Mon Apr 19 06:55:40 EDT 2004


John1 wrote:
> On Monday, April 19, 2004 7:36 AM, interchange at samcompc.com wrote:
> 
> 
>>Hello,
>>
>>Does anyone know how to get the Active/Inactive option to work with
>>interchange 5.0
>>
> 
> Make sure you have the following line in your db conf file  (e.g.
> products.mysql)
> 
> Database  products  HIDE_FIELD   inactive
> 
> Then, a 1 in the inactive field should deactivate that product (use a 0 for
> all active products).

One thing to keep in mind is that doing it this way will make it so that 
that products with a 1 essentially become completely invisible to IC. 
You won't even be able to find them in the admin interface.  The only 
way you will be able to get an item back once it is marked inactive is 
to go into your sql backend and do an UPDATE from there to set the field 
back to 0 (or possibly can get it back from the direct SQL entry page, 
not sure about that).

Another way to do it is to simply exclude items which have inactive set 
to 1 from your searches, by adding the following to all your searches:
sf=inactive
se=1
op=ne

General Disclaimer here:  This is just what I've found from my own 
catalogs, and some of them are a bit on the old side so things may have 
changed, etc. YMMV

Regards, Peter


More information about the interchange-users mailing list