Prestashop: Error Stock in New Products

[sebaborda04]

I am loading the stock as the images show.
I attach the images step by step.
1-update stock in 4 new products
2-click on the "Apply new Quantity" button
3-The stock was updated
4-Re-enter Stock Management
5-There is only one product with stock!

Thanks, and help me, please.

Additionnal information
PrestaShop version: 1.7.2.4
PHP version: Versión del software del servidor: Apache
Versión PHP: 7.1.22
Límite de memoria: 512M
Tiempo máx. de ejecución: 30
Tamaño máx. para la subida de archivos: 128M

[khouloudbelguith]

Hi @sebaborda04,

Thanks for your report.
I did not manage to reproduce the issue with PS1.7..6.0beta1.
We need to retrieve the PHP error log and the debug mode report in order to find out what's wrong.
Don't you know how to get this information? Please read the following article:
http://build.prestashop.com/howtos/misc/how-to-create-bug-report/

Thanks!

[sebaborda04]

Do you mean this data?

[khouloudbelguith]

@sebaborda04, when debugging mode enabled in your case => there is no exception.
You can use DevTools, so:

1. enable debug mode
2. go to the stocks page
3. open up developer tools
4. go to Network tab
5. Click on the "Apply new Quantity" button
6. wait for an error, you should see red request information in Network tab
7. click on it, you should see the error message in "Response" or "Preview" tab

Thanks to check & feedback.

[sebaborda04]

Error.

[khouloudbelguith]

@sebaborda04, you have some duplicated entry in the table ps_stock_avalible for the product which has id_product = 34.
Did you edit your database manually?
Thanks!

[sebaborda04]

I'm going to check it and I'll tell you ...
Thanks

[khouloudbelguith]

@sebaborda04, thanks!
Waiting for your feedback

[sebaborda04]

I do not have any product_id = 34 in the table ps_stock_avalible. The last number is the product_id = 31 and has id_stock_available = 0

[khouloudbelguith]

@sebaborda04, this error is displayed in your case

Thanks!

[sebaborda04]

[sebaborda04]

when I want to modify the product_id 34, it shows this error.

[khouloudbelguith]

@sebaborda04, could you please run the command SQL in your Database & feedback.

Select * from ps_stock_available where id_product = 34;

Thanks!

[sebaborda04]

now I see it

[khouloudbelguith]

@sebaborda04, the id_stock_available for this product which has id_product = 34 is incorrect.
id_stock_available = 0 where id_product = 34 => incorrect => you need to edit it.
Thanks!

[sebaborda04]

Thank you very much for the help.
What happens if that table is empty? I do not know why he kept that field at 0.

[khouloudbelguith]

@sebaborda04, in my case, it is OK.
I tried with steps that you provided but I did not manage to reproduce the issue.
Thanks!

[sebaborda04]

If I empty that table, I only lose the stock or can I lose something else?

[khouloudbelguith]

@sebaborda04, if you empty this table, you will lose the quantity of your products.
Make sure to have a backup of your database before deleting anything from the database.
Thanks!

[sebaborda04]

Thank you, you are very kind.

[khouloudbelguith]

@sebaborda04, you are welcome!
Can I close the issue?
Thanks!

[sebaborda04]

yes, Thanks

[khouloudbelguith]

@sebaborda04, Thanks!

Feel free to open a new one when needed.
THanks!