Pranav R.

Hello @mguo!

My bad to have missed that part; you cannot fetch SSR as WooCommerce would be disabled.

However, you can still take a backup of your site and update WordPress. But, if you don’t want to update your LIVE site; you can create a staging version of your site and try updating that instead. This way, you can check if that would fix the problem for you or not and then update your LIVE site.

Idea is to ensure that this problem is not oaccuring because of any conflict between different versions.

Also, if possible, let us know the exact version number of the installed WooCommerce plugin.

Best!

Hey @mguo!

This looks like an incompatibility between the codes of the installed plugins and WordPress. Please, temporarily disable your WooCoomerce plugin by changing its folder name to gain access to your WordPress installation.

then, log in to the admin panel; and update WordPress (if it is not on the latest version). But, do take a full backup of your site before proceeding with the updates. Make sure other plugins are updated too.

After that, generate your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

Clear all types of caches; even the ones provided by your hosting provider. Now, activate WooCommerce to see if this solves the problem.

If the problem persists, paste here the generated SSR; we’ll check and get back to you.

Best!

Hey @siwhyatt!

It won’t be possible for us to assist you with your custom code. It is hard to tell what exactly is breaking without checking the input and output values of your functions and hooks and no access to the error log.

But, following is how you can troubleshoot your code:
1. Check the hooks documentation to ensure you’re using those correctly, like the parameters and the data types.
2. Then, ensure that your custom functions are receiving the values in the expected format.

Most probably, you’ll find the problem in these two steps; but if you don’t, check the data/values that your hooks are outputting to ensure these are in the expected format. This should tell you what is wrong with the output.

Note: You must check the actual errors that are thrown from the PHP Error logs. Knowing the errors will help you find and fix these problems.

Best!

Hello @mimiseku93002!

The thumbnail size is responsive and increases/decreases as per the available screen width and column size. I see some padding in your category template (on the page sides as in the below screenshot). So, fixing this should fix the thumbnail size as well.

We can’t check your setup but you might be having extra padding, margin or width differently set for the category template (as in the below screenshot).

This would need some troubleshooting to figure out. There are helpful videos available on YouTube on editing Category page templates using the WordPress Editor, like this one.

Best!

Hi @shivapentacove!

I believe you are referring to Elementor Pro’s feature of updating WooCommerce pages. If that is the case, I suggest you get in touch with their support.

We can best assist with the default WooCommerce setup. You can switch back to the default checkout system for now; clear all caches, and if the problem persists after that, let us know.

Best!

Hey @mguo!

Thank you for providing the error log, and the exact query that is creating issues; this is very helpful.

We know the problematic query; but, I do not see the actual values that the system is trying to put in there. Maybe, unsupported value types are causing this problem. such issues may occur on updating plugins but not WordPress.

Q1) Did you recently update your plugins?
Q2) Any idea of what WordPress version was your site on?

Anyways, I suggest you enable MySql error log as well as MySql General log. Here are the instructions to enable these (only enable general and error log).

If you face any issues enabling these, your host should be able to assist you with enabling these log files.

Best!

Hello @mguo!

I can see that the error is related to the WooCommerce plugin’s action scheduler and seems to have occurred at the database level. This error could be because of a corrupted database, or query duration limits or its size.

Did you check your database (MySql) error log? If you haven’t, please check it, and paste the errors here for us to review of you see any.

Also, share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

I found this article about such an issue and it mainly talks about the corrupted database.

Best!

Hello @cutu234!

I believe you’re referring to these instructions, you’ve already followed these with no luck, correct?

Make sure you didn’t miss any steps; if you did, please fix that. Once done; make sure all caches are cleared.

These days, there are object caches that the servers offer; this might also create issues; clear those too, and try again.

If the error doesn’t go away, share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

Best!

Hello @shivapentacove!

I see the following error in your SSR report:

Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.

This error means that your main checkout page doesn’t have the expected checkout shortcode. The checkout page in general has only the shortcode (as follows).

Have you made any modifications to the checkout page/functionality of your site?
If yes, the developer who originally coded this should be able to help you out.

Otherwise, you can switch back to the default behavior to see if the problem persists. But, make sure to take a backup of your site before proceeding.

Best!

Hello @mimiseku93002!

I checked your website and noticed that you are using the ‘Twenty-Twenty-Two’ theme on your site.

Do you want the product listings to look the same as your regular shop pages?
If yes, then kindly note that by default, this is the actual behavior; but, it seems you have a custom page set for your homepage and are displaying products from different categories under different sections.

Please correct if I missed anything.

Your category page will show products from the applicable category; but, you can make this category page full-width by following these steps: https://d.pr/v/elvBFz

If you have questions or if you are trying to achieve something else, let us know.

Best!

Hello @petranca!

I tried again, but I am still not able to replicate the issue. This time, I applied the coupon on the checkout page.

Also, I don’t see a setting to limit the coupon application to just the ‘checkout’ page.

Do you only see the option to enter the coupon on your checkout page?
Also, are you using any plugin for managing your coupons?

Best!

Hello @lauraserena!

It seems you have already taken care of not allowing people to create accounts on your site. But, if you haven’t you can turn off user registration on your site from the “WooCommerce Settings” area (as in the following screenshot):

As far as saving the card information on your site is concerned, do note that card information is not saved directly on the website; only tokens are saved. You can turn this off as well, and the settings can usually be found in the applicable payment method configurations section (as in the following screenshots).

For WooCommerce Payments:

For PayPal Payments:

If you are using a different payment gateway and cannot find the applicable setting, please share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

We’ll check, and let you know.

Best!

Hello @shivapentacove!

Kindly note that variation level stock settings override main stock settings. Still, I tried a similar scenario; I disabled backorders at the product level as well as the level of the variations.

Then, I opened two separate browser windows (Chrome and Chrome Incognito); simultaneously added the same item into the cart that has a stock of 1. The system let me add the items to the cart; but, at the payment/checkout level, I was only able to make the payment for one order. One of the checkout attempts failed.

So, at the checkout level, the available stock is also checked. Following is the screenshot of the error I received:

Are you able to replicate the issue on your end?

If yes, this might be happening because of a plugin conflict or custom modifications. Please share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

Also, please check your error logs from the “WooCommerce > Status > Logs” section (you can filter the latest error logs from the top right corner of the screen). If you find any errors related to this problem, please take a screenshot of your full browser page, upload it on snipboard and paste the generated URL here.

Best!

Hello @petranca!

I just checked the functionality and noticed that if a domain-restricted coupon is applied and a different email address is used; the checkout action fails. Following is the error I received after pressing the checkout button:

Were you able to successfully checkout using the domain-restricted coupon?

If yes, then this might be happening due to a plugin/theme conflict.

Please share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

Best!

Hello @abhigovind!

There are cases in which automatic TAX calculation can be zero; this doesn’t really mean that the automatic tax calculation isn’t working.

Zero Tax calculation is usually calculated due to the applicable “tax nexus”.
You can read more about this here: https://woocommerce.com/document/woocommerce-shipping-and-tax/woocommerce-tax/#automated-taxes-do-not-appear-to-be-calculating

Make sure this is not happening in your case; also make sure that you are not testing with random non-existent addresses. In case you still feel there is a problem; please provide us with the addresses that you are testing with; we’ll check this further.

Let us know if you have questions.

Best!