Reversing Update Shipment Status Error?

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
hautebox
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 26
Joined: Thu Nov 05, 2009 2:46 pm

Reversing Update Shipment Status Error?

Post by hautebox » Sat Jan 16, 2010 1:47 pm

Does a process exist to "change/revert" an individual order (or group of orders) from "Shipped" back to "Unshipped" if the admin erroneously clicks the wrong button?

I erroneously checked one of the selection boxes for a particular set of orders, I then batch processed the Shipment Status from Unshipped to Ship for those orders.

When I try to "reverse" my mistake for that particular order that was included in the batch, there is no task selection in the drop down menu selection to "undo" the error.

This is a HUUUUGE problem because now I am unable to process any of those orders such as "Print pull sheets" or "packing slips"...The window comes up blank with an empty data set and nothing to print...

Any ideas for an "undo" process here...?

Hautebox

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Reversing Update Shipment Status Error?

Post by AbleMods » Sun Jan 17, 2010 9:42 am

Interesting this question hasn't come up before. While uncommon, it certainly would seem to make sense to include an unship function.

I haven't seen anything that allows you to do it through code. I do it manually through the SQL tables. Not so tough when an order has only one shipment. But it gets rather complex when the order has multiple shipments.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

vhemlani
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 30
Joined: Wed May 25, 2011 7:58 pm

Re: Reversing Update Shipment Status Error?

Post by vhemlani » Fri Jul 29, 2011 5:53 pm

Was there a solution to this?

hautebox
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 26
Joined: Thu Nov 05, 2009 2:46 pm

Re: Reversing Update Shipment Status Error?

Post by hautebox » Mon Aug 01, 2011 11:26 am

As of about 9 months ago, there was not a solution to this other than the "manual crowbar" that Joe referenced above.

We did not upgrade our AC ver due to uncertainty around the impact on some code that we had written. As a result, I don't know if that been taken care of since that time.

vhemlani
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 30
Joined: Wed May 25, 2011 7:58 pm

RESOLVED: Reversing Update Shipment Status Error?

Post by vhemlani » Fri Aug 12, 2011 4:05 pm

I was able to do it through the database.

Something to NOTE: You have to delete "Ship Date" otherwise it will automatically revert to "Shipped" status.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Reversing Update Shipment Status Error?

Post by AbleMods » Sun Aug 14, 2011 6:29 am

vhemlani wrote:Something to NOTE: You have to delete "Ship Date" otherwise it will automatically revert to "Shipped" status.
That is correct. AbleCommerce 7 uses the Ship Date field to determine the status for the specific shipment. If the ship date field has a value, AC7 reports the shipment as 'shipped'. Conversely, you can manually UN-ship any shipment by clearing the ship-date value.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply