I am trying to accomplish almost the same thing... but my tpl_index_default.php file looks very different... and in my case I just want the Featured Products to be before the New Products.
Here is the code of my tpl_index_default.php page;
<table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td class="pageHeading"><h1><?php echo HEADING_TITLE; ?></h1></td>
</tr>
<tr>
<td class="greetUser"><?php echo zen_customer_greeting(); ?></td>
</tr>
<?php if (TEXT_MAIN) { ?>
<tr>
<td class="main"><?php echo TEXT_MAIN; ?></td>
</tr>
<?php } ?>
<?php if (TEXT_INFORMATION) { ?>
<tr>
<td class="plainBox"><?php echo TEXT_INFORMATION; ?></td>
</tr>
<?php } ?>
<?php if (DEFINE_MAIN_PAGE_STATUS == '1') { ?>
<tr>
<td class="plainBox"><?php require($define_main_page); ?><br /></td>
</tr>
<?php } ?>
</table><br />
<?php
$show_display_category = $db->Execute(SQL_SHOW_PRODUCT_INFO_MAIN);
while (!$show_display_category->EOF) {
?><?php if ($show_display_category->fields['configuration_key'] == 'SHOW_PRODUCT_INFO_MAIN_FEATURED_PRODUCTS') { ?>
<?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_FEATURED_PRODUCTS_MODULE)); ?><?php } ?>
<?php if ($show_display_category->fields['configuration_key'] == 'SHOW_PRODUCT_INFO_MAIN_SPECIALS_PRODUCTS') { ?>
<?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_SPECIALS_INDEX)); ?><?php } ?>
<?php if ($show_display_category->fields['configuration_key'] == 'SHOW_PRODUCT_INFO_MAIN_NEW_PRODUCTS') { ?>
<?php require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_NEW_PRODUCTS)); ?><?php } ?>
<?php if ($show_display_category->fields['configuration_key'] == 'SHOW_PRODUCT_INFO_MAIN_UPCOMING') { ?>
<?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_UPCOMING_PRODUCTS)); ?><?php } ?>
<?php
$show_display_category->MoveNext();
} // !EOF
?>
Please help!! :D