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
219683 2021-01-04 $18.11 USPSFirstClass 1 0.25 lbs $4.72 $3.52 $1.20
219684 2021-01-04 $9.82 USPSFirstClass 1 0.13 lbs $4.23 $2.84 $1.39
219685 2021-01-03 $60.03 Priority Mail International Small Flat Rate Box 2 0.90 lbs $38.45 $37.60 $0.85
219686 2021-01-04 $12.13 USPSFirstClass 1 0.06 lbs $4.34 $2.84 $1.50
219687 2021-01-04 $31.25 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.65 lbs $8.60 $7.75 $0.85
219690 2021-01-04 $47.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.75 $0.85
219691 2021-01-04 $6.30 USPSFirstClass 1 0.19 lbs $4.11 $3.39 $0.72
219692 2021-01-04 $17.21 First-Class Package Service 5 0.30 lbs $3.76 $3.31 $0.45
219693 2021-01-04 $28.67 FedExHomeDelivery 1 0.29 lbs $16.96 $22.21 $-5.25
219694 2021-01-04 $64.29 USPSPriority 1 1.25 lbs $10.92 $7.65 $3.27
219695 2021-01-04 $8.82 First-Class Package Service 1 0.10 lbs $3.63 $3.18 $0.45
219696 2021-01-04 $7.71 USPSFirstClass 1 0.02 lbs $4.22 $3.05 $1.17
219697 2021-01-04 $56.25 First-Class Package Service 12 0.42 lbs $4.77 $4.32 $0.45
219698 2021-01-04 $20.80 USPSFirstClass 1 0.06 lbs $4.80 $2.93 $1.87
219700 2021-01-04 $20.75 USPSFirstClass 1 0.06 lbs $4.75 $2.84 $1.91
219701 2021-01-04 $31.99 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.00 $8.00 $0.00
219702 2021-01-04 $9.12 First-Class Mail Stamped Letter 1 0.06 lbs $3.10 $2.74 $0.36
219703 2021-01-04 $16.13 USPSFirstClass 1 0.45 lbs $5.34 $4.18 $1.16
219704 2021-01-04 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.05 $0.05
219705 2021-01-04 $10.75 USPSFirstClass 2 0.12 lbs $4.21 $3.05 $1.16
219706 2021-01-04 $39.77 Priority Mail 2-Day Flat Rate Envelope 3 1.11 lbs $8.00 $8.00 $0.00
219708 2021-01-04 $48.34 First-Class Package Service 3 0.68 lbs $5.37 $5.12 $0.25
219709 2021-01-04 $86.58 Priority Mail 3-Day 2 2.35 lbs $13.00 $12.32 $0.68
219710 2021-01-04 $47.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.75 $0.85
219712 2021-01-04 $14.97 Priority Mail 3-Day Flat Rate Envelope 3 0.21 lbs $8.00 $7.65 $0.35
219713 2021-01-04 $9.47 First-Class Package Service 3 0.14 lbs $3.50 $3.05 $0.45
219715 2021-01-04 $20.17 USPSFirstClass 2 0.12 lbs $4.59 $3.18 $1.41
219716 2021-01-04 $144.46 Priority Mail 2-Day Small Flat Rate Box 4 8.25 lbs $8.50 $7.65 $0.85
219717 2021-01-04 $11.54 USPSFirstClass 1 0.06 lbs $4.55 $3.18 $1.37
219718 2021-01-04 $47.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.75 $0.85
219719 2021-01-04 $47.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.75 $0.85
219720 2021-01-04 $38.25 USPSFirstClass 1 0.45 lbs $6.49 $4.32 $2.17
219721 2021-01-04 $20.70 USPSFirstClass 1 0.06 lbs $4.70 $2.78 $1.92
219723 2021-01-04 $17.32 First-Class Mail Stamped Letter 8 0.16 lbs $3.40 $3.18 $0.22
219726 2021-01-04 $67.58 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.00 lbs $8.60 $7.75 $0.85
219727 2021-01-04 $17.59 USPSFirstClass 1 0.05 lbs $4.60 $2.84 $1.76
219728 2021-01-04 $16.37 USPSFirstClass 4 0.76 lbs $7.61 $7.64 $-0.03
219732 2021-01-04 $37.59 Priority Mail 2-Day 10 2.50 lbs $8.69 $7.84 $0.85
219734 2021-01-04 $52.00 Priority Mail 2-Day 4 1.40 lbs $12.04 $12.10 $-0.06
219736 2021-01-04 $20.80 USPSFirstClass 1 0.06 lbs $4.80 $2.93 $1.87
219738 2021-01-04 $60.39 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.12 lbs $8.60 $7.65 $0.95
219739 2021-01-05 $7.57 USPSFirstClass 1 0.05 lbs $3.98 $2.74 $1.24
219740 2021-01-05 $18.26 USPSFirstClass 1 0.25 lbs $4.87 $3.67 $1.20
219741 2021-01-05 $29.76 USPSFirstClass 2 0.58 lbs $6.34 $5.70 $0.64
219742 2021-01-04 $7.04 First-Class Mail Stamped Letter 6 0.06 lbs $3.10 $2.93 $0.17
219743 2021-01-05 $9.76 USPSFirstClass 1 0.06 lbs $4.27 $2.93 $1.34
219744 2021-01-04 $14.62 First-Class Package Service 1 0.02 lbs $3.63 $3.18 $0.45
219745 2021-01-05 $18.01 USPSFirstClass 1 0.25 lbs $4.62 $3.31 $1.31
219748 2021-01-04 $76.25 3 Day Select 1 1.44 lbs $37.26 $29.45 $7.81
219750 2021-01-04 $16.24 Priority Mail 2-Day Medium Flat Rate Box 1 0.35 lbs $4.45 $3.85 $0.60
219752 2021-01-05 $10.23 USPSFirstClass 1 0.05 lbs $4.34 $3.05 $1.29
219753 2021-01-04 $111.06 Priority Mail 2-Day 3 6.39 lbs $10.59 $8.21 $2.38
219754 2021-01-05 $67.79 USPSPriority 1 1.25 lbs $14.42 $7.75 $6.67
219756 2021-01-05 $9.14 USPSFirstClass 1 0.03 lbs $4.15 $2.78 $1.37
219757 2021-01-04 $63.35 Direct Link International 3 0.59 lbs $22.78 $15.94 $6.84
219758 2021-01-05 $12.23 USPSFirstClass 1 0.06 lbs $4.44 $3.05 $1.39
219759 2021-01-05 $59.24 USPSFirstClass 4 1.80 lbs $16.08 $7.75 $8.33
219761 2021-01-05 $108.30 Priority Mail 3-Day Padded Flat Rate Envelope 3 3.74 lbs $8.60 $7.75 $0.85
219762 2021-01-05 $24.02 USPSFirstClass 2 0.12 lbs $4.54 $3.05 $1.49
219764 2021-01-05 $134.43 Priority Mail 2-Day Medium Flat Rate Box 2 8.78 lbs $14.45 $10.53 $3.92
219766 2021-01-05 $9.24 USPSFirstClass 1 0.03 lbs $4.25 $2.93 $1.32
219767 2021-01-05 $85.80 USPSFirstClass 20 3.90 lbs $44.00 $14.16 $29.84
219768 2021-01-05 $11.87 USPSFirstClass 3 0.57 lbs $5.60 $4.18 $1.42
219769 2021-01-05 $11.99 Priority Mail 2-Day Flat Rate Envelope 1 0.04 lbs $8.00 $7.65 $0.35
219771 2021-01-05 $8.14 USPSFirstClass 1 0.06 lbs $4.15 $2.84 $1.31
219772 2021-01-05 $38.58 Priority Mail 3-Day Flat Rate Envelope 2 1.32 lbs $8.00 $7.65 $0.35
219773 2021-01-05 $67.79 USPSPriority 1 1.38 lbs $14.42 $7.65 $6.77
219774 2021-01-05 $9.81 USPSFirstClass 1 0.06 lbs $4.32 $3.05 $1.27
219775 2021-01-05 $253.83 Priority Mail 2-Day 1 13.20 lbs $43.84 $47.29 $-3.45
219776 2021-01-05 $56.73 Priority Mail 2-Day 6 3.00 lbs $18.99 $18.14 $0.85
219778 2021-01-05 $75.85 Priority Mail 2-Day 1 3.95 lbs $21.86 $21.96 $-0.10
219779 2021-01-05 $9.66 USPSFirstClass 1 0.06 lbs $4.17 $2.78 $1.39
219780 2021-01-05 $16.03 USPSFirstClass 1 0.45 lbs $5.24 $4.00 $1.24
219782 2021-01-05 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
219783 2021-01-05 $232.29 Ground 1 14.05 lbs $39.30 $26.11 $13.19
219784 2021-01-05 $10.03 USPSFirstClass 1 0.23 lbs $4.24 $3.31 $0.93
219785 2021-01-05 $8.19 USPSFirstClass 1 0.05 lbs $4.20 $2.93 $1.27
219786 2021-01-05 $11.21 First-Class Package Service 2 0.14 lbs $3.23 $2.78 $0.45
219787 2021-01-05 $58.02 Ground 1 1.30 lbs $25.23 $21.52 $3.71
219788 2021-01-05 $52.67 Priority Mail 2-Day 2 1.60 lbs $10.39 $8.76 $1.63
219789 2021-01-05 $77.80 InternationalPriorityShipping 5 3.04 lbs $29.20 $16.06 $13.14
219791 2021-01-05 $4.94 USPSFirstClass 1 0.03 lbs $3.95 $2.78 $1.17
219793 2021-01-05 $65.94 USPSPriority 1 1.25 lbs $12.57 $7.65 $4.92
219794 2021-01-05 $32.16 USPSPriority 1 1.00 lbs $8.67 $7.02 $1.65
219795 2021-01-05 $10.54 First-Class Package Service 2 0.38 lbs $3.76 $2.84 $0.92
219796 2021-01-05 $19.22 First-Class Package Service 3 0.42 lbs $4.25 $3.25 $1.00
219798 2021-01-05 $7.99 USPSFirstClass 1 0.08 lbs $4.00 $2.74 $1.26
219799 2021-01-05 $63.19 USPSPriority 1 5.15 lbs $15.20 $16.89 $-1.69
219800 2021-01-05 $9.29 USPSFirstClass 1 0.06 lbs $4.30 $3.05 $1.25
219801 2021-01-05 $35.10 First-Class Package Service 3 0.41 lbs $4.63 $4.18 $0.45
219802 2021-01-05 $11.50 USPSFirstClass 1 0.50 lbs $5.21 $3.52 $1.69
219803 2021-01-05 $9.65 USPSFirstClass 1 0.06 lbs $4.32 $3.05 $1.27
219804 2021-01-05 $8.29 First-Class Mail Stamped Letter 1 0.07 lbs $3.10 $2.84 $0.26
219805 2021-01-05 $41.29 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.50 $7.65 $0.85
219806 2021-01-05 $6.94 First-Class Mail Stamped Letter 1 0.04 lbs $2.95 $3.18 $-0.23
219807 2021-01-05 $63.52 Ground 24 1.54 lbs $20.86 $17.13 $3.73
219808 2021-01-05 $29.85 First-Class Package Service 2 0.70 lbs $5.57 $5.27 $0.30
219809 2021-01-05 $43.49 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
219810 2021-01-05 $37.95 Priority Mail 2-Day Flat Rate Envelope 5 1.52 lbs $8.00 $8.00 $0.00
219811 2021-01-05 $87.92 Priority Mail 3-Day 2 2.35 lbs $14.34 $12.32 $2.02
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56