'https://www.123realhealth.com',
'username' => 'rohit_api',
'api_key' => 'c017e80c5c7542f38b31a3c649e92c9b7f66d94d'
));
/* $count=Bigcommerce::getProductsCount();
echo $count;
$loop=ceil($count/250);
for($i=1;$i<=$loop;$i++)
{
$filter = array("page" => $i, "limit" => 250);
$brandnameObj=Bigcommerce::getProducts($filter);
foreach($brandnameObj as $value)
{
$id=$value->id;
echo $name=$value->name;
}
} */
$query=mysql_query("select Prod_id.P_id,avb_pdt_list.name,avb_pdt_list.price,avb_pdt_list.availability FROM avb_pdt_list INNER JOIN Prod_id ON avb_pdt_list.name= Prod_id.P_name");
echo mysql_error();
echo mysql_num_rows($query);
$i=1;
while($row=mysql_fetch_assoc($query))
{
echo $id=$row['P_id'];
$name=$row['name'];
$Stock=$row['availability'];
$retail=$row['price'];
$fields = array(
"name" =>$name,
"price" => $retail,
"availability"=>$Stock
);
//print_r($fields);
echo "
";
try {
$req=Bigcommerce::getRequestsRemaining();
echo 'request left->'.$req;
echo "
";
if($req>100)
{
$updateObj=Bigcommerce::updateProduct($id, $fields);
}
else
{
sleep(60);
}
echo "loop".$i;
echo "
";
$i++;
}
catch(Bigcommerce\Api\Error $error) {
echo 'unsuccessfull';
echo $error->getCode();
echo $error->getMessage();
}
}
echo "success";
?>