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
204978 2018-12-20 $24.68 Priority Mail 3-Day Flat Rate Envelope 1 0.35 lbs $7.40 $6.85 $0.55
204979 2018-12-20 $26.90 Priority Mail 2-Day 2 1.90 lbs $9.32 $8.22 $1.10
204983 2018-12-21 $88.70 Direct Link International 2 2.05 lbs $30.72 $28.79 $1.93
204984 2018-12-21 $18.86 First-Class Package Service 3 0.39 lbs $4.39 $3.82 $0.57
204985 2018-12-21 $14.09 First-Class Package Service 2 0.08 lbs $3.71 $2.79 $0.92
204986 2018-12-21 $13.82 First-Class Package Service 2 0.24 lbs $3.84 $2.79 $1.05
204987 2018-12-21 $68.84 Priority Mail 2-Day Flat Rate Envelope 6 1.52 lbs $7.40 $6.85 $0.55
204988 2018-12-21 $8.90 First-Class Package Service 1 0.08 lbs $3.71 $2.66 $1.05
204991 2018-12-22 $42.93 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.25 lbs $7.95 $6.85 $1.10
204993 2018-12-22 $27.92 First-Class Package Service 2 0.74 lbs $5.15 $4.66 $0.49
204994 2018-12-22 $8.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
204997 2018-12-22 $30.80 Direct Link International 1 0.30 lbs $19.01 $16.25 $2.76
204998 2018-12-22 $81.74 First-Class Package International Service 9 1.07 lbs $30.33 $22.33 $8.00
204999 2018-12-23 $101.69 First-Class Package International Service 24 1.02 lbs $30.33 $22.33 $8.00
205000 2018-12-23 $8.81 First-Class Package Service 3 0.22 lbs $3.84 $3.05 $0.79
205003 2018-12-24 $68.68 Priority Mail 2-Day Medium Flat Rate Box 37 3.42 lbs $13.85 $10.80 $3.05
205004 2018-12-24 $10.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
205005 2018-12-24 $24.24 First-Class Package Service 1 0.65 lbs $4.95 $4.94 $0.01
205008 2018-12-24 $6.68 First-Class Package Service 3 0.12 lbs $3.71 $2.66 $1.05
205012 2018-12-25 $54.01 Priority Mail 3-Day 9 1.23 lbs $9.00 $7.91 $1.09
205013 2018-12-25 $18.94 First-Class Package Service 3 0.30 lbs $3.97 $2.79 $1.18
205015 2018-12-25 $8.20 First-Class Package Service 1 0.50 lbs $5.71 $6.89 $-1.18
205016 2018-12-25 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
205017 2018-12-26 $99.42 Priority Mail 3-Day 14 6.33 lbs $16.45 $8.15 $8.30
205018 2018-12-26 $102.90 Priority Mail 2-Day 3 2.20 lbs $13.01 $13.75 $-0.74
205023 2018-12-26 $57.42 Ground 2 4.30 lbs $22.84 $22.67 $0.17
205024 2018-12-26 $6.60 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
205027 2018-12-26 $163.66 Priority Mail 2-Day 6 6.88 lbs $26.98 $25.35 $1.63
205029 2018-12-26 $7.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
205032 2018-12-27 $37.60 Priority Mail 3-Day 5 1.30 lbs $8.25 $7.40 $0.85
205033 2018-12-27 $15.76 First-Class Package Service 1 0.35 lbs $3.97 $3.18 $0.79
205034 2018-12-27 $46.58 Priority Mail 2-Day 2 1.55 lbs $9.00 $7.91 $1.09
205035 2018-12-27 $40.09 Priority Mail 2-Day 1 0.75 lbs $11.14 $9.98 $1.16
205037 2018-12-28 $18.08 First-Class Package Service 2 0.38 lbs $4.10 $2.66 $1.44
205038 2018-12-28 $53.22 Priority Mail 3-Day Medium Flat Rate Box 3 1.25 lbs $13.85 $6.85 $7.00
205040 2018-12-28 $3.97 First-Class Package Service 1 0.30 lbs $3.97 $2.79 $1.18
205045 2018-12-29 $65.29 Priority Mail 2-Day 4 2.44 lbs $15.03 $13.75 $1.28
205047 2018-12-29 $14.46 First-Class Package Service 5 0.21 lbs $5.51 $4.94 $0.57
205048 2018-12-29 $56.81 Priority Mail 2-Day Medium Flat Rate Box 24 2.19 lbs $13.85 $10.80 $3.05
205049 2018-12-29 $24.54 First-Class Package Service 10 0.27 lbs $3.84 $2.92 $0.92
205050 2018-12-29 $18.08 First-Class Package Service 2 0.38 lbs $4.10 $2.66 $1.44
205051 2018-12-29 $7.69 First-Class Package Service 2 0.20 lbs $3.71 $2.66 $1.05
205053 2018-12-29 $7.40 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
205056 2018-12-29 $7.69 First-Class Package Service 2 0.04 lbs $3.71 $2.66 $1.05
205057 2018-12-29 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
205060 2018-12-30 $17.91 First-Class Package Service 6 0.20 lbs $3.97 $3.18 $0.79
205061 2018-12-30 $7.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
205062 2018-12-30 $15.76 First-Class Package Service 1 0.35 lbs $3.97 $2.79 $1.18
205063 2018-12-30 $26.09 First-Class Package Service 1 0.40 lbs $4.10 $3.34 $0.76
205064 2018-12-30 $20.37 First-Class Package Service 2 0.40 lbs $4.39 $3.66 $0.73
205065 2018-12-30 $6.68 First-Class Package Service 3 0.06 lbs $3.71 $2.92 $0.79
205067 2018-12-30 $28.21 First-Class Package Service 2 0.45 lbs $4.23 $4.66 $-0.43
205070 2018-12-30 $32.14 Priority Mail 2-Day 11 1.11 lbs $8.25 $7.18 $1.07
205073 2018-12-31 $21.53 First-Class Mail Large Envelope 1 0.65 lbs $4.87 $4.94 $-0.07
205074 2018-12-31 $46.69 Priority Mail 3-Day 3 1.61 lbs $10.32 $9.47 $0.85
205075 2018-12-31 $7.20 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
205076 2018-12-31 $5.18 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
205077 2019-01-01 $28.29 Priority Mail 3-Day 3 1.22 lbs $10.32 $9.19 $1.13
205078 2019-01-01 $36.38 First-Class Package Service 1 0.50 lbs $4.39 $3.18 $1.21
205083 2019-01-01 $14.79 First-Class Package Service 16 0.14 lbs $3.71 $2.66 $1.05
205084 2019-01-01 $94.81 First-Class Package International Service 28 2.15 lbs $31.99 $23.99 $8.00
205088 2019-01-01 $13.95 First-Class Package Service 2 0.28 lbs $3.97 $3.18 $0.79
205089 2019-01-02 $28.78 First-Class Package Service 2 0.60 lbs $5.15 $4.94 $0.21
205091 2019-01-02 $6.65 First-Class Package Service 6 0.06 lbs $3.71 $2.66 $1.05
205093 2019-01-02 $12.09 First-Class Package Service 2 0.07 lbs $3.71 $2.66 $1.05
205094 2019-01-02 $17.79 Priority Mail 2-Day 1 0.95 lbs $9.00 $7.91 $1.09
205097 2019-01-02 $41.02 Priority Mail 2-Day 9 1.90 lbs $10.11 $8.15 $1.96
205100 2019-01-02 $37.98 Priority Mail 2-Day Padded Flat Rate Envelope 27 1.24 lbs $7.95 $6.90 $1.05
205102 2019-01-02 $60.92 Priority Mail 2-Day 2 4.30 lbs $11.50 $8.15 $3.35
205104 2019-01-03 $11.70 First-Class Package Service 1 0.17 lbs $3.71 $2.79 $0.92
205105 2019-01-03 $7.20 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
205107 2019-01-03 $22.37 Priority Mail 2-Day Flat Rate Envelope 3 0.17 lbs $7.40 $2.66 $4.74
205108 2019-01-03 $47.93 Priority Mail 2-Day 1 1.30 lbs $11.14 $9.98 $1.16
205109 2019-01-03 $63.63 Priority Mail 3-Day Medium Flat Rate Box 2 2.00 lbs $13.85 $10.29 $3.56
205110 2019-01-03 $21.32 First-Class Mail Large Envelope 1 0.60 lbs $4.66 $4.66 $0.00
205111 2019-01-03 $19.81 First-Class Package Service 3 0.26 lbs $3.84 $3.05 $0.79
205113 2019-01-03 $14.18 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
205115 2019-01-03 $180.40 Priority Mail 3-Day 9 5.40 lbs $27.89 $23.35 $4.54
205116 2019-01-04 $21.27 Priority Mail 3-Day 5 0.95 lbs $10.32 $9.19 $1.13
205117 2019-01-04 $11.37 First-Class Package Service 2 0.50 lbs $4.39 $3.66 $0.73
205119 2019-01-04 $13.30 First-Class Package Service 4 0.23 lbs $3.84 $3.18 $0.66
205120 2019-01-04 $10.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
205129 2019-01-05 $51.54 Priority Mail 2-Day 10 0.76 lbs $11.14 $7.28 $3.86
205130 2019-01-05 $47.31 Priority Mail 2-Day 30 8.75 lbs $12.31 $11.12 $1.19
205131 2019-01-05 $29.44 Priority Mail 3-Day 10 4.50 lbs $15.05 $10.33 $4.72
205132 2019-01-05 $5.21 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
205133 2019-01-05 $30.11 Ground 1 0.25 lbs $21.39 $6.85 $14.54
205134 2019-01-05 $10.16 First-Class Package Service 4 0.13 lbs $3.71 $2.66 $1.05
205136 2019-01-06 $20.47 Priority Mail 2-Day 1 3.55 lbs $8.16 $7.10 $1.06
205137 2019-01-06 $101.78 Direct Link International 6 3.43 lbs $30.48 $26.45 $4.03
205139 2019-01-06 $52.31 Priority Mail 2-Day 2 2.10 lbs $13.01 $9.47 $3.54
205142 2019-01-07 $23.71 Priority Mail 3-Day Flat Rate Envelope 2 0.74 lbs $7.40 $4.38 $3.02
205143 2019-01-07 $15.20 Priority Mail 3-Day Small Flat Rate Box 12 0.22 lbs $7.90 $6.85 $1.05
205150 2019-01-07 $49.10 Priority Mail 2-Day 2 1.50 lbs $10.32 $9.19 $1.13
205153 2019-01-07 $69.99 Priority Mail 2-Day Flat Rate Envelope 5 1.60 lbs $7.40 $6.90 $0.50
205154 2019-01-07 $24.56 First-Class Package Service 5 0.23 lbs $5.71 $2.92 $2.79
205156 2019-01-07 $12.64 First-Class Package Service 7 0.08 lbs $3.71 $2.66 $1.05
205158 2019-01-07 $27.49 Priority Mail 2-Day 1 0.60 lbs $8.20 $7.13 $1.07
205163 2019-01-07 $19.19 Priority Mail 2-Day Flat Rate Envelope 1 0.30 lbs $7.40 $6.85 $0.55
205164 2019-01-07 $27.38 Priority Mail 2-Day Flat Rate Envelope 2 0.89 lbs $7.40 $6.85 $0.55
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56