Jump to content
Latest News: (loading..)

mugitty

Members
  • Content count

    1,193
  • Joined

  • Last visited

2 Followers

Profile Information

  • Real Name
    Stuart Owens
  • Location
    Great Southeastern Washington Desert, USA
  • Website
  1. There had been prior discussion and a proposed fix for the UPS rates being incorrect when displaying the totals in Ship-In-Cart. I don't recall if I had the fix in UPSXML in place and found that it corrected the problem, or if I had just decided to not show the totals to my customers... at any rate, I just made some mods to provide for the weight of attributes to be added when they are selected so that the shipping quotes would be accurate for the actual weight being shipped, and I find the same issue has cropped up again: The UPS rates for each individual method appear to be OK but if you show the total $ amount for the order, it seems that the weight is being doubled, producing almost double the shipping charge. This only occurs when a UPS rate is selected (USPS appears correctly), and it only appears in the total section... the individual method rate remains correct. Has anyone else encountered this and found a solution?
  2. I have installed the attribute sorter/copier with weight support and it is working quite nicely, however... The tables with the selectable attributes appear every time an item add/edit page is opened in the admin. With several thousand products, several hundred attributes and only a few dozen items which actually have attributes, the tables become a problem when editing. Is there a way to 1) only have the tables appear if an item has attributes and then 2) only have the specific table(s) appear for attributes that have been indicated as valid for a given item?
  3. Anita; Thank you for all of your eforts on this contribution. It's very nicely done and provides excellent options from the Admin interface. Install was a breeze and your instructions and user guide are first rate! My little suggestion for upcoming versions (I've looked at doing this and just don't have the capability to bring it off) would be to make the item selection from within the Admin interface a search function rather than dropdowns (similar to what was done in Select Specials) I've also noticed that whenever I do an addition or update, there is a long pause before the screen refreshes. I have around 3000 products in the database, and I suspect that the delay is due to the number of products. I don't know if there's a way to streamline the queries that are being done to improve the speed (and possibly reduce the query load) or not...
  4. Anita; Thank you for all of your eforts on this contribution. It's very nicely done and provides excellent options from the Admin interface. Install was a breeze and your instructions and user guide are first rate! My little suggestion for upcoming versions (I've looked at doing this and just don't have the capability to bring it off) would be to make the item selection from within the Admin interface a search function rather than dropdowns (similar to what was done in Select Specials) I've also noticed that whenever I do an addition or update, there is a long pause before the screen refreshes. I have around 3000 products in the database, and I suspect that the delay is due to the number of products. I don't know if there's a way to streamline the queries that are being done to improve the speed (and possibly reduce the query load) or not...
  5. mugitty

    Information Pages Unlimited v1.0

    Joeri; Great contribution, Thank You! I use this extensively to provide pages of additional information that relates to the products I sell. I have amended things slightly to show the page title in the browser title bar, but I notice that the breadcrumb only reflects the current page. Is it possible to have the breadcrumb reflect the entire path to whatever page you happen to be on (as the catalog itself does)? Thus, if you have a parent and a child page, the breadcrumb would show Home >> Catalog >> Parent Info Page >> Child Info Page It would also be neat if the child pages appeared in the body of the parent page (as they do in the catalog categories)
  6. mugitty

    All Manufacturers Categories 1.0

    Carine; Thank you, that did the trick! I thought it might be as simple as that, but wasn't sure if the initial query might need to be modified as well. BTW - Don't you dare quit offering contributions... Your name is among the top 10 that I look for when I'm looking to see if there is new and helpful information and/or contributions available :thumbsup:
  7. mugitty

    All Manufacturers Categories 1.0

    Well, I uploaded the original catalog/all_manufacturers_categories.php as it originally came out of the contribution download - just in case I messed something up with my amendments - and I get the same thing... When you click on a category under a manufacturer's name, you get the entire catalog for that manufacturer, not just the category that was clicked on. The path that is shown in the link from the all categories page is similar to: The path that is shown once you are looking at the product listing for that manufacturer and use the on page filter to filter for the same category looks like: ...so apparently category_id in and of itself does not return a filtered listing for a category whereas filter_id seems to. Anybody know how to rewrite this code to select the filtered list? (code is above in previous post)
  8. mugitty

    All Manufacturers Categories 1.0

    Solved the line break problem but still no joy with the alignment I've run into something else, though... Has anybody who is using this found that, while the categories display correctly under each manufacturer, if you click the link to one of the categories, it doesn't filter for that category - it brings up a result page that contains all of the products from that manufacturer. I am appending the code for the query and result display if anyone can tell me how to correct it so the filter is applied <!-- all manufacturers begin //--> <?php $row = -1; $manufacturers_query = tep_db_query("SELECT DISTINCT count(p2c.products_id) as prodcount, cd.categories_id, cd.categories_name, m.manufacturers_id, manufacturers_name, manufacturers_image FROM " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_MANUFACTURERS ." m, " . TABLE_PRODUCTS_TO_CATEGORIES ." p2c WHERE p.manufacturers_id = m.manufacturers_id AND p.products_id = p2c.products_id AND p.products_status = 1 AND p2c.categories_id = c.categories_id and c.categories_id = cd.categories_id and cd.language_id = " . (int)$languages_id . " GROUP BY m.manufacturers_name, cd.categories_name"); $last_manid = ''; while ($manufacturers = tep_db_fetch_array($manufacturers_query)) { if ($manufacturers['manufacturers_id'] <> $last_manid ) { $row++; if ($last_manid) { echo '<br><br>' . tep_draw_separator('pixel_silver.gif', '90%', '1') . '</td>'; if ((($row / 1) == floor($row / 1))) { ?> </tr> <tr> <?php } } $last_manid = $manufacturers['manufacturers_id']; echo ' <td align="center" valign="top" width="100%" class="main">'; echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'] , 'NONSSL', false) . '">'; //If you'd like to have an image shown, remove the comment slashes from the next lines if ($manufacturers['manufacturers_image']) { echo tep_image(DIR_WS_IMAGES . $manufacturers['manufacturers_image'], $manufacturers['manufacturers_name'], '', '') . tep_draw_separator('pixel_trans.gif', '50', '1') . '<font size="+1"><b>'. $manufacturers['manufacturers_name'] . '</b></font><br><br>'; } else { echo '<font size="+1"><b>'. $manufacturers['manufacturers_name'] .'</b></font><br><br>'; } echo "</a>"; } echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'] . '&category_id=' . $manufacturers['categories_id'], 'NONSSL', false) . '" style="text-decoration: none;">'; echo '<nobr>' . $manufacturers['categories_name'] . '</nobr> ('.$manufacturers['prodcount'].')'; echo '</a> '; } ?> <!-- all manufacturers end //-->
  9. I have installed All Manufacturers and their Products Categories 1.0 (thank you Carine). Since I have some manufacturers that have products in many categories and others with just a few, the stock 3 column layout left big gaps when a manufacturer with many categories fell next to one with just a few. I changed the output so that there is just 1 column with the manufacturer name followed by its product categories. I also amended the manufacturer logo/name line to show both the logo and the name. Having done that, I am left with the following problems: 1) The logo appears to be formatted so that any text next to it is aligned at the bottom of the logo - I need to have it aligned along the centerline of the logo 2) The category output will break a category name that has a space in it so that part of the name wraps to the next line - how can I prevent breaks and/or specify a given number of category names to appear before there is a break to the next line My amended code is below <!-- all manufacturers begin //--> <?php $row = -1; $manufacturers_query = tep_db_query("SELECT DISTINCT count(p2c.products_id) as prodcount, cd.categories_id, cd.categories_name, m.manufacturers_id, manufacturers_name, manufacturers_image FROM " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_MANUFACTURERS ." m, " . TABLE_PRODUCTS_TO_CATEGORIES ." p2c WHERE p.manufacturers_id = m.manufacturers_id AND p.products_id = p2c.products_id AND p.products_status = 1 AND p2c.categories_id = c.categories_id and c.categories_id = cd.categories_id and cd.language_id = " . (int)$languages_id . " GROUP BY m.manufacturers_name, cd.categories_name"); $last_manid = ''; while ($manufacturers = tep_db_fetch_array($manufacturers_query)) { if ($manufacturers['manufacturers_id'] <> $last_manid ) { $row++; if ($last_manid) { echo '</td>'; if ((($row / 1) == floor($row / 1))) { ?> </tr> <tr> <?php } } $last_manid = $manufacturers['manufacturers_id']; echo '<td align="left" valign="top" width="100%" class="main">'; echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'] , 'NONSSL', false) . '">'; //If you'd like to have an image shown, remove the comment slashes from the next lines if ($manufacturers['manufacturers_image']) { echo tep_image(DIR_WS_IMAGES . $manufacturers['manufacturers_image'], $manufacturers['manufacturers_name'], '', '') . tep_draw_separator('pixel_trans.gif', '50', '1') . '<font size="+1"><b>'. $manufacturers['manufacturers_name'] . '</b></font><br>'; } else { echo '<h4>'. $manufacturers['manufacturers_name'] .'</h4>'; } echo "</a>"; } echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'] . '&category_id=' . $manufacturers['categories_id'], 'NONSSL', false) . '" style="text-decoration: none;">'; echo $manufacturers['categories_name'] . ' ('.$manufacturers['prodcount'].')'; echo "</a> "; } ?> <!-- all manufacturers end //--> Any suggestions would be appreciated
  10. mugitty

    stupid design question

    "Zone Rates" is in catalog\includes\languages\english\modules\shipping\zones.php as define('MODULE_SHIPPING_ZONES_TEXT_TITLE', 'Zone Rates'); MODULE_SHIPPING_CANADAPOST_TEXT_TITLE (1 x 0.22kgs) MODULE_SHIPPING_CANADAPOST_TEXT_TITLE are probably in the language file for a Canada Post shipping contribution which you have added - although it looks like you may not have added the language file for that contribution because what is showing there is the call to the text that should appear rather than the text itself. Check back through the Canada Post contribution to see if there is a file that did not get uploaded into the languages area.
  11. Post #32 in This Thread
  12. mugitty

    Free Shipping per Product

    Just in case anyone else needs to do this... I didn't get it done by using the zone but did manage to get it by excluding the states (Alaska/Hawaii) if ($order->delivery['country_id'] != STORE_COUNTRY && FREE_SHIPPING_TO_ALL_COUNTRIES == "false") { $free_shipping = false; } elseif ($order->delivery['country_id'] == STORE_COUNTRY && $order->delivery['state'] == "Hawaii"){ $free_shipping = false; } elseif ($order->delivery['country_id'] == STORE_COUNTRY && $order->delivery['state'] == "Alaska"){ $free_shipping = false; }
  13. mugitty

    Free Shipping per Product

    I have a need to present certain items with Free Shipping to the lower 48 US states. I installed the Free Shipping per Product, which I believe I can make work pretty much the way I want it to except for one issue: In the setup for the mod, there is a provision to ship designated items worldwide or just to the shop's own country. I need to amend the code to reflect just the lower 48 US States instead of the entire US. There is already a zone set up in the cart for the lower 48, but I can't sort out which code to change to exclude Alaska and Hawaii from the free shipping availability. The amended section of catalog/checkout_shipping.php is below, though I'm not sure if the last section of this where it says if ($order->delivery['country_id'] != STORE_COUNTRY && FREE_SHIPPING_TO_ALL_COUNTRIES == "false") { is the correct area to be looking or not: 94: if ($free_shipping == false) { 95: $check_free_shipping_basket_query = tep_db_query("select products_id from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "'"); 96: while ($check_free_shipping_basket = tep_db_fetch_array($check_free_shipping_basket_query)) { 97: $check_free_shipping_query = tep_db_query("select products_free_shipping from " . TABLE_PRODUCTS . " where products_id = '" . (int)$check_free_shipping_basket['products_id'] . "'"); 98: $check_free_shipping = tep_db_fetch_array($check_free_shipping_query); 99: $check_free_shipping_array[] = $check_free_shipping['products_free_shipping']; 100: } 101: if (in_array("1", $check_free_shipping_array) && !in_array("0", $check_free_shipping_array)) { 102: $free_shipping = true; 103: include_once(DIR_WS_LANGUAGES . $language . '/checkout_shipping.php'); 104: } 105: } 106: 107: if ($order->delivery['country_id'] != STORE_COUNTRY && FREE_SHIPPING_TO_ALL_COUNTRIES == "false") { 108: $free_shipping = false; 109: } I believe that other files affected by the contribution only deal with text identification for free shipping items (index, product_info and product_listing in the catalog area) or with providing for selecting whether an item gets free shipping (categories in the admin area). Anyone have an ides how to make $order->delivery['country_id'] != call the zone rather than the whole country?
  14. mugitty

    Catalog Listing Contrib 2795

    ...perhaps I'm looking at the wrong part of the file to accomplish what I'm after. Is there a way to get all products included in the output - whether or not they have a "Special" price by amending some of the code in the html output section? The current output area looks like this: <? $i = 0; $table = mysql_fetch_array($records); while ($table) { $category1 = $table['categories_name']; $manufacturer1 = $table['manufacturers_name']; ?> <h2 class="report" align="left"> <? echo $category1 . ": " . $manufacturer1; ?> </h2> <table class="report"> <tr> <th width=150 align="center" class="report">Model</th> <th width=500 align="left" class="report">Product</th> <th width=80 align="center" class="report">Price</th> <th width=80 align="center" class="report">Special</th> </tr> <? do { $category = $table['categories_name']; $manufacturer = $table['manufacturers_name']; $model = $table['products_model']; $product = $table['products_name']; $price = $table['products_price']; $special = $table['specials_new_products_price']; $description = $table['products_description']; if ($category != $category1 || $manufacturer != $manufacturer1) { ?> </table> <? break; } if (!($i%2)) {$color = "BGCOLOR = #FFFF99";} else { $color = "BGCOLOR = #FFFFFF";} ?> <tr> <td class="report"> <? echo $model;?> <td class="report"> <? echo $product;?> </td> <td class="price"> <? echo number_format ($price,2,'.',',');?> </td> <td class="price"> <? echo number_format ($special,2,'.',',');?> </td> </tr> <? $i++; } while ($table = mysql_fetch_array($records)); } ?> Thanks for any pointers!
  15. I have amended the Catalog Listing contribution http://www.oscommerce.com/community/contributions,2795 to show model number and special pricing, along with the product name and regular price. It returns just fine in my browser with one small problem... ONLY the items that have a special price are included. Can anyone describe to me how I would amend the query so that it returns all items, wheter or not they have a special price? The current query is: <?php $qry = "select distinct c.categories_name, pd.products_name, pd.products_description, p.products_model, p.products_price, s.specials_new_products_price, p.products_image, m.manufacturers_name" . " from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s, " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m" . " where p.products_id = pd.products_id and p.manufacturers_id = m.manufacturers_id and p.products_id = pc.products_id and p.products_id = s.products_id and pc.categories_id = c.categories_id AND c.language_id = '" . (int)$languages_id . "' and pd.language_id = '" . (int)$languages_id . "'" . " order by trim(c.categories_name), m.manufacturers_name, trim(p.products_model) asc"; $records = tep_db_query($qry); $num_records = tep_db_num_rows($records); ?>
×