Support for Discount Coupons by Burt
Posted 25 May 2009 - 21:28
im using ot_discount_coupon_codes_3_33
Posted 20 July 2009 - 14:56
Any tips on getting this to work with Express Checkout? (the one where you click the PayPal express checkout button _instead_ of the Continue button on checkout_payment.php)
Did you find a solution to this at all?
I have the coupon box on the same page as the payment details (PP Direct and PP Express) and if the yellow Express button is clicked the customer is taken to PayPal and the coupon discount is not applied.
Thanks anyone for any advice,
Posted 23 September 2009 - 21:44
1366 - Incorrect decimal value: '' for column 'value' at row 1
insert into orders_total (orders_id, title, text, value, class, sort_order) values ('25', 'Coupon (Sportscar)', '-£1.60', '', 'ot_coupon', '4')
This was working before. Have I put the code in the wrong place?
Posted 04 November 2009 - 23:09
are add ons
and "coupon version 5"
all the same contribution?
If they are all the same, the latest version I can download is V1.2. /blush.gif' class='bbc_emoticon' alt=':blush:' />
Where can I find the latest version? I have a site already up and running that my admin will change.
Edited by BertaRecchia, 04 November 2009 - 23:09.
Posted 07 December 2009 - 21:12
Installed v1.2 of this contribution and it works like a charm, exactly what I needed - the one tiny fly in the ointment seems to be integrating with the SagePay Form Module (v1.2).
For some reason the discount amount shows as £0.00.
For example, the checkout_confirmation page shows...
Coupon (30PERCENT) -£2.25
Royal Mail 1st Class Standard: £1.62
Yet the SagePay payment pages, emails and transactions all show...
Coupon (30PERCENT) £0.00
Royal Mail 1st Class Standard: £1.62
I have tried various settings and Order Total Module sort orders - all give the same result.
The bottom line is correct so no-one is being overcharged and I can live with it for now.
SagePay support say that their logs show the Coupon amount being passed to them is £0.00 but I don't know how to fix this.
I suspected the payment module and I have tried the forum for the SagePay module but to no avail - can anyone shed any light on this?
If it helps I am also using the QTPro and UK Royal Mail & Overseas Shipping Methods contributions.
Apologies in advance but I'm a total numpty when it comes to PHP!
Posted 08 December 2009 - 17:16
I may be barking up completely the wrong tree here but I have noticed that there is no colon (' : ') generated between the Coupon title and the amount (see my post above for examples).
All the other amounts have this and I was led to believe that SagePay use the ' : ' sign as a seperator between each field.
Could be a red herring but how would I insert this in to the code to test it?
Posted 16 December 2009 - 03:56
Just wanted to thank you for the contrib. Works as advertised on PHP5.3/mySQL 5/latest from Github and will save me some hair pulling over the other CCGV contribs at the moment.
Posted 22 December 2009 - 20:07
I have been spending the evening reading through this topic but haven't find the correct answer yet.
It's probably a known one but:
I get the opportunity to create coupon codes just fine.
I can enter them on the checkout.
On the checkout confirmation page it is not deducted however, if I take a step back and go forward again, it deducts itself just fine.
I have adapted into the order-total module:
$this->output = array('title' => TEXT_COUPON . ' (' . $_SESSION['coupon_code'] . ')', 'text' => '-' . $currencies->format($coupon_discount, true, $order->info['currency'], $order->info['currency_value']), 'value' => $coupon_discount);
But this didn't solved my problem.
I installed the latest version available onto the site.
Someone out there who might have a brilliant input on this one?
Posted 23 December 2009 - 13:40
I'm going to take another swing at it tonight, as I was using a code-base that had another couple non-fucntional discount pieces added. I've reverted to clean code now.
My issues with the previous attempt were:
Admin side did not display properly. The top banner and part of the side boxes displayed, but only a few. Probably an issue with incorrectly adding code to the customers.php file. When i removed that change, I got these menus, but I noticed the module name did not display correctly in the modules list.
On the user side, I'm assuming I added the code wrong as one of the checkout pages was drawing weirdly, too.
Posted 18 April 2010 - 16:35
1146 - Table 'db318685302.coupons' doesn't exist
select count(*) as total from coupons
Ive double checked everything and can't see anything wrong. I was wondering if anyone else had an idea I could try at all. Would it help if i posted my customer.php page from Admin??
Thanks Alix /smile.gif' class='bbc_emoticon' alt=':)' />
Posted 21 May 2010 - 20:51
I am totally new to osCommerce and I'd like to ask a question.
I would like to send my customers a promo code by email and have them enter this code on the order page. Can this add-on enable a customer to enter a promotional code?
Thank you for any help.
Posted 28 February 2011 - 12:02
I do have some php/mysql knowledge so if you can point me in the right direction I think I should be able to code it myself. Any help is appreciated! Thanks!
Posted 15 July 2011 - 21:56
I installed the contribution and I seem to have killed the checkout_payment file,
If I remove the coupon code the page loads just find, but No Matter Where I paste it into the checkout_payment.php I just get a blank page.
Anyone willing to tell me the secret on where I'm supposed to put the code?
Thanks in advance, I'm going slowly nutz here /tongue.gif' class='bbc_emoticon' alt=':P' />
Posted 03 March 2012 - 16:04
I have just installed this contribution on my website and it seems to work well, however, as I am in the UK there is a problem with the TAX (VAT amount).
It seems to be working the tax ( UK VAT ) out based on the original amount of the items before the discount was applied. Everything else is fine.
Sub-Total (Inc VAT): £114.03 (Correct)
Voucher - 10% Discount (gdx45t10) -£11.40 (Correct)
Standard Delivery (Inc VAT) 13.079 kg(s)): £7.99 (Correct)
Total (Inc VAT): £110.62 (Correct)
UK VAT 20% (included in price): £20.34 (Wrong - Should be £18.44).
In the UK - we have to show our prices with tax (VAT) included on our stores and if a discount is applied to an order, we have to charge the VAT on the new amount (after discount) - not the original amount. Therefore the VAT amount of £110.62 Including VAT should be £18.44.
Maybe I'm doing something wrong. I can't be the only one with this problem?
I hope someone can help.