products get disabled without any human action.

[bostamaster]

Hi every one;

 

Mesdames, Messieurs bonjour.

 

I got 105 products in my shop. some products get  disabled without any human intervention. When I enable them to appear in the shop they get disabled after a while or enable some and others get disabled.
 

Thanks

[vekia]

hello

 

maybe you use some external module to manage product availability automatically?

or maybe some software like store manager? or other integration software?

it's worth to check it

[bostamaster]

hello

 

maybe you use some external module to manage product availability automatically?

or maybe some software like store manager? or other integration software?

it's worth to check it

No i am not using any external software. I did an upgrade to 1.5.6.1 and the problem is still here

[bostamaster]

hello

 

maybe you use some external module to manage product availability automatically?

or maybe some software like store manager? or other integration software?

it's worth to check it

hello

I remember now that I did a mysql trigger to disable out of stock products automatically. I actually learned it from you Vekia.

the statement is: UPDATE  ps_product_shop SET active=0 WHERE id_product IN (SELECT id_product FROM  ps_stock_available WHERE quantity=0)

but it always disable the same products even if they have quantity.

[vekia]

hello

 

maybe you use multistore feature?

[bostamaster]

hello

 

maybe you use multistore feature?

No it is disabled. I deleted the trigger and solved the problem. The trigger was indeed the cause.  Unfortunately, I would have liked to make the trigger work correctly..

[PrestaHeroes USA]

No it is disabled. I deleted the trigger and solved the problem. The trigger was indeed the cause.  Unfortunately, I would have liked to make the trigger work correctly..

 

are you using advanced stock management and/or warehouses?

[bostamaster]

are you using advanced stock management and/or warehouses?

No.