Jump to content

GraemeN

Members
  • Content count

    8
  • Joined

  • Last visited

Profile Information

  • Real Name
    Graeme Nelson
  1. GraemeN

    MATCHING PRODUCTS CROSS-SELL

    Thanks, but it's Keith W.'s contribution - I just posted an update / suggestion. I agree, great contribution - Thanks to Keith! Regards, Graeme
  2. GraemeN

    MATCHING PRODUCTS CROSS-SELL

    Yes, I agree. The SKU is still shown in the pop-up and you must enter the SKU to identify matching products. Displaying the product model only helps you find the right SKU.
  3. GraemeN

    MATCHING PRODUCTS CROSS-SELL

    To show the product model in the popup you could edit admin\popup_product_id.php as follows: Line 29 - change $products_list_query = tep_db_query("select pd.products_name, p.products_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where pd.language_id = '" . (int)$languages_id . "' ORDER BY pd.products_name"); to $products_list_query = tep_db_query("select pd.products_name, p.products_id, p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where pd.language_id = '" . (int)$languages_id . "' ORDER BY pd.products_name"); After line 59 <td align="left" valign="top" class="dataTableContent"><b>Product Name</b></td> insert <td align="left" valign="top" class="dataTableContent"><b>Model</b></td> After line 69 echo '<tr class="dataTableRow"><td align="left" valign="top" class="dataTableContent">' . $products_list['products_name'] . '</td>'; insert echo '<td align="left" valign="top" class="dataTableContent">' . $products_list['products_model'] . '</td>'; If your descriptions are long you may need to change the table width (line 55 of this file) and the width of the pop-up, defined in admin/categories.php, search for <script type="text/javascript"> function openSKUpopup(popurl){ var winpops=window.open(popurl,"","width=450,height=500,scrollbars=1,resizable=1,top=0,left=0") }
  4. GraemeN

    MATCHING PRODUCTS CROSS-SELL

    Minor bug repair to fix this - in admin/popup_product_id.php find line 31: $products_list = tep_db_fetch_array($products_list_query); and delete this line (or add // to comment out the line).
  5. GraemeN

    MATCHING PRODUCTS CROSS-SELL

    You must be using a different contribution - this thread is about the Matching Products Cross-Sell contribution by 'homewetbar' from this link: http://www.oscommerce.com/community/contributions,5347. It does not include the admin page that you show. You should search for the thread for the contribution you used. Sorry I'm not more help...
  6. GraemeN

    MATCHING PRODUCTS CROSS-SELL

    Thanks for the contribution - just what I was looking for. I added v1.1 which uses the standard content box format on product info page compatible with STS template, ensuring style is consistent with template and existing style. No changes to features or to admin section. I installed it on a version of OSC 2.2RC1 with STS V4.5.4, and also checked it on a clean version of 2.2RC1. This package modifies v1.0a moving HTML output to new module matching_products.php, using the existing contentBox() function. Full package included. To show more than 3 products edit line 22 of includes/modules/matching_products.php and change ($count < 3) to ($count < 6) (for example). Products will be shown upto 3 per line. To show the products vertically, i.e. one per line edit 32 of includes/modules/matching_products and change ($col > 2) to ($col > 0). ... I haven't tried either of these changes
×