How to bulk modify title tag

[dreadscott]

URL: https://www.usrallyteam.com
ZC: 1.5.8a
PHP version: 7.4.33
MySQL 8.0.37
HTTP Server: Apache

Hey, folks. I'm an "advanced n00b" with a a basic problem to resolve. Hundreds of my products include a non-standard "|" character in the title tag. For example, this product's meta title tag is written as: | 4-cylinder direct port WMI (octane + fueling)

How do I globally remove all the | as the first character from title tags written that way? Initial research leads me to believe that I must find the TABLE_META_TAGS_PRODUCTS_DESCRIPTION table and then adjust it. How is this done? Or, where do I start to research this topic? Can I/should I replace the | with another space holder like an * or -, etc?

Thanks,

[dreadscott]

ONE other thing... I'm using the Sitemap XML v4.0.1 plugin and see this advice:


However, a simple URL check demonstrates that the file is right there. Should I just ignore the warning? Why do these things happen? :)
https://www.usrallyteam.com/robots.txt

[lat9]

ONE other thing... I'm using the Sitemap XML v4.0.1 plugin and see this advice:


However, a simple URL check demonstrates that the file is right there. Should I just ignore the warning? Why do these things happen? :)
https://www.usrallyteam.com/robots.txt

SitemapXMP uses this concatenation to determine the presumed means to access a site's sitemap.xml file:

HTTP_CATALOG_SERVER . DIR_WS_CATALOG . SITEMAPXML_SITEMAPINDEX . '.xml';

... where the first two constants come from your admin/includes/configure.php and the last one is set in the SitemapXML configuration settings. From viewing the robots.txt, that contains a www. prefix to the site's URL which is not reflected in the HTTP_CATALOG_SERVER setting.

Sitemap: https://www.usrallyteam.com/sitemap.xml

[dreadscott]

I thank you for the help, lat9. In plain English, then... What you're saying is that a simple change will fix the problem, yes?

I should rewrite this:
Sitemap: https://www.usrallyteam.com/sitemap.xml

to this?
Sitemap: https://usrallyteam.com/sitemap.xml

[lat9]

I thank you for the help, lat9. In plain English, then... What you're saying is that a simple change will fix the problem, yes?

I should rewrite this:
Sitemap: https://www.usrallyteam.com/sitemap.xml

to this?
Sitemap: https://usrallyteam.com/sitemap.xml

Yes, sorry for not stating the actual solution from the get-go!

[dreadscott]

Yes, sorry for not stating the actual solution from the get-go!

Alrighty, I do believe we've made progress on this one. Thanks so much for the help.


Now about this title meta tag challenge... Hmmm...

[simon1066]

Now about this title meta tag challenge... Hmmm...

The link you posted, of a product, shows the title tag as

<title>(RACE) DPR4 | 4-cylinder direct port WMI (octane + fueling)</title>

which looks fine, but I do note others of yours in Google search results that do begin with '|'

e.g.

<title>| Direct port injection w/RACE valves = best octane + fueling</title>

that is the tag for a category page and shouldn't be happening - it is missing the 'categories_name' and that is the problem. I don't have an answer but the category title tags are generated in \includes\modules\meta_tags.php (or its override). Compare yours with the original to see if there's something awry.

Anyways, not an answer but, the '|' separator/divider usually defined in \includes\languages\english\lang.meta_tags.php (or the template's override copy if you have one). Removing it might resolve the issue of the second example but will potentially screw up the appearance of the first tag.