Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Deactivate multiple products by manufacture or category


tim_ver

Recommended Posts

There are addons that allow you to hide/disable any category. I'm not aware of a similar addon for manufacturers.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

update products set products_status = 0 where manufacturers_id = x

 

Change x to the ID of the manufacturer.

 

update products set products_status = 0 where products_id in (select products_id from products_to_categories where categories_id = y)

 

Change y to the ID of the category.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...