Community Add-Ons

First install v. 4.7

Edit catalogallprods.php

Find (line 143)
$listing_sql = "select p.products_id, products_weight, p.products_quantity, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p 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";


And replace with this.

$listing_sql = "select p.products_id, products_weight, p.products_quantity, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p 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";

This is just an fix...

It is now possible to use the sortorder the way it normally works. In standard product listing you can click on the tableheadings to select the sortorder of your choise.

For everyone that is having the 'p.products_sort_order' problem, you need to replace catalog/allprods.php with this one. It does not have the sort order included.

Update only

Sorry for got to add the define in the languages files. Corrected.

Full Version

Added the proper method to allow the All Products link to show in the header along side Cart etc. The link will conform to your stylesheet settings.

Full Version included

* Fixed an error wich made the products quantity and weight not show in the standard product listing.
* The products now appear sorted after descending quantity.
* Modified the "FULL link" in the Alphabetical row to not show "FULL" but the header title instead (wich for example in english is "All Products".

This is a full version.

Add polish language.
###############
Dodano język polski

This makes the numeric names mod compatible with hidden products. The previous version showed all products disabled or not.

This is a small change to one single file to add numbers to the All Product page so that product names starting with numbers can be a separate category. If your site does not have numerical product names, then you do not need this contribution.
It is based on All Products V4.4 by Jack_mcs

GemRock

New Languages Are addet (Danish)

Combined all languages in one file.

Included are:
danish
dutch
english
espanol
french
german
italian
portuguese

Support@
http://forums.oscommerce.com/index.php?showtopic=57574&hl=allprods

Combined all languages in one file.

Included are:
english
german
spanish
dutch
italian
french
portuguese

Support@
http://forums.oscommerce.com/index.php?showtopic=57574&hl=allprods

Added Dutch file in: includeslanguagesdutchallprods.php

Combined all languages in one file.

Included are:
english
german
spanish
dutch
italian
french

COMPLETE package.

Changed nothing in the other files, only added dutch language file of allprods.php in includeslanguagesdutch

Support@
http://forums.oscommerce.com/index.php?showtopic=57574&hl=allprods

For those in need of an Italian translation, simply download this file, allprods.php, and upload it to your (catalog)/includes/languages/italian/ folder. All translations done by Isabella. Thank you!

This package contains only the allprods.php file for the languages/italian/ folder, and nothing else.

This is NOT a complete package!

Oups! There was a typo in the name of a sub-directory.

Same file, but with this error corrected. Forget the previous file.

--------
Added the Spanish language file.
No further code modification.

Updated the instructions in the readme text relating to that.

Included are the English, French, German and Spanish versions, in the multilanguage friendly All Products.

Added the Spanish language file.
No further code modification.

Updated the instructions in the readme text relating to that.

Included are the English, French, German and Spanish versions, in the multilanguage friendly All Products.

Small changes permitting All Products to be multilanguage friendly.

There is no more English text embedded in the code, but instead some variables in the different language files, which then permits this contribution to fully support different languages.

Included are the English, French and German versions.

Changes were made the .sql file, updated configuration_id values in the configuration table to a less commonly used value. Also fixed configuration_group Visable value to 1 instead of 2, the "all Products" was not appearing in the admin configuration box, because the visable value was set to 2. Also added change log.

There were only bug fixes, full credit goes to original authors.

J'ai juste traduis en français cette contrib. Elle a été testée autant sur php 4 que php 5 ms2. Je débute alors soyez indulgent. En tout les cas, ça fonctionne sans problème pour moi. Le dossier est complet. N'oubliez pas de faire un backup de vos fichiers avant de l'installer. Voici ce que ça donne: http://www.nautil.ch/allprods.php

Fixed problem with showing "hidden" products

Same as the last version, except it includes instructions for the last step which had been omitted. This had caused confusion for many people on the boards.

* Fixed code for alternate display so that it recognized other product settings like model number.
* Fixed problem with alternate dislay in which specials were not displaying properly.
* Added a FULL link to the Alphabetical row.

This is a full version.

The support thread is at http://forums.oscommerce.com/index.php?act=ST&f=7&t=57574

added the last update and changing the id$ naming in php.file - full package

To correct the table heading from showing in the all products listing.

Included the /includes/languages/english/allprods file

- Added A to Z display
- Added optional display mode controlled by admin setting
- Changed code to have all products code use the existing product listing code for a more uniform appearance. This allows for easier control of what colums are displayed and aslo adds a page split option.
- Removed the extra allprods_model.php file
- Image height was not being displayed correctly
- Added specials date bug fix by Michael Hopfengaerter

This is a full release.

Support thread is at
http://forums.oscommerce.com/index.php?showtopic=57574&st=20

Fixed problem with includes/boxes/categories.php.

To upgrade, just copy that file.

This is a full version.

There's bug in the sql statement.
It does not respect the expires date of a spezial offer.

That is the way to fix it:
1) open file allprods.php
2) search for 'on p.products_id = s.products_id'
3) replace ist with 'on p.products_id = s.products_id AND TO_DAYS(s.expires_date)>=TO_DAYS(NOW())'

Thats it.
I changed that constribution so that i can use it multilingual with a standars MS2.2 (no other constributions). If anyone is interested please write me an eMail.

Thanks to all :-)

Fixed the problem with All products being turned off with other admin changes

Fixed code error where image was being displayed. The arguments for the
tep_image call were out of order and too numerous.

Replaced non-existant All Products class in allprods.php with class main.

Removed unnecessay files and instructions

Added define to make it work without Header Tags (not recommended for best results)

Combined the sql files

This is a small fix to the product listing heading because the column names did not line up with the data.

Removed the c.categories_status sql query which was causing errors for those who have not installed ' Enable & Disable Category Mod '

Changes made to display :
* Compatible with Milestone MS 2.2
* Displaying Images for every product
* Addded the ability to change the Image width and height from the Admin Section ( Admin => Configuration => Images => All Products * )
* Display Manufacturer's Name
* Displays Both Retail and Discount Price
* Implemented it with Header Tags Controller ( You need to have Header tags Controller installed for this)
* Ability to Turn On or Off through Admin

Discussiong here:
http://forums.oscommerce.com/viewtopic.php?t=57574