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
220762 2021-01-21 $12.43 First-Class Package Service 1 0.30 lbs $3.76 $3.57 $0.19
220763 2021-01-21 $121.85 Priority Mail 2-Day Flat Rate Envelope 37 2.55 lbs $8.00 $8.00 $0.00
220764 2021-01-21 $6.49 First-Class Package Service 1 0.04 lbs $3.50 $3.35 $0.15
220765 2021-01-21 $84.44 Priority Mail 2-Day Medium Flat Rate Box 1 5.30 lbs $14.45 $13.75 $0.70
220767 2021-01-21 $13.64 USPSFirstClass 1 0.05 lbs $4.65 $3.67 $0.98
220768 2021-01-21 $12.43 USPSFirstClass 3 0.57 lbs $5.86 $5.70 $0.16
220769 2021-01-21 $27.99 USPSFirstClass 3 0.15 lbs $13.32 $3.18 $10.14
220770 2021-01-21 $11.98 USPSFirstClass 1 0.06 lbs $4.19 $2.74 $1.45
220771 2021-01-21 $11.28 USPSFirstClass 1 0.20 lbs $4.39 $3.52 $0.87
220772 2021-01-21 $19.26 Priority Mail 2-Day 1 0.95 lbs $8.97 $8.24 $0.73
220774 2021-01-22 $8.14 USPSFirstClass 1 0.19 lbs $4.15 $2.84 $1.31
220776 2021-01-21 $6.46 First-Class Package Service 1 0.20 lbs $3.97 $3.69 $0.28
220777 2021-01-21 $102.41 Priority Mail 3-Day Medium Flat Rate Box 4 4.25 lbs $14.45 $8.00 $6.45
220778 2021-01-21 $26.90 Priority Mail 2-Day 1 0.45 lbs $9.00 $7.90 $1.10
220779 2021-01-21 $9.64 Priority Mail 2-Day 1 0.01 lbs $8.65 $7.88 $0.77
220782 2021-01-21 $96.66 Ground 11 4.13 lbs $22.92 $14.25 $8.67
220783 2021-01-22 $12.13 USPSFirstClass 1 0.06 lbs $4.34 $2.84 $1.50
220786 2021-01-21 $16.35 First-Class Package Service 3 0.07 lbs $3.38 $3.22 $0.16
220788 2021-01-22 $7.14 USPSFirstClass 1 0.02 lbs $4.15 $2.93 $1.22
220789 2021-01-21 $26.25 First-Class Package Service 1 0.27 lbs $3.76 $3.57 $0.19
220791 2021-01-21 $17.42 First-Class Package Service - Retail 13 0.13 lbs $5.05 $3.49 $1.56
220792 2021-01-22 $27.53 USPSPriority 1 1.50 lbs $10.74 $8.21 $2.53
220796 2021-01-22 $8.19 USPSFirstClass 1 0.10 lbs $4.20 $2.93 $1.27
220797 2021-01-22 $16.29 USPSFirstClass 1 0.50 lbs $5.30 $3.31 $1.99
220798 2021-01-22 $11.29 USPSFirstClass 1 0.06 lbs $4.30 $2.84 $1.46
220800 2021-01-22 $11.08 USPSFirstClass 1 0.02 lbs $4.29 $2.84 $1.45
220802 2021-01-22 $7.86 USPSFirstClass 1 0.04 lbs $4.37 $3.18 $1.19
220803 2021-01-22 $16.14 First-Class Package Service 1 0.30 lbs $4.35 $3.85 $0.50
220804 2021-01-22 $13.39 USPSFirstClass 1 0.05 lbs $4.40 $3.31 $1.09
220805 2021-01-22 $14.44 USPSFirstClass 1 0.50 lbs $5.45 $4.46 $0.99
220806 2021-01-22 $10.17 First-Class Mail Stamped Letter 3 0.04 lbs $3.20 $3.49 $-0.29
220807 2021-01-22 $93.02 Next Day Air 1 1.20 lbs $65.03 $62.53 $2.50
220810 2021-01-22 $21.46 First-Class Mail Stamped Letter 14 0.16 lbs $3.60 $3.35 $0.25
220811 2021-01-22 $14.13 USPSFirstClass 1 0.06 lbs $4.39 $2.78 $1.61
220812 2021-01-22 $15.98 First-Class Package Service 1 0.05 lbs $3.99 $3.18 $0.81
220813 2021-01-22 $53.10 Priority Mail 3-Day 11 1.01 lbs $9.70 $7.65 $2.05
220815 2021-01-22 $20.92 First-Class Package Service 1 0.40 lbs $5.03 $4.32 $0.71
220816 2021-01-22 $20.82 First-Class Package Service 6 0.60 lbs $4.88 $4.18 $0.70
220817 2021-01-22 $36.72 Ground 2 0.60 lbs $24.74 $20.07 $4.67
220819 2020-08-30 $36.79 Priority Mail 2-Day 1 1.20 lbs $0.00 $10.54 $-10.54
220820 2021-01-22 $23.16 First-Class Mail Stamped Letter 4 0.18 lbs $3.60 $3.85 $-0.25
220824 2021-01-22 $18.09 USPSFirstClass 3 0.60 lbs $12.42 $5.54 $6.88
220825 2021-01-22 $19.25 USPSFirstClass 1 0.95 lbs $8.96 $9.99 $-1.03
220826 2021-01-22 $10.38 USPSFirstClass 1 0.05 lbs $4.49 $3.18 $1.31
220827 2021-01-22 $10.07 First-Class Package Service 1 0.19 lbs $4.08 $3.22 $0.86
220828 2021-01-22 $9.45 USPSFirstClass 1 0.10 lbs $4.26 $2.93 $1.33
220830 2021-01-22 $19.65 USPSFirstClass 1 0.95 lbs $9.36 $10.54 $-1.18
220833 2021-01-22 $96.56 Priority Mail 3-Day Medium Flat Rate Box 3 3.59 lbs $15.00 $12.13 $2.87
220835 2021-01-23 $47.39 USPSFirstClass 4 1.44 lbs $20.53 $10.44 $10.09
220837 2021-01-22 $48.52 Priority Mail 3-Day Medium Flat Rate Box 2 1.20 lbs $15.00 $13.20 $1.80
220838 2021-01-23 $12.13 USPSFirstClass 1 0.06 lbs $4.34 $2.84 $1.50
220841 2021-01-22 $23.71 Priority Mail 2-Day 2 0.53 lbs $8.73 $7.88 $0.85
220842 2021-01-23 $14.28 USPSFirstClass 1 0.06 lbs $4.54 $3.05 $1.49
220844 2021-01-23 $16.70 USPSFirstClass 2 0.60 lbs $5.72 $5.27 $0.45
220845 2021-01-23 $12.13 USPSFirstClass 1 0.06 lbs $4.34 $2.84 $1.50
220846 2021-01-22 $10.73 First-Class Package Service 1 0.07 lbs $3.72 $3.22 $0.50
220847 2021-01-22 $20.86 First-Class Package Service 5 0.41 lbs $5.91 $4.38 $1.53
220849 2021-01-22 $35.79 First-Class Package Service 1 0.20 lbs $4.19 $3.69 $0.50
220850 2021-01-23 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
220851 2021-01-22 $36.74 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
220854 2021-01-23 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
220855 2021-01-23 $53.54 USPSFirstClass 1 0.50 lbs $7.03 $4.00 $3.03
220856 2021-01-23 $65.03 Priority Mail 3-Day Flat Rate Envelope 2 2.30 lbs $8.25 $8.00 $0.25
220858 2021-01-23 $39.89 First-Class Package Service 4 0.35 lbs $4.63 $3.58 $1.05
220861 2021-01-23 $33.40 Priority Mail 3-Day 5 2.25 lbs $14.95 $13.75 $1.20
220862 2021-01-23 $25.93 Priority Mail 2-Day 3 1.35 lbs $11.86 $19.30 $-7.44
220863 2021-01-23 $28.53 USPSPriority 1 1.50 lbs $11.74 $9.54 $2.20
220864 2021-01-23 $7.13 USPSFirstClass 1 0.07 lbs $4.34 $3.18 $1.16
220865 2021-01-23 $41.98 Priority Mail 3-Day Flat Rate Envelope 7 1.15 lbs $8.25 $8.00 $0.25
220866 2021-01-23 $19.05 USPSFirstClass 1 0.95 lbs $8.76 $8.76 $0.00
220868 2021-01-23 $43.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.12 lbs $8.85 $8.00 $0.85
220872 2021-01-23 $40.35 Priority Mail 3-Day Small Flat Rate Box 1 0.20 lbs $8.75 $7.90 $0.85
220874 2021-01-23 $79.29 Priority Mail 3-Day Padded Flat Rate Envelope 1 13.50 lbs $8.85 $8.00 $0.85
220876 2021-01-23 $6.55 First-Class Package Service 1 0.01 lbs $3.56 $3.06 $0.50
220877 2021-01-23 $5.99 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.12 $-0.12
220878 2021-01-23 $8.13 USPSFirstClass 2 0.06 lbs $4.15 $3.35 $0.80
220880 2021-01-23 $14.13 USPSFirstClass 1 0.06 lbs $4.39 $3.06 $1.33
220881 2021-01-23 $7.92 USPSFirstClass 2 0.02 lbs $4.14 $3.35 $0.79
220882 2021-01-23 $11.03 USPSFirstClass 1 0.02 lbs $4.24 $3.06 $1.18
220884 2021-01-23 $27.24 Priority Mail 2-Day 3 2.49 lbs $9.57 $9.21 $0.36
220885 2021-01-23 $12.08 USPSFirstClass 1 0.06 lbs $4.29 $3.06 $1.23
220886 2021-01-23 $38.81 Priority Mail 3-Day Padded Flat Rate Envelope 2 1.75 lbs $8.85 $8.00 $0.85
220887 2021-01-23 $13.87 First-Class Package Service 1 0.30 lbs $4.08 $4.38 $-0.30
220888 2021-01-23 $23.72 Priority Mail 3-Day 1 0.23 lbs $8.73 $7.90 $0.83
220889 2021-01-24 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.35 $1.09
220891 2021-01-23 $8.98 First-Class Mail Stamped Letter 2 0.12 lbs $3.40 $3.85 $-0.45
220892 2021-01-24 $12.13 USPSFirstClass 1 0.06 lbs $4.34 $3.12 $1.22
220893 2021-01-24 $20.72 USPSFirstClass 2 0.77 lbs $9.14 $11.01 $-1.87
220894 2021-01-23 $8.17 First-Class Package Service 2 0.38 lbs $4.19 $3.35 $0.84
220895 2021-01-23 $10.92 First-Class Mail Stamped Letter 8 0.03 lbs $3.00 $3.06 $-0.06
220896 2021-01-23 $46.77 Priority Mail 3-Day Padded Flat Rate Envelope 2 1.25 lbs $8.85 $8.00 $0.85
220898 2021-01-23 $32.53 Priority Mail 3-Day 1 1.10 lbs $12.54 $23.38 $-10.84
220900 2021-01-23 $7.71 First-Class Package Service 1 0.10 lbs $3.72 $3.22 $0.50
220901 2021-01-24 $33.37 USPSPriority 1 5.30 lbs $13.78 $9.64 $4.14
220906 2021-01-23 $83.73 Priority Mail 3-Day Flat Rate Envelope 2 2.90 lbs $8.25 $7.70 $0.55
220907 2021-01-24 $7.53 USPSFirstClass 1 0.06 lbs $4.22 $3.35 $0.87
220908 2021-01-23 $17.04 First-Class Package Service 2 0.44 lbs $6.06 $4.53 $1.53
220909 2021-01-23 $16.89 First-Class Package Service 2 0.60 lbs $5.91 $5.66 $0.25
220910 2021-01-24 $19.30 USPSFirstClass 1 0.95 lbs $9.01 $8.85 $0.16
220911 2021-01-24 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56