Hallo all, How can we make Spryker generate URLs for store that has two english locales? like en_GB

UM9F81RCP

Hallo all,
How can we make Spryker generate URLs for store that has two english locales? like en_GB and en_IE,

Jeremy Fourna

You must have those locales defined for your stores and also your data must have a value for those locales
• CMS pages
• Products
• etc.

UM9F81RCP

yeah but in stores.php the key for locale array is language

UM9F81RCP

    'locales' => [
        'en' => 'en_GB',
        'en' => 'en_IE', // <- ????

    ],

Jeremy Fourna

you could define whatever you want as key there, we use it for shortcut

UM9F81RCP

I see

UM9F81RCP

thank you Jeremy 🙂

Jeremy Fourna

yrw

UM9F81RCP

one more question please 😅 how would dropping unique indexfrom url column in spy_url affect the applicaiton behaviour?

giovanni.piemontese

u can override spy_url.schema.xml in pyz level and u can overwrite the unique index or remove it for example.

UM9F81RCP

I know I can do that 😅 my concern is what would be the consequences of that!?

Ievgen Varava

you won't get where you might expect? as the first occurence of url might be used afterwards

UM9F81RCP

so you think it is safe?

Ievgen Varava

I cant read your thoughts, sorry

Ievgen Varava

what do you try to achieve with dropping unique constraint?

UM9F81RCP

I want a different URL based on locale not language

Ievgen Varava

then make it different and stick to unique constraint

giovanni.piemontese

i had for example the unique key extended with fk_locale too and everything worked fine..

because in the case u have two store with same language and same url then the actual schema does not work

They are already based on locale and not language.. the problem is only in stores.php

UM9F81RCP

I was thinkning the same but doing this will require a lot of data manipulation on my import files because I have big files … I was thinking maybe we can do somehting on app level

UM9F81RCP

@UL65CH0MC how did you address the problem in stores.php?

giovanni.piemontese

one mom.. let me see in my old project..

UM9F81RCP

thanks a lot

giovanni.piemontese

ok, i dont' have any store with two same language..

i have only for example FR Store with fr_FR locale and CH Shop with fr_CH locale too..

it means with the change of unique key it was possible in my shop have the same url /fr/blabla in spy_url table but for two different locales.. but unfortunately i dont have the same language for the same store...

UM9F81RCP

i have only for example FR Store with fr_FR locale and CH Shop with fr_CH locale too..

I have similar problem 😄

giovanni.piemontese

but i think u need two different language.. therefore it is as key in stores.php because the language is used to recognize the language via url...

UM9F81RCP

actually the same

giovanni.piemontese

then it is enough to extend the unique key in db..

UM9F81RCP

ok I will try that

UM9F81RCP

thank you very much 🙂

giovanni.piemontese

so i had in my old project

<?xml version="1.0"?>
<database xmlns:xsi="<http://www.w3.org/2001/XMLSchema-instance>" name="zed" xsi:noNamespaceSchemaLocation="<http://static.spryker.com/schema-01.xsd>" namespace="Orm\Zed\Url\Persistence" package="src.Orm.Zed.Url.Persistence">

    <table name="spy_url" phpName="SpyUrl">
        <unique name="spy_url_unique_key">
            <unique-column name="url"/>
            <unique-column name="fk_locale"/>
        </unique>
    </table>
</database>

giovanni.piemontese

please check if name etc... still the same are