Simple product quantity update script needed

[KariL]

I need a simple product quantity update script that doesn't need to upload csv or any other silly maneuvers. Here is an example:

 

 

I'm using similar in my current non-presta store and it works. I did try to modify it but it's not working.

mysql_query ("UPDATE $ps_product SET quantity='$s[1]', WHERE reference='$s[0]'") or die (mysql_error ());

Obviously this is a simple job for someone who is familiar with mysql and php commands.

[PeterDesouza]

Hi Karil,

 

PM sent.

check please.

 

 

Kind Regards

Peter

[CartExpert.net]

HI Karil.

 

PM sent.

 

Regards.
Robin.
The CartExpert Team.

[chrisranjana.com]

I need a simple product quantity update script that doesn't need to upload csv or any other silly maneuvers. Here is an example:

 

example-update-qty.jpg

 

I'm using similar in my current non-presta store and it works. I did try to modify it but it's not working.

mysql_query ("UPDATE $ps_product SET quantity='$s[1]', WHERE reference='$s[0]'") or die (mysql_error ());

Obviously this is a simple job for someone who is familiar with mysql and php commands.

Ok so how many products do you want to update ? and would each product have a different or same quantity ?