Advanced Search

Magento : product sku and url

/ Published in: PHP
Save to your folder(s)
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 
  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


Comments

You need to login to view comments.