Hey guys I have written a script to try and add tier pricing to some products but it doesn't seem to be working, I am getting no errors at all screen stays at white screen, but going to backend and checking it hasn't added tier pricing to the products.
My script is:
<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
ini_set("soap.wsdl_cache_enabled", "0");
$proxy = new SoapClient('http://magento/index.php/api/soap/?wsdl');
$sessionId = $proxy->login('apiuser', 'apikey');
$row = 1;
$errors = 0;
$handle = fopen('apiTierAttempt.csv', 'r');
while (($data = fgetcsv($handle,',')) !== false) {
if ($row != 1) {
$tierPrices = '';
$sku = $data[0];
$tierPrices[] = array(
'website'=> $data[1],
'customer_group'=> $data[2],
'qty'=> $data[3],
'price'=> $data[4]
);
try {
$proxy->call($sessionId, 'product_tier_price.update', array($sku, $tierPrices));
var_dump($proxy);
} catch (Exception $e) {
$errors = 'Error for SKU ' . $sku . ': ' . $e->getMessage() . " \n";
echo($errors);
}
}
$row++;
}
Solved! Go to Solution.
The script works. It was a csv file issue. It didn't like the file, causing it to read it incorrectly. Thus, I just went back into excel on my mac and re-saved it in windows format.
i think you should check out this extension: Tier Prices Extension