Jump to content

Op999

Members
  • Content count

    48
  • Joined

  • Last visited

Posts posted by Op999


  1. I keep having the discount dig into the shipping part (as seen below)

     

    Discount Coupon omar25 applied: -$25.00 Sub-Total: $1.70 United States Postal Service (1 pkg, 3.00 lbs total) (Priority Mail®

    ---Insured for $1.7): $15.70 Total: $0.00

     

     

    It almost looks like the coupon ($25 in this case) is readding itself to the shipping.

     

     

    Am I missing something?


  2. I've installed it in the past and have updated as well, but I am not able to change discount codes. If, for example, I have a 20 percent discount on the total purchase, and I edit an order and add a few more items, the discount stays the same as the original. Nor do I have the option of deleting a coupon/discount used.

     

    Am I missing something?


  3. I keep getting:

     

    1074 - Too big column length for column 'set_function' (max = 255). Use BLOB instead

     

    ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 1020 )

     

    [TEP STOP]

     

     

     

    I did the SQL updgrade as:

     

    ALTER TABLE `configuration` CHANGE `configuration_value` `configuration_value` TEXT NOT NULL ,

    CHANGE `set_function` `set_function` TEXT NULL DEFAULT NULL;

     

    Any thoughts?


  4. Does anyone here know why the module won't work?

     

    It doesn't give me any errors, and it looks like I have saved everything. But, in the end, only the general module (under modules >> order total >> shipping) determines free shipping. I don't have two similar modules running at the same time, and i've tried to deactivate the 'general module" I just mentioned. And when I do, no free shipping.

     

    Wouldn't I get an error message if this module was working properly?


  5. Hi all -- This sounds like what I will need to help client sell both retail AND wholesale through her site.

     

    However, before trying to install it, I'm wondering if this has any type of minimum number feature.

     

    See, my client wants to sell all of her items in groups of 3. But, she has too many items to recreate individual listings with a different price. So, we're hoping that, by having a wholesale customer, they must buy a min. of 3 products.

     

    That and there would be a minimum dollar amount on the order.

     

    Anyone know?


  6. No matter what I do, even installed the latest 3.32 version, I just cannot get anyplace to fill out a maximum amount. I want to stop allowing the use of coupons up to a certain dollar amount, and despite everything, I'm back to where I started with version 3.0 -- no way to limit coupon uses.

     

    Am I missing something?? It's driving me mad :angry:


  7. Hi all -- i recently installed Category Description v1.04, and while it is indeed allowing me to enter a brief description, the picture for each category no longer appears. Does this sound familiar to anyone? Here's the code I have, and I suspect that it involves the index.php page (on the admin end, I am allowed to pic a cat. picture, but it just doesn't show on the front end.)

     

    <?php

    /*

    $Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

     

    osCommerce, Open Source E-Commerce Solutions

    http://www.oscommerce.com

     

    Copyright © 2003 osCommerce

     

    Released under the GNU General Public License

    */

     

    require('includes/application_top.php');

     

    // the following cPath references come from application_top.php

    $category_depth = 'top';

    if (isset($cPath) && tep_not_null($cPath)) {

    $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

    $cateqories_products = tep_db_fetch_array($categories_products_query);

    if ($cateqories_products['total'] > 0) {

    $category_depth = 'products'; // display products

    } else {

    $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

    $category_parent = tep_db_fetch_array($category_parent_query);

    if ($category_parent['total'] > 0) {

    $category_depth = 'nested'; // navigate through the categories

    } else {

    $category_depth = 'products'; // category has no products, but display the 'no products' message

    }

    }

    }

     

    require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);

    ?>

    <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

    <html <?php echo HTML_PARAMS; ?>>

    <head>

    <meta content="Cake decorating supplies, including cake cutters and tools, tips and bags, floral wire and stamens, gumpaste flowers, and more" name=description>

    <title>Cake Decorating Supplies, Cake Cutters, Cake Tools, Gumpaste Flowers and

    More</title>

    <meta content="cake decorating supplies cutters tools stamens gumpaste flowers impression mats decoration bags cake making baking pastries cooking decoration books equipment baked" name=keywords>

    <meta content=index,follow name=robots>

    <meta content="2 Days" name=REVISIT-AFTER>

    <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

    <link rel="stylesheet" type="text/css" href="stylesheet.css">

    </head>

    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

    <table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/background.jpg">

    <tr>

    <td background="images/background.jpg">

    <!-- header //-->

    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>

    <!-- header_eof //-->

    <!-- body //-->

    <table width="900" border="1" align="center" cellpadding="3" cellspacing="3" bordercolor="#FF0000" bgcolor="#FFFFFF">

    <tr>

    <td width="<?php echo BOX_WIDTH; ?>" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

    <!-- left_navigation //-->

    <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

    <!-- left_navigation_eof //-->

    </table></td>

    <!-- body_text //-->

    <?php

    if ($category_depth == 'nested') {

    $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");

    $category = tep_db_fetch_array($category_query);

    ?>

    <td width="100%" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td class="pageHeading"><?php echo $category['categories_name']; ?></td>

    <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

    </tr>

    <tr>

    <td class="productListing-data"><?php echo $categories_desc['categories_description']; ?></td>

    <td class="productListing-data"><?php echo $categories_image['categories_image']; ?></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

    </tr>

     

    </table></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

    </tr>

    <tr>

    <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr>

    <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr>

    <?php

    if (isset($cPath) && strpos('_', $cPath)) {

    // check to see if there are deeper categories within the current category

    $category_links = array_reverse($cPath_array);

    for($i=0, $n=sizeof($category_links); $i<$n; $i++) {

    $categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");

    $categories = tep_db_fetch_array($categories_query);

    if ($categories['total'] < 1) {

    // do nothing, go through the loop

    } else {

    $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

    break; // we've found the deepest category the customer is in

    }

    }

    } else {

    $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

    }

     

    $number_of_categories = tep_db_num_rows($categories_query);

     

    $rows = 0;

    while ($categories = tep_db_fetch_array($categories_query)) {

    $rows++;

    $cPath_new = tep_get_path($categories['categories_id']);

    $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';

    echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";

    if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {

    echo ' </tr>' . "\n";

    echo ' <tr>' . "\n";

    }

    }

     

    // needed for the new products module shown below

    $new_products_category_id = $current_category_id;

    ?>

    </tr>

    </table></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

    </tr>

    <tr>

    <td>

    <?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?>

    </td>

    </tr>

    </table></td>

    </tr>

    </table></td>

    <?php

    } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

    // create column list

    $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

    'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

    'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

    'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

    'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

    'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

    'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

    'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

     

    asort($define_list);

     

    $column_list = array();

    reset($define_list);

    while (list($key, $value) = each($define_list)) {

    if ($value > 0) $column_list[] = $key;

    }

     

    $select_column_list = '';

     

    for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

    switch ($column_list[$i]) {

    case 'PRODUCT_LIST_MODEL':

    $select_column_list .= 'p.products_model, ';

    break;

    case 'PRODUCT_LIST_NAME':

    $select_column_list .= 'pd.products_name, ';

    break;

    case 'PRODUCT_LIST_MANUFACTURER':

    $select_column_list .= 'm.manufacturers_name, ';

    break;

    case 'PRODUCT_LIST_QUANTITY':

    $select_column_list .= 'p.products_quantity, ';

    break;

    case 'PRODUCT_LIST_IMAGE':

    $select_column_list .= 'p.products_image, ';

    break;

    case 'PRODUCT_LIST_WEIGHT':

    $select_column_list .= 'p.products_weight, ';

    break;

    }

    }

     

    // show the products of a specified manufacturer

    if (isset($HTTP_GET_VARS['manufacturers_id'])) {

    if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

    // We are asked to show only a specific category

    $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

    } else {

    // We show them all

    $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

    }

    } else {

    // show the products in a given categorie

    if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

    // We are asked to show only specific catgeory

    $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

    } else {

    // We show them all

    $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

    }

    }

     

    if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

    for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

    if ($column_list[$i] == 'PRODUCT_LIST_NAME') {

    $HTTP_GET_VARS['sort'] = $i+1 . 'a';

    $listing_sql .= " order by pd.products_name";

    break;

    }

    }

    } else {

    $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

    $sort_order = substr($HTTP_GET_VARS['sort'], 1);

    $listing_sql .= ' order by ';

    switch ($column_list[$sort_col-1]) {

    case 'PRODUCT_LIST_MODEL':

    $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

    break;

    case 'PRODUCT_LIST_NAME':

    $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

    break;

    case 'PRODUCT_LIST_MANUFACTURER':

    $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

    break;

    case 'PRODUCT_LIST_QUANTITY':

    $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

    break;

    case 'PRODUCT_LIST_IMAGE':

    $listing_sql .= "pd.products_name";

    break;

    case 'PRODUCT_LIST_WEIGHT':

    $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

    break;

    case 'PRODUCT_LIST_PRICE':

    $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

    break;

    }

    }

    ?>

    <td width="100%" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td class="pageHeading"><?php echo $category['categories_name']; ?></td>

    <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

    </tr>

    <tr>

    <td class="productListing-data"><?php echo $categories_desc['categories_description']; ?></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

    </tr>

     

     

     

     

     

    <?php

    // optional Product List Filter

    if (PRODUCT_LIST_FILTER > 0) {

    if (isset($HTTP_GET_VARS['manufacturers_id'])) {

    $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

    } else {

    $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";

    }

    $filterlist_query = tep_db_query($filterlist_sql);

    if (tep_db_num_rows($filterlist_query) > 1) {

    echo ' <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';

    if (isset($HTTP_GET_VARS['manufacturers_id'])) {

    echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);

    $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));

    } else {

    echo tep_draw_hidden_field('cPath', $cPath);

    $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));

    }

    echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);

    while ($filterlist = tep_db_fetch_array($filterlist_query)) {

    $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);

    }

    echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');

    echo '</form></td>' . "\n";

    }

    }

     

    // Get the right image for the top-right

    $image = DIR_WS_IMAGES . 'table_background_list.gif';

    if (isset($HTTP_GET_VARS['manufacturers_id'])) {

    $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

    $image = tep_db_fetch_array($image);

    $image = $image['manufacturers_image'];

    } elseif ($current_category_id) {

    $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

    $image = tep_db_fetch_array($image);

     

    }

    ?>

    </td>

    </tr>

    </table></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

    </tr>

    <tr>

    <td>

    <?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?>

    </td>

    </tr>

    </table></td>

    <?php

    } else { // default page

    ?>

    <td width="100%" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td class=<p><p><strong><font size="4" face="Arial, Helvetica, sans-serif"><strong><img src="images/front-pics.gif" alt="Cake Decorating Supplies and More" width="200" height="300" hspace="5" border="1" align="left"></strong></font></strong><font color="#CC0000" size="3" face="Arial, Helvetica, sans-serif"><strong><font size="2">For

    cake decorating supplies, Icing on the Cake offers everything

    you're looking for. Our selection is broad, our prices

    low, and we offer prompt delivery.</font></strong></font></p>

    <p><font color="#CC0000" size="2"><strong><font face="Arial, Helvetica, sans-serif">We

    offer everything from cake cutters and tools; cake decorating

    tips and bags; floral wire and stamens; gumpaste flowers;

    impression mats, and much more. Please

    contact us if you have any questions regarding inventory.

    If you cannot find it on our site, ask us and we will

    do our best to get what you're looking for. </font></strong></font></p>

    <p><strong><font face="Arial, Helvetica, sans-serif">

    <em>

    <font color="#CC0000">Orders

    $100 or more receive free shipping!

    </font>

    <font color="#CC0000" size="1">(USA and Canada Only)</font></em><font color="#CC0000" size="2"><br>

    <br>

    Happy Decorating!</font></font></strong></p></td>

    </tr>

    </table></td>

    </tr>

    <tr>

    <td> </td>

    </tr>

    <tr>

    <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td>

    <?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?>

    </td>

    </tr>

    <tr>

    <td> </td>

    </tr>

    <?php

    include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);

    ?>

    </table></td>

    </tr>

    </table></td>

    <?php

    }

    ?>

    <!-- body_text_eof //-->

    <td width="<?php echo BOX_WIDTH; ?>" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

    <!-- right_navigation //-->

    <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

    <!-- right_navigation_eof //-->

    </table></td>

    </tr>

    </table>

    <!-- body_eof //-->

    <!-- footer //-->

    <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

    <!-- footer_eof //-->

    </td>

    </tr>

    </table>

    </body>

    </html>

    <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>


  8. Despite doing my best to try to see if I overlooked uploading or modifying any files, I still don't get any discounts. Yes, I can create coupons and add all the figures and totals, and I can enter a discount coupon code upon checkout. But, at the end, nothing. No discount, no error messages -- even when I type in a code that does not exist.

     

    So, what gives? Are there any bug fixes that anyone knows about?


  9. I am able to input the information for the coupons, and if don't enter something (an amount, for example), it will remind me to do so. But then, upon hitting submit, I get:

     

    1136 - Column count doesn't match value count at row 1

     

    insert into discount_coupons values ( 'test', '', '5', 'fixed', null, null, 0, 0, null, 0)

     

    [TEP STOP]

     

     

     

    Ok, so perhaps I picked up the wrong SQL, but there was never any SQL info on the contribution itself. So, what IS the SQL command?


  10. Same problem here, and yes, i have tried reinstalling the CC module and re-running/dropping and reinstalling the SQL script. What gives?

     

     

     

     

    I have installed this mod http://www.oscommerce.com/community/contri...,cvv2_version+2 the one dated 7 sept 2006

     

    All appears fine when working though the oder process but when I view the order this is all I get

     

    Credit Card Type: Visa

    Credit Card Owner: Test Testing

    Credit Card Number: 4111111111111111

    Credit Card Expires: 0109

    CVV2:

     

    the cvv2 field is blank, can anyone suggest what file the problem may be on I have checked right though everything

     

    Regards


  11. Despite all of my research, i still cannot figure out how to get orders that were not completed (which are now marked as "Preparing [PayPal IPN] " off the orders page entirely, and just have those that were paid ("pending"). Is that even possible? I don't want my client to send off goods thinking they have been paid, when in fact, the person who was about to purchase them didn't, and just aborted the purchase.


  12. Hi all - not only am I having the same problem of having $0.00 for shipping, but I also cannot get past the second stage (the checkout_shipping.php part). I also cannot see the payment options (in my case, PayPal). Yet, when I remove the individual shipping module, it works fine.

     

    Anyone else had this problem and knew how to solve it?


  13. Hello -- I just had V. 2.20 installed, and it seems to be working fine until I try to upload an IIF file (one that I created using QBI's export feature)

     

    That's when I get:

     

    SETUP_FAIL

     

    Quickbooks Items

    Name Description Account Action

     

    Quickbooks Items

    Name Description Account Action

     

    Am I doing something wrong? Or am I missing something? I figured if QBI is making the IIF file for me and I am simply renaming it and inserting in the appropriate folder, then it would be exactly in the format that it can recognize.


  14. What does this error message mean?

     

    1054 - Unknown column 'extra_cat_info.categories_id' in 'where clause'

     

    select categories_description.categories_id, categories_name from categories left join categories_description using (categories_id) left join extra_cat_info on extra_cat_info.categories_id = categories_description.categories_id where extra_cat_info.categories_id is null and parent_id !=0 and categories_description.language_id=1

     

    [TEP STOP]

×