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
202943 2018-05-10 $14.40 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.18 $0.43
202945 2018-05-11 $42.34 First-Class Package Service 5 0.35 lbs $4.39 $3.05 $1.34
202947 2018-05-11 $5.20 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
202948 2018-05-11 $146.22 Ground 5 6.40 lbs $21.27 $15.71 $5.56
202949 2018-05-11 $17.04 Priority Mail 2-Day 1 0.95 lbs $8.25 $7.18 $1.07
202951 2018-05-12 $24.80 First-Class Package Service 1 0.80 lbs $5.51 $4.38 $1.13
202956 2018-05-12 $115.00 Priority Mail International 1 3.95 lbs $61.01 $56.76 $4.25
202957 2018-05-12 $53.59 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $7.90 $6.85 $1.05
202958 2018-05-12 $13.99 First-Class Mail Large Envelope 4 0.40 lbs $4.03 $3.34 $0.69
202961 2018-05-13 $20.22 First-Class Package Service 1 0.60 lbs $5.23 $4.38 $0.85
202962 2018-05-14 $51.98 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $7.40 $6.85 $0.55
202963 2018-05-14 $6.16 First-Class Package Service 5 0.05 lbs $3.71 $2.66 $1.05
202964 2018-05-14 $25.98 First-Class Mail Large Envelope 5 0.41 lbs $4.03 $3.18 $0.85
202965 2018-05-14 $17.16 First-Class Package Service 1 0.40 lbs $4.67 $3.18 $1.49
202970 2018-05-15 $87.87 Priority Mail 2-Day 5 2.15 lbs $9.32 $8.22 $1.10
202971 2018-05-15 $60.51 First-Class Package International Service 2 1.40 lbs $27.33 $33.25 $-5.92
202972 2018-05-15 $35.77 First-Class Package Service 2 0.84 lbs $5.79 $4.94 $0.85
202973 2018-05-15 $44.07 Priority Mail 3-Day Flat Rate Envelope 13 1.21 lbs $7.40 $6.90 $0.50
202974 2018-05-15 $134.29 First-Class Package International Service 7 2.14 lbs $38.01 $33.01 $5.00
202977 2018-05-15 $26.59 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $7.40 $6.85 $0.55
202978 2018-05-15 $9.18 First-Class Package Service 3 0.09 lbs $3.71 $2.66 $1.05
202979 2018-05-15 $37.69 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $7.90 $6.85 $1.05
202980 2018-05-15 $9.93 First-Class Package Service - Retail 2 0.12 lbs $4.35 $2.66 $1.69
202981 2018-05-16 $5.15 First-Class Package Service 2 0.02 lbs $3.71 $2.66 $1.05
202982 2018-05-16 $35.09 Priority Mail 2-Day 6 0.95 lbs $8.25 $7.40 $0.85
202983 2018-05-16 $32.88 Priority Mail 2-Day Small Flat Rate Box 2 0.90 lbs $7.90 $6.85 $1.05
202984 2018-05-16 $5.70 First-Class Package Service 1 0.01 lbs $3.71 $2.66 $1.05
202986 2018-05-16 $37.69 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.90 $6.85 $1.05
202989 2018-05-17 $26.65 First-Class Package Service 12 0.27 lbs $3.97 $3.18 $0.79
202990 2018-05-18 $138.02 Direct Link International 6 2.60 lbs $34.15 $8.22 $25.93
202991 2018-05-18 $19.66 Priority Mail 2-Day 9 1.04 lbs $8.25 $7.18 $1.07
202992 2018-05-18 $17.86 First-Class Mail Large Envelope 5 0.26 lbs $3.61 $3.05 $0.56
202996 2018-05-19 $15.59 First-Class Package Service - Retail 1 0.35 lbs $4.60 $3.18 $1.42
202998 2018-05-19 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
202999 2018-05-19 $26.36 First-Class Mail Large Envelope 1 0.50 lbs $4.87 $4.10 $0.77
203000 2018-05-19 $9.69 First-Class Package Service 2 0.10 lbs $3.71 $2.66 $1.05
203002 2018-05-20 $32.31 First-Class Package Service 3 0.15 lbs $3.84 $2.92 $0.92
203004 2018-05-20 $48.34 Priority Mail 2-Day 17 1.61 lbs $9.00 $6.90 $2.10
203005 2018-05-20 $18.05 First-Class Package Service - Retail 5 0.25 lbs $4.60 $2.79 $1.81
203006 2018-05-20 $12.68 First-Class Package Service 3 0.09 lbs $3.71 $2.66 $1.05
203007 2018-05-20 $40.89 Priority Mail 2-Day 5 1.06 lbs $11.14 $9.98 $1.16
203008 2018-05-20 $5.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
203009 2018-05-21 $104.84 Priority Mail 2-Day 6 3.18 lbs $19.00 $17.61 $1.39
203010 2018-05-21 $50.57 Priority Mail 2-Day Flat Rate Envelope 3 1.55 lbs $7.40 $6.85 $0.55
203011 2018-05-21 $5.20 First-Class Package Service 1 0.01 lbs $3.71 $2.66 $1.05
203012 2018-05-22 $11.69 First-Class Package Service 2 0.10 lbs $3.71 $2.66 $1.05
203013 2018-05-22 $35.48 Priority Mail 2-Day 2 0.65 lbs $8.20 $7.13 $1.07
203014 2018-05-22 $115.00 Priority Mail International 1 3.95 lbs $61.01 $56.76 $4.25
203015 2018-05-22 $15.40 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.05 $0.56
203018 2018-05-22 $14.69 First-Class Package Service 2 0.40 lbs $4.71 $4.66 $0.05
203019 2018-05-22 $12.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
203020 2018-05-22 $44.14 Priority Mail 3-Day 6 0.80 lbs $9.00 $6.85 $2.15
203022 2018-05-22 $39.35 First-Class Package Service 10 1.34 lbs $4.55 $6.85 $-2.30
203023 2018-05-22 $33.72 Direct Link International 5 0.69 lbs $23.37 $7.18 $16.19
203024 2018-05-23 $54.88 Priority Mail 2-Day Flat Rate Envelope 2 1.60 lbs $7.40 $6.85 $0.55
203025 2018-05-23 $63.31 First-Class Package International Service 2 0.90 lbs $27.33 $22.33 $5.00
203031 2018-05-23 $106.98 First-Class Package International Service 3 2.25 lbs $38.01 $33.01 $5.00
203033 2018-05-23 $19.82 First-Class Package Service 2 0.18 lbs $3.84 $2.92 $0.92
203034 2018-05-23 $24.02 First-Class Mail Large Envelope 1 0.40 lbs $4.03 $3.34 $0.69
203035 2018-05-23 $4.72 First-Class Package Service 1 0.37 lbs $4.23 $3.18 $1.05
203039 2018-05-23 $30.59 Priority Mail 2-Day 2 1.90 lbs $13.01 $11.80 $1.21
203040 2018-05-23 $3.97 First-Class Package Service 1 0.30 lbs $3.97 $2.79 $1.18
203042 2018-05-24 $20.47 First-Class Package Service 5 0.56 lbs $5.71 $3.82 $1.89
203043 2018-05-24 $8.87 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
203047 2018-05-25 $12.08 First-Class Package Service 2 0.38 lbs $4.10 $2.66 $1.44
203048 2018-05-25 $10.70 First-Class Package Service 1 0.06 lbs $3.71 $2.66 $1.05
203050 2018-05-26 $72.77 Priority Mail 3-Day Flat Rate Envelope 13 3.17 lbs $7.40 $6.85 $0.55
203051 2018-05-27 $17.04 Priority Mail 2-Day 1 0.95 lbs $8.25 $7.18 $1.07
203055 2018-05-27 $15.67 First-Class Package Service 4 0.14 lbs $3.71 $2.66 $1.05
203057 2018-05-27 $110.56 First-Class Package International Service 5 2.23 lbs $38.01 $33.01 $5.00
203058 2018-05-27 $34.73 First-Class Package Service 2 0.47 lbs $4.35 $3.50 $0.85
203063 2018-05-28 $82.15 Priority Mail 3-Day 30 5.70 lbs $16.45 $23.55 $-7.10
203066 2018-05-28 $63.98 First-Class Package International Service 1 2.20 lbs $28.99 $23.99 $5.00
203068 2018-05-28 $120.05 Priority Mail International 3 2.20 lbs $54.84 $50.59 $4.25
203069 2018-05-28 $73.94 Ground 4 9.90 lbs $23.56 $25.78 $-2.22
203071 2018-05-28 $24.69 First-Class Package Service 15 0.20 lbs $3.84 $2.79 $1.05
203072 2018-05-28 $25.69 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
203073 2018-05-29 $35.82 Priority Mail 3-Day 3 0.45 lbs $7.85 $6.85 $1.00
203075 2018-05-29 $9.65 First-Class Package Service 6 0.02 lbs $3.71 $2.66 $1.05
203077 2018-05-29 $281.47 Priority Mail 2-Day 7 22.89 lbs $37.74 $41.09 $-3.35
203078 2018-05-29 $53.66 Ground 1 2.54 lbs $13.67 $11.99 $1.68
203079 2018-05-29 $10.17 First-Class Package Service 4 0.05 lbs $3.71 $2.66 $1.05
203080 2018-05-29 $20.01 First-Class Mail Large Envelope 2 0.40 lbs $4.03 $3.66 $0.37
203082 2018-05-29 $80.89 Priority Mail 3-Day 13 2.47 lbs $16.92 $15.59 $1.33
203083 2018-05-29 $36.39 Priority Mail 3-Day Flat Rate Envelope 1 1.10 lbs $7.40 $6.85 $0.55
203085 2018-05-30 $98.00 Priority Mail 2-Day Medium Flat Rate Box 5 2.75 lbs $13.85 $9.47 $4.38
203087 2018-05-30 $24.80 First-Class Package Service 1 0.60 lbs $5.51 $4.38 $1.13
203088 2018-05-30 $82.98 Priority Mail International Small Flat Rate Box 2 2.20 lbs $25.50 $47.22 $-21.72
203089 2018-05-30 $182.83 Priority Mail 2-Day Medium Flat Rate Box 2 4.55 lbs $13.85 $10.80 $3.05
203090 2018-05-31 $50.59 Priority Mail 2-Day 2 1.50 lbs $13.01 $9.19 $3.82
203093 2018-05-31 $48.49 Priority Mail 3-Day 3 0.90 lbs $10.32 $9.19 $1.13
203094 2018-05-31 $9.70 First-Class Package Service 1 0.27 lbs $4.71 $3.82 $0.89
203096 2018-05-31 $21.36 First-Class Package Service 5 0.13 lbs $3.84 $2.66 $1.18
203099 2018-05-31 $20.41 First-Class Package Service 2 0.30 lbs $4.23 $3.18 $1.05
203100 2018-06-01 $14.18 First-Class Package Service 1 0.25 lbs $3.97 $3.05 $0.92
203104 2018-06-01 $14.09 First-Class Package Service 2 0.12 lbs $3.71 $2.66 $1.05
203105 2018-06-01 $59.96 Priority Mail 2-Day 16 1.19 lbs $9.00 $8.98 $0.02
203106 2018-06-01 $8.08 First-Class Package Service 2 0.25 lbs $4.10 $3.05 $1.05
203109 2018-06-02 $20.81 Priority Mail 3-Day 3 1.00 lbs $11.14 $9.98 $1.16
203110 2018-06-02 $28.84 First-Class Mail Large Envelope 3 0.60 lbs $4.87 $4.10 $0.77
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56