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
220638 2021-01-19 $21.21 USPSFirstClass 1 0.04 lbs $4.72 $2.78 $1.94
220639 2021-01-19 $21.21 USPSFirstClass 1 0.04 lbs $4.72 $2.78 $1.94
220640 2021-01-19 $19.58 First-Class Package Service 12 0.22 lbs $3.70 $3.06 $0.64
220641 2021-01-19 $31.60 Priority Mail 3-Day 4 0.35 lbs $10.84 $9.99 $0.85
220642 2021-01-19 $49.47 Priority Mail 2-Day 4 2.22 lbs $16.91 $16.78 $0.13
220643 2021-01-19 $70.39 Priority Mail 2-Day Medium Flat Rate Box 6 1.85 lbs $14.45 $13.75 $0.70
220645 2021-01-19 $53.02 Priority Mail 2-Day Flat Rate Envelope 5 1.40 lbs $8.00 $7.40 $0.60
220646 2021-01-19 $53.84 USPSFirstClass 1 0.50 lbs $7.33 $4.46 $2.87
220647 2021-01-19 $15.49 First-Class Package Service 1 0.30 lbs $3.70 $3.51 $0.19
220648 2021-01-20 $9.33 USPSFirstClass 1 0.03 lbs $4.44 $3.18 $1.26
220649 2021-01-20 $6.24 USPSFirstClass 1 0.20 lbs $4.15 $3.52 $0.63
220650 2021-01-20 $20.10 USPSFirstClass 5 0.10 lbs $5.15 $3.18 $1.97
220651 2021-01-20 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
220652 2021-01-19 $39.77 Priority Mail 3-Day Flat Rate Envelope 3 1.11 lbs $8.00 $8.00 $0.00
220653 2021-01-19 $34.67 Priority Mail 3-Day 1 1.20 lbs $9.61 $7.65 $1.96
220654 2021-01-19 $11.07 First-Class Mail Stamped Letter 3 0.05 lbs $3.10 $3.22 $-0.12
220656 2021-01-20 $10.79 USPSFirstClass 2 0.12 lbs $4.17 $2.93 $1.24
220657 2021-01-20 $14.44 USPSFirstClass 1 0.50 lbs $5.45 $5.70 $-0.25
220658 2021-01-19 $31.35 Priority Mail 3-Day 6 0.75 lbs $11.39 $10.54 $0.85
220659 2021-01-19 $19.91 First-Class Package Service 2 0.36 lbs $4.33 $3.57 $0.76
220660 2021-01-19 $12.14 First-Class Package Service 3 0.23 lbs $3.77 $3.69 $0.08
220661 2021-01-20 $20.02 USPSFirstClass 2 0.12 lbs $4.44 $3.05 $1.39
220662 2021-01-20 $77.11 USPSPriority 1 1.31 lbs $14.05 $7.65 $6.40
220663 2021-01-19 $7.87 First-Class Package Service 1 0.05 lbs $3.38 $3.22 $0.16
220664 2021-01-20 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
220666 2021-01-19 $62.62 Ground 1 1.55 lbs $19.63 $17.41 $2.22
220667 2021-01-20 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
220668 2021-01-20 $20.02 USPSFirstClass 2 0.12 lbs $4.44 $3.05 $1.39
220670 2021-01-19 $9.89 First-Class Mail Stamped Letter 1 0.03 lbs $3.10 $3.22 $-0.12
220671 2021-01-20 $40.83 USPSFirstClass 2 0.30 lbs $4.85 $3.31 $1.54
220672 2021-01-19 $15.91 First-Class Package Service 1 0.30 lbs $4.12 $3.85 $0.27
220674 2021-01-19 $27.03 First-Class Package Service 2 0.74 lbs $5.85 $5.66 $0.19
220675 2021-01-20 $18.06 USPSFirstClass 4 0.80 lbs $9.70 $5.70 $4.00
220677 2021-01-20 $8.29 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.12 $-0.02
220678 2021-01-20 $46.86 USPSFirstClass 10 2.50 lbs $22.96 $11.13 $11.83
220679 2021-01-20 $23.09 USPSFirstClass 1 0.15 lbs $5.10 $3.67 $1.43
220681 2021-01-20 $40.76 Ground 2 2.10 lbs $20.52 $16.82 $3.70
220682 2021-01-20 $25.50 USPSFirstClass 10 0.30 lbs $5.60 $3.39 $2.21
220683 2021-01-20 $7.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.06 $0.04
220684 2021-01-20 $22.49 First-Class Package Service 1 0.35 lbs $3.50 $4.12 $-0.62
220686 2021-01-20 $19.26 Priority Mail 2-Day 1 0.95 lbs $8.97 $8.24 $0.73
220687 2021-01-20 $23.77 USPSFirstClass 2 0.12 lbs $4.29 $2.74 $1.55
220688 2021-01-20 $7.66 USPSFirstClass 1 0.02 lbs $4.17 $2.93 $1.24
220690 2021-01-20 $56.76 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.60 lbs $8.60 $8.00 $0.60
220691 2021-01-20 $30.89 USPSPriority 1 1.70 lbs $10.90 $8.21 $2.69
220692 2021-01-20 $7.86 USPSFirstClass 1 0.04 lbs $4.37 $3.18 $1.19
220693 2021-01-20 $50.96 Priority Mail 2-Day Padded Flat Rate Envelope 4 1.48 lbs $8.60 $8.00 $0.60
220694 2021-01-20 $15.77 USPSFirstClass 2 0.80 lbs $8.19 $8.12 $0.07
220695 2021-01-20 $94.58 Priority Mail 3-Day Padded Flat Rate Envelope 2 5.91 lbs $8.60 $7.75 $0.85
220696 2021-01-20 $53.54 USPSFirstClass 1 0.50 lbs $7.03 $4.00 $3.03
220698 2021-01-20 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.50 $15.80 $-7.30
220699 2021-01-20 $32.90 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.18 lbs $8.60 $7.75 $0.85
220700 2021-01-20 $22.75 First-Class Package Service 2 0.20 lbs $3.97 $3.69 $0.28
220704 2021-01-20 $7.28 First-Class Package Service 1 0.08 lbs $3.29 $3.12 $0.17
220705 2021-01-20 $8.88 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.35 $-0.25
220707 2021-01-20 $57.21 Priority Mail 2-Day 10 6.08 lbs $21.31 $21.48 $-0.17
220708 2021-01-20 $61.58 Priority Mail 2-Day Flat Rate Envelope 2 1.77 lbs $8.00 $8.00 $0.00
220709 2021-01-20 $9.38 First-Class Package Service - Retail 2 0.04 lbs $4.90 $3.35 $1.55
220711 2021-01-20 $6.08 First-Class Mail Stamped Letter 2 0.06 lbs $3.10 $3.12 $-0.02
220712 2021-01-20 $6.88 USPSFirstClass 1 0.07 lbs $4.09 $2.84 $1.25
220713 2021-01-20 $103.82 Priority Mail 2-Day Medium Flat Rate Box 3 3.70 lbs $14.45 $11.42 $3.03
220714 2021-01-20 $70.97 Priority Mail 2-Day 5 0.87 lbs $11.39 $11.01 $0.38
220715 2021-01-20 $37.06 Priority Mail 3-Day Padded Flat Rate Envelope 4 0.90 lbs $8.60 $7.90 $0.70
220716 2021-01-20 $6.94 First-Class Mail Stamped Letter 1 0.04 lbs $2.95 $3.35 $-0.40
220717 2021-01-20 $9.35 First-Class Package Service 3 0.09 lbs $3.38 $3.22 $0.16
220718 2020-11-24 $4.08 Priority Mail 2-Day Flat Rate Envelope 1 0.03 lbs $0.90 $2.74 $-1.84
220721 2021-01-20 $93.30 Priority Mail 3-Day Flat Rate Envelope 2 2.30 lbs $8.00 $9.93 $-1.93
220722 2021-01-20 $84.29 First-Class Package International Service 5 2.00 lbs $39.34 $31.83 $7.51
220723 2021-01-20 $17.98 USPSFirstClass 1 0.17 lbs $4.67 $2.93 $1.74
220724 2021-01-20 $14.88 USPSFirstClass 2 0.12 lbs $4.22 $2.84 $1.38
220725 2021-01-20 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.50 $7.90 $0.60
220727 2021-01-20 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
220728 2021-01-20 $9.22 First-Class Package Service 1 0.02 lbs $3.23 $3.06 $0.17
220729 2021-01-21 $22.85 USPSFirstClass 5 0.95 lbs $12.40 $5.27 $7.13
220730 2021-01-21 $11.57 USPSFirstClass 3 0.57 lbs $5.60 $2.93 $2.67
220731 2021-01-21 $12.08 USPSFirstClass 2 0.12 lbs $4.10 $3.25 $0.85
220732 2021-01-20 $40.97 Priority Mail 2-Day Flat Rate Envelope 3 1.05 lbs $8.00 $8.00 $0.00
220733 2021-01-20 $65.06 Priority Mail 3-Day 5 1.85 lbs $12.11 $7.40 $4.71
220734 2021-01-21 $10.66 USPSFirstClass 1 0.34 lbs $5.17 $3.52 $1.65
220735 2021-01-20 $27.55 First-Class Package Service 2 0.70 lbs $5.57 $5.27 $0.30
220736 2021-01-20 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.90 $0.60
220737 2021-01-21 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.18 $1.41
220738 2021-01-21 $22.94 USPSFirstClass 1 0.15 lbs $4.95 $3.05 $1.90
220739 2021-01-20 $12.83 First-Class Package Service 2 0.10 lbs $3.29 $3.12 $0.17
220740 2021-01-21 $57.68 USPSFirstClass 7 0.47 lbs $29.75 $4.32 $25.43
220742 2021-01-20 $32.90 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.18 lbs $8.60 $7.75 $0.85
220743 2021-01-20 $87.58 Priority Mail 3-Day Padded Flat Rate Envelope 2 5.30 lbs $8.60 $7.90 $0.70
220744 2021-01-21 $9.32 USPSFirstClass 1 0.23 lbs $4.30 $3.05 $1.25
220745 2021-01-20 $36.98 First-Class Package Service 5 0.41 lbs $4.53 $4.20 $0.33
220746 2021-01-20 $16.04 First-Class Package Service 1 0.40 lbs $4.25 $4.12 $0.13
220747 2021-01-21 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
220748 2021-01-21 $14.28 USPSFirstClass 1 0.06 lbs $4.54 $3.05 $1.49
220752 2021-01-21 $14.11 USPSFirstClass 3 0.75 lbs $5.44 $5.04 $0.40
220753 2021-01-21 $17.30 USPSFirstClass 1 0.19 lbs $4.44 $2.74 $1.70
220755 2021-01-21 $19.90 Priority Mail 2-Day 1 0.95 lbs $9.61 $8.85 $0.76
220757 2021-01-21 $54.19 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $8.50 $7.90 $0.60
220758 2021-01-21 $63.79 Priority Mail 2-Day 5 1.85 lbs $10.84 $8.00 $2.84
220759 2021-01-21 $126.20 Priority Mail 3-Day 6 6.63 lbs $12.34 $9.74 $2.60
220760 2021-01-21 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.90 $0.60
220761 2021-01-21 $76.42 Priority Mail 2-Day Medium Flat Rate Box 3 8.72 lbs $14.45 $11.42 $3.03
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56