Help- Glitches in R6

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Help- Glitches in R6

Post by Brewhaus » Thu Nov 07, 2013 11:58 am

We have just today started using R6 and have already found a couple of glitches. Has anyone found ways to correct these yet?

1) When a customer pays by credit card and the Payment changes to Payment Authorized, it is not triggering the status to change from Unpaid to Payment Pending. I have even tried editing the status and then changing it back, hoping that it would fix it, but no luck. We still have a site running on 7.0.7, so I compared the settings and they are identical.

2) PayPal payments are not being marked as paid in AC. Our PayPal settings have IPN turned off, however, PayPal payments made for orders on our 7.0.7 site show on the order as completed. My greater concern on this is that after upgrading our second site to Gold that PayPal payments will not be showing up on either website, which will be a tremendous issue.

3) R6 is not letting us either remove or edit a coupon that is added to an order. The edit button does not open the quantity or value box to make changes, and while pressing the X does bring up a window for confirmation, when we click OK nothing happens (ie. it does not remove the coupon). This leaves us having to cancel the order and start over.

If anyone can help on these three issues it will be greatly appreciated.

Rick
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Help- Glitches in R6

Post by Brewhaus » Thu Nov 07, 2013 3:03 pm

With more order coming in it appears that more of the triggers are not working. Printing an order does destock items, however, items are not being destocked when an order is placed. The trigger is there, but it appears to not be firing. Can anyone help? I am sure that others must have hit this issue by now.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: Help- Glitches in R6

Post by compunerdy » Thu Nov 07, 2013 3:56 pm

Still working on the layout myself... Would be nice if you could share the DB between ac 7 and gold so when you notice issues you could just switch back without worrying about orders placed, etc..

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Help- Glitches in R6

Post by Brewhaus » Thu Nov 07, 2013 4:14 pm

Tell me about it. There are a lot of things that you just don't notice until you go live, and then it is too late! At this poing, given the grief of the first day, on basic things like destocking when an order is placed, I am regretting the move to Gold.

I will say that Gold has some nice new features, but there are also a couple that have disappeared in Gold that are badly missed. For example, when you process payments, ship an order, etc., there is no longer a list of affected orders at the bottom of the page (it is replaced with a popup confirmation). My staff used this list to double-check against the order sheets that were supposed to be processed so that an error would be caught immediately. A second drawback is that the "preview" of an order (the link on the right side of the order at /admin/orders) just takes you to that order instead of showing a list of items on the order. This means that you can no longer see the items in an order without going to the order (and leaving the batch order page). We did not realize that we used this so much until it was gone. :-(
Maybe we are just resistant to change...
Last edited by Brewhaus on Fri Nov 08, 2013 12:58 pm, edited 1 time in total.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Help- Glitches in R6

Post by Katie » Thu Nov 07, 2013 4:58 pm

1) When a customer pays by credit card and the Payment changes to Payment Authorized, it is not triggering the status to change from Unpaid to Payment Pending. I have even tried editing the status and then changing it back, hoping that it would fix it, but no luck. We still have a site running on 7.0.7, so I compared the settings and they are identical.
By default, the destock happens with a paid order, but it does look like an authorized status is not triggering the destock, and it should. I will request a patch for this asap.
2) PayPal payments are not being marked as paid in AC. Our PayPal settings have IPN turned off, however, PayPal payments made for orders on our 7.0.7 site show on the order as completed. My greater concern on this is that after upgrading our second site to Gold that PayPal payments will not be showing up on either website, which will be a tremendous issue.
If you have turned off IPN, then I don't see how the updates from Paypal will be made. Can you turn on IPN or provide some additional information?
3) R6 is not letting us either remove or edit a coupon that is added to an order. The edit button does not open the quantity or value box to make changes, and while pressing the X does bring up a window for confirmation, when we click OK nothing happens (ie. it does not remove the coupon). This leaves us having to cancel the order and start over.
A fix for the coupons was posted here:
viewtopic.php?f=29&t=17599

Somehow, I missed the update. It looks like an official patch still needs to be posted.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Help- Glitches in R6

Post by Brewhaus » Thu Nov 07, 2013 5:14 pm

Thank you for the help, Katie. Just to be sure on a couple of things:
By default, the destock happens with a paid order, but it does look like an authorized status is not triggering the destock, and it should. I will request a patch for this asap.
We do have the statuses set to Destock when an order is placed (Name: Unpaid, Stock: Destock, Trigger: Order Placed). These are the same settings that we use in 7.0.7 and when an order is placed the products are destocked. Will the patch correct this, as well? It just seems that some of the triggers are not working.
If you have turned off IPN, then I don't see how the updates from Paypal will be made.
I can't say why it works, but it does. I checked our PayPal account and IPN is turned off, but when a PayPal order is placed it shows as Authorization Pending until the customer completes the payment, at which time it updates to Paid. Given that we will now have to run two DBs we would have to supply different URLs, and PayPal only allows us to enter one. It would not likely work, anyway, as we will have duplicate OrderIDs now that we are on separate DBs.
A fix for the coupons was posted here:
viewtopic.php?f=29&t=17599
Thank you. I will hit that thread and make the corrections.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Help- Glitches in R6

Post by Katie » Fri Nov 08, 2013 9:11 am

We do have the statuses set to Destock when an order is placed
The R6 patch below should fix the destock issue when an order is either unpaid or in an authorized only state.

ftp://ftp.ablecommerce.com/patches/Comm ... ending.zip

If you could report back, that would be great. Please make a backup of your CommerceBuilder.dll file first. This has not gone through the official channels for testing yet, but I wanted you to get it right away.

Thanks,
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Help- Glitches in R6

Post by Brewhaus » Fri Nov 08, 2013 11:50 am

Thank you for the patch, Katie. I just placed a test order and it worked (ie. the product was destocked as soon as the order was placed).

Is this patch also supposed to correct the issue with the other triggers (ie. when a payment is authorized the status will change to Payment Pending, or when the payment is completed the status will change to Shipment Pending)?
Incidentally, for some reason the PayPal payments are now being applied. I wish that I could explain it, but I can't.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Help- Glitches in R6

Post by Katie » Fri Nov 08, 2013 3:21 pm

Is this patch also supposed to correct the issue with the other triggers (ie. when a payment is authorized the status will change to Payment Pending, or when the payment is completed the status will change to Shipment Pending)?
No, this patch is only to fix the destock issue on an unpaid order. As far as I know, there are no other issues with triggers. If you do have a problem, you'll need to give us the steps to reproduce the issue so we can try it ourselves. If you have customized your order statuses, we'll need that information too.

Glad to hear the patch and Paypal are working. Thanks for letting me know.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Help- Glitches in R6

Post by Brewhaus » Fri Nov 08, 2013 3:27 pm

I was actually coming back here to say that the new DLL fixed this issue, but maybe it was just something with needing the nudge, as I restarted the website after putting in the new patch. Anyway, destocking and updating the status with payment both appear to be working, so I believe that we can go into the weekend with everything functioning correctly.

Thanks again, Katie!
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Help- Glitches in R6

Post by Brewhaus » Wed Dec 04, 2013 7:29 pm

I think that there may be a bug in AC with respect to PayPal. Shortly after turning on IPN with PayPal we found that any payment going to hotsaucedepot.com would be credited to the order in brewhaus.com, as well. We figured out that it had to do with the order number. There is an additional digit on orders under hotsaucedepot.com (2111111), and if the order number on brewhaus.com is the same, less that extra lead digit (111111) then the payment is also being applied to that order. In other words, the order number shown by PayPal to be paid does not have to match exactly- if there is an extra digit in the order number paid, but the rest matches, AC will apply the payment to the order. How can we fix this, as we had to turn off IPN, so only about 1 in every 6 or 8 PayPal payments are getting applied, so we must manually check and apply most PayPal payments.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Help- Glitches in R6

Post by Katie » Thu Dec 05, 2013 4:02 am

Hi Rick,

I don't know how it's possible that Paypal is adjusting orders in two different stores. Are you sure that you don't have some code or something in the merchant account that is doing this? I know you originally had two stores running under the same installation, so that seems like a very likely reason this is happening.

Also, it would be super helpful if you can keep your issues separated in different forums. It will also make it easier to find things if other customers are having the same problem.

Thanks,
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Help- Glitches in R6

Post by Brewhaus » Thu Dec 05, 2013 10:46 am

You are correct, Katie. My apologies. I will start a new thread for the PayPal issue, and give a bit more explanation, as we never had Gold run two sites, and they were pretty much built independently from the ground up (they had to be separate, as Gold works differently from 7.0.7).
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

Post Reply