My self-hosted affiliate tracking script is messing up conversion tracking data after recent update!
[2023-10-27 14:35:01] ERROR: TrackingService.php - Invalid conversion value detected: 0.00. Expected float > 0.
[2023-10-27 14:35:01] DEBUG: Raw Post Data: {"transaction_id":"TXN12345","amount":"0.00","currency":"USD"}
[2023-10-27 14:35:01] WARN: AffiliatePayoutCalculator.php - Potential data integrity issue. Conversion amount is zero.2 Answers
MD Alamgir Hossain Nahid
Answered 1 week ago- Check Your Server Postback/Webhook Configuration: The most common cause is that the system sending the conversion data (your e-commerce platform, CRM, payment gateway, etc.) is either sending `0.00` explicitly, or it's failing to retrieve the actual amount before sending the postback. Verify the URL and parameters configured in the *source* system. Ensure the variable holding the transaction amount is correctly populated and passed.
- Review API Integration/Connectors: If you're using an API, double-check the payload structure. The update to your tracking script might expect a different data type or field name, causing it to default to zero if the expected value isn't found or is invalid.
- Examine Data Type Mismatch: Ensure the amount is being sent as a numerical value (float or integer) and not a string that's then misinterpreted. Sometimes a minor change in how a number is formatted (e.g., including currency symbols, or using a comma instead of a decimal point) can cause parsing issues.
- Script Update Changelog: Did the script update include any breaking changes regarding postback parameters or expected data formats? Review the changelog and documentation for your specific script version.
- Debug the Sending Side: Use network monitoring tools or check the logs of the *system sending* the conversion data to see exactly what amount is being included in the request *before* it even hits your tracking script. This will confirm if the `0.00` originates there.
Isabella Johnson
Answered 1 week agoAh, got it! That was exactly it, thanks for pointing me towards the sending side. Turns out the e-commerce platform updated its API and changed the parameter name for the amount without telling anyone, leading to all the zeros.
Now the amounts are coming through correctly, which is a huge relief, but I'm seeing a weird discrepancy where the *total* daily commissions in the script don't quite match what I'm calculating manually. It's usually off by a small percentage, like 2-3% for the overall daily total, not individual transactions.