Can you not use the product API? http://www.magentocommerce.com/wiki/doc/webservices-api/api#product_api

Hank

>>a quick search shows that Magento has a full-featured web service API. http://www.magentocommerce.com/support/magento_core_api
>>
>>Rather than have to reverse engineer their database, I'd suggest you use their API.
>>
>
>Hank
>
>Seems cool.. but, I don't have any idea how to implement that PHP routine of a single product listing in VFP9
>
>

>$proxy = new SoapClient('http://magentohost/api/soap/?wsdl');
>$sessionId = $proxy->login('apiUser', 'apiKey');
> 
>$filters = array(
>    'sku' => array('like'=>'zol%')
>);
> 
>$products = $proxy->call($sessionId, 'product.list', array($filters));
> 
>var_dump($products);
>

>
>I know by the use of PHP... The following one show how to task create/view/update/delete on Product table... Could someone translate that for vfp9?
>
>

>$proxy = new SoapClient('http://magentohost/api/soap/?wsdl');
>$sessionId = $proxy->login('apiUser', 'apiKey');
> 
>$attributeSets = $proxy->call($sessionId, 'product_attribute_set.list');
>$set = current($attributeSets);
> 
> 
>$newProductData = array(
>    'name'              => 'name of product',
>     // websites - Array of website ids to which you want to assign a new product
>    'websites'          => array(1), // array(1,2,3,...)
>    'short_description' => 'short description',
>    'description'       => 'description',
>    'price'             => 12.05
>);
> 
>// Create new product
>$proxy->call($sessionId, 'product.create', array('simple', $set['set_id'], 'sku_of_product', $newProductData));
> 
>// Get info of created product
>var_dump($proxy->call($sessionId, 'product.info', 'sku_of_product'));
> 
>// Update product name on german store view
>$proxy->call($sessionId, 'product.update', array('sku_of_product', array('name'=>'new name of product'), 'german'));
> 
>// Get info for default values
>var_dump($proxy->call($sessionId, 'product.info', 'sku_of_product'));
>// Get info for german store view
> 
>var_dump($proxy->call($sessionId, 'product.info', array('sku_of_product', 'german')));
> 
>// Delete product
>$proxy->call($sessionId, 'product.delete', 'sku_of_product');
> 
>try {
>    // Ensure that product deleted
>    var_dump($proxy->call($sessionId, 'product.info', 'sku_of_product'));
>} catch (SoapFault $e) {
>    echo "Product already deleted";
>}
>

>
>tks
>
>>>I'm running under a task to integrate data exchange between our POS application and Magento e-commerce...
>>>
>>>http://www.magentocommerce.com/
>>>
>>>Does anyone here had some similar experience.. That mind to share here some SQLs code to import/export products, clients and orders programmactically via ODBC