Alex Anodin

Product status in SugarCRM

Discussion created by Alex Anodin on Feb 3, 2017
Latest reply on Feb 3, 2017 by sidhu sidhu

Hi everyone,

I have a question.

The SugarCRM version 7.6 has products module. A product has Status.
Our Client has got about 4500 products with the Shipped status in your Sugar GUI.


When I ask him to run the following SQL Query:
SELECT Count(*) FROM products WHERE status = "Shipped";

He says the result is 188.


Can you please tell me which field contains a product status in the SugarCRM Database ?
How can I get all Shipped products with an SQL Query?


Thanks a ton,