Product should be hide from shopping list or home page once vendor deactivate

Hello Sir,

I am stuck on below point,Please help me.

Once Vendor/customer deactivated from system, the entire relevant product should be hide of relevant vendor will not be available(display) for shopping or online listing(homepage).


Waiting for your kindly reply.


Regards,
Nirav

Hello-

Instead of sending private messages, you should always ask your questions by posting a new topic on the forum so that other people have the benefit of reading them because maybe somebody else has a better idea how to solve your problem. Also, it is better because the person giving you help will receive Karma points.

Also, please do not post your same topic in more than one category of the forum..and give us a little time to answer..patience.

There is no way to automatically hide(un-publish) all products associated with a vendor that has been disabled, but you could use a simple SQL query to update those products. You'd need to access your database via SSMS (SQL Server Management Studio) and create and execute a new query, like this:

update product set published=False where vendorid=123

You'll just need to change "123" to be the vendor id you are deactivating/disabling.

By only setting published to False on that vendor's products, you can still re-activate the vendor at a later date and then run the query again to easily activate all their products at the same time:

update product set published=True where vendorid=123


Steve

embryo wrote:
Steve is absolutely right!!!!!!

Please stop duplicating forum topics (all of them are deleted). This is the last warning!