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
221053 2021-01-26 $11.60 First-Class Package Service 2 0.10 lbs $3.62 $3.12 $0.50
221054 2021-01-26 $25.01 First-Class Package Service 1 0.65 lbs $5.52 $5.27 $0.25
221055 2021-01-26 $36.23 Priority Mail 3-Day Flat Rate Envelope 2 1.72 lbs $8.25 $7.90 $0.35
221056 2021-01-26 $16.82 First-Class Package Service 1 0.45 lbs $5.03 $3.69 $1.34
221057 2021-01-27 $10.02 USPSFirstClass 2 0.15 lbs $4.44 $3.69 $0.75
221058 2021-01-26 $8.07 First-Class Package Service 1 0.05 lbs $3.72 $3.22 $0.50
221059 2021-01-27 $8.87 USPSFirstClass 1 0.05 lbs $4.52 $3.69 $0.83
221064 2021-01-26 $50.90 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $8.25 $8.00 $0.25
221065 2021-01-27 $9.60 USPSFirstClass 1 0.10 lbs $4.41 $3.51 $0.90
221066 2021-01-27 $16.54 USPSFirstClass 1 0.50 lbs $5.55 $4.38 $1.17
221067 2021-01-27 $26.69 Priority Mail 2-Day Small Flat Rate Box 6 0.20 lbs $8.75 $7.90 $0.85
221069 2021-01-27 $10.70 USPSFirstClass 1 0.06 lbs $4.60 $3.35 $1.25
221072 2021-01-27 $26.98 Priority Mail 3-Day 1 0.90 lbs $9.70 $8.00 $1.70
221075 2021-01-27 $38.66 Priority Mail 2-Day Flat Rate Envelope 3 1.65 lbs $8.25 $8.00 $0.25
221078 2021-01-27 $25.27 First-Class Package Service 4 0.64 lbs $6.31 $4.53 $1.78
221079 2021-01-27 $14.63 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.01 $0.39
221080 2021-01-27 $19.05 USPSFirstClass 1 0.95 lbs $8.76 $8.72 $0.04
221083 2021-01-27 $51.37 Priority Mail 3-Day Small Flat Rate Box 18 1.42 lbs $8.75 $7.90 $0.85
221084 2021-01-27 $19.00 First-Class Package Service 1 0.30 lbs $4.01 $3.51 $0.50
221085 2021-01-27 $25.40 First-Class Package Service 1 0.65 lbs $5.91 $5.66 $0.25
221086 2021-01-27 $15.18 First-Class Package Service 1 0.35 lbs $4.19 $3.69 $0.50
221089 2021-01-27 $8.34 USPSFirstClass 1 0.08 lbs $4.35 $3.06 $1.29
221090 2021-01-27 $18.78 First-Class Mail Stamped Letter 2 0.08 lbs $3.20 $3.06 $0.14
221091 2021-01-27 $18.18 USPSFirstClass 1 0.17 lbs $4.87 $3.57 $1.30
221092 2021-01-27 $10.54 USPSFirstClass 1 0.04 lbs $4.55 $3.22 $1.33
221097 2021-01-27 $6.49 USPSFirstClass 1 0.20 lbs $4.40 $3.69 $0.71
221098 2021-01-27 $9.59 USPSFirstClass 2 0.38 lbs $5.21 $4.53 $0.68
221102 2021-01-27 $14.95 USPSFirstClass 5 0.10 lbs $5.00 $5.27 $-0.27
221104 2021-01-27 $20.47 First-Class Package Service 5 0.62 lbs $4.62 $4.12 $0.50
221105 2020-10-20 $102.77 Ground 3 5.20 lbs $10.00 $8.73 $1.27
221106 2021-01-28 $14.69 USPSFirstClass 1 0.15 lbs $4.70 $3.57 $1.13
221107 2021-01-27 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.75 $7.90 $0.85
221108 2021-01-28 $10.70 USPSFirstClass 1 0.06 lbs $4.60 $3.35 $1.25
221110 2021-01-27 $50.46 First-Class Package International Service 3 0.34 lbs $25.09 $17.34 $7.75
221111 2021-01-28 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
221112 2021-01-28 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
221113 2021-01-28 $9.47 USPSFirstClass 1 0.25 lbs $4.45 $3.12 $1.33
221114 2021-01-28 $16.95 USPSFirstClass 2 0.68 lbs $5.97 $4.38 $1.59
221115 2021-01-28 $8.81 USPSFirstClass 1 0.23 lbs $4.42 $3.12 $1.30
221117 2021-01-27 $15.13 First-Class Package Service 2 0.25 lbs $4.35 $3.85 $0.50
221118 2021-01-28 $9.75 USPSFirstClass 1 0.10 lbs $4.56 $3.35 $1.21
221119 2021-01-27 $26.19 First-Class Package Service 1 0.35 lbs $4.70 $3.57 $1.13
221120 2021-01-27 $18.35 First-Class Mail Stamped Letter 5 0.17 lbs $3.40 $3.06 $0.34
221121 2021-01-27 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.75 $7.90 $0.85
221122 2021-01-27 $26.68 First-Class Package Service 1 0.27 lbs $4.19 $3.69 $0.50
221123 2021-01-27 $23.01 First-Class Package Service 1 0.40 lbs $4.62 $4.12 $0.50
221124 2021-01-28 $9.34 First-Class Package Service 1 0.22 lbs $4.35 $3.85 $0.50
221125 2021-01-28 $5.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.49 $-0.29
221127 2021-01-28 $43.29 Priority Mail 2-Day 1 2.40 lbs $17.30 $18.50 $-1.20
221128 2021-01-28 $23.35 USPSFirstClass 5 1.00 lbs $12.90 $8.85 $4.05
221129 2021-01-28 $19.41 USPSFirstClass 1 0.05 lbs $5.02 $3.35 $1.67
221131 2021-01-28 $24.10 USPSFirstClass 4 0.24 lbs $4.54 $4.53 $0.01
221133 2021-01-28 $13.88 First-Class Package Service 5 0.62 lbs $6.23 $5.98 $0.25
221135 2021-01-28 $10.47 USPSFirstClass 1 0.05 lbs $4.74 $3.49 $1.25
221136 2021-01-28 $30.83 Priority Mail 2-Day 6 2.40 lbs $10.49 $10.43 $0.06
221137 2021-01-28 $19.99 First-Class Package Service 13 0.14 lbs $3.72 $3.22 $0.50
221138 2021-01-28 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
221139 2021-01-28 $62.01 USPSFirstClass 6 2.31 lbs $27.27 $12.70 $14.57
221140 2021-01-28 $8.10 First-Class Mail Stamped Letter 10 0.10 lbs $3.20 $3.06 $0.14
221143 2021-01-28 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221145 2021-01-28 $19.22 First-Class Package Service 1 0.35 lbs $4.63 $4.38 $0.25
221146 2021-01-28 $40.81 Priority Mail 2-Day 1 1.25 lbs $8.64 $7.90 $0.74
221147 2021-01-28 $58.84 Priority Mail 3-Day Padded Flat Rate Envelope 1 2.06 lbs $8.85 $7.90 $0.95
221149 2021-01-28 $163.31 Priority Mail International 12 4.47 lbs $55.09 $52.39 $2.70
221151 2021-01-28 $19.83 Priority Mail 2-Day Padded Flat Rate Envelope 2 0.76 lbs $8.85 $8.00 $0.85
221152 2021-01-28 $15.54 First-Class Mail Stamped Letter 6 0.18 lbs $3.60 $3.49 $0.11
221153 2021-01-28 $11.64 USPSFirstClass 1 0.06 lbs $4.65 $3.35 $1.30
221155 2021-01-28 $71.71 Priority Mail 2-Day 1 3.95 lbs $17.72 $16.87 $0.85
221156 2021-01-28 $11.60 USPSFirstClass 2 0.12 lbs $4.62 $3.49 $1.13
221157 2021-01-28 $23.19 First-Class Package Service 1 0.35 lbs $4.35 $3.85 $0.50
221158 2021-01-28 $50.98 Priority Mail 2-Day Medium Flat Rate Box 2 1.88 lbs $15.00 $12.13 $2.87
221160 2021-01-28 $68.70 Priority Mail 2-Day 3 5.55 lbs $10.49 $9.52 $0.97
221161 2021-01-28 $45.09 Priority Mail 2-Day 2 1.60 lbs $8.64 $7.83 $0.81
221165 2021-01-28 $36.23 Priority Mail 3-Day Flat Rate Envelope 2 1.72 lbs $8.25 $7.90 $0.35
221166 2021-01-28 $74.13 Priority Mail 2-Day 1 3.95 lbs $20.14 $19.29 $0.85
221167 2021-01-28 $21.11 First-Class Package Service 14 0.17 lbs $4.45 $3.12 $1.33
221168 2021-01-28 $32.80 USPSFirstClass 1 0.06 lbs $5.56 $3.12 $2.44
221172 2021-01-28 $27.10 First-Class Package Service 2 0.74 lbs $5.92 $5.42 $0.50
221173 2021-01-28 $53.48 Priority Mail 2-Day 1 1.70 lbs $10.49 $9.01 $1.48
221174 2021-01-29 $32.85 USPSFirstClass 1 0.06 lbs $5.61 $3.22 $2.39
221175 2021-01-29 $34.58 USPSFirstClass 6 0.36 lbs $5.24 $4.38 $0.86
221176 2021-01-29 $32.90 USPSFirstClass 1 0.06 lbs $5.66 $3.35 $2.31
221177 2021-01-28 $8.36 First-Class Package Service 1 0.15 lbs $4.01 $3.06 $0.95
221179 2021-01-28 $49.08 Priority Mail 2-Day 1 1.15 lbs $9.09 $8.49 $0.60
221180 2021-01-29 $10.70 USPSFirstClass 1 0.07 lbs $4.51 $3.57 $0.94
221182 2021-01-29 $112.58 USPSPriority 1 1.19 lbs $14.98 $7.90 $7.08
221183 2021-01-28 $28.38 Priority Mail 2-Day 1 0.74 lbs $9.09 $8.24 $0.85
221185 2021-01-29 $16.49 USPSFirstClass 1 0.50 lbs $5.50 $3.57 $1.93
221186 2021-01-29 $24.43 Priority Mail 2-Day Padded Flat Rate Envelope 2 3.50 lbs $8.85 $9.52 $-0.67
221188 2021-01-29 $50.22 Priority Mail 2-Day Flat Rate Envelope 3 2.58 lbs $8.25 $7.90 $0.35
221190 2021-01-29 $31.53 First-Class Package Service 15 0.49 lbs $4.88 $4.38 $0.50
221193 2021-01-29 $52.94 Priority Mail 2-Day 1 1.55 lbs $9.95 $7.90 $2.05
221194 2021-01-29 $31.18 Priority Mail 3-Day Flat Rate Envelope 7 0.53 lbs $8.25 $7.90 $0.35
221196 2021-01-29 $8.38 First-Class Mail Stamped Letter 2 0.09 lbs $3.40 $3.12 $0.28
221197 2021-01-29 $8.39 USPSFirstClass 1 0.06 lbs $4.40 $3.12 $1.28
221198 2021-01-29 $7.68 USPSFirstClass 1 0.06 lbs $4.37 $3.12 $1.25
221199 2021-01-29 $12.49 First-Class Package Service 2 0.25 lbs $4.01 $3.51 $0.50
221200 2021-01-29 $36.74 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
221203 2021-01-29 $62.91 USPSFirstClass 6 2.31 lbs $28.17 $14.10 $14.07
221204 2021-01-29 $46.46 Priority Mail 3-Day 2 2.40 lbs $9.57 $8.00 $1.57
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56