Multistore / Multilingual

HI there
I am looking for some general advice to runing multiple stores from one installation. V3.8

My webstore will sell printers.

I want to have a different site for each country. i.e UK, France, Spain, Germany

Each store will sell the SAME products and use the same Categories but just in the native language

Each store will be set to display the relevant language i.e.

store.co.uk will be english
store.es will be spanish
store.fr will be french

Each store will be set to use the native currency ie,

store.co.uk will be GBP
store.es will be EURO

My question:

Can I run multiple stores all selling the same products and using the same categories. Just using the language as the difference between  them?

any answer as to whether this can be done would be great !

toadman wrote:

Yes. In language settings assign each lenguaje (Limited to store)to the corresponding store. The same for currencies

Thank you !

can you import products or categories in multiple languages?
Thanks !

AFAIK, the excel import is in the default language only.

To add names and descriptions in another language, you'd have to use the UI, or code to add/set the corresponding properties in [dbo].[LocalizedProperty]

For example, to set the FullDescription in spanish (assuming you have them in a SQL table)

with localizedData as (
  select
    EntityId = prd.Id
    , LanguageId = 2 -- Spanish (México)
    , LocaleKeyGroup = 'Product'
    , LocaleKey = 'FullDescription'
    , LocaleValue = tsrc.LongDescSpanish
  from
    [dbo].[Product] prd
    inner join [dbo].[tmpPrdSpanishDesc] tsrc with (NoLock) on tsrc.ProductId = prd.Id
  where 
    LongDescSpanish is not null
)
MERGE INTO [dbo].[LocalizedProperty] AS target
USING localizedData AS source
    ON target.EntityId = source.EntityId 
    AND target.LanguageId = source.LanguageId
    AND target.LocaleKeyGroup = source.LocaleKeyGroup
    AND target.LocaleKey = source.LocaleKey
WHEN MATCHED THEN 
    UPDATE SET target.LocaleValue = source.LocaleValue
WHEN NOT MATCHED BY TARGET THEN
    INSERT (EntityId, LanguageId, LocaleKeyGroup, LocaleKey, LocaleValue)
    VALUES (source.EntityId, source.LanguageId, source.LocaleKeyGroup, source.LocaleKey, source.LocaleValue);