UPS Tracking Number

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
mkeith1
Commander (CMDR)
Commander (CMDR)
Posts: 120
Joined: Wed Jul 25, 2007 12:46 pm
Contact:

UPS Tracking Number

Post by mkeith1 » Wed Oct 29, 2008 11:01 am

how do i change the UPS tracking number after i've completed an order. there isn't a place to do this.

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

Re: UPS Tracking Number

Post by AbleMods » Wed Oct 29, 2008 12:05 pm

You have to edit the SQL table ac_TrackingNumbers directly. There is no way to edit a tracking number once it's been posted.
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

mkeith1
Commander (CMDR)
Commander (CMDR)
Posts: 120
Joined: Wed Jul 25, 2007 12:46 pm
Contact:

Re: UPS Tracking Number

Post by mkeith1 » Wed Oct 29, 2008 12:33 pm

Joe, it's not possible for me to edit the table directly. Version 5.5 had this ability within the store, maybe it could be added or offered as an uprade by Able.

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

Re: UPS Tracking Number

Post by AbleMods » Wed Oct 29, 2008 12:58 pm

Understandable.

I hope so too - perhaps Mazhar can whip something up for everyone to download until then. It's been sorely needed for a while now.
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

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: UPS Tracking Number

Post by Robbie@FireFold » Wed Oct 29, 2008 7:25 pm

This is something we could use also. My staff scratched their head trying to find the edit button for the tracking.

It didn't exist!
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

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

Re: UPS Tracking Number

Post by compunerdy » Wed Oct 29, 2008 10:11 pm

I posted the request earlier today..vote for it here

viewtopic.php?f=45&t=8753&start=0

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

Re: UPS Tracking Number

Post by mazhar » Thu Oct 30, 2008 8:27 am

Here is the modified page with editing support for tracking number. Extract and replace the EditShipment.aspx file in your Website\Admin\Orders\Shipments directory with this page.

Please first take backup of your existing EditShipment.aspx page

User avatar
draneb
Captain (CAPT)
Captain (CAPT)
Posts: 314
Joined: Sun Jun 12, 2005 4:07 pm
Location: Texas
Contact:

Re: UPS Tracking Number

Post by draneb » Mon Dec 22, 2008 7:18 pm

Hi Mazhar,

I have been using the revised EditShipment.aspx page. There is one thing I noticed and I'm hoping you can help.

If you have a tracking number entered and want to go back and edit it the revised file works great.

What I often find myself having to do is go into Shipments and Ship the Order. Then either that evening or then next day my vendor will email me the tracking number. I would like to go back in and enter the tracking number but if you do not initially enter a tracking number that field will not be there. There will only be "Delivery Instructions" shown.

Do you think that would be something you would be able to correct, please?

Thank you!
AC 7.0.3 build 13937

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: UPS Tracking Number

Post by Robbie@FireFold » Mon Dec 22, 2008 7:26 pm

Since we are on the tracking bandwagon. I was wondering if there was some better way to re-assign/edit/change a shipment after it has been shipped.

The merge button goes away. A button that we could 'move' items to a new shipment would be great.

Currently we have to create a second shipment, go into order items, delete the item, re-add the item, assign it to the second shipment, then ship the item. Quite a few steps just to separate a shipment.

This happens a lot for us because we use Shipper 3 - and our 'drop ship' tracking comes in the next day. Shipper 3 ships the entire package no matter what.
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

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

Re: UPS Tracking Number

Post by mazhar » Tue Dec 23, 2008 2:10 am

Hi Mazhar,

I have been using the revised EditShipment.aspx page. There is one thing I noticed and I'm hoping you can help.

If you have a tracking number entered and want to go back and edit it the revised file works great.

What I often find myself having to do is go into Shipments and Ship the Order. Then either that evening or then next day my vendor will email me the tracking number. I would like to go back in and enter the tracking number but if you do not initially enter a tracking number that field will not be there. There will only be "Delivery Instructions" shown.

Do you think that would be something you would be able to correct, please?

Thank you!
Here is the modified file. Now when you edit a shipment that has no tracking number then the page will give you the ability to enter the tracking number.

Post Reply