Shipping shows $327 for all products

Even when I set Set shipping costs in other currencies manually and did not add any fees in other currencies manually it seems I still see $327.99 as the shipping fee for the crate. Still no idea where this USD dollars number is coming from booking a simple crate with a shipping fee for Northern USA of [qty]*28.93 in EUR. As said we set 1 EUR at 1.19 USD. So how could this result in $327.99 for New York, New York 1000 where we set the rate at €28.93 converted to USD by multiplying by 1.19?

Hey @rhand,

Thanks for sharing that info. I took a look at that example product and calculated shipping costs for the US and saw what you described (screenshot).

From what is visible on the front end, it isn’t clear if the calculation problem is related to the currency switching or something else. However, I would suggest changing the order of the info used for the calculation and make sure it is correctly formatted, as seen below:

28.93 * [qty]

If that doesn’t help, can you share screenshots of the Flat Rate shipping method settings being used in the US zone(s) so I can take a look? Thanks!

Hi @shaunkuschel

The current North America Flat Rate Settings with shipping class costs you can see here in two screenshots on Dropbox:
https://www.dropbox.com/s/r67p3a66uh8moly/North%20America%20Flat%20Rate%20Settings%20Top.png?dl=0
https://www.dropbox.com/s/d3nlojad0spx0y9/North%20America%20Flat%20Rate%20Settings%20Top%20Bottom.png?dl=0
extra shipping zone view: https://www.dropbox.com/s/uhy9rfjiz7lhp2c/Shipping%20Zones.png?dl=0
This is the top and bottom of the US/CA/MX flat rate shipping and shipping class cost for North America. All amounts are in EUR and now you see 28.93 * [qty] for crates.

As you can see I changed the order for all so if we were using quantity I added it at the end. It however does not seem to change the shipping in USD showing as $327.99..

FYI When I keep the base currency EUR the shipping is only …?€28,93

We do have the feeling this is a bug. We tried it with individual products in USD, with products with product add-ons. All keep on showing this oddly large amount in USD which we cannot locate.

Here WooCommerce Multilingual View https://www.dropbox.com/s/yj5giwywhynm00d/woocommerce%20multilingual%20view.png?dl=0 in case it helps.

• This reply was modified 3 years, 11 months ago by Rhand.
• This reply was modified 3 years, 11 months ago by Rhand.
• This reply was modified 3 years, 11 months ago by Rhand.
• This reply was modified 3 years, 11 months ago by Rhand.

On staging.ourdomain.com (.htaccess protected) the amount is calculated correctly still https://www.dropbox.com/s/voojrsvm0tlx24e/staging%20shipping%20okay.png?dl=0 .

It is a bit behind production as it uses 1 EUR is 1.10 USD and some template designs are different. But shipping classes are similar and start with qty before the amount as well:

https://www.dropbox.com/s/tiigxtug49ytmw6/staging%20flat%20rate%20settings%20north%20america.png?dl=0

The WooCommerce multi-currency setup there chooses to keep default currency per language whereas on production we have EUR for both NL and EN. Here staging view:

https://www.dropbox.com/s/vyod14s22zz3a2p/staging%20woocommerce%20multicurrency.png?dl=0

So wonder if I am onto something here..but I doubt it.

• This reply was modified 3 years, 11 months ago by Rhand.

Decided to add

woocommerce_items_in_cart
wp_woocommerce_session_

to WP Rocket Cache no caching of cookies
Specify full or partial IDs of cookies that, when set in the visitor’s browser, should prevent a page from getting cached (one per line)

to see if WP Rocket was causing issues. This as I realized that staging did not have cache turned on and was calculating just fine. So looked into settings and bumped into the advanced cache rules and set to exclude WooCommerce cookies or not use cache when cookies are set. Once set I then emptied WP Rocket Cache, OPcache, Redis Caching. Did not regenerate cache for pages yet.

Then I opened site in new private window and booked a crate with US New York address again. And now it seems to be working!

See https://www.dropbox.com/s/moderecwg46vs7k/new%20test%20with%20WP%20Rocket%20Woo%20cookies%20then%20no%20cache.png?dl=0

Will be doing some more testing, but happy to see Flat Rate Shipping Fee: $34.42!

• This reply was modified 3 years, 11 months ago by Rhand.
• This reply was modified 3 years, 11 months ago by Rhand.
• This reply was modified 3 years, 11 months ago by Rhand.
• This reply was modified 3 years, 11 months ago by Rhand.
• This reply was modified 3 years, 11 months ago by Rhand.

Hmm, issue came back again so seems either WP Rocket or Redis Object Caching is stil somehow messing it up. With all WP Rocket caching, OPcache and Redis object cache removed all was well but before that bad shipping amounts were back!

Hey @rhand,

Sorry for the delay getting back to you on this thread- I wasn’t around in the forums until today. Though, super glad to hear that you at least made some progress- even if it was short lived.

It does sound like you’re looking in the right direction with the caching, but I’m not able to tell what is causing the issue again based on what I can see. However, after reading your replies, I wonder if it could just be browser caching. Was the most recent test where the rates were incorrect done in an incognito/private browser?

Yeah it seems like WPML Currency Converter part of WooCommerce Multilingual is cached in PHP and that caused display issues working with WP Rocket Cache and OPcache. This I was told by WP Rocket. So we are now testing Aelia Currency Switcher for WooCommerce which works with cookies instead. And this time it does seem to be working and shipping is getting calculated well.

But we will do some more testing before we move onto tweaking other parts of the site. It all drove us kind of insane there for a while but it seems we finally got the issue down and solution setup. Will keep thread open for a little while though. Fingers crossed.

Thanks for the update, @rhand. I’ll keep a look out for any other updates. ??

Cheers!

I’m going to go ahead and close out this thread, but if you do find out anything related to this that you’d like to pass along, don’t hesitate to just create a new thread. Thanks!! ??