README

composer require mage/product-view

All the tables(ViewTable, MView, JSON) will be create on setup:upgrade

You can also run it with the command bin/magento pview:run, which will populate the table with the data.

bin/magento pview:run

Command Output:

By running this code populateProductJsonTableFromView($changeLog = false) with the true parameter, you are generating data only for change log data

Tables will be generated:

• catalog_product_view : it is a view, not a table. Runs direct SQL to the core magento tables. Update mechanism not required however, has performace of the raw queries

• catalog_product_view_MVIEW : materialized view table from the view table. An update mechanism is required

• product_json : table with the denormilised json attribute data in the data field. An update mechanism is also required