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
224991 2021-05-15 $29.19 First-Class Package Service 1 0.45 lbs $5.40 $3.57 $1.83
224995 2021-05-15 $10.59 First-Class Mail Stamped Letter 1 0.03 lbs $3.80 $3.49 $0.31
224996 2021-05-15 $17.99 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.69 $0.31
224997 2021-05-15 $10.77 First-Class Package Service 1 0.15 lbs $4.78 $3.22 $1.56
224999 2021-05-15 $60.48 Priority Mail 2-Day Flat Rate Envelope 2 1.68 lbs $8.50 $7.90 $0.60
225000 2021-05-15 $38.47 Priority Mail 2-Day Flat Rate Envelope 3 0.95 lbs $8.50 $15.80 $-7.30
225001 2021-05-16 $8.44 USPSFirstClass 1 0.05 lbs $4.45 $3.22 $1.23
225002 2021-05-15 $46.69 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $9.00 $7.90 $1.10
225005 2021-05-15 $136.23 Ground 6 5.43 lbs $43.29 $19.23 $24.06
225006 2021-05-16 $57.99 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $9.00 $7.90 $1.10
225010 2021-05-16 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.12 $0.68
225012 2021-05-16 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.06 $0.74
225015 2021-05-16 $9.91 USPSFirstClass 1 0.06 lbs $4.52 $3.22 $1.30
225017 2021-05-16 $26.12 First-Class Package Service 1 0.60 lbs $5.63 $4.68 $0.95
225020 2021-05-16 $6.56 First-Class Mail Stamped Letter 4 0.04 lbs $3.60 $3.35 $0.25
225024 2021-05-16 $49.08 Priority Mail 3-Day Padded Flat Rate Envelope 2 2.10 lbs $9.10 $8.85 $0.25
225026 2021-05-16 $17.49 Priority Mail 2-Day Small Flat Rate Box 1 0.05 lbs $9.00 $7.90 $1.10
225027 2021-05-16 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
225028 2021-05-16 $9.91 USPSFirstClass 1 0.06 lbs $4.52 $3.22 $1.30
225029 2021-05-16 $24.42 First-Class Mail Stamped Letter 8 0.11 lbs $4.00 $3.35 $0.65
225030 2021-05-16 $75.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.80 lbs $9.10 $8.00 $1.10
225032 2021-05-16 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
225034 2021-05-16 $10.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.06 $0.74
225035 2021-05-16 $28.38 First-Class Package International Service 1 0.19 lbs $25.39 $17.34 $8.05
225042 2021-05-17 $85.05 Priority Mail 3-Day 1 3.50 lbs $20.06 $21.96 $-1.90
225043 2021-05-17 $72.99 Priority Mail 2-Day 1 2.06 lbs $15.20 $11.42 $3.78
225044 2021-05-17 $16.15 First-Class Package Service 1 0.35 lbs $4.66 $3.46 $1.20
225045 2021-05-17 $6.60 USPSFirstClass 1 0.01 lbs $4.41 $3.35 $1.06
225046 2021-05-17 $8.55 USPSMedia 1 0.23 lbs $3.16 $2.89 $0.27
225047 2021-05-17 $10.74 USPSFirstClass 1 0.04 lbs $4.75 $3.49 $1.26
225048 2021-05-17 $67.19 Priority Mail 2-Day 1 1.70 lbs $15.20 $11.63 $3.57
225051 2021-05-17 $42.00 First-Class Package Service 1 0.70 lbs $7.01 $5.81 $1.20
225052 2021-05-17 $37.41 USPSPriority 1 2.60 lbs $12.35 $9.21 $3.14
225053 2021-05-17 $13.79 USPSFirstClass 1 0.07 lbs $7.60 $3.12 $4.48
225054 2021-05-17 $63.21 Priority Mail 2-Day Flat Rate Envelope 2 3.80 lbs $8.50 $8.00 $0.50
225055 2020-10-16 $70.78 Priority Mail 2-Day Flat Rate Envelope 2 0.90 lbs $8.40 $7.90 $0.50
225059 2021-05-17 $56.98 Priority Mail 2-Day Large Flat Rate Box 2 9.08 lbs $20.40 $19.30 $1.10
225060 2021-05-17 $57.99 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $9.00 $7.90 $1.10
225062 2021-05-17 $9.70 First-Class Mail Stamped Letter 1 0.03 lbs $3.80 $3.49 $0.31
225064 2021-05-17 $27.78 First-Class Package Service 1 0.35 lbs $4.89 $3.69 $1.20
225065 2021-05-17 $10.03 First-Class Package Service 1 0.20 lbs $4.64 $3.69 $0.95
225068 2021-05-17 $14.99 Priority Mail 2-Day Small Flat Rate Box 1 0.05 lbs $9.00 $7.90 $1.10
225069 2021-05-18 $10.78 First-Class Mail Stamped Letter 2 0.06 lbs $3.80 $3.06 $0.74
225071 2021-05-18 $23.09 Priority Mail 2-Day 6 1.20 lbs $9.95 $8.85 $1.10
225073 2021-05-18 $7.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.22 $0.58
225074 2021-05-18 $19.41 USPSFirstClass 1 0.05 lbs $5.02 $3.35 $1.67
225075 2021-05-18 $9.29 USPSFirstClass 1 0.50 lbs $5.30 $5.81 $-0.51
225078 2021-05-18 $57.99 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $9.00 $7.90 $1.10
225079 2021-05-18 $61.48 Priority Mail 3-Day Small Flat Rate Box 2 1.69 lbs $9.00 $7.90 $1.10
225080 2021-05-18 $29.19 First-Class Package Service 1 0.45 lbs $5.40 $4.20 $1.20
225081 2021-05-18 $57.99 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $9.00 $7.90 $1.10
225082 2021-05-18 $175.88 2nd Day Air 1 7.20 lbs $83.72 $79.21 $4.51
225083 2021-05-18 $205.53 Ground 4 8.96 lbs $27.27 $18.03 $9.24
225084 2021-05-18 $49.94 Priority Mail 3-Day 1 1.40 lbs $9.95 $8.85 $1.10
225088 2021-05-18 $42.58 First-Class Package Service 4 0.65 lbs $6.62 $5.42 $1.20
225092 2021-05-18 $11.09 First-Class Mail Stamped Letter 1 0.06 lbs $3.80 $3.06 $0.74
225093 2021-05-18 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.12 $0.68
225097 2021-05-18 $39.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225101 2021-05-19 $20.51 First-Class Package Service 1 0.45 lbs $5.73 $4.53 $1.20
225102 2021-05-19 $16.65 First-Class Package Service 1 0.30 lbs $4.66 $3.46 $1.20
225103 2021-05-19 $20.42 USPSFirstClass 2 0.12 lbs $4.84 $3.49 $1.35
225104 2021-05-19 $5.34 USPSFirstClass 1 0.03 lbs $4.35 $3.35 $1.00
225106 2021-05-19 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225109 2021-05-19 $10.30 First-Class Package Service 12 0.12 lbs $4.42 $3.22 $1.20
225112 2021-05-19 $42.28 Priority Mail 3-Day Flat Rate Envelope 2 1.45 lbs $8.50 $7.90 $0.60
225114 2021-05-19 $11.69 First-Class Mail Stamped Letter 1 0.07 lbs $3.80 $3.49 $0.31
225118 2021-05-19 $25.56 First-Class Package Service 1 0.60 lbs $5.07 $5.27 $-0.20
225119 2021-05-19 $110.39 Priority Mail 2-Day 11 1.98 lbs $10.74 $9.64 $1.10
225121 2021-05-19 $57.99 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $9.00 $7.90 $1.10
225125 2021-05-20 $58.62 Priority Mail 3-Day Padded Flat Rate Envelope 1 3.75 lbs $9.10 $8.00 $1.10
225127 2021-05-20 $42.17 First-Class Package Service 1 0.70 lbs $7.18 $5.98 $1.20
225128 2021-05-20 $41.46 First-Class Package Service 1 0.70 lbs $6.47 $5.27 $1.20
225129 2021-05-20 $10.51 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.01 $0.99
225131 2021-05-20 $9.91 USPSFirstClass 1 0.06 lbs $4.52 $3.22 $1.30
225132 2021-05-20 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
225133 2021-05-20 $29.54 USPSPriority 1 1.70 lbs $9.55 $7.83 $1.72
225134 2021-05-20 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
225135 2021-05-20 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225137 2021-05-20 $39.05 Priority Mail 3-Day Flat Rate Envelope 2 1.25 lbs $8.50 $8.00 $0.50
225138 2021-05-20 $52.34 Ground 9 0.94 lbs $21.61 $15.94 $5.67
225143 2021-05-20 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.06 $0.74
225147 2021-05-20 $18.84 First-Class Package Service 5 0.24 lbs $4.89 $7.38 $-2.49
225148 2021-05-20 $19.38 First-Class Mail Stamped Letter 2 0.08 lbs $3.80 $3.06 $0.74
225149 2021-05-20 $5.09 First-Class Mail Stamped Letter 1 0.02 lbs $3.60 $3.12 $0.48
225150 2021-05-20 $28.37 First-Class Package Service 4 0.31 lbs $4.71 $8.24 $-3.53
225151 2021-05-20 $65.79 Priority Mail 3-Day 1 1.70 lbs $13.80 $21.78 $-7.98
225153 2021-05-20 $16.77 First-Class Package Service 2 0.25 lbs $4.89 $6.70 $-1.81
225155 2021-05-20 $28.06 First-Class Package Service 1 0.50 lbs $6.37 $8.40 $-2.03
225157 2021-05-21 $8.91 USPSFirstClass 1 0.03 lbs $4.42 $3.12 $1.30
225158 2021-05-21 $61.36 Priority Mail 3-Day Medium Flat Rate Box 4 4.60 lbs $15.40 $13.75 $1.65
225159 2021-05-21 $11.61 First-Class Package Service 2 0.40 lbs $5.63 $9.36 $-3.73
225163 2021-05-21 $66.53 Priority Mail 2-Day 1 1.45 lbs $11.54 $10.44 $1.10
225164 2021-05-21 $17.04 USPSFirstClass 1 0.30 lbs $5.76 $3.85 $1.91
225165 2021-05-21 $17.97 First-Class Mail Stamped Letter 2 0.09 lbs $4.00 $6.24 $-2.24
225166 2021-05-21 $11.09 First-Class Mail Stamped Letter 1 0.06 lbs $3.80 $6.98 $-3.18
225167 2021-05-21 $33.42 Priority Mail 3-Day 3 0.97 lbs $9.95 $17.70 $-7.75
225170 2021-05-21 $14.54 First-Class Package Service 1 0.13 lbs $4.55 $6.70 $-2.15
225172 2021-05-21 $23.63 First-Class Package Service 1 0.65 lbs $6.37 $10.84 $-4.47
225174 2021-05-21 $14.23 First-Class Package Service 2 0.32 lbs $5.15 $8.40 $-3.25
225175 2021-05-21 $43.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $15.80 $-6.80
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56