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
222289 2021-02-18 $216.75 FedExHomeDelivery 1 9.20 lbs $36.76 $26.93 $9.83
222290 2021-02-18 $18.51 USPSFirstClass 1 0.25 lbs $5.12 $3.85 $1.27
222291 2021-02-18 $9.43 USPSFirstClass 1 0.03 lbs $4.54 $3.35 $1.19
222292 2021-02-18 $33.42 USPSPriority 1 1.90 lbs $12.97 $12.70 $0.27
222296 2021-02-18 $9.97 First-Class Package Service 2 0.06 lbs $3.99 $3.49 $0.50
222297 2021-02-18 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.35 $-0.15
222300 2021-02-18 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.75 $7.90 $0.85
222305 2021-02-18 $54.54 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.75 lbs $8.85 $7.90 $0.95
222306 2021-02-18 $35.25 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.75 $7.90 $0.85
222309 2021-02-18 $7.19 First-Class Mail Stamped Letter 1 0.06 lbs $3.20 $3.35 $-0.15
222311 2021-02-18 $89.41 Priority Mail 3-Day 3 0.46 lbs $12.54 $5.98 $6.56
222312 2021-02-18 $20.22 USPSFirstClass 2 0.12 lbs $4.64 $3.22 $1.42
222313 2021-02-18 $40.93 USPSPriority 1 3.10 lbs $22.14 $4.57 $17.57
222314 2021-02-18 $9.34 First-Class Package Service 2 0.10 lbs $3.56 $3.06 $0.50
222316 2021-02-18 $66.71 Priority Mail 2-Day Small Flat Rate Box 4 3.44 lbs $8.75 $7.90 $0.85
222318 2021-02-18 $46.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.95 lbs $8.85 $8.00 $0.85
222319 2021-02-18 $83.24 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $8.25 $8.00 $0.25
222320 2021-02-18 $8.59 First-Class Mail Stamped Letter 1 0.15 lbs $3.40 $3.12 $0.28
222327 2021-02-18 $11.41 First-Class Package Service 5 0.24 lbs $3.96 $3.46 $0.50
222328 2021-02-18 $35.61 Priority Mail 2-Day 4 0.29 lbs $9.65 $7.90 $1.75
222329 2021-02-19 $9.90 USPSFirstClass 1 0.06 lbs $4.57 $3.35 $1.22
222330 2021-02-19 $28.39 USPSFirstClass 1 0.15 lbs $5.45 $3.35 $2.10
222331 2021-02-19 $19.41 USPSFirstClass 3 0.09 lbs $8.94 $3.35 $5.59
222332 2021-02-19 $29.76 Priority Mail 2-Day 3 0.80 lbs $9.09 $8.34 $0.75
222335 2021-02-19 $17.11 First-Class Package Service 2 0.15 lbs $4.08 $3.58 $0.50
222338 2021-02-19 $40.02 Priority Mail 3-Day Flat Rate Envelope 3 1.11 lbs $8.25 $8.00 $0.25
222340 2021-02-19 $135.58 Ground 1 19.40 lbs $40.59 $35.75 $4.84
222341 2021-02-19 $41.54 USPSFirstClass 8 1.18 lbs $24.42 $11.01 $13.41
222342 2021-02-19 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
222345 2021-02-19 $385.28 Priority Mail 2-Day 1 18.94 lbs $26.37 $26.11 $0.26
222346 2021-02-19 $75.36 Priority Mail 3-Day 34 1.40 lbs $9.70 $9.01 $0.69
222348 2021-02-19 $7.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222349 2021-02-19 $22.55 First-Class Package Service 2 0.31 lbs $4.07 $3.57 $0.50
222350 2021-02-19 $43.61 First-Class Package Service 4 0.35 lbs $4.63 $4.38 $0.25
222352 2021-02-19 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
222353 2021-02-19 $50.56 Priority Mail 2-Day 8 5.32 lbs $20.24 $19.39 $0.85
222357 2021-02-19 $85.68 Priority Mail 3-Day Medium Flat Rate Box 4 2.67 lbs $15.00 $13.75 $1.25
222359 2021-02-19 $17.98 USPSFirstClass 1 0.17 lbs $4.67 $3.46 $1.21
222360 2021-02-19 $20.50 USPSFirstClass 4 1.00 lbs $8.94 $10.44 $-1.50
222361 2021-02-19 $7.33 USPSFirstClass 1 0.25 lbs $4.44 $3.69 $0.75
222362 2021-02-19 $28.73 USPSPriority 1 1.50 lbs $11.94 $9.64 $2.30
222363 2021-02-19 $31.53 USPSPriority 1 1.50 lbs $14.74 $11.01 $3.73
222364 2021-02-19 $28.39 USPSFirstClass 1 0.15 lbs $5.45 $3.35 $2.10
222365 2021-02-19 $8.66 USPSFirstClass 1 0.40 lbs $5.27 $4.53 $0.74
222366 2021-02-19 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
222367 2021-02-19 $46.03 Priority Mail 2-Day Flat Rate Envelope 3 1.43 lbs $8.50 $15.80 $-7.30
222370 2021-02-19 $10.00 First-Class Package Service 1 0.15 lbs $4.01 $3.06 $0.95
222371 2021-02-19 $23.38 First-Class Package Service 1 0.22 lbs $3.99 $7.46 $-3.47
222374 2021-02-19 $66.83 Priority Mail 3-Day Padded Flat Rate Envelope 2 3.50 lbs $8.85 $8.00 $0.85
222375 2021-02-19 $15.87 First-Class Mail Stamped Letter 7 0.17 lbs $3.60 $3.58 $0.02
222377 2021-02-19 $9.64 First-Class Mail Stamped Letter 6 0.06 lbs $3.20 $3.22 $-0.02
222378 2021-02-19 $11.56 First-Class Package Service 6 0.06 lbs $3.62 $3.12 $0.50
222380 2021-02-19 $89.54 Priority Mail 2-Day 30 5.94 lbs $26.24 $22.52 $3.72
222381 2021-02-19 $70.69 Priority Mail 3-Day Padded Flat Rate Envelope 2 7.00 lbs $8.85 $8.00 $0.85
222382 2021-02-19 $21.82 First-Class Package Service 1 0.45 lbs $5.03 $3.69 $1.34
222383 2021-02-19 $15.04 Priority Mail 3-Day Flat Rate Envelope 1 0.03 lbs $8.25 $8.52 $-0.27
222384 2021-02-19 $4.99 First-Class Mail Stamped Letter 1 0.00 lbs $3.00 $3.35 $-0.35
222386 2021-02-20 $20.84 USPSFirstClass 1 0.40 lbs $5.85 $3.69 $2.16
222387 2021-02-20 $29.58 USPSPriority 1 1.50 lbs $12.79 $12.70 $0.09
222388 2021-02-20 $20.12 USPSFirstClass 2 0.77 lbs $8.54 $8.24 $0.30
222389 2021-02-20 $7.78 USPSFirstClass 1 0.06 lbs $4.47 $3.35 $1.12
222390 2021-02-20 $29.58 USPSPriority 1 1.50 lbs $12.79 $10.44 $2.35
222391 2021-02-20 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.06 $0.14
222393 2021-02-20 $33.79 Priority Mail 3-Day Medium Flat Rate Box 1 3.10 lbs $15.00 $11.63 $3.37
222394 2021-02-20 $41.81 Priority Mail 3-Day 3 0.57 lbs $11.29 $8.34 $2.95
222395 2021-02-20 $34.76 First-Class Mail Stamped Letter 4 0.16 lbs $3.60 $3.49 $0.11
222396 2021-02-20 $15.34 First-Class Package Service 1 0.35 lbs $4.35 $3.85 $0.50
222399 2021-02-20 $34.08 Priority Mail 2-Day 1 0.95 lbs $11.29 $10.44 $0.85
222400 2021-02-20 $33.23 Priority Mail 3-Day Flat Rate Envelope 2 0.90 lbs $8.25 $7.90 $0.35
222401 2021-02-20 $99.63 Priority Mail 2-Day Flat Rate Envelope 2 3.50 lbs $8.25 $8.00 $0.25
222402 2021-02-20 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
222403 2021-02-20 $33.79 Priority Mail 2-Day Medium Flat Rate Box 1 3.10 lbs $15.00 $11.63 $3.37
222405 2021-02-20 $88.36 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.44 lbs $8.85 $7.40 $1.45
222406 2021-02-20 $9.04 First-Class Package Service 1 0.07 lbs $3.85 $3.35 $0.50
222407 2021-02-20 $7.06 USPSFirstClass 1 0.01 lbs $4.57 $3.49 $1.08
222410 2021-02-20 $9.18 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.06 $0.14
222411 2021-02-20 $34.08 Priority Mail 2-Day 1 0.95 lbs $11.29 $10.89 $0.40
222412 2021-02-20 $11.67 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.01 $0.19
222413 2021-02-20 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.75 $7.90 $0.85
222419 2021-02-20 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
222420 2021-02-20 $99.07 Priority Mail 2-Day Medium Flat Rate Box 69 1.56 lbs $15.00 $13.75 $1.25
222421 2021-02-20 $31.48 USPSPriority 1 3.10 lbs $12.69 $8.34 $4.35
222423 2021-02-20 $9.60 USPSFirstClass 1 0.06 lbs $4.27 $3.01 $1.26
222425 2021-02-20 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.75 $7.90 $0.85
222426 2021-02-20 $16.38 First-Class Mail Stamped Letter 2 0.14 lbs $3.40 $3.58 $-0.18
222429 2021-02-20 $5.71 First-Class Package Service 1 0.02 lbs $3.72 $3.22 $0.50
222430 2021-02-20 $28.54 USPSFirstClass 1 0.15 lbs $5.60 $3.49 $2.11
222431 2021-02-20 $32.24 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $8.25 $8.00 $0.25
222432 2021-02-20 $42.30 Priority Mail 2-Day Flat Rate Envelope 2 1.28 lbs $8.25 $7.40 $0.85
222433 2021-02-20 $34.65 Priority Mail 3-Day 1 0.95 lbs $11.86 $11.63 $0.23
222435 2021-02-21 $73.29 USPSPriority 1 5.15 lbs $25.30 $21.48 $3.82
222436 2021-02-21 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
222439 2021-02-20 $29.80 Priority Mail 2-Day 7 1.92 lbs $9.57 $8.34 $1.23
222440 2021-02-20 $31.88 Priority Mail 3-Day 1 0.95 lbs $9.09 $8.34 $0.75
222444 2021-02-21 $23.03 First-Class Package Service 1 0.35 lbs $4.19 $3.69 $0.50
222445 2021-02-21 $16.32 First-Class Package Service 3 0.30 lbs $4.35 $3.85 $0.50
222447 2021-02-21 $13.33 USPSFirstClass 1 0.20 lbs $4.59 $3.06 $1.53
222448 2021-02-21 $11.28 USPSFirstClass 1 0.39 lbs $5.49 $4.68 $0.81
222449 2021-02-21 $6.24 USPSFirstClass 1 0.08 lbs $4.25 $3.06 $1.19
222450 2021-02-21 $6.13 USPSFirstClass 1 0.01 lbs $4.24 $3.06 $1.18
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56