Search By SKU does not make sense

Gentlemen,

I am in the process of modifying NOP to also work as a back office point of sales application as well as our ecommerce store and I have ran into a very confusing issue.

In the productvariant database there is a field named "SKU" which is also search enabled in the productloadallpaged stored procedure. What does not make any sense is when you search by SKU it returns the main product item rather than the productvariant sku item.

For example I have a product named "Shirts", with 3 variants red, white, blue. Blue is sku #1234. When I search on sku #1234 from the main page or search page the result is just the product named "Shirts". I then have to click details where all three red, white, blue variants are listed to then pick the blue one.

Why would it not just show ONLY the blue one instead? Why is there even a search enabled for sku when it only returns the main product?

Anyone know of a way to return ONLY the sku I have searched on?

Thanks for any help!