MetaTag Description - Auto Insert Price

Code: Select all

<?php 
################
# Written By:  #
# Lawrence Shea#
# for OpenCart #
#AddPriceToMeta#
################


include 'config.php';

# VARIABLES #

$tagline = 'Get it now for';
$currency = '$';

# VARIABLES #

    	$connect = mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWORD);
		mysql_select_db(DB_DATABASE,$connect);

        $data = mysql_query("SELECT * FROM `".DB_PREFIX."product` WHERE 1") 
		or die(mysql_error()); 

		while($row = mysql_fetch_assoc($data)) { ?>

			<?php $price = $row["price"]; $price = explode('.',$price); $pid = $row["product_id"]; 

			echo '===GOT NEW PRODUCT===<br>Product ID ->'.$pid.'<br><br>';

			echo 'Got Price of '.$price[0].' For Product Id '.$pid.'<br><br>';



			$data1 = mysql_query("SELECT * FROM `".DB_PREFIX."product_description` WHERE `product_id`=$pid") 
		or die(mysql_error()); 

		while($row2 = mysql_fetch_assoc($data1)) {

			 $meta = $row2["meta_description"];

			 echo 'Got Meta Description '.$meta.'For Product Id '.$pid.'<br><br>';

			 $metaprice = $meta.' '.$tagline.' '.$currency.$price[0];

			 mysql_query("UPDATE `".DB_PREFIX."product_description` SET `meta_description`='$metaprice' WHERE `product_id`=$pid") or die(mysql_error());

			 echo 'Changed Meta Description '.$metaprice.'<br><br>';


		}

		}

?>

Code: Select all

update `product_description` pd inner join `product` p on pd.product_id = p.`product_id` set pd.`meta_description` = p.`price`;

Code: Select all

update `product_description` pd inner join `product` p on pd.product_id = p.`product_id` set pd.`meta_description` = concat("get ", pd.`name`, " for only $", format(p.`price`,2));

Code: Select all

update `product_description` pd inner join `product` p on pd.product_id = p.`product_id` set pd.`meta_description` = concat(pd.`meta_description`, "get ", pd.`name`, " for only $", format(p.`price`,2));

Code: Select all

$this->document->setDescription($product_info['meta_description']);

Code: Select all

$this->document->setDescription($product_info['meta_description'] . 'Get it for only ' . $this->currency->format($this->tax->calculate($product_info['price'], $product_info['tax_class_id'], $this->config->get('config_tax'))));

Code: Select all

$this->document->setDescription($product_info['meta_description'] . 'Get it for only ' . $this->currency->format($product_info['price']));

Code: Select all

<meta name="description" content="Meta Description - Get it for £50" />