View Issue Details

IDProjectCategoryView StatusLast Update
0006345OXID eShop (all versions)4.06. Language and translationspublic2024-09-11 12:25
Reporterd3 Assigned To 
PrioritylowSeveritymajorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version4.9.7 / 5.2.7 
Summary0006345: hreflang + wrong abbreviation(ISO-Code)
DescriptionThe abbreviation from the languags-setting is used for the 'hreflang'-Link.
For German the Shop/Theme creates this link:
<link rel="alternate" hreflang="de" href="http://de.yourshop.de"/>
For English:
<link rel="alternate" hreflang="en" href="http://en.yourshop.de"/>

But what is with US-English or a separete German Language(Page) for Austria?
In this cases the value for hreflang should be:
en-Us / de-Au
This is a combination of language-code(https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes) an country-code(https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2).

It is not possible to use this combination in the shop!
The framework creates the views with this abbreviation(_de, _en). And a database view with this name: 'oxv_oxactions_en-Us' results in a SQL-Error.

This kind ofviews can't delete from an, ... SQL-Error.

A hreflang-Link with 'us' or 'au' is not a valid value.


Source
https://www.sistrix.de/hreflang-guide/


mg
TagsInternationalization Rework
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

kordhell

2024-09-09 09:23

reporter   ~0017488

Last edited: 2024-09-09 09:24

Using the correct hreflang values is crucial for SEO and ensuring that users are directed to the appropriate regional content. If the framework creates views with incorrect abbreviations like "_de" and "_en", and you’re encountering SQL errors with 'en-Us' or 'de-Au', it’s important to adjust the framework to support the proper ISO codes.

Updating the framework or correcting the view generation to use the proper regional codes should resolve these issues.
https://www.igmguru.com/digital-marketing-programming/ruby-on-rails-certification-training

SvenBrunk

2024-09-11 12:25

administrator   ~0017502

@kordhell we definitely agree with you and this will be one of our main topics for one of the next major releases.