Exporting Combination IDs

[Guest]

Hey guys,

 

So I am looking to export combination ID's using the SQL Manager.

 

All I need is 

 

Product Combination ID, Product Combination Title, Product Description, Image URL, Quantity, Combination Price.

 

I would REALLY REALLY appreciate anyone who could help me out. I was looking at nemo's tutorial but I really don't know the commands well enough to customize it.

 

If anyone could help me out I would be very grateful! 

 

Thanks in advance!

eggo

[BigfootSRL]

I was looking for the same SQL query

[vekia]

here it is:
 

SELECT pa.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
					a.`id_attribute`, pa.`unit_price_impact`
				FROM `ps_product_attribute` pa
				LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
				LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
				LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
				LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
				LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
				WHERE pa.`id_product` like '%'
				GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group`
				ORDER BY pa.`id_product_attribute`

[Gourzout]

Hi Vekia,

 

And thanks for this code.

But when I execute it, all the quantities are at 0...

 

Is there any procedure I don't do?

 

Thank you

Romain