Magento : product sku and url - PHP Snipplr Social Repository

Revision: 34307

at October 20, 2010 22:51 by aashvi

Initial Code

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

Initial URL

Initial Description

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

Initial Title

Magento : product sku and url

Initial Tags

path, magento

Initial Language

PHP

Choose a language for easy browsing: