Contributions

Features (Category Index)
Search: 

New Low Price

The contribution displays 'New Low Price' in the Product Info screen, and shows the old price struck out next to the new price (like specials) in a product list.

This happens

a. After you adjust a price downwards by more than a defined percentage

b. for a defined number of days after the price adjustment.

All credit to those that have gone before.

This is my first contribution, so 'all care, no responsibility'!

Expand All / Collapse All

New Low Price V1.1 21 Mar 2006

Corrected syntax error in install.txt directions:

====================================================================
7. catalog/index.php

Several places, $listing_sql is constructed.

Where you find "p.products_price,"

add right after the comma, (delete quotation marks below)

"p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL ".NLP_DAYS." DAY)) nlp_expires,"
======================================================

>>>>> added a closed parenthesis:
UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL ".NLP_DAYS." DAY) nlp_expires,"
======================================================

discussion here:
http://forums.oscommerce.com/index.php?showtopic=198228&hl=

New Low Price Quentin Bennett 12 May 2005

Note: Contributions are used at own risk.