Subscription Order Including other products

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Subscription Order Including other products

Post by egormsen » Mon Dec 28, 2015 5:29 am

Having a problem with subscription orders when the original order included another product.

We have a customer that ordered a subscription and a book at the same time. The original order had no problems. Yesterday a recurring ordered was created that included the subscription along with the book that was a part of the original order and charged the customer for both products.

Here is a screenshot of the original order.
Order1.png
Here is screenshot of the recurring order
Order2.png
How we noticed the problem is when we were trying to print the packing slip (which normally would not be needed for subscriptions, but since the book as in the order the status was shipment pending) the following error was generated.

Code: Select all

An error has occured at https://store.weighdown.com/Admin/Orders/Print/PackSlips.aspx?OrderNumber=102350&is=1 
Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown. Stack Trace: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.admin_orders_print_packslips_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\root\942f1355\f9cd0b69\App_Web_kncvpuv1.2.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Inner Exception: Object reference not set to an instance of an object. Inner Exception Stack Trace: at ASP.admin_orders_print_packslips_aspx.__DataBinding__control17(Object sender, EventArgs e) in c:\inetpub\wwwroot\store2\Admin\Orders\Print\PackSlips.aspx:line 54 at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) at AbleCommerce.Admin.Orders.Print.PackSlips.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\store2\Admin\Orders\Print\PackSlips.aspx.cs:line 84 at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

We are on Gold R10.

Any ideas or suggestions?
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Subscription Order Including other products

Post by mazhar » Wed Jan 06, 2016 6:03 am

This exception on PackingSlip is fixed in Gold R11. It actually happens only on generated order. Locate following code in your Admin/Orders/Print/PackSlips.aspx

Code: Select all

<asp:Localize ID="IsResidenceText" runat="server" Text="Residential" Visible='<%# Eval("ShipToResidence") %>'></asp:Localize>
<asp:Localize ID="IsBusinessText" runat="server" Text="Commercial" Visible='<%# !(bool)Eval("ShipToResidence") %>'></asp:Localize>
and then update it like this

Code: Select all

<asp:Localize ID="IsResidenceText" runat="server" Text="Residential" Visible='<%# AlwaysConvert.ToBool(Eval("ShipToResidence"), false) %>'></asp:Localize>
<asp:Localize ID="IsBusinessText" runat="server" Text="Commercial" Visible='<%# !(AlwaysConvert.ToBool(Eval("ShipToResidence"), false)) %>'></asp:Localize>

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Wed Jan 06, 2016 6:32 am

Thank you! I will apply this fix.

What about the first part of this problem? Where an recurring subscription order includes a product that should not be there?
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Subscription Order Including other products

Post by mazhar » Thu Jan 07, 2016 2:12 am

What about the first part of this problem? Where an recurring subscription order includes a product that should not be there?
I am able to reproduce this problem. It only happens when subscription is a non shippable product. I have reported this issue for further investigation.

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Fri Jan 08, 2016 7:34 am

Thanks for the update. Please keep me posted.
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Wed Feb 03, 2016 11:14 am

Any updates on this, we are still having problems with people getting charged extra when the subscription comes due again.
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

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

Re: Subscription Order Including other products

Post by Katie » Thu Feb 04, 2016 5:40 am

Hi Eldon,

Yes, we are working on a Service Release for Gold R11. The issue is undergoing final testing and then we can patch it for Gold R10. Are you still using that version?

Thanks
Katie
Thank you for choosing AbleCommerce!

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

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Thu Feb 04, 2016 6:10 am

That's Great!

Yes, we are still using R10. Any eta for the patch?

Thank you.
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

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

Re: Subscription Order Including other products

Post by Katie » Fri Feb 05, 2016 5:00 am

It's not possible for me to give an exact date. As soon as we have finalized SR1 for Gold R11, then we will provide you a patch within a few days. It should be soon. We have the whole team working on final testing.
Thank you for choosing AbleCommerce!

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

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Wed Feb 10, 2016 4:31 am

This is probably related to the issue you are working on, but wanted to make sure you where aware of this also.

Each day we need to go into the order manager and update the status of the subscriptions since they never end up complete, they are in a shipment pending status even though they are paid and there are no items to ship.

Thanks,
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

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

Re: Subscription Order Including other products

Post by Katie » Sun Feb 14, 2016 7:12 am

Hi Eldon,

I wanted to let you know that we are close to releasing a patch for Gold R10 which will fix the subscription issues. You will need to make sure your installation has the latest patches available before installing the new one.

1) Confirm you are using Gold R10 SR1 - http://help.ablecommerce.com/index.htm# ... ld_r10.htm
2) Confirm you have applied the Authorize.net CIM patch - http://help.ablecommerce.com/index.htm# ... h_2015.htm

As far as the issue you are having with order statuses? I'm not able to reproduce it with my install of Gold R10. Let's make sure you are all patched up and then I can take a closer look at this.

I am hoping it will be ready tomorrow or the next day. Right now, I'm stalled on testing because of some issue with TaxCloud service being unavailable.

Thanks,
Katie
Thank you for choosing AbleCommerce!

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

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Mon Feb 15, 2016 5:10 am

Katie,

Sounds good to me.

I have updated our store with SR1, we had already previously applied the CIM patch.

Eldon
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

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

Re: Subscription Order Including other products

Post by Katie » Mon Feb 15, 2016 10:57 am

Hi Eldon,

I just finished uploading the patch and instructions to our help site. http://help.ablecommerce.com/

It's the link in the upper-right corner of the Announcements section.

Please let me know if you have any trouble.

Katie
Thank you for choosing AbleCommerce!

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

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Mon Feb 15, 2016 1:15 pm

Thank you!

I have installed the patch and will keep you posted of any issues.
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Tue Feb 16, 2016 4:59 am

It looks like the patch has not resolved the issues with the order status. All of the orders that are auto-generated for the subscription are still showing shipment pending even though there is nothing to ship.

Any suggestions or other info I could get to you?
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

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

Re: Subscription Order Including other products

Post by Katie » Wed Feb 17, 2016 5:50 am

I'm not able to reproduce this using the latest version. Please try this:

Assign the 'Payment Captured' trigger to the 'Completed' order status from Administration > Configure > Store > Order Statuses > Edit Status.

Please let me know if this works.

Katie
Thank you for choosing AbleCommerce!

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

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

Re: Subscription Order Including other products

Post by Katie » Thu Feb 18, 2016 4:04 am

Hello Eldon,

If you get a minute, can you let me know how the patch is working for you?

Thanks,
Katie
Thank you for choosing AbleCommerce!

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

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Thu Feb 18, 2016 6:33 am

Definitely will keep you posted.

It will be next week before I can start giving you some feedback, we have one renewal next Thursday (the 25th) where the original order had a subscription and additional products, then a few days later have another, then the next following week we have three coming up. So by then we will have a good idea if the issue is resolved.

Thanks,
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Thu Feb 18, 2016 6:35 am

FYI the assigning if the trigger that you suggested fixed the order status problem!

Thank you.
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

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

Re: Subscription Order Including other products

Post by Katie » Thu Feb 18, 2016 7:27 am

Great. Thanks for the update. I totally understand that it takes time to really test the subscription feature.

Katie
Thank you for choosing AbleCommerce!

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

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Subscription Order Including other products

Post by egormsen » Mon Feb 29, 2016 6:20 am

Things are looking good for the patch fixing the problem.

We had two orders generated this weekend where the customer had previously purchased other items with their subscription. Both orders where correctly generated!

Thank you for the patch!
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

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

Re: Subscription Order Including other products

Post by Katie » Mon Feb 29, 2016 6:57 am

Glad to hear it! Thanks for letting us know.

Katie
Thank you for choosing AbleCommerce!

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

Post Reply