I created a new Store View in my Magento and now I need to set some of my pages and blocks to "All Store Views".

When I go to CMS > Page or CMS > Static Blocks I am able to open one item (page or block) and change the Store View inside it. Do I need to do it manually for each page/block or is there an easy way to do that? (Like multiple select changes)



Run sql to update them by batch,

  1. Mark down all your cms page id that want to switch to all store view
  2. insert record into table 'cms_page_store', where the page id is the cms you mentioned in step1, set store_id = 0 (means all store view)
|improve this answer|||||
  • Thanks @leo, just a small fix in your answer: If I already have the pages, I will need to modify the record instead of insert a duplicated one, right? – Bruno Monteiro Jun 14 '16 at 16:05
  • Anyway, thanks for giving the directions to the right table :) – Bruno Monteiro Jun 14 '16 at 16:06
  • Yes, you dont need to copy the page "content" into a new record, only associate it to another store_id. You can observe what data is updated 'cms_page_store' when you save a page in magento admin. It helps you to know how to write your query. – leo Jun 15 '16 at 3:20

Your Answer

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

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