Jump to content
lanouettea

Reset all stocks to 0 with advanced stock management

Recommended Posts

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,

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
UPDATE `ps_stock_available` SET `quantity`=0

 

Share this post


Link to post
Share on other sites

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 by BWarner (see edit history)

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More