0

I need to extract configurable products only from magento. I need a query to perform it or model to work with configurable products.

Akhmed
  • 1,141
  • 4
  • 21
  • 49
  • what data do you actually need? – FlorinelChis Oct 24 '12 at 14:36
  • I need to select all configurable products for pdf product list. I need it next way: product_name, product_sku, product_brand and also tier price params in next way (qty=>price) let me know if you didn't get it – Akhmed Oct 24 '12 at 14:41

2 Answers2

0

Try 

 $_productCollection = $this ->getLoadedProductCollection()
                        ->addAttributeToFilter('type_id','configurable');

 //print_r($_productCollection);

 foreach($_productCollection as $product){
     echo $product->getSku();
     .....

 }

Then pass this info into your function to create the pdf like this How to create a pdf in magento?

See more @ Magento - load only configurable products

Community
  • 1
  • 1
MagePal Extensions
  • 17,646
  • 2
  • 47
  • 62
0

The menu System / Import-Export of the Backoffice is designed for this purpose.

particularly the Dataflow - Profiles entry where you have a "Export all product" profile customisable/filterable with a assitant.

You can use the CSV/XML/whatever generated to generate a PDF (your call)

Jscti
  • 14,096
  • 4
  • 62
  • 87