andyrjames

Hi Zdenys,

My Woocommerce is at 4.7.0 Storefront is at 2.9

Not inclined to roll back and lose the security fixes I suspect it would break the site.

Query monitor complains about this SELECT query:

post_status, COUNT( * ) AS num_posts
FROM wp_posts
WHERE post_type = ‘product’
GROUP BY post_status

Not sure why it needs to be executed for a product update.

But I believe the main issue is still Woocommerce use of wp_postmeta to store product information in a metakey/metavalue structure.

The design needs to use a product table rather than this cludge. My wp_postmeta table now has 6,288,553 rows after cleanup.

Move all the fields that are used for every product into wp_wc_product_meta_lookup

A product can typically have 23 rows in this table and they aren’t indexable in a meaningful way. Move the Woocommerce ones into the meta lookup table.

It would speed up woocommerce for everyone overnight.

If you have any other suggestions I’d be grateful to hear them.

Cheers,

Andy

Update.

Went back to the test site.

Removed the code from functions.php upgraded from 2.11 to 2.12 and the results appear below the search on mobile.

Cleared autoptimize cache just in case. No joy.

Put the snippet back into functions.php and the results appear above on mobile.

Cheers,

Andy

I put the add action into functions.Php on the livd site.

Works fine. I thought it would have been incorporated into the last plugin update.

Which snippet should I actually be using, the first or second you posted?

Cheers,

Andy

Hi,

Got it all indexed.

A combination of these fixed it:

1. Set PHP max_execution_time to a ridiculously high number.
2. Switched from Firefox to Chrome.
3. Started a new session.
4. Ticked Remember Me when logging in so WP didn’t time out the session too soon.

326,048 products indexed.

Thank you very much!

(Took over 18 hours.)

Cheers,

Andy

Hi,

Excellent, I absolutely do want it.

🙂

Cheers,

Andy

I believe you need to add css to your theme’s style sheet (style.css – best to use a child theme).

Probably also do it through Appearance => Customise => Additional CSS
but I never do it that way.

.aws-search-result .aws_result_link {
background-color: #fff;
}

Makes the background white. Goes with storefront.

Sorry for the delay, I’ve just cloned the live site back over the demo site and the Advanced Woo Search index rebuild took at least 12 hours!

Do a search on your android phone.

The google (android) keyboard pops up and takes up half the screen space. It pushes the browser display beyond the top half and you can’t see or scroll to the top 3 results until you back out of the google keyboard.

I honestly don’t know if this is something that you can do anything about as the google keyboard is part of the OS.

On the plus side the search is working great with 325,995 products.

Does the plugin index Imported products? This is the main way we add new items.

Thanks for your help.

Cheers,

Andy

No change of theme and no updates to Storefront recently.

I can still see it on mobile.

Tap the magnify glass centre bottom and up slides the quick search box.

Type in: fujitsu and your results appear.

Works on my android phone and narrowing the screen on Chrome or Firefox.

Cheers,

Andy