Skip to content

Instantly share code, notes, and snippets.

@steverobbins

steverobbins/magento-copy-cms-to-store-view.sql

Created August 6, 2014 23:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save steverobbins/ab55916c48b8d38cfd7c to your computer and use it in GitHub Desktop.
Save steverobbins/ab55916c48b8d38cfd7c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
magento-copy-cms-to-store-view.sql
set @STORE_TO_COPY_FROM = 2;
set @STORE_TO_COPY_TO = 3;
insert ignore into cms_block_store
select block_id, @STORE_TO_COPY_TO
from cms_block_store
where store_id = @STORE_TO_COPY_FROM;
insert ignore into cms_page_store
select page_id, @STORE_TO_COPY_TO
from cms_page_store
where store_id = @STORE_TO_COPY_FROM;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment