Im struggling on this so i need help please, i have 2 websites on the same magento installation ( ) :

CANADA ( default, code : base ) English (store view code : en_ca ) French ( store view code : fr_ca )

USA ( code : usa ) English ( store view code : en_us )

Add store code to url : yes Use web server rewrites : yes

the default website was the Canada one, but we decide to use USA as default, so i did this on dev ( i have no production site yet, still in dev mode ) :

Delete the USA website ( do you want to create a DB backup - i answer NO ) now i have the default website only ( canada with 2 languages ), I rename the Website name to USA ( keeping code to : base ), I rename the Store Name to USA store, I rename the Store view from en_ca to en_us, i delete the fr_ca store view.

After that i create my new website Canada with previous deleted settings, i reassign all my CMS pages and static blocks the the new Website, reindex, clear cache.

Everyting work except the USA - default(en_us) categories, it gives me a 404 ( not cms page 404, the default magento ugly blue & orange one ). All my products and CMS pages are working good.

What ive done since, i create a second store view in default website ( en_us2 ), this one work, i also create another root category and assign it to the USA Store, keep having this 404.

So it look like the default store view categories are down for some reason i did.

is there anyone that have face this issue before and/or have maybe a solution ?

thank you

  • 1
    did you reindex ?
    – PЯINCƎ
    Sep 15, 2018 at 21:34
  • Yes i reindex couple times, clear cache also.
    – Frank007
    Sep 16, 2018 at 14:47
  • What you think if you remove all (not just rename) the websites, stores, store views then you restart from scratch but you have to set all your sms pages for the different websites
    – PЯINCƎ
    Sep 16, 2018 at 20:44
  • @Prince, thank you for your help, i did that also. At this point i got only Default Website( base ) - default store( usa store ) - default store view( en_us )... and it was still not working.
    – Frank007
    Sep 25, 2018 at 19:04
  • Check in magento database names , delete or change them Sep 25, 2018 at 20:06

1 Answer 1


So i decide to return to previous settings and reinstall a back up( files + DB ), all work good. So i try the same procedure that broke the site, but in a reverse order, i rename : store view - store name - website, instead of : website - store name - store view... not sure if this was the problem, but it work find.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.