StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMagento - Single Coupon marked as used when payment pending
primarykey
Id
13268938
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2012-11-07T11:34:24.800
FavoriteCount
2
LastActivityDate
2014-01-19T08:13:38.040
LastEditDate
2014-01-17T13:02:05.660
LastEditorUserId
1461781
OwnerUserId
1805921
ParentId
0
PostTypeId
1
Score
15
ViewCount
3079
LastEditorDisplayName
text
Body
I have got a problem with Magento single coupon code that is marked as having been used at the time the customer clicks on the Place Order button. If the Paypal payment fails or the client leaves the page before the order is complete, he won't able to go back and re-order with this coupon which is set to be only used once, and has been marked already been used. I have found a piece of code that decreases the number of times the coupons has been used by the user and allows him to reuse the coupon. Unfortunately, he gets an error when trying to connect the Paypal page when clicking the place order button. In order to be able to use the coupon another time and access the Paypal page, I have to delete the lines in SQL database in tables salesrule_coupon_usage and salesrule_customer with this customer's ID. Here is the code I need to change to automatically delete coupon usage information for a customer ID: <pre><code>public function cancel($observer) { $order = $observer->getEvent()->getPayment()->getOrder(); if ($order->canCancel()) { if ($code = $order->getCouponCode()) { $coupon = Mage::getModel('salesrule/coupon')->load($code, 'code'); if ($coupon->getTimesUsed() > 0) { $coupon->setTimesUsed($coupon->getTimesUsed() - 1); $coupon->save(); } $rule = Mage::getModel('salesrule/rule')->load($coupon->getRuleId()); error_log("\nrule times used=" . $rule->getTimesUsed(), 3, "var/log/debug.log"); if ($rule->getTimesUsed() > 0) { $rule->setTimesUsed($rule->getTimesUsed()-1); $rule->save(); } if ($customerId = $order->getCustomerId()) { if ($customerCoupon = Mage::getModel('salesrule/rule_customer')->loadByCustomerRule($customerId, $rule->getId())) { $couponUsage = new Varien_Object(); Mage::getResourceModel('salesrule/coupon_usage')->loadByCustomerCoupon($couponUsage, $customerId, $coupon->getId()); if ($couponUsage->getTimesUsed() > 0) { /* I can't find any #@$!@$ interface to do anything but increment a coupon_usage record */ $resource = Mage::getSingleton('core/resource'); $writeConnection = $resource->getConnection('core_write'); $tableName = $resource->getTableName('salesrule_coupon_usage'); $query = "UPDATE {$tableName} SET times_used = times_used-1 " . "WHERE coupon_id = {$coupon->getId()} AND customer_id = {$customerId} AND times_used > 0"; $writeConnection->query($query); } if ($customerCoupon->getTimesUsed() > 0) { $customerCoupon->setTimesUsed($customerCoupon->getTimesUsed()-1); $customerCoupon->save(); } } } } } } </code></pre>
Tags
<php><sql><magento><paypal><coupon>
Title
Magento - Single Coupon marked as used when payment pending
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USHarshal Doshi Jain
UserOwnerUserId
1. USuser1805921
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POMagento - Single Coupon marked as used when payment pending
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POMagento - Single Coupon marked as used when payment pending
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POMagento - Single Coupon marked as used when payment pending
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.