#6970 – Batch Redirection of VM Product URLs

  Finally about the URLs of the product I would like to do a general redirection:

/*/*/*/xxxxxx-detail.html

>

/xxxxxx-detail.html

Where xxxxxx the name of the product.

The categories and sub-categories (/*/*/*/) could be 1, 2, 3 or 4

You can do that by setting a alias. Read the details with full examples on this page of the documentation.. You don't need to care about how many sub-categories there are. You can just redirect /{*}/{*}-detail.html to /{*}-detail.html

I added the alias,
/{*}/{*}-detail.html to /{*}-detail.html
but strange things happen.
/axesouar-kouzinas/mpataries-kouzines/mpataria-kouzinas-gloria-simplex-13-5064-detail.html
should redirect to:
/mpataria-kouzinas-gloria-simplex-13-5064-detail.html
but redirects to:
/axesouar-kouzinas/mpataries-kouzines/mpataries-kouzinas-pagkou.html

/diafora/grammatokibotia/gramatothirida-viometal-torino-205-mpronze-detail.html
should redirect to:
/gramatothirida-viometal-torino-205-mpronze-detail.html
but redirects to
/stop-portas-dapedou-viometale-mpronze-detail.html

I have "301 redirect from non-sef to sef URL" and "301 redirect from JOOMLA SEF to sh404SEF"
set to NO, in order not to make any redirection depending on the URLs in database.
Is there another setting I am missing?

There is nothing in the alias tab (alias-tab.jpg).
I do not use any other SEO extension. You can also check the backend.

The htaccess is the default joomla htaccess. Only added a redirection from non www to www in the custom redirection area, as you can see the code below:

##
# @package    Joomla
# @copyright  Copyright (C) 2005 - 2019 Open Source Matters. All rights reserved.
# @license    GNU General Public License version 2 or later; see LICENSE.txt
##

##
# READ THIS COMPLETELY IF YOU CHOOSE TO USE THIS FILE!
#
# The line 'Options +FollowSymLinks' may cause problems with some server configurations.
# It is required for the use of mod_rewrite, but it may have already been set by your
# server administrator in a way that disallows changing it in this .htaccess file.
# If using it causes your site to produce an error, comment it out (add # to the
# beginning of the line), reload your site in your browser and test your sef urls. If
# they work, then it has been set by your server administrator and you do not need to
# set it here.
##

## No directory listings
<IfModule autoindex>
  IndexIgnore *
</IfModule>

## Suppress mime type detection in browsers for unknown types
<IfModule mod_headers.c>
Header always set X-Content-Type-Options "nosniff"
</IfModule>

## Can be commented out if causes errors, see notes above.
Options +FollowSymlinks
Options -Indexes

## Mod_rewrite in use.

RewriteEngine On

## Begin - Rewrite rules to block out some common exploits.
# If you experience problems on your site then comment out the operations listed
# below by adding a # to the beginning of the line.
# This attempts to block the most common type of exploit `attempts` on Joomla!
#
# Block any script trying to base64_encode data within the URL.
RewriteCond %{QUERY_STRING} base64_encode[^(]*\([^)]*\) [OR]
# Block any script that includes a <script> tag in URL.
RewriteCond %{QUERY_STRING} (<|%3C)([^s]*s)+cript.*(>|%3E) [NC,OR]
# Block any script trying to set a PHP GLOBALS variable via URL.
RewriteCond %{QUERY_STRING} GLOBALS(=|\[|\[0-9A-Z]{0,2}) [OR]
# Block any script trying to modify a _REQUEST variable via URL.
RewriteCond %{QUERY_STRING} _REQUEST(=|\[|\[0-9A-Z]{0,2})
# Return 403 Forbidden header and show the content of the root home page
RewriteRule .* index.php [F]
#
## End - Rewrite rules to block out some common exploits.

## Begin - Custom redirects
#
# If you need to redirect some pages, or set a canonical non-www to
# www redirect (or vice versa), place that code here. Ensure those
# redirects use the correct RewriteRule syntax and the [R=301,L] flags.
#
## End - Custom redirects
RewriteEngine On
RewriteCond %{HTTP_HOST} !^www\. [NC]
RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]
##
# Uncomment the following line if your webserver's URL
# is not directly related to physical file paths.
# Update Your Joomla! Directory (just / for root).
##

# RewriteBase /

## Begin - Joomla! core SEF Section.
#
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
#
# If the requested path and file is not /index.php and the request
# has not already been internally rewritten to the index.php script
RewriteCond %{REQUEST_URI} !^/index\.php
# and the requested path and file doesn't directly match a physical file
RewriteCond %{REQUEST_FILENAME} !-f
# and the requested path and file doesn't directly match a physical folder
RewriteCond %{REQUEST_FILENAME} !-d
# internally rewrite the request to the index.php script
RewriteRule .* index.php [L]
#
## End - Joomla! core SEF Section.

PERFECT!!!!
Thank you again, for resolving one more issue.
I think it´s all done now.