Export product urls (alias)

[MKI-Miro]

Hi

I need to export URL links (alias-links) for products like

product_id, product_url

Is there any sql query for it?

Thanks

[GJC Web Design]

no -- they are never stored -

[Studio 42]

You need to use the router to generate it.

Code Select Expand

JRoute::_ ('index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_product_id . '&virtuemart_category_id=' . $product->virtuemart_category_id);

[MKI-Miro]

so not possible to construct it with SQL query?

thanks

[Studio 42]

If it was possible, i had give the solution

[GJC Web Design]

you would need to code a small script that is in the Joomla namespace to use the router

get the pids, form the url and render it thru the router and record

[MKI-Miro]

You need to use the router to generate it.

Code Select Expand

JRoute::_ ('index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_product_id . '&virtuemart_category_id=' . $product->virtuemart_category_id);

not working it outputs non sef urls, seems like it is missing something

[GJC Web Design]

the &Itemid={vm root menu}

[MKI-Miro]

thank you but it is still generating non sef url 

index.php?option=com_virtuemart&view=productdetails&Itemid=1912&virtuemart_product_id=9220

[PRO]

Do you have csvimproved?

[pinochico]

Do you have easyfeeder?

[Jörgen]

Perhaps a silly question, Do You have search friendly URL turned on in Joomla and in VM ?

Jörgen @ Kreativ Fotografi

[Studio 42]

Do you run your PHP in admin ?
To get SEF url you need to do it in front side.