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
223157 2021-03-09 $4.89 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.22 $-0.22
223158 2021-03-09 $48.02 First-Class Package Service 1 0.56 lbs $5.03 $4.53 $0.50
223159 2021-03-10 $6.29 USPSFirstClass 1 0.08 lbs $4.30 $3.12 $1.18
223160 2021-03-09 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
223161 2021-03-09 $32.69 Priority Mail 2-Day 1 0.85 lbs $9.70 $7.88 $1.82
223162 2021-03-09 $49.99 Priority Mail International Small Flat Rate Box 1 0.35 lbs $39.00 $38.15 $0.85
223164 2021-03-09 $46.93 Priority Mail 3-Day 3 2.13 lbs $13.55 $10.89 $2.66
223166 2021-03-09 $21.15 First-Class Package Service 2 0.25 lbs $4.19 $3.69 $0.50
223167 2021-03-10 $24.72 First-Class Package Service 5 0.24 lbs $4.01 $3.51 $0.50
223168 2021-03-10 $7.99 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.49 $-0.49
223169 2021-03-10 $33.08 First-Class Package International Service 1 0.35 lbs $21.29 $13.54 $7.75
223170 2021-03-10 $30.17 First-Class Package Service 1 0.40 lbs $5.18 $4.68 $0.50
223171 2021-03-10 $58.93 Priority Mail 3-Day 2 3.60 lbs $11.28 $10.33 $0.95
223172 2021-03-10 $34.58 USPSMedia 1 3.15 lbs $6.00 $4.57 $1.43
223173 2021-03-10 $14.44 USPSFirstClass 1 0.50 lbs $5.45 $5.66 $-0.21
223174 2021-03-10 $24.36 Priority Mail 2-Day Flat Rate Envelope 4 0.73 lbs $8.25 $7.90 $0.35
223175 2021-03-10 $19.97 USPSFirstClass 2 0.60 lbs $6.19 $4.53 $1.66
223176 2021-03-10 $11.14 Priority Mail 3-Day Flat Rate Envelope 1 0.05 lbs $8.25 $3.35 $4.90
223177 2021-03-10 $36.74 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
223178 2021-03-10 $18.34 First-Class Package Service 1 0.27 lbs $4.35 $3.85 $0.50
223179 2021-03-10 $29.07 USPSMedia 1 1.95 lbs $4.67 $3.45 $1.22
223181 2021-03-10 $33.49 Priority Mail 2-Day 5 0.77 lbs $12.54 $12.64 $-0.10
223182 2021-03-10 $30.53 First-Class Package Service 2 0.48 lbs $4.62 $4.12 $0.50
223183 2021-03-10 $14.31 First-Class Mail Stamped Letter 9 0.11 lbs $3.40 $3.35 $0.05
223184 2021-03-10 $29.20 First-Class Package Service 2 0.55 lbs $4.62 $4.12 $0.50
223186 2021-03-10 $25.74 First-Class Package Service 5 0.30 lbs $4.19 $3.69 $0.50
223187 2021-03-10 $18.54 Priority Mail 2-Day Small Flat Rate Box 1 0.30 lbs $8.75 $7.88 $0.87
223188 2021-03-10 $24.27 First-Class Package Service 4 0.78 lbs $6.31 $5.81 $0.50
223189 2021-03-10 $99.18 Priority Mail 2-Day Medium Flat Rate Box 5 5.99 lbs $15.00 $12.13 $2.87
223191 2021-03-10 $53.40 Priority Mail 3-Day 3 8.70 lbs $28.23 $8.85 $19.38
223192 2021-03-10 $23.43 First-Class Package Service 4 0.20 lbs $4.35 $3.85 $0.50
223194 2021-03-10 $45.20 Priority Mail 3-Day Medium Flat Rate Box 4 6.00 lbs $15.00 $9.01 $5.99
223196 2021-03-11 $25.57 First-Class Package Service 1 0.35 lbs $4.08 $3.58 $0.50
223198 2021-03-11 $31.08 First-Class Package International Service 1 0.05 lbs $25.09 $17.34 $7.75
223199 2021-03-11 $14.33 First-Class Package Service 1 0.40 lbs $4.54 $3.46 $1.08
223202 2021-03-11 $16.89 USPSFirstClass 1 0.15 lbs $4.90 $3.69 $1.21
223203 2021-03-11 $7.71 USPSFirstClass 1 0.07 lbs $4.32 $3.06 $1.26
223204 2021-03-11 $45.49 USPSFirstClass 1 0.58 lbs $7.50 $5.27 $2.23
223205 2021-03-11 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
223207 2021-03-11 $48.64 Priority Mail 2-Day Padded Flat Rate Envelope 1 0.75 lbs $8.85 $7.90 $0.95
223208 2021-03-11 $9.18 First-Class Mail Stamped Letter 2 0.07 lbs $3.20 $3.49 $-0.29
223209 2021-03-11 $37.63 First-Class Package Service 2 0.33 lbs $4.19 $3.69 $0.50
223210 2021-03-11 $8.56 First-Class Mail Stamped Letter 4 0.16 lbs $3.60 $3.35 $0.25
223211 2021-02-24 $14.49 First-Class Package Service 1 0.25 lbs $1.70 $3.57 $-1.87
223212 2021-03-11 $9.48 USPSFirstClass 1 0.02 lbs $4.69 $3.49 $1.20
223213 2021-03-11 $7.23 USPSFirstClass 1 0.10 lbs $4.34 $3.12 $1.22
223214 2021-03-11 $110.22 Priority Mail 3-Day 33 3.71 lbs $9.55 $13.75 $-4.20
223217 2021-03-11 $7.39 USPSFirstClass 1 0.20 lbs $4.40 $3.58 $0.82
223218 2021-03-11 $15.86 First-Class Package Service 1 0.30 lbs $4.07 $3.57 $0.50
223219 2021-03-11 $15.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.06 $0.34
223220 2021-03-11 $33.83 Priority Mail 2-Day 6 1.10 lbs $9.09 $8.24 $0.85
223221 2021-03-11 $32.26 First-Class Package Service 1 0.70 lbs $5.77 $5.27 $0.50
223224 2021-03-11 $24.87 First-Class Package Service 2 0.57 lbs $5.03 $4.53 $0.50
223225 2021-03-11 $37.84 First-Class Package Service 3 0.77 lbs $5.67 $5.42 $0.25
223226 2021-03-12 $6.45 USPSFirstClass 1 0.20 lbs $4.26 $3.51 $0.75
223227 2021-03-11 $9.10 First-Class Package Service 1 0.10 lbs $3.85 $3.35 $0.50
223228 2021-03-11 $10.18 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.12 $0.08
223230 2021-03-11 $22.82 First-Class Package Service 3 0.23 lbs $4.35 $3.85 $0.50
223232 2021-03-12 $40.52 Priority Mail 2-Day 3 1.90 lbs $8.85 $8.00 $0.85
223233 2021-03-12 $12.66 USPSFirstClass 3 0.15 lbs $4.29 $3.51 $0.78
223234 2021-03-12 $11.40 USPSFirstClass 2 0.06 lbs $4.42 $3.22 $1.20
223237 2021-03-12 $12.99 USPSFirstClass 1 0.17 lbs $4.86 $3.85 $1.01
223238 2020-11-03 $9.97 Priority Mail 2-Day 1 0.37 lbs $0.00 $3.51 $-3.51
223239 2021-03-12 $10.32 USPSFirstClass 1 0.05 lbs $4.59 $3.35 $1.24
223240 2021-03-12 $23.97 First-Class Package Service 1 0.56 lbs $5.18 $4.68 $0.50
223241 2021-03-12 $43.90 Priority Mail 3-Day Medium Flat Rate Box 10 2.74 lbs $15.00 $8.52 $6.48
223244 2021-03-12 $8.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
223246 2021-03-12 $15.64 Priority Mail 2-Day Small Flat Rate Box 1 0.30 lbs $8.75 $7.90 $0.85
223248 2021-03-12 $16.04 First-Class Package Service 2 0.71 lbs $6.06 $5.81 $0.25
223249 2021-03-12 $49.93 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.20 lbs $8.85 $7.90 $0.95
223251 2021-03-12 $14.48 USPSFirstClass 1 0.17 lbs $4.69 $3.57 $1.12
223252 2021-03-12 $58.98 Ground 2 20.15 lbs $36.08 $31.61 $4.47
223254 2021-03-12 $104.66 Next Day Air 3 0.29 lbs $100.19 $80.88 $19.31
223256 2021-03-12 $7.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
223257 2021-03-13 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
223258 2021-03-12 $78.84 Priority Mail 3-Day Padded Flat Rate Envelope 1 3.67 lbs $8.85 $8.00 $0.85
223260 2021-03-12 $34.97 Priority Mail 2-Day 4 2.66 lbs $19.81 $16.45 $3.36
223261 2021-03-12 $25.68 Priority Mail 2-Day 2 1.30 lbs $9.70 $8.85 $0.85
223265 2021-03-12 $13.02 First-Class Package Service 3 0.30 lbs $4.35 $3.49 $0.86
223267 2021-03-13 $38.91 Priority Mail 2-Day 4 1.76 lbs $14.95 $11.42 $3.53
223268 2021-03-13 $14.47 USPSFirstClass 2 0.06 lbs $4.69 $3.49 $1.20
223269 2021-03-13 $7.81 USPSFirstClass 1 0.03 lbs $4.32 $3.06 $1.26
223270 2021-03-13 $45.98 USPSFirstClass 5 0.35 lbs $22.41 $3.58 $18.83
223271 2021-03-13 $34.69 Priority Mail 2-Day 1 1.05 lbs $9.70 $8.85 $0.85
223278 2021-03-13 $4.49 First-Class Mail Stamped Letter 1 0.05 lbs $3.00 $3.06 $-0.06
223279 2021-03-13 $10.33 USPSFirstClass 1 0.04 lbs $4.54 $3.22 $1.32
223280 2021-03-13 $10.04 First-Class Package Service - Retail 1 0.07 lbs $5.05 $3.12 $1.93
223284 2021-03-14 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
223285 2021-03-13 $15.77 First-Class Package Service 1 0.50 lbs $4.78 $3.69 $1.09
223286 2021-03-13 $17.87 First-Class Package Service 1 0.28 lbs $4.08 $4.38 $-0.30
223288 2021-03-13 $46.26 First-Class Package Service 4 0.54 lbs $4.70 $4.20 $0.50
223291 2021-03-14 $8.52 First-Class Package Service 4 0.16 lbs $3.56 $3.51 $0.05
223292 2021-03-14 $11.28 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.06 $0.34
223293 2021-03-14 $120.76 Ground 32 8.20 lbs $25.08 $30.05 $-4.97
223294 2021-03-14 $12.33 USPSFirstClass 1 0.34 lbs $5.44 $3.69 $1.75
223295 2021-03-14 $7.33 USPSFirstClass 1 0.10 lbs $4.44 $3.35 $1.09
223296 2021-03-14 $13.61 USPSFirstClass 3 0.30 lbs $4.94 $3.46 $1.48
223297 2021-03-14 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
223298 2021-03-14 $9.69 First-Class Mail Stamped Letter 1 0.15 lbs $3.40 $6.98 $-3.58
223301 2021-03-14 $6.61 First-Class Package Service 1 0.03 lbs $3.62 $3.12 $0.50
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56