如何通过API使用CSV文件更新Magento中的新atribute


How to update a new atribute in Magento with CSV file thorugh API

我有一个来自Magneto产品的大数字,我必须将EAN编号添加到所有产品中。如何通过API从CSV文件更新新属性。我想通过API SOAP从ssh服务器更新EAN编号。

这对您来说不是一个完整的解决方案,但它绝对是您的起点。好运

$productData = array(
    'additional_attributes' => array(
        'single_data' => array(
            array(
                'key' => 'ean',
                'value' => 'value',
            ),
        ),
    ),
);
$productId = '1000000';
$soap = new SoapConnection('1','2','3');
echo $soap->_catalogProductUpdate($productId,$productData); 

class SoapConnection
{
    protected $soap_client;
    protected $session_id;
    function __construct($soap_host, $api_user, $api_pass)
    {
        try{
            echo "Connecting to $soap_host'n";
            $this->soap_client = new SoapClient( $soap_host, array('trace' =>true,
                'connection_timeout' => 30,
                'cache_wsdl' => WSDL_CACHE_NONE,
                'keep_alive' => false
                ));
            $this->session_id = $this->soap_client->login( $api_user, $api_pass);
            echo "Connected with session id ".$this->session_id."'n";
            return true;
        } catch (SoapFault $e) {
            echo "Soap Exception connecting to $soap_host: ".  $e->getMessage(). "'n";
            var_dump($this->soap_client->__getLastRequest()); var_dump($this->soap_client->__getLastResponse());
            return false;
        }
    }
    function _catalogProductUpdate($sku, $args)
    {
        try
        {
            return $this->soap_client->catalogProductUpdate($this->session_id, $sku, $args);
        } catch (SoapFault $e) {
            echo "Soap Exception _catalogProductUpdate: ".  $e->getMessage(). "'n";
            return false;
        }
    }
}

编辑:

以下是如何读取csv:

$file = fopen("my file path .csv","r");
while($row = fgetcsv($file))
{
    $row[0];//column1
    $row[1];//column2 etc etc etc
}
fclose($file);