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
226379 2021-07-24 $74.19 Priority Mail 2-Day 1 3.55 lbs $14.20 $11.70 $2.50
226380 2021-07-24 $9.28 USPSFirstClass 1 0.04 lbs $4.39 $3.06 $1.33
226381 2021-07-24 $67.94 Priority Mail 3-Day Flat Rate Envelope 1 3.55 lbs $7.95 $11.70 $-3.75
226383 2021-07-24 $70.99 Priority Mail 2-Day 3 1.95 lbs $13.90 $7.90 $6.00
226386 2021-07-24 $26.94 Priority Mail 2-Day Flat Rate Envelope 1 0.25 lbs $7.95 $8.25 $-0.30
226387 2021-07-24 $58.44 USPSFirstClass 3 1.50 lbs $16.50 $11.69 $4.81
226388 2021-07-24 $12.59 Priority Mail 2-Day 1 0.20 lbs $9.10 $7.90 $1.20
226389 2020-09-08 $1533.90 Priority Mail 2-Day 20 60.95 lbs $238.90 $113.62 $125.28
226392 2021-07-25 $20.27 USPSFirstClass 2 0.08 lbs $4.69 $3.35 $1.34
226393 2021-07-24 $14.24 Priority Mail 2-Day 1 0.18 lbs $8.25 $7.90 $0.35
226394 2021-07-24 $85.30 Priority Mail 3-Day Flat Rate Envelope 5 3.95 lbs $7.95 $18.50 $-10.55
226396 2021-07-24 $16.24 United States 1 0.30 lbs $4.25 $3.99 $0.26
226397 2021-07-25 $48.28 Priority Mail 2-Day 2 0.84 lbs $8.80 $10.44 $-1.64
226401 2021-07-25 $12.19 Priority Mail 2-Day 6 0.06 lbs $8.25 $7.40 $0.85
226402 2021-07-26 $7.39 USPSFirstClass 1 0.05 lbs $4.40 $3.22 $1.18
226403 2021-07-26 $66.24 USPSFirstClass 1 1.00 lbs $9.25 $8.24 $1.01
226404 2021-07-26 $88.93 Priority Mail 2-Day Small Flat Rate Box 2 17.90 lbs $8.45 $13.75 $-5.30
226406 2021-07-26 $88.41 Priority Mail 2-Day Small Flat Rate Box 8 21.20 lbs $8.45 $25.75 $-17.30
226407 2021-07-26 $16.24 Priority Mail 2-Day 1 0.34 lbs $8.25 $7.90 $0.35
226408 2021-07-26 $54.00 USPSFirstClass 2 0.30 lbs $6.10 $3.51 $2.59
226409 2021-07-26 $26.08 USPSFirstClass 1 0.15 lbs $5.29 $3.22 $2.07
226410 2021-07-26 $85.48 USPSPriority 3 3.30 lbs $24.61 $13.75 $10.86
226412 2021-07-26 $10.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.49 $0.31
226413 2021-07-26 $14.96 First-Class Package Service 2 0.34 lbs $5.48 $4.53 $0.95
226415 2021-07-26 $13.28 First-Class Package Service 3 0.27 lbs $4.71 $3.51 $1.20
226427 2021-07-27 $14.42 United States 3 0.09 lbs $3.95 $3.06 $0.89
226428 2021-07-28 $123.02 Priority Mail 2-Day 2 1.33 lbs $11.54 $8.00 $3.54
226429 2021-07-28 $49.47 Priority Mail 2-Day Flat Rate Envelope 3 0.77 lbs $8.50 $7.90 $0.60
226430 2021-07-28 $9.54 USPSFirstClass 1 0.20 lbs $4.55 $3.69 $0.86
226431 2021-07-28 $66.49 USPSFirstClass 1 1.00 lbs $9.50 $11.01 $-1.51
226433 2021-07-28 $100.62 Priority Mail 2-Day 1 4.65 lbs $10.63 $7.90 $2.73
226434 2021-07-28 $20.99 United States 1 0.95 lbs $8.50 $8.34 $0.16
226435 2021-07-29 $18.09 USPSFirstClass 1 0.05 lbs $5.10 $3.49 $1.61
226436 2021-07-29 $66.59 USPSFirstClass 1 1.00 lbs $9.60 $8.80 $0.80
226439 2021-07-29 $15.76 First-Class Package Service 2 0.20 lbs $4.78 $3.22 $1.56
226440 2021-07-29 $7.71 USPSFirstClass 1 0.07 lbs $4.32 $3.06 $1.26
226441 2021-07-29 $10.75 USPSFirstClass 1 0.05 lbs $4.46 $3.06 $1.40
226442 2021-07-29 $27.24 United States 1 0.90 lbs $5.75 $8.00 $-2.25
226443 2021-07-29 $21.48 United States 2 0.40 lbs $4.50 $3.85 $0.65
226444 2021-07-29 $36.15 USPSFirstClass 2 0.88 lbs $9.17 $8.85 $0.32
226446 2021-07-29 $41.85 First-Class Package Service 1 0.70 lbs $6.86 $5.66 $1.20
226448 2021-07-29 $111.49 Priority Mail 2-Day Flat Rate Envelope 1 3.90 lbs $8.50 $8.00 $0.50
226449 2021-07-29 $11.11 First-Class Package Service 1 0.03 lbs $4.32 $3.12 $1.20
226451 2021-07-29 $18.95 First-Class Mail Stamped Letter 5 0.17 lbs $4.00 $3.58 $0.42
226452 2021-07-29 $14.31 First-Class Package Service 1 0.13 lbs $4.32 $3.12 $1.20
226454 2021-07-29 $22.71 Priority Mail 2-Day 1 0.95 lbs $8.89 $7.16 $1.73
226455 2021-07-29 $11.69 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.22 $0.58
226459 2021-07-29 $49.14 United States 1 0.15 lbs $4.15 $3.49 $0.66
226461 2021-07-30 $109.48 United States 2 0.91 lbs $8.50 $8.00 $0.50
226462 2021-07-30 $9.39 USPSFirstClass 1 0.20 lbs $4.40 $3.51 $0.89
226463 2021-07-30 $23.21 USPSPriority 1 1.15 lbs $10.72 $7.90 $2.82
226464 2021-07-30 $79.81 Priority Mail 2-Day 1 2.52 lbs $9.82 $7.90 $1.92
226465 2021-07-30 $29.76 USPSFirstClass 3 0.60 lbs $6.09 $4.38 $1.71
226466 2021-07-30 $23.21 USPSPriority 1 1.15 lbs $10.72 $7.90 $2.82
226469 2021-07-30 $15.25 First-Class Package Service 3 0.22 lbs $4.78 $3.22 $1.56
226470 2021-07-31 $29.30 USPSFirstClass 1 0.15 lbs $5.35 $3.06 $2.29
226471 2021-07-31 $9.44 USPSFirstClass 1 0.06 lbs $4.45 $3.12 $1.33
226472 2021-07-31 $9.70 USPSFirstClass 1 0.06 lbs $4.51 $3.22 $1.29
226473 2021-07-31 $7.59 First-Class Mail Stamped Letter 1 0.02 lbs $3.60 $3.12 $0.48
226477 2021-07-31 $75.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.80 lbs $9.10 $8.00 $1.10
226479 2021-08-01 $20.30 USPSFirstClass 2 0.40 lbs $5.32 $3.58 $1.74
226481 2021-08-01 $22.44 Priority Mail 3-Day 1 0.95 lbs $9.95 $8.85 $1.10
226482 2021-08-01 $398.14 Ground 3 15.72 lbs $58.47 $33.89 $24.58
226483 2021-08-01 $8.87 USPSFirstClass 3 0.57 lbs $5.90 $3.35 $2.55
226488 2021-08-02 $40.98 Express Saver 2 0.43 lbs $25.50 $19.50 $6.00
226490 2021-08-02 $27.70 First-Class Package Service 1 0.35 lbs $4.71 $3.51 $1.20
226492 2021-08-02 $75.24 USPSFirstClass 1 1.00 lbs $12.25 $11.01 $1.24
226494 2021-08-02 $41.79 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $9.00 $7.90 $1.10
226496 2021-08-02 $6.48 First-Class Mail Stamped Letter 2 0.03 lbs $0.00 $3.35 $-3.35
226499 2021-08-02 $12.28 USPSFirstClass 3 0.57 lbs $5.71 $4.12 $1.59
226500 2021-08-02 $17.71 First-Class Package Service 2 0.20 lbs $4.53 $3.58 $0.95
226501 2021-08-02 $11.69 First-Class Mail Stamped Letter 1 0.06 lbs $3.80 $3.35 $0.45
226502 2021-08-02 $27.37 United States 3 0.35 lbs $4.50 $3.51 $0.99
226504 2021-08-02 $34.80 Priority Mail 2-Day 2 1.90 lbs $9.82 $8.24 $1.58
226505 2021-08-03 $14.34 USPSFirstClass 1 0.34 lbs $5.35 $3.51 $1.84
226506 2021-08-02 $28.29 Priority Mail 3-Day Flat Rate Envelope 1 0.80 lbs $8.50 $8.00 $0.50
226508 2021-08-02 $94.96 Priority Mail 2-Day Medium Flat Rate Box 3 3.75 lbs $15.40 $11.63 $3.77
226509 2021-08-02 $80.50 Priority Mail International 1 2.40 lbs $45.51 $49.16 $-3.65
226512 2021-08-03 $52.92 United States 8 3.51 lbs $11.50 $16.78 $-5.28
226513 2021-08-03 $5.58 First-Class Mail Stamped Letter 2 0.02 lbs $3.60 $3.12 $0.48
226514 2021-08-03 $18.73 USPSFirstClass 4 0.28 lbs $5.17 $3.58 $1.59
226515 2021-08-03 $8.64 USPSFirstClass 1 0.03 lbs $4.65 $3.49 $1.16
226516 2021-08-03 $9.35 USPSFirstClass 2 0.02 lbs $4.37 $3.22 $1.15
226517 2021-08-03 $50.73 2-Day 4 0.06 lbs $37.77 $26.30 $11.47
226518 2021-08-03 $197.38 Priority Mail 2-Day Medium Flat Rate Box 2 3.75 lbs $15.40 $10.89 $4.51
226520 2021-08-03 $48.51 United States 4 2.19 lbs $9.75 $8.00 $1.75
226521 2021-08-04 $9.65 USPSFirstClass 1 0.07 lbs $4.46 $3.12 $1.34
226522 2021-08-03 $18.89 Priority Mail 2-Day Small Flat Rate Box 1 0.05 lbs $9.00 $7.90 $1.10
226523 2021-08-03 $12.99 Priority Mail 2-Day Small Flat Rate Box 1 0.05 lbs $9.00 $7.40 $1.60
226524 2021-08-04 $52.60 Priority Mail 3-Day Small Flat Rate Box 2 1.40 lbs $9.00 $7.90 $1.10
226527 2021-08-04 $28.79 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $9.00 $7.90 $1.10
226529 2021-08-04 $18.22 First-Class Package Service 1 0.45 lbs $5.73 $4.53 $1.20
226531 2021-08-04 $38.11 First-Class Package Service 6 0.81 lbs $6.37 $5.42 $0.95
226537 2021-08-04 $3.99 Free Shipping 1 0.03 lbs $0.00 $3.49 $-3.49
226539 2021-08-05 $24.09 USPSFirstClass 1 0.25 lbs $5.10 $3.06 $2.04
226540 2021-08-04 $17.14 United States 1 0.25 lbs $4.25 $3.69 $0.56
226541 2021-08-04 $35.97 Free Shipping 3 0.66 lbs $0.00 $5.42 $-5.42
226542 2021-08-05 $27.16 USPSPriority 1 1.50 lbs $12.67 $10.44 $2.23
226543 2021-08-05 $56.99 Priority Mail 2-Day Small Flat Rate Box 1 1.45 lbs $9.00 $8.25 $0.75
226547 2021-08-05 $51.96 United States 3 2.58 lbs $9.00 $7.90 $1.10
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56