Need help: Product Finder problem

AbleMods · Post by **AbleMods** » Sat Nov 24, 2007 2:57 pm

I set several unfinished categories of products to hidden. I confirmed the category and the items contained in it have the little ghost icon.

Product Finder still shows them. It also still counts them in the "by Manufacturer" count.

I'm also starting to suspect it's including orphaned products. Several items listed in my Product Finder don't render a product page link - the link they render is incomplete and simply reloads the product finder page.

Need some help here.

JimCrisp · Post by **JimCrisp** » Sat Nov 24, 2007 5:39 pm

I agree, mine also shows an orphaned product and has counts by manufacturer when the categoires have been hidden.

AbleMods · Post by **AbleMods** » Sat Nov 24, 2007 7:29 pm

thank the gods it's not just my install - I figured all the test importing I had done had ruined my database.

I tested everything locally, but in small numbers. The product finder issue wasn't readily apparent until I got a large number of products set up.

I could restore, but orders have since come in on the live system

Post by **sohaib** » Mon Nov 26, 2007 1:40 am

When you set a category hidden by default all its sub categories and items are marked hidden as well ... so the will not appear in Product Finder.

If while making a category hidden, you did not chose to make its sub-items hidden then they will get displayed in product finder.

Bug http://bugs.ablecommerce.com/show_bug.cgi?id=6076

AbleMods · Post by **AbleMods** » Mon Nov 26, 2007 3:58 am

I think Product Finder was including orphaned products in it's counts and searches - might want to check into that as well.

Post by **sohaib** » Mon Nov 26, 2007 4:12 am

You are right. It is including orphaned products in the search. It will be taken care of in the next revision.
P.S. Under normal circumstances there should be no orphaned items...

AbleMods · Post by **AbleMods** » Mon Nov 26, 2007 4:19 am

Understood.

I had 634 orphans after all my import testing was done

I ended up using a Windows-based macro program I have to do the deleting for me.

I figured out how to find them via an SQL script that tied products into ac_CatalogNodes, but was hesitant to blow them away directly out the SQL database.