Jump to content

Stock quantity does not update

djaenicke
 Share

Recommended Posts

djaenicke Newbie

djaenicke

Posted
Posted

Hi,

When I try to update the stock quantity it says update successful but reverts back to the setting in the quantity box. I have the option on all my products set to 'manually update stock quantities' but whenever I try to it says update successful and does not update them instead just reverting back to the number in the box before I tried to update the stock. I know I can update stock from phpmyadmin in the database but I would prefer not to. Any way around this?

 

It also updates the stock in FO but BO still has the incorrect number. My website is www.joovuu.com

 

Any help greatly appreciated.

 

Cheers,

 

Dan

Link to comment
Share on other sites
mfedorets Newbie

mfedorets

Posted
Posted

What file does this function of updating stock? Maybe I can re-upload it. It's incredibly annoying having to change stock quantity in phpmyadmin.

 

Please let me know what are the settings of stock management in Preferences > Products > Products stock, or you can simply make screenshots of these pages. Stock behavior is complicated and depends on combinations of these settings.

  • Enable stock management (Yes/No?)
  • Enable advanced-stock management (Yes/No?)

And quantity preferences on the Backend Product page > Quantity tab (what fields are switched on and what are off):

  • I want to use the advanced stock management system for this product.
  • Available quantities for current product and its combinations are based on warehouse stock
  • I want to specify available quantities manually.

Link to comment
Share on other sites
  • 2 weeks later...
armi0024 Newbie

armi0024

Posted
Posted

I had this same problem (I believe) where I would change the number, save and stay, and then poof, it would revert back.

 

I clicked on the " I want to specify available quantities manually" button, even though it was already highlighted and now it works.

  • Like 5
Link to comment
Share on other sites
  • 1 year later...
  • 4 weeks later...
VertNature Newbie

VertNature

Posted
Posted

I confirm the bug and its solution for me as well in 1.6.0.9 version: 

This happened after trying the advanced stock management, which created funny values per articles and curiously disabling the transporter option in the FO (...?). So I reverted to simple stock management and then got stuck with impossible quantities adjustments in manual mode.

Thanks to this forum and shared experience, "I clicked on the " I want to specify available quantities manually" button, even though it was already highlighted" and now it works again in simple stock management.

I'll have to try the Advanced mode later again...

Link to comment
Share on other sites
  • 3 weeks later...
Hessellund Newbie

Hessellund

Posted
Posted

Unfortunately this solution did not work for me.

 

I am upgrading from 1.5.6.2 to 1.6.0.9, and for some (not all) products the stock values are "0" and cannot be changed. On the BO product overview page the stock is not zero!!

 

Any help or pointers appreciated.

 

Thx

Link to comment
Share on other sites
  • 2 months later...
  • 2 weeks later...
jorgecrce Newbie

jorgecrce

Posted
Posted

Hi,

 

Thanks a lot. This solution looks to work for me. But now I have another problem, I have more than 1000 products in my store, and update each one manually is not an option, so, how I could automate this task? Maybe it's to change any value in the products database?

Link to comment
Share on other sites
jorgecrce Newbie

jorgecrce

Posted
Posted

Ok, we got it.

 

I have exported all our id products to a CSV, and then add a second column with all "0". Then import it and select in the second column use advance stock managemente. Then all our producs work allright with traditional stock system.

  • Like 1
Link to comment
Share on other sites
  • 4 months later...
jandresbc Newbie

jandresbc

Posted
Posted (edited)

Ok, we got it.

 

I have exported all our id products to a CSV, and then add a second column with all "0". Then import it and select in the second column use advance stock managemente. Then all our producs work allright with traditional stock system.

 

Hello,

 

This solution works for me, thanks for sharing jorgecrce.

Edited by jandresbc (see edit history)
Link to comment
Share on other sites
  • 7 months later...
Logical IT Newbie

Logical IT

Posted
Posted

I had this same problem (I believe) where I would change the number, save and stay, and then poof, it would revert back.

 

I clicked on the " I want to specify available quantities manually" button, even though it was already highlighted and now it works.

 

Thank you this worked for me. I experienced this problem with PrestaShop version 1.6.1.4. Problem started occurring after upgrade from 1.6.0.9 to 1.6.1.4 . Also the problem may have started occurring after turning off advance stock management.

Link to comment
Share on other sites
  • 3 months later...
BoKr Newbie

BoKr

Posted
Posted (edited)

Oh no,
 
I just noticed this caveat an hour ago and I know that we are in big trouble now.
I turned advanced stock management off in February after running it for three years.
 
I was able via CSV ex- & imports to recover the quantity of stock from asm to manual management based on stock. As users described above all looked! fine.
But more and more often I stumbled over mismatch of stock in our warehouse and what Prestashop told us!!! :angry: :angry: :angry:
 
My question is if it is possible to really turn off asm and reactivate manual stock based on stock...(sells and restock) via the DB?
 
I have these tables here that do not change when buying certain articles:

 

https://i.imgur.com/E3yIF1m.png

 

 

WScJdo1.png

 

So I went through this SQL command to update columns after I did an backup of the db.

UPDATE `ps_product` SET `advanced_stock_management`=0;
UPDATE `ps_product_shop` SET `advanced_stock_management`=0;
UPDATE `ps_stock_available` SET `depends_on_stock`=0

This made things work again. ASM is definetly set to off and manual stock management runs fine.

Edited by Boris_Shoppist (see edit history)
Link to comment
Share on other sites
  • 9 months later...
intandem Newbie

intandem

Posted
Posted

I had this same problem (I believe) where I would change the number, save and stay, and then poof, it would revert back.

 

I clicked on the " I want to specify available quantities manually" button, even though it was already highlighted and now it works.

 

3 years later and on version 1.6.1.7 and we just started to experience the same issue - not for any new products we're setting up but for anything already in the system. I used your solution (which I would have never thought of on my own because obviously the radio button was already ticked) and it works!! Thanks so much!

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...