nicw.a11n

Hi @reberiii

Thanks for that. If sync is off, then orders will show as unsynced, that is expected. And it sounds as if you have already removed legacy data. I don’t believe removing order data will have an effect: order data is now stored separately from product data, which is where you’re experiencing the problem.

Overall, it sounds as if your SQL server is taking strain. The admin processes are, from necessity, hard-core SQL queries, and although object caching can help, at the end of the day there has to be a SQL write/read.

Your database doesn’t even look that big. Setting up a staging site, and running Query Monitor on it might expose any rogue issues. That would be my next step. A staging site would also allow you to run in conflict mode, to see if dropping all plugins (except WooCommerce) and switching to a default theme like Twenty Twenty Five or Storefront, helps speed things up.

For a more detailed picture, a tool like New Relic or similar APM is an excellent, though somewhat more complex, choice.

Hi there,

Looking over your System Status Report, I see that while you have HPOS enabled, and Custom Tables are authoritative, you are still syncing legacy order data. I would recommend turning this off, and then using the tool in WooCommerce > Status > Tools to remove legacy data from the wp_posts and wp_postmeta table.

You can re-enable sync at any time.

I’m not sure where you currently stand on SQL indexing, but a tool such as a SQL indexing plugin can be handy.

Could we try removing that additional data, and then if you could let us have another System Status Report, it would show us any changes to your database.

Apologies – I see you have already added a system status report. The DB size is not huge, and you are already running HPOS, so that question is also answered.

I would try an external object cache next.

Also ensure that your autoload query is not too large: a large autoload query (that is all options which are marked as ‘autoload=yes’) can swamp your SQL Query cache. Autoload should be no more than 500kb.

• This reply was modified 6 days, 12 hours ago by nicw.a11n.

Hi @reberiii

Thanks for the update on that. I think it would be best if you could remove the file from file.io.

Editing products on admin is a database intensive process, and bulk editing does not reduce the size of the query, but actually increases the amount of processing which takes place.

You did ask if HPOS (High Performance Order Storage) would help and the answer to this is yes, if you have a high number of orders, it allows you to move meta data from wp_postmeta to the new custom order tables and remove the legacy order data from the wp_postmeta and wp_posts table. This reduces the number of rows in the table, where many heavy JOIN queries are run.

The impact will be higher as the number of orders increases. If you currently have no orders, the impact will not be significant at this point.

Performance of the admin dashboard can be improved by using an external object caching mechanism, such as Redis. In fact, I would say an external object cache is essential.

the server is a AWS Lightsail instance with 4 vCPU, 16GB of RAM and 320GB of storage.

Scaling vertically, so that your database server is separated from your web server, is recommended as your needs scale. This allows the DB server to be built optimally for the task, while the webserver can have a different configuration. Our experience at this point is that autoscaling solutions, rather than static individual server instances, might be better suited for larger stores.

Alternative methods of managing stock, which implement either through the REST API or through a plugin which is designed for bulk stock management (search WooCommerce bulk stock management) may be more efficient.

A pro tip here: running a CSV export, removing all columns but SKU and stock numbers from the CSV, editing the stock and then reimporting can be a quick and dirty way to manage bulk stock updates.

Could you please give us a copy of your System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. That will give us some idea of what we’re dealing with.

Hi Lucein,

Could you please open a ticket at WooCommerce.com so that we can investigate further? I think this requires further investigation, which we can carry out there. Please copy the link from this forum to your ticket, so that we can match them up.

Regards,

Nic

Awesome @miyagibonsai – I will mark this thread as resolved. Should you need any more help, you know where to find us ??

Hi @miyagibonsai

I’ve checked whatsmydns.net for your site’s DNS entries and I’ve not been able to find any of them. Can you try verifying your DNS settings again, as you may need to reset them.

You will find this in the Sender Domain Authentication section of the documentation here: https://kb.mailpoet.com/article/188-how-to-set-up-mailpoet-sending-service

Hi @graichura

I agree, the implementation does seem klunky, and our developers do have the shortcodes on their list of issues to address.

I found that using a bit of CSS to hide the select dropdown left the selections in the default “subscribed” setting, which meant that lists not subscribed to are off, while lists that are subscribed to are on.

.mailpoet-manage-subscription .mailpoet_select_label, .mailpoet-manage-subscription  .mailpoet_select{
	display:none;
}

This seemed to work well and allows an opportunity to reword the instructions, perhaps?

Hi @coldrealms65

I’ve tried several different way to replicate this, in both Firefox and Chrome, and have not been able to. I took a screen capture of one attempt (in Firefox, where I did not scroll at all).

None of the attempts ended with the page scrolling. Possibly you’ve corrected the problem already.

However, I am seeing a JavaScript error Uncaught Error: Syntax error, unrecognized expression: a.ultp-pagination, a[href*=“/page/”]

This error is triggered in the Loftloader Pro plugin.

Hi @klexi

Thank you for the input. Our team has in fact had the introduction of trace IDs to the UI and reporting for some time. An issue is open here on the public repository.

There are two possible routes to take on this – the one you’ve suggested, and the one mentioned in the repository, where we add the trace ID to reporting on the site and to the CSV files obtained from the site, allowing reconciliation.

Bank statement descriptors can be unreliable for this, as statement descriptors can vary somewhat from institution to institution and from country to country. But the trace ID should be a constant.

Thank you for the reminder on this, and I’ll be reaching out to the team to ensure this is on their radar.

Hi @isidorodanna

Thanks for reaching out on this. I see that your subscription was approved, as we did receive your message on this. Please let us know if you have any further questions. We will be happy to help.

Hi @johnclearmoonstudios

There are two steps to removing WooCommerce subscribers from the list. The first is to uncheck the subscribe option in settings

Link to image: https://d.pr/i/JCdi2I

The second is to go to MailPoet > Lists and force sync the WooCommerce Customers list.

Have you carried out both these steps?

Hi @mylenep,

In future, we’d recommend starting a new thread with your question. This makes it easier for us to manage, and for other users to find answers in the forum.

The content blocks in the newsletter are not compatible with Trabe Events – but you can extend the newsletter customizer by creating your own custom shortcodes to display eventws in your MailPoet newsletter by following the instructions in the knowledge base article here: https://kb.mailpoet.com/article/160-create-a-custom-shortcode

Hi @gabyrau

You’ll need to make sure that the email address you set up in your default from address setting is authorized to send. If you log into MailPoet, it should appear in the Authorized Emails list.

The mail address I set up for mailpoet is also used for WordPress notifications. Why? I don’t want that WP notifications have to go via Mailpoet sending service. I already tried to overwrite this with addfilter('wp_mail_from', ...), but this did not work (except if Mailpoet is switched off).

When MailPoet is selected as your sending service, all mails are routed via MailPoet, and get the default sender address as set up in your MailPoet > Settings > Basic tab.

Remember, when sending from MailPoet, attachments, CCs, BCCs and multiple to addresses are not supported.

Hi @coldrealms65

By default, the slide in should not trigger a scroll on the page, and this is probably occurring because of a conflict with your theme. Could you try disabling animation, to see if this helps?

This is set in the form preview as in the screenshot below.

Link to image: https://d.pr/i/Hot80n