| Tue 08-11-2026 11:24

Compare Shipping on UPS CSV Export

CSV File:

Upload the UPS Billing Center data

This form accepts UPS Billing Center CSV files for upload which will be merged with UPS QuantumView shipment records and OpenPro shipping charges for orders.

To view and export the current merged UPS Shipments data, go here: UPS Shipments Report

Until we find an automated solution, periodic manual uploading of UPS Billing Center CSV report is required. Follow the procedure below to merge UPS Billing Center data into our UPS shipments database.

  1. Point your web browser to https://www.apps.ups.com/ebilling
  2. Log in using the Shopsmith billing account credentials
  3. On the Billing Center home page, click the hamburger 3 lines menu in the upper left.
  4. Click "Reporting & Search."
  5. Tick the "Tracking Number Detail" box.
  6. Click "Invoice Date"
  7. Select the desired date range (make sure to cover the invoice date prior to the start date you want - it's grouped by invoice now).
  8. All the required fields should be added already under "Current Display Fields", if you used the existing report template.
  9. Click "Submit"
  10. Click the export icon in the upper right of the result data table (looks like an upload button).
  11. Select "CSV."
  12. Click "Download."
  13. Enter report name TRK_NUM_REPORT_YYYYMMDD and save the file to your computer.
  14. Upload the CSV file you saved to this page. WARNING: This upload process may take several minutes.
  15. ** Due to a bug in the system, after the upload is complete, hit F5 to refresh and re-submit the data again.
  16. Read the output notes and proceed to UPS Shipments Report to view the merged data.