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
220208 2021-01-13 $14.69 USPSFirstClass 3 0.09 lbs $4.22 $3.05 $1.17
220209 2021-01-13 $11.34 USPSFirstClass 1 0.06 lbs $4.35 $2.93 $1.42
220210 2021-01-13 $9.28 USPSFirstClass 2 0.40 lbs $5.10 $3.67 $1.43
220211 2021-01-12 $8.77 First-Class Mail Stamped Letter 3 0.03 lbs $3.10 $3.05 $0.05
220213 2021-01-13 $14.02 USPSFirstClass 2 0.10 lbs $4.24 $2.93 $1.31
220214 2021-01-13 $7.86 USPSFirstClass 1 0.03 lbs $4.37 $3.18 $1.19
220217 2021-01-12 $30.99 Priority Mail 2-Day Small Flat Rate Box 1 0.27 lbs $8.50 $7.65 $0.85
220220 2021-01-12 $13.99 Priority Mail 2-Day 1 0.05 lbs $9.00 $8.15 $0.85
220221 2021-01-12 $27.99 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
220222 2021-01-13 $9.87 USPSFirstClass 1 0.13 lbs $4.28 $2.93 $1.35
220223 2021-01-13 $9.92 USPSFirstClass 1 0.13 lbs $4.33 $3.05 $1.28
220225 2021-01-12 $64.23 Priority Mail 3-Day 1 3.95 lbs $10.24 $9.53 $0.71
220226 2021-01-12 $15.48 Priority Mail 2-Day Small Flat Rate Box 2 0.08 lbs $8.50 $7.56 $0.94
220227 2021-01-12 $15.92 First-Class Package Service 5 0.24 lbs $3.97 $3.52 $0.45
220231 2021-01-13 $113.97 Priority Mail 2-Day 3 0.75 lbs $9.00 $7.75 $1.25
220232 2021-01-13 $13.91 USPSFirstClass 1 0.10 lbs $4.42 $2.84 $1.58
220233 2021-01-13 $23.96 Priority Mail 2-Day Flat Rate Envelope 4 0.27 lbs $8.00 $7.65 $0.35
220234 2021-01-13 $8.94 First-Class Mail Stamped Letter 1 0.02 lbs $2.95 $3.18 $-0.23
220235 2021-01-13 $11.34 USPSFirstClass 1 0.19 lbs $4.35 $2.93 $1.42
220237 2021-01-13 $18.41 USPSPriority 1 0.10 lbs $8.92 $7.98 $0.94
220238 2021-01-13 $42.45 Priority Mail 2-Day 3 0.80 lbs $12.04 $15.74 $-3.70
220239 2021-01-13 $8.94 First-Class Mail Stamped Letter 1 0.01 lbs $2.95 $3.18 $-0.23
220240 2021-01-13 $54.11 Priority Mail 3-Day Small Flat Rate Box 1 1.38 lbs $8.50 $7.75 $0.75
220241 2021-01-13 $8.77 USPSFirstClass 1 0.45 lbs $5.08 $4.32 $0.76
220242 2021-01-13 $12.08 USPSFirstClass 1 0.15 lbs $4.29 $3.25 $1.04
220243 2021-01-13 $24.16 USPSFirstClass 2 0.12 lbs $8.58 $2.78 $5.80
220244 2021-01-13 $20.38 USPSFirstClass 2 0.12 lbs $4.40 $2.93 $1.47
220246 2021-01-13 $15.30 First-Class Package Service 3 0.45 lbs $4.33 $5.27 $-0.94
220247 2021-01-13 $22.59 First-Class Package Service 13 0.82 lbs $5.72 $5.27 $0.45
220248 2021-01-13 $93.98 Priority Mail 3-Day Flat Rate Envelope 2 3.00 lbs $8.00 $8.45 $-0.45
220249 2021-01-13 $18.96 First-Class Package Service 1 0.30 lbs $3.97 $3.52 $0.45
220250 2021-01-13 $10.39 First-Class Mail Stamped Letter 1 0.19 lbs $3.40 $2.93 $0.47
220251 2021-01-13 $7.71 USPSFirstClass 1 0.06 lbs $4.22 $3.05 $1.17
220252 2021-01-13 $23.26 First-Class Package Service 1 0.18 lbs $3.97 $3.05 $0.92
220253 2021-01-13 $8.19 USPSFirstClass 1 0.19 lbs $4.20 $2.93 $1.27
220254 2021-01-13 $20.32 USPSFirstClass 2 0.77 lbs $8.74 $7.98 $0.76
220255 2021-01-13 $24.86 First-Class Package Service 1 0.65 lbs $5.37 $4.00 $1.37
220259 2021-01-13 $80.00 Priority Mail 3-Day 1 3.50 lbs $15.01 $16.14 $-1.13
220262 2021-01-13 $24.06 First-Class Package Service 1 0.60 lbs $4.57 $35.65 $-31.08
220263 2021-01-13 $11.09 First-Class Mail Stamped Letter 1 0.04 lbs $3.10 $2.84 $0.26
220265 2021-01-13 $66.21 Ground 2 2.20 lbs $26.23 $21.91 $4.32
220266 2021-01-13 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
220267 2021-01-13 $37.29 Priority Mail 2-Day Small Flat Rate Box 1 1.10 lbs $8.50 $7.65 $0.85
220268 2021-01-14 $9.45 USPSFirstClass 1 0.10 lbs $4.26 $2.93 $1.33
220269 2021-01-13 $26.64 First-Class Package Service 1 0.45 lbs $4.45 $4.00 $0.45
220272 2021-01-13 $6.94 First-Class Mail Stamped Letter 1 0.03 lbs $2.95 $3.05 $-0.10
220274 2021-01-13 $10.89 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.00 $7.75 $0.25
220275 2021-01-13 $56.49 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.65 $0.85
220276 2021-01-14 $36.09 USPSFirstClass 1 0.56 lbs $7.10 $5.54 $1.56
220277 2021-01-14 $26.97 USPSFirstClass 3 0.57 lbs $6.00 $3.52 $2.48
220278 2021-01-13 $48.09 Priority Mail 3-Day Padded Flat Rate Envelope 1 2.65 lbs $8.60 $7.75 $0.85
220279 2021-01-13 $16.48 Priority Mail 2-Day Small Flat Rate Box 2 0.13 lbs $8.50 $7.65 $0.85
220282 2021-01-13 $23.49 Priority Mail 2-Day Flat Rate Envelope 1 0.35 lbs $8.00 $7.65 $0.35
220283 2021-01-13 $22.05 First-Class Package Service 1 0.30 lbs $3.76 $3.31 $0.45
220285 2021-01-13 $20.13 First-Class Mail Stamped Letter 12 0.14 lbs $3.25 $3.05 $0.20
220286 2021-01-13 $4.93 First-Class Mail Stamped Letter 2 0.02 lbs $2.95 $2.93 $0.02
220287 2021-01-13 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
220288 2021-01-13 $79.97 Priority Mail 3-Day 8 4.52 lbs $10.35 $9.39 $0.96
220289 2021-01-14 $12.59 USPSFirstClass 1 0.06 lbs $4.60 $3.18 $1.42
220290 2021-01-14 $10.05 First-Class Mail Stamped Letter 5 0.08 lbs $3.10 $3.57 $-0.47
220294 2021-01-14 $54.79 USPSPriority 1 1.25 lbs $16.80 $7.65 $9.15
220295 2021-01-14 $11.34 USPSFirstClass 1 0.19 lbs $4.35 $2.93 $1.42
220297 2021-01-14 $8.19 USPSFirstClass 1 0.03 lbs $4.20 $2.93 $1.27
220298 2021-01-14 $30.69 Priority Mail 2-Day Small Flat Rate Box 1 0.40 lbs $8.50 $7.65 $0.85
220300 2021-01-14 $23.99 Priority Mail 2-Day Small Flat Rate Box 1 0.35 lbs $8.50 $7.65 $0.85
220301 2021-01-14 $11.34 USPSFirstClass 1 0.19 lbs $4.35 $2.93 $1.42
220303 2021-01-14 $8.74 USPSFirstClass 3 0.06 lbs $4.27 $3.67 $0.60
220304 2021-01-14 $23.15 First-Class Package Service 5 0.25 lbs $3.70 $3.25 $0.45
220306 2021-01-14 $6.29 USPSFirstClass 1 0.19 lbs $4.30 $3.18 $1.12
220309 2021-01-14 $25.11 First-Class Package Service 1 0.35 lbs $4.12 $3.67 $0.45
220310 2021-01-14 $8.14 USPSFirstClass 1 0.06 lbs $4.15 $2.84 $1.31
220311 2021-01-14 $25.00 First-Class Package Service 2 0.16 lbs $3.63 $3.67 $-0.04
220312 2021-01-14 $19.11 First-Class Package Service 1 0.30 lbs $4.12 $3.67 $0.45
220313 2021-01-14 $13.86 First-Class Package Service 5 0.51 lbs $4.91 $5.98 $-1.07
220314 2021-01-14 $16.43 USPSFirstClass 1 0.10 lbs $4.64 $3.52 $1.12
220315 2021-01-14 $110.57 Priority Mail 3-Day Padded Flat Rate Envelope 3 3.75 lbs $8.60 $7.75 $0.85
220318 2021-01-14 $277.53 Priority Mail 2-Day 1 14.40 lbs $40.80 $41.98 $-1.18
220323 2021-01-14 $49.99 Priority Mail 2-Day Flat Rate Envelope 2 1.55 lbs $8.00 $7.65 $0.35
220325 2021-01-14 $21.17 Priority Mail 3-Day Small Flat Rate Box 3 0.31 lbs $8.50 $7.65 $0.85
220326 2021-01-14 $27.10 First-Class Package Service 1 0.40 lbs $4.91 $3.67 $1.24
220327 2021-01-14 $72.78 USPSFirstClass 5 0.47 lbs $10.56 $4.18 $6.38
220329 2021-01-14 $36.49 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
220330 2021-01-14 $15.55 First-Class Package Service 1 0.30 lbs $3.76 $3.31 $0.45
220331 2021-01-14 $23.84 First-Class Package Service - Retail 1 0.30 lbs $5.55 $3.25 $2.30
220332 2021-01-14 $7.61 USPSFirstClass 1 0.03 lbs $4.12 $2.84 $1.28
220334 2021-01-14 $22.13 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
220338 2021-01-15 $17.69 USPSFirstClass 1 0.05 lbs $4.70 $3.05 $1.65
220339 2021-01-14 $7.58 First-Class Package Service 1 0.10 lbs $3.23 $2.78 $0.45
220340 2021-01-14 $17.68 First-Class Mail Stamped Letter 7 0.09 lbs $3.25 $2.93 $0.32
220343 2021-01-14 $12.77 First-Class Package Service 1 0.10 lbs $3.23 $2.78 $0.45
220345 2021-01-15 $7.08 USPSFirstClass 1 0.10 lbs $4.19 $3.05 $1.14
220346 2021-01-14 $34.83 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.25 lbs $8.60 $7.65 $0.95
220347 2021-01-14 $23.31 First-Class Package Service 1 0.30 lbs $3.66 $3.21 $0.45
220349 2021-01-14 $28.48 Priority Mail 2-Day Small Flat Rate Box 1 0.35 lbs $8.50 $7.65 $0.85
220350 2021-01-15 $10.13 USPSFirstClass 1 0.25 lbs $4.34 $15.27 $-10.93
220351 2021-01-14 $22.88 First-Class Package Service 5 0.38 lbs $3.97 $3.69 $0.28
220352 2021-01-15 $9.45 USPSFirstClass 1 0.10 lbs $4.26 $2.93 $1.33
220353 2021-01-14 $27.85 Priority Mail 2-Day 1 1.10 lbs $10.84 $10.44 $0.40
220354 2021-01-14 $22.13 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
220355 2021-01-15 $6.83 USPSFirstClass 1 0.06 lbs $4.04 $2.78 $1.26
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56