Search the Community
Showing results for tags 'sale'.
Found 2 results
Resolved - Setting a Sale Price produces errors
[email protected] posted a topic in Technical Helpsetting a sale price i get hundreds of system errors: - all the same error logged a few minutes apart. and a similar thing happens when i enable Global percentage discount, so i have switch them off. Is there just a setting i have wrong? File: [gui.class.php] Line:  "SELECT `product_id`,`description`,`name`, `price`-`sale_price` AS `saving` FROM `cc5CubeCart_inventory` WHERE `price` > `sale_price` AND `sale_price` > 0 AND `status` = '1' LIMIT " - 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 Thanks
Stop coupons being applied to sale items
Guest posted a topic in Technical HelpHi all I've set up some coupons to give a 10% discount. But I don't want these to apply to sales items otherwise I'll be out of pocket. Is there a way of stopping coupons applying to sales items? I know you can assign products to coupons but I have nearly 400 products and several coupons so this isn't ideal. Any help much appreciated. Thanks