View Full Version : Multiple Sales Per Product

02-27-2010, 06:15 PM
Added a new file to this contribution that allows you to set sale prices on multiple items at once. Sale prices can be set as an amount, as a dollar reduction, or as a percentage discount. Products can be found using any combination of keyword, category, manufacturer or regular price. This file also makes use of the named sale feature. You will be presented with a list of matching products showing you the regular price and the new sale price. You can then deselect any unexpected finds that shouldn't be put on sale before committing all of the new sale prices to the database.

All of the other files have been updated slightly as well. Empty dates that designate that a sale has no beginning (or ending) date are now saved as NULL in the database rather than as 0000-00-00 00:00:00. Sale prices are now rounded to the maximum number of decimal places allowed by the default currency to prevent unexpected totals when multiples of a single product are ordered. You may choose the number of decimals of rounding when using sale_prices.php and multi_product_sale_prices.php. (For example: Using US dollars a sale price calculated to be 1.3333 would display as $1.33 in the catalog but add up to $2.67 if two were ordered. You would now round this to the nearest $1.00, $0.10 or $0.01 automatically.)

If updating from an earlier version copy all of the admin and languages files from this version over your older version files and then perform instructions 7, 8 and 9 of the install (noting that only the last line added by each instruction is new).

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