Reset all stocks to 0 with advanced stock management

[lanouettea]

Hello,

 

My installation of Prestashop has advanced stock management enabled for every product on the website.

 

Simply put, is there a way to reset all the stock quantities to 0 on the website (for every products /warehouses), preferably without losing all the orders history?

 

Any help / clues will be greatly appreciated,

[vekia]

before i will create a SQL query for you, i need confirmation:

 

you want to change quantity field to 0 for each product in your store?

[troyrob]

I would very much like that SQL query. I would like to reset all quantities in store to zero

[vekia]

UPDATE `ps_stock_available` SET `quantity`=0

 

[BWarner]

Hey. Apologize for the thread necro, but this looks exactly like what I need (had some issues with some stock orders and want to start with a fresh slate). Buuut SQL Manager doesn't allow the UPDATE statement, so...

 

A )  is there another way to go about this same task using tools supported by SQL Manager?

or

B )  is there another way to get in and run this query? (database noob here)

PS. if possible I'd like to avoid any task needing directory/root access, as my hosting and installation is managed for me and I'd like to avoid involving more people - but if this is the easiest way to do it that's fine.

Edited July 28, 2014 by BWarner (see edit history)

[vekia]

if you have got an access to software like PHPmyAdmin you can do everything there.

almost each hosting packets today allows to use phpMyAdmin so i bet that you have got an access to this software.

[BWarner]

Cool, I'll send the request along to my guy. Last Q before I disappear: would this be a more thorough way to clear things out?

 

 

 

UPDATE `ps_stock_available` SET `quantity`=0
UPDATE `ps_stock` SET `physical_quantity`=0
UPDATE `ps_stock` SET `usable_quantity`=0

[BWarner]

Bump... I'd rather not break things with an irresponsible database query.