VirtueMart Forum

Hi

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

product_id, product_url

Is there any sql query for it?

Thanks

no -- they are never stored -

You need to use the router to generate it.
JRoute::_ ('index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_product_id . '&virtuemart_category_id=' . $product->virtuemart_category_id);

so not possible to construct it with SQL query?

thanks

If it was possible, i had give the solution

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

Quote from: Studio 42 on May 24, 2020, 11:12:05 AM
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

the &Itemid={vm root menu}

thank you but it is still generating non sef url  :(

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

Do you have csvimproved?

Do you have easyfeeder?

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

Jörgen @ Kreativ Fotografi

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