products pages are not showing in index status

#556902
  • Resolved GuestofHonor
    Rank Math free

    Hello,

    I have 700,000 products and when i click on the index status in the analytics page i see only 7,000

    and the SEO Analyzer is showing this warning “Could not check Focus Keywords in posts – the post meta table exceeds the size limit.” and i believe it’s because of the huge number of products.

    Can this be resolved ?

    Thanks

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hello,

    Thank you for contacting us and sorry for any inconvenience that might have been caused due to that.

    For the index status, please follow the steps below to see if that helps you to resolve the issue:

    1. At first please head over to WordPress Dashboard > Rank Math > Status & Tools > Database Tools and click the Rebuild Index button.

    2. After that, Head over to WordPress Dashboard > Rank Math > General Settings > Analytics tab, click the Delete Data button, and then click the Update Data Manually

    It will start the new data fetch from Google. You can reload the page to see the notice related to the import process. As you have a lot of products, it will take time to complete the whole process.

    Regarding the focus keyword, please try to add the following filter on your site:

    /**
     * Filter to change the Post Meta Table Limit
     */
    add_filter('rank_math/seo_analysis/postmeta_table_limit', function ( $limit ) {
    		return 5000000;
    	}
    );
    

    Here’s how you can add filter/hook to your WordPress site: https://rankmath.com/kb/wordpress-hooks-actions-filters/

    Once done, clear the SEO Analyzer cache from Rank Math > Status & Tools > Database Tools > Flush SEO Analysis cache and check again.

    Let us know how it goes. Looking forward to helping you.

    Thank you.

    Thanks for the reply.
    I’m waiting for the index issue.

    the focus keywords issue was not resolved by the filter provided

    Regards

    the analyzer is now giving the following error “An error has occured”
    and the reindex needs 2 days 9 hours to finish 🙁

    Hello,

    Depending on the amount of data, the fetching process could take between 45 minutes to a couple of hours.

    Regarding the Analyzer tool, please check your site’s configuration if there are some PHP values that are too low and which you should increase. You can get in touch with your web host and ask them to set the following values (if not yet):

    PHP Memory Limit: 512M
    Max input time: 150
    PHP time limit: 120
    PHP max input variables: 1000

    If the issue still persists, we might need to take a closer look at the settings. Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.

    Please do take a complete backup of your website before sharing the information with us.
    Sensitive Data Section

    It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

    https://wordpress.org/plugins/temporary-login-without-password/

    You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

    https://wordpress.org/plugins/wp-security-audit-log/

    We really look forward to helping you.

    Thank you.

    PHP Version 8.1.17
    PHP Memory Limit 4 GB
    Max input time 600
    PHP Time Limit 600
    PHP Max Input Vars 10000

    i believe that rankmath can’t analyze 700k of products, it will simply timeout

    Hello,

    Since the PHP values on your site are already above the recommended configuration, head over to Rank Math > Status & Tools > Database Tools > and click the Clear SEO Analysis and Remove Transients buttons to flush the SEO Analysis cache

    Flush

    Once done, clear your website and any server-level caching on your site before doing the Sitewide analysis again.

    Let us know how this goes.

    Thank you.

    didn’t work

    After doing the steps recommended by you, now i’m getting an error_log of 14GB
    and then it will list all posts, pages and products

    https://pastebin.com/hR3EwEMA

    Hello,

    In this case, head over to Rank Math > Status & Tools > Database Tools and recreate the Rank Math tables by clicking this button:
    https://rankmath.com/kb/rank-math-status-and-tools/#recreate-missing-database-tools

    If the issue still persists, then we may need to take a close look at your site to investigate the issue further. Please follow the steps above and add the logins in the sensitive data section.

    Looking forward to helping you.

    Thank you.

Viewing 9 replies - 1 through 9 (of 9 total)

You must be logged in to reply to this ticket.