Home / inventory_stock_1 doest exist on magento 2.3 import problem

inventory_stock_1 doest exist on magento 2.3 import problem

You need elevated permissions to use the CREATE ALGORITHM bit

This can and will stop an import in it’s tracks.

Instead use this statement to create the view

Run this command

CREATE
OR REPLACE
VIEW `inventory_stock_1` AS select
    distinct `legacy_stock_status`.`product_id` AS `product_id`,
    `legacy_stock_status`.`website_id` AS `website_id`,
    `legacy_stock_status`.`stock_id` AS `stock_id`,
    `legacy_stock_status`.`qty` AS `quantity`,
    `legacy_stock_status`.`stock_status` AS `is_salable`,
    `product`.`sku` AS `sku`
from
    ( `cataloginventory_stock_status` `legacy_stock_status`
join `catalog_product_entity` `product` on
        (( `legacy_stock_status`.`product_id` = `product`.`entity_id` )));

Hits: 49

%d bloggers like this: