CODEWITHSUNDEEP
prestashop-1.6
Chen Hanhan
Chen Hanhan

Reputation: 1729

increase quantity to 5 to all products that are out of stock in Prestashop 1.6

I have many products in my store that have quantity 0. I want to change it to 5. Can it be done from the database with some sql statement?

Upvotes: 0

Views: 123

Answers (1)

Chen Hanhan
Chen Hanhan

Reputation: 1729

After several hours of research, I have found the solution. Run the following sql statement in phpmyadmin: 

  UPDATE ps_stock_available SET quantity=5 WHERE quantity=0

But remember to clear the cache in preferences> performance

Upvotes: 1

Related Questions