Posted By

aashvi on 10/20/10

Tagged

path
magento

Versions (?)

Last Edited at 10/20/10 10:51pm

Statistics

Viewed 2322 times

Favorited by 0 user(s)

Related snippets

Magento : product sku and url

/ Published in: PHP

Following sql statement collect product sku with store url

select catalog_product_entity.sku,catalog_product_entity_varchar.value from catalog_product_entity,catalog_product_entity_varchar where
catalog_product_entity_varchar.attribute_id=87 and catalog_product_entity_varchar.store_id=0 and catalog_product_entity_varchar.entity_id=catalog_product_entity.entity_id

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

select catalog_product_entity.sku,catalog_product_entity_varchar.value from  catalog_product_entity,catalog_product_entity_varchar where 
catalog_product_entity_varchar.attribute_id=87 and catalog_product_entity_varchar.store_id=0 and catalog_product_entity_varchar.entity_id=catalog_product_entity.entity_id