v1.3.9d

Of about 1200 products I have 57 by a manufacturer I'll call "Acme".

The name "Acme" populates the v_manufacturers_name column on the 57 appropriate rows.

When I Advance Search by manufacturer it returns 283 items that incorrectly say Manufactured by: Acme.

When I put Acme in the general search box it returns 789 items. Many incorrectly say Manufactured by: Acme but when I refer back to the original product upload CSV, the cell where the manufacturer's name goes is blank.

I understand why a general search might return a large number; the name Acme might be in the meta, or product description, etc.

But why would the "Manufactured by" line be incorrect?

I have used phpMyAdmin to delete all the products and start fresh but the problem persists. I'd be very grateful for any guidance.

Thank you.