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
204079 2018-09-17 $8.19 First-Class Package Service 2 0.04 lbs $3.71 $2.66 $1.05
204080 2018-09-17 $6.20 First-Class Package Service 3 0.15 lbs $3.71 $2.66 $1.05
204087 2018-09-17 $23.10 First-Class Package Service 1 0.22 lbs $3.71 $2.92 $0.79
204088 2018-09-18 $86.34 Direct Link International 1 2.85 lbs $28.35 $43.97 $-15.62
204090 2018-09-18 $16.72 First-Class Package Service 1 0.45 lbs $4.23 $3.34 $0.89
204091 2018-09-16 $237.04 Ground 5 14.92 lbs $26.59 $21.07 $5.52
204092 2018-09-18 $16.54 First-Class Package Service 7 0.11 lbs $3.71 $2.66 $1.05
204093 2018-09-18 $23.91 Priority Mail 2-Day Small Flat Rate Box 9 0.51 lbs $7.90 $6.85 $1.05
204094 2018-09-18 $32.07 Priority Mail 2-Day Small Flat Rate Box 3 0.70 lbs $7.90 $6.85 $1.05
204095 2018-09-18 $11.70 First-Class Package Service 1 0.17 lbs $3.71 $5.58 $-1.87
204096 2018-09-18 $18.66 First-Class Package Service 5 0.15 lbs $3.71 $7.98 $-4.27
204097 2018-09-18 $39.37 First-Class Package Service 10 0.18 lbs $3.97 $2.79 $1.18
204098 2018-09-19 $166.05 Priority Mail International 8 5.17 lbs $63.63 $59.38 $4.25
204099 2018-09-19 $6.08 First-Class Package Service 2 0.38 lbs $4.10 $7.98 $-3.88
204101 2018-09-19 $98.98 Priority Mail 2-Day Medium Flat Rate Box 9 2.69 lbs $13.85 $12.45 $1.40
204102 2018-09-19 $8.99 First-Class Package Service 1 0.45 lbs $4.10 $3.34 $0.76
204103 2018-09-19 $98.15 Direct Link International 17 2.18 lbs $25.32 $33.48 $-8.16
204104 2018-09-19 $7.81 First-Class Package Service 5 0.22 lbs $3.84 $8.76 $-4.92
204106 2018-09-19 $12.64 First-Class Package Service 7 0.08 lbs $3.71 $2.66 $1.05
204107 2018-09-19 $8.50 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
204108 2018-09-20 $41.99 First-Class Package International Service 5 0.27 lbs $21.54 $22.33 $-0.79
204114 2018-09-20 $62.37 Priority Mail 3-Day Medium Flat Rate Box 10 1.93 lbs $13.85 $12.45 $1.40
204115 2018-09-20 $102.16 Priority Mail 3-Day 4 3.95 lbs $10.22 $7.40 $2.82
204117 2018-09-21 $76.99 Priority Mail 2-Day 1 3.85 lbs $17.00 $15.67 $1.33
204118 2018-09-21 $33.52 Direct Link International 1 0.05 lbs $18.73 $23.49 $-4.76
204120 2018-09-21 $11.69 First-Class Package Service 2 0.11 lbs $3.71 $2.66 $1.05
204127 2018-09-21 $9.19 First-Class Package Service 4 0.12 lbs $5.23 $3.05 $2.18
204128 2018-09-22 $111.27 Direct Link International 3 2.85 lbs $35.70 $60.31 $-24.61
204129 2018-09-22 $28.07 First-Class Package Service 2 0.40 lbs $4.39 $3.34 $1.05
204130 2018-09-22 $17.69 First-Class Package Service 2 0.12 lbs $3.71 $2.66 $1.05
204131 2018-09-23 $77.44 Priority Mail 3-Day 7 1.72 lbs $13.01 $9.47 $3.54
204132 2018-09-23 $49.78 Priority Mail 3-Day 2 1.50 lbs $9.00 $7.91 $1.09
204133 2018-09-23 $14.62 First-Class Package Service 2 0.25 lbs $3.84 $2.92 $0.92
204134 2018-09-23 $52.39 Priority Mail 3-Day Flat Rate Envelope 1 4.90 lbs $7.40 $6.90 $0.50
204135 2018-09-24 $13.69 First-Class Package Service 2 0.04 lbs $3.71 $2.66 $1.05
204137 2018-09-24 $93.38 Priority Mail 2-Day 3 2.05 lbs $10.11 $10.03 $0.08
204138 2018-09-24 $143.73 Priority Mail 2-Day 19 6.16 lbs $20.92 $16.15 $4.77
204139 2018-09-24 $135.88 Priority Mail 2-Day 4 5.55 lbs $16.45 $10.65 $5.80
204140 2018-09-24 $33.38 First-Class Package Service 5 0.43 lbs $4.23 $3.66 $0.57
204141 2018-09-24 $39.35 Priority Mail 3-Day 1 2.20 lbs $9.32 $7.40 $1.92
204142 2018-09-24 $8.89 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
204143 2018-09-24 $31.01 Priority Mail 2-Day 10 1.90 lbs $10.11 $7.91 $2.20
204145 2018-09-25 $73.47 Direct Link International 2 1.68 lbs $24.49 $34.16 $-9.67
204146 2018-09-25 $54.23 Direct Link International 3 1.28 lbs $13.23 $37.58 $-24.35
204147 2018-09-25 $24.30 First-Class Package Service 4 0.26 lbs $3.84 $3.05 $0.79
204148 2018-09-25 $19.34 Priority Mail 2-Day Flat Rate Envelope 6 0.18 lbs $7.40 $6.85 $0.55
204149 2018-09-26 $36.38 First-Class Package Service 1 0.50 lbs $4.39 $3.66 $0.73
204150 2018-09-26 $36.51 Direct Link International 1 0.40 lbs $6.52 $29.17 $-22.65
204151 2018-09-26 $21.44 First-Class Package Service 3 0.30 lbs $3.97 $3.05 $0.92
204152 2018-09-26 $44.10 Priority Mail 3-Day Flat Rate Envelope 30 1.08 lbs $7.40 $6.85 $0.55
204155 2018-09-26 $44.83 Direct Link International 2 0.83 lbs $21.55 $29.24 $-7.69
204156 2018-09-26 $108.40 Direct Link International 4 1.95 lbs $38.84 $38.34 $0.50
204158 2018-09-26 $39.38 Priority Mail 2-Day 27 1.13 lbs $11.65 $10.48 $1.17
204159 2018-09-26 $11.61 First-Class Package Service 10 0.10 lbs $3.71 $2.66 $1.05
204160 2018-09-26 $5.69 First-Class Package Service 2 0.07 lbs $3.71 $3.05 $0.66
204161 2018-09-26 $40.39 Priority Mail 2-Day Small Flat Rate Box 2 1.20 lbs $7.90 $6.85 $1.05
204162 2018-09-27 $37.78 Direct Link International 4 0.08 lbs $17.82 $21.90 $-4.08
204163 2018-09-27 $154.37 Direct Link International 4 5.00 lbs $53.41 $93.28 $-39.87
204164 2018-09-27 $31.27 First-Class Package Service 2 0.65 lbs $4.95 $4.38 $0.57
204171 2018-09-27 $57.13 Priority Mail 2-Day 5 2.04 lbs $10.11 $8.15 $1.96
204172 2018-09-27 $42.49 Priority Mail 2-Day 16 1.52 lbs $11.65 $10.48 $1.17
204173 2018-09-28 $73.66 Direct Link International 2 1.73 lbs $24.68 $34.84 $-10.16
204174 2018-09-28 $73.90 Direct Link International 3 1.75 lbs $24.77 $35.20 $-10.43
204175 2018-09-28 $64.54 Direct Link International 3 1.73 lbs $12.67 $34.82 $-22.15
204176 2018-09-28 $61.27 Direct Link International 2 1.63 lbs $12.29 $34.16 $-21.87
204177 2018-09-28 $52.08 Direct Link International 1 1.45 lbs $11.59 $37.89 $-26.30
204178 2018-09-28 $52.28 Direct Link International 1 1.50 lbs $11.79 $20.16 $-8.37
204179 2018-09-28 $93.99 Direct Link International 2 4.40 lbs $23.01 $86.42 $-63.41
204180 2018-09-28 $23.10 First-Class Package Service 1 0.22 lbs $3.71 $2.92 $0.79
204183 2018-09-28 $7.69 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
204184 2018-09-28 $28.64 First-Class Package Service 7 0.52 lbs $4.71 $3.18 $1.53
204185 2018-09-28 $10.69 First-Class Package Service 2 0.10 lbs $3.71 $2.66 $1.05
204187 2018-09-28 $45.13 First-Class Package Service 2 0.75 lbs $5.15 $4.38 $0.77
204188 2018-09-28 $121.70 Priority Mail 2-Day 38 3.80 lbs $21.88 $20.40 $1.48
204189 2018-09-28 $40.89 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
204190 2018-09-28 $35.89 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.90 $6.85 $1.05
204192 2018-09-29 $68.73 Ground 1 7.20 lbs $18.74 $16.94 $1.80
204196 2018-09-30 $61.05 Direct Link International 1 1.50 lbs $23.80 $33.14 $-9.34
204199 2018-09-30 $33.86 First-Class Package Service 11 0.53 lbs $4.87 $3.82 $1.05
204200 2018-09-30 $34.10 Priority Mail 2-Day Padded Flat Rate Envelope 25 1.06 lbs $7.95 $6.90 $1.05
204202 2018-09-30 $18.08 Priority Mail 2-Day 1 0.50 lbs $7.95 $6.89 $1.06
204203 2018-09-30 $60.16 Priority Mail 3-Day 2 7.10 lbs $12.18 $7.40 $4.78
204207 2018-10-01 $95.07 Priority Mail 2-Day 28 1.22 lbs $11.65 $10.48 $1.17
204208 2018-10-01 $106.28 Direct Link International 4 3.06 lbs $31.72 $47.71 $-15.99
204209 2018-10-01 $55.24 Priority Mail 2-Day Flat Rate Envelope 16 0.38 lbs $7.40 $6.85 $0.55
204211 2018-10-01 $84.97 Priority Mail 2-Day 3 4.06 lbs $17.00 $47.01 $-30.01
204213 2018-10-02 $585.02 Direct Link International 50 31.55 lbs $123.10 $26.89 $96.21
204214 2018-10-02 $7.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204215 2018-10-02 $11.87 Priority Mail 2-Day Flat Rate Envelope 2 0.12 lbs $7.40 $2.66 $4.74
204216 2018-10-02 $16.98 First-Class Package Service 3 0.17 lbs $3.71 $2.79 $0.92
204217 2018-10-02 $45.09 Priority Mail 2-Day 10 2.50 lbs $16.19 $12.45 $3.74
204218 2018-10-02 $6.65 First-Class Package Service 4 0.31 lbs $4.10 $2.92 $1.18
204219 2018-10-03 $25.69 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.40 $6.90 $0.50
204220 2018-10-03 $41.43 Priority Mail 3-Day 2 1.70 lbs $8.25 $7.18 $1.07
204225 2018-10-03 $21.83 First-Class Package Service 6 0.48 lbs $4.39 $3.34 $1.05
204226 2018-10-03 $25.12 First-Class Package Service 3 0.57 lbs $4.55 $3.82 $0.73
204227 2018-10-03 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
204229 2018-10-03 $14.18 First-Class Package Service 3 0.11 lbs $3.71 $2.66 $1.05
204230 2018-10-03 $19.01 First-Class Package Service 8 0.34 lbs $3.97 $3.18 $0.79
204234 2018-10-04 $168.65 Direct Link International 4 5.25 lbs $38.69 $115.32 $-76.63
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56