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
219949 2021-01-08 $20.75 Priority Mail 2-Day 2 0.10 lbs $9.27 $7.65 $1.62
219951 2021-01-08 $156.04 USPSPriority 1 2.88 lbs $19.38 $10.33 $9.05
219952 2021-01-08 $104.43 Ground 2 5.05 lbs $30.45 $22.52 $7.93
219954 2021-01-08 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
219955 2021-01-08 $9.13 USPSFirstClass 1 0.04 lbs $4.24 $2.93 $1.31
219956 2021-01-08 $28.36 USPSFirstClass 2 0.12 lbs $8.88 $7.80 $1.08
219957 2021-01-08 $38.26 USPSFirstClass 4 0.76 lbs $10.30 $3.39 $6.91
219958 2021-01-08 $80.49 Priority Mail 3-Day 3 3.27 lbs $16.91 $18.46 $-1.55
219959 2021-01-08 $41.59 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.75 lbs $8.60 $7.75 $0.85
219960 2021-01-08 $42.07 Priority Mail 2-Day 17 0.42 lbs $12.04 $8.42 $3.62
219963 2021-01-08 $5.89 First-Class Package Service 1 0.19 lbs $3.70 $3.25 $0.45
219964 2021-01-08 $96.82 Priority Mail 2-Day Medium Flat Rate Box 7 2.91 lbs $14.45 $10.82 $3.63
219965 2021-01-08 $47.98 Priority Mail 2-Day Small Flat Rate Box 2 0.60 lbs $8.50 $7.65 $0.85
219966 2021-01-08 $13.96 USPSFirstClass 1 0.10 lbs $4.47 $2.93 $1.54
219967 2021-01-08 $14.24 USPSFirstClass 1 0.50 lbs $5.25 $4.18 $1.07
219969 2021-01-08 $54.10 Priority Mail 2-Day Small Flat Rate Box 3 1.05 lbs $8.50 $7.65 $0.85
219970 2021-01-08 $8.88 USPSFirstClass 1 0.47 lbs $5.09 $4.32 $0.77
219971 2021-01-08 $8.29 First-Class Mail Stamped Letter 1 0.08 lbs $3.10 $2.84 $0.26
219973 2021-01-08 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
219974 2021-01-08 $15.06 USPSFirstClass 2 0.90 lbs $7.68 $7.64 $0.04
219975 2021-01-08 $23.53 USPSFirstClass 3 1.35 lbs $12.46 $7.64 $4.82
219977 2021-01-08 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
219978 2021-01-08 $12.08 USPSFirstClass 1 0.06 lbs $4.29 $2.78 $1.51
219979 2021-01-08 $59.87 Priority Mail 3-Day Large Flat Rate Box 5 10.55 lbs $19.15 $18.30 $0.85
219980 2021-01-08 $19.87 USPSFirstClass 2 0.77 lbs $8.29 $8.12 $0.17
219982 2021-01-08 $8.09 First-Class Mail Stamped Letter 1 0.07 lbs $3.10 $2.78 $0.32
219983 2021-01-09 $8.19 USPSFirstClass 1 0.06 lbs $4.20 $2.93 $1.27
219984 2021-01-09 $10.50 USPSFirstClass 2 0.12 lbs $3.96 $2.74 $1.22
219985 2021-01-09 $17.64 USPSFirstClass 1 0.05 lbs $4.65 $2.93 $1.72
219986 2021-01-08 $43.49 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
219987 2021-01-09 $15.59 USPSFirstClass 1 0.10 lbs $4.60 $3.05 $1.55
219989 2021-01-08 $82.40 Priority Mail 2-Day Medium Flat Rate Box 3 4.95 lbs $14.45 $11.97 $2.48
219990 2021-01-08 $47.65 Direct Link International 6 0.76 lbs $23.71 $13.49 $10.22
219991 2021-01-08 $40.34 First-Class Package Service 5 0.80 lbs $5.99 $5.54 $0.45
219992 2021-01-09 $24.34 USPSFirstClass 5 0.25 lbs $4.89 $3.25 $1.64
219993 2021-01-08 $40.40 First-Class Package Service 3 0.57 lbs $4.63 $4.38 $0.25
219994 2021-01-08 $57.39 Priority Mail 2-Day 2 1.80 lbs $9.61 $9.01 $0.60
219995 2021-01-08 $12.33 First-Class Package Service 3 0.49 lbs $5.37 $3.25 $2.12
219996 2021-01-09 $7.43 USPSFirstClass 1 0.06 lbs $4.16 $2.93 $1.23
220000 2021-01-09 $15.87 Priority Mail 2-Day Flat Rate Envelope 3 0.10 lbs $8.00 $7.65 $0.35
220002 2021-01-09 $86.23 Priority Mail 3-Day Medium Flat Rate Box 4 3.70 lbs $20.40 $13.75 $6.65
220004 2021-01-09 $11.39 USPSFirstClass 1 0.19 lbs $4.40 $3.05 $1.35
220005 2021-01-09 $17.20 USPSFirstClass 1 0.29 lbs $5.49 $3.52 $1.97
220006 2021-01-09 $14.05 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
220007 2021-01-09 $9.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $2.84 $0.26
220008 2021-01-09 $65.05 Priority Mail 2-Day Flat Rate Envelope 5 1.85 lbs $8.00 $15.80 $-7.80
220009 2021-01-09 $9.40 USPSFirstClass 1 0.10 lbs $4.21 $2.84 $1.37
220010 2021-01-09 $29.87 Priority Mail 2-Day 1 1.95 lbs $9.44 $7.75 $1.69
220011 2021-01-09 $15.76 First-Class Package Service 1 0.20 lbs $3.97 $3.52 $0.45
220012 2021-01-09 $8.47 USPSFirstClass 1 0.10 lbs $4.12 $2.78 $1.34
220013 2021-01-09 $23.90 Priority Mail 3-Day Small Flat Rate Box 2 0.45 lbs $8.50 $7.65 $0.85
220014 2021-01-09 $38.25 USPSFirstClass 1 0.45 lbs $6.49 $4.32 $2.17
220016 2021-01-09 $9.81 USPSFirstClass 1 0.06 lbs $4.32 $3.05 $1.27
220018 2021-01-09 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.45 lbs $8.50 $7.90 $0.60
220019 2021-01-09 $6.93 USPSFirstClass 1 0.10 lbs $4.04 $2.78 $1.26
220020 2021-01-09 $128.74 USPSPriority 1 3.00 lbs $18.75 $14.16 $4.59
220021 2021-01-09 $10.12 USPSFirstClass 1 0.05 lbs $4.34 $3.05 $1.29
220022 2021-01-09 $7.04 USPSFirstClass 1 0.10 lbs $4.05 $2.78 $1.27
220023 2021-01-09 $17.51 USPSFirstClass 3 0.45 lbs $5.84 $4.32 $1.52
220024 2021-01-09 $8.62 USPSFirstClass 1 0.05 lbs $4.27 $3.05 $1.22
220025 2021-01-09 $9.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.05 $0.05
220026 2021-01-09 $11.29 USPSFirstClass 1 0.19 lbs $4.30 $2.84 $1.46
220028 2021-01-09 $13.08 First-Class Mail Stamped Letter 2 0.20 lbs $3.10 $2.93 $0.17
220030 2021-01-09 $33.56 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
220031 2021-01-09 $29.70 First-Class Package Service 2 0.23 lbs $4.12 $3.18 $0.94
220032 2021-01-09 $12.99 Priority Mail 2-Day 1 0.03 lbs $9.00 $3.05 $5.95
220033 2021-01-09 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.50 $15.80 $-7.30
220035 2021-01-09 $7.09 First-Class Mail Stamped Letter 1 0.08 lbs $3.10 $2.78 $0.32
220036 2021-01-09 $116.35 Priority Mail 2-Day 6 3.10 lbs $10.31 $8.34 $1.97
220037 2021-01-09 $48.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.65 lbs $8.60 $7.75 $0.85
220038 2021-01-09 $19.49 Priority Mail 2-Day Small Flat Rate Box 1 0.33 lbs $8.50 $7.65 $0.85
220039 2021-01-09 $3.94 First-Class Mail Stamped Letter 1 0.01 lbs $2.95 $2.93 $0.02
220040 2021-01-09 $5.85 First-Class Package Service 3 0.03 lbs $3.38 $2.93 $0.45
220041 2021-01-10 $7.56 USPSFirstClass 1 0.03 lbs $4.07 $2.78 $1.29
220042 2021-01-09 $50.56 Priority Mail 2-Day 8 1.34 lbs $10.84 $9.99 $0.85
220043 2021-01-09 $71.66 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.31 lbs $8.60 $7.75 $0.85
220045 2021-01-09 $15.13 First-Class Package Service 3 0.12 lbs $3.70 $3.51 $0.19
220046 2021-01-09 $38.27 Priority Mail 2-Day Flat Rate Envelope 1 0.96 lbs $8.00 $7.65 $0.35
220047 2021-01-10 $8.19 USPSFirstClass 1 0.04 lbs $4.20 $2.93 $1.27
220048 2021-01-10 $12.18 USPSFirstClass 1 0.06 lbs $4.39 $2.93 $1.46
220049 2021-01-09 $9.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.06 $0.04
220050 2021-01-09 $64.23 Priority Mail 2-Day 1 3.95 lbs $10.24 $9.53 $0.71
220051 2021-01-10 $9.22 USPSFirstClass 1 0.61 lbs $5.63 $5.27 $0.36
220052 2021-01-10 $12.08 USPSFirstClass 1 0.15 lbs $4.29 $3.25 $1.04
220053 2021-01-09 $7.62 First-Class Package Service 1 0.03 lbs $3.63 $3.18 $0.45
220054 2021-01-10 $27.88 USPSFirstClass 1 0.00 lbs $6.47 $3.25 $3.22
220055 2021-01-09 $27.82 Priority Mail 2-Day 2 0.73 lbs $10.84 $7.98 $2.86
220056 2021-01-09 $8.49 First-Class Package Service 1 0.10 lbs $3.50 $3.05 $0.45
220057 2021-01-10 $8.46 USPSFirstClass 1 0.40 lbs $5.07 $3.52 $1.55
220058 2021-01-10 $16.48 USPSFirstClass 2 0.51 lbs $9.30 $4.32 $4.98
220059 2021-01-09 $40.54 Priority Mail 2-Day Flat Rate Envelope 2 2.50 lbs $8.00 $7.75 $0.25
220060 2021-01-10 $13.86 USPSFirstClass 1 0.10 lbs $4.37 $2.78 $1.59
220061 2021-01-09 $9.08 First-Class Mail Stamped Letter 2 0.06 lbs $3.10 $2.93 $0.17
220063 2021-01-10 $33.11 USPSPriority 1 1.00 lbs $9.62 $22.78 $-13.16
220064 2021-01-10 $15.25 USPSFirstClass 1 0.17 lbs $4.54 $3.39 $1.15
220065 2021-01-10 $8.42 First-Class Package Service 1 0.10 lbs $3.23 $2.78 $0.45
220067 2021-01-10 $29.48 Priority Mail 3-Day Small Flat Rate Box 2 0.41 lbs $8.50 $7.65 $0.85
220068 2021-01-10 $13.91 First-Class Package Service 1 0.30 lbs $3.70 $3.25 $0.45
220070 2021-01-10 $26.52 Direct Link International 1 0.08 lbs $21.33 $8.81 $12.52
220072 2021-01-10 $7.56 USPSFirstClass 1 0.04 lbs $4.07 $2.78 $1.29
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56