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
205615 2019-02-03 $113.44 Priority Mail 3-Day 4 3.45 lbs $11.18 $10.03 $1.15
205616 2019-02-03 $7.87 First-Class Package Service 2 0.20 lbs $3.89 $2.84 $1.05
205617 2019-02-03 $36.54 First-Class Package Service 10 0.15 lbs $4.14 $3.09 $1.05
205619 2019-02-03 $32.50 Priority Mail 2-Day 7 0.99 lbs $8.27 $7.42 $0.85
205620 2019-02-03 $7.53 First-Class Mail Large Envelope 2 0.34 lbs $12.65 $4.19 $8.46
205621 2019-02-03 $40.27 Priority Mail 3-Day Flat Rate Envelope 13 2.29 lbs $7.80 $7.55 $0.25
205622 2019-02-03 $35.81 First-Class Package Service 8 0.64 lbs $6.09 $5.24 $0.85
205623 2019-02-04 $57.59 Priority Mail 2-Day 3 2.20 lbs $12.65 $10.00 $2.65
205625 2019-02-04 $17.81 First-Class Package Service 10 0.22 lbs $4.41 $2.84 $1.57
205628 2019-02-04 $27.19 First-Class Mail Large Envelope 1 0.50 lbs $4.15 $4.94 $-0.79
205630 2019-02-04 $6.34 First-Class Package Service 5 0.05 lbs $3.89 $2.84 $1.05
205636 2019-02-05 $59.94 Priority Mail 2-Day Medium Flat Rate Box 6 1.86 lbs $12.65 $10.55 $2.10
205637 2019-02-05 $48.40 Priority Mail 2-Day Large Flat Rate Box 5 3.10 lbs $18.45 $17.60 $0.85
205638 2019-02-05 $53.48 Priority Mail 2-Day Large Flat Rate Box 17 3.70 lbs $18.45 $17.60 $0.85
205639 2019-02-05 $9.20 First-Class Package Service 1 0.08 lbs $4.01 $2.96 $1.05
205640 2019-02-05 $32.41 First-Class Package Service 1 0.35 lbs $6.43 $7.50 $-1.07
205641 2019-02-05 $14.56 Priority Mail 3-Day 2 3.90 lbs $11.18 $10.33 $0.85
205643 2019-02-05 $10.87 First-Class Package Service 2 0.08 lbs $3.89 $2.84 $1.05
205644 2019-02-05 $64.67 Direct Link International 1 1.50 lbs $24.18 $20.86 $3.32
205645 2019-02-05 $64.67 Direct Link International 1 1.50 lbs $24.18 $20.70 $3.48
205646 2019-02-05 $87.56 Direct Link International 2 2.50 lbs $28.58 $24.56 $4.02
205647 2019-02-05 $23.04 Priority Mail 3-Day Flat Rate Envelope 6 1.14 lbs $7.80 $7.50 $0.30
205652 2019-02-06 $24.88 First-Class Package Service 10 0.38 lbs $4.33 $3.96 $0.37
205653 2019-02-06 $10.78 First-Class Package Service 3 0.05 lbs $3.81 $2.76 $1.05
205655 2019-02-06 $22.56 First-Class Package Service 1 0.30 lbs $4.27 $3.22 $1.05
205656 2019-02-06 $14.76 First-Class Package Service 3 0.14 lbs $3.89 $3.36 $0.53
205657 2019-02-06 $18.22 First-Class Package Service 2 0.58 lbs $5.24 $5.38 $-0.14
205659 2019-02-06 $18.26 First-Class Package Service 1 0.23 lbs $4.27 $3.22 $1.05
205661 2019-01-30 $4.95 Priority Mail 3-Day Small Flat Rate Box 5 0.05 lbs $3.25 $2.76 $0.49
205663 2019-02-06 $16.20 First-Class Package Service 1 0.30 lbs $4.41 $3.36 $1.05
205666 2019-02-07 $73.82 Priority Mail 2-Day Medium Flat Rate Box 18 3.18 lbs $13.80 $12.80 $1.00
205667 2019-02-07 $81.64 Priority Mail 2-Day Medium Flat Rate Box 36 1.92 lbs $13.80 $12.80 $1.00
205669 2019-02-07 $26.09 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.55 $0.25
205671 2019-02-07 $25.67 First-Class Package Service 1 0.35 lbs $4.68 $3.63 $1.05
205672 2019-02-07 $8.00 First-Class Package Service 1 0.05 lbs $4.01 $2.96 $1.05
205673 2019-02-07 $370.80 Priority Mail 2-Day Medium Flat Rate Box 1 66.00 lbs $12.65 $12.80 $-0.15
205674 2019-02-07 $48.84 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
205675 2019-02-07 $93.21 Priority Mail 3-Day 2 1.55 lbs $12.65 $15.59 $-2.94
205676 2019-02-07 $4.27 First-Class Package Service 1 0.20 lbs $4.54 $3.22 $1.32
205677 2019-02-08 $106.21 First-Class Package International Service 3 2.35 lbs $32.94 $24.94 $8.00
205685 2019-02-08 $86.77 Priority Mail 3-Day 1 4.40 lbs $18.78 $17.93 $0.85
205687 2019-02-08 $80.63 Direct Link International 2 2.50 lbs $29.85 $27.26 $2.59
205691 2019-02-08 $58.22 Priority Mail 2-Day 3 1.56 lbs $12.65 $11.80 $0.85
205693 2019-02-08 $9.79 First-Class Package Service 2 0.20 lbs $3.81 $3.28 $0.53
205695 2019-02-08 $12.78 First-Class Package Service 3 0.10 lbs $3.81 $2.76 $1.05
205697 2019-02-09 $103.56 Priority Mail 2-Day 7 1.96 lbs $16.13 $15.28 $0.85
205701 2019-02-09 $194.36 Priority Mail 2-Day 2 14.45 lbs $19.27 $21.26 $-1.99
205703 2019-02-09 $5.88 First-Class Package Service 1 0.03 lbs $3.89 $2.84 $1.05
205704 2019-02-09 $16.06 First-Class Package Service 1 0.30 lbs $4.27 $3.22 $1.05
205705 2019-02-09 $53.44 Priority Mail 3-Day 11 2.12 lbs $12.65 $12.80 $-0.15
205706 2019-02-10 $77.97 Priority Mail 3-Day 12 1.43 lbs $8.73 $7.88 $0.85
205707 2019-02-10 $69.21 First-Class Package Service 6 0.85 lbs $6.17 $7.50 $-1.33
205708 2019-02-10 $63.88 Priority Mail 2-Day 17 0.86 lbs $9.35 $8.50 $0.85
205709 2019-02-10 $5.71 First-Class Package Service 4 0.08 lbs $3.75 $2.70 $1.05
205710 2019-02-10 $65.83 Priority Mail 2-Day 2 1.95 lbs $12.65 $11.80 $0.85
205712 2019-02-10 $69.67 Priority Mail 3-Day Medium Flat Rate Box 3 2.40 lbs $13.80 $12.80 $1.00
205715 2019-02-10 $25.92 First-Class Package Service - Retail 6 0.47 lbs $6.38 $4.19 $2.19
205716 2019-02-10 $23.29 First-Class Mail Large Envelope 1 0.60 lbs $4.00 $5.24 $-1.24
205717 2019-02-11 $20.69 Priority Mail 2-Day 6 1.20 lbs $9.35 $8.50 $0.85
205719 2019-02-11 $111.06 First-Class Package International Service 4 0.81 lbs $30.80 $22.80 $8.00
205720 2019-02-11 $118.57 Priority Mail 3-Day 4 2.49 lbs $10.11 $7.50 $2.61
205726 2019-02-11 $33.85 Priority Mail 2-Day 10 0.70 lbs $9.35 $8.50 $0.85
205728 2019-02-11 $187.59 Priority Mail International 53 5.75 lbs $70.37 $62.46 $7.91
205729 2019-02-11 $78.83 Priority Mail 3-Day Medium Flat Rate Box 7 2.67 lbs $13.80 $10.00 $3.80
205730 2019-02-11 $30.53 First-Class Package International Service 1 0.29 lbs $21.54 $22.33 $-0.79
205731 2019-02-11 $34.89 Priority Mail 2-Day 9 0.94 lbs $11.08 $10.23 $0.85
205733 2019-02-11 $9.29 First-Class Package Service 2 0.09 lbs $3.81 $2.76 $1.05
205735 2019-02-11 $144.74 Priority Mail 3-Day 3 9.84 lbs $22.16 $21.31 $0.85
205736 2019-02-11 $136.62 Priority Mail 3-Day 7 6.75 lbs $12.01 $8.12 $3.89
205737 2019-02-12 $74.06 Direct Link International 5 2.17 lbs $32.41 $28.35 $4.06
205738 2019-02-12 $64.86 Direct Link International 1 1.55 lbs $24.37 $20.70 $3.67
205739 2019-02-12 $64.86 Direct Link International 1 1.55 lbs $24.37 $20.70 $3.67
205740 2019-02-12 $95.86 Direct Link International 2 2.70 lbs $29.88 $26.91 $2.97
205743 2019-02-12 $144.98 Direct Link International 3 4.50 lbs $48.71 $9.22 $39.49
205744 2019-02-12 $38.14 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.35 $7.50 $0.85
205745 2019-02-12 $67.27 Priority Mail 3-Day 4 1.29 lbs $9.35 $8.50 $0.85
205746 2019-02-12 $12.31 First-Class Package Service 2 0.36 lbs $4.33 $3.28 $1.05
205747 2019-02-12 $10.10 First-Class Package Service 1 0.27 lbs $5.11 $4.06 $1.05
205748 2019-02-13 $11.74 First-Class Package Service 1 0.17 lbs $3.75 $3.22 $0.53
205749 2019-02-13 $51.00 Priority Mail 2-Day 8 0.70 lbs $11.08 $10.23 $0.85
205750 2019-02-13 $30.78 Priority Mail 2-Day Flat Rate Envelope 2 2.30 lbs $7.80 $7.55 $0.25
205751 2019-02-13 $5.80 First-Class Package Service 1 0.07 lbs $3.81 $3.28 $0.53
205758 2019-02-13 $20.50 Priority Mail 3-Day 1 0.95 lbs $11.71 $10.86 $0.85
205759 2019-02-13 $25.38 First-Class Package Service 1 0.80 lbs $6.09 $5.24 $0.85
205760 2019-02-13 $103.35 Priority Mail 3-Day Medium Flat Rate Box 8 3.14 lbs $13.80 $12.80 $1.00
205761 2019-02-13 $6.70 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
205767 2019-02-14 $35.37 First-Class Package International Service 2 0.80 lbs $24.39 $16.39 $8.00
205769 2019-02-14 $30.05 Priority Mail 3-Day 6 2.17 lbs $10.11 $9.26 $0.85
205770 2019-02-14 $11.38 Priority Mail 2-Day Flat Rate Envelope 2 0.10 lbs $7.80 $7.49 $0.31
205771 2019-02-14 $27.72 First-Class Package Service 9 0.18 lbs $3.81 $3.28 $0.53
205773 2019-02-15 $66.76 Priority Mail 3-Day Flat Rate Envelope 3 0.51 lbs $7.80 $7.50 $0.30
205774 2019-02-15 $99.65 Direct Link International 9 2.13 lbs $27.14 $22.69 $4.45
205776 2019-02-15 $258.76 Priority Mail 2-Day 1 14.40 lbs $28.92 $29.44 $-0.52
205779 2019-02-15 $31.06 Priority Mail 3-Day 2 0.71 lbs $11.08 $10.23 $0.85
205780 2019-02-15 $15.25 First-Class Package Service 2 0.27 lbs $4.27 $2.70 $1.57
205781 2019-02-15 $48.84 Priority Mail 2-Day Small Flat Rate Box 1 1.45 lbs $8.35 $7.50 $0.85
205782 2019-02-15 $93.92 Priority Mail 2-Day 8 3.10 lbs $9.66 $8.12 $1.54
205783 2019-02-15 $28.56 Priority Mail 2-Day Medium Flat Rate Box 4 1.80 lbs $13.80 $10.23 $3.57
205784 2019-02-15 $38.88 Priority Mail 2-Day Flat Rate Envelope 5 0.92 lbs $7.80 $7.55 $0.25
205785 2019-02-15 $48.84 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56