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

Maintainers

Details

github.com/Genaker/mage-product-view-table

Source

Issues

Installs: 0

Dependents: 0

Suggesters: 0

Security: 0

Stars: 2

Watchers: 1

Forks: 0

Open Issues: 0

Type:magento2-module

1.0.9 2024-12-21 02:20 UTC

Requires

Unknown License a8654d7693b4be601a6d3c9c7f46536be0fd41c8

This package is auto-updated.

Last update: 2024-12-21 02:21:25 UTC

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:
image

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
image
  • catalog_product_view_MVIEW : materialized view table from the view table. An update mechanism is required
image
  • product_json : table with the denormilised json attribute data in the data field. An update mechanism is also required
image