301 redirects diff file

johnbol1 · November 14, 2024, 6:43pm

regards the post below by @thetool and @CS-Cart_team I have 7000 301 redirects created with most like this, is there any way I can delte them in bulk.
I cant reply in that thread, it has been closed ?

thetool · November 16, 2024, 5:35pm

If you have other legitimate redirects, you will unfortunately have to go through the list and pick and choose.

I didn’t have other legitimate redirects so I have been deleting the list in bulk throughout the years.

CS-Cart_team · November 18, 2024, 7:56am

Thanks for your comment.

I’ve created the script that seems to remove these duplicates and even tested it, but only with one duplicate

Please make a backup of the seo_redirects table. Then upload the following script to the root of your installation:

gist.github.com

https://gist.github.com/Saylt/25b50778ebbea281eacdee4355c1f4e2

remove_broken_seo_redirects.php

<?php

use Tygh\Enum\YesNo;
use Tygh\Registry;

define('AREA', 'A');
define('ACCOUNT_TYPE', 'admin');

require(__DIR__ . '/init.php');

This file has been truncated. show original

and run it from your browser. If something goes wrong, restore the backup.

johnbol1 · November 18, 2024, 10:19am

Great, thanks for the help

johnbol1 · November 24, 2024, 7:23pm

Thanks, and I managed to remove some, but …

Is there anyway it can look at and remove duplicates like this
/custom-printed-hi-vis-coat-yellow.html
but remove this
https://www.myweb site/custom-printed-hi-vis-coat-yellow.html

CS-Cart_team · December 2, 2024, 7:40am

Unfortunately, I didn’t understand what is required to be done. Could you please clarify?