[kevinbrown]

Here is a crude but working mod of export.php/tpl to allow exporting all product data for use by
AffiliateWindow.com
Kelkoo.com
PriceRunner.com

Is displays in pipe delimited format all products that are on sale and in stock.



Save this as affiliatewindow.php under /provider/affiliatewindow.com

<?

#
# /provider/affiliatewindow.php
#

@set_time_limit(1800);

require "../smarty.php";
require "../config.php";



$excluded_columns = array("provider",
"distribution", "weight", "categoryid1", "categoryid2", "categoryid3",
"productcode", "descr", "avail", "forsale", "shipping_freight", "free_shipping", "discount",
"image_x", "discount_avail",
"param00", "param01", "param02", "param03", "param04", "param05", "param06", "param07", "param08", "param09",
"min_amount", "dim_x", "dim_y", "dim_z", "low_avail_limit", "orderby", "vat", "free_tax", "apply_gst", "apply_pst",
"list_price",
"image_y",
"add_date",
"rating",
"sales_stats",
"views_stats",
"del_stats",
"brand",
"model");


$chunk_size = 35;
$show_column_headers = "N";
$images_dir = $HTTP_POST_VARS["images_dir"];


# To block everything that has a stock level of less than 1 add the folling line to the sql statement
# $sql_tbl[products].avail>0 AND

$search_query = "SELECT $sql_tbl[products].*, $sql_tbl[categories].category, MIN($sql_tbl[pricing].price) AS price FROM $sql_tbl[products], $sql_tbl[pricing], $sql_tbl[categories] WHERE $sql_tbl[pricing].productid=$sql_tbl[products].productid AND $sql_tbl[pricing].quantity=1 AND $sql_tbl[products].categoryid=$sql_tbl[categories].categoryid AND $sql_tbl[products].forsale='Y' AND $sql_tbl[pricing].membership='' $provider_condition GROUP BY $sql_tbl[products].productid ORDER BY $sql_tbl[products].productid";

$result = db_query($search_query);

$total_products = db_num_rows($result);

if ($total_products > 0) {


$_tmp_smarty_debug = $smarty->debugging;
$smarty->debugging = false;

$smarty->assign("delimiter", "|");
$smarty->assign("line", $line);

$counter = 0;

while ($product_data = db_fetch_array($result)) {



$product_data_2 = array();
if (is_array($product_data)) {
if ($config["Images"]["thumbnails_location"] == "DB" && $HTTP_POST_VARS["donot_backup_images"] != "Y")
$product_data["thumbnail"] = func_copy_image_to_fs($product_data["productid"], $images_dir);
elseif ($config["Images"]["thumbnails_location"] == "FS")
$product_data["thumbnail"] = array_pop(func_query_first("SELECT image_path FROM $sql_tbl[thumbnails] WHERE productid='$product_data[productid]'"));
foreach ($product_data as $key => $value) {
if (!in_array($key, $excluded_columns)) {
$product_data_2[$key] = strtr($value, "\r\n\t", "");
$product_data_2[$key] = "".str_replace("\"", "\"\"", $value)."";
}
}

}

$products[] = $product_data_2;
$counter++;

if ($counter%$chunk_size==0 || $counter==$total_products) {
$smarty->assign("products", $products);
$smarty->assign("total_columns", (is_array($products)?count($products[0]):0));
$smarty->assign("show_column_headers", $show_column_headers);
if ($show_column_headers == "Y")
$show_column_headers = "";
$smarty->display("main/aw_feed.tpl");
flush();
unset($products);
}

}

$smarty->debugging = $_tmp_smarty_debug;
exit;
}


$line = "\n";
$smarty->assign("line", $line);
$smarty->assign("products", $products);


?>



THEN save this as aw_feed.tpl under /skin1/main

{section name=prod_num loop=$products}
{strip}
http://www.citybreakaways.com/customer/product.php?productid={$products[prod_num].productid|replace:"\"":""}&cat={$products[prod_num].categoryid|replace:"\"":""}{$delimiter}
{$products[prod_num].product|replace:"\"":""}{$delimiter}
{$products[prod_num].fulldescr|replace:"\r":" "|replace:"\n":" "|replace:"\t":" "|replace:"\"":""|replace:",":","|strip_tags}{$del imiter}
{$products[prod_num].price|replace:"\"":""}{$delimiter}
http://www.citybreakaways.com/image.php?productid={$products[prod_num].productid|replace:"\"":""}{$delimiter}
{$products[prod_num].category|replace:"/":" > "|replace:"\"":""}{$delimiter}
{$products[prod_num].productcode|replace:"\"":""}
{/strip}

{/section}