Phil

Glad to you were able to find the source of that @msndrstd!

I’m not familiar with their platform, so not sure if they have any options that would cause this or not. You’ll want to reach out to their support team to have them take a look.

On the staging site, I’d recommend the following:

Set the site to a conflict testing state (all plugins except for WooCommerce disabled and using the Twenty Twenty theme). Then delete and reinstall WooCommerce as you had mentioned.

When you do that, check your system status report to see if the page structure still has the Checkout/Cart/My Account pages in a separate directory. If it does, please try deleting those page. Then go to WooCommerce >Status > Tools and use the option to create the default pages.

Once you’ve done that check to see if that helps.

As you mentioned, it’s definitely a head-scratcher ??

I see in your System Status Report that your My Account, Cart, and Checkout pages are all in a different file path than your shop?

Shop base: #343 - /shop/
Cart: #344 - /dashboard/cart/
Checkout: #345 - /dashboard/checkout/
My account: #346 - /dashboard/my-account/

Was this something that you intentionally did? If so, what steps did you do to set that up.

That is not how WooCommerce is normally configured. These pages should all be on your site’s root folder by default.

My guess is that this issue is either from customizations that have been made to WooCommerce, or if any odd custom setups have been configured, such as the page structure that I mentioned above.

With only WooCommerce and the Twenty Twenty theme active, there is no reason why you wouldn’t see the coupon field if you have enabled the coupon option under your WooCommerce > Settings.

When you had everything else disabled, did you try checking your browser’s console to see if there are any errors there?

Using Your Browser to Diagnose JavaScript Errors

I would recommend reaching out to your host then and having them take a look at your server error logs.

If those pages are properly created, WooCommerce is the only plugin active, and you are using the default Twenty Twenty theme there is no reason why you would get that error.

Your host will want to take a look at your server logs to trace the 500 error that is happening.

Thank you for that.

Just so that I’m clear. The SQL queries that you mentioned in your first message. Is that what is displayed on your screen when trying to search for a product on the WooCommerce > Products page of your admin dashboard?

Or are those the results of queries you are trying to run directly on your database?

If you are seeing that print out on your admin dashboard as a result of using the “Search Product” field (https://d.pr/i/7Yeuke), did you install WordPress and WooCommerce on your server? Or did you use your host’s tools to install both?

If you made any changes to either WordPress or WooCommerce’s files, you’ll first want to revert those. Next, I would recommend having your host review your installation. Using the same server setup as you I’m not able to replicate this at all in WooCommerce. So the cause is something either unique to your site, or to your server environment.

Since the email address is not collected on the “Cart” page, there is no way to validate an email restriction at that point.

By default there is not a way to collect the email address on the cart. If you wanted to do this and validate coupons on that page, it would require either finding a third-party plugin that adds that functionality, or adding some custom code to your site to perform this action. If you want to explore using customer code, I would recommend checking sites like https://www.codeabel.io for skilled third-party developers.

Otherwise, you can look to customize your site by hiding the coupon field on the Cart page. This way they would need to wait until the Checkout page to apply their coupon. You should be able to find some guides and sample code on how to do that with a Google search:
https://www.google.com/search?q=wWooCommerce+disable+coupon+on+cart

I hope this information helps to get you pointed in the right direction.

You’re welcome @cimita and good luck with your customizations!

Hey Carlos,

I wouldn’t be able to comment on the price rounding based on language, as that is a feature that WPML adds, that’s not from WooCommerce itself.

That being said, if you set your taxes to calculate based on your shop’s address it would certainly change the way this works.

Ignoring WPML and it’s currency conversion feature for a moment. If you were just using WooCommerce and set your taxes to calculated based on your shop’s address – it means every customer would be charged the same tax rate regardless of where they live. This may not be what you want, as you likely want to charge a different tax rate based on the customer’s location.

Using your original example, customers from Poland and Serbia would both be charged the same tax rate. That rate would be whatever matches your store’s address in your tax table.

So using WPML’s currency conversion option, the prices should stay the same regardless of their country, since the tax rate isn’t changing.

To answer your following up question, in WooCommerce it’s not possible to charge customers different tax rates, yet keep the tax inclusive display price the same. Either the rate will adjust for the reasons I mentioned in my earlier reply. Or you would need to display the product price exclusive of tax.

The only way to do what you described would be to use a third-party plugin or custom code to change the way that WooCommerce normally works. I’m not sure if WPML has options to allow you to override this (I’m guessing not, since they recommended using your shop’s based address for tax collection). If not, you may want to take a look at sites such as https://www.coedable.io for a skilled third-party developer.

I hope that this gets you pointed in the right direction ??

Shipping zones work in order from the top down.

WooCommerce starts at the top of the list and finds the first zone that the customer matches and that is what options are displayed.

For this reason you want to have your most specific zones (for example ones limited to a specific town or region) at the top of the list. Then have your least specific zones at the bottom of the list.

I would recommend reading the help documentation on how shipping zones work:
https://docs.woocommerce.com/document/setting-up-shipping-zones/

There is no way to do that in WooCommerce by default.

You would need to find a plugin that allowed you to display different products based on the user.

I’m not aware of a plugin that does this by user. However there are plugins that allow you to do this based on role. So for example you could display different products to wholesale customers.

A good plugin for that would be:

https://woocommerce.com/products/woocommerce-memberships/

Or

https://woocommerce.com/products/products-visibility-by-user-roles/

If I understood well, as the price includes taxes, it should NOT change no matter or where I am.

That is incorrect.

When showing pricing that is inclusive of tax, it means that the tax rate is built into the final price that is displayed to the customer.

That does not mean that the same price will be charged regardless of if there is tax on the product or not. This also applies for different tax rates.

When using inclusive pricing and various tax rates, your base tax is used as a benchmark. Taxes that are more than that have their prices adjusted so that you aren’t selling the actual product for less.

The reason for this, is that the method that you described can lead to undercharging customers and potentially selling products at a loss depending on your margins.

For example, say your cost on a product is $90.
You sell the product with a 10% profit margin and use a base tax of 5%.
This means normally you would set the cost of the product to $105 ($5 for tax, $10 profit).

Now you add another tax rate in and it’s 15%.
If you were to applied the method you mentioned and display the same price, you are no longer making 10% profit on this sale. In fact, you only make $1.5.

With different tax rates and profit margins this could actually lead to you selling your products for a loss.

If you want to display the same base product price regardless of the tax that is being applied, you’ll want to enter and display your pricing exclusive of tax. This way the product price will be displayed the same to everyone. Then your site can show the taxes as an separate line item.

As this problem just started after an update, it’s likely that either your theme or a third-party plugin on your site has not had it’s code properly updated to remain compatible.

In that case you’ll want to do some conflict tests with your theme and other plugins. We have a guide on how to test for conflicts here:
https://docs.woocommerce.com/document/woocommerce-self-service-guide/#section-4

You can also use the free Health Check plugin to simulate these tests, though that sometimes isn’t as effective:
https://docs.woocommerce.com/document/troubleshooting-using-health-check/

In the future, I would recommend setting up a staging site. Either through your hosting company, or by using a plugin like WP Staging. This way you have a safe place to test updates and changes before making them on your live site.

Please never share sensitive information such as a username/password on these forums, as they are public.

Even if the credentials are for a limited user role.

As for the problem, please repeat the steps of switching to the Twenty Twenty theme, as well as disabling all plugins, except for WooCommerce. Once your site is that state, please grab a copy of your System Status Report and share that with us here.

If you have already tried disabling ALL plugins on your site, except for WooCommerce – did you also try switching to the default Twenty Twenty or Storefront theme?

Please try both of those steps. While everything is disabling, please grab a copy of your System Status Report. You can get that on the WooCommerce > Status page of your site’s admin dashboard.

These forums are intended for support with the default functionality of WooCommerce, so there aren’t as many developers on here as other options.

For this type of coding questions, you’re more likely to get input by asking in the WooCommerce Developer Slack or Advanced WooCommerce Facebook group. As those communities are both frequented by developers (including our own).