Delivery Date Column (and Delivery Estimate column)
We had many orders that didn't get delivered by the carrier estimated delivery dates during the holiday ordering period. Now, I'd like to request refunds on the delivery fees, but have to backtrack manually to get this information. It'd be great to have both the delivery estimate from the carrier and the actual delivery date as exportable columns.
Hey everyone! Thank you to @Perry who took the time to bring this one up! We’ll keep your feedback in mind, but for now we’re primarily interested in hearing what other users have to say.
If you haven’t already, please let us know your thoughts on this and how you’re doing this today (if at all).
Actually, I just exported a report from Shipstation with the delivery date.
1. Go to the Shipments tab
2. Create a filter of shipments you would like to see (i.e. specific states, specific ship date range, etc.) or just leave it as is to see all shipments.
3. Click the "Export Shipments" button above the grid
4. In the Export Shipments window, select "Create new format"
5. Name the report and select the columns you would like to see. One of those columns is "Delivery Date". Click "Save" to save the new format.
6. Select the new format, and click "Export"
Screenshots for steps 4-6 are in the attached PDF. Screenshots for steps 1-3 are at the following link: https://help.shipstation.com/hc/en-us/articles/360026191452-Export-Shipment-Records
I spot-checked a few tracking numbers and the delivery date is correct and matches what's shown in the tracking.
If the delivery date column is blank in the report, it means one of the following:
1. The shipment is still in transit
2. The shipment was cancelled, but the shipping label wasn't voided. There's not a column in the report to isolate these, but when you check the USPS tracking, it has a status of "Label Cancelled".
3. The shipment tracking is not being updated, which can often occur with USPS shipments when the carrier fails to scan the package. https://sellercentral.amazon.com/forums/t/is-it-an-absolute-fact-that-the-usps-will-sometimes-not-scan-a-package/6550
While it would be preferable to see the delivery date in the Shipments grid, having it available in an exported report is a start.
James Clark Technical Hot & Cold commented
Just get this feature added already.
Your customers want it, and it is an easy enough task to get done.
In the midst of COVID-19 and the delays it's causing, this is necessary!
MATTHEW LAZARUS Lulu-B Clothing commented
Since February 2016 and this is not available 4 years later. The data is there. Let us access it
Graham Orr PHOME commented
Wow 4 years as a suggestion. +1 from me.
As mentioned in many comments we would like to see how each courier is performing often the price difference is small, but if items are delayed or late. It will negatively impact on our business. At peak periods some couriers fall off quicker than others.
Also combining this information with postcode (zipcode) we can see which carrier performs best in each ragion we send to. It's not always about sending items as cheaply as you can. Adding a delivery date column even if it has to be manually imported would be a great start.
Paul Kalra PK Enterprises commented
Having a final date delivered would be incredibly valuable to be able to determining how on track carrier shipments were. It would lead to some great data for the insights section.
Josef Zarif Kabo Canada commented
Also would be great to have access to estimate delivery via api endpoint
Carson Stone commented
Really would love to see this. I don't want to use shipstation for SFP because I have no visibility of Deliver By
Yes! This would so be helpful. It's very painful to track and filter which orders were and were not delivered on time (in addition to refunds, it's also needed to email customers when their package is running late)
Be great to have the delivery date added to display and be able to export.
Delivery Date column is really needed for reporting. It's been requested for 3 years! Please add!
If SS factored in the standard USPS / UPS / Fedex zones and transit times by zip code and allowed these to be used as criteria in the automation rules, it would save my team 100's of hours.
IE - if USPS PM is 3 day transit time, choose FC instead || if USPS PM is 2 day transit time, choose PM
if UPS zone 4-6 choose 3-day, if zones 1-3 choose ground
The only other option is to create a huge number of rules based on 5K different zips codes AND carrier AND service options, which i don't think SS can even support and is not realistic.
This would allow me to automate carrier/service selection and review carrier OTD so I can 1) proactively reach out to the customer to address the delay, 2) easily compile and submit guaranteed service claims to the carrier, and 3) review OTD metrics by carrier for QBRs and decision making.
Douglas Brown UnTapped LLC commented
Returns have the ability to show delivery date... why would this not be available for outbound?
Hi @James Cramton Rocketry Works, thanks for sharing! This sounds like a technical issue that is best resolved by our support folks here. We certainly want to make sure your shipments appear in the status they say they are.
Please head on over to help.shipstation.com and use the "Contact Us" button to get started.
James Cramton Rocketry Works commented
I see that there is an attempt to indicate the delivery status for shipments, but it is horribly broken. Of 61 orders in the past few weeks, only one shows accurate delivery status. 3 other orders show an intermediate delivery status (in transit) even though the shipments were delivered. The other 57 orders shown an 'unknown' delivery status, many of them after weeks of time to poll the carrier. Having this list to review for delayed or problematic shipments would be very useful, but the current implementation leaves serious doubt about the reliability of the system.
Just chat about this with Austin over and would really like to see a Delivery by added to the Column tab. If we know when the order needs to be delivered by then we would set it to the correct shipping method.
Currently we need to go into the specific selling channel and check the delivery by date and then go back to ship-station and select the appropriate shipping method which takes a lot of manual work on our end. Putting a Column with the Estimated Delivery Date or Delivery By date would be very helpful and it seems as a lot of users are needing this feature.
Joel Habre Shoe Mill commented
Just spoke to a chat agent requesting a report for this. Please produce this!
Adam Hickman Foxhound Bee Company commented
Please add this feature, it would make a big difference in our shipping experience.
Emilie Fournier Jalie commented
For Canada Post, I use BusterFetcher that tracks that for me, but I haven't found a tool that does it for UPS yet. I think the only way to claim for late delivery is by contacting them directly so having a report with expected delivery and actual delivery date would really help speed up the process! I agree that it would add value to an already amazing tool, saving us precious time.
It would also be helpful to see ebay and amazon estimated delivery times so that we can best pick which delivery service to use when estimating.