Jump to content

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
  • 4 weeks later...
  • 9 months later...

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
  • 1 month later...
×
×
  • Create New...

Important Information

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