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
216330 2020-10-08 $16.87 USPSFirstClass 3 0.07 lbs $4.25 $3.05 $1.20
216333 2020-10-08 $37.48 First-Class Package Service 3 0.54 lbs $4.91 $4.46 $0.45
216334 2020-10-08 $8.57 First-Class Package Service 1 0.10 lbs $3.38 $2.93 $0.45
216335 2020-10-08 $86.70 Ground 23 4.51 lbs $23.06 $20.33 $2.73
216338 2020-10-08 $6.28 First-Class Package Service 1 0.02 lbs $3.29 $2.84 $0.45
216339 2020-10-08 $93.50 Priority Mail 2-Day 1 2.40 lbs $9.92 $8.59 $1.33
216340 2020-10-08 $4.34 First-Class Mail Stamped Letter 1 0.01 lbs $3.35 $3.18 $0.17
216342 2020-10-08 $9.14 First-Class Mail Stamped Letter 1 0.15 lbs $3.65 $3.31 $0.34
216345 2020-10-08 $14.07 First-Class Package Service 5 0.15 lbs $4.12 $3.18 $0.94
216346 2020-10-08 $13.95 First-Class Package Service 2 0.20 lbs $3.97 $3.05 $0.92
216347 2020-10-08 $9.72 USPSFirstClass 1 0.05 lbs $4.24 $2.93 $1.31
216348 2020-10-09 $5.86 USPSFirstClass 1 0.03 lbs $4.02 $2.84 $1.18
216350 2020-10-08 $17.40 First-Class Package Service 1 0.40 lbs $4.91 $4.46 $0.45
216351 2020-10-08 $20.67 First-Class Package Service 2 0.39 lbs $4.53 $3.31 $1.22
216352 2020-10-09 $16.07 USPSFirstClass 1 0.35 lbs $5.50 $4.46 $1.04
216353 2020-10-08 $24.48 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
216355 2020-10-08 $91.56 Priority Mail 2-Day Large Flat Rate Box 9 3.55 lbs $19.15 $8.15 $11.00
216358 2020-10-08 $40.75 Priority Mail 2-Day Flat Rate Envelope 5 1.13 lbs $8.00 $8.15 $-0.15
216359 2020-10-08 $118.98 Priority Mail 2-Day 7 1.79 lbs $16.59 $15.74 $0.85
216360 2020-10-08 $15.63 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
216361 2020-10-09 $29.96 Priority Mail 3-Day 10 1.43 lbs $8.97 $8.21 $0.76
216363 2020-10-09 $66.79 Priority Mail 3-Day 1 2.40 lbs $13.00 $12.15 $0.85
216364 2020-10-09 $31.99 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
216365 2020-10-09 $10.90 USPSFirstClass 3 0.09 lbs $4.30 $3.18 $1.12
216366 2020-10-09 $51.96 Priority Mail 3-Day 1 1.55 lbs $8.97 $8.05 $0.92
216368 2020-10-09 $44.91 First-Class Package Service 3 0.72 lbs $5.99 $4.32 $1.67
216370 2020-10-09 $9.51 USPSFirstClass 1 0.03 lbs $4.14 $2.78 $1.36
216371 2020-10-09 $38.29 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
216372 2020-10-09 $42.87 Priority Mail 3-Day Flat Rate Envelope 2 1.75 lbs $8.00 $7.75 $0.25
216376 2020-10-09 $106.28 Priority Mail 2-Day Medium Flat Rate Box 3 3.51 lbs $14.45 $7.65 $6.80
216377 2020-10-09 $19.48 Priority Mail 2-Day 1 0.30 lbs $9.27 $8.42 $0.85
216378 2020-10-09 $35.02 Ground 1 2.30 lbs $18.08 $17.21 $0.87
216379 2020-10-09 $46.96 Priority Mail 2-Day Small Flat Rate Box 2 1.70 lbs $8.50 $7.65 $0.85
216380 2020-10-09 $42.98 Priority Mail 3-Day Flat Rate Envelope 2 1.35 lbs $8.00 $7.65 $0.35
216381 2020-10-09 $15.98 Priority Mail 2-Day Flat Rate Envelope 2 0.10 lbs $8.00 $7.15 $0.85
216382 2020-10-10 $9.84 USPSFirstClass 1 0.04 lbs $4.29 $3.05 $1.24
216386 2020-10-10 $9.08 USPSFirstClass 1 0.05 lbs $4.19 $2.84 $1.35
216387 2020-10-10 $16.20 USPSFirstClass 1 0.05 lbs $4.50 $2.84 $1.66
216392 2020-10-10 $12.21 First-Class Mail Stamped Letter 4 0.14 lbs $3.65 $3.67 $-0.02
216393 2020-10-10 $9.98 USPSFirstClass 1 0.10 lbs $4.46 $3.18 $1.28
216394 2020-10-10 $142.25 Priority Mail 2-Day 35 14.00 lbs $23.60 $23.27 $0.33
216395 2020-10-10 $35.49 Priority Mail 3-Day Small Flat Rate Box 1 0.45 lbs $8.50 $7.65 $0.85
216397 2020-10-10 $89.95 Priority Mail 2-Day 5 2.27 lbs $13.00 $8.15 $4.85
216401 2020-10-10 $7.79 USPSFirstClass 1 0.03 lbs $4.12 $2.84 $1.28
216403 2020-10-10 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
216406 2020-10-10 $17.12 First-Class Package Service 1 0.40 lbs $4.63 $4.18 $0.45
216408 2020-10-10 $30.40 First-Class Package Service 5 0.55 lbs $4.45 $4.00 $0.45
216410 2020-10-10 $29.36 InternationalPriorityShipping 1 0.02 lbs $4.30 $3.05 $1.25
216412 2020-10-10 $94.30 Priority Mail 3-Day 1 3.90 lbs $10.24 $9.39 $0.85
216416 2020-10-10 $26.39 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
216419 2020-10-11 $28.73 USPSFirstClass 1 0.45 lbs $6.05 $4.46 $1.59
216420 2020-10-11 $7.19 USPSFirstClass 1 0.07 lbs $4.19 $3.52 $0.67
216421 2020-10-10 $33.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.33 lbs $8.60 $7.75 $0.85
216422 2020-10-10 $21.22 First-Class Package Service 2 0.35 lbs $3.84 $3.39 $0.45
216423 2020-10-10 $17.15 First-Class Package Service 8 0.16 lbs $3.23 $3.25 $-0.02
216426 2020-10-11 $19.16 Priority Mail 3-Day 1 0.60 lbs $8.97 $8.12 $0.85
216428 2020-10-11 $8.98 USPSFirstClass 1 0.10 lbs $4.12 $2.78 $1.34
216430 2020-10-11 $42.95 First-Class Package International Service 1 0.40 lbs $27.96 $11.64 $16.32
216431 2020-10-11 $13.85 First-Class Package Service 3 0.15 lbs $3.38 $2.93 $0.45
216434 2020-10-11 $11.81 USPSFirstClass 1 0.05 lbs $4.34 $2.93 $1.41
216435 2020-10-11 $13.28 First-Class Package Service 1 0.13 lbs $3.29 $3.31 $-0.02
216436 2020-10-11 $7.90 USPSFirstClass 1 0.04 lbs $4.22 $3.05 $1.17
216437 2020-10-11 $43.48 Ground 1 3.10 lbs $24.69 $22.19 $2.50
216438 2020-10-11 $13.45 First-Class Mail Stamped Letter 20 0.20 lbs $3.65 $3.18 $0.47
216439 2020-10-11 $36.99 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.65 $0.35
216441 2020-10-11 $28.45 First-Class Package Service 25 0.29 lbs $3.70 $2.78 $0.92
216443 2020-10-11 $13.13 First-Class Package Service 10 0.10 lbs $3.23 $2.78 $0.45
216447 2020-10-11 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
216448 2020-10-11 $19.26 Priority Mail 2-Day 1 0.95 lbs $8.97 $7.56 $1.41
216451 2020-10-12 $12.28 First-Class Package Service 1 0.08 lbs $3.29 $2.84 $0.45
216452 2020-10-12 $41.29 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.65 $0.85
216453 2020-10-12 $8.87 USPSFirstClass 1 0.10 lbs $4.12 $2.78 $1.34
216455 2020-10-12 $6.18 First-Class Package Service 1 0.10 lbs $3.29 $2.84 $0.45
216457 2020-10-12 $45.55 Priority Mail 2-Day 2 1.06 lbs $8.97 $8.12 $0.85
216458 2020-10-12 $12.85 USPSFirstClass 4 0.08 lbs $4.15 $4.32 $-0.17
216460 2020-10-12 $14.69 First-Class Package Service 1 0.30 lbs $3.70 $3.25 $0.45
216462 2020-10-12 $25.03 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
216463 2020-10-12 $11.18 First-Class Mail Stamped Letter 2 0.04 lbs $3.20 $2.78 $0.42
216464 2020-10-12 $99.71 First-Class Package International Service 12 2.19 lbs $48.73 $54.53 $-5.80
216465 2020-10-12 $12.14 First-Class Mail Stamped Letter 1 0.04 lbs $3.35 $3.18 $0.17
216466 2020-10-12 $15.63 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
216467 2020-10-12 $22.50 USPSFirstClass 2 0.77 lbs $9.89 $5.70 $4.19
216468 2020-10-12 $18.05 USPSFirstClass 1 0.16 lbs $4.66 $3.52 $1.14
216471 2020-10-12 $13.95 First-Class Package Service 2 0.20 lbs $3.97 $3.05 $0.92
216472 2020-10-12 $7.53 USPSFirstClass 1 0.10 lbs $4.09 $2.84 $1.25
216473 2020-10-12 $7.57 USPSFirstClass 1 0.10 lbs $4.09 $2.84 $1.25
216475 2020-10-12 $11.48 First-Class Mail Stamped Letter 2 0.14 lbs $3.50 $3.05 $0.45
216476 2020-10-12 $22.13 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
216478 2020-10-12 $125.80 Priority Mail 2-Day Medium Flat Rate Box 4 7.33 lbs $14.45 $11.53 $2.92
216479 2020-10-12 $8.60 USPSFirstClass 1 0.03 lbs $4.39 $3.18 $1.21
216483 2020-10-12 $6.34 First-Class Mail Stamped Letter 1 0.04 lbs $3.35 $3.18 $0.17
216485 2020-10-12 $36.49 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
216486 2020-10-12 $40.65 Priority Mail 3-Day Small Flat Rate Box 2 1.35 lbs $8.50 $7.65 $0.85
216487 2020-10-13 $22.59 First-Class Package Service 1 0.35 lbs $3.84 $3.39 $0.45
216488 2020-10-13 $37.08 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $8.00 $7.65 $0.35
216489 2020-10-13 $38.45 USPSFirstClass 1 0.64 lbs $7.20 $4.46 $2.74
216490 2020-10-13 $13.62 First-Class Package Service 1 0.13 lbs $3.63 $3.67 $-0.04
216491 2020-10-13 $12.39 Priority Mail 2-Day Flat Rate Envelope 1 0.07 lbs $8.00 $7.56 $0.44
216492 2020-10-13 $33.47 First-Class Package Service 1 0.65 lbs $4.38 $5.04 $-0.66
216494 2020-10-13 $16.63 First-Class Package Service 1 0.20 lbs $3.84 $3.39 $0.45
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56