默认数据库表建立方法:
1CREATE
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` ))
请登录已经激活账号继续浏此文章所有内容!