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,

Link to comment
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)
Link to comment
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
Link to comment
Share on other sites

  • 1 month later...
×
×
  • Create New...