[ic] Active / Inactive Items
peter at pajamian.dhs.org
Mon Apr 19 06:55:40 EDT 2004
> On Monday, April 19, 2004 7:36 AM, interchange at samcompc.com wrote:
>>Does anyone know how to get the Active/Inactive option to work with
> Make sure you have the following line in your db conf file (e.g.
> 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:
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
More information about the interchange-users