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
215528 2020-09-12 $5.60 USPSFirstClass 1 0.01 lbs $4.25 $3.18 $1.07
215529 2020-09-12 $7.71 USPSFirstClass 1 0.03 lbs $3.97 $2.74 $1.23
215530 2020-09-12 $6.60 USPSFirstClass 1 0.01 lbs $4.29 $3.18 $1.11
215531 2020-09-11 $38.89 Priority Mail 2-Day 10 1.63 lbs $11.39 $10.54 $0.85
215532 2020-09-12 $6.62 USPSFirstClass 1 0.17 lbs $4.02 $3.25 $0.77
215535 2020-09-12 $12.74 First-Class Mail Stamped Letter 1 0.02 lbs $3.20 $3.31 $-0.11
215537 2020-09-12 $8.96 First-Class Package Service 1 0.20 lbs $3.97 $3.52 $0.45
215538 2020-09-12 $4.67 First-Class Mail Stamped Letter 3 0.03 lbs $3.20 $3.18 $0.02
215539 2020-09-12 $12.64 USPSFirstClass 1 0.31 lbs $5.14 $3.39 $1.75
215540 2020-09-12 $26.90 USPSFirstClass 1 0.95 lbs $8.85 $8.12 $0.73
215541 2020-09-12 $9.83 USPSFirstClass 1 0.20 lbs $4.25 $3.39 $0.86
215542 2020-09-12 $88.95 Priority Mail 3-Day 4 2.00 lbs $10.39 $9.54 $0.85
215544 2020-09-12 $43.42 First-Class Package Service 1 0.45 lbs $4.43 $4.18 $0.25
215545 2020-09-12 $9.71 USPSFirstClass 3 0.03 lbs $4.04 $2.84 $1.20
215547 2020-09-12 $22.39 Priority Mail 2-Day 2 0.38 lbs $8.41 $7.65 $0.76
215548 2020-09-12 $13.97 First-Class Mail Stamped Letter 3 0.15 lbs $3.50 $3.05 $0.45
215550 2020-09-12 $79.30 Priority Mail 2-Day 1 3.85 lbs $19.31 $18.46 $0.85
215551 2020-09-12 $123.79 Priority Mail 3-Day 3 7.95 lbs $12.82 $7.75 $5.07
215552 2020-09-12 $9.16 USPSFirstClass 1 0.05 lbs $4.22 $2.93 $1.29
215553 2020-09-12 $12.25 USPSFirstClass 1 0.20 lbs $4.54 $4.46 $0.08
215555 2020-09-12 $17.06 Priority Mail 2-Day Small Flat Rate Box 4 0.10 lbs $8.50 $7.65 $0.85
215556 2020-09-12 $168.87 Ground 3 12.27 lbs $33.90 $25.36 $8.54
215557 2020-09-13 $45.74 USPSFirstClass 1 0.45 lbs $6.75 $4.18 $2.57
215559 2020-09-13 $7.75 USPSFirstClass 1 0.25 lbs $4.34 $3.67 $0.67
215562 2020-09-13 $14.41 USPSFirstClass 1 0.05 lbs $4.40 $2.84 $1.56
215563 2020-09-12 $61.12 Priority Mail 3-Day Flat Rate Envelope 3 1.65 lbs $8.00 $7.65 $0.35
215564 2020-09-13 $11.77 USPSFirstClass 1 0.19 lbs $4.25 $2.78 $1.47
215566 2020-09-12 $19.58 First-Class Package Service 2 0.32 lbs $3.66 $3.21 $0.45
215567 2020-09-13 $7.46 USPSFirstClass 1 0.07 lbs $4.09 $2.84 $1.25
215568 2020-09-13 $8.71 USPSFirstClass 1 0.05 lbs $4.20 $2.93 $1.27
215570 2020-09-13 $128.05 Direct Link International 3 3.25 lbs $31.61 $22.90 $8.71
215572 2018-10-15 $88.66 Ground 3 2.65 lbs $19.39 $9.54 $9.85
215573 2020-09-13 $6.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.18 $0.02
215574 2020-09-13 $24.00 First-Class Package Service 1 0.60 lbs $4.71 $5.70 $-0.99
215576 2020-09-13 $7.34 First-Class Mail Stamped Letter 1 0.06 lbs $3.35 $3.05 $0.30
215577 2020-09-13 $49.02 USPSFirstClass 1 0.45 lbs $6.70 $4.08 $2.62
215578 2020-09-13 $7.16 First-Class Mail Stamped Letter 4 0.04 lbs $3.20 $3.18 $0.02
215579 2020-09-13 $17.18 First-Class Package Service 9 0.51 lbs $4.77 $3.52 $1.25
215580 2020-09-13 $9.82 USPSFirstClass 1 0.04 lbs $4.29 $3.05 $1.24
215581 2020-09-13 $15.99 UPSGround 1 0.07 lbs $11.17 $13.43 $-2.26
215582 2020-09-13 $8.45 USPSFirstClass 1 0.05 lbs $4.10 $2.78 $1.32
215584 2020-09-13 $9.49 USPSFirstClass 1 0.03 lbs $4.24 $2.93 $1.31
215585 2020-09-13 $15.07 USPSFirstClass 2 0.07 lbs $4.29 $3.05 $1.24
215586 2020-09-14 $47.54 USPSFirstClass 1 0.45 lbs $6.65 $4.00 $2.65
215588 2020-09-13 $21.13 Priority Mail 3-Day 1 0.95 lbs $10.84 $7.98 $2.86
215589 2020-09-13 $36.79 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.90 $0.10
215590 2020-09-14 $12.01 USPSFirstClass 1 0.35 lbs $5.02 $4.00 $1.02
215591 2020-09-14 $33.92 InternationalPriorityShipping 1 0.10 lbs $4.43 $3.05 $1.38
215592 2020-09-14 $15.64 USPSFirstClass 1 0.40 lbs $5.18 $3.25 $1.93
215593 2020-09-14 $26.86 Priority Mail 3-Day 14 0.16 lbs $9.00 $7.65 $1.35
215594 2020-09-14 $10.07 USPSFirstClass 2 0.32 lbs $5.11 $3.67 $1.44
215595 2020-09-14 $46.20 Priority Mail 2-Day 1 1.70 lbs $10.39 $9.54 $0.85
215597 2020-09-14 $24.48 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
215598 2020-09-14 $49.19 USPSFirstClass 1 0.45 lbs $6.85 $4.32 $2.53
215600 2020-09-14 $6.24 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.93 $0.42
215601 2020-09-14 $9.25 USPSFirstClass 1 0.07 lbs $4.22 $2.93 $1.29
215603 2020-09-14 $16.37 USPSFirstClass 3 0.15 lbs $4.40 $3.18 $1.22
215605 2020-09-14 $20.59 Priority Mail 2-Day 2 0.72 lbs $9.61 $8.76 $0.85
215606 2020-09-14 $12.89 USPSFirstClass 1 0.31 lbs $5.14 $3.39 $1.75
215607 2020-09-14 $7.72 USPSFirstClass 1 0.03 lbs $4.20 $3.05 $1.15
215608 2020-09-14 $89.61 Ground 2 3.40 lbs $17.99 $20.74 $-2.75
215609 2020-09-14 $31.39 USPSFirstClass 2 0.58 lbs $6.34 $3.67 $2.67
215611 2020-09-14 $279.99 Priority Mail 2-Day 1 15.55 lbs $30.00 $58.44 $-28.44
215615 2020-09-14 $16.45 First-Class Package Service 2 0.21 lbs $3.97 $4.32 $-0.35
215617 2020-09-14 $35.10 First-Class Package Service 6 0.60 lbs $4.71 $5.70 $-0.99
215618 2020-09-14 $76.44 Priority Mail 2-Day Medium Flat Rate Box 1 6.50 lbs $14.45 $13.20 $1.25
215619 2020-09-14 $27.79 Priority Mail 2-Day 1 0.30 lbs $8.00 $7.90 $0.10
215621 2020-09-14 $148.52 Priority Mail 3-Day 1 9.60 lbs $18.53 $18.16 $0.37
215624 2020-09-14 $24.64 First-Class Package Service 6 0.28 lbs $3.70 $2.78 $0.92
215625 2020-09-14 $27.02 First-Class Package Service 22 0.24 lbs $3.66 $2.74 $0.92
215626 2020-09-14 $7.82 First-Class Package Service 2 0.26 lbs $3.84 $2.93 $0.91
215628 2020-09-14 $104.43 Priority Mail 3-Day Padded Flat Rate Envelope 3 4.02 lbs $8.60 $7.75 $0.85
215629 2020-09-14 $48.67 Priority Mail 3-Day Flat Rate Envelope 3 0.92 lbs $8.00 $7.65 $0.35
215630 2020-09-14 $57.68 Priority Mail 2-Day Flat Rate Envelope 2 1.65 lbs $8.00 $7.65 $0.35
215631 2020-09-14 $18.15 First-Class Package Service 5 0.25 lbs $3.70 $3.25 $0.45
215634 2020-09-15 $25.54 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
215635 2020-09-15 $9.19 USPSFirstClass 1 0.10 lbs $4.27 $3.05 $1.22
215636 2020-09-15 $47.98 USPSFirstClass 1 0.45 lbs $6.65 $4.00 $2.65
215637 2020-09-15 $49.19 USPSFirstClass 1 0.45 lbs $6.85 $4.32 $2.53
215639 2020-09-15 $9.15 First-Class Package Service 1 0.05 lbs $3.23 $2.78 $0.45
215640 2020-09-15 $135.68 Priority Mail 2-Day Flat Rate Envelope 32 2.46 lbs $8.00 $7.65 $0.35
215641 2020-09-15 $11.81 USPSFirstClass 1 0.19 lbs $4.25 $2.78 $1.47
215642 2020-09-15 $47.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.75 $0.85
215643 2020-09-15 $22.59 First-Class Package Service 1 0.35 lbs $3.84 $3.39 $0.45
215644 2020-09-15 $12.46 USPSFirstClass 1 0.50 lbs $5.06 $3.31 $1.75
215645 2020-09-15 $14.99 USPSFirstClass 2 0.04 lbs $4.15 $3.25 $0.90
215647 2020-09-15 $6.76 USPSFirstClass 1 0.17 lbs $4.17 $3.52 $0.65
215648 2020-09-15 $12.90 USPSFirstClass 3 0.60 lbs $5.75 $4.32 $1.43
215650 2020-09-15 $9.63 USPSFirstClass 2 0.38 lbs $4.90 $3.39 $1.51
215651 2020-09-15 $5.04 USPSFirstClass 1 0.01 lbs $3.95 $2.78 $1.17
215654 2020-09-15 $7.12 First-Class Package Service 1 0.05 lbs $3.23 $2.78 $0.45
215655 2020-09-15 $47.83 Priority Mail 2-Day 1 2.13 lbs $14.34 $7.65 $6.69
215657 2020-09-15 $13.19 Priority Mail 2-Day Flat Rate Envelope 1 0.07 lbs $8.00 $7.65 $0.35
215659 2020-09-15 $54.37 Priority Mail 2-Day 2 0.90 lbs $11.39 $10.54 $0.85
215660 2020-09-15 $29.21 Priority Mail 3-Day 10 0.83 lbs $9.61 $8.76 $0.85
215661 2020-09-15 $22.51 First-Class Package Service 1 0.90 lbs $5.52 $8.76 $-3.24
215663 2020-09-16 $12.91 USPSFirstClass 1 0.10 lbs $4.43 $3.05 $1.38
215664 2020-09-15 $26.97 Priority Mail 3-Day 1 3.00 lbs $11.18 $9.54 $1.64
215665 2020-09-16 $45.54 USPSPriority 1 1.60 lbs $12.55 $8.76 $3.79
215666 2020-09-16 $58.56 Priority Mail 2-Day Medium Flat Rate Box 1 5.20 lbs $14.45 $7.65 $6.80
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56