when I go to manually add coupon usage, the coupon that I manually created does not appear in the drop down box, any ideas why?
manually add history of use not working
- Yes, I too was able to reproduce the problem. This will be fixed in the next version but for now, here is a solution:
in www/administrator/components/com_awocoupon/models/usershistoryentry.php, around line 55 is this
WHERE published=1 AND function_type2!="parent"
change it to this
WHERE published=1 AND (function_type2 IS NULL OR function_type2!="parent" )
- Hi Seyi,
thanks for the quick reply, this has solved the problem with regard to being able to select a manually entered gift voucher, but now I have a different problem concerning the scenario of my client having an over the counter shop.
Lets say that the coupon is used by someone who has not set up an online account, currently the History Of Uses Form checks to see if a valid username has been entered by looking up the username in #__users. How do you think we can overcome this? What about having a checkbox saying 'Unregistered User' or something like that, so as the script knows to by-pass the user Id lookup? Ahh, but you only store the user_id, not the username so that won't work!
- Okay I've come across another issue regarding data entry.
I have a Gift Certificate (Id=1, coupon_code=qwerty1234) with a value of £50
I go to history of uses form and enter the following:
Coupon Code: qwerty1234
Username: philip butler
Discount (Product): 20.00
Discount (Shipping): NULL
Order Number: NULL
Click Save and the record is saved and appears under the 'coupons' heading on the History of uses page but there is no date in the Order Date column (when you query jos_awocoupon_user_uses there is a valid timestamp against the new record)
When you go to the Coupons page, it does not show a summary of the number of uses and the Asset (which I assume is the current value of the Coupon) shows as --
- I've modified line 75 of administrator\components\com_awocoupon\views\usershistory\tmpl\default_coupon.php
echo !empty($row->cdate) ? date('Y-m-d',$row->cdate) : ' ';
echo !empty($row->cdate) ? date('Y-m-d',$row->cdate) : $row->timestamp;
so if the coupon was manually entered without an online order it shows the date the manual entry was made. I know this will go a bit wierd if the client sorts by this column, but that's a minor inconvenience.