Need a report of when order is delivered vs. label printed

Comments

4 comments

  • Avatar
    Erin E.

    Hello Kenneth, 

     

    Thank you for your post and for being a member of our Community.

     

    There currently is not a way to generate this in ShipStation as our system considers an order shipped when the label is created. I would recommend reaching out to UPS to check what options for data reports are available for your account.

     

    If you need to locate contact information you can use  the following: Contact Carrier Support 

     

    Please let us know how it goes, as I know this information will be very helpful to your fellow Community Members as well. 

     

    -Erin: Your Friendly ShipStation Community Moderator

    0
    Comment actions Permalink
  • Avatar
    Pierre Gagnon - Logistics

    Hey Kenneth

     

    The moment when an order hits the mailstream is a really import variable to track. Shipstation uses this internally to send confirmation emails, however the variable is not directly accessible to the end-user. IMO it'd be pretty useful ! With such a value, along with a confirmed delivery date, you can plot histograms to visualize your typical shipping delays.

     

    It won't allow you to produce exhaustive reports, however there's a way to pinpoint those orders that haven't been sent at all.

    >"Shipments" in the header menu">"In transit" in the left menu>sort by "Ship date" and look at the older orders. They may have not hit the mailstream yet.

    0
    Comment actions Permalink
  • Avatar
    Kenneth Mawhinney

    Pierre,

       Thanks I found the Shipments-In Transit page. When you say "mainstream", what does this term mean? The carrier in my case is UPS not the postal service. Do you just mean when the shipment is entered into UPS's system and a tracking number issued? The In-transit page confused me, when I clicked on a few of the tracking numbers and went to the UPS site it was telling me they had been delivered already the day before (Jan 10th, I am looking at the page on Jan 11th). Is this page not updated very often? I found only one order that had not yet been delivered which I assume would be characterized as "in transit".

    The problem I'm trying to solve has to do with our shipment workflow. The UPS pick up is at 5:30pm every week-day from the UPS store that just happens to be a few doors down from our business. About 4:40pm we use Ship Station to "ship" and print out the labels for all the orders received that day (at least for the ones we plan on shipping). Then the boxes for each order are physically carried down on a trolley to the UPS store with a stack of the labels; the boxes and labels are left with the UPS guy scans in each label for us, sticks each one on a box and it gets put on the truck. The problem is that in the weeks before the holidays, when there were lots of orders every day, we started to get feedback from a few customers asking why they hadn't received their shipment. And in looking into it we found that the labels had been printed but the box had never shipped; so there was a tracking number but it had never shipped. So... maybe we marked it shipped in ShipStation but carelessly missed printing out the label; or the label got mislaid after printing and didn't get included in the stack taken to the store; or the UPS guys mislaid the label; or who knows. Things were pretty hectic in the run up to the holidays; since then some checks have been introduced to ensure that a label is printed for each order and that there is confirmation that it has really gotten accepted by UPS. However, having received feedback from a few customers we wanted to go back and check all the other orders to make sure they had all really shipped. That is what prompted my post here. 

    The "Shipments" -> "In Transit" page would certainly have helped to an extent except that except that we would still have to click on each tracking number to visit the UPS site and find out the true status. ShipStation of course was still telling us it had shipped when really I think all this was really saying is that a tracking number had been created.

    Anyway, it turns out that the UPS web site has a page that allows the uploading of file of tracking numbers, one per line, maximum of 100 in a single upload. And given that upload it will return a CSV file with a record with a lot of information on each shipment including whether or not it has been picked up by UPS. So, I was able to get a report of the shipped orders from ShipStation (for a given time period) in an Excel file, then I manually copied the Carrier Transaction ID column which is the tracking number; pasted that into a CSV file. Then used a Linux command (split) to split the big file into files of 100, there were only 7 of them; upload each one manually to the UPS site one at a time; and saved the CSV files that were returned. Then I used Linux commands "tail" and "grep" to extract the rows for shipments that UPS said it didn't have. Thus out of the 700 orders I was able to generate a list of the few that had a tracking number but for unknown reasons had not made it onto the truck. Using the UPS tracking number I was able to match those to the original ShipStation order and figure out from there what to do about it.

    The "In transit" page looks promising, I will investigate this and follow a single order through to see what can be tracked as it moves through the shipping pipeline. I noticed both this page and the "Delivered" page have columns for "Marketplace Notified" and "Shipment Notification" and "Delivery Notification"; these last two are empty for me on both pages. Is this because we are not using ShipStation send these notifications to the customer? 

    0
    Comment actions Permalink
  • Avatar
    Kenneth Mawhinney

    Sorry, I guess that previous post is bit long.

    0
    Comment actions Permalink

Please sign in to leave a comment.