Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

NopCommerce 3.6 Tax By Country & State & Zip always results in zero tax

Tags:

nopcommerce

The NopCommerce 3.6 Tax By Country & State & Zip plugin always returns zero tax for one of my stores. I have the same results locally and remotely, but the database was not copied from local machine. I performed the steps locally and then again remotely to help eliminate the particular environment as a factor.

What might be wrong?

Here are some screen shots to demonstrate.

Tax provider marked primary : Tax Providers

Test customer address contains example zip code. Customer Address

No roles are marked exempt. Customer roles

Set tax based on shipping address, etc. Tax Settings

Tax rates were imported via SSMS. Tax Rates

Customer is not exempt. Customer Details

General tax category has been added.

Tax Category

CountryID of 1 is present. Country

Specific tax rate for test shipping address is identified. I also attempted a test with a specific StoreId of 1, though there is only 1 store. Also the field is not nullable, zero acts as the wildcard. Tax Rate

All products are taxable and assigned to General tax category. Products Query

No tax displayed in the cart. Tax Cart

No tax displayed in checkout. Tax Checkout

No relevant errors in the log. Error Log

like image 434
Seventh Son Avatar asked Dec 05 '25 07:12

Seventh Son


1 Answers

As much as I wanted to avoid thinking it was true, this problem was created by a third party plugin. A vendor's alternate "One Page Checkout" was clearing the tax for the cart once the Checkout page was hit, and preventing that user from ever obtaining tax calculations in the cart afterward. Removing the plugin corrected the problem, and I've reached out to the vendor for support.

Thanks for anyone who took the time to look at this!

EDIT: To be clearer, what's occurring is that the Real One Page Checkout plugin creates NULL fields in the Address table and associates them with the customer. Therefore, any subsequent orders put in the cart by that customer will never calculate taxation again. I didn't investigate what else might be happening as a result.

I've downloaded the latest copy of the plugin and tested with the same results. All orders placed without the plugin installed work fine, with the plugin installed there are blank records added to the Address table and associated with the Customer.

enter image description here enter image description here

like image 181
Seventh Son Avatar answered Dec 12 '25 05:12

Seventh Son



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!