Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this community
I need to select all the attributes of the products these columns of all products in the tables:
Any suggestion?
--
TABLE: catalog_product_entity
COLUMN: sku
--
TABLE: catalog_product_index_price
COLUMN: price
--
TABLE: cataloginventory_stock_status
COLUMN: qty
COLUMN: stock_status
--
TABLE: catalog_product_index_price
COLUMN: price
Ready, I got it.
Just use:
SELECT DISTINCT catalog_product_entity.entity_id, sku, price as preco, qty as quantidade, stock_status as estoque FROM catalog_product_entity INNER JOIN cataloginventory_stock_status ON (cataloginventory_stock_status.product_id = entity_id) INNER JOIN catalog_product_index_price ON (catalog_product_index_price.entity_id = catalog_product_entity.entity_id)
LEFT JOIN instead of INNER JOIN if you want to catch situations where a product doesn't have stock or price 2) the query works for single store Magento installations; if you have more than one store you might want to add AND catalog_product_index_price.website_id=$websiteId to the second join 3) you might be interested in catalog_product_index_price.final_price field also since that's the actual selling price.