Bir arkadaşım rica etmişti sitesi sitesi eski sürüm opencart. Facebook Catalog için eklenti bulamamış. Hızlıca basit bir şey yazdım belki işine yarayan olur.

Ana dizine facebookCatalog.php olarak attıktan sonra,
htaccess dosyanıza
RewriteRule ^facebookCatalog.xml$ facebookCatalog.php [L]
ekleyip. siteurl.com/facebookCatalog.xml olarak kullanabilirsiniz.

<?php
header('Content-type: text/xml');
header('Pragma: public');
header('Cache-control: private');
header('Expires: -1');

function xmlEscape($string) {
    return str_replace(array('&', '<', '>', '\'', '"'), array('&amp;', '&lt;', '&gt;', '&apos;', '&quot;'), $string);
}

$dbName = "";
$dbUser = "";
$dbPass = "";
$siteUrl ="https://websitename.com/";
$siteImageUrl = "https://website.com/image/";
$exchange = "TRY";
$siteTitle = "Lorem ipsum";
$siteDesc = "Lorem ipsum dollar sit amet.";


$mysqli = new mysqli("localhost",$dbUser,$dbPass,$dbName);
$mysqli -> set_charset("utf8");

// Check connection
if ($mysqli -> connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
  exit();
}

$sql = "SELECT * FROM oc_product inner join oc_product_description on oc_product_description.product_id = oc_product.product_id inner join oc_product_to_category on oc_product_to_category.product_id = oc_product.product_id where status = 1 and language_id = 2 GROUP BY oc_product.product_id";
$result = $mysqli -> query($sql);

$item = "";
while ($row = mysqli_fetch_array($result))  
{
    $link = xmlEscape($siteUrl."index.php?route=product/product&product_id=");
    $link .= $row["product_id"];
    $title= xmlEscape($row['name']);
    $asd = htmlspecialchars_decode($row["description"]);
    $desc = trim(strip_tags($asd));
    $desc = xmlEscape($desc);
    $price = number_format($row["price"], 2, '.', '');
    $image = $siteImageUrl;
    $image .= $row["image"];
    
    $item .= "<item>
            <g:id>".$row["product_id"]."</g:id>
            <g:title>".$title."</g:title>
            <g:description>".$desc."</g:description>
            <g:link>".$link."</g:link>
            <g:brand>".$row["model"]."</g:brand>
            <g:condition>new</g:condition>
            <g:availability>in stock</g:availability>
            <g:price>".$price." TRY</g:price>
            <g:image_link>$image</g:image_link>
        </item>";
}



echo '<rss xmlns:g="http://base.google.com/ns/1.0">';
echo '
    <channel>
    <title>'.$siteTitle.'</title>
    <link>'.$siteUrl.'</link>
    <description>'.$siteDesc.'</description>
';
echo $item;

echo '</channel>';
echo '</rss>';