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
220073 2021-01-10 $9.39 First-Class Mail Stamped Letter 1 0.15 lbs $3.40 $3.35 $0.05
220075 2021-01-10 $30.34 Priority Mail 2-Day 10 1.90 lbs $9.44 $8.12 $1.32
220077 2021-01-10 $47.64 Priority Mail 3-Day 1 2.20 lbs $14.34 $11.13 $3.21
220078 2021-01-10 $7.71 USPSFirstClass 1 0.06 lbs $4.22 $3.05 $1.17
220080 2021-01-10 $68.28 Priority Mail 2-Day Flat Rate Envelope 2 2.02 lbs $8.00 $7.65 $0.35
220081 2021-01-10 $9.65 USPSFirstClass 1 0.10 lbs $4.46 $3.18 $1.28
220082 2021-01-10 $17.96 USPSFirstClass 2 0.04 lbs $8.38 $2.84 $5.54
220084 2021-01-10 $61.68 Priority Mail 2-Day Medium Flat Rate Box 5 3.57 lbs $14.45 $8.00 $6.45
220085 2021-01-10 $35.89 USPSPriority 1 1.70 lbs $15.90 $11.18 $4.72
220086 2021-01-10 $14.05 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
220087 2021-01-10 $8.24 First-Class Mail Stamped Letter 1 0.12 lbs $3.25 $3.31 $-0.06
220088 2021-01-10 $55.19 USPSFirstClass 1 0.00 lbs $7.39 $4.46 $2.93
220091 2021-01-10 $13.68 First-Class Package Service 2 0.20 lbs $3.70 $2.78 $0.92
220092 2021-01-10 $21.61 First-Class Package Service 2 0.10 lbs $3.63 $3.67 $-0.04
220094 2021-01-10 $9.33 USPSFirstClass 1 0.04 lbs $4.44 $3.18 $1.26
220096 2021-01-10 $14.42 First-Class Package Service 2 0.28 lbs $3.84 $3.39 $0.45
220097 2021-01-10 $7.66 USPSFirstClass 1 0.04 lbs $4.17 $2.93 $1.24
220098 2021-01-10 $11.04 First-Class Mail Stamped Letter 1 0.15 lbs $3.25 $2.93 $0.32
220099 2021-01-10 $32.90 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.18 lbs $8.60 $7.75 $0.85
220102 2021-01-10 $8.28 First-Class Package Service 1 0.10 lbs $3.29 $2.84 $0.45
220103 2021-01-10 $10.84 USPSFirstClass 2 0.12 lbs $4.22 $3.05 $1.17
220104 2021-01-10 $22.45 First-Class Package Service 1 0.35 lbs $3.76 $3.31 $0.45
220106 2021-01-10 $7.86 USPSFirstClass 1 0.03 lbs $4.37 $3.18 $1.19
220107 2021-01-10 $9.99 Priority Mail 2-Day Flat Rate Envelope 1 0.19 lbs $8.00 $7.15 $0.85
220108 2021-01-10 $77.11 USPSPriority 1 1.19 lbs $14.05 $7.65 $6.40
220109 2021-01-10 $9.35 USPSFirstClass 1 0.05 lbs $4.16 $2.78 $1.38
220111 2021-01-11 $9.19 USPSFirstClass 1 0.10 lbs $4.20 $2.84 $1.36
220112 2021-01-11 $96.67 UPSGround 1 4.34 lbs $29.26 $32.03 $-2.77
220115 2021-01-10 $47.67 Priority Mail 3-Day Flat Rate Envelope 3 1.06 lbs $8.00 $15.80 $-7.80
220116 2021-01-11 $9.19 USPSFirstClass 1 0.10 lbs $4.20 $2.84 $1.36
220117 2021-01-10 $34.56 First-Class Package Service 1 0.45 lbs $4.57 $4.32 $0.25
220118 2021-01-11 $9.29 USPSFirstClass 1 0.10 lbs $4.30 $3.05 $1.25
220119 2021-01-10 $51.75 First-Class Package Service 1 0.25 lbs $3.76 $3.31 $0.45
220120 2021-01-10 $66.05 Priority Mail 2-Day 12 4.80 lbs $25.37 $24.52 $0.85
220121 2021-01-10 $103.82 Priority Mail 3-Day Medium Flat Rate Box 3 3.75 lbs $14.45 $10.82 $3.63
220122 2021-01-10 $23.92 First-Class Package Service 1 0.60 lbs $4.43 $5.40 $-0.97
220124 2021-01-10 $14.49 Priority Mail 2-Day Small Flat Rate Box 1 0.10 lbs $8.50 $7.65 $0.85
220125 2021-01-11 $18.66 USPSFirstClass 2 0.10 lbs $8.88 $3.18 $5.70
220128 2021-01-11 $9.33 USPSFirstClass 1 0.05 lbs $4.44 $3.18 $1.26
220129 2021-01-11 $32.44 USPSFirstClass 4 1.86 lbs $17.28 $12.15 $5.13
220130 2021-01-11 $17.00 USPSFirstClass 1 0.29 lbs $5.29 $3.25 $2.04
220131 2021-01-11 $4.94 USPSFirstClass 1 0.03 lbs $3.95 $2.78 $1.17
220132 2021-01-10 $8.22 First-Class Package Service 1 0.10 lbs $3.23 $2.78 $0.45
220133 2021-01-11 $31.62 USPSFirstClass 4 1.80 lbs $16.86 $9.54 $7.32
220134 2021-01-11 $33.39 USPSFirstClass 1 0.25 lbs $5.40 $3.39 $2.01
220135 2021-01-11 $9.33 USPSFirstClass 1 0.05 lbs $4.44 $3.18 $1.26
220136 2021-01-11 $34.24 First-Class Package Service 1 0.45 lbs $4.25 $4.00 $0.25
220137 2021-01-11 $27.33 First-Class Package Service 2 0.74 lbs $6.15 $5.98 $0.17
220139 2021-01-11 $61.41 Priority Mail 3-Day 2 4.60 lbs $15.03 $14.18 $0.85
220142 2021-01-11 $11.93 First-Class Mail Stamped Letter 2 0.10 lbs $3.25 $3.85 $-0.60
220144 2021-01-11 $44.39 Priority Mail 2-Day 2 0.75 lbs $8.41 $7.75 $0.66
220145 2021-01-11 $12.34 USPSFirstClass 1 0.06 lbs $4.35 $2.84 $1.51
220146 2021-01-11 $7.66 USPSFirstClass 1 0.04 lbs $4.17 $2.93 $1.24
220148 2021-01-11 $18.06 USPSFirstClass 2 0.10 lbs $8.28 $2.78 $5.50
220149 2021-01-11 $21.40 USPSFirstClass 4 0.60 lbs $5.84 $4.32 $1.52
220150 2021-01-11 $6.21 First-Class Package Service 1 0.19 lbs $4.12 $3.18 $0.94
220152 2021-01-11 $5.40 First-Class Mail Stamped Letter 5 0.05 lbs $2.95 $2.78 $0.17
220153 2021-01-11 $19.84 First-Class Package Service 1 0.86 lbs $5.85 $5.40 $0.45
220154 2021-01-11 $9.14 USPSFirstClass 1 0.03 lbs $4.15 $2.78 $1.37
220155 2021-01-11 $17.05 USPSFirstClass 1 0.29 lbs $5.34 $3.31 $2.03
220156 2021-01-11 $19.16 USPSFirstClass 1 0.05 lbs $4.77 $3.05 $1.72
220158 2021-01-11 $12.38 USPSFirstClass 1 0.15 lbs $4.59 $3.18 $1.41
220159 2021-01-11 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.90 $0.60
220160 2021-01-11 $10.63 First-Class Package Service - Retail 2 0.10 lbs $4.85 $2.93 $1.92
220161 2021-01-12 $28.29 USPSFirstClass 3 1.82 lbs $16.92 $9.54 $7.38
220164 2021-01-11 $33.56 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
220165 2021-01-11 $65.83 Priority Mail 3-Day 3 1.72 lbs $10.84 $9.98 $0.86
220166 2021-01-11 $39.30 Priority Mail 2-Day Small Flat Rate Box 1 0.18 lbs $8.50 $7.65 $0.85
220167 2021-01-11 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
220168 2021-01-12 $11.32 USPSFirstClass 1 0.05 lbs $4.54 $3.18 $1.36
220169 2021-01-11 $92.64 Ground 4 2.38 lbs $26.65 $16.61 $10.04
220170 2021-01-12 $17.20 USPSFirstClass 1 0.29 lbs $5.49 $3.52 $1.97
220171 2021-01-12 $25.00 USPSFirstClass 3 1.20 lbs $13.63 $9.99 $3.64
220172 2021-01-11 $23.68 First-Class Package Service 1 0.35 lbs $3.70 $3.25 $0.45
220173 2021-01-12 $16.31 USPSFirstClass 1 0.10 lbs $4.59 $2.93 $1.66
220174 2021-01-12 $24.59 USPSFirstClass 6 0.90 lbs $12.65 $9.99 $2.66
220175 2021-01-12 $8.68 USPSFirstClass 1 0.40 lbs $4.89 $4.00 $0.89
220176 2021-01-11 $64.70 Priority Mail 3-Day Large Flat Rate Box 5 4.20 lbs $19.15 $17.40 $1.75
220177 2021-01-11 $13.64 Priority Mail 3-Day 1 0.05 lbs $8.65 $7.80 $0.85
220178 2021-01-11 $39.76 Priority Mail 2-Day 2 3.45 lbs $11.18 $9.01 $2.17
220181 2021-01-12 $88.33 Priority Mail 3-Day 2 4.80 lbs $10.35 $9.64 $0.71
220182 2021-01-12 $9.29 USPSFirstClass 1 0.05 lbs $4.30 $3.05 $1.25
220184 2021-01-12 $9.95 First-Class Package Service 2 0.31 lbs $3.97 $3.52 $0.45
220185 2021-01-12 $6.98 USPSFirstClass 1 0.10 lbs $4.09 $2.84 $1.25
220187 2021-01-12 $9.56 First-Class Package Service 1 0.42 lbs $4.57 $4.32 $0.25
220189 2021-01-12 $7.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $2.84 $0.26
220190 2021-01-12 $18.29 USPSPriority 1 0.95 lbs $9.30 $7.65 $1.65
220191 2021-01-12 $8.04 USPSFirstClass 1 0.06 lbs $4.05 $2.76 $1.29
220192 2021-01-12 $43.55 Ground 1 3.20 lbs $22.81 $19.35 $3.46
220194 2021-01-12 $23.30 First-Class Package Service 1 0.40 lbs $4.91 $4.46 $0.45
220195 2021-01-12 $6.93 USPSFirstClass 1 0.05 lbs $4.04 $2.78 $1.26
220196 2021-01-12 $28.98 Priority Mail 2-Day 1 2.52 lbs $18.99 $15.74 $3.25
220197 2021-01-12 $53.47 Priority Mail 3-Day Flat Rate Envelope 3 2.59 lbs $8.00 $7.65 $0.35
220198 2021-01-12 $7.90 First-Class Mail Stamped Letter 5 0.02 lbs $2.95 $3.18 $-0.23
220199 2021-01-12 $23.66 First-Class Package Service 1 0.35 lbs $3.68 $3.97 $-0.29
220201 2021-01-12 $8.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.05 $0.05
220203 2021-01-12 $9.29 USPSFirstClass 1 0.03 lbs $4.30 $3.05 $1.25
220205 2021-01-13 $15.25 USPSFirstClass 1 0.17 lbs $4.54 $3.39 $1.15
220206 2021-01-12 $12.35 Priority Mail 2-Day Flat Rate Envelope 1 0.10 lbs $8.00 $7.65 $0.35
220207 2021-01-13 $18.66 USPSFirstClass 2 0.10 lbs $8.88 $3.18 $5.70
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56