WakizashiYoshikawa
WakizashiYoshikawa
/ m2_get_products_data.sql
Last active
March 22, 2021 11:28
— forked from antoinekociuba/m2_get_products_data.sql
Magento 2 - Retrieve some products data (name, price, stock qty, images, categories...) from SQL query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Updated query for EE and reference to row_id intead of entity_id in joins */ | |
| SELECT e.entity_id AS 'id', | |
| v1.value AS 'name', | |
| e.sku, | |
| d1.value AS 'price', | |
| si.qty AS 'qty', | |
| t1.value AS 'short_description', | |
| t2.value AS 'description', | |
| v2.value AS 'image', | |
| v3.value AS 'thumbnail', |