Jump to content

tedmcdonald

Members
  • Content count

    97
  • Joined

  • Last visited

2 Followers

Profile Information

  • Real Name
    ted mcdonald
  1. tedmcdonald

    Stock Status in Product Listing

    I may have answered my own question. However, perhaps it could be done more elegantly. Here's what I did in product_info.php (actually, in my case, using BTS, the file was catalog/templates/content/product_info.tpl.php): <!--bof stock announcement--> <?php if ((STOCK_CHECK == 'true')&&($product_info['products_quantity'] == 0)) { ?> <tr> <td><span class="markProductOutOfStock"><b>Out of Stock</b></span></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } elseif ((STOCK_CHECK == 'true')&&($product_info['products_quantity'] >= 2)&&($product_info['products_quantity'] < 400)) { ?> <tr> <td><span class="markProductOutOfStock"><b>In Stock</b></span></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } elseif ((STOCK_CHECK == 'true')&&($product_info['products_quantity'] < -400)&&($product_info['products_quantity'] > -500)) { ?> <tr> <td><span class="markProductOutOfStock"><b>Custom Message Here</b></span></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> <!--eof stock announcement--> In this case, items that have a quantity of less than -400 and greater than -500 will display a custom message. I plan on using this to create several different custom messages. Is there any reason why I should NOT do it this way? Best Regards, Ted :thumbsup:
  2. tedmcdonald

    Stock Status in Product Listing

    I have been using this contrib for nearly a year. It is a great contribution. Thank you. I am hoping to expand its usefulness. I would like to expand on the IN STOCK and OUT OF STOCK messages. For example, I would like it to say LOW STOCK when less than 5 items are in stock. Also, I would like to create custom stock messages based on specific stock levels, for example: If stock is between 300 and 400, I would like to have CALL FOR INFO If stock is between 401 and 500, I would like to have ARRIVING IN DECEMBER ETC. There is a contribution called Quantity availability image and text Unlimited that does this, but it is not as conprehensive as this one. Has anyone done anything like this? Can someone give me a hint on how to do this? Best Regards, Ted :-"
  3. tedmcdonald

    USPS Tracking problem

    I have the same problem. Anyone with a solution? Best Regards, Ted
  4. tedmcdonald

    Impulse Item

    Howdy Fredrik Any new news to report? I am very surprised that more are not interested in this contribution. It is a great idea. Best, Ted
  5. tedmcdonald

    Google Analytics module

    Clement, thanks for this contribution. :thumbsup: I have a question: My catalog is non-ssl while shopping. When you login and checkout, the customer enters SSL, but it is a different domain. E.g. Person shops at http://shop.com, and checks out at https://secure-shop.com. When I set up my Analytics account, which domain name do I use? Both? Does it matter? Thanks for your help. Best, Ted
  6. I really want to offer a FREE SHIPPING coupon. Is there a way to prevent the coupon user from choosing an expensive (i.e., Overnight) shipping method? Any help greatly appreciated since I am planning on sending out a coupon to all my customers this week. Best Regards, Ted PS. I thought this would have been a common question/problem for others, but I couldn't find a similar thread.
  7. tedmcdonald

    Impulse Item

    Howdy Fredrik :D Anything new to report on Impulse? Let us know. Dangling Carrot IS generating sales for me. Best Regards, Ted
  8. tedmcdonald

    Bundled products

    Thanks Mark Although your solution did not work, the idea that lines might need to be connected led me to find a problem in the checkout_confirmation file where a line did not meet correctly with the line below. Best, Ted
  9. tedmcdonald

    Bundled products

    Thanks for taking a stab at it Sosige, but there is no gap in the actual code. It must just look like it in the quoted code area. Anyone else want to take a stab at my problem (above)? Best Regards, Ted
  10. tedmcdonald

    Bundled products

    On the Order Confirmation page, I get: 1064 - You have an error in your SQL syntax near 'product_id LEFT JOIN products_description pd on p.products_id=pd.products_id whe' at line 2 SELECT pb.subproduct_id, p.products_quantity, pd.products_name from products_bundles pb LEFT JOIN products p on p.products_id=pb.sub product_id LEFT JOIN products_description pd on p.products_id=pd.products_id where pb.bundle_id = '1076' and pd.language_id = '1' under bundled products. I am not able to figure out why. Any ideas, hints? Thanks. Best, Ted My product_info looks thus: <!-- start bundle At the beginning of Bundle Mod Addition 21.01.2005--> <?php if (tep_not_null($product_info['products_bundle'])) { ?> <table border="0" width="65%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="3"> <?php if ($product_info['products_bundle'] == "yes") { $products_bundle = $product_info['products_bundle']; echo TEXT_PRODUCTS_BY_BUNDLE . "</td></tr>"; $bundle_query = tep_db_query(" SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price, p.products_image FROM products p INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id=pd.products_id INNER JOIN " . TABLE_PRODUCTS_BUNDLES . " pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = " . (int)$HTTP_GET_VARS['products_id'] . " and language_id = '" . (int)$languages_id . "'"); while ($bundle_data = tep_db_fetch_array($bundle_query)) { if ($bundle_data['products_bundle'] == "yes") { // uncomment the following line to display subproduct qty echo "<br>? <b>" . $bundle_data['subproduct_qty'] . " x " . $bundle_data['products_name'] . "</b>"; echo "<br>? <b> " . $bundle_data['products_name'] . "</b>"; $bundle_query_nested = tep_db_query(" SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price FROM products p INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id=pd.products_id INNER JOIN " . TABLE_PRODUCTS_BUNDLES . " pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = " . $bundle_data['products_id'] . " and language_id = '" . (int)$languages_id . "'");
  11. tedmcdonald

    Official thread for Great Categories

    Yep, that was it. :D I had to add: // #################### Added Enable / Disable Categories ############## // $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' and c.categories_status = '1' order by sort_order, cd.categories_name"); // #################### End Added Enable / Disable Categories ############## to both queries. Best, Ted
  12. tedmcdonald

    Bundled products

    Ouch! :blink: I just found a problem at checkout for my only bundled product. On the Order Confirmation page, I get: What's wrong? Please help if you can. Best Regards, Ted
  13. tedmcdonald

    Bundled products

    By the way, the solution works for the Extra Fields Contribution...thus: // START: Extra Fields Contribution v2.0b $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=".[b](int)[/b]$HTTP_GET_VARS['products_id']." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".$languages_id."') ORDER BY products_extra_fields_order"); Best Regards, Ted
  14. tedmcdonald

    Official thread for Great Categories

    Fantastic contribution. :thumbsup: Thank you! I do have one problem though: I am using enable_disable_categories_1.6.1.1 My disabled categories still show up in Great Categories. Any idea why? Best Regards, Ted
  15. tedmcdonald

    Bundled products

    Howdy Folks I would like to have my Bundled Products listed also as Specials. Currently, if I add a bundled product to Specials, it's special price is not correct in the You save... line. Here's what I did: I added a bundled product with three products @ $5.00 each. I made the bundled product price $15.00 (no savings), and then I put the bundled product on Special at $10.00. I was hoping it would then say You save $5.00, but it doesn't. Is it possible to have a Bundled Product also be on Special and the price that you save accurate? :huh: Please let me know if you know. :) Best, Ted
×