lian8 Posted July 25, 2005 Share Posted July 25, 2005 I've installed the 2.71 version. Everything seems to be ok but I do have one problem. I have some of my products in more than one category. So when I use this feature, the product is listed several times e.g. if one product appears in two different categories, the list shows 2 separate products (when in actual fact, it is the same product). Is there a way to stop it from listing the same product more than once? Quote Link to comment Share on other sites More sharing options...
carromex Posted September 23, 2007 Share Posted September 23, 2007 Hi again !I don't know if someone told but you wont see all product if one exist without a category describing it Take care :( How do I do that ? How do I have a category describing it and where ? My page http://www.carromex.com.au/applications/os...b32ca2c9294de72 is coming up, but only a to z and full are coming up, with nothing inside them. Quote Nina Link to comment Share on other sites More sharing options...
metntnt Posted June 28, 2008 Share Posted June 28, 2008 Ok, here's the fix... The bold lines are the ones I added... $duplicates = array(); $languages_query = tep_db_query("select languages_id, name, code, image, directory from " . TABLE_LANGUAGES . " order by sort_order"); while ($languages = tep_db_fetch_array($languages_query)) { $languages_array[] = array('id' => $languages['languages_id'], 'name' => $languages['name'], 'code' => $languages['code'], 'image' => $languages['image'], 'directory' => $languages['directory']); } for ($i=0; $i<sizeof($languages_array); $i++) { $this_language_id = $languages_array[$i]['id']; $this_language_name = $languages_array[$i]['name']; $this_language_code = $languages_array[$i]['code']; $this_language_image = $languages_array[$i]['image']; $this_language_directory = $languages_array[$i]['directory']; echo " <tr>\n"; $products_query = tep_db_query("select p.products_id, p.products_model ,pd.products_name, p.products_thumbnail, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name"); $products_array = array(); while($products = tep_db_fetch_array($products_query)) { $id = $products['products_id']; if( !isset( $duplicates[ $id ] ) ) { $duplicates[ $id ] = true; $products_array[] = array('id'=> $products['products_id'], 'name' => $products['products_name'], 'image' => $products['products_thumbnail'], 'manufacturer' => $products['manufacturers_name'], 'price' => $products['products_price'], 'tax' => $products['products_tax_class_id'], 'special' => $products['specials_new_products_price']); } } Hope this helps. BTW, the duplicates add relevance to your page & site. I just got spidered by Google & I got ranked as #1 for the products that I had duplicated on my allprods page. e.g., http://www.google.com/search?hl=en&lr=...G=Google+Search But, I still put in the duplicates fix. I'd rather have a professional looking site. This looks like exactly what I need but cant figure out which page I edit this on... I've been searching this thread for several hours. Can youtell me what page this is supposed to go on? Quote Link to comment Share on other sites More sharing options...
paid4real Posted July 28, 2008 Share Posted July 28, 2008 Hello everyone! I can't seem to figure this out. I am using Download_Controllerv5.3b_MS2.2_2 and osCommerce_PayPal_IPN_v2.3.3 and my problem is that when I order two digital products from my store, and am returned back to my website for product download, only one link is downloadable but both products show up as files to download. I will always have one product with the download button and the remaining product with no button and no link for it. I am going crazy trying to figure this out. Any help would be gladly appreciated. :'( Quote Link to comment Share on other sites More sharing options...
paid4real Posted July 29, 2008 Share Posted July 29, 2008 Nevermind! My human error as I originally thought...just couldn't find it. My own Error: the product that did not have the link for download after purchase made had the file extension missing, as in ("filename") when it should have been (filename.zip) So if you experience anything similar, don't forget to check the filename of your product. Anyways, thanks if anyone looked for me. finished my site so check it out whenever you can youbestproduct link in signature. Thanks osCommerce for a great product and AlexStudio for the super download shop contribution!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.