We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Gold Contributor
Gold Contributor
 
9 REPLIES 9

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Moderator
Moderator
Hi Jeremy, The best way is to use a "Set data values" extension (https://community.tealiumiq.com/posts/554049) scoped to the GUA tag, and set "_ctotal" to "_csubtotal". This will have the effect (just for the GUA tag) of overriding the total with the subtotal. Hope this helps. Craig.
Check out our new Swift integration library for iOS, macOS, tvOS and watchOS: https://github.com/Tealium/tealium-swift with updated
documentation https://community.tealiumiq.com/t5/Swift/tkb-p/swift.

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Employee Emeritus
Hey Jeremy, The best practice way would be to handle this via Mapping. In the mapping section of the GUA tag, select the variable you would like to use for the Grand Total amount. Click "Select Destination" and this will bring up the Mapping Toolbox. Click on the "E-commerce" tab. Then select "Revenue (Grand Total)." This will overwrite the standard "_ctotal" mapping used in the template with whatever value you map.

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Gold Contributor
Gold Contributor
Hi Craig, I tried that and it didn't appear to work. I tried changing the extension order to have ecomm then set data values and vice versa, but neither seemed to work. Maybe I need to wait longer for the update to replicate.

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Gold Contributor
Gold Contributor
Hi Jarid, That was what I first thought but it didn't seem to be reflected in my test. I'll try another test.

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Moderator
Moderator
That's odd - it should work. Jared's solution above is better anyway - I had forgotten that we had a mapping for grand total. Give Jared's method a try.
Check out our new Swift integration library for iOS, macOS, tvOS and watchOS: https://github.com/Tealium/tealium-swift with updated
documentation https://community.tealiumiq.com/t5/Swift/tkb-p/swift.

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Employee Emeritus
Hi Jeremy, a quick tip for testing - it's always worth looking at the timestamp which is contained in the first line of the utag.js file, in the format "//tealium universal tag - utag.loader ut4.0.201407151556" where the last part is year-month-day and then the time in GMT time zone. You will see this timestamp change when the update files hit the CDN.

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Gold Contributor
Gold Contributor
Ok, yep. I was too eager on my 1st test. The change must not have replicated. Thanks.

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Gold Contributor
Gold Contributor
Oh! That's great. I always just wait 10-15min and look for the changes to be reflected or not. Thanks.

We're currently using the ecomm ext and for most tags we want to pass grand total as grand total, but for GUA we want to pass subtotal, so that in GUA we have Revenue not including tax and shipping. Is there a way to change the _ctotal mapping for 1 tag?

Employee Emeritus
Current best practice is as Jared states. Use mapping for a tag to override any of the default values that would otherwise come from the E-Commerce Extension.
Public