Home » Forums » Ubercart » Development

UPS Tracking Numbers

Submitted by VitaLife on Mon, 11/05/2007 - 23:15
VitaLife

Posts: 96
 Joined: 10/29/2007
Bug Finder

Now that I have successfully gotten Uberccart to send orders to my in-house shipping system. (Works great). I want to send the package tracking data back to Ubercart so my users can check the status in their order history. I have a couple of questions.

1. I assume that the main thing I need to do is complete the uc_shipment table for each order that I ship. I can record actual shipping cost, tracking number, shipping methould, and trans number for my USPS and UPS shipments. My question is, how do users see this tracking information? When logged in as a admin I have a shipment tab, but users status page does not have any shipment details. Even though the email that Ubercart sends tells them to go to that page. Do I have to emable something for them to see their shipment status? Would it make sense for me to add a line to the order_history pane that would be a hyperlink for tracking with the tracking number embedded in the link?

2. Do I need to use the uc_package table, since I'm printing the usps and ups labels from another application, I'm assuming I don't.

3. I'd like to change the order status from Pending to Shipped at the same time I send of the tracking information. Do I just need to create a status for 'Shipped' and call uc_order_update_status($order_id, 'Shipped') to update it?

Thanks
Jim
permalink #1 Tue, 11/06/2007 - 09:43
Lyle

Posts: 2267
 Joined: 08/07/2007
AdministratoreLiTe!

I knew the shipping system wasn't quite good enough yet, but I couldn't figure out what it was. Right now you'd have to put the tracking numbers in the order comments yourself. In your situation, that might actually be easier since all the shipping stuff is handled elsewhere.

If you do start putting data in the uc_shipments table, you should also fill in uc_packages and uc_pacakged_products. Übercart's process assumes that there will be packages containing products on every shipment, so it would be bad if it gets confused or disappointed.

permalink #2 Wed, 11/07/2007 - 02:03
VitaLife

Posts: 96
 Joined: 10/29/2007
Bug Finder

Thanks Lyle,
I have this working GREAT now, My shipping system automatically updates all the tables. Putting the tracking information in the uc_order_comments worked out great too. Here;s a cool tip for those doing tracking. When I posted the comments, I included full HREF for the UPS and USPS tracking. That way users can just click to have a new window with tracking pop up. These two links below are nice one to use for tracking, they let you track a package without having to agree to the UPS and Postal Terms and conditions like their default tracking link uses. Here are the comment entries for UPS and USPS I used, just change to your tracking numbers.

<?php
USPS
Shipped via USPS tracking #: <a href=http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?CAMEFROM=OK&strOrigTrackNum=9101805213907204408622&track.x=3D0&track.y==3D0 target=_new>9101805213907204408622</a>

UPS
Shipped via UPSG tracking #: <a href=http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=3D=status&tracknums_displayed=3D1&TypeOfInquiryNumber=3DT&loc=3D=en_US&InquiryNumber1=1ZX317870392307870&track.x=3D0&track.y==3D0>1ZX317870392307870</a>
?>