I would like to see an Activity Log Report by User. Currently, to see the full spectrum of what a user has been doing in ShipStation, I have to go to User Management - Edit - Activity and continuously scroll and "Load More", but that only shows me some data. To see more, I would have to go to the Order's screen and search Activity under each individual order. I would like for all activity by a User to be available to me in a Report for accountability purposes with time stamps.
This would be super helpful for us... We rely on a third party distro who has had some "missed shipments" but printed labels.
Being able to generate a report where we could see labels printed with no additional scans and either export it, or allow an API integration for us to automate a notification system would be tremendous.
I don't need a fancy inventory system, what Ship Station provides is almost what I need. However, if I can't pull a month end inventory report, there is no point. Not having this capability essentially requires that I bring in more software just to be able to get a month end inventory report? That's ridiculous. A simple reporting enhancement that should have been included in the initial development solves a ton of issues for those of us that just want to use SS to manage our inventory.
We had to develop our own solution to this since there doesn't seem to be a good solution available. It uses the ShipStation API and the various carriers' APIs (UPS, USPS, FedEx, etc).
Basically, we have a script that runs on a cron job once a day to load all new ShipStation shipments into a database. Then a different script that runs via cron once per minute, each minute pulling one tracking number that is still in transit, and checking the carrier API for its status. If it's in transit and on time, it marks it to check it again the next day. If it was delivered on time, it marks it to not need to check it again (and purge it from the database after a period of time). If there's an exception, or it's late, or it hasn't been scanned in at all, it emails somebody so they can handle it.
This method insures we don't hit the fairly low ShipStation API call limit, since we have other things running on the ShipStation API. A simpler solution for low shipment volume would be to have just one script that pulls ShipStation shipments and check the carrier API in one step.
The hardest part is that the USPS API doesn't return a good exception code to use. USPS just returns the notes for each tracking event. So you have to build a large list of potential status notes, and I've found they can change based on what the individual postal employee enters. UPS, on the other hand, returns a single-character status code. So you only have to check for "X" for an exception, for example. Much better.
I don't think it would be hard for ShipStation to implement something like this, and it would certainly be a very positive feature to have.
This would be a great feature for ShipStation users. We just recently got contacted by a company who offers this as a service for certain carrier's customers. They track all of your shipments and automatically apply for refunds when applicable. This way shippers can collect refunds on ALL late shipments, and not just the ones that our customers notify us of.
Even something as simple as a late shipment report would be incredibly useful, but automated refunds would be amazing.
I'd love to be able to run a report that showed what customers paid toward shipping vs the actual cost, and then be able to sort that report by the order tags associated with each order.
We need the ability to pull a shipping report at the end of the month that shows all of the shipping info (buyer, recipient, date, etc.) that also include products shipped. We need this so that we can invoice our customers. Thank you.
Ok so you guys SHOW "Returning Customers" in the Insights UI but there is NO WAY to actually identify / see who the returning customers are.
It would help to obviously be able to SEE your returning customers to re-market to them. Obvious stuff here.
We recently started using the scan to verify & print option. I had a customer come back this week saying she is missing products from her order. I would like to be able to run a report to verify that the items were physically scanned and verified before being shipped.
Is this something y'all can do?
Generating true profit for everyone might be complicated but just the COST OF THE PRODUCT would be great rather than having nothing at all, something is better than nothing. At the end of the day true profit can never be calculated since all businesses have so many additional costs, Bank fees, International wire fees, insurance, payroll, ect ect. But just having the COST of the product would be great.
I would love to see a place where pertinent info could be added to specific orders of repeat customers. Sothat was each time another order was placed you could view your notes, ie. specific personal shipping instructions for that 1 customer (for example "Don't include "XYZ" for that customer" because XYZ are included in all other orders.
Dispatch Time Report...
It would be good to be able to run a report that shows the time an order was placed and the time it was dispatched. Then a column which shows the difference in hours/minutes.
This would enable us to setup KPI's around dispatch times to make sure that we are sending orders in the most efficient way.
At the moment 2 reports need to be pulled, and then using vlookup formula to match the SO's to match. This kind of report is very important for our pricing.
We are in need of a report that shows historically how many orders are pending shipment per day. Being a highly seasonal business with large surge, we would like to reflect on prior years to see how that daily total fluctuates throughout season. This is a good KPI for when additional manpower is needed or when we need to slow sales/turnaround expectations.
I was hoping to find a way to report on the # of each package type shipped during a period of time.
This is useful when negotiating with shipping carriers, as they create the shipping rates both geographically and by package type. (If rates are calculated by a dimensional weight). We should easily be able to see that we sent X number of Box 1s, X number of Box 2s, etc.
I want an option for a weekly overview of how many of each SKU was ordered per day of that week.
I know I can run a report for Item Demand Summary, that will give me the weekly totals, but I would like to be able to break that down by day, but pull it as 1 report weekly.
If not, I'm having to pull daily reports and compile the info, or try to customize a weekly export, which still forces me to have to manually go in a sort by day and calculate how many of each per day
Have a report that pulled any order that had an exception on it for an extended period of time. This would allow me to see that UPS had X number of exceptions and FedEx had X number of exceptions. I could find their on time delivery % based off of that and use that for negotiations or to choose one over the other for the base of your shipping.
Who are my repeat customers. What is the percentage of my repeat sales to my total sales. some times we recognize a name or address (Bright red house next to park) but if you are processing a lot of orders for that day, you just do not pay attention because there is no time.
This would help gauge what products customers like/dislike. If we launch a new product, are people buying or not liking the product, if no repeat sales.
We would love the ability to report on how long it takes users to complete a shipment. Average time per shipment, total time shipping, etc.
We are struggling to measure/compare effeciencies of our shippers without these metrics.
I am surprised that this does not have more votes and have not already been implemented by Shipstation. At the least you should be able to enter your landed cost per product in the first iteration. Second iteration maybe one or two more costs that you incur per product. For example packaging. Another would be the commission per market channel, but it will vary by either per product or per product category. And then maybe one or two custom fields a user may want to enter on their costs. Cost of Good Sold is so critical for any business. Revenue is great to see, but not easily knowing exactly what profit was made on each order can easily impact the success of a business. That quick look to see how profitable a day, or week or month is, is vital. Please implement. I am not sure if this is available already, but if we can download all products in shipstation using csv/excel, and then upload it back in adding in these new fields...then it would be so easily for users to implement and start using once Shipstation has created the formula to calculate the costs and then show the profit in dollars and percentages.
There currently is no way to export a report including the Shipper who created the shipment and the SKU in the shipment. You can either export one or the other, but not both. Would be a very easy implementation to be able to export both I would think.
