Forums

How can I disable multiple Products in eCommerce

Permalink
Hi,
I need to disable hundreds of products and doing them one by one via editing the properties is very time consuming.
Is there a quicker way to do it?
I want to disable all my products and enable only a few as the business has been scaled back and stock has been liquidated.

Thanks in advance

Peter
patchworkfabricator
 
mesuva replied on at Permalink Reply
mesuva
Although I wouldn't normally suggest directly editing a concrete5 database, doing so in this case would probably be the quickest way to achieve this (and since the data stored isn't complex it's pretty safe).

Back up your database, then in the CoreCommerceProducts table modify the prStatus column for each product, with a value of 0 being disabled.

You could run an SQL statement like:
UPDATE CoreCommerceProducts SET prStatus = 0;

to make all products disabled in one go, then you could just go back and enable the ones you need.

I'm not aware of something in concrete5's Dashboard to do this quickly.
cytringan replied on at Permalink Reply
cytringan
Simular thing I needed to do today... and found this addon! Totally awesome, worth every $

http://www.concrete5.org/marketplace/addons/core-commerce-csv-mass-...