Jump to content

Op999

Members
  • Content count

    48
  • Joined

  • Last visited

Everything posted by Op999

  1. PS: it looks like when I select domestic first class as a shipping option, it shows the empty express. Yet first class does not show at all. Odd.
  2. And I can't get "Priority Mail Express tradmrk" to show (shows blank w/rate; even when selected, it revers back to Priority. (The express flat rate envelope does show, however) Internationally, Express does show.
  3. 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?
  4. Op999

    NEW! Complete Order Editing Tool!

    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?
  5. Op999

    [Contribution] - USPS Methods

    Hooray! That seems to have worked. Thanks!
  6. Op999

    [Contribution] - USPS Methods

    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?
  7. Op999

    Checkout by Amazon for osCommerce Support Thread

    Hello -- seem to have most of it working on the admin side, but I get this error when testing the cart: Fatal error: Call to undefined function: substr_compare() in /homepages/11/d206294808/htdocs/checkout_by_amazon/custom_data.php on line 53 Any clues what this might mean?
  8. 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?
  9. While I have installed free shipping modules (one by category, the other by amount/weight), it seems that, no matter what I try, the setting under modules>>order total is the one that determines free shipping -- even when I try to remove it. Is there something I'm missing?
  10. Op999

    free shipping by categories support thread

    I'm also having problems with the number of categories i can add, versus how many I have in my store. And the weight limit feature is not working.
  11. Op999

    Seperate Pricing Per Customer v3.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?
  12. 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:
  13. Op999

    Low Stock Report v2.0

    Thanks for the great contribution. It really will make my client happy. If only she could find the link on the admin panel! (When I click directly on the www.xxx.com/admin/stats_low_stock.php, it does seem to work fine though.)
  14. Op999

    USPS Shipping Insurance

    So far it's been working as planned, although does anyone know if I can make insurance required, and not allow a customer to uncheck the box at the checkout stage?
  15. Op999

    Category Descriptions

    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'); ?>
  16. 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?
  17. 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?
  18. Op999

    cvv problem after contibution

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

    Official PayPal IPN Support Thread

    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.
  20. 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?
  21. according to the usps.php page, USPS doesn't accept 0 weight. So, how on earth could any of the contributions for 0 shipping for 0 weight work if USPS doesn't allow for a weight of 0? (We're talking deliverable goods -- not downloads/etc.)
  22. Op999

    QBI Quickbooks Import

    Say, I just realized that my client is using Quickbooks Point of Sale, not just Quickbooks Premier. Will this affect whether or not i can use QBI?
  23. Op999

    QBI Quickbooks Import

    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.
  24. 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]
  25. Hello -- does anyone have a sample IFF file so I can test to see if my recent install of QBI really works? Thanks a bunch. This project has been driving me crazy :blink:
×