Settings>Shipping>Carriers>Carrier>USPS>Actions>View Report> Selecting Transactions and Balances. Then Export data. In the exported data under field “Type” shows on the word “Adjustment”. There is no way to link this data to orders in Shipstation. I was told by TechSupport that this is not available.
We have a customer that we have to send chargebacks to for UPS adjustments. There are many. At this point now we have to manually click on each “Adjustment ID” on the screen readout, then a popup opens with data, then copy the tracking # then go back to shipstation from Stamps.com, then to Shipment>Seach>paste in tracking number. If there are a lot which we do have. We could create a spread sheet file (table) and place it into Libre Office and then export all order detail (item level) and then send the exported csv file to Libre Office then link the two files together, then do a view showing the order detail of the adjustment ID transaction. However, there will be no adjustment data with it. We have to go to stamps.com create the onscreen list and then click on each and every adjustment id and copy and paste all of the data in the adjustment into their respective fields in each record representing the adjustment ID in the spreadsheet created in Libre Office.
The only other way to do this would be to call up each and every adjustment as a popup and try and find a very high performance OCR program (optical character recognition) hoping it will actually read the data in the adjustment popup and send the data to each individual field in the record representing each of the adjustments.
Now when you have 70-100 adjustments that have to be copied pasted by hand it gets extremely time consuming. This should be a priority. I don’t understand why this is not an already available export.
The only alternative to this copy/paste is asking Shipstation tech support to create the report each time which is fine but it really should be available on demand as an export feature.
Thank you for reading this and I hope this happens soon.
Mark