Community Add-Ons

changed a lot of code for this version, so be careful when installing it and don't forget to backup.

Changed: the main file to look more like the "advanced_search_result.php" file (code point of view).
Changed: As a result, the background image used (top right corner) is the same as advanced search, this was not necessary but I found it more logical than the one used for new products. So I left it.
Added: As a result, shop by price now take into account the special prices
Added: Also as a result, if you are using the "display prices with tax" feature of osCommerce, this should also work well now.
Added: Support to make it work with the contribution: "Product Listing in Columns" (this can be removed)
Fix: The prices chosen should display correctly in the title (some people had problems with that).
Changed: As a result price ranges does not work exactly the same but this was necessary to fix the "display prices with tax" feature.

more details in the package

- Added French Translation : the one done by someone else before was in fact in english in the pack
- Changed : to be more coherent, the position of
define('FILENAME_SHOP_BY_PRICE','shop_by_price.php');
has been changed.
- Optional : easy way to display the Box Heading (this was already possible in the glassraven's package, just not explained).

This is a complete package

Edit two files:-

catalog/includes/boxes/shop_by_price.php

catalog/includes/languages/english.php

Note: the download file is not a zip file but a text file renamed to zip!

Voici la traduciton française du fichier shop_by_price.php

(A copier dans le répertoire : /catalog/includes/languages/french/)

-----------------------------------------------------------

Here is the french translation of the file shop_by_price.php

(to install in : catalog/includes/languages/french/)


http://www.alyseeinformatique.com

Sébastien MONACO

Version 2.4 allows you to select from a dropdown list format or text list style format.

Installation document updated to be easier to follow.

Full Package included.

Modified the query in order to have the sort by weight and product model being displayed when activated in teh product listing options.

This is a full package

The price ranges were not displayed in the selected currency, only the symbol was. This has been fixed in this version: a customer select Yens will now see the price ranges in yens, and not the 20, 50, 100 ranges. Creating new ranges is also easier, using less code.

This is a
solution.
Search for this and follow the rules:

/*
Warning by Sylvio Ruiz in 02/02/2006
You need define what fields will show in page result using // to hide a
field.
Don't forget what the last field can't have "," at the end.
Edit the number to modifiy a display order.
All possible fields are listed below:
*/

$define_list = array(
'PRODUCT_LIST_IMAGE' => 0,
'PRODUCT_LIST_MODEL' => 1,
'PRODUCT_LIST_NAME' => 2,
'PRODUCT_LIST_MANUFACTURER' => 3,
'PRODUCT_LIST_PRICE' => 4,
'PRODUCT_LIST_QUANTITY' => 5,
'PRODUCT_LIST_WEIGHT' => 6,
'PRODUCT_LIST_BUY_NOW' => 7
);

Best Regards;

Sylvio Ruiz


To view witch column you want. Tks Sylvio !

spanish (es_ES) translation of this info fox.

translation done by me.
---spanish---

traducción al español (es_ES) de este infobox.

Release: Shop By Price v2.2.1

This is a small modification for this wonderful contribution to work with osCommerce MS2.
All credit goes to the original developer: Matt Davies.

New Feautures in Shop By Price v2.2.1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Fixed: Update Translation for Germany;

New Feautures in Shop By Price v2.2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

New Feautures in Shop By Price v2.1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Fixed: Problem with "breadcrumb";
Fixed: Problem with of table header;
Added: Text for empty queries with information;
Added: Capacity for new ordinance of registers through click in the top of the columns;
Added: Translation for Portuguese of Brazil;

New Feautures in Shop By Price v2.2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Added: Translation for Germany (Thanks to Kornie);
Added: Prices are displayed in infobox with the respective currency,
using "symbol_left" and "symbol_rigth" of TABLE_CURRENCIES (Thanks to Kornie for idea);
Added: PageHeading with information of range value;
Added: Conversion of values before the query,
what it allows to show correct result independent of the currency standard.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

-> HowTo in zip file.

Translations for others languages will be coming well, specially to spanish.
Please send translations unpacked to: sylvioruiz@ibest.com.br

Thanks for all contributors, specially to Brian Gallagher for your "Simple Template System - STS",
OsCommerce Team and Kornie.

Sylvio Ruiz
sylvioruiz@ibest.com.br
Salvador - Brazil
10/12/2005

Release: Shop By Price v2.2

This is a small modification for this wonderful contribution to work with osCommerce MS2.
All credit goes to the original developer: Matt Davies.

New Feautures in Shop By Price v2.1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Fixed: Problem with "breadcrumb";
Fixed: Problem with of table header;
Added: Text for empty queries with information;
Added: Capacity for new ordinance of registers through click in the top of the columns;
Added: Translation for Portuguese of Brazil;

New Feautures in Shop By Price v2.2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Added: Translation for Germany (Thanks to Kornie);
Added: Prices are displayed in infobox with the respective currency,
using "symbol_left" and "symbol_rigth" of TABLE_CURRENCIES (Thanks to Kornie for idea);
Added: PageHeading with information of range value;
Added: Conversion of values before the query,
what it allows to show correct result independent of the currency standard.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Translations for others languages will be coming well, specially to spanish.
Please send translations unpacked to: sylvioruiz@ibest.com.br

Thanks for all contributors, specially to Brian Gallagher for your "Simple Template System - STS",
OsCommerce Team and Kornie.

Sylvio Ruiz
sylvioruiz@ibest.com.br
Salvador - Brazil
10/12/2005

Small modification: Prices are displayed with the respective currency. Added german language file.

This is a small modification for this wonderful contribution to work with osCommerce MS2.
All credit goes to the original developer: Matt Davies.

New Feautures xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Fixed: Problem with "breadcrumb";
Fixed: Problem with of table header;
Added: Text for empty queries with information;
Added: Capacity for new ordinance of registers through click in the heading of the columns;
Added: Tanslation for Portuguese of Brazil.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Translations for others languages will be coming well, specially to spanish and deutch.
Please send unpacked to: sylvioruiz@ibest.com.br

Thanks for all contributors, specially to Brian Gallagher for your "Simple Template System - STS" and OsCommerce Team.

Sylvio Ruiz
Salvador - Brazil
08/12/2005

Hi All, just another minor change to the /catalog/shop_by_price.php to include query for WEIGHT and QUANTITY.

Well done to Matt Davies and everyone else who have contributed to this great little infobox!

Best Regards,
AA
www.mrgadget.com.au

- Same as previous, but with a $breadcrumb fix.

This is a bugfix release for shop_by_price.php. SQL error that you get when you click on the shop _by_price.php

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

select count(*) as total from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '4' left join specials s on p.products_id = s.products_id where p.products_status = '1' and


All credit goes to the original Author: Matt Davies

This revision will address the SQL error that you get when you click on the little arrow "more" link in the infobox header. Also, it will fix the table headers on the shop_by_price page.
******************
*****************
****************
All credit goes to the original Author: Matt Davies for this great contribution. Thanks.

Regards,

Ray Chinoy

This didn't install smoothly on MS1 at first - I forgot I had altered some of my files.

This fixes this install problem

This infobox lets the shopper select from a price range in an infobox. Its ideal for a gift shop type application.

At present it has only English language files.

It is built on MS1.