v1.5.5f | php 7.1.3 | Ceon uri mapping 4.5.5 | no error log generated for this issue | .htaccess is attached if of any use

After modifying product urls to incorporate a 'brand' name the new urls result in a '404 cannot be reached on this server'. So after diligently going through over 100 products and seeing if the brand name could be inserted into the url and still be appropriate I now have a site with products that cannot be reached!!

Frustrated = yes ... Why, why, why?

So why isn't the re-writer rewriting the old url to the new url after it creates the new url??? (the new url is being generated) - is it a .htaccess issue? (see attached)

Any and all assistance very much appreciated.

cheers, Mike

root .htaccess

Code:
RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$
RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$
RewriteRule ^index\.php$ - [L]

RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

###############################################################################
# Add any other directives relating to the handling of physical files
###############################################################################
# Notes:
#
# If processing makes it this far, the request was for a real file or folder.
# Example: Adding further processing related to browser caching or security.
###############################################################################
<IfModule mod_security.c>
    SecFilterScanPOST Off
</IfModule>

RewriteCond %{HTTP_HOST} ^cliponearrings\.net\.au$ [OR]
RewriteCond %{HTTP_HOST} ^www\.cliponearrings\.net\.au$
RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$
RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$
RewriteRule ^/?$ "https\:\/\/www\.cliponearrings\.net\.au\/" [R=301,L]
##################
RewriteCond %{HTTP_HOST} ^cliponearrings\.net\.au$ [OR]
RewriteCond %{HTTP_HOST} ^www\.cliponearrings\.net\.au$
RewriteRule ^earrings\-article\-ezp\-2\.html$ "https\:\/\/www\.cliponearrings\.net\.au\/earrings\-article\-origin\-and\-history\-of\-earrings" [R=301,L]
RewriteCond %{HTTP_HOST} ^cliponearrings\.net\.au$ [OR]
RewriteCond %{HTTP_HOST} ^www\.cliponearrings\.net\.au$
RewriteRule ^resources\-ezp\-3\.html$ "https\:\/\/www\.cliponearrings\.net\.au\/resources" [R=301,L]
RewriteCond %{HTTP_HOST} ^cliponearrings\.net\.au$ [OR]
RewriteCond %{HTTP_HOST} ^www\.cliponearrings\.net\.au$
RewriteRule ^products_all\.html$ "https\:\/\/www\.cliponearrings\.net\.au\/index\.php\?main_page\=products_all" [R=301,L]
RewriteCond %{HTTP_HOST} ^cliponearrings\.net\.au$ [OR]
RewriteCond %{HTTP_HOST} ^www\.cliponearrings\.net\.au$
RewriteRule ^featured_products\.html$ "https\:\/\/www\.cliponearrings\.net\.au\/index\.php\?main_page\=featured_products" [R=301,L]
RewriteCond %{HTTP_HOST} ^cliponearrings\.net\.au$ [OR]
RewriteCond %{HTTP_HOST} ^www\.cliponearrings\.net\.au$
RewriteRule ^specials\.html$ "https\:\/\/www\.cliponearrings\.net\.au\/index\.php\?main_page\=specials" [R=301,L]
RewriteCond %{HTTP_HOST} ^cliponearrings\.net\.au$ [OR]
RewriteCond %{HTTP_HOST} ^www\.cliponearrings\.net\.au$
RewriteRule ^products_new\.html$ "https\:\/\/www\.cliponearrings\.net\.au\/index\.php\?main_page\=products_new" [R=301,L]
RewriteCond %{HTTP_HOST} ^cliponearrings\.net\.au$ [OR]
RewriteCond %{HTTP_HOST} ^www\.cliponearrings\.net\.au$
RewriteRule ^how\-to\-easily\-adjust\-clip\-on\-earrings\-cliponearrings\.net\.au\-ezp\-6$ "https\:\/\/www\.cliponearrings\.net\.au\/how\-to\-easily\-adjust\-clip\-on\-earrings\-cliponearringsnetau\-ezp\-6\.html" [R=301,L]

###############################################################################

## BEGIN CEON URI MAPPING REWRITE RULE

RewriteEngine On

# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
# Don't rewrite any URIs for some, popular specific file format extensions,
#   which are not covered by main file extension condition above
# Don't rewrite any URIs for some specific file format extensions,
#   which are not covered by main file extension condition above
#   Uncomment the following line to apply this condition! (Remove the # at the start of the next line)
#RewriteCond %{REQUEST_URI} !\.(3gp|3g2|h261|h263|mj2|mjp2|mp4v|mpg4|m1v|m2v|m4u|f4v|m4v|3dml)$ [NC]
# Don't rewrite admin directory
# Don't rewrite editors directory
# Don't rewrite bmz_cache directory
# Don't rewrite .well-known directory
# Don't rewrite teststore directory
# Don't rewrite cgi-bin directory
# Don't rewrite zc_install_done directory
# Don't rewrite blog directory
# Don't rewrite logs directory
# Don't rewrite sitemap directory
# Don't rewrite temp directory
# Handle all other URIs using Zen Cart (its index.php)
RewriteCond %{REQUEST_URI} !\.[a-zA-Z]{2,5}$ [OR]
RewriteCond %{REQUEST_URI} \.(html)$ [NC]
RewriteCond %{REQUEST_URI} !\.(mp3|mp4|h264)$ [NC]
RewriteCond %{REQUEST_URI} !^/dazzlers [NC]
RewriteCond %{REQUEST_URI} !^/editors/ [NC]
RewriteCond %{REQUEST_URI} !^/bmz_cache/ [NC]
RewriteCond %{REQUEST_URI} !^/\.well\-known/ [NC]
RewriteCond %{REQUEST_URI} !^/teststore/ [NC]
RewriteCond %{REQUEST_URI} !^/cgi\-bin/ [NC]
RewriteCond %{REQUEST_URI} !^/zc_install_done/ [NC]
RewriteCond %{REQUEST_URI} !^/blog/ [NC]
RewriteCond %{REQUEST_URI} !^/logs/ [NC]
RewriteCond %{REQUEST_URI} !^/sitemap/ [NC]
RewriteCond %{REQUEST_URI} !^/temp/ [NC]
RewriteRule .* index.php [QSA,L]

## END CEON URI MAPPING REWRITE RULE

###############################################################################

## Optional caching improvements
## Requires mod_header and mod_deflate to be enabled within Apache
##################

##################
## Optional caching improvements
## Requires mod_header and mod_deflate to be enabled within Apache
##################
<filesMatch ".(ico|pdf|flv|jpg|jpeg|png|gif|webp|js|css|swf)$">
Header set Cache-Control "max-age=2592000, public"
</filesMatch>
<IfModule mod_deflate.c>
  <FilesMatch "(?i)\.(js|css)$">
    SetOutputFilter DEFLATE
  </FilesMatch>
</IfModule>

##################
## Optional improvements
## Requires mod_expires to be enabled within Apache
##################
## EXPIRES HEADER CACHING ##
 <IfModule mod_expires.c>
 ExpiresActive On
 ExpiresByType image/jpg "access 1 year"
 ExpiresByType image/jpeg "access 1 year"
 ExpiresByType image/gif "access 1 year"
 ExpiresByType image/png "access 1 year"
 ExpiresByType text/css "access 1 month"
 ExpiresByType application/pdf "access 1 month"
 ExpiresByType application/javascript "access 1 month"
 ExpiresByType application/x-javascript "access 1 month"
 ExpiresByType application/x-shockwave-flash "access 1 month"
 ExpiresByType image/x-icon "access 1 year"
 ExpiresDefault "access 7 days"
 </IfModule>
 ## EXPIRES HEADER CACHING ##