Do you Have My Printable Catalog?

[Guest]

Hi All!

 

We're working on a bug in Add a Printable Catalog V1.1. If you have it installed WITH mulitple languages enabled, please respond here with the number of languages you are using and the version of OSC (snapshot date, pre or post November).

 

Thanks !!!

[livefooduk]

Hello I have tried your Printable Catalog but am only using 1 language.

 

It could be very good but for some reason it is listing all product twice and some products 3 times. I am using a late November snapshot and have made a few changes including Linda's Quantity controller 5.1 so maybe that is the cause.

[Guest]

Hi Steve!

 

That's very interesting. So far, I know of several others that have the catalog installed and they are having trouble with repeats but, the only thing they seemed to have in common was multiple languages.

 

Are any of your products in more than one category?

[livefooduk]

Yes there are a few, and on closer inspection it seems to be listing some of the same products 4 times and these are the ones that are in 2 catorgories and all the rest it is listing twice.

[livefooduk]

Quick update:

I have been messing around with the code (don't really known what I am doing :( )

So I changed in catalog/print_catalog.php

 	 TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id=p2c.products_id left join

	 " . TABLE_CATEGORIES . " c on p2c.categories_id=c.categories_id left join " .

	 TABLE_CATEGORIES_DESCRIPTION . " cd on c.parent_id='0' and

	 c.categories_id=cd.categories_id 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 = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on

	 p.products_id = s.products_id where products_status = '1' order by

	 cd.categories_name, c.parent_id, c.sort_order, c.categories_id,

	 pd.products_name";

To this:

 	 TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id=p2c.products_id left join

	 " . TABLE_CATEGORIES . " c on p2c.categories_id=c.categories_id  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 = '" . $languages_id . "' where products_status = '1' order by

	 c.sort_order,  pd.products_name";

and now it only repeats the products that are in more than one catorgory.

:D

[Guest]

We're working on a bug in Add a Printable Catalog V1.1. If you have it installed WITH mulitple languages enabled, please respond here with the number of languages you are using and the version of OSC (snapshot date, pre or post November).

 

hello,

 

Yes, i got and use it

 

i think the problem comes from :

 

cd on c.categories_id=cd.categories_id and c.parent_id='0' left join

in catalog/print_catalog.php

 

actually products seem to be sorted by categories_id

 

when i take " and c.parent_id='0' " off, it works, i mean products are sorted by categories_name, but the same product is present four times (four languages !)

 

... but i can't solve it even if i would like

 

charles