View Full Version : Multiple Sales Per Product

09-10-2009, 04:11 PM
Fixed a bug in the sale_prices.php file. When searching for a different product if only one match was found it didn't correctly switch to that product. Also fixed finding multiple instances of the same product when products exist in more than one category.

Major changes have been made to the installation instructions for the catalog/index.php, catalog/advanced_search_results.php, catalog/includes/classes/split_page_results.php and catalog/includes/modules/product_listing.php files. As originally written the SQL queries worked fine on our test site with only a few products and sale prices. However on our actual web site with over 11,000 different products and almost 3,600 defined sale prices the queries slowed the web site down tremendously. As originally written the queries sorted the entire list of sale prices every time a category was accessed or a search was made. The rewritten queries in the updated instructions now only sort the matching results and therefore work MUCH faster. If you have already installed this contribution I highly recommend that you change your install using the new instructions.

Added an instruction for those using the Dynamic Sitemaps with XML Sitemaps contribution to correctly generate the XML site map for specials.

Complete package attached. Only the instructions and the admin/sale_prices.php files have changed.

More... (http://addons.oscommerce.com/info/6944)