Author Topic: Export product urls (alias)  (Read 670 times)

MKI-Miro

  • Jr. Member
  • **
  • Posts: 185
Export product urls (alias)
« on: May 23, 2020, 22:43:37 pm »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9651
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Export product urls (alias)
« Reply #1 on: May 23, 2020, 23:17:24 pm »
no -- they are never stored -
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4329
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Export product urls (alias)
« Reply #2 on: May 24, 2020, 11:12:05 am »
You need to use the router to generate it.
Code: [Select]
JRoute::_ ('index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_product_id . '&virtuemart_category_id=' . $product->virtuemart_category_id);

MKI-Miro

  • Jr. Member
  • **
  • Posts: 185
Re: Export product urls (alias)
« Reply #3 on: May 25, 2020, 09:26:27 am »
so not possible to construct it with SQL query?

thanks

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4329
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Export product urls (alias)
« Reply #4 on: May 26, 2020, 14:42:01 pm »
If it was possible, i had give the solution

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9651
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Export product urls (alias)
« Reply #5 on: May 27, 2020, 00:03:58 am »
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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation