There are many posts regarding adding realurl to tt_products but I found that the fillowing code works well.
Copy this code to your realurl configuration file. Disable the realurl autoconf in the Backend.
// product categories
‘categories’ => array (
array (
‘GETvar’ => ‘tt_products[cat]’ ,
‘lookUpTable’ => array (
‘table’ => ‘tt_products_cat’ ,
‘id_field’ => ‘uid’ ,
‘alias_field’ => ‘title’ ,
‘addWhereClause’ => ‘ AND NOT deleted’ ,
‘languageGetVar’ => ‘L’,
‘useUniqueCache’ => 1 ,
‘useUniqueCache_conf’ => array (
‘strtolower’ => 1 ,
‘spaceCharacter’ => ‘-‘ ,
)
)
)
),
// products
‘products’ => array (
array (
‘GETvar’ => ‘tt_products[product]’ ,
‘lookUpTable’ => array (
‘table’ => ‘tt_products’ ,
‘id_field’ => ‘uid’,
‘alias_field’ => ‘title’ ,
‘addWhereClause’ => ‘ AND NOT deleted’ ,
‘languageGetVar’ => ‘L’,
‘useUniqueCache’ => 1 ,
‘useUniqueCache_conf’ => array (
‘strtolower’ => 1 ,
‘spaceCharacter’ => ‘-‘ ,
)
)
)
),
// backPID
‘backPID’ => array (
array (
‘GETvar’ => ‘tt_products[backPID]’ ,
‘lookUpTable’ => array (
‘table’ => ‘pages’ ,
‘id_field’ => ‘uid’ ,
‘alias_field’ => ‘title’ ,
‘addWhereClause’ => ‘ AND NOT deleted’ ,
‘languageGetVar’ => ‘L’,
‘useUniqueCache’ => 1 ,
‘useUniqueCache_conf’ => array (
‘strtolower’ => 1 ,
‘spaceCharacter’ => ‘-‘ ,
)
)
)
) ,