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
221669 2021-02-06 $11.88 First-Class Package Service 1 0.05 lbs $3.99 $3.49 $0.50
221670 2021-02-06 $6.46 First-Class Package Service 5 0.40 lbs $4.01 $3.06 $0.95
221672 2021-02-07 $63.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 3.75 lbs $8.85 $8.00 $0.85
221673 2021-02-07 $31.27 USPSPriority 1 7.00 lbs $20.25 $16.18 $4.07
221674 2021-02-07 $34.98 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.75 $7.90 $0.85
221675 2021-02-07 $22.71 First-Class Package Service 3 0.56 lbs $4.88 $10.44 $-5.56
221678 2021-02-07 $15.09 USPSFirstClass 3 0.09 lbs $4.62 $3.49 $1.13
221679 2021-02-07 $53.24 Priority Mail 2-Day Flat Rate Envelope 1 1.89 lbs $8.25 $8.00 $0.25
221681 2021-02-07 $17.84 First-Class Package Service 1 0.16 lbs $3.85 $3.69 $0.16
221682 2021-02-07 $40.88 Priority Mail 3-Day 3 1.15 lbs $11.29 $10.44 $0.85
221684 2021-02-07 $53.70 Priority Mail 2-Day Flat Rate Envelope 2 1.36 lbs $8.25 $8.00 $0.25
221685 2021-02-07 $13.78 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.22 $0.18
221686 2021-02-07 $9.92 First-Class Package Service 1 0.45 lbs $5.03 $4.53 $0.50
221688 2021-02-07 $13.19 First-Class Mail Stamped Letter 1 0.07 lbs $3.20 $3.35 $-0.15
221689 2021-02-07 $67.78 Priority Mail 2-Day Medium Flat Rate Box 2 6.42 lbs $15.00 $9.01 $5.99
221690 2021-02-07 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.12 $0.08
221692 2021-02-07 $6.55 USPSFirstClass 1 0.19 lbs $4.36 $3.58 $0.78
221693 2021-02-07 $12.85 First-Class Mail Stamped Letter 5 0.09 lbs $3.40 $3.69 $-0.29
221694 2021-02-07 $11.05 First-Class Package Service 2 0.30 lbs $4.07 $3.57 $0.50
221695 2021-02-07 $16.44 First-Class Package Service 1 0.10 lbs $3.85 $3.35 $0.50
221697 2021-02-07 $7.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
221701 2021-02-07 $19.14 First-Class Package Service 2 0.08 lbs $3.56 $3.06 $0.50
221702 2021-02-07 $11.48 USPSFirstClass 1 0.20 lbs $4.59 $3.58 $1.01
221703 2021-02-07 $19.81 First-Class Package Service 3 0.41 lbs $4.78 $3.69 $1.09
221704 2021-02-07 $36.32 Priority Mail 3-Day Flat Rate Envelope 3 0.48 lbs $8.25 $7.90 $0.35
221705 2021-02-07 $7.78 USPSFirstClass 1 0.06 lbs $4.47 $3.35 $1.12
221706 2021-02-07 $53.79 USPSFirstClass 1 0.50 lbs $7.28 $4.20 $3.08
221709 2021-02-07 $6.49 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.49 $-0.49
221711 2021-02-07 $11.95 First-Class Package Service 2 0.24 lbs $4.07 $3.12 $0.95
221713 2021-02-07 $13.59 USPSFirstClass 1 0.05 lbs $4.60 $3.51 $1.09
221714 2021-02-07 $19.34 First-Class Package Service 1 0.28 lbs $4.35 $3.85 $0.50
221715 2021-02-07 $6.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
221718 2021-02-07 $6.88 First-Class Package Service 1 0.05 lbs $3.99 $3.49 $0.50
221719 2021-02-07 $7.48 USPSFirstClass 1 0.25 lbs $4.59 $3.85 $0.74
221721 2021-02-07 $9.86 USPSFirstClass 1 0.23 lbs $4.47 $3.12 $1.35
221722 2021-02-07 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
221723 2021-02-07 $6.63 First-Class Mail Stamped Letter 7 0.07 lbs $3.20 $3.22 $-0.02
221725 2021-02-07 $33.42 Priority Mail 3-Day 6 2.70 lbs $11.28 $13.75 $-2.47
221726 2021-02-07 $66.65 Priority Mail 2-Day Padded Flat Rate Envelope 20 1.00 lbs $8.85 $7.90 $0.95
221727 2021-02-07 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.22 $-0.02
221728 2021-02-07 $5.86 USPSFirstClass 1 0.03 lbs $4.37 $3.35 $1.02
221729 2021-02-07 $8.11 USPSFirstClass 1 0.03 lbs $4.62 $3.49 $1.13
221738 2021-02-07 $21.97 First-Class Package Service 2 0.20 lbs $4.19 $3.69 $0.50
221739 2021-02-07 $7.71 First-Class Package Service 1 0.03 lbs $3.72 $3.22 $0.50
221741 2021-02-08 $7.23 USPSFirstClass 1 0.05 lbs $4.34 $3.12 $1.22
221742 2021-02-07 $8.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
221743 2021-02-07 $16.04 Priority Mail 3-Day Flat Rate Envelope 1 0.04 lbs $8.25 $7.90 $0.35
221744 2021-02-07 $34.82 First-Class Package Service 5 0.23 lbs $4.07 $3.57 $0.50
221745 2021-02-07 $63.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 3.75 lbs $8.85 $8.00 $0.85
221746 2021-02-07 $51.74 Priority Mail 3-Day Small Flat Rate Box 1 1.45 lbs $8.75 $8.25 $0.50
221747 2021-02-08 $7.38 USPSFirstClass 1 0.07 lbs $4.59 $3.49 $1.10
221749 2021-02-07 $32.24 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.25 $8.00 $0.25
221751 2021-02-07 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.35 $-0.15
221752 2021-02-07 $84.99 Priority Mail 2-Day Medium Flat Rate Box 1 5.30 lbs $15.00 $13.75 $1.25
221753 2021-02-07 $20.94 Priority Mail 2-Day 3 2.00 lbs $9.57 $8.72 $0.85
221754 2021-02-07 $28.24 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.25 $8.00 $0.25
221755 2021-02-07 $19.43 First-Class Package Service 2 0.08 lbs $3.85 $3.35 $0.50
221757 2021-02-08 $48.63 Priority Mail 2-Day 2 0.56 lbs $9.65 $8.80 $0.85
221758 2021-02-08 $48.23 Priority Mail 2-Day Small Flat Rate Box 2 0.60 lbs $8.75 $7.90 $0.85
221759 2021-02-08 $17.32 First-Class Package Service 7 0.33 lbs $4.19 $3.69 $0.50
221760 2021-02-08 $4.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.22 $-0.22
221761 2021-02-08 $19.71 Priority Mail 2-Day 2 2.10 lbs $10.49 $7.90 $2.59
221764 2021-02-08 $13.74 USPSFirstClass 1 0.05 lbs $4.75 $3.69 $1.06
221765 2021-02-08 $28.38 Priority Mail 2-Day 1 0.74 lbs $9.09 $8.24 $0.85
221766 2021-02-08 $9.57 USPSFirstClass 1 0.25 lbs $4.55 $3.69 $0.86
221767 2021-02-08 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
221768 2021-02-08 $7.96 USPSFirstClass 1 0.03 lbs $4.47 $3.35 $1.12
221769 2021-02-08 $7.96 USPSFirstClass 1 0.03 lbs $4.47 $3.35 $1.12
221770 2021-02-08 $11.34 USPSFirstClass 1 0.06 lbs $4.35 $3.01 $1.34
221771 2021-02-08 $8.82 USPSFirstClass 1 0.05 lbs $4.42 $3.12 $1.30
221772 2021-02-08 $80.74 Priority Mail 3-Day Small Flat Rate Box 3 2.14 lbs $8.75 $8.00 $0.75
221773 2021-02-08 $7.28 USPSFirstClass 1 0.05 lbs $4.39 $3.22 $1.17
221774 2021-02-08 $20.55 USPSPriority 1 0.06 lbs $9.65 $7.90 $1.75
221775 2021-02-08 $19.00 First-Class Package Service 1 0.35 lbs $4.01 $3.51 $0.50
221777 2021-02-08 $32.86 First-Class Package Service 2 0.48 lbs $4.88 $4.38 $0.50
221778 2021-02-08 $4.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.35 $-0.35
221780 2021-02-08 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.35 $-0.15
221781 2021-02-08 $25.39 First-Class Package Service 2 0.39 lbs $4.70 $4.20 $0.50
221783 2021-02-08 $35.59 First-Class Mail Stamped Letter 1 0.17 lbs $3.60 $3.51 $0.09
221786 2021-02-08 $11.14 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.25 $3.35 $4.90
221787 2021-02-08 $36.89 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
221790 2021-02-08 $60.02 Priority Mail 2-Day Flat Rate Envelope 3 1.90 lbs $8.25 $8.00 $0.25
221791 2021-02-08 $14.97 First-Class Package Service 8 6.41 lbs $5.18 $8.00 $-2.82
221792 2021-02-08 $19.74 Priority Mail 2-Day Small Flat Rate Box 1 0.05 lbs $8.75 $7.90 $0.85
221793 2021-02-08 $39.64 Priority Mail 2-Day 2 2.65 lbs $10.49 $9.01 $1.48
221796 2021-02-08 $22.73 Priority Mail 3-Day Small Flat Rate Box 2 0.34 lbs $8.75 $7.90 $0.85
221797 2021-02-08 $12.09 First-Class Package Service 2 0.20 lbs $4.01 $3.06 $0.95
221798 2021-02-08 $9.30 First-Class Mail Stamped Letter 1 0.06 lbs $3.20 $3.12 $0.08
221800 2021-02-08 $67.83 Priority Mail 3-Day Flat Rate Envelope 2 2.35 lbs $8.25 $8.00 $0.25
221803 2021-02-08 $16.16 Priority Mail 3-Day 3 0.20 lbs $9.19 $8.34 $0.85
221804 2021-02-08 $17.14 First-Class Package Service 1 0.20 lbs $4.35 $3.85 $0.50
221805 2021-02-08 $17.55 First-Class Package Service 1 0.28 lbs $4.37 $3.51 $0.86
221806 2021-02-08 $141.47 Priority Mail 2-Day 33 11.60 lbs $28.23 $19.30 $8.93
221807 2021-02-08 $40.50 Priority Mail 2-Day 5 2.67 lbs $13.55 $10.89 $2.66
221811 2021-02-09 $15.60 USPSFirstClass 1 0.06 lbs $4.70 $3.06 $1.64
221812 2021-02-09 $19.12 USPSFirstClass 2 0.90 lbs $9.34 $7.90 $1.44
221813 2021-02-09 $9.28 USPSFirstClass 1 0.05 lbs $4.39 $3.06 $1.33
221814 2021-02-09 $28.54 USPSFirstClass 1 0.15 lbs $5.60 $3.49 $2.11
221815 2021-02-09 $24.17 USPSFirstClass 2 0.12 lbs $4.69 $3.12 $1.57
221816 2021-02-09 $26.55 USPSFirstClass 2 0.12 lbs $4.75 $3.12 $1.63
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56