Hi
I currently have every product set-up within its own section (1 to 1 relationship) and these exist within a top level section (1 to many). Therefore:
Top section - cufflinks (exclude from Froogle ticked).
Sub section - Product Cufflinks 1 (exclude from Froogle NOT ticked).
Product Cufflinks 1 (exclude from Froogle NOT ticked).
Sub section - Product Cufflinks 2 (exclude from Froogle NOT ticked).
Product Cufflinks 2 (exclude from Froogle NOT ticked).
I am trying to do a SQL query to not show products where exclude from Froogle is ticked. I am using bExcludeFromFroogle in the Catalog Section table - with a criteria of 0. However becuase I have set the marker 2 categories high - many of the duplicate products are still showing. Is there any way to make the query work based on the highest section setting?
If not I will have to go through and tick half the site to Exclude from Froogle.
Kind regards
Paul
KJ Beckett
I currently have every product set-up within its own section (1 to 1 relationship) and these exist within a top level section (1 to many). Therefore:
Top section - cufflinks (exclude from Froogle ticked).
Sub section - Product Cufflinks 1 (exclude from Froogle NOT ticked).
Product Cufflinks 1 (exclude from Froogle NOT ticked).
Sub section - Product Cufflinks 2 (exclude from Froogle NOT ticked).
Product Cufflinks 2 (exclude from Froogle NOT ticked).
I am trying to do a SQL query to not show products where exclude from Froogle is ticked. I am using bExcludeFromFroogle in the Catalog Section table - with a criteria of 0. However becuase I have set the marker 2 categories high - many of the duplicate products are still showing. Is there any way to make the query work based on the highest section setting?
If not I will have to go through and tick half the site to Exclude from Froogle.
Kind regards
Paul
KJ Beckett
Comment