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
221205 2021-01-29 $14.38 USPSFirstClass 1 0.06 lbs $4.64 $3.06 $1.58
221206 2021-01-29 $6.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.35 $-0.15
221207 2021-01-29 $25.60 USPSFirstClass 10 0.30 lbs $5.70 $3.51 $2.19
221208 2021-01-29 $5.84 First-Class Package Service 1 0.01 lbs $3.85 $3.35 $0.50
221209 2021-01-29 $20.55 First-Class Package Service 1 0.16 lbs $3.83 $3.58 $0.25
221210 2021-01-29 $6.51 First-Class Package Service 1 0.05 lbs $3.62 $3.12 $0.50
221211 2021-01-29 $28.24 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.25 $8.00 $0.25
221212 2021-01-29 $8.39 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.35 $0.05
221215 2021-01-29 $8.49 USPSFirstClass 1 0.06 lbs $4.50 $3.35 $1.15
221216 2021-01-29 $9.44 USPSFirstClass 1 0.10 lbs $4.45 $3.12 $1.33
221217 2021-01-18 $5.19 First-Class Package Service 1 0.05 lbs $0.00 $3.35 $-3.35
221218 2021-01-29 $18.38 USPSFirstClass 4 0.24 lbs $4.42 $3.22 $1.20
221220 2021-01-29 $19.38 Priority Mail 3-Day 1 0.95 lbs $9.09 $8.24 $0.85
221221 2021-01-30 $9.87 USPSFirstClass 2 0.12 lbs $4.29 $3.06 $1.23
221222 2021-01-29 $25.55 First-Class Package Service 1 0.65 lbs $6.06 $5.81 $0.25
221224 2021-01-29 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221225 2021-01-29 $75.61 Priority Mail 3-Day Medium Flat Rate Box 2 3.73 lbs $15.00 $13.75 $1.25
221227 2021-01-30 $19.30 USPSFirstClass 1 0.95 lbs $9.01 $8.85 $0.16
221228 2021-01-29 $5.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.35 $-0.15
221230 2021-01-30 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
221234 2021-01-29 $80.98 Priority Mail 3-Day Medium Flat Rate Box 5 1.85 lbs $15.00 $11.69 $3.31
221235 2021-01-30 $13.43 USPSFirstClass 1 0.05 lbs $4.64 $3.12 $1.52
221238 2021-01-30 $7.81 USPSFirstClass 1 0.03 lbs $4.32 $3.06 $1.26
221239 2021-01-30 $19.30 USPSFirstClass 1 0.95 lbs $9.01 $8.85 $0.16
221240 2021-01-30 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.75 $7.90 $0.85
221242 2021-01-30 $39.74 Priority Mail 3-Day 1 1.20 lbs $9.95 $7.90 $2.05
221243 2021-01-30 $15.75 USPSFirstClass 4 0.24 lbs $4.59 $3.85 $0.74
221247 2021-01-30 $17.85 Priority Mail 3-Day 1 0.14 lbs $8.73 $7.90 $0.83
221248 2021-01-30 $13.42 USPSFirstClass 3 0.10 lbs $4.45 $3.35 $1.10
221249 2021-01-30 $19.60 USPSPriority 1 0.95 lbs $9.31 $10.44 $-1.13
221252 2021-01-30 $9.59 First-Class Mail Stamped Letter 1 0.18 lbs $3.60 $3.06 $0.54
221253 2021-01-30 $33.37 First-Class Package Service 1 0.55 lbs $4.88 $4.38 $0.50
221254 2021-01-30 $7.69 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
221256 2021-01-30 $8.59 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.12 $0.28
221258 2021-01-30 $19.99 Priority Mail 2-Day 1 0.95 lbs $9.70 $8.85 $0.85
221259 2021-01-30 $39.53 First-Class Package Service 5 0.38 lbs $4.63 $4.38 $0.25
221260 2021-01-30 $17.18 First-Class Package Service 1 0.28 lbs $4.19 $3.69 $0.50
221261 2021-01-30 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
221262 2021-01-30 $6.28 USPSFirstClass 1 0.01 lbs $4.39 $3.35 $1.04
221263 2021-01-30 $199.83 Priority Mail 2-Day Medium Flat Rate Box 37 1.93 lbs $15.00 $11.69 $3.31
221265 2021-01-30 $13.43 USPSFirstClass 1 0.05 lbs $4.64 $3.12 $1.52
221266 2021-01-30 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
221268 2021-01-30 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
221269 2021-01-30 $33.37 First-Class Package Service 1 0.55 lbs $4.88 $4.38 $0.50
221270 2021-01-30 $22.15 Priority Mail 2-Day 1 0.95 lbs $11.86 $11.01 $0.85
221271 2021-01-30 $10.17 USPSFirstClass 1 0.13 lbs $4.58 $3.35 $1.23
221272 2021-01-30 $34.18 USPSPriority 1 2.10 lbs $13.82 $9.01 $4.81
221275 2021-01-30 $10.97 First-Class Package Service 3 0.06 lbs $3.56 $3.51 $0.05
221276 2021-01-31 $5.34 USPSFirstClass 1 0.19 lbs $4.35 $3.35 $1.00
221277 2021-01-31 $19.30 USPSFirstClass 1 0.95 lbs $9.01 $9.64 $-0.63
221278 2021-01-31 $8.91 USPSFirstClass 1 0.22 lbs $4.52 $3.69 $0.83
221281 2021-01-30 $62.74 Priority Mail 2-Day 25 5.00 lbs $10.49 $9.53 $0.96
221282 2021-01-30 $14.63 First-Class Mail Stamped Letter 2 0.15 lbs $3.40 $3.01 $0.39
221283 2021-01-31 $7.78 USPSFirstClass 1 0.06 lbs $4.47 $3.35 $1.12
221285 2021-01-30 $667.65 Priority Mail 2-Day Large Flat Rate Box 15 22.75 lbs $22.80 $19.20 $3.60
221288 2021-01-30 $68.14 Priority Mail 3-Day Flat Rate Envelope 3 2.23 lbs $8.25 $8.00 $0.25
221291 2021-01-31 $10.65 USPSFirstClass 1 0.06 lbs $4.55 $3.22 $1.33
221292 2021-01-30 $11.30 First-Class Package Service 1 0.04 lbs $3.51 $3.01 $0.50
221293 2021-01-30 $22.59 First-Class Package Service 3 0.40 lbs $4.62 $3.51 $1.11
221294 2021-01-30 $10.78 First-Class Package Service 1 0.03 lbs $3.99 $3.49 $0.50
221295 2021-01-31 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.75 $7.90 $0.85
221296 2021-01-31 $8.70 USPSFirstClass 1 0.01 lbs $4.65 $3.49 $1.16
221299 2021-01-31 $62.66 Ground 1 1.55 lbs $19.67 $17.41 $2.26
221301 2021-01-31 $67.14 USPSPriority 1 1.31 lbs $13.77 $8.00 $5.77
221302 2021-01-31 $55.69 Priority Mail 3-Day Medium Flat Rate Box 1 1.75 lbs $10.00 $7.90 $2.10
221303 2021-01-31 $52.53 Priority Mail 2-Day 1 1.15 lbs $12.54 $12.66 $-0.12
221304 2021-01-31 $13.78 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.35 $0.05
221305 2021-01-31 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.75 $8.25 $0.50
221309 2021-01-31 $66.14 USPSPriority 1 1.31 lbs $12.77 $8.00 $4.77
221310 2021-01-31 $19.12 USPSFirstClass 2 0.40 lbs $5.34 $4.38 $0.96
221311 2021-01-31 $16.20 USPSFirstClass 2 0.10 lbs $4.74 $3.49 $1.25
221312 2021-01-31 $77.36 Ground 3 3.75 lbs $20.39 $17.89 $2.50
221313 2021-01-31 $9.58 USPSFirstClass 1 0.04 lbs $4.69 $3.49 $1.20
221314 2021-01-31 $14.89 USPSFirstClass 3 0.15 lbs $4.42 $3.22 $1.20
221315 2021-01-31 $5.45 First-Class Mail Stamped Letter 5 0.05 lbs $3.00 $3.12 $-0.12
221316 2021-01-31 $7.18 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.35 $-0.15
221318 2021-01-31 $9.03 First-Class Package Service 1 0.07 lbs $3.51 $3.01 $0.50
221319 2021-01-31 $25.55 First-Class Package Service 1 0.80 lbs $6.06 $4.53 $1.53
221320 2021-01-31 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221321 2021-01-31 $43.23 Priority Mail 2-Day 11 1.31 lbs $12.54 $8.00 $4.54
221322 2021-01-31 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.75 $7.90 $0.85
221323 2021-01-31 $14.64 USPSFirstClass 1 0.50 lbs $5.65 $5.98 $-0.33
221324 2021-01-31 $10.75 First-Class Mail Stamped Letter 15 0.15 lbs $3.40 $3.06 $0.34
221325 2021-01-31 $23.28 Priority Mail 2-Day Flat Rate Envelope 7 0.95 lbs $8.25 $7.90 $0.35
221326 2021-01-31 $5.19 First-Class Mail Stamped Letter 1 0.07 lbs $3.20 $3.35 $-0.15
221328 2021-01-31 $23.83 Priority Mail 2-Day Flat Rate Envelope 2 0.08 lbs $8.25 $7.90 $0.35
221330 2021-01-31 $74.13 Priority Mail 2-Day 1 3.90 lbs $20.14 $19.29 $0.85
221331 2021-02-01 $21.61 USPSFirstClass 1 0.04 lbs $5.12 $3.35 $1.77
221332 2021-02-01 $9.38 USPSFirstClass 1 0.05 lbs $4.49 $3.22 $1.27
221333 2021-01-31 $33.34 Priority Mail 2-Day 5 1.34 lbs $9.09 $8.24 $0.85
221336 2021-01-31 $52.81 Priority Mail 2-Day Padded Flat Rate Envelope 4 1.40 lbs $8.85 $8.00 $0.85
221338 2021-01-31 $39.28 Priority Mail 3-Day 1 0.95 lbs $11.29 $10.44 $0.85
221340 2021-01-31 $36.06 Priority Mail 2-Day 3 1.50 lbs $9.09 $8.72 $0.37
221341 2021-01-31 $38.93 First-Class Package Service 5 0.82 lbs $6.48 $5.98 $0.50
221342 2021-02-01 $14.89 USPSFirstClass 3 0.09 lbs $4.42 $3.22 $1.20
221343 2021-02-01 $18.13 USPSFirstClass 1 0.17 lbs $4.82 $3.51 $1.31
221344 2021-02-01 $39.58 USPSFirstClass 1 0.58 lbs $7.55 $5.98 $1.57
221345 2021-02-01 $14.43 USPSFirstClass 1 0.06 lbs $4.69 $3.12 $1.57
221346 2021-02-01 $7.44 USPSFirstClass 1 0.03 lbs $4.45 $3.35 $1.10
221347 2021-02-01 $516.06 Priority Mail International 161 35.85 lbs $183.93 $174.47 $9.46
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56