[ic] Categories - one product in multiple categories
Fri, 02 Mar 2001 17:48:58 -0500
> On Fri, Mar 02, 2001 at 12:30:43PM -0800, firstname.lastname@example.org wrote:
> > Does anyone know the magic trick for allowing one product to appear in
> > multiple categories? Can't seem to find any info in the .pdf files or
> > here among the users.
> keep the list of categories in which any particular product belongs
> in a separate table and JOIN
Alrternatively, a somewhat simpler way of doing this is to set up
multiple category columns
sku desc cat_1 cat_2 cat_3
1 this none blue
2 that all red
3 other all blue
Then you just search against all three categories for the key word. In
this case a search on blue would return products 1 and 3, a search on
all would return 2 and 3. A search on this and blue would return only 1.
Assuming that you disabled or searching.
The problem is that this only works well with smaller catalogs and a low
number of categories columns. If you have 16 category columns and 27,000
items this is simply not the right way to do it. Mr. Miller's example
seems more versatile to me.