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
223601 2021-03-23 $16.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
223606 2021-03-24 $492.51 Priority Mail International 127 31.10 lbs $177.62 $155.56 $22.06
223607 2021-03-24 $9.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
223608 2021-03-24 $15.87 First-Class Package Service 1 0.30 lbs $4.08 $3.58 $0.50
223611 2021-03-24 $25.55 First-Class Package Service 1 0.65 lbs $6.06 $4.53 $1.53
223612 2021-03-24 $19.25 USPSFirstClass 2 0.90 lbs $6.27 $11.69 $-5.42
223613 2021-03-24 $48.32 FedExHomeDelivery 1 7.50 lbs $15.88 $15.95 $-0.07
223616 2021-03-24 $9.73 First-Class Mail Stamped Letter 4 0.20 lbs $3.20 $3.01 $0.19
223620 2021-03-24 $8.39 USPSFirstClass 1 0.04 lbs $4.40 $3.12 $1.28
223626 2021-03-24 $72.37 Priority Mail 2-Day 1 4.39 lbs $10.38 $8.00 $2.38
223627 2021-03-24 $46.34 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.35 lbs $8.85 $8.00 $0.85
223629 2021-03-18 $99.95 Priority Mail 3-Day 20 4.95 lbs $20.24 $21.48 $-1.24
223631 2021-03-24 $11.27 USPSFirstClass 1 0.05 lbs $4.49 $3.51 $0.98
223632 2021-03-24 $57.99 Priority Mail 3-Day Medium Flat Rate Box 1 2.20 lbs $15.00 $12.64 $2.36
223634 2021-03-24 $29.93 Priority Mail 3-Day Padded Flat Rate Envelope 2 6.00 lbs $8.85 $8.00 $0.85
223635 2021-03-18 $8.29 Priority Mail 2-Day Medium Flat Rate Box 1 0.06 lbs $1.00 $3.49 $-2.49
223636 2021-03-24 $34.32 First-Class Mail Stamped Letter 1 0.13 lbs $3.40 $3.57 $-0.17
223637 2021-03-24 $22.89 First-Class Mail Stamped Letter 1 0.18 lbs $3.60 $3.85 $-0.25
223641 2021-03-24 $44.27 First-Class Package Service 4 0.72 lbs $6.31 $5.81 $0.50
223643 2021-03-25 $5.29 USPSFirstClass 1 0.03 lbs $4.30 $3.58 $0.72
223644 2021-03-25 $38.80 UPSGround 1 0.69 lbs $13.81 $12.53 $1.28
223646 2021-03-25 $39.90 USPSFirstClass 10 1.50 lbs $20.00 $16.45 $3.55
223647 2021-03-25 $73.40 Priority Mail 2-Day Medium Flat Rate Box 2 4.32 lbs $15.00 $11.42 $3.58
223648 2021-03-25 $16.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
223649 2021-03-25 $12.75 First-Class Package Service 1 0.25 lbs $4.08 $4.38 $-0.30
223650 2021-03-25 $13.94 First-Class Package Service 3 0.19 lbs $4.01 $3.06 $0.95
223651 2021-03-25 $21.12 First-Class Mail Stamped Letter 8 0.06 lbs $3.20 $3.06 $0.14
223654 2021-03-25 $9.44 USPSFirstClass 1 0.05 lbs $4.45 $3.12 $1.33
223656 2021-03-25 $28.24 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.25 $8.00 $0.25
223658 2021-03-26 $7.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.00 $3.22 $-0.22
223659 2021-03-26 $36.19 USPSPriority 1 1.70 lbs $16.20 $12.13 $4.07
223660 2021-03-26 $7.34 USPSFirstClass 1 0.10 lbs $4.35 $3.12 $1.23
223661 2021-03-26 $9.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
223662 2021-03-26 $74.58 Priority Mail 2-Day 10 2.76 lbs $11.28 $9.01 $2.27
223663 2021-03-26 $7.59 USPSFirstClass 1 0.10 lbs $4.60 $3.49 $1.11
223664 2021-03-26 $19.36 USPSFirstClass 3 0.09 lbs $4.69 $3.49 $1.20
223665 2021-03-26 $9.57 First-Class Mail Stamped Letter 3 0.18 lbs $3.60 $3.22 $0.38
223666 2021-03-26 $65.83 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.70 lbs $8.85 $7.90 $0.95
223667 2021-03-26 $13.32 First-Class Package Service 3 0.30 lbs $4.35 $3.49 $0.86
223668 2021-03-26 $53.92 Priority Mail 2-Day Padded Flat Rate Envelope 2 0.18 lbs $8.85 $7.90 $0.95
223669 2021-03-27 $41.11 Priority Mail 2-Day 5 0.62 lbs $8.52 $7.90 $0.62
223670 2021-03-27 $35.27 First-Class Package Service 1 0.13 lbs $4.35 $3.85 $0.50
223671 2021-03-27 $28.86 Priority Mail 2-Day 1 0.80 lbs $9.37 $8.52 $0.85
223672 2021-03-27 $11.99 USPSFirstClass 1 0.08 lbs $4.52 $3.51 $1.01
223674 2021-03-27 $9.49 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
223675 2021-03-27 $98.98 Priority Mail 2-Day Medium Flat Rate Box 2 17.88 lbs $15.00 $13.75 $1.25
223677 2021-03-27 $8.88 First-Class Mail Stamped Letter 2 0.11 lbs $3.40 $3.49 $-0.09
223678 2021-03-27 $10.59 First-Class Mail Stamped Letter 1 0.17 lbs $3.60 $3.22 $0.38
223679 2021-03-27 $25.55 First-Class Package Service 1 0.65 lbs $6.06 $9.06 $-3.00
223680 2021-03-27 $23.06 First-Class Package Service 2 0.36 lbs $4.08 $3.58 $0.50
223681 2021-03-27 $16.53 First-Class Mail Stamped Letter 1 0.12 lbs $3.40 $3.22 $0.18
223682 2021-03-27 $9.14 First-Class Mail Stamped Letter 6 0.06 lbs $3.20 $3.12 $0.08
223684 2021-03-27 $18.21 First-Class Package Service - Retail 9 0.09 lbs $5.30 $3.49 $1.81
223685 2021-03-28 $12.09 USPSFirstClass 1 0.08 lbs $4.62 $3.58 $1.04
223686 2021-03-27 $9.18 First-Class Mail Stamped Letter 2 0.07 lbs $3.20 $3.35 $-0.15
223687 2021-03-27 $17.52 Priority Mail 2-Day 1 0.05 lbs $8.73 $7.90 $0.83
223688 2021-03-27 $70.43 Ground 2 18.45 lbs $26.98 $25.44 $1.54
223691 2021-03-27 $16.84 First-Class Package Service 1 0.05 lbs $3.85 $3.35 $0.50
223692 2021-03-27 $25.01 First-Class Package Service 1 0.80 lbs $5.52 $5.27 $0.25
223693 2021-03-27 $52.34 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.38 lbs $8.85 $8.00 $0.85
223694 2021-03-28 $25.53 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.25 $8.00 $0.25
223695 2021-03-28 $20.21 First-Class Package Service 1 0.25 lbs $4.07 $3.57 $0.50
223696 2021-03-28 $7.34 USPSFirstClass 1 0.10 lbs $4.35 $3.12 $1.23
223697 2021-03-28 $10.49 USPSFirstClass 1 0.04 lbs $4.50 $3.12 $1.38
223698 2021-03-28 $335.31 Ground 6 21.57 lbs $59.12 $35.92 $23.20
223699 2021-03-28 $14.02 First-Class Package Service 1 0.40 lbs $5.03 $4.53 $0.50
223703 2021-03-28 $7.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.69 $-0.49
223705 2021-03-28 $18.93 Priority Mail 3-Day Small Flat Rate Box 2 0.10 lbs $8.75 $7.90 $0.85
223707 2021-03-28 $6.29 USPSFirstClass 1 0.03 lbs $4.30 $3.12 $1.18
223708 2021-03-28 $9.30 First-Class Package Service 1 0.31 lbs $4.01 $4.12 $-0.11
223709 2021-03-29 $25.29 USPSFirstClass 1 0.25 lbs $5.30 $3.69 $1.61
223710 2021-03-28 $53.39 Priority Mail 2-Day 15 1.15 lbs $12.54 $11.69 $0.85
223711 2021-03-28 $21.72 Priority Mail 3-Day 1 0.05 lbs $8.73 $7.90 $0.83
223712 2021-03-28 $29.16 First-Class Package Service 2 0.53 lbs $5.18 $4.68 $0.50
223713 2021-03-28 $29.30 First-Class Package Service 5 0.38 lbs $4.35 $4.68 $-0.33
223714 2021-03-28 $69.61 Priority Mail 2-Day 20 3.57 lbs $22.81 $21.96 $0.85
223716 2021-03-29 $10.18 First-Class Package Service 1 0.20 lbs $4.19 $3.35 $0.84
223717 2021-03-29 $79.20 Ground 25 4.95 lbs $25.35 $27.35 $-2.00
223721 2021-03-29 $8.05 USPSFirstClass 1 0.05 lbs $4.34 $3.06 $1.28
223722 2021-03-29 $8.35 USPSFirstClass 1 0.03 lbs $4.64 $3.49 $1.15
223723 2021-03-29 $10.32 USPSFirstClass 3 0.07 lbs $4.35 $3.22 $1.13
223724 2021-03-29 $21.33 Priority Mail 3-Day Small Flat Rate Box 2 0.18 lbs $8.75 $7.90 $0.85
223725 2021-03-29 $8.64 USPSFirstClass 1 0.03 lbs $4.65 $3.49 $1.16
223726 2021-03-29 $34.23 First-Class Mail Stamped Letter 2 0.12 lbs $3.40 $3.49 $-0.09
223728 2021-03-29 $12.92 First-Class Mail Stamped Letter 3 0.10 lbs $3.20 $3.01 $0.19
223729 2021-03-29 $32.57 First-Class Package Service 5 0.44 lbs $4.62 $4.12 $0.50
223732 2021-03-29 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.75 $8.10 $0.65
223734 2021-03-29 $90.78 Priority Mail 2-Day 17 2.40 lbs $14.95 $11.63 $3.32
223735 2021-03-29 $11.51 First-Class Package Service 1 0.06 lbs $3.72 $3.22 $0.50
223736 2021-03-29 $10.32 First-Class Package Service 3 0.22 lbs $4.35 $3.85 $0.50
223738 2021-03-29 $54.44 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $8.75 $7.90 $0.85
223739 2021-03-29 $47.85 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.30 lbs $8.85 $7.90 $0.95
223740 2021-03-29 $38.64 Priority Mail 3-Day 1 3.15 lbs $10.06 $8.34 $1.72
223742 2021-03-30 $49.14 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $8.75 $7.90 $0.85
223744 2021-03-30 $49.14 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $8.75 $7.90 $0.85
223746 2021-03-30 $49.14 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $8.75 $7.90 $0.85
223747 2021-03-30 $15.86 First-Class Package Service 1 0.30 lbs $4.07 $3.57 $0.50
223748 2021-03-30 $16.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
223752 2021-03-30 $68.13 Priority Mail 1-Day 2 5.71 lbs $9.58 $8.73 $0.85
223753 2021-03-30 $49.63 Priority Mail 3-Day 3 2.40 lbs $9.57 $9.21 $0.36
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56