Magento 2 – Programmatically Change CMS Block and CMS Page Store

cms-blockcms-pagesmagento2migration

I had migrated data into magento 1.X to 2.X.

In the migrated website I have around 2000 pages+blocks so I have to set all CMS blocks and CMS pages in all stores.

Give me a better solution .

Best Answer

The relation between blocks and store view is kept in the table cms_block_store and for pages in cms_page_store.
These tables contain 2 column. One is the store_id and the other is the page or block id, depending on the table.
You can simply insert rows in these tables.
One row for each page and block and set the store id to 0.
This will make all pages and blocks available in all the stores.

You can run these queries on your db:
For blocks

INSERT INTO cms_block_store
SELECT block_id, 0 FROM cms_block;

and for pages

INSERT INTO cms_page_store
SELECT page_id, 0 FROM cms_page;

Related Solutions

Magento 2 – How to Add a CMS Block Programmatically

add this to the your class:

private $blockFactory;

and make your constructor look like this:

public function __construct(
    PageFactory $pageFactory,
    \Magento\Cms\Model\BlockFactory $blockFactory
  )
{
    $this->pageFactory = $pageFactory;
    $this->blockFactory = $blockFactory;
}

you can even remove the $pageFactory dependency if you don't need it anymore.

Then replace:

$testPage = [
    'title' => 'Test page title',
    'identifier' => 'test-page',
    'stores' => [0],
    'is_active' => 1,
    'content_heading' => 'Test page heading',
    'content' => 'Test page content',
    'page_layout' => '1column'
];

$this->pageFactory->create()->setData($testPage)->save();

with

$testBlock = [
    'title' => 'Test block title',
    'identifier' => 'test-block',
    'stores' => [0],
    'is_active' => 1,
];
$this->blockFactory->create()->setData($testBlock)->save();

Magento – How to add a CMS Block via XML layout update in Magento 2

I found the solution in case this will help anyone. In Magento 2, if you want to create a left side bar navigation, (and remove wishlist and compare), you need the following code in the CMS Page Layout Update XML (I dont like editing files if I dont have to, thats why I like sysing Layout Update XML). My block is called "guidenav" that calls the menu.

<referenceContainer name="sidebar.additional">
<referenceBlock name="catalog.compare.sidebar" remove="true"/>
<referenceBlock name="wishlist_sidebar" remove="true" />
<referenceBlock name="sale.reorder.sidebar" remove="true" />
    <block class="Magento\Cms\Block\Block" name="guidenav">
        <arguments>
            <argument name="block_id" xsi:type="string">promo</argument>
        </arguments>
    </block>
</referenceContainer>

Best Answer

Related Solutions

Magento 2 – How to Add a CMS Block Programmatically

Magento – How to add a CMS Block via XML layout update in Magento 2

Related Topic