I am having an issue with stores, magento is trying to find a store by id '3', it doesn't exist, due to which most of the functionality is not working. Website was migrated from to 2.2.7, I have checked both databases for the store ID but it only exists in the new database.

I have checked Magento 2: Requested store is not found

But it isn't related to my issue and not working.

After some digging I found that store ID '3' should infact be '5' as that is the store which customers belong to. I am trying to run a db query that changes store_id to 5 from 3, is this good practice or there is another way? How do I perform this for whole database instead of one table as in the query below.

UPDATE  `MySQL_Table` SET  `MySQL_Table_Column` = REPLACE(`MySQL_Table_Column`, 'oldString', 'newString') WHERE  `MySQL_Table_Column` LIKE 'oldString%';
  • I guess that your issue at data migration.Might be setting migration is not working properly – Amit Bera Mar 8 '19 at 7:44
  • Could be but is my proposed solution a good one? – paranoid kid Mar 8 '19 at 8:58
  • Yes, my proposed solution worked, also used sql search to find the tables with the id that was giving the error – paranoid kid Mar 10 '19 at 13:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.