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
216495 2020-10-13 $15.91 First-Class Package Service 1 0.30 lbs $4.12 $3.67 $0.45
216497 2020-10-13 $36.89 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
216499 2020-10-13 $21.32 First-Class Package Service 1 0.45 lbs $4.53 $4.20 $0.33
216501 2020-10-13 $10.01 First-Class Package Service 2 0.15 lbs $3.23 $2.78 $0.45
216504 2020-10-13 $14.46 Priority Mail 2-Day 1 0.15 lbs $9.27 $8.42 $0.85
216505 2020-10-13 $8.25 First-Class Mail Stamped Letter 10 0.10 lbs $3.35 $3.18 $0.17
216506 2020-10-13 $22.59 First-Class Package Service 1 0.35 lbs $3.84 $3.64 $0.20
216507 2020-10-14 $48.09 USPSFirstClass 1 0.45 lbs $6.96 $4.32 $2.64
216508 2020-10-13 $8.25 First-Class Mail Stamped Letter 10 0.10 lbs $3.35 $3.05 $0.30
216510 2020-10-14 $10.08 USPSFirstClass 1 0.05 lbs $4.19 $3.25 $0.94
216513 2020-10-14 $25.72 First-Class Package Service 4 0.40 lbs $3.76 $3.57 $0.19
216514 2020-10-14 $12.03 USPSFirstClass 1 0.30 lbs $5.14 $4.18 $0.96
216515 2020-10-14 $19.47 First-Class Package Service 1 0.30 lbs $4.12 $3.67 $0.45
216519 2020-10-14 $50.99 USPSFirstClass 1 0.45 lbs $6.86 $4.18 $2.68
216521 2020-10-14 $51.60 USPSFirstClass 1 0.45 lbs $6.96 $4.32 $2.64
216522 2020-10-14 $21.68 Priority Mail 2-Day 1 0.95 lbs $11.39 $10.54 $0.85
216525 2020-10-14 $85.71 3 Day Select 31 1.55 lbs $27.04 $9.98 $17.06
216526 2020-10-14 $108.21 Priority Mail 3-Day Medium Flat Rate Box 4 3.53 lbs $14.45 $10.93 $3.52
216528 2020-10-14 $35.51 First-Class Package Service 1 0.75 lbs $5.52 $5.27 $0.25
216529 2020-10-14 $33.23 USPSFirstClass 4 0.23 lbs $16.38 $7.56 $8.82
216533 2020-10-15 $11.69 USPSFirstClass 1 0.20 lbs $4.24 $2.78 $1.46
216538 2020-10-14 $42.35 First-Class Package Service 2 0.50 lbs $4.77 $4.32 $0.45
216541 2020-10-14 $7.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.18 $0.02
216543 2020-10-14 $36.64 First-Class Package Service 1 0.50 lbs $4.45 $4.00 $0.45
216544 2020-10-14 $46.58 USPS Priority Mail 1-Day<sup>™</sup> 4 1.58 lbs $8.25 $7.83 $0.42
216545 2020-10-14 $7.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $2.78 $0.42
216547 2020-10-14 $34.83 Priority Mail 3-Day 1 0.95 lbs $12.04 $12.10 $-0.06
216548 2020-10-15 $34.39 Priority Mail 2-Day Flat Rate Envelope 2 1.15 lbs $8.00 $7.75 $0.25
216549 2020-10-15 $36.96 First-Class Package Service 1 0.50 lbs $4.77 $4.32 $0.45
216552 2020-10-15 $224.26 Ground 1 13.15 lbs $35.57 $32.29 $3.28
216553 2020-10-15 $18.06 First-Class Package Service 3 0.32 lbs $3.97 $3.52 $0.45
216554 2020-10-15 $12.84 USPSFirstClass 3 0.57 lbs $5.86 $5.70 $0.16
216556 2020-10-15 $19.47 USPSFirstClass 2 1.10 lbs $11.18 $8.21 $2.97
216557 2020-10-15 $46.99 Priority Mail 2-Day 2 1.25 lbs $9.61 $7.75 $1.86
216558 2020-10-15 $30.39 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.75 $0.25
216560 2020-10-15 $13.19 Priority Mail 3-Day Flat Rate Envelope 1 0.10 lbs $8.00 $7.85 $0.15
216561 2020-10-15 $13.19 Priority Mail 3-Day Flat Rate Envelope 1 0.10 lbs $8.00 $7.56 $0.44
216562 2020-10-15 $8.55 First-Class Package Service 1 0.20 lbs $3.66 $3.21 $0.45
216563 2020-10-15 $58.87 Priority Mail 2-Day 2 1.10 lbs $11.39 $10.54 $0.85
216565 2020-10-15 $38.64 USPSFirstClass 1 0.64 lbs $6.90 $4.08 $2.82
216573 2020-10-15 $14.49 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $3.05 $0.45
216574 2020-10-15 $8.28 First-Class Package Service - Retail 2 0.06 lbs $6.30 $3.31 $2.99
216576 2020-10-15 $48.99 Priority Mail 2-Day Flat Rate Envelope 3 1.50 lbs $8.00 $8.00 $0.00
216578 2020-10-15 $11.49 First-Class Package Service 1 0.05 lbs $3.50 $3.05 $0.45
216579 2020-10-15 $27.84 Priority Mail 3-Day Padded Flat Rate Envelope 2 0.16 lbs $8.60 $7.65 $0.95
216582 2020-10-16 $47.89 USPSFirstClass 1 0.45 lbs $6.76 $4.00 $2.76
216584 2020-10-16 $14.82 First-Class Mail Stamped Letter 3 0.10 lbs $3.35 $2.93 $0.42
216587 2020-10-16 $39.73 Priority Mail 3-Day Flat Rate Envelope 3 0.90 lbs $8.40 $7.65 $0.75
216590 2020-10-16 $54.37 Priority Mail 3-Day Flat Rate Envelope 3 1.50 lbs $8.40 $7.65 $0.75
216591 2020-10-16 $29.27 First-Class Package Service 3 0.70 lbs $6.40 $5.70 $0.70
216593 2020-10-16 $6.69 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $2.93 $0.27
216595 2020-10-16 $32.48 Priority Mail 2-Day Small Flat Rate Box 2 0.65 lbs $8.90 $7.65 $1.25
216599 2020-10-16 $9.93 First-Class Package Service 2 0.20 lbs $3.95 $2.78 $1.17
216601 2020-10-16 $40.59 Priority Mail 3-Day 1 3.30 lbs $10.64 $9.07 $1.57
216603 2020-10-16 $16.32 First-Class Mail Stamped Letter 4 0.12 lbs $3.50 $2.93 $0.57
216604 2020-10-17 $9.21 USPSFirstClass 1 0.10 lbs $4.12 $2.78 $1.34
216605 2020-10-17 $9.79 USPSFirstClass 1 0.10 lbs $4.31 $3.05 $1.26
216606 2020-10-17 $19.52 USPSFirstClass 2 0.68 lbs $5.74 $5.12 $0.62
216607 2020-10-17 $8.12 USPSFirstClass 1 0.03 lbs $4.09 $2.78 $1.31
216610 2020-10-17 $51.89 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.90 $8.05 $0.85
216611 2020-10-17 $10.29 First-Class Mail Stamped Letter 1 0.09 lbs $3.50 $3.18 $0.32
216612 2020-10-17 $38.98 Priority Mail 2-Day Flat Rate Envelope 2 1.45 lbs $8.40 $7.65 $0.75
216614 2020-10-17 $42.41 Priority Mail 2-Day 3 1.05 lbs $12.44 $11.58 $0.86
216618 2020-10-17 $24.49 First-Class Package Service 3 0.45 lbs $4.82 $4.32 $0.50
216621 2020-10-17 $24.91 First-Class Package Service 1 0.65 lbs $5.62 $5.37 $0.25
216622 2020-10-17 $19.42 First-Class Mail Stamped Letter 8 0.16 lbs $3.50 $3.30 $0.20
216623 2020-10-17 $41.41 First-Class Package Service 5 0.46 lbs $5.16 $4.71 $0.45
216632 2020-10-17 $6.24 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.30 $0.05
216634 2020-10-17 $18.40 First-Class Package Service 5 0.25 lbs $3.95 $3.50 $0.45
216637 2020-10-17 $19.71 First-Class Package Service 1 0.35 lbs $4.22 $3.77 $0.45
216638 2020-10-17 $7.74 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $3.09 $0.26
216639 2020-10-18 $7.34 USPSFirstClass 1 0.10 lbs $4.05 $3.03 $1.02
216640 2020-10-18 $19.33 USPSFirstClass 2 0.38 lbs $5.35 $3.43 $1.92
216641 2020-10-18 $17.79 USPSFirstClass 2 0.40 lbs $5.21 $3.77 $1.44
216642 2020-10-18 $13.64 USPSFirstClass 1 0.05 lbs $4.65 $3.43 $1.22
216643 2020-10-18 $7.11 USPSFirstClass 1 0.05 lbs $4.04 $3.03 $1.01
216644 2020-10-18 $28.80 USPSFirstClass 1 0.60 lbs $6.76 $5.95 $0.81
216645 2020-10-18 $20.37 Priority Mail 2-Day Flat Rate Envelope 3 0.07 lbs $8.40 $8.05 $0.35
216646 2020-10-18 $79.72 Direct Link International 8 1.09 lbs $26.50 $21.00 $5.50
216650 2020-10-18 $22.67 First-Class Package Service 1 0.65 lbs $4.88 $5.65 $-0.77
216651 2020-10-18 $5.19 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $3.30 $-0.10
216652 2020-10-18 $22.86 Priority Mail 2-Day 3 1.35 lbs $11.79 $11.53 $0.26
216656 2020-10-18 $15.08 First-Class Package Service 1 0.30 lbs $4.09 $3.64 $0.45
216657 2020-10-18 $7.74 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $3.30 $0.05
216662 2020-10-18 $60.58 Priority Mail 3-Day 9 0.88 lbs $9.67 $8.82 $0.85
216663 2020-10-18 $33.96 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.90 $8.05 $0.85
216664 2020-10-18 $13.62 First-Class Package Service 1 0.13 lbs $3.63 $3.64 $-0.01
216666 2020-10-18 $7.99 First-Class Package Service 2 0.28 lbs $4.01 $4.33 $-0.32
216667 2020-10-18 $9.33 First-Class Mail Stamped Letter 2 0.00 lbs $3.35 $3.42 $-0.07
216668 2020-10-19 $7.76 USPSFirstClass 1 0.02 lbs $4.36 $3.43 $0.93
216669 2020-10-19 $12.48 USPSFirstClass 1 0.20 lbs $4.59 $3.92 $0.67
216670 2020-10-19 $15.20 USPSFirstClass 1 0.10 lbs $4.42 $3.09 $1.33
216671 2020-10-19 $7.46 USPSFirstClass 1 0.10 lbs $4.14 $3.18 $0.96
216672 2020-10-19 $81.24 USPSFirstClass 2 1.78 lbs $20.50 $10.88 $9.62
216673 2020-10-19 $15.92 USPSFirstClass 1 0.20 lbs $4.71 $3.92 $0.79
216674 2020-10-19 $18.83 USPSFirstClass 1 0.40 lbs $5.42 $4.43 $0.99
216675 2020-10-19 $7.16 USPSFirstClass 1 0.05 lbs $4.04 $3.03 $1.01
216677 2020-10-19 $29.90 Priority Mail 3-Day Flat Rate Envelope 1 3.55 lbs $8.40 $8.15 $0.25
216680 2020-10-19 $19.86 First-Class Package Service 1 0.35 lbs $4.37 $3.92 $0.45
216681 2020-10-19 $19.44 First-Class Package Service 1 0.30 lbs $4.09 $3.64 $0.45
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56