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
230442 2022-11-11 $37.15 Priority Mail 1 1.25 lbs $9.84 $8.10 $1.74
230444 2022-11-11 $49.53 Priority Mail 1 1.30 lbs $9.84 $8.10 $1.74
230448 2022-11-11 $7.31 First-Class Package Service 1 0.01 lbs $4.87 $3.67 $1.20
230450 2022-11-12 $16.92 USPS Shipping 1 0.79 lbs $7.93 $4.67 $3.26
230451 2022-11-12 $13.19 USPS First Class 1 0.04 lbs $5.30 $3.88 $1.42
230452 2022-11-12 $97.64 Priority Mail 3 6.75 lbs $12.17 $8.30 $3.87
230454 2022-11-14 $12.23 First-Class Package Service 2 0.15 lbs $5.50 $4.26 $1.24
230455 2022-11-13 $13.49 USPS First Class 1 0.06 lbs $5.60 $4.26 $1.34
230456 2022-11-14 $29.92 USPS Shipping 1 0.90 lbs $7.93 $6.36 $1.57
230457 2022-11-14 $21.47 First-Class Package Service 3 0.17 lbs $5.75 $4.26 $1.49
230458 2022-11-14 $21.96 Ground 1 0.17 lbs $18.42 $8.30 $10.12
230463 2022-11-16 $8.34 USPS First Class 1 0.05 lbs $4.95 $3.67 $1.28
230464 2022-11-16 $16.92 USPS Shipping 1 0.79 lbs $7.93 $5.23 $2.70
230466 2022-11-16 $12.84 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230467 2022-11-16 $48.57 Priority Mail Flat Rate Envelope 6 2.01 lbs $9.60 $8.30 $1.30
230468 2022-11-16 $14.97 First-Class Package Service 1 0.30 lbs $5.48 $4.28 $1.20
230470 2022-11-18 $71.62 USPS Shipping 1 0.75 lbs $6.63 $6.68 $-0.05
230471 2022-11-18 $26.09 USPS First Class 1 0.35 lbs $6.10 $5.38 $0.72
230473 2022-11-18 $11.24 Priority Mail Flat Rate Envelope 1 1.00 lbs $9.60 $7.60 $2.00
230474 2022-11-19 $11.95 First-Class Package Service 1 0.15 lbs $4.87 $3.67 $1.20
230475 2022-11-18 $12.84 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230476 2022-11-18 $8.59 USPS First Class 1 0.06 lbs $5.30 $3.88 $1.42
230478 2022-11-19 $10.27 First-Class Package Service 1 0.04 lbs $4.87 $3.67 $1.20
230481 2022-11-20 $7.51 First-Class Package Service 1 0.10 lbs $4.87 $3.67 $1.20
230482 2022-11-21 $193.75 Priority Mail Medium Flat Rate Box 1 12.88 lbs $16.65 $14.00 $2.65
230483 2022-11-20 $36.09 USPS Priority Mail 1 1.50 lbs $17.10 $13.46 $3.64
230484 2022-11-20 $12.84 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230485 2022-11-21 $14.18 USPS Shipping 1 0.06 lbs $5.23 $3.98 $1.25
230486 2022-11-21 $10.50 USPS Shipping 1 0.20 lbs $5.51 $4.06 $1.45
230487 2022-11-21 $54.59 Priority Mail Small Flat Rate Box 1 1.50 lbs $10.10 $8.10 $2.00
230491 2022-11-21 $18.54 First-Class Package Service 1 0.20 lbs $5.48 $4.28 $1.20
230494 2022-11-21 $18.14 First-Class Package Service 4 0.06 lbs $5.18 $3.98 $1.20
230495 2022-11-21 $29.52 USPS First-Class Mail or Priority Mail 1 1.30 lbs $-16.99 $8.30 $-25.29
230496 2022-11-21 $232.37 First-Class Package International Service 53 3.01 lbs $73.54 $66.39 $7.15
230497 2022-11-22 $13.44 First-Class Package Service 2 0.12 lbs $5.46 $4.26 $1.20
230498 2022-11-22 $58.36 Priority Mail 6 0.98 lbs $20.85 $9.94 $10.91
230502 2022-11-22 $9.72 First-Class Package Service 1 0.03 lbs $5.08 $3.88 $1.20
230504 2022-11-23 $12.76 First-Class Package Service 2 0.40 lbs $6.03 $4.28 $1.75
230505 2022-11-23 $9.89 USPS First Class 1 0.06 lbs $5.40 $4.12 $1.28
230506 2022-11-23 $9.24 USPS First Class 1 0.05 lbs $4.95 $3.67 $1.28
230507 2022-11-23 $21.42 USPS First-Class Mail or Priority Mail 1 0.08 lbs $5.51 $3.88 $1.63
230509 2022-11-23 $43.69 Priority Mail 1 1.25 lbs $9.84 $8.10 $1.74
230510 2022-11-23 $27.65 Priority Mail 1 1.10 lbs $9.84 $8.64 $1.20
230516 2022-11-24 $39.88 Priority Mail Flat Rate Envelope 2 1.30 lbs $9.60 $8.10 $1.50
230517 2022-11-23 $13.19 USPS First Class 1 0.06 lbs $5.30 $3.88 $1.42
230518 2022-11-24 $106.27 Ground Home Delivery 1 8.55 lbs $32.02 $25.81 $6.21
230520 2022-11-25 $17.23 First-Class Package Service 2 0.20 lbs $5.24 $3.64 $1.60
230521 2022-11-26 $48.92 Priority Mail 1 1.30 lbs $12.86 $9.94 $2.92
230522 2022-11-26 $20.80 USPS First Class 1 0.05 lbs $5.30 $3.88 $1.42
230524 2022-11-27 $13.10 First-Class Package Service 3 0.34 lbs $5.48 $4.28 $1.20
230525 2022-11-27 $9.66 USPS First-Class Mail or Priority Mail 1 0.05 lbs $10.23 $3.67 $6.56
230526 2022-11-27 $33.79 First-Class Package Service 1 0.50 lbs $5.87 $4.06 $1.81
230527 2022-11-27 $10.38 First-Class Package Service 2 0.04 lbs $5.75 $4.55 $1.20
230528 2022-11-28 $21.61 First-Class Package Service 1 0.60 lbs $6.18 $6.51 $-0.33
230529 2022-11-28 $13.30 USPS Shipping 1 0.12 lbs $5.51 $4.55 $0.96
230530 2022-11-28 $24.79 USPS Shipping 1 0.35 lbs $5.80 $4.90 $0.90
230531 2022-11-28 $19.00 USPS Shipping 1 0.12 lbs $5.51 $3.98 $1.53
230532 2022-11-28 $10.50 USPS Shipping 1 0.01 lbs $5.51 $4.26 $1.25
230535 2022-11-28 $15.34 USPS First Class 1 0.05 lbs $5.35 $3.98 $1.37
230536 2022-11-29 $17.74 First-Class Package Service 1 0.24 lbs $5.75 $4.55 $1.20
230537 2022-11-29 $12.59 First-Class Package Service 2 0.07 lbs $5.46 $4.26 $1.20
230538 2022-11-29 $31.92 Priority Mail 1 0.95 lbs $13.52 $9.96 $3.56
230539 2022-11-29 $13.79 First-Class Package Service 3 0.10 lbs $4.82 $3.62 $1.20
230540 2022-11-30 $43.35 Priority Mail Small Flat Rate Box 1 1.20 lbs $10.10 $8.10 $2.00
230543 2022-11-30 $68.64 USPS Priority Mail 1 1.20 lbs $13.65 $8.30 $5.35
230549 2022-11-30 $18.18 USPS First Class 2 0.08 lbs $11.20 $4.26 $6.94
230550 2022-11-30 $12.85 First-Class Package Service 2 0.16 lbs $4.87 $4.06 $0.81
230551 2022-11-30 $11.08 First-Class Package Service 1 0.07 lbs $5.18 $3.98 $1.20
230552 2022-11-30 $47.96 Priority Mail Medium Flat Rate Box 2 1.95 lbs $16.65 $14.00 $2.65
230555 2022-12-01 $9.40 USPS Shipping 1 0.03 lbs $5.23 $3.98 $1.25
230556 2022-12-01 $10.50 USPS Shipping 1 0.20 lbs $5.51 $4.06 $1.45
230557 2022-12-01 $18.58 First-Class Package Service 1 0.29 lbs $5.59 $4.39 $1.20
230560 2022-12-02 $18.46 First-Class Package Service 1 0.22 lbs $5.47 $4.27 $1.20
230561 2022-12-03 $7.46 First-Class Package Service 1 0.01 lbs $5.32 $4.12 $1.20
230562 2022-12-03 $9.32 First-Class Package Service 1 0.04 lbs $5.18 $3.98 $1.20
230563 2022-12-03 $20.68 First-Class Package Service 1 0.30 lbs $5.59 $4.39 $1.20
230565 2022-12-04 $15.37 First-Class Package Service 1 0.10 lbs $5.08 $3.88 $1.20
230566 2022-12-04 $8.66 First-Class Package Service 2 0.02 lbs $5.08 $3.88 $1.20
230567 2022-12-05 $20.30 USPS Shipping 2 0.12 lbs $11.02 $4.55 $6.47
230569 2022-12-05 $19.24 First-Class Package Service 2 0.20 lbs $5.26 $3.67 $1.59
230570 2022-12-05 $14.07 USPS First-Class Mail or Priority Mail 1 0.27 lbs $5.80 $5.38 $0.42
230574 2022-12-05 $18.58 First-Class Package Service 1 0.22 lbs $5.59 $4.12 $1.47
230579 2022-12-07 $13.45 First-Class Package Service 2 0.02 lbs $5.32 $4.12 $1.20
230581 2022-12-06 $15.34 USPS First Class 1 0.05 lbs $5.35 $3.98 $1.37
230582 2022-12-07 $15.03 USPS Shipping 1 0.07 lbs $3.58 $3.98 $-0.40
230583 2022-12-07 $14.04 USPS Shipping 1 0.06 lbs $5.23 $4.26 $0.97
230584 2022-12-07 $13.30 USPS Shipping 1 0.12 lbs $5.51 $3.67 $1.84
230585 2022-12-07 $10.71 First-Class Package Service 1 0.18 lbs $5.47 $3.88 $1.59
230587 2022-12-07 $9.84 First-Class Package Service 3 0.03 lbs $5.32 $4.12 $1.20
230589 2022-12-07 $24.40 First-Class Package Service 2 0.03 lbs $5.32 $4.12 $1.20
230590 2022-12-07 $10.34 USPS First Class 1 0.04 lbs $5.35 $3.98 $1.37
230591 2022-12-07 $18.79 USPS First Class 1 0.62 lbs $6.20 $5.82 $0.38
230592 2022-12-07 $54.04 Priority Mail Medium Flat Rate Box 3 1.91 lbs $16.65 $8.30 $8.35
230594 2022-12-07 $14.39 USPS First Class 1 0.15 lbs $5.60 $4.26 $1.34
230595 2022-12-08 $29.50 USPS First-Class Mail or Priority Mail 1 1.30 lbs $13.76 $8.30 $5.46
230596 2022-12-08 $13.30 USPS Shipping 1 0.12 lbs $5.51 $3.98 $1.53
230597 2022-12-08 $15.57 First-Class Package Service 1 0.30 lbs $5.26 $4.06 $1.20
230598 2022-12-08 $29.50 USPS First-Class Mail or Priority Mail 1 1.30 lbs $13.76 $8.30 $5.46
230599 2022-12-08 $16.39 First-Class Package Service 1 0.25 lbs $5.48 $4.28 $1.20
230600 2022-12-08 $45.89 Priority Mail Small Flat Rate Box 1 1.25 lbs $10.10 $8.10 $2.00
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56