Posted By

aashvi on 10/20/10


Tagged

path product magento sku


Versions (?)

Magento : product sku and url


 / Published in: PHP
 

Following sql statement collect product sku with store url

select catalogproductentity.sku,catalogproductentityvarchar.value from catalogproductentity,catalogproductentityvarchar where catalogproductentityvarchar.attributeid=87 and catalogproductentityvarchar.storeid=0 and catalogproductentityvarchar.entityid=catalogproductentity.entity_id

  1. select catalog_product_entity.sku,catalog_product_entity_varchar.value from catalog_product_entity,catalog_product_entity_varchar where
  2. 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

Report this snippet  

You need to login to post a comment.