@NextMike yes I did generate the SEO urls as well as cleared the cache several times. The custom field has a value for the product that I test, but it always seem to go to the else case.
When I debug the {$sArticle.custom_url} in frontend template, it is shown there but I guess that it is not giving a value for the url. Any clues on that?