Author Topic: Delete all the product's alias and regenerate them  (Read 399 times)

m.davide82

  • Jr. Member
  • **
  • Posts: 89
Delete all the product's alias and regenerate them
« on: May 12, 2017, 23:01:42 pm »
Hello,

is there any where to delete all the product's alias and regenerate them?


Thanks a lot,
Davide

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9374
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Delete all the product's alias and regenerate them
« Reply #1 on: May 17, 2017, 20:27:17 pm »
one by one, open, delete, store..

or delete all by sql,... and use a small php script,.. loading any product and store it, which generates the slugs automatically
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

m.davide82

  • Jr. Member
  • **
  • Posts: 89
Re: Delete all the product's alias and regenerate them
« Reply #2 on: May 18, 2017, 00:10:28 am »
The problem was this, I deleted them from mysql but the urls are not working any more.

It will be beautiful to have an option to re-generete them in bulk, necessary during the development.


Thanks a lot!

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2628
  • VirtueMart Version: 3.2.5
Re: Delete all the product's alias and regenerate them
« Reply #3 on: May 18, 2017, 10:39:50 am »
just write some sql to generate them using "product name"

make sure you check for duplicates
regards
A

Joomla 3.8.2
php 5.6 + php 7