mage / product-view
There is no license information available for the latest version (1.0.9) of this package.
Magento 2 module to Create Prodcut View Flat table
Package info
github.com/Genaker/mage-product-view-table
Type:magento2-module
pkg:composer/mage/product-view
1.0.9
2024-12-21 02:20 UTC
Requires
- mage/db2: ^1
- mage/view-table: ^1
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
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