Not all results being returned

Anonymous

#112878

Greetings –

All of a sudden our filters aren’t returning all results (for all categories it’s returning less than the number it should). I’ve spent over 2 hours trying to work out the issue and it must be a bug. It seems to dovetail with other recent comments about the caching, but since most replies are private the previous threads don’t do me any good as I can’t understand problems/solutions.

I’ve tried reverting to 2.2.1 and rebuilding the cache and I get the same results as I do in 2.3.4. As someone reported, the cache contains all the items, but there is something not right in it.

I don’t know exactly when the plugin stopped working which makes things difficult.

Ross Moderator

#112879

This reply has been marked as private.

Anonymous

#112883

Hey Ross —

Sure, this same comparison can be done with any category — but here is the actual WordPress category page (28 pages of results):

https://warpandphil.com/product-category/drapery-and-bedding-fabrics/captivate/

Then if you click the category in the sidebar, this is the page you get (20 pages):

https://warpandphil.com/?sfid=83833&_sft_product_cat=captivate

That’s the clearest indication of the issue…

Anonymous

#112885

In a few minutes I’m going to try rebuilding the filters from scratch on a test site – I think that was recommended to someone else… that’s about the only thing I haven’t tried yet. I might actually do a clean install as well – delete the db tables and everything and start over.

Ross Moderator

#112902

Hi Johnny

I can see a few missing.

Just to note, your second link, does in fact have 28 pages (click on “last page”) it seems the pagination works a little different on the two pages, but there are a few missing still.

I compared each page between your category archive and S&F results, and the results match perfectly from pages 1 – 9, its on page 10 things change.

The first thing I would suggest is to identify specifically which ones are being skipped, it looks like there are 9 results missing from this particular category, if you could figure out which exactly and look for any trends between them.

My first inclination would be that you have some settings in your search form, which is excluding your results based on certain conditions.

In your search form I would check the Tags, Categories & Taxonomies tab, and the post meta tab for any conditions which might be affecting your results – let me know if there are any there?

Another thing to look for would be your sorting options under the posts tab – if you sort by post meta then posts which do not yet have the particular meta assigned to them will be skipped / ignored.

Let me know if you find anything!

Best

Anonymous

#112911

Hi Ross —

As part of yesterday’s troubleshooting I did do that actually – compared two products, one which was appearing and one which wasn’t, and there’s nothing that’s different between them. Also, none of the ‘products’ have changed at all recently. This also happens in every category site-wide… I will look at one more now, but I’m pretty sure that this isn’t the issue.

The thing is, the results used to be accurate for a long time – then all of a sudden, I don’t know the timing, but recently, there started to be some missing from the search results. I was told about it yesterday morning.

There might be another plugin that’s affected the results somehow, or possibly WordPress, but it’s an update that has altered the results — the products themselves (and the form settings) haven’t changed at all in a long time.

Thank you!

Ross Moderator

#113227

This reply has been marked as private.

Anonymous

#113273

Hi Ross — good news and bad news. The new update didn’t fix it but I did go into the database and look over the caching tables and the appear correct – in the term_results table, the category tag for the test category I’m working with has the correct number of results. The IDs of products not appearing are there. So it’s not a caching issue.

Problem is, I’ve also tried switching themes without luck (same problematic results) and also deactivated all plugins but this one and Woocommerce, also without luck (same problematic results).

The only think I can think of is to test another free filtering plugin to see if it generates these same results – I think that would indicate some sort of Woocommerce problem, as that would be the only thing left… it’s possible the upgrade to V3 is what broke the results a month or so ago.

Ross Moderator

#113319

This reply has been marked as private.

Ross Moderator

#113321

This reply has been marked as private.

[Author]

Posts