I have installed magento2.1 and it was working properly with multi-store.

When I have disabled some categories from a "sub" store, and try to add any product (already assigned to "sub" store) to that category (which is edited in "sub" store) system returns error url key for specified store already exists.

If I removed "sub" store from "product in website" and try to assign that category again it saved successfully.

That's mean it is the issue with categories which has different value of any attribute in multi-store view.

I found so many post regarding this, but unable to fix this issue.

How to solve this issue in magento2?


I did following changes and it is working.

Magento\UrlRewrite\Model\Storage\DbStorage.php file

protected function insertMultiple($data)
        try {
            foreach($data as $current=>$_data)
                $key = $_data['request_path'];

            $this->connection->insertMultiple($this->resource->getTableName(self::TABLE_NAME), $data);
        } catch (\Exception $e) {
            if ($e->getCode() === self::ERROR_CODE_DUPLICATE_ENTRY
                && preg_match('#SQLSTATE\[23000\]: [^:]+: 1062[^\d]#', $e->getMessage())
            ) {
                throw new \Magento\Framework\Exception\AlreadyExistsException(
                    __('URL key for specified store already exists.')
            throw $e;

Reference :


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.