Update Product Quantity With External Tool

[rubenvincenten]

So we are going to upgrade to 1.5 soon from 1.3.5.

 

Previously we used an external tool to update the stock for our shop. We did this with a simple query over an ajax request. (Offcourse the code below is stripped of any weird propiarity framework code we internally use)

mysql_connect('localhost','****','****');
mysql_select_db('*****');
$q = (int) $_POST['q'];
$id = (int) $_POST['id'];
if(!$id) die;
mysql_query("update product set quantity = $q where id_product = $id");
die('');

 

Now with the multistore environment, I'm afraid this won't work anymore as I think we need to set the quantity per shop or group.

 

We only have one "warehouse" and we want multiple shops to use the same quantity.

We do not use any product attributes and/or combinations.

 

Please enlighten me how I can do this. My boss doesn't want to use the stock manager that is included within prestashop as we have used an external tool since like forever.

 

Can I just do a simple query like this:

 

mysql_connect('localhost','****','****');
mysql_select_db('*****');
$q = (int) $_POST['q'];
$id = (int) $_POST['id'];
if(!$id) die;
mysql_query("update product set quantity = $q where id_product = $id");
mysql_query("update stock_available set quantity = $q where id_product = $id");
die('');

Or do I need to do additional work?

Edited February 21, 2013 by rubenvincenten (see edit history)

[vekia]

So we are going to upgrade to 1.5 soon from 1.3.5.

 

Previously we used an external tool to update the stock for our shop. We did this with a simple query over an ajax request. (Offcourse the code below is stripped of any weird propiarity framework code we internally use)

mysql_connect('localhost','****','****');
mysql_select_db('*****');
$q = (int) $_POST['q'];
$id = (int) $_POST['id'];
if(!$id) die;
mysql_query("update product set quantity = $q where id_product = $id");
die('');

 

Now with the multistore environment, I'm afraid this won't work anymore as I think we need to set the quantity per shop or group.

 

We only have one "warehouse" and we want multiple shops to use the same quantity.

We do not use any product attributes and/or combinations.

 

Please enlighten me how I can do this. My boss doesn't want to use the stock manager that is included within prestashop as we have used an external tool since like forever.

 

Can I just do a simple query like this:

 

mysql_connect('localhost','****','****');
mysql_select_db('*****');
$q = (int) $_POST['q'];
$id = (int) $_POST['id'];
if(!$id) die;
mysql_query("update product set quantity = $q where id_product = $id");
mysql_query("update stock_available set quantity = $q where id_product = $id");
die('');

Or do I need to do additional work?

 

it isnt great solution, the best way is to use prestashop classes. But if you still want to use this code u have to add additional where instance with ps_shop id for which you want change quantity value of product