Product price is not capturing properly

Create a new Data element 
Custom Code 

You may need to adjust the regex if your locale uses different formats

Or you can do is Transform the Price Inside a Rule (Set Variables Action)
In the “Set Variables” action for Adobe Analytics, instead of directly using product_price, use custom code:

Let me know which one works for you!

Hi @dineshrkumar ,

to be completely blunt, this is a sh*t in, sh*t out situation that should not be resolved by you in the first place, but by the developers. 
Are you certain that the numeric value is not around on the website, since quite often formatting happens in the frontend based on browser locales.

So my suggestion is reaching out to the developers first before adding complex clean up logic on your end.

You as tag management specialist can also make demands in terms of data quality, and I'm certain that you will find business people who have your back on this.

You need a numeric value, simple as that. Formatting characters that improve readability are turning you numeric into a string value.

Hi @dineshrkumar,

Although, this should probably be fixed by the site developers in the data layer so that the value is consistent, this isn't always possible. I would first try and get the developers to mend it but if they can't or won't then I would go with  the following approach.

Create a data element that will return the price but run a function to make the data uniform.

Run the function with the following code, but replace the input with your data layer reference:

Here is how the code will perform with the different inputs:

Input => Output

1.234,56 => 1234.56
1,234.56 => 1234.56
1234,56 => 1234.56
1234.56 => 1234.56
1 234,56 => 1234.56
₹1,23,456.78 => 123456.78
¥123,456 => 123456
USD 1,000.00 => 1000
abc123,45xyz => 123.45
12.50 => 12.5
12,50 => 12.5
1.000 => 1000
1,000 => 1000
123456 => 123456

Thanks,

Dan

You're dealing with inconsistent price formats in the data layer due to locale differences (e.g., 1.416.993,75 vs 1416993.75). To fix this in Adobe Launch, create a Custom Code Data Element that:

-Reads the raw price from the data layer.
-Normalizes it by removing thousand separators and converting the decimal to a dot (.).
-Returns a clean float value (e.g., 1416993.75).

Use this normalized value in your analytics tags for consistency.

Hi @dineshrkumar ,

Inconsistent number formats across languages/locales (like commas vs dots for decimal or thousand separators) can break price accuracy in Adobe Analytics, especially if you're sending raw data from the data layer without normalization.

Since the product price is available in the data layer, the best fix is to standardize the format in Adobe Launchbefore sending it to Adobe Analytics.

• English: 1416993.75 → Correct format
• Other locales: 1.416.993,75 or 1,416,993,75 → Adobe interprets this as a string, not a number.
• Analytics expects . as the decimal separator and no thousand separators.

1. Create a Data Element: normalizedPrice
• Type: Custom Code
• Paste the normalizePrice() logic
2. Use in Adobe Analytics Rule
• e.g., s.products = ";productName;1;" + _satellite.getVar("normalizedPrice")

Sample code for normalization function:

function normalizePrice(rawPrice) {
// Convert to string just in case
var priceStr = rawPrice.toString().trim();

// Detect and replace comma as decimal
if (priceStr.match(/,\d{2}$/)) {
// Replace thousand separators (dot or comma) with nothing
priceStr = priceStr.replace(/[.,](?=\d{3}([.,]))/g, '');
// Replace last comma with dot for decimal
priceStr = priceStr.replace(/,(\d{2})$/, '.$1');
} else {
// Remove comma thousand separators
priceStr = priceStr.replace(/,/g, '');
}

return parseFloat(priceStr);
}

// Example usage
var rawPrice = window.digitalData.product.price; // Or your data element
var normalizedPrice = normalizePrice(rawPrice);

// Store normalized price in a Launch data element or eVar/prop
_satellite.setVar('normalizedPrice', normalizedPrice);

Some Tips:

Hi @dineshrkumar 

To standardize price formatting before sending to Adobe Analytics via Launch, you can add a data element or custom code to clean and normalize the price value across all languages. Here’s a simple approach using a custom JavaScript data element -

function normalizePrice(rawPrice) {
// Replace comma with nothing if it's used as a thousand separator
// Then replace the locale-specific decimal with dot
let cleanPrice = rawPrice.replace(/\./g, '').replace(/,/g, '.');
return parseFloat(cleanPrice);
}


You can use this function inside a Custom Code action in Launch, or attach it to the data element that handles the product price. Make sure the logic aligns with how your site formats prices per locale.

Also, double-check that the raw price being scraped is not a string with currency symbols or HTML wrappers, sometimes stripping tags or symbols helps before parsing.

Hope that helps!

How are you picking up the price value? I assume this is being passed in a data layer, or through some data element on the purchase event?

I would be more tempted to work with your developers to pass you the information in a consistent format, no matter what language is being used on the site... they must be doing this anyway for passing to the payment provider...