Advanced Search

Return to Snippet

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