You have no items in your shopping cart.

Wednesday, October 16, 2019 2:55:03 AM

Tax Amount in Total Even Though 'Include Tax' is Un-checked

Avatar

Posted: 2 months ago

#8936 Quote

Scott

Posted: 2 months ago

#8936 Quote
Hello,

The amount of Tax is being included in the Total value passed to the dataLayer in the Google Tag Manager script even though the setting 'Include Tax' in Configuration is not checked.

Please fix this so that the Tax amount is not included in the Total value amount.

Thanks
Avatar

Posted: 2 months ago

#8937 Quote

Scott

Posted: 2 months ago

#8937 Quote
To clarify, I do not want to include the Tax amount in the transactionTotal value that is passed to dataLayer for Google Analytics ecommerce tracking, only the order subtotal before tax and shipping should be passed to transactionTotal variable. I am OK with keeping the tax amount in the transactionTax variable.
Avatar

Posted: 2 months ago

#8939 Quote

Support

Posted: 2 months ago

#8939 Quote
'Include Tax'  - this parameter is for product prices.

transactionTotal - order total with tax and shipping fees.
transactionTax - order total tax.

I can add the new parameter 'transactionSubTotal'
transactionTotal - order subtotal value (with or without TAX)
What do you think?
Avatar

Posted: 2 months ago

#9211 Quote

Scott

Posted: 2 months ago

#9211 Quote
Support wrote:
'Include Tax'  - this parameter is for product prices.

transactionTotal - order total with tax and shipping fees.
transactionTax - order total tax.

I can add the new parameter 'transactionSubTotal'
transactionTotal - order subtotal value (with or without TAX)
What do you think?


No, because Google Analytics only looks for the variable transactionTotal, it won't recognize transactionSubTotal.

You should make another checkbox in the Settings called 'Include Tax & Shipping In Order Total'. If unchecked, then you don't include tax/shipping amounts in the transactionTotal variable amount. If checked, then you include tax/shipping amounts in the transactionTotal variable amount.

Thanks

Then you can also rename the existing Include Tax setting to be called 'Include Tax on Products'
Avatar

Posted: 2 months ago

#9244 Quote

Support

Posted: 2 months ago

#9244 Quote
I need to think.
Write me on Monday
Avatar

Posted: 2 months ago

#9245 Quote

Scott

Posted: 2 months ago

#9245 Quote
Support wrote:
I need to think.
Write me on Monday


Will do. If it makes it easier, you should simply deduct the tax and shipping amount you pass to transactionTotal - because most Google Analytics users would prefer to exclude those amounts from revenue since tax and shipping amounts are passed through to 3rd parties (tax authorities and shipping company).
Avatar

Posted: 2 months ago

#9246 Quote

Support

Posted: 2 months ago

#9246 Quote
I need to think.
I'll be busy next two weeks and I need to think about better solution.
Avatar

Posted: 12 days ago

#10124 Quote

Isaura

Posted: 12 days ago

#10124 Quote
I have the same problem, have this issue been resolved?  Thanks.
Avatar

Posted: 12 days ago

#10125 Quote

Isaura

Posted: 12 days ago

#10125 Quote
Also, the price in the transactionProducts list includes tax.
Avatar

Posted: 11 days ago

#10126 Quote

Support

Posted: 11 days ago

#10126 Quote
Do you want to have product price with TAX (include TAX)
and order Total without TAX?
Avatar

Posted: 11 days ago

#10127 Quote

Isaura

Posted: 11 days ago

#10127 Quote
I want the transactionProducts list and transactionTotal to NOT include tax.
Avatar

Posted: 11 days ago

#10128 Quote

Isaura

Posted: 11 days ago

#10128 Quote
Just to confirm I want the product price and the transactiontotal to NOT include tax.  I have the includeTax in the configuration unchecked but those fields are still including the tax.

Thanks.
Avatar

Posted: 11 days ago

#10129 Quote

Support

Posted: 11 days ago

#10129 Quote
Help me.
What tracking code do you use? Google, Facebook?
Avatar

Posted: 11 days ago

#10130 Quote

Isaura

Posted: 11 days ago

#10130 Quote
Google Tag Manager

price is showing - price: 367.01, quantity: 1, it should display 343.00.  It's including Tax.

Transaction total is showing  'transactionTotal': 403.81, it should be 343.00.  Transaction total includes Tax and Delivery Charges.

Example:
Product amount: 343.00
Delivery Charges: 34.39
Tax: 26.42
Total amount: 403.81

Google Tag manger Datalayer:
     <script>
window.dataLayer = window.dataLayer || [];
var order_product_list = [];
order_product_list.push(
     { id: '329', price: 367.01, quantity: 1 }
);
dataLayer.push({
    'PageType':'OrderCompletedPage',
    'PageUrl':'https://hrdirect.crqa.inet/checkout/completed/',
    'email': 'iwall@complyright.com',
    'value': '403.81',
    'currency': 'USD',
    'orderid': 968,
    'ProductIDList': order_product_list
});
dataLayer.push({
    'storename': 'HRdirect | Smart Solutions to Help Solve Your HR Tasks',
    'transactionId': '968',
    'transactionTotal': 403.81,
    'transactionTax': 26.42,
    'transactionShipping': 36.80,
    'transactionProducts': [
     { 'sku': '329', 'name': 'Forklift Training Set Bilingual', 'category': 'Safety Training', 'price': 367.01, 'quantity': 1 }
    ]
});

Thank you.
Avatar

Posted: 8 days ago

#10132 Quote

Support

Posted: 8 days ago

#10132 Quote
Version 1.41 - October 07, 2019

+ added new parameter in each tracking code (Exclude TAX, Exclude Shipping and Payment Fees)
- remove parameter "Include TAX" from plugin configure page

Powered by nopCommerce

Copyright © 2019 FoxNetSoft. All rights reserved