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
225495 2021-06-05 $20.97 USPSFirstClass 2 0.40 lbs $5.39 $4.38 $1.01
225497 2021-06-05 $29.27 Priority Mail 3-Day 1 1.10 lbs $12.11 $11.01 $1.10
225499 2021-06-05 $22.90 First-Class Package Service 2 0.50 lbs $5.32 $3.51 $1.81
225501 2021-06-05 $12.77 First-Class Mail Stamped Letter 3 0.10 lbs $3.80 $3.06 $0.74
225502 2021-06-05 $89.10 Priority Mail 2-Day 1 6.50 lbs $11.23 $9.52 $1.71
225503 2021-06-05 $10.29 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.49 $0.51
225504 2021-06-06 $14.09 First-Class Package Service 2 0.41 lbs $6.61 $3.22 $3.39
225505 2021-06-06 $26.53 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225507 2021-06-06 $16.66 First-Class Package Service 2 0.30 lbs $4.78 $3.58 $1.20
225508 2021-06-06 $73.94 USPSPriority 1 20.00 lbs $50.95 $36.31 $14.64
225509 2021-06-06 $12.43 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
225510 2021-06-06 $22.26 First-Class Package Service 3 0.23 lbs $4.78 $3.58 $1.20
225512 2021-06-06 $68.67 Priority Mail 2-Day 1 3.90 lbs $20.39 $19.29 $1.10
225513 2021-06-06 $23.11 Priority Mail 2-Day Flat Rate Envelope 9 0.98 lbs $8.50 $7.90 $0.60
225515 2021-06-06 $7.79 First-Class Mail Stamped Letter 1 0.03 lbs $3.80 $3.35 $0.45
225516 2021-06-06 $35.12 Priority Mail 2-Day 2 1.61 lbs $11.54 $12.70 $-1.16
225517 2021-06-06 $16.70 First-Class Package Service 1 0.25 lbs $4.71 $3.51 $1.20
225519 2021-06-06 $5.93 First-Class Mail Stamped Letter 2 0.02 lbs $3.60 $3.01 $0.59
225521 2021-06-06 $16.70 First-Class Package Service 1 0.30 lbs $4.71 $3.51 $1.20
225523 2021-06-06 $7.05 First-Class Mail Stamped Letter 5 0.05 lbs $3.60 $3.35 $0.25
225524 2021-06-06 $11.09 First-Class Mail Stamped Letter 1 0.06 lbs $3.80 $3.35 $0.45
225529 2021-06-07 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $9.00 $7.90 $1.10
225530 2021-06-07 $14.41 First-Class Package Service 1 0.13 lbs $4.42 $3.58 $0.84
225531 2021-06-07 $12.43 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
225532 2021-06-07 $57.88 Priority Mail 2-Day 1 2.54 lbs $13.80 $19.23 $-5.43
225534 2021-06-07 $78.55 Priority Mail 2-Day Medium Flat Rate Box 2 6.70 lbs $15.40 $10.89 $4.51
225535 2021-06-07 $8.64 USPSFirstClass 1 0.05 lbs $4.65 $3.49 $1.16
225536 2021-06-07 $7.06 USPSFirstClass 1 0.01 lbs $4.57 $3.49 $1.08
225537 2021-06-07 $40.96 Ground 1 0.40 lbs $24.97 $20.27 $4.70
225538 2021-06-07 $10.56 First-Class Mail Stamped Letter 4 0.08 lbs $3.80 $3.22 $0.58
225539 2021-06-07 $19.37 USPSFirstClass 3 0.15 lbs $4.40 $3.51 $0.89
225540 2020-10-16 $103.98 Ground 2 3.05 lbs $9.00 $8.00 $1.00
225541 2021-06-07 $16.63 USPSFirstClass 1 0.10 lbs $4.84 $3.22 $1.62
225542 2021-06-08 $10.54 USPSFirstClass 1 0.04 lbs $4.55 $3.22 $1.33
225546 2021-06-07 $31.35 Priority Mail 2-Day Flat Rate Envelope 2 0.96 lbs $8.50 $8.00 $0.50
225547 2021-06-07 $15.20 First-Class Package Service 1 0.30 lbs $4.89 $3.69 $1.20
225549 2021-06-08 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $9.00 $7.90 $1.10
225552 2021-06-08 $38.90 Priority Mail 3-Day 5 0.34 lbs $13.80 $10.89 $2.91
225553 2021-06-08 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225554 2021-06-08 $23.19 First-Class Package Service 1 0.25 lbs $5.05 $3.85 $1.20
225555 2021-06-08 $22.31 First-Class Package Service 2 0.47 lbs $5.32 $3.51 $1.81
225556 2021-06-08 $29.99 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225560 2021-06-08 $282.14 Ground 6 11.10 lbs $18.20 $21.44 $-3.24
225561 2020-11-24 $615.73 Priority Mail 1-Day 19 36.48 lbs $34.46 $28.96 $5.50
225564 2021-06-08 $43.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225565 2021-06-08 $27.25 First-Class Package Service 1 0.65 lbs $6.76 $4.53 $2.23
225567 2021-06-09 $7.06 USPSFirstClass 1 0.01 lbs $4.57 $3.49 $1.08
225568 2021-06-09 $6.76 USPSFirstClass 1 0.01 lbs $4.27 $3.06 $1.21
225569 2021-06-09 $16.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.12 $0.68
225577 2021-06-09 $58.83 Priority Mail 3-Day 3 1.77 lbs $13.80 $10.44 $3.36
225579 2021-06-09 $8.11 First-Class Package Service 1 0.05 lbs $4.32 $3.12 $1.20
225580 2021-06-09 $202.28 Priority Mail 2-Day 17 3.68 lbs $23.06 $18.50 $4.56
225581 2021-06-09 $7.08 First-Class Mail Stamped Letter 2 0.04 lbs $3.60 $3.12 $0.48
225586 2021-06-09 $36.70 First-Class Package Service 2 0.70 lbs $6.22 $4.12 $2.10
225587 2021-06-09 $41.99 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $9.00 $7.90 $1.10
225588 2020-09-14 $231.86 Priority Mail 2-Day 3 23.75 lbs $102.79 $78.46 $24.33
225590 2021-06-09 $10.12 First-Class Package Service 9 0.19 lbs $4.71 $3.06 $1.65
225596 2021-06-10 $10.41 First-Class Mail Stamped Letter 5 0.12 lbs $4.00 $3.58 $0.42
225597 2021-06-10 $13.02 First-Class Mail Stamped Letter 18 0.18 lbs $4.20 $3.22 $0.98
225599 2021-06-10 $10.77 First-Class Mail Stamped Letter 3 0.04 lbs $3.80 $3.35 $0.45
225600 2020-09-01 $130.16 Priority Mail 2-Day 4 4.30 lbs $7.50 $8.00 $-0.50
225601 2021-06-10 $16.55 First-Class Package Service 3 0.41 lbs $5.58 $3.58 $2.00
225602 2020-09-14 $353.19 Priority Mail 2-Day 5 14.82 lbs $41.07 $41.14 $-0.07
225603 2020-09-15 $71.18 Priority Mail 2-Day 2 2.00 lbs $8.00 $9.64 $-1.64
225604 2021-06-10 $7.09 First-Class Mail Stamped Letter 1 0.01 lbs $3.60 $3.49 $0.11
225605 2021-06-10 $43.24 Priority Mail 3-Day Flat Rate Envelope 3 1.30 lbs $8.50 $7.90 $0.60
225606 2021-06-10 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225607 2021-06-10 $58.69 Priority Mail 2-Day 4 3.22 lbs $11.53 $10.43 $1.10
225610 2021-06-10 $283.61 Priority Mail 2-Day 1 15.55 lbs $17.06 $15.47 $1.59
225611 2021-06-11 $16.77 First-Class Package Service 1 0.30 lbs $4.78 $3.58 $1.20
225612 2021-06-11 $9.81 USPSFirstClass 1 0.06 lbs $4.42 $3.06 $1.36
225613 2021-06-11 $10.11 USPSFirstClass 1 0.06 lbs $4.72 $3.49 $1.23
225614 2021-06-11 $14.28 First-Class Mail Stamped Letter 2 0.05 lbs $3.80 $3.49 $0.31
225616 2021-06-11 $16.07 First-Class Package Service 2 0.30 lbs $4.89 $3.69 $1.20
225617 2021-06-11 $66.40 Priority Mail 2-Day 5 1.20 lbs $9.34 $8.00 $1.34
225618 2020-10-31 $153.95 Priority Mail 2-Day Large Flat Rate Box 3 4.65 lbs $11.55 $12.13 $-0.58
225619 2020-11-12 $33.91 Priority Mail 3-Day 6 0.72 lbs $1.37 $7.90 $-6.53
225622 2020-11-20 $91.70 Priority Mail 2-Day 3 3.05 lbs $10.00 $16.78 $-6.78
225623 2020-12-01 $80.63 Priority Mail 2-Day 11 1.91 lbs $2.99 $8.00 $-5.01
225624 2020-12-03 $299.79 Priority Mail 3-Day 4 21.50 lbs $42.61 $36.00 $6.61
225625 2020-11-27 $127.43 Priority Mail 2-Day 5 4.15 lbs $10.24 $9.53 $0.71
225628 2020-12-06 $301.17 Ground 7 9.74 lbs $39.42 $32.13 $7.29
225629 2021-06-11 $18.64 First-Class Package Service 14 0.24 lbs $4.78 $3.58 $1.20
225630 2021-06-11 $71.49 Priority Mail 2-Day 4 3.20 lbs $11.53 $9.01 $2.52
225632 2021-06-11 $47.49 Priority Mail 2-Day Flat Rate Envelope 1 1.27 lbs $8.50 $8.00 $0.50
225633 2021-06-11 $21.31 First-Class Package Service 1 0.40 lbs $5.32 $4.12 $1.20
225634 2021-06-11 $57.22 Ground Home Delivery 2 0.70 lbs $26.74 $23.07 $3.67
225635 2021-06-11 $30.24 Priority Mail 3-Day 1 1.10 lbs $9.95 $8.00 $1.95
225637 2021-06-11 $28.49 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225638 2021-06-12 $13.98 First-Class Mail Stamped Letter 2 0.09 lbs $4.00 $3.22 $0.78
225639 2021-06-12 $12.59 USPSFirstClass 1 0.05 lbs $4.60 $3.12 $1.48
225640 2021-06-12 $9.55 USPSFirstClass 2 0.02 lbs $4.57 $3.49 $1.08
225641 2021-06-12 $114.19 Priority Mail International Small Flat Rate Box 1 2.15 lbs $29.20 $28.10 $1.10
225642 2021-01-19 $690.63 Ground 51 28.62 lbs $44.54 $26.06 $18.48
225643 2020-12-11 $196.82 Priority Mail 2-Day 2 13.35 lbs $17.02 $20.02 $-3.00
225647 2021-06-12 $27.58 First-Class Package International Service 1 0.07 lbs $21.59 $13.54 $8.05
225648 2021-06-12 $268.36 Ground 4 12.50 lbs $63.75 $36.65 $27.10
225649 2021-06-12 $32.03 Priority Mail 2-Day 2 1.45 lbs $17.55 $16.45 $1.10
225652 2021-06-12 $22.60 Priority Mail 2-Day 1 0.95 lbs $12.11 $11.01 $1.10
225653 2021-06-12 $12.59 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.12 $0.68
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56