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
224052 2021-04-09 $33.81 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
224053 2021-04-10 $38.85 Priority Mail 3-Day 10 2.34 lbs $13.55 $12.70 $0.85
224055 2021-04-10 $63.73 Priority Mail 3-Day Small Flat Rate Box 2 0.55 lbs $8.75 $7.90 $0.85
224057 2021-04-10 $54.05 Priority Mail 2-Day Medium Flat Rate Box 1 1.85 lbs $15.00 $12.64 $2.36
224059 2021-04-10 $29.57 First-Class Package Service 4 0.36 lbs $4.63 $4.38 $0.25
224060 2021-04-10 $18.97 First-Class Package Service 2 0.30 lbs $4.08 $3.58 $0.50
224061 2021-04-10 $6.99 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.22 $-0.22
224062 2021-04-10 $93.10 Priority Mail 3-Day Medium Flat Rate Box 2 3.70 lbs $15.00 $10.89 $4.11
224063 2021-04-10 $17.36 First-Class Package Service 1 0.40 lbs $4.37 $20.84 $-16.47
224064 2021-04-10 $25.37 First-Class Package Service 3 0.38 lbs $4.19 $3.69 $0.50
224067 2021-04-10 $43.29 Priority Mail 2-Day 7 1.48 lbs $13.55 $10.44 $3.11
224068 2021-04-10 $16.98 First-Class Package Service 1 0.25 lbs $4.19 $3.69 $0.50
224069 2021-04-10 $31.79 Priority Mail 2-Day 6 3.99 lbs $9.05 $8.20 $0.85
224070 2021-04-10 $9.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
224071 2021-04-10 $64.92 Priority Mail 2-Day Medium Flat Rate Box 3 2.15 lbs $15.00 $12.13 $2.87
224072 2021-04-10 $27.10 First-Class Package Service 3 0.19 lbs $3.76 $3.51 $0.25
224074 2021-04-10 $16.87 First-Class Package Service 1 0.20 lbs $4.08 $3.58 $0.50
224077 2021-04-10 $35.35 Priority Mail 2-Day 3 0.90 lbs $11.86 $11.01 $0.85
224078 2021-04-10 $43.70 First-Class Package Service 12 0.52 lbs $4.62 $4.12 $0.50
224079 2021-04-10 $6.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.22 $-0.02
224080 2021-04-10 $5.49 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.22 $-0.22
224081 2021-04-11 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
224083 2021-04-10 $16.16 First-Class Mail Stamped Letter 4 0.06 lbs $3.20 $3.22 $-0.02
224086 2021-04-10 $8.19 First-Class Mail Stamped Letter 1 0.08 lbs $3.20 $3.35 $-0.15
224090 2021-04-10 $28.49 First-Class Package Service 3 0.50 lbs $4.62 $4.12 $0.50
224091 2021-04-11 $16.19 First-Class Mail Stamped Letter 2 0.13 lbs $3.40 $3.85 $-0.45
224092 2021-04-11 $8.64 USPSFirstClass 1 0.10 lbs $4.65 $3.49 $1.16
224093 2021-04-11 $13.38 USPSFirstClass 1 0.04 lbs $4.59 $3.06 $1.53
224094 2021-04-11 $36.00 First-Class Package Service 1 0.31 lbs $4.01 $3.51 $0.50
224096 2021-04-11 $22.75 First-Class Package Service 12 0.27 lbs $4.07 $3.57 $0.50
224098 2021-04-11 $7.59 USPSFirstClass 1 0.10 lbs $4.60 $3.49 $1.11
224100 2021-04-11 $34.98 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.75 $7.90 $0.85
224102 2021-04-11 $53.62 Priority Mail 2-Day Flat Rate Envelope 4 1.43 lbs $8.25 $7.90 $0.35
224103 2021-04-11 $40.51 First-Class Package Service 2 0.70 lbs $6.23 $6.28 $-0.05
224105 2021-04-11 $5.29 USPSFirstClass 1 0.01 lbs $4.30 $3.22 $1.08
224106 2021-04-11 $25.19 USPSFirstClass 1 0.03 lbs $5.20 $3.12 $2.08
224108 2021-04-11 $6.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.49 $-0.49
224109 2021-04-11 $31.08 First-Class Package International Service 1 0.04 lbs $25.09 $17.34 $7.75
224111 2021-04-11 $42.04 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.77 lbs $8.85 $8.00 $0.85
224113 2021-04-11 $22.21 First-Class Package Service 2 0.33 lbs $4.01 $4.12 $-0.11
224114 2021-04-11 $22.24 First-Class Package Service 1 0.80 lbs $5.48 $5.23 $0.25
224115 2021-04-11 $40.22 Priority Mail 2-Day 4 1.34 lbs $11.86 $11.01 $0.85
224117 2021-04-11 $40.96 First-Class Package Service 3 0.81 lbs $5.77 $5.27 $0.50
224118 2021-04-12 $9.39 First-Class Mail Stamped Letter 1 0.07 lbs $3.40 $3.51 $-0.11
224120 2021-04-12 $30.02 USPSFirstClass 4 0.30 lbs $5.26 $4.20 $1.06
224121 2021-04-12 $12.13 First-Class Package Service 2 0.54 lbs $4.54 $4.04 $0.50
224123 2021-04-12 $44.13 Priority Mail 3-Day 15 2.90 lbs $11.28 $9.64 $1.64
224124 2021-04-12 $13.87 First-Class Mail Stamped Letter 3 0.12 lbs $3.40 $3.06 $0.34
224125 2021-04-12 $24.26 First-Class Mail Stamped Letter 9 0.10 lbs $3.40 $3.46 $-0.06
224128 2021-04-10 $129.51 Ground 24 16.95 lbs $40.87 $18.93 $21.94
224130 2021-04-12 $19.59 First-Class Package Service 2 0.30 lbs $4.01 $3.51 $0.50
224131 2021-04-12 $201.17 Priority Mail 2-Day 1 14.05 lbs $26.37 $22.34 $4.03
224132 2021-04-13 $12.24 First-Class Package Service 1 0.20 lbs $4.35 $3.85 $0.50
224133 2021-04-13 $14.56 First-Class Package Service 1 0.30 lbs $4.35 $4.68 $-0.33
224134 2021-04-13 $63.29 Priority Mail 2-Day Small Flat Rate Box 3 1.53 lbs $8.75 $7.90 $0.85
224135 2021-04-13 $7.39 USPSFirstClass 1 0.10 lbs $4.40 $3.22 $1.18
224136 2021-04-13 $10.24 USPSFirstClass 1 0.05 lbs $4.54 $3.22 $1.32
224137 2021-04-13 $14.58 USPSFirstClass 1 0.17 lbs $4.79 $3.69 $1.10
224138 2021-04-13 $67.78 Priority Mail 3-Day 2 1.40 lbs $17.30 $16.45 $0.85
224139 2021-04-13 $8.16 USPSMedia 1 0.23 lbs $3.14 $2.89 $0.25
224140 2021-04-13 $11.05 USPSFirstClass 1 0.15 lbs $4.76 $3.49 $1.27
224141 2021-04-13 $48.23 Priority Mail 2-Day Flat Rate Envelope 2 1.70 lbs $8.25 $8.00 $0.25
224142 2021-04-13 $19.86 First-Class Mail Stamped Letter 4 0.11 lbs $3.40 $3.85 $-0.45
224143 2021-04-13 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
224145 2021-04-13 $23.94 First-Class Package Service 1 0.60 lbs $4.45 $5.42 $-0.97
224146 2021-04-13 $37.74 Priority Mail 2-Day Flat Rate Envelope 2 1.30 lbs $8.25 $7.90 $0.35
224148 2021-04-13 $134.35 Priority Mail 2-Day 21 1.89 lbs $17.30 $11.69 $5.61
224150 2021-04-13 $39.70 Priority Mail 3-Day 5 0.73 lbs $8.73 $7.90 $0.83
224151 2021-04-13 $8.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
224152 2021-04-13 $73.38 Priority Mail 2-Day Medium Flat Rate Box 2 10.92 lbs $15.00 $13.75 $1.25
224153 2021-04-13 $85.13 Ground 1 25.05 lbs $37.14 $27.39 $9.75
224154 2021-04-14 $21.71 Priority Mail 3-Day 2 0.65 lbs $8.73 $7.88 $0.85
224157 2021-04-14 $24.42 First-Class Package Service 1 0.60 lbs $4.93 $5.98 $-1.05
224158 2021-04-14 $14.46 First-Class Package Service 3 0.12 lbs $3.99 $3.49 $0.50
224160 2021-04-14 $41.46 First-Class Package Service 2 0.60 lbs $4.88 $6.12 $-1.24
224161 2021-04-14 $9.87 USPSFirstClass 2 0.12 lbs $4.29 $3.06 $1.23
224162 2021-04-14 $10.03 USPSFirstClass 1 0.35 lbs $5.14 $4.12 $1.02
224163 2021-04-14 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
224164 2021-04-14 $5.71 USPSFirstClass 1 0.19 lbs $4.22 $3.06 $1.16
224165 2021-04-14 $6.91 USPSFirstClass 1 0.01 lbs $4.42 $3.35 $1.07
224166 2021-04-14 $42.78 Priority Mail 3-Day 1 1.20 lbs $11.29 $7.90 $3.39
224167 2021-04-14 $7.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.22 $-0.02
224168 2021-04-14 $33.24 USPSFirstClass 4 0.23 lbs $17.58 $5.42 $12.16
224172 2021-04-14 $35.25 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
224174 2021-04-14 $39.64 Priority Mail 2-Day 2 1.05 lbs $11.86 $11.01 $0.85
224175 2021-04-14 $10.80 USPSFirstClass 1 0.07 lbs $4.51 $3.12 $1.39
224181 2021-04-14 $35.44 Priority Mail 3-Day 2 0.85 lbs $11.29 $10.44 $0.85
224182 2021-04-14 $73.56 UPSGround 2 1.00 lbs $14.02 $16.54 $-2.52
224183 2021-04-14 $24.70 First-Class Package Service 1 0.90 lbs $6.31 $5.81 $0.50
224184 2021-04-14 $25.38 First-Class Package Service 1 0.12 lbs $3.85 $3.69 $0.16
224185 2021-04-14 $14.10 First-Class Mail Stamped Letter 1 0.06 lbs $3.20 $3.22 $-0.02
224186 2021-04-14 $7.91 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
224187 2021-04-15 $15.12 Priority Mail 1-Day Flat Rate Envelope 1 0.05 lbs $8.25 $7.90 $0.35
224188 2021-04-15 $74.61 Priority Mail 2-Day Large Flat Rate Box 4 5.63 lbs $20.15 $13.75 $6.40
224189 2021-04-15 $12.08 First-Class Package Service 1 0.20 lbs $4.19 $3.69 $0.50
224190 2021-04-15 $13.28 First-Class Package Service 7 0.26 lbs $4.35 $4.68 $-0.33
224192 2021-04-15 $201.18 Ground 4 9.60 lbs $17.54 $20.80 $-3.26
224193 2021-04-15 $7.06 USPSFirstClass 1 0.01 lbs $4.57 $3.49 $1.08
224195 2021-04-15 $25.16 First-Class Package Service 1 0.80 lbs $5.67 $5.42 $0.25
224196 2021-04-15 $35.17 First-Class Package Service 1 0.60 lbs $5.18 $5.98 $-0.80
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56