Magento – Programmatically Change All Categories for All Store Views

categorycollection;store-view

I want to change some data of all categories (all store views).

This is my code:

$category = Mage::getModel('catalog/category');
$tree = $category->getTreeModel();
$tree->load();
$ids = $tree->getCollection()->getAllIds();
asort($ids);
$categories = array();
if($ids) {
    foreach ( $ids as $id ) {
        $cat = $category->load($id);
        if($cat->getId()) {
            $cat->setName($cat->getName().' add some text');
            $cat->save();
        }
    }
}

Unfortunately I get only the data of the second language.
I need to change data of all languages (store views).

Does anyone has an idea?

Best Answer

$storeIds = Mage::getModel('core/store')->getCollection()->getAllIds();
$category = Mage::getModel('catalog/category');
$tree = $category->getTreeModel();
$tree->load();
$ids = $tree->getCollection()->getAllIds();
asort($ids);
$categories = array();
if($ids) {
    foreach ( $ids as $id ) {
        foreach ($storeIds as $storeId) {
            if ($storeId == 0) {
                continue;
            }
            $cat = $category->setStoreId($storeId)->load($id);
            if($cat->getId()) {
                $cat->setName($cat->getName().' add some text');
                $cat->save();
            }
        }
    }
}

Related Solutions

Magento – Multi store view confusion, page 404’s redirects and Magento store codes

To get around this problem, you could consider using another URL for the second store view and then explicitly set that store ID -> then it would work.

Let's assume you have www.store.com

Then use for example www.store.com/de/ for the German store view (i.e. set this as the base URL for that store view in your backend).

In the index.php (or better using .htaccess logic) you should then detect that whenever there is /de/ in your URL, you set the store ID to your second store view.

That way, the URL of the translated store is uniquely detectable and everything will work out while you still keep the original URL for your main store.

Magento – Magento 2 : URL key For Specified Store Already Exists

I've fixed this issue. And I have 2 solutions for that.

The first one: Clean up your database in table url_rewrite (Change the url_key of all category). You can write UpgradeData script for this solution.

The second one: Remove the duplication data when saving category. This data is throw in method doReplace($urls) in \vendor\magento\module-url-rewrite\Model\Storage\DbStorage.php file.

protected function doReplace($urls)
    {
        foreach ($this->createFilterDataBasedOnUrls($urls) as $type => $urlData) {
            $urlData[UrlRewrite::ENTITY_TYPE] = $type;
            $this->deleteByData($urlData);
        }
        $data = [];
        foreach ($urls as $url) {
            $data[] = $url->toArray();
        }
        $this->insertMultiple($data);
    }

After debugging, I found out $data variable has a duplicate record. If you want this method to work without any errors. Rewrite this method above to:

protected function doReplace($urls)
{
    foreach ($this->createFilterDataBasedOnUrls($urls) as $type => $urlData) {
        $urlData[UrlRewrite::ENTITY_TYPE] = $type;
        $this->deleteByData($urlData);
    }
    $data = [];
    $storeId_requestPaths = [];
    foreach ($urls as $url) {
        $storeId = $url->getStoreId();
        $requestPath = $url->getRequestPath();
        // Skip if is exist in the database
        $sql = "SELECT * FROM url_rewrite where store_id = $storeId and request_path = '$requestPath'";
        $exists = $this->connection->fetchOne($sql);

        if ($exists) continue;

        $storeId_requestPaths[] = $storeId . '-' . $requestPath;
        $data[] = $url->toArray();
    }

    // Remove duplication data;
    $n = count($storeId_requestPaths);
    for ($i = 0; $i < $n - 1; $i++) {
        for ($j = $i + 1; $j < $n; $j++) {
            if ($storeId_requestPaths[$i] == $storeId_requestPaths[$j]) {
                unset($data[$j]);
            }
        }
    }
    $this->insertMultiple($data);
}

If you want to get more details. Please, read my comment in

https://github.com/magento/magento2/issues/7298

Hope this will help you.

Best Answer

Related Solutions

Magento – Multi store view confusion, page 404’s redirects and Magento store codes

Magento – Magento 2 : URL key For Specified Store Already Exists

Related Topic