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
215216 2020-09-03 $11.83 USPSFirstClass 1 0.31 lbs $5.09 $3.31 $1.78
215217 2020-09-02 $26.42 First-Class Package Service 3 0.46 lbs $4.45 $3.25 $1.20
215219 2020-09-03 $22.48 First-Class Package Service 2 0.09 lbs $3.50 $3.05 $0.45
215220 2020-09-03 $17.79 USPSFirstClass 6 0.42 lbs $5.85 $4.46 $1.39
215222 2020-09-03 $37.98 USPSFirstClass 1 0.10 lbs $5.62 $2.93 $2.69
215224 2020-09-03 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
215225 2020-09-03 $36.96 Priority Mail 2-Day 1 0.95 lbs $8.97 $8.21 $0.76
215231 2020-09-03 $13.37 First-Class Package Service 1 0.13 lbs $3.38 $2.93 $0.45
215232 2020-09-03 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.50 $7.90 $0.60
215234 2020-09-03 $23.64 First-Class Package Service - Retail 4 0.27 lbs $5.75 $3.52 $2.23
215235 2020-09-03 $9.19 First-Class Mail Stamped Letter 1 0.02 lbs $3.20 $2.93 $0.27
215236 2020-09-03 $8.44 USPSFirstClass 1 0.05 lbs $4.10 $2.78 $1.32
215237 2020-09-03 $17.79 Priority Mail 3-Day Flat Rate Envelope 1 0.30 lbs $8.00 $7.65 $0.35
215238 2020-09-03 $37.83 Priority Mail 2-Day 8 1.07 lbs $9.61 $8.76 $0.85
215240 2020-09-03 $9.17 First-Class Package Service 12 0.12 lbs $3.29 $2.84 $0.45
215241 2020-09-03 $6.40 USPSFirstClass 1 0.01 lbs $4.14 $3.05 $1.09
215242 2020-09-03 $62.97 Priority Mail 2-Day Flat Rate Envelope 3 1.54 lbs $8.00 $7.65 $0.35
215243 2020-09-03 $38.29 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
215244 2020-09-03 $38.29 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
215245 2020-09-03 $10.28 USPSFirstClass 1 0.20 lbs $4.45 $3.67 $0.78
215246 2020-09-03 $12.68 First-Class Mail Stamped Letter 2 0.14 lbs $3.50 $2.84 $0.66
215247 2020-09-03 $14.80 Priority Mail 2-Day 3 0.04 lbs $8.83 $7.65 $1.18
215248 2020-09-03 $161.12 Priority Mail 3-Day 3 10.15 lbs $36.35 $38.40 $-2.05
215250 2020-09-03 $7.70 First-Class Package Service 3 0.06 lbs $3.23 $2.78 $0.45
215251 2020-09-03 $13.63 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
215252 2020-09-04 $37.37 USPSFirstClass 10 0.34 lbs $5.45 $3.21 $2.24
215253 2020-09-03 $26.64 First-Class Package Service 1 0.40 lbs $4.45 $4.00 $0.45
215254 2020-09-04 $10.05 USPSFirstClass 1 0.20 lbs $4.30 $3.52 $0.78
215256 2020-09-04 $22.18 USPSFirstClass 2 0.30 lbs $5.19 $5.40 $-0.21
215261 2020-09-04 $123.69 Priority Mail 2-Day 4 5.75 lbs $25.03 $38.40 $-13.37
215262 2020-09-04 $9.68 USPSFirstClass 1 0.05 lbs $4.16 $2.78 $1.38
215263 2020-09-04 $7.32 USPSFirstClass 1 0.10 lbs $4.19 $3.05 $1.14
215264 2020-09-04 $15.99 USPSFirstClass 2 0.40 lbs $5.05 $4.18 $0.87
215265 2020-09-04 $11.98 USPSFirstClass 1 0.31 lbs $5.24 $4.32 $0.92
215266 2020-09-04 $41.39 Priority Mail 3-Day 4 1.37 lbs $11.39 $10.54 $0.85
215267 2020-09-04 $167.06 Direct Link International 34 8.92 lbs $65.41 $11.97 $53.44
215271 2020-09-04 $15.40 USPSFirstClass 1 0.10 lbs $4.54 $3.52 $1.02
215272 2020-09-04 $16.52 USPSFirstClass 2 0.08 lbs $8.44 $3.05 $5.39
215274 2020-09-04 $15.94 Priority Mail 2-Day Flat Rate Envelope 6 0.06 lbs $8.00 $7.65 $0.35
215276 2020-09-04 $14.83 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
215277 2020-09-04 $25.03 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
215279 2020-09-04 $22.13 Priority Mail 2-Day 1 0.47 lbs $10.84 $7.98 $2.86
215280 2020-09-04 $54.75 Priority Mail 2-Day Flat Rate Envelope 5 1.15 lbs $8.00 $7.65 $0.35
215281 2020-09-04 $9.83 USPSFirstClass 1 0.02 lbs $4.25 $2.93 $1.32
215283 2020-09-04 $3.69 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $2.78 $0.42
215285 2020-09-04 $148.33 Priority Mail 1-Day 2 4.01 lbs $8.89 $8.04 $0.85
215289 2020-09-04 $26.64 First-Class Package Service 1 0.40 lbs $4.45 $4.00 $0.45
215290 2020-09-04 $23.27 Priority Mail 3-Day 4 1.55 lbs $9.61 $8.76 $0.85
215291 2020-09-04 $19.44 First-Class Mail Stamped Letter 6 0.10 lbs $3.50 $3.67 $-0.17
215292 2020-09-04 $34.71 First-Class Package Service 2 0.60 lbs $4.43 $4.18 $0.25
215295 2020-09-05 $16.63 First-Class Package Service 1 0.25 lbs $3.84 $3.39 $0.45
215297 2020-09-05 $20.67 First-Class Package Service 3 0.22 lbs $3.70 $3.25 $0.45
215300 2020-09-05 $14.63 USPSFirstClass 2 0.65 lbs $5.94 $5.70 $0.24
215301 2020-09-05 $8.13 USPSFirstClass 1 0.03 lbs $4.17 $2.93 $1.24
215302 2020-09-05 $20.79 USPSFirstClass 1 0.15 lbs $4.80 $2.93 $1.87
215303 2020-09-05 $20.40 First-Class Package Service 1 0.40 lbs $4.91 $4.46 $0.45
215304 2020-09-05 $16.63 First-Class Package Service 1 0.20 lbs $3.84 $2.93 $0.91
215306 2020-09-05 $137.28 Priority Mail 2-Day Flat Rate Envelope 4 5.05 lbs $8.00 $7.75 $0.25
215308 2020-09-05 $45.80 Priority Mail 3-Day Medium Flat Rate Box 15 3.00 lbs $14.45 $12.15 $2.30
215309 2020-09-05 $9.68 USPSFirstClass 2 0.20 lbs $4.17 $3.05 $1.12
215311 2020-09-05 $58.34 Priority Mail 3-Day 4 2.70 lbs $11.18 $7.75 $3.43
215312 2020-09-05 $7.18 First-Class Mail Stamped Letter 2 0.04 lbs $3.20 $2.84 $0.36
215314 2020-09-05 $256.58 Ground Home Delivery 11 16.60 lbs $40.69 $35.39 $5.30
215318 2020-09-05 $40.18 Priority Mail 3-Day 3 1.03 lbs $9.61 $8.92 $0.69
215319 2020-09-05 $37.58 Priority Mail 2-Day Small Flat Rate Box 1 1.10 lbs $8.50 $7.65 $0.85
215321 2020-09-05 $25.19 First-Class Package Service 1 0.35 lbs $3.70 $3.25 $0.45
215322 2020-09-05 $174.93 Ground 1 30.00 lbs $31.32 $27.86 $3.46
215323 2020-09-06 $38.40 USPSFirstClass 4 0.20 lbs $16.96 $2.93 $14.03
215324 2020-09-06 $31.99 Priority Mail 3-Day Flat Rate Envelope 1 3.55 lbs $8.00 $7.75 $0.25
215325 2020-09-06 $20.64 USPSFirstClass 1 0.30 lbs $5.65 $3.52 $2.13
215327 2020-09-06 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
215329 2020-09-06 $41.21 Direct Link International 8 0.22 lbs $19.29 $9.46 $9.83
215330 2020-09-06 $9.38 USPSFirstClass 1 0.02 lbs $4.24 $2.93 $1.31
215331 2020-09-06 $38.69 USPSPriority 1 3.55 lbs $12.75 $7.75 $5.00
215332 2020-09-06 $26.72 First-Class Package Service 1 0.40 lbs $4.53 $5.27 $-0.74
215333 2020-09-06 $9.36 USPSFirstClass 1 0.05 lbs $4.22 $2.93 $1.29
215334 2020-09-06 $8.49 First-Class Package Service 1 0.07 lbs $3.50 $3.05 $0.45
215335 2020-09-06 $10.01 USPSFirstClass 1 0.02 lbs $4.30 $3.05 $1.25
215336 2020-09-06 $112.08 Ground 7 2.65 lbs $19.13 $16.91 $2.22
215339 2020-09-06 $12.14 First-Class Mail Stamped Letter 1 0.18 lbs $3.65 $3.67 $-0.02
215340 2020-09-06 $8.33 USPSFirstClass 1 0.05 lbs $4.10 $2.78 $1.32
215341 2020-09-06 $6.18 USPSFirstClass 1 0.20 lbs $4.29 $3.52 $0.77
215342 2020-09-06 $133.53 Priority Mail 2-Day 5 2.76 lbs $9.92 $9.07 $0.85
215343 2020-09-06 $15.63 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
215344 2020-09-06 $10.64 First-Class Mail Stamped Letter 1 0.19 lbs $3.65 $2.84 $0.81
215345 2020-09-06 $9.21 USPSFirstClass 1 0.05 lbs $4.17 $2.84 $1.33
215346 2020-09-06 $24.60 First-Class Package Service - Retail 1 0.40 lbs $6.50 $3.52 $2.98
215347 2020-09-06 $20.48 Priority Mail 2-Day Small Flat Rate Box 2 0.20 lbs $8.50 $7.65 $0.85
215348 2020-09-06 $17.82 First-Class Package Service 2 0.38 lbs $3.84 $2.93 $0.91
215349 2020-09-06 $38.56 Priority Mail 2-Day 3 0.87 lbs $11.39 $10.93 $0.46
215352 2020-09-06 $4.18 First-Class Mail Stamped Letter 2 0.02 lbs $3.20 $2.93 $0.27
215353 2020-09-06 $29.60 Priority Mail 3-Day 1 1.10 lbs $9.61 $8.76 $0.85
215354 2020-09-06 $42.88 Priority Mail 2-Day 3 1.16 lbs $9.61 $8.92 $0.69
215355 2020-09-06 $6.83 First-Class Package Service 1 0.20 lbs $3.84 $3.39 $0.45
215356 2020-09-07 $9.87 USPSFirstClass 1 0.20 lbs $4.30 $3.52 $0.78
215360 2020-09-07 $21.45 First-Class Package Service 4 0.65 lbs $5.99 $4.32 $1.67
215363 2020-09-07 $31.99 Priority Mail 2-Day Flat Rate Envelope 1 3.55 lbs $8.00 $7.75 $0.25
215364 2020-09-07 $107.54 Ground Home Delivery 1 8.55 lbs $23.55 $19.60 $3.95
215365 2020-09-07 $109.48 Priority Mail 2-Day 4 3.01 lbs $9.92 $8.21 $1.71
215367 2020-09-07 $67.09 Priority Mail 2-Day 1 3.90 lbs $19.31 $18.46 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56