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

UM9F81RCP · May 2020

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

Jeremy Fourna · May 2020

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 · May 2020

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

UM9F81RCP · May 2020

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

    ],

Jeremy Fourna · May 2020

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

UM9F81RCP · May 2020

I see

UM9F81RCP · May 2020

thank you Jeremy 🙂

Jeremy Fourna · May 2020

yrw

UM9F81RCP · May 2020

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

giovanni.piemontese · May 2020

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

UM9F81RCP · May 2020

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

Ievgen Varava · May 2020

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

UM9F81RCP · May 2020

so you think it is safe?

Ievgen Varava · May 2020

I cant read your thoughts, sorry

Ievgen Varava · May 2020

what do you try to achieve with dropping unique constraint?

UM9F81RCP · May 2020

I want a different URL based on locale not language

Ievgen Varava · May 2020

then make it different and stick to unique constraint

giovanni.piemontese · May 2020

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 · May 2020

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 · May 2020

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

giovanni.piemontese · May 2020

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

UM9F81RCP · May 2020

thanks a lot

giovanni.piemontese · May 2020

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 · May 2020

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 · May 2020

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 · May 2020

actually the same

giovanni.piemontese · May 2020

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

UM9F81RCP · May 2020

ok I will try that

UM9F81RCP · May 2020

thank you very much 🙂

giovanni.piemontese · May 2020

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 · May 2020

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

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

Welcome!

Comments

Welcome!

Welcome!

Quick Links

Categories