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
200600 2017-10-20 $66.10 Ground 4 0.80 lbs $32.74 $12.42 $20.32
200601 2017-10-21 $23.41 First-Class Package Service 1 0.90 lbs $5.02 $4.16 $0.86
200602 2017-10-21 $6.12 First-Class Package Service 4 0.04 lbs $3.81 $2.61 $1.20
200604 2017-10-21 $33.61 Priority Mail 2-Day 2 0.90 lbs $7.83 $9.05 $-1.22
200605 2017-10-21 $35.91 Priority Mail 3-Day 3 3.62 lbs $9.72 $6.83 $2.89
200606 2017-10-21 $9.00 First-Class Package Service 1 0.05 lbs $3.81 $2.61 $1.20
200610 2017-10-22 $6.15 First-Class Package Service 1 0.01 lbs $3.81 $2.61 $1.20
200615 2017-10-22 $68.23 First-Class Package International Service 15 1.39 lbs $22.38 $21.38 $1.00
200616 2017-10-22 $21.15 First-Class Mail Large Envelope 1 0.45 lbs $3.66 $3.32 $0.34
200617 2017-10-22 $139.63 Priority Mail 2-Day 4 6.50 lbs $26.37 $24.61 $1.76
200620 2017-10-22 $36.94 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.45 $6.25 $1.20
200621 2017-10-23 $105.74 First-Class Package International Service 4 1.80 lbs $33.78 $21.38 $12.40
200623 2017-10-23 $43.18 Priority Mail 2-Day 1 1.35 lbs $10.19 $8.91 $1.28
200625 2017-10-23 $15.39 First-Class Package Service 8 0.18 lbs $3.97 $2.77 $1.20
200626 2017-10-23 $58.71 Priority Mail 3-Day 3 1.57 lbs $10.04 $9.19 $0.85
200627 2017-10-23 $36.79 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.30 $6.25 $1.05
200629 2017-10-23 $470.91 Ground 9 39.59 lbs $40.30 $31.32 $8.98
200631 2017-10-23 $41.99 Priority Mail 2-Day 1 1.35 lbs $9.00 $8.15 $0.85
200632 2017-10-23 $22.01 First-Class Package Service 1 0.30 lbs $3.62 $2.77 $0.85
200633 2017-10-23 $39.33 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $7.30 $6.25 $1.05
200634 2017-10-23 $52.41 Priority Mail 3-Day 2 1.30 lbs $10.84 $9.69 $1.15
200636 2017-10-23 $45.22 First-Class Package International Service 1 1.25 lbs $22.23 $31.83 $-9.60
200637 2017-10-23 $22.77 First-Class Mail Large Envelope 2 0.27 lbs $3.09 $2.77 $0.32
200638 2017-10-23 $64.59 First-Class Package International Service 4 1.48 lbs $22.23 $21.38 $0.85
200639 2017-10-23 $18.64 First-Class Package Service 2 0.13 lbs $3.66 $2.77 $0.89
200640 2017-10-24 $45.60 First-Class Package International Service 3 0.45 lbs $22.23 $21.38 $0.85
200643 2017-10-24 $25.89 First-Class Package Service 2 0.70 lbs $5.15 $4.16 $0.99
200655 2017-10-24 $12.24 First-Class Package Service 2 0.10 lbs $3.56 $2.61 $0.95
200656 2017-10-24 $3.95 First-Class Package Service 1 0.35 lbs $3.72 $2.77 $0.95
200657 2017-10-24 $133.40 Priority Mail Express 2-Day 2 2.18 lbs $38.11 $37.36 $0.75
200660 2017-10-25 $29.10 Priority Mail 2-Day 1 0.50 lbs $7.61 $6.66 $0.95
200661 2017-10-25 $383.53 Priority Mail International 8 13.75 lbs $105.81 $93.62 $12.19
200663 2017-10-25 $26.24 First-Class Package Service 3 0.46 lbs $4.07 $3.32 $0.75
200664 2017-10-25 $52.84 Priority Mail 2-Day 4 1.14 lbs $7.58 $6.63 $0.95
200666 2017-10-25 $29.82 First-Class Package Service 1 0.65 lbs $4.83 $4.16 $0.67
200667 2017-10-25 $133.93 Priority Mail International 1 5.65 lbs $66.64 $61.56 $5.08
200671 2017-10-25 $211.14 Priority Mail International 3 13.44 lbs $93.17 $89.82 $3.35
200672 2017-10-26 $43.47 First-Class Package International Service 1 1.20 lbs $15.48 $14.73 $0.75
200673 2017-10-26 $51.62 First-Class Package International Service 1 1.15 lbs $22.13 $21.38 $0.75
200674 2017-10-26 $23.61 First-Class Mail Large Envelope 1 0.35 lbs $3.62 $2.77 $0.85
200675 2017-10-26 $52.14 Priority Mail 2-Day Medium Flat Rate Box 1 1.60 lbs $13.15 $9.69 $3.46
200676 2017-10-26 $92.47 Priority Mail 2-Day 7 1.45 lbs $10.74 $9.69 $1.05
200679 2017-10-26 $20.55 Priority Mail 2-Day 3 0.86 lbs $7.58 $6.63 $0.95
200682 2017-10-26 $24.20 First-Class Package Service 1 0.60 lbs $4.91 $3.88 $1.03
200683 2017-10-27 $25.66 First-Class Package Service 1 0.65 lbs $4.91 $4.02 $0.89
200684 2017-10-27 $65.11 First-Class Package International Service 2 1.00 lbs $22.13 $21.38 $0.75
200685 2017-10-27 $86.11 First-Class Package International Service 2 1.00 lbs $22.13 $21.38 $0.75
200686 2017-10-27 $14.48 First-Class Mail Large Envelope 1 0.30 lbs $2.99 $2.77 $0.22
200687 2017-10-27 $15.41 First-Class Package Service 2 0.40 lbs $4.55 $4.30 $0.25
200688 2017-10-27 $51.28 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $6.70 $6.25 $0.45
200692 2017-10-27 $10.54 First-Class Package Service 2 0.10 lbs $3.56 $2.61 $0.95
200693 2017-10-28 $129.17 Priority Mail 2-Day Medium Flat Rate Box 5 3.67 lbs $13.15 $12.05 $1.10
200694 2017-10-28 $24.71 First-Class Package Service 1 0.35 lbs $3.72 $2.77 $0.95
200696 2017-10-28 $20.25 First-Class Package Service 2 0.47 lbs $4.97 $8.91 $-3.94
200697 2017-10-28 $64.21 Priority Mail 2-Day Padded Flat Rate Envelope 4 1.73 lbs $7.25 $6.25 $1.00
200700 2017-10-29 $52.11 Priority Mail 2-Day 3 0.80 lbs $10.74 $9.69 $1.05
200701 2017-10-29 $28.49 First-Class Package Service 2 1.00 lbs $4.91 $12.90 $-7.99
200703 2017-10-29 $23.40 First-Class Mail Large Envelope 1 0.40 lbs $3.41 $3.46 $-0.05
200704 2017-10-29 $35.19 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.20 $6.25 $0.95
200705 2017-10-29 $30.78 Priority Mail 2-Day Small Flat Rate Box 2 0.60 lbs $7.20 $6.25 $0.95
200707 2017-10-29 $96.14 Priority Mail 2-Day Flat Rate Envelope 4 1.40 lbs $6.70 $6.25 $0.45
200708 2017-10-29 $30.85 Priority Mail 3-Day 9 1.18 lbs $10.74 $15.13 $-4.39
200709 2017-10-29 $36.19 Priority Mail 3-Day Flat Rate Envelope 1 0.95 lbs $6.70 $6.25 $0.45
200710 2017-10-30 $43.60 Priority Mail 2-Day 1 2.20 lbs $8.61 $6.83 $1.78
200711 2017-10-30 $12.55 First-Class Package Service 1 0.08 lbs $3.56 $2.61 $0.95
200714 2017-10-30 $20.69 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $6.70 $5.75 $0.95
200715 2017-10-30 $35.19 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.20 $6.25 $0.95
200716 2017-10-30 $52.89 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $7.20 $6.25 $0.95
200717 2017-10-30 $97.80 Priority Mail 3-Day 5 3.00 lbs $16.35 $12.39 $3.96
200720 2017-10-31 $17.47 First-Class Package Service 2 0.50 lbs $4.49 $4.30 $0.19
200721 2017-10-31 $48.52 Priority Mail 3-Day 2 1.20 lbs $9.94 $8.91 $1.03
200723 2017-10-31 $81.50 Priority Mail 2-Day 4 4.13 lbs $9.94 $6.83 $3.11
200725 2017-10-31 $21.83 First-Class Mail Large Envelope 1 0.25 lbs $3.44 $2.77 $0.67
200726 2017-10-31 $47.48 Priority Mail 2-Day 2 1.30 lbs $8.90 $7.91 $0.99
200730 2017-10-31 $28.42 First-Class Package International Service 6 0.35 lbs $13.58 $21.38 $-7.80
200732 2017-10-31 $17.47 First-Class Package Service 2 0.40 lbs $4.49 $3.60 $0.89
200733 2017-10-31 $71.36 First-Class Package International Service 2 1.50 lbs $32.58 $31.83 $0.75
200734 2017-10-31 $21.65 First-Class Mail Large Envelope 1 0.35 lbs $3.86 $3.46 $0.40
200735 2017-11-01 $291.36 Ground 11 15.88 lbs $22.47 $13.92 $8.55
200737 2017-11-01 $72.21 First-Class Package International Service 4 1.07 lbs $21.99 $21.14 $0.85
200738 2017-11-01 $72.89 Priority Mail 2-Day 3 1.85 lbs $12.66 $11.46 $1.20
200744 2017-11-02 $35.79 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $6.80 $6.25 $0.55
200746 2017-11-02 $87.31 Next Day Air Saver 4 2.10 lbs $36.75 $35.05 $1.70
200748 2017-11-02 $13.80 First-Class Mail Large Envelope 1 0.35 lbs $4.01 $3.74 $0.27
200750 2017-11-03 $23.67 First-Class Package International Service 1 0.35 lbs $13.68 $21.38 $-7.70
200751 2017-11-03 $61.26 First-Class Package International Service 3 0.98 lbs $21.99 $21.14 $0.85
200753 2017-11-03 $44.90 Priority Mail 2-Day 3 0.98 lbs $11.13 $7.04 $4.09
200754 2017-11-03 $14.09 First-Class Package Service 3 0.23 lbs $3.82 $2.77 $1.05
200755 2017-11-04 $147.77 Priority Mail International 11 4.53 lbs $56.88 $54.63 $2.25
200756 2017-11-04 $25.77 First-Class Package Service 1 0.65 lbs $5.01 $4.02 $0.99
200757 2017-11-04 $37.09 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $7.30 $6.25 $1.05
200758 2017-11-04 $77.00 First-Class Package International Service 3 1.39 lbs $22.23 $21.38 $0.85
200759 2017-11-04 $9.13 First-Class Package Service 1 0.45 lbs $3.62 $3.60 $0.02
200761 2017-11-05 $15.46 First-Class Mail Large Envelope 1 0.30 lbs $3.59 $2.77 $0.82
200762 2017-11-05 $12.38 First-Class Package Service 1 0.45 lbs $4.59 $2.77 $1.82
200763 2017-11-05 $29.22 First-Class Package International Service 1 1.00 lbs $22.23 $21.38 $0.85
200766 2017-11-06 $19.87 First-Class Package International Service 1 0.08 lbs $9.88 $9.03 $0.85
200767 2017-11-06 $59.05 First-Class Package International Service 1 1.45 lbs $22.23 $21.38 $0.85
200769 2017-11-06 $29.78 Priority Mail 2-Day Flat Rate Envelope 2 2.30 lbs $6.80 $6.25 $0.55
200770 2017-11-06 $21.66 First-Class Package Service 1 0.45 lbs $4.17 $3.32 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56