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
225339 2021-05-29 $279.02 Ground 1 14.30 lbs $42.29 $26.40 $15.89
225340 2021-05-29 $37.21 Priority Mail 3-Day 3 0.90 lbs $11.54 $10.44 $1.10
225343 2021-05-29 $16.81 First-Class Package Service 1 0.40 lbs $5.32 $4.12 $1.20
225345 2021-05-29 $228.67 Ground 1 13.20 lbs $33.48 $23.88 $9.60
225349 2021-05-29 $20.88 First-Class Mail Stamped Letter 12 0.14 lbs $4.00 $3.22 $0.78
225352 2021-05-29 $45.28 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $8.50 $8.00 $0.50
225353 2021-05-29 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
225355 2021-05-29 $16.54 First-Class Package Service 1 0.30 lbs $5.05 $3.85 $1.20
225356 2021-05-29 $27.19 First-Class Package Service 1 0.45 lbs $5.40 $4.20 $1.20
225357 2021-05-29 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.06 $0.74
225358 2021-05-29 $12.73 First-Class Mail Stamped Letter 7 0.08 lbs $3.80 $3.06 $0.74
225360 2021-05-30 $151.48 Priority Mail 3-Day Flat Rate Envelope 2 2.66 lbs $8.50 $8.00 $0.50
225361 2021-05-30 $32.83 USPSPriority 1 1.50 lbs $16.04 $11.69 $4.35
225362 2021-05-30 $8.44 USPSFirstClass 1 0.05 lbs $4.45 $3.22 $1.23
225363 2021-05-30 $6.45 USPSFirstClass 1 0.20 lbs $4.26 $3.51 $0.75
225364 2021-05-30 $48.48 Priority Mail 2-Day Small Flat Rate Box 2 1.40 lbs $8.50 $8.00 $0.50
225366 2021-05-30 $16.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.06 $0.74
225367 2021-05-30 $11.39 First-Class Package Service - Retail 1 0.03 lbs $5.40 $3.35 $2.05
225369 2021-05-30 $38.10 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225370 2021-05-31 $61.76 First-Class Package Service 5 0.28 lbs $4.71 $3.51 $1.20
225371 2021-05-31 $915.51 Ground 21 73.60 lbs $94.58 $94.31 $0.27
225372 2021-05-31 $5.60 First-Class Mail Stamped Letter 1 0.01 lbs $3.60 $3.35 $0.25
225373 2021-05-31 $23.30 Priority Mail 2-Day 1 2.52 lbs $10.31 $8.72 $1.59
225374 2021-05-31 $39.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225376 2021-05-31 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
225377 2021-05-31 $15.52 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.06 $0.94
225378 2021-05-31 $88.70 Priority Mail 2-Day 2 2.10 lbs $9.82 $8.00 $1.82
225379 2021-05-31 $48.51 Priority Mail 3-Day Flat Rate Envelope 3 1.00 lbs $8.50 $8.00 $0.50
225381 2021-05-31 $12.18 USPSFirstClass 1 0.06 lbs $4.39 $3.01 $1.38
225382 2021-05-31 $47.58 Priority Mail 3-Day Flat Rate Envelope 2 1.35 lbs $8.50 $7.90 $0.60
225383 2021-05-31 $11.78 First-Class Mail Stamped Letter 2 0.07 lbs $3.80 $3.12 $0.68
225384 2021-05-31 $37.10 Ground 2 0.10 lbs $25.62 $20.92 $4.70
225385 2021-05-31 $13.54 First-Class Package Service 1 0.05 lbs $4.55 $3.35 $1.20
225386 2021-05-31 $14.11 USPSFirstClass 1 0.10 lbs $4.62 $3.06 $1.56
225388 2021-05-31 $79.08 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.30 lbs $9.10 $7.90 $1.20
225389 2021-06-01 $12.23 USPSFirstClass 1 0.34 lbs $5.34 $3.58 $1.76
225390 2021-05-31 $27.67 First-Class Package Service 1 0.40 lbs $5.88 $4.68 $1.20
225392 2021-05-31 $23.45 First-Class Package Service 1 0.35 lbs $4.46 $3.51 $0.95
225393 2021-06-01 $15.20 First-Class Package Service 1 0.25 lbs $4.89 $3.69 $1.20
225394 2021-06-01 $26.50 Priority Mail 2-Day 1 1.10 lbs $9.34 $8.00 $1.34
225395 2021-06-01 $9.91 First-Class Package Service 1 0.10 lbs $4.42 $3.22 $1.20
225396 2021-06-01 $17.79 Priority Mail 1-Day 1 0.07 lbs $8.26 $7.90 $0.36
225399 2021-06-01 $14.42 First-Class Package Service 1 0.35 lbs $4.89 $3.69 $1.20
225402 2021-06-01 $13.79 First-Class Mail Stamped Letter 1 0.08 lbs $3.80 $3.22 $0.58
225403 2021-06-01 $21.77 First-Class Package Service 1 0.25 lbs $4.78 $3.22 $1.56
225404 2021-06-01 $7.06 USPSFirstClass 1 0.01 lbs $4.57 $3.49 $1.08
225405 2021-06-01 $35.39 Priority Mail 2-Day Medium Flat Rate Box 1 2.14 lbs $15.40 $12.64 $2.76
225406 2021-06-01 $16.77 First-Class Package Service 1 0.28 lbs $4.78 $3.58 $1.20
225407 2021-06-01 $12.78 First-Class Package Service 1 0.20 lbs $4.89 $3.35 $1.54
225409 2021-06-01 $29.54 First-Class Package Service - Retail 1 0.50 lbs $7.85 $4.68 $3.17
225410 2021-06-01 $11.11 First-Class Package Service 1 0.10 lbs $4.32 $3.57 $0.75
225411 2021-06-01 $11.15 USPSFirstClass 2 0.14 lbs $4.37 $3.57 $0.80
225412 2021-06-01 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225413 2021-06-01 $14.27 First-Class Mail Stamped Letter 3 0.11 lbs $3.80 $3.22 $0.58
225417 2021-06-02 $300.07 Priority Mail 2-Day Padded Flat Rate Envelope 3 2.70 lbs $9.10 $8.00 $1.10
225418 2021-06-02 $132.98 Priority Mail 3-Day Small Flat Rate Box 2 3.50 lbs $9.00 $7.90 $1.10
225419 2021-06-02 $12.99 Priority Mail 2-Day Small Flat Rate Box 1 0.05 lbs $9.00 $8.52 $0.48
225420 2021-06-02 $15.11 First-Class Package Service 1 0.25 lbs $4.89 $3.69 $1.20
225421 2021-06-02 $7.39 USPSFirstClass 1 0.02 lbs $4.40 $3.58 $0.82
225422 2021-06-02 $10.98 USPSFirstClass 3 0.03 lbs $4.41 $3.35 $1.06
225423 2021-06-02 $10.29 First-Class Mail Stamped Letter 1 0.10 lbs $4.00 $3.35 $0.65
225424 2021-06-02 $44.93 UPSGround 1 0.50 lbs $15.16 $22.60 $-7.44
225425 2021-06-02 $10.19 First-Class Mail Stamped Letter 1 0.18 lbs $4.20 $3.35 $0.85
225428 2021-06-02 $10.28 USPSFirstClass 2 0.04 lbs $4.30 $3.06 $1.24
225431 2021-06-02 $75.27 Priority Mail 3-Day 3 1.80 lbs $13.80 $10.82 $2.98
225432 2021-06-02 $24.19 Ground 1 0.04 lbs $16.40 $10.65 $5.75
225433 2021-06-02 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
225434 2021-06-02 $43.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225436 2021-06-02 $12.97 First-Class Mail Stamped Letter 3 0.15 lbs $4.00 $3.12 $0.88
225438 2021-06-02 $17.66 First-Class Package Service 1 0.30 lbs $4.77 $3.57 $1.20
225439 2021-06-03 $11.94 First-Class Package Service 1 0.34 lbs $5.05 $3.85 $1.20
225440 2021-06-03 $8.53 First-Class Package Service 2 0.02 lbs $4.55 $3.35 $1.20
225442 2021-06-03 $16.70 First-Class Package Service 1 0.21 lbs $4.71 $3.51 $1.20
225443 2021-06-03 $7.91 USPSFirstClass 1 0.03 lbs $4.42 $3.22 $1.20
225444 2021-06-03 $12.23 USPSFirstClass 1 0.34 lbs $5.34 $3.58 $1.76
225445 2021-06-03 $46.71 USPSPriority 1 2.60 lbs $21.65 $16.45 $5.20
225447 2021-06-03 $26.99 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.51 $0.49
225448 2021-06-03 $10.11 USPSFirstClass 1 0.06 lbs $4.72 $3.49 $1.23
225449 2021-06-03 $34.92 Priority Mail 2-Day 2 1.10 lbs $9.34 $8.24 $1.10
225450 2021-06-03 $9.79 First-Class Mail Stamped Letter 1 0.07 lbs $3.80 $3.49 $0.31
225451 2021-06-03 $20.77 Priority Mail 2-Day 2 1.00 lbs $12.79 $11.69 $1.10
225457 2021-06-03 $15.11 First-Class Package Service 1 0.25 lbs $4.89 $3.69 $1.20
225462 2021-06-03 $40.99 First-Class Package Service - Retail 1 0.13 lbs $6.00 $3.51 $2.49
225468 2021-06-03 $50.47 Priority Mail 2-Day 7 0.78 lbs $9.34 $7.67 $1.67
225470 2021-06-03 $19.76 First-Class Package Service 3 0.22 lbs $4.78 $3.22 $1.56
225471 2021-06-04 $55.36 Priority Mail 3-Day 5 4.30 lbs $23.06 $21.96 $1.10
225472 2021-06-04 $10.29 First-Class Mail Stamped Letter 1 0.10 lbs $4.00 $3.49 $0.51
225473 2021-06-04 $16.36 First-Class Package Service 2 0.20 lbs $4.78 $3.58 $1.20
225476 2021-06-04 $14.16 USPSFirstClass 1 0.10 lbs $4.67 $3.12 $1.55
225480 2021-06-04 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.01 $0.79
225481 2021-06-04 $9.80 First-Class Package Service 2 0.08 lbs $4.42 $3.22 $1.20
225482 2021-06-04 $13.40 First-Class Mail Stamped Letter 4 0.12 lbs $4.00 $3.22 $0.78
225483 2021-06-04 $9.86 USPSFirstClass 1 0.06 lbs $4.47 $3.12 $1.35
225484 2021-06-04 $41.79 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $9.00 $7.90 $1.10
225487 2021-06-04 $76.40 Priority Mail 3-Day 7 2.00 lbs $9.82 $8.00 $1.82
225489 2021-06-04 $49.23 Priority Mail 2-Day 6 1.35 lbs $12.79 $11.69 $1.10
225490 2021-06-04 $56.76 Priority Mail 2-Day 1 0.69 lbs $8.77 $7.67 $1.10
225491 2021-06-04 $30.73 Priority Mail 2-Day 1 2.14 lbs $10.74 $8.00 $2.74
225493 2021-06-05 $44.24 First-Class Package Service 1 0.58 lbs $5.24 $4.04 $1.20
225494 2021-06-05 $10.43 USPSFirstClass 2 0.20 lbs $4.45 $3.35 $1.10
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56