>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