Jump to content

northshore

Members
  • Content count

    12
  • Joined

  • Last visited

  1. Hi, Thank-you for this fix.. Although I can;t find this code in my files - what is the file name that you editted to get this working??
  2. If anyone could help me with a small mod - I would really appreciate it. I am trying to add the word (taxable) after the product name in the confirmation email. Since some products in my store are taxable and some are not - it would make it easier to distiguish the products when issuing refunds. the sql field is the table that controls taxable goods is called : products_tax_class_id if products_tax_class_id = 0 (item is not taxable) if products_tax_class_id = 1 (item is taxable) I need help creating the SQL query to check this value for a product. I am thinking if i add it just before this line on checkout_process.php $products_ordered .= $order->products[$i]['qty'] . ' Case(s) ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) .$products_ordered_attributes . "\n\n"; ----- like so - it will work: SQL taxable goods query??? if products_tax_class_id <>0 $taxable = 'taxable' $products_ordered .= $order->products[$i]['qty'] . ' Case(s) ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) .$taxable. $products_ordered_attributes . "\n\n"; ----- note in abovce i added the variable $taxable to the product_ordered variable in hopes the word "taxable" will print in the sent email only for items which are taxable... If anyone can help me build this taxable goods query OR helpme mod this into checkout_process.php - I thank-you in advance
  3. Hi, I need some help with the product display. Currently when you click on a Top-Level Category it displays the featured products under that category. When I click a subcategory under the Top-Level Category it displays all the products under the subcategory. Is there any way modify the index.php file to have the Top Level Category display all the products under the subcategories instead of just a few select featured products. I'd like to leave the featured products display on the homepage as it is, but change the product selection for the Top Level Category to all products under that category. Any help with this is greatly appreciated, OSC driving me crazy as usual.
  4. northshore

    [Contribution] Extra Fields

    Hi, I am trying to display the Extra Fields in the product_listing_tpl.php file, but the contribution only gives instructions for doing this in the product_listing.php. The suggested replace line does not exist in product_listing_tpl.php. Does anyone know how to accomplish this?? Any help is appeciated. 13. Extra Fields in product listing (optional) In catalog/includes/modules/product_listings.php FIND $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> '; } break; REPLACE WITH //PRODUCT EXTRA FIELDS IN PRODUCT LISTING - BEGINING //PRODUCT EXTRA FIELDS IN PRODUCT LISTING - BEGINING //$lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . //$listing['products_name'] . '</a> '; // } // break; $extra_fields_text = ''; $extra_fields_query = tep_db_query(" SELECT pef.languages_id, 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=". (int) $listing[$x]['products_id'] ." and pef.languages_id=" . (int)$languages_id . " and ptf.products_extra_fields_value<>'' ORDER BY products_extra_fields_order"); while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) continue; $extra_fields_text = $extra_fields_text. '<font color="#000000">'.$extra_fields['name'].': </font>' . '<font color="#006600">' .$extra_fields['value'].'<BR></font>'; } $lc_text = ' <b><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a></b><br> ' . $extra_fields_text . '<br>'; } break; // PRODUCT EXTRA FIELDS IN PRODUCT LISTING - END
  5. northshore

    Product extra fields -product list

    Hi, Can someone help me with this contribution? I am trying to get the Product extra fields to show-up in the product listing. But i'm using the product_listing_tpl.php file instead of the product_listing.php file and this mod doesn't work. I don't have a code line matching what is suggested in the instructions to replace?? If anyone knows what line I should replace with the provided code I would apprec. it. working on this for hours: 13. Extra Fields in product listing (optional) In catalog/includes/modules/product_listings.php FIND $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> '; } break; REPLACE WITH //PRODUCT EXTRA FIELDS IN PRODUCT LISTING - BEGINING //PRODUCT EXTRA FIELDS IN PRODUCT LISTING - BEGINING //$lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . //$listing['products_name'] . '</a> '; // } // break; $extra_fields_text = ''; $extra_fields_query = tep_db_query(" SELECT pef.languages_id, 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=". (int) $listing[$x]['products_id'] ." and pef.languages_id=" . (int)$languages_id . " and ptf.products_extra_fields_value<>'' ORDER BY products_extra_fields_order"); while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) continue; $extra_fields_text = $extra_fields_text. '<font color="#000000">'.$extra_fields['name'].': </font>' . '<font color="#006600">' .$extra_fields['value'].'<BR></font>'; } $lc_text = ' <b><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a></b><br> ' . $extra_fields_text . '<br>'; } break; // PRODUCT EXTRA FIELDS IN PRODUCT LISTING - END
  6. northshore

    [Contribution] Open Featured Sets Support

    Hi Surfalot, Great contribution, works perfectly. Was wondering if it was possible to add "focus manufacturer", just like the featured & category focus fields, it would be great if under a specific category, only the relevant featured manufacturers are shown. Nice enhancement to target customers to view products by a given manufacturer. If there is an easy code fix to impliment this - any guidance, would be greatly appreciated.
  7. northshore

    Minimum Order per Zone

    Hi All, Anyone know if there is a Minimum Order contribution that can be configured to apply only to specific zones. ie. Minimum Order for Canada $300 Minimum Order for USA $500 Any help or guidance appreciated. Thank-you!
  8. Hi, I am having trouble setting up my shipping modules. I need 2 flat rate shipping charges: 1 for Canada/Ontario 1 for Canada/Quebec I created primary Tax Zone - Canada : clicked this folder and created 2 zones inside Ontario & Quebec But when I go to edit the Flat Rate shipping zone drop-down only one zone is shown, just the Country : Canada. It's not displaying the provinces in the drop-down. Somewhere i'm not setting something up correctly?? Any help appreciated...
  9. Thank-you this is a great contribution. Although I found a minor error - if you have subcategories and try to add a product under a subcategory, the Extra Product Fields do not show up on the Product editting page??
  10. Hi, I was wondering if a contribution exists which allows for different payment options for specific customers? I have 2 types of customers retail and wholesale. For the retail they have the option to use credit card only For the wholesale they have to option to use credit card AND manual billing (ie. pay on delivery, 14 day terms, etc.) Can I activate a specific payment module for a specific group of customers only? Thanks in advance for any direction.. Northshore
×