SQL Command

[justmeagain]

Hi

Does anyone know the SQL Command to extract

 

Product Id

Product Name

and then Stock Location

 

I can't seem to get it to work properly.

 

Probably doing something really simple wrong......

 

Thanks in advance

[Muzammil Mac]

Did you mean a SQL query to fetch product ID, name, and Stock location?

[justmeagain]

Sorry - yes....I want to use it for a inventory check

Probably should include Quantity as well

 

Thanks

[ps8modules]

Hi.

It does not work for combinations !

ps_ => table prefix

id_lang = 1 => language id

SELECT a.id_product, a.name, b.quantity, b.location FROM `ps_product_lang` a 
LEFT JOIN `ps_stock_available` b ON (a.id_product = b.id_product)
WHERE a.id_lang = 1 AND b.id_product_attribute = 0;

 

Edited February 12 by ps8moduly.cz (see edit history)

[justmeagain]

Thank you, works a treat....I was forgetting to select the lang.....knew it was something simple but just couldn't see it.....