One option then is to consume it from .Net, which you can do inside VFP using a variety of methods, the easiest probably being the eTecnologia (www.etecnologia.net) CLR Extender.

Hank

>>Can you not use the product API? http://www.magentocommerce.com/wiki/doc/webservices-api/api#product_api
>>
>Hi Hank...
>
>Finally I found that docs wasn't updated..
>
>specialty on:
>
>

$proxy 		= new SoapClient("http://www.domain.com/magento/index.php/api/soap/index/wsdl/1");

>
>And far from it.. I found a limitation to consume that webservice with VFP.. VFP doesn't setup arrays using names as indexes
>
>tks
>
>>
>>>>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