Magento tables price list export table structure -


hi thought i'd ask in case has went through big magento database.

i'm trying export list of products in database.

name price sku url stock level

the usual.

i go through tables manually seeing if has list of essential tables sitting around. thanks!

here go:

select name, sku, url_path, qty stock_level catalog_product_flat_1 c1 inner join cataloginventory_stock_status c2 on c1.entity_id = c2.product_id ; 

do not forget adjust store_id in 'catalog_product_flat_1' make match store want...

edit: image path of base image should added in last column:

select name, sku, url_path, qty stock_level ,c3.value base_image catalog_product_flat_1 c1 inner join cataloginventory_stock_status c2 on c1.entity_id = c2.product_id left outer join catalog_product_entity_varchar c3 on c3.entity_id = c1.entity_id , c3.attribute_id = (select attribute_id eav_attribute attribute_code = 'image' , entity_type_id = 4 , store_id in (0,1)) ; 

do not forget adjust store_id in 'catalog_product_flat_1' , in in() condition (but leave 0) make match store want...


Comments

Popular posts from this blog

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

html - How to style widget with post count different than without post count -

url rewriting - How to redirect a http POST with urlrewritefilter -