AbleCommerce Shopping Cart Software

Hello,
Before I report this as a bug, I wanted to check here first in case others have come across it and I'm just missing something.

We are building a Gold R9 site, configured for the SQL search method, and have confirmed that no customization at all is touching Product searching.

When trying to run a search by SKU, from Manage Products, the results & messages just make no sense.
(For the record, we're just looking at the standard SKU field. No SKU changes are made at variant levels to try to account for)

from Manage Products: ManageProducts.aspx

Search Criteria: SKU:49* Expecting 4 Results

• 4906 - Product A
• 4940 - Product B
• 4942 - Product C
• 4943 - Product D

Instead
SKU: 49* Returns: "137 matching products Page 1 of 7" though there are no pages to move through Only listed result: Product B

SKU: 494* Expecting 3 Results Returns: "99 matching products Page 1 of 5" though there are no pages to move through Only listed result again: Product B

Second Example:
Search Criteria: SKU:1540* Expected 4 results

• 1540BK - Product A
• 1540BK2 - Product B
• 1540SB - Product C
• 1540WB - Product D

Instead
SKU: 1540* Expecting 4 Results Returns: "128 matching products Page 1 of 7" though there are no pages to move through Only listed result: Product D

Additional Notes:

• Same SKU searches in the Batch Edit tool also only returns the same single product, but without indicating more results possible 'found'. - Incorrect
• Same search of 49* from the ADMIN Header Search bar, selecting "Search Products" does return the four products expected. - Correct, but inefficient for long run

I'm hesistant to change the system to Full Text Searching and potentially slowing the whole thing down. But I don't know what else is going on here.

Has anyone else bumped into this?

Thank you for your time!

Two similar issues with SKU have already been fixed in Gold R10 and upcoming R11. We will make sure the scenario you described is fixed as well.

Thanks.

This thread viewtopic.php?f=65&t=18195 may help you for a workaround to one of the issues with search by SKU.

The related post eels to be primarily about the pagination and getting errors (which we aren't getting).
While the pagination results & header is wrong, it's actually the lesser of the two issues.
As far as I know, our searches for say 494* shouldn't possibly find 99 results. Just 3.
We can ignore the false header about findings and results, as long as it returned the right results and not just a (random?) single result. (Or am I missing the connection of the pagination counts to the returned results?)

Is that one of the other reported issues? Is the source known or does a workaround exist? If so might a hot fix planned for R9?
We are still building a significantly customized site and we upgraded to R9 for the performance enhancements and the filter by enhancement, but will not be able to upgrade to R10 or beyond for quite a while.

Thank you very much!

There are number of issues with search by SKU including false header and return results. The workaround provided in other thread is simple and it has connection to the results count. Please try applying the below fix and see if this fix your issues.

Locate following code inside Admin/Products/ManageProducts.aspx
and replace with
If the above workaround doesn't work as expected and you have the source code, let me know so that I can provide you complete code changes that will fix all of the issues with SKU.

Hope this helps.

oK, Thank you very much. I've printed a PDF of this forum post and the other post and will give them to the developers to try adjusting this when they are ready for it. (Currently in a push for completing other areas).

I'll update if we come across any issues with this approach. Thank you again very much!