Shipping Charges Analysis

Shipping Charges Analysis — Functional Description

Analyzes shipped OpenCart orders to compare customer shipping charges against actual carrier costs recorded in oc_order_shipping_cost. Profit is calculated as shipping charged minus shipping paid. Only orders with a non-zero recorded shipping paid value are included. Shipping method labels are normalized by trimming suffixes at an opening parenthesis, matching legacy grouping behavior.

Profit Status Row Legend (Section 3.4)

  • High Profit Profit greater than or equal to $2.00 — green row highlight (table-success)
  • Moderate Profit Profit between $1.00 and $1.99 inclusive — yellow row highlight (table-warning)
  • Low / Loss Profit strictly below $1.00 — red row highlight (table-danger)
  • Date range — optional Start Date and End Date boundaries filter on oc_order.date_added.
  • Weight range slider — dual-handle control auto-scales to the absolute minimum and maximum total product weight present in the active dataset (respecting the selected date range).
  • Profit range slider — dual-handle control auto-scales to the absolute minimum and maximum shipping profit (charged minus paid) present in the active dataset.
  • Shipping methods — multi-select narrows results to one or more normalized carrier methods; leave empty to include all methods.
  • Click any column header to sort; pagination retains all active filter and sort parameters.
Report Filters
Start End
Drag both handles to narrow total product weight (0–115 lbs).
Drag both handles to narrow shipping profit ($-103476.00–$126.00).
Leave unselected to include all shipping methods.

21021 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
226732 2021-08-16 $8.72 USPSFirstClass 1 0.61 lbs $5.99 $4.53 $1.46
226734 2021-08-16 $9.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.35 $0.45
226735 2021-08-16 $45.67 Priority Mail 2-Day 1 0.15 lbs $8.26 $7.70 $0.56
226736 2021-08-16 $10.75 USPSFirstClass 1 0.08 lbs $4.46 $3.06 $1.40
226737 2021-08-16 $8.41 USPSFirstClass 1 0.04 lbs $4.64 $3.49 $1.15
226738 2021-08-16 $62.53 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.80 lbs $9.10 $8.00 $1.10
226739 2021-08-16 $50.24 United States 1 1.20 lbs $8.75 $11.01 $-2.26
226742 2021-08-16 $8.86 First-Class Mail Stamped Letter 1 0.10 lbs $4.00 $3.06 $0.94
226743 2021-08-17 $6.86 USPSFirstClass 1 0.02 lbs $4.42 $3.35 $1.07
226744 2021-08-17 $36.17 First-Class Package Service 1 0.70 lbs $6.47 $4.12 $2.35
226745 2021-08-17 $41.79 Priority Mail 2-Day 9 1.40 lbs $17.55 $8.80 $8.75
226746 2021-08-17 $29.99 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.45 $0.05
226748 2021-08-17 $25.55 USPSFirstClass 3 0.00 lbs $14.18 $10.44 $3.74
226749 2021-08-17 $73.84 USPSPriority 1 1.00 lbs $10.85 $7.79 $3.06
226750 2021-08-17 $18.40 USPSFirstClass 1 0.03 lbs $4.83 $3.06 $1.77
226751 2021-08-17 $12.58 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
226752 2021-08-17 $76.04 USPSPriority 1 1.00 lbs $13.05 $11.69 $1.36
226754 2021-08-17 $14.32 First-Class Package Service - Retail 1 0.35 lbs $6.00 $4.12 $1.88
226755 2021-08-17 $34.53 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $9.00 $7.90 $1.10
226756 2021-08-17 $14.56 First-Class Package Service 2 0.35 lbs $4.77 $3.57 $1.20
226757 2021-08-17 $11.10 First-Class Package Service 1 0.05 lbs $4.32 $3.12 $1.20
226758 2021-08-17 $46.41 Priority Mail 3-Day Flat Rate Envelope 2 1.35 lbs $8.50 $7.90 $0.60
226759 2021-08-18 $21.79 USPSFirstClass 1 0.05 lbs $4.80 $3.22 $1.58
226760 2021-08-18 $9.33 USPSFirstClass 1 0.03 lbs $4.34 $3.06 $1.28
226761 2021-08-18 $6.41 USPSFirstClass 1 0.01 lbs $4.22 $3.06 $1.16
226763 2021-08-18 $13.94 USPSFirstClass 1 0.10 lbs $4.45 $3.06 $1.39
226764 2021-08-18 $18.77 First-Class Package Service 1 0.30 lbs $4.78 $3.58 $1.20
226767 2021-08-18 $34.53 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $9.00 $7.90 $1.10
226768 2021-08-18 $38.72 Priority Mail 3-Day 2 5.04 lbs $10.74 $9.64 $1.10
226769 2021-08-18 $8.09 First-Class Mail Stamped Letter 1 0.03 lbs $3.60 $3.49 $0.11
226771 2021-08-18 $9.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.06 $0.74
226773 2021-08-18 $25.78 Priority Mail 2-Day 1 0.95 lbs $12.79 $8.80 $3.99
226775 2021-08-18 $32.91 First-Class Package Service 6 0.30 lbs $4.71 $3.51 $1.20
226777 2021-08-18 $41.42 Priority Mail 2-Day 1 1.30 lbs $9.34 $8.24 $1.10
226778 2021-08-19 $117.68 Ground 5 13.65 lbs $28.86 $24.16 $4.70
226779 2021-08-19 $6.09 First-Class Mail Stamped Letter 1 0.01 lbs $3.60 $3.06 $0.54
226780 2021-08-19 $93.21 United States 9 2.42 lbs $9.75 $8.45 $1.30
226781 2021-08-19 $19.36 USPSFirstClass 3 0.14 lbs $4.69 $3.85 $0.84
226782 2021-08-19 $9.54 USPSFirstClass 1 0.03 lbs $4.55 $3.35 $1.20
226787 2021-08-19 $58.53 Priority Mail 3-Day 1 3.95 lbs $12.80 $11.70 $1.10
226788 2021-08-19 $10.03 First-Class Package Service 2 0.24 lbs $5.05 $3.49 $1.56
226789 2021-08-19 $91.93 United States 2 3.72 lbs $11.95 $8.00 $3.95
226791 2021-08-19 $43.66 Ground Home Delivery 2 0.12 lbs $27.68 $20.77 $6.91
226794 2021-08-20 $9.60 USPSFirstClass 1 0.06 lbs $4.41 $3.06 $1.35
226795 2021-08-20 $36.90 United States 7 0.40 lbs $4.75 $4.20 $0.55
226796 2021-08-20 $21.69 USPSFirstClass 1 0.05 lbs $4.70 $3.06 $1.64
226798 2021-08-20 $7.64 United States 1 0.05 lbs $3.95 $3.12 $0.83
226799 2021-08-20 $7.89 First-Class Package Service 3 0.04 lbs $4.42 $3.22 $1.20
226800 2021-08-20 $61.57 United States except IL & MA 2 4.00 lbs $11.95 $19.29 $-7.34
226801 2021-08-20 $101.22 Priority Mail 3-Day 2 2.25 lbs $10.74 $13.34 $-2.60
226806 2021-06-19 $33.41 Pickup From Store 1 1.30 lbs $0.00 $8.02 $-8.02
226808 2021-08-21 $19.36 USPSFirstClass 1 0.05 lbs $4.97 $3.22 $1.75
226809 2021-08-21 $7.71 USPSFirstClass 1 0.07 lbs $4.32 $3.06 $1.26
226810 2021-08-21 $11.78 First-Class Mail Stamped Letter 2 0.10 lbs $4.00 $3.22 $0.78
226811 2021-08-21 $6.98 USPSFirstClass 2 0.80 lbs $0.00 $5.66 $-5.66
226812 2021-08-21 $18.66 USPSFirstClass 2 0.10 lbs $8.88 $3.12 $5.76
226816 2021-08-22 $23.31 Selected States in United States 3 0.60 lbs $5.50 $4.38 $1.12
226817 2021-08-22 $23.55 United States 2 0.80 lbs $5.75 $5.42 $0.33
226819 2021-08-22 $8.44 USPSFirstClass 1 0.05 lbs $4.45 $3.22 $1.23
226820 2021-08-22 $6.39 USPSFirstClass 1 0.04 lbs $4.40 $3.35 $1.05
226821 2021-08-22 $7.81 USPSFirstClass 1 0.04 lbs $4.32 $3.06 $1.26
226822 2021-08-22 $113.81 Priority Mail 2-Day 4 4.80 lbs $12.80 $9.01 $3.79
226823 2021-08-22 $31.76 USPSFirstClass 1 0.27 lbs $6.27 $3.85 $2.42
226824 2021-08-22 $14.83 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
226828 2021-08-22 $155.39 Priority Mail 2-Day Medium Flat Rate Box 1 17.86 lbs $15.40 $13.75 $1.65
226830 2021-08-23 $22.55 USPSFirstClass 5 0.95 lbs $12.60 $3.06 $9.54
226837 2021-08-22 $33.32 Selected States in United States 8 0.82 lbs $6.00 $11.69 $-5.69
226838 2021-08-22 $41.61 First-Class Package Service 1 0.56 lbs $5.32 $4.12 $1.20
226840 2021-08-23 $63.70 Priority Mail 2-Day 1 3.95 lbs $17.97 $16.87 $1.10
226841 2021-08-23 $9.62 First-Class Mail Stamped Letter 1 0.09 lbs $4.00 $3.22 $0.78
226842 2021-08-23 $12.58 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
226843 2021-08-23 $12.43 USPSFirstClass 1 0.04 lbs $4.54 $3.06 $1.48
226844 2021-08-23 $6.54 USPSFirstClass 1 0.06 lbs $4.55 $3.49 $1.06
226845 2021-08-23 $9.38 USPSFirstClass 1 0.04 lbs $4.49 $3.22 $1.27
226846 2021-08-23 $24.10 USPSFirstClass 2 0.68 lbs $6.12 $5.81 $0.31
226847 2021-08-23 $24.17 First-Class Package Service 3 0.51 lbs $5.73 $4.53 $1.20
226860 2021-08-23 $19.60 United States 1 0.35 lbs $4.75 $3.69 $1.06
226863 2021-08-23 $41.54 Selected States in United States 1 1.25 lbs $8.75 $7.90 $0.85
226865 2021-08-23 $8.79 First-Class Mail Stamped Letter 1 0.08 lbs $3.80 $3.06 $0.74
226866 2021-08-24 $12.48 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
226867 2021-08-24 $6.24 USPSFirstClass 1 0.06 lbs $4.25 $3.06 $1.19
226868 2021-08-24 $14.54 USPSFirstClass 1 0.34 lbs $5.55 $3.69 $1.86
226869 2021-08-24 $6.75 USPSFirstClass 1 0.01 lbs $4.56 $3.49 $1.07
226870 2021-08-24 $12.64 USPSFirstClass 1 0.06 lbs $4.65 $3.22 $1.43
226871 2021-08-23 $155.39 Priority Mail 2-Day Medium Flat Rate Box 1 17.86 lbs $15.40 $13.75 $1.65
226874 2021-08-24 $28.49 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.45 $0.05
226875 2021-08-24 $28.67 USPSFirstClass 3 0.19 lbs $4.70 $3.35 $1.35
226877 2021-08-25 $18.36 USPSFirstClass 2 0.04 lbs $8.78 $3.06 $5.72
226881 2021-08-24 $33.51 United States 1 2.40 lbs $9.75 $12.70 $-2.95
226882 2021-08-25 $34.53 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $9.00 $7.90 $1.10
226885 2021-08-25 $12.53 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
226891 2021-08-25 $25.91 Priority Mail 3-Day 2 1.17 lbs $11.54 $10.44 $1.10
226898 2021-08-25 $12.43 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
226899 2021-08-25 $44.30 Selected States in United States 1 0.29 lbs $4.50 $3.69 $0.81
226908 2021-08-25 $13.46 Priority Mail 3-Day 4 0.04 lbs $8.50 $7.40 $1.10
226909 2021-08-25 $43.96 First-Class Package International Service 3 0.55 lbs $28.24 $20.19 $8.05
226911 2021-08-26 $47.02 First-Class Package Service 2 0.60 lbs $5.40 $5.42 $-0.02
226912 2021-08-26 $76.19 USPSPriority 1 1.84 lbs $14.20 $9.01 $5.19
226913 2021-08-26 $7.76 USPSFirstClass 1 0.07 lbs $4.37 $3.12 $1.25
226916 2021-08-26 $34.96 USPSPriority 1 1.10 lbs $14.67 $11.01 $3.66
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56