product is no longer available

[tarek.fellah]

I use a webservice to load product parameters from my supplier, and let customer choose between them, when the customer choose a product this one is added to the database,

by this code

$e=mysql_query(" INSERT INTO ps_product(`id_supplier` ,`id_manufacturer`, `id_category_default`, `id_shop_default`, `id_tax_rules_group`, `on_sale` ,`online_only` ,`ean13` ,`upc`, `ecotax`, `quantity`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight` ,`out_of_stock` ,`quantity_discount`, `customizable`, `uploadable_files`, `text_fields`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order` ,`available_date`, `condition`, `show_price`, `indexed` ,`visibility` ,`cache_is_pack`, `cache_has_attachments`, `is_virtual`, `cache_default_attribute`, `date_add`, `date_upd`, `advanced_stock_management`)
VALUES (
'', '', '2', '1', '1', '', '0', '0', '', '', '100', '1', '".$price."', '".$price."', '', '', '', '".$productarticle->art."', '".$productarticle->art."', '', '', '', '', '', '2', '', '', '', '', '1', '', '', '1', '', 'new', '1', '1', '1', '', '', '0', '', '2012-04-12 13:23:11', '', ''
)") ;

this is my website

My problem is when i tried to add a product to the cart, the message "product is no longer available" appear. I checked the product quantity (100) when i add a new product.

My prestashop version is 1.5.3.1

And thank you.

Edited March 16, 2013 by tarek.fellah (see edit history)

[Totti]

I also would like to use the web service to add and modify products but do not know how.

[tarek.fellah]

i use the webservice to load product parameters ans i use a query to add products to the database but i don't know why prestashop show me that the product is no longer available and its quantity is 100