Mass update product to "Used" state

[AcidLava]

Hello,

On PS 8.1, I'm looking for a SQL request or any way to mass update all my product to the "Used" state.

Thanks for your feedback

[Renaud B]

Hello,

This shoudl do it:

UPDATE ps_product SET `condition` = "used"

 

[ventura]

It is always advisable before performing any operation on the database records to first perform a backup of the database or tables affected by the changes.
Also it is always advisable to use a filter in the queries that modify data, delete, update