Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mr_dimsum

Members
  • Content count

    19
  • Joined

  • Last visited

Profile Information

  • Real Name
    Danny Tam
  1. Even before my store is launched, it will be looming with more than several hundred products. Since it is mainly about Toys, CD's, DVD's, it is logical to list them by letter. What I mean for example is, when a customer clicks on for example, the DVD Category, it would be ideal to list them by alphabet letter, instead of page no's. Here's more in depth with what I mean: For the film, Lost in Translation, if a customer would be in the DVD section, he'd have to scroll to page 25 to find it. Whereas, if it were sorted and listed by Letter, he/she could simply click on L, and scroll through a much more condensed list of all "L" letter titles. I've checked around and can't seem to find much information on this.. Hopefully somebody can give some insight. Regards, Danny
  2. mr_dimsum

    Reviews on Product Info Page v1.0

    Anybody know what is necessary to get the reviews count appearing on the index page with the code inserted into the modules/products_reviews_info.php file? Reason for this is because I'd like to integrate it in between the 'Read All Reviews' and the 'Write a review' links.
  3. Actually, the pics still do work, however, there is still the huge gap. thanks! seems like it was just my site loading slow. =)
  4. Hey Todd, The following didn't work out. It is still persisting to do the same thing. The following is the code I have below. Take a gander and lemme know if there's something I'm missing out on or not doing properly.. Or perhaps you have an alternative method to alleviate the problem. UPDATE: Update checking out the site, my pictures have actually disappeared with this add-on. // BOF: More Pics 6 if (MOPICS_TABLE_LOCATION=='below' && !empty($mopics_output)) { echo ' <br> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="center" class="smallText">'.$mopics_output.'</td> </tr> </table>'."\n"; }
  5. mr_dimsum

    Product Description 1.3

    i have no prob putting it in products_new.php, but new_products.php is giving me trouble.. can u suggest anything.. it seems to be giving me some type of conflict with my spcial prices module i think. here is my code from new_product.php $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
  6. This is a great contribution... Got it working with my moddoed osC without any problems.. But there is a slight little problem I have.. On my product pages, the space reserved for More Pics 6 is still there, regardless whether I have more than one picture or not.. This becomes a bit problematic because I have a reviews section right under More Pics 6. There is a huge gap between the product description and the reviews section if I don't have additional images or no images at all. Regards, Danny
  7. mr_dimsum

    Product Description 1.3

    i'm having some problems with this.. i am getting conflicts with some of my existing code.. can anybody propose a solution? below is enigma1's suggested coding to use the short description on the new_products.php page.. at the bottom is mine pulled from new_products.php. my code: $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
  8. mr_dimsum

    Product Description 1.3

    The contribution installed great.. However, I noticed that it always has to be shown underneath the Product Name. I've tried to mix and mingle with product_listing.php, but nothing seems to really work out of it - at least with my knowledge and skill level. For my site, we are using a list view mode and have incorporated it, however, we would like the Manufacturer Name and also the price right underneath the Product Name before it hits the description. Below is a photo provided as an example mocked up in Photoshop: Any type of assistance is greatly appreciated. A big thank you in advance!
×