Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution Update] All Prods v2.4


Farrukh

Recommended Posts

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?

Link to comment
Share on other sites

  • 2 years later...
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.

Nina

Link to comment
Share on other sites

  • 9 months later...
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?

Link to comment
Share on other sites

  • 1 month later...

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. :'(

Link to comment
Share on other sites

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!!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...