Query to list amount of stock (using advanced stock management)

[asmar]

Hi all,

 

I'm trying to figure out how to export (in any format, ideally something that I can print it afterwards like a csv) just the name of all products with relevant quantity.

I'm using the advanced stock management and many products have attributes like color, size etc.

 

If anyone has the query via sql manager it will be really appreciated if he/she can share it.

 

Kind regards

[Anton_bcn]

I dont think any have one who read this =)

 

But you can enable profiling and see what sql query was used for this and build you own query.

 

enable profiling is in config/defines.inc.php

 

like this define('_PS_DEBUG_PROFILING_', false);