tedmcdonald
Archived-
Posts
97 -
Joined
-
Last visited
Profile Information
-
Real Name
ted mcdonald
tedmcdonald's Achievements
-
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:
-
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 :-"
-
I have the same problem. Anyone with a solution? Best Regards, Ted
-
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
-
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
-
Credit Class/Gift Vouchers/Discount Coupons 5.10
tedmcdonald replied to Strider's topic in General Add-Ons Support
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. -
Howdy Fredrik :D Anything new to report on Impulse? Let us know. Dangling Carrot IS generating sales for me. Best Regards, Ted
-
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
-
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
-
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 . "'");
-
Official thread for Great Categories
tedmcdonald replied to willross's topic in General Add-Ons Support
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 -
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
-
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
-
Official thread for Great Categories
tedmcdonald replied to willross's topic in General Add-Ons Support
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 -
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