<tr> <td><?php echo '<a href="' . $item_url . '" target="_blank">' . $ebay_id . '</a>'; ?> </td> <td><?php echo '<a href="' . $row_product['VendorUrl'] . '" target="_blank">' . $row_product['SKU'] . '</a>'; ?> </td> <!-- <?php if ($poswm > 0) { ?> <td><?php $tasin = explode('-', $asin); $linkitem = scrap_walmartlink($tasin[0]); echo '<a href=http://www.walmart.com/' . $linkitem . ' target="_blank">' . $tasin[0] . '</a>'; ?> </td> <?php } elseif ($posos > 0) { ?> <td><?php echo '<a href=http://www.overstock.com/search/' . $asin . ' target="_blank">' . $asin . '</a>'; ?> </td> <?php } elseif ($posamaz > 0) { ?> <td><?php
function ebay_revise_item($user_id, $item_id, $revise_price, $amazon_price, $revise_qty, $max_qty, $asin) { $sql_config = "SELECT \n \t\t\t\teu.dev_name,\n \t\t\t\teu.app_name,\n \t\t\t\teu.cert_name,\n \t\t\t\teu.token,\n \t\t\t\tec.paypal_address,\n \t\t\t\tec.return_accept_option,\n \t\t\t\tec.refund_option,\n \t\t\t\tec.return_days \n \t\tFROM \t\n \t\t\t\tebay_users eu,\n \t\t\t\tebay_config ec\n \t\tWHERE \n \t\t\t\teu.user_id = ec.user_id AND \n \t\t\t\teu.user_id = {$user_id}\t\t\t\t\n "; $rs_config = mysql_query($sql_config) or die(mysql_error()); if (mysql_num_rows($rs_config) != 1) { die("Database Error - Developer Side"); } $row_config = mysql_fetch_assoc($rs_config); $DEVNAME = trim($row_config['dev_name']); $APPNAME = trim($row_config['app_name']); $CERTNAME = trim($row_config['cert_name']); // $token = "AgAAAA**AQAAAA**aAAAAA**rk05VA**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6AElYCmCJiFqQqdj6x9nY+seQ**y4ICAA**AAMAAA**I+dnHHqjbr1rjZlo8wEbyge8d1Rj73Vd3La+W4FzvDVDYl4cLgvS2pw9bttZX9kkkFTpeRtt+UDuYxU9N6O3FpzN7OklgZaQKMud9sjKb6O3WQYICnjw2KdMlEaeBKrTTmyM31hEcOiTvJB5u/0U0zFLWXvk1Qk6YAPhqTGejzYiwQtqYGtmd0rGtoS+b+46XxRov3saL5cRdOfSSTcHlWY9mtIqWerFpM4ZP0Qbj6xM4azxUa0m0BIZKf70+EbSBoFOaVo4X2k5ysHvSII+1WTbVBNvqgp9PNvgfyoMs+VZZ77Q+Qlfl+kk1pmGJqgqUY854qv0gABzSV5OEbgHIS2v0K2OhcTbo3EgvDX1SbPr/MKGFmC2aeqrVbn/9x5XZKnwPdtqoDwYJKe3sU/tzonToUKfyqldIF1GbJlvh5lgd2dPv+WS29g0wNNKGtPDyrLmQ0cktF0Ymnx5zvT7xffOtE9HweCCCILJeqFgyS7XeBgSY4d4fXcxXtaMaK9c2HFjwnF4v2WKoJ9KYYT9svSsf3ksk4fGzEv6XVPonZQxvyZESJHxQ7SbR/KE0rAB1WZY8N8x0hMu999SEJEse4lYRP7RjVxx82AVZp6MUVExfHSMQcQQL8O5O6wgjkErAHpfd7CzOmaSeyy4HNzWq3liP0WGQCfVXFDGl2YunJL9stIKaA/SrMeOvx5CSAWYUwEnx4OUwKlPpeZot+x98I+6Q1i2K1Paf6jMM6X5j4HGIrtMHgCMqWfM8IkPU+5Q"; $token = trim($row_config['token']); $SiteId = 0; $active_user = 8; $eBayAPIURL = "https://api.ebay.com/ws/api.dll"; $COMPATIBILITYLEVEL = '837'; $paypal_email = trim($row_config['paypal_address']); $return_accept_option = trim($row_config['return_accept_option']); $refund_option = trim($row_config['refund_option']); $return_within_days = trim($row_config['return_days']); $sql = "SELECT * FROM user_products WHERE UserID={$active_user} and ItemID={$item_id}"; $rs = mysql_query($sql); $row = mysql_fetch_assoc($rs); $sku = $row['SKU']; $pattern = '/^AMZ/'; $posamaz = preg_match($pattern, $sku, $matches, PREG_OFFSET_CAPTURE); $pattern = '/^WM/'; $poswm = preg_match($pattern, $sku, $matches, PREG_OFFSET_CAPTURE); $pattern = '/^OS/'; $posos = preg_match($pattern, $sku, $matches, PREG_OFFSET_CAPTURE); $pattern = '/^AL/'; $posal = preg_match($pattern, $sku, $matches, PREG_OFFSET_CAPTURE); $pattern = '/^HN/'; $poshe = preg_match($pattern, $sku, $matches, PREG_OFFSET_CAPTURE); $pattern = '/^WF/'; $poswa = preg_match($pattern, $sku, $matches, PREG_OFFSET_CAPTURE); if ($posamaz > 0) { $url = "http://www.amazon.com/dp/" . $asin; } elseif ($poswm > 0) { $linkitem = scrap_walmartlink($asin); $url = "http://www.walmart.com/" . $linkitem; } elseif ($posos > 0) { $url = "http://www.overstock.com/search/" . $asin; } elseif ($posal > 0) { $url = "http://www.aliexpress.com/wholesale?SearchText=" . $asin; } elseif ($poshe > 0) { $url = "http://search.hayneedle.com/search/index.cfm?Ntt=" . $asin; } elseif ($poswa > 0) { $url1 = "http://www.wayfair.com/keyword.php?keyword=" . $asin; $data = getPage($url1); $html = str_get_html($data); foreach ($html->find('div[id=sbprodgrid] a') as $item) { $url1 = $item->href; break; } $url = $url1; } else { $url = "http://www.amazon.com/dp/" . $asin; } if ($row['Qty'] != $revise_qty && $revise_qty > 0 && $row['Price'] == $revise_price) { $date = date("d/m/Y h:i:s"); $message = "" . $date . " eBay Quantity changed from " . $row['Qty'] . " to " . $revise_qty . " for itemid=<a target='_blank' href=http://www.ebay.com/itm/" . $item_id . ">" . $item_id . "</a> because max_quantiy = " . $max_qty . "<br>"; $headers = 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; file_put_contents("log.php", $message, FILE_APPEND); //mail('*****@*****.**', 'Updating Quantity', $message,$headers); mail('*****@*****.**', 'Updating Ebay Quantity', $message, $headers); mail('*****@*****.**', 'Updating Ebay Quantity', $message, $headers); $post_data = '<?xml version="1.0" encoding="utf-8"?> <ReviseItemRequest xmlns="urn:ebay:apis:eBLBaseComponents"> <ErrorLanguage>en_US</ErrorLanguage> <Item> <ItemID>' . $item_id . '</ItemID> <Quantity>' . $revise_qty . '</Quantity> </Item> <RequesterCredentials> <eBayAuthToken>' . $token . '</eBayAuthToken> </RequesterCredentials> </ReviseItemRequest>'; } elseif ($row['Qty'] == $revise_qty && $revise_qty > 0 && $row['Price'] != $revise_price) { //echo $ebay_price $amzprice = $row['AmazonPrice']; $date = date("d/m/Y h:i:s"); if ($amzprice != $amazon_price) { $message = "" . $date . " eBay Price changed from \$" . $row['Price'] . " to \$" . $revise_price . " for itemid=<a target='_blank' href=http://www.ebay.com/itm/" . $item_id . ">" . $item_id . "</a> because Vendor price of <a target='_blank' href=" . $url . ">" . $asin . "</a> change from \$" . $amzprice . " to \$" . $amazon_price . "<br>"; } else { $message = "" . $date . " eBay Price changed from \$" . $row['Price'] . " to \$" . $revise_price . " for itemid=<a target='_blank' href=http://www.ebay.com/itm/" . $item_id . ">" . $item_id . "</a> for vendor product <a target='_blank' href=" . $url . ">" . $asin . "</a> priced \$" . $amazon_price . "<br>"; } $headers = 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; file_put_contents("log.php", $message, FILE_APPEND); mail('*****@*****.**', 'Updating Ebay Price', $message, $headers); mail('*****@*****.**', 'Updating Ebay Price', $message, $headers); $post_data = '<?xml version="1.0" encoding="utf-8"?> <ReviseItemRequest xmlns="urn:ebay:apis:eBLBaseComponents"> <ErrorLanguage>en_US</ErrorLanguage> <Item> <ItemID>' . $item_id . '</ItemID> <StartPrice>' . $revise_price . '</StartPrice> </Item> <RequesterCredentials> <eBayAuthToken>' . $token . '</eBayAuthToken> </RequesterCredentials> </ReviseItemRequest>'; } elseif ($row['Qty'] != $revise_qty && $revise_qty > 0 && $row['Price'] != $revise_price) { $date = date("d/m/Y h:i:s"); $amzprice = $row['AmazonPrice']; if ($amzprice != $amazon_price) { $message1 = "" . $date . " eBay Price changed from \$" . $row['Price'] . " to \$" . $revise_price . " for itemid=<a target='_blank' href=http://www.ebay.com/itm/" . $item_id . ">" . $item_id . "</a> because Vendor price of <a target='_blank' href=" . $url . ">" . $asin . "</a> change from \$" . $amzprice . " to \$" . $amazon_price . "<br>"; } else { $message1 = "" . $date . " eBay Price changed from \$" . $row['Price'] . " to \$" . $revise_price . " for itemid=<a target='_blank' href=http://www.ebay.com/itm/" . $item_id . ">" . $item_id . "</a> for vendor product <a target='_blank' href=" . $url . ">" . $asin . "</a> priced \$" . $amazon_price . "<br>"; } $message2 = "" . $date . " eBay Quantity changed from " . $row['Qty'] . " to " . $revise_qty . " for itemid=<a target='_blank' href=http://www.ebay.com/itm/" . $item_id . ">" . $item_id . "</a> because max_quantiy = " . ${$max_qty} . "<br>"; file_put_contents("log.php", $message1, FILE_APPEND); file_put_contents("log.php", $message2, FILE_APPEND); $headers = 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; mail('*****@*****.**', 'Updating Ebay Price', $message1, $headers); mail('*****@*****.**', 'Updating Ebay Quantity', $message2, $headers); //mail('*****@*****.**', 'Updating Ebay Price', $message1,$headers); //mail('*****@*****.**', 'Updating Ebay Quantity', $message2,$headers); mail('*****@*****.**', 'Updating Ebay Price', $message1, $headers); mail('*****@*****.**', 'Updating Ebay Quantity', $message2, $headers); $post_data = '<?xml version="1.0" encoding="utf-8"?> <ReviseItemRequest xmlns="urn:ebay:apis:eBLBaseComponents"> <ErrorLanguage>en_US</ErrorLanguage> <Item> <ItemID>' . $item_id . '</ItemID> <StartPrice>' . $revise_price . '</StartPrice> <Quantity>' . $revise_qty . '</Quantity> </Item> <RequesterCredentials> <eBayAuthToken>' . $token . '</eBayAuthToken> </RequesterCredentials> </ReviseItemRequest>'; } $call_name = "ReviseItem"; $ebayapiheader = array("X-EBAY-API-COMPATIBILITY-LEVEL: {$COMPATIBILITYLEVEL}", "X-EBAY-API-DEV-NAME: {$DEVNAME}", "X-EBAY-API-APP-NAME: {$APPNAME}", "X-EBAY-API-CERT-NAME: {$CERTNAME}", "X-EBAY-API-SITEID: {$SiteId}", "X-EBAY-API-CALL-NAME: " . $call_name); $ch = curl_init(); $res = curl_setopt($ch, CURLOPT_URL, $eBayAPIURL); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_HEADER, 0); // 0 = Don't give me the return header curl_setopt($ch, CURLOPT_HTTPHEADER, $ebayapiheader); // Set this for eBayAPI curl_setopt($ch, CURLOPT_POST, 1); // POST Method curl_setopt($ch, CURLOPT_POSTFIELDS, $post_data); //My XML Request curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $body = curl_exec($ch); //Send the request curl_close($ch); // Close the connection return $body; }