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.

21025 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
216857 2020-10-23 $54.17 Priority Mail Express International 3 0.15 lbs $43.70 $42.85 $0.85
216858 2020-10-08 $18.29 Priority Mail 2-Day Large Flat Rate Box 1 0.30 lbs $0.00 $3.67 $-3.67
216863 2020-10-23 $630.45 Priority Mail 2-Day 8 59.60 lbs $73.33 $77.08 $-3.75
216864 2020-10-23 $55.02 USPSFirstClass 7 0.53 lbs $8.31 $7.96 $0.35
216865 2020-10-23 $38.69 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.90 $8.05 $0.85
216867 2020-10-23 $32.80 Priority Mail 2-Day 1 0.95 lbs $10.01 $9.32 $0.69
216868 2020-10-23 $14.29 First-Class Package Service 1 0.35 lbs $4.50 $3.64 $0.86
216870 2020-10-23 $37.19 Priority Mail 3-Day Flat Rate Envelope 1 1.05 lbs $8.40 $8.05 $0.35
216871 2020-10-23 $35.36 Priority Mail 2-Day Flat Rate Envelope 4 0.10 lbs $8.40 $8.05 $0.35
216872 2020-10-23 $89.37 Priority Mail 3-Day Flat Rate Envelope 3 1.35 lbs $8.40 $8.05 $0.35
216873 2020-10-24 $70.09 USPSPriority 2 7.10 lbs $18.30 $8.61 $9.69
216874 2020-10-24 $12.71 USPSFirstClass 1 0.30 lbs $5.24 $3.77 $1.47
216875 2020-10-24 $11.96 USPSFirstClass 1 0.19 lbs $4.35 $3.18 $1.17
216876 2020-10-24 $48.14 USPSFirstClass 7 0.62 lbs $18.31 $4.71 $13.60
216879 2020-10-24 $6.08 First-Class Package Service 1 0.19 lbs $4.09 $3.18 $0.91
216882 2020-10-24 $17.17 First-Class Package Service 3 0.65 lbs $6.20 $4.68 $1.52
216884 2020-10-24 $19.58 First-Class Package Service 3 0.23 lbs $4.01 $3.56 $0.45
216885 2020-10-24 $44.26 First-Class Package Service 2 0.60 lbs $4.78 $5.52 $-0.74
216886 2020-10-24 $10.09 USPSFirstClass 1 0.05 lbs $4.31 $3.30 $1.01
216888 2020-10-24 $9.04 USPSFirstClass 1 0.05 lbs $4.25 $3.30 $0.95
216889 2020-10-24 $35.13 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.90 $8.05 $0.85
216890 2020-10-24 $37.19 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.40 $7.90 $0.50
216891 2020-10-24 $48.40 Priority Mail 3-Day Flat Rate Envelope 2 1.55 lbs $8.40 $8.05 $0.35
216892 2020-10-24 $25.71 First-Class Package Service 1 0.35 lbs $4.22 $3.77 $0.45
216893 2020-10-24 $11.31 First-Class Mail Stamped Letter 4 0.08 lbs $3.35 $3.18 $0.17
216896 2020-10-24 $14.89 Priority Mail 2-Day Small Flat Rate Box 1 0.19 lbs $8.90 $8.05 $0.85
216897 2020-10-24 $4.97 First-Class Package Service 1 0.20 lbs $4.96 $3.92 $1.04
216898 2020-10-24 $16.79 Priority Mail 3-Day Small Flat Rate Box 1 0.20 lbs $8.90 $8.05 $0.85
216899 2020-10-25 $12.86 USPSFirstClass 1 0.20 lbs $4.39 $3.64 $0.75
216900 2020-10-25 $29.56 USPSFirstClass 2 0.10 lbs $9.00 $3.30 $5.70
216902 2020-10-24 $9.38 First-Class Mail Stamped Letter 2 0.09 lbs $3.50 $3.18 $0.32
216903 2020-10-25 $9.03 USPSFirstClass 1 0.40 lbs $4.89 $4.25 $0.64
216904 2020-10-24 $70.39 Priority Mail 2-Day Flat Rate Envelope 1 3.06 lbs $8.40 $8.15 $0.25
216905 2020-10-25 $17.37 USPSFirstClass 3 0.30 lbs $4.80 $5.29 $-0.49
216906 2020-10-25 $21.42 First-Class Mail Stamped Letter 8 0.06 lbs $3.50 $3.09 $0.41
216910 2020-10-25 $44.00 Priority Mail 3-Day 1 1.40 lbs $10.01 $9.16 $0.85
216912 2020-10-25 $37.69 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $8.90 $8.05 $0.85
216913 2020-10-25 $21.53 Priority Mail 3-Day 1 0.95 lbs $11.24 $7.98 $3.26
216914 2020-10-25 $14.27 USPSFirstClass 1 0.05 lbs $4.45 $3.64 $0.81
216915 2020-10-25 $48.97 Priority Mail 2-Day Flat Rate Envelope 3 1.75 lbs $8.40 $8.05 $0.35
216916 2020-10-25 $12.78 USPSFirstClass 1 0.20 lbs $4.34 $3.56 $0.78
216917 2020-10-25 $15.74 First-Class Package Service 1 0.30 lbs $3.95 $3.50 $0.45
216918 2020-10-25 $19.29 First-Class Mail Stamped Letter 6 0.04 lbs $3.35 $3.30 $0.05
216919 2020-10-25 $8.58 USPSFirstClass 1 0.08 lbs $4.25 $3.30 $0.95
216921 2020-10-25 $14.20 USPSFirstClass 1 0.05 lbs $4.65 $3.92 $0.73
216922 2020-10-25 $22.44 USPSFirstClass 2 0.40 lbs $5.19 $4.43 $0.76
216924 2020-10-25 $38.69 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.90 $8.05 $0.85
216925 2020-10-25 $9.88 USPSFirstClass 1 0.10 lbs $4.20 $3.09 $1.11
216926 2020-10-25 $15.74 First-Class Package Service 1 0.30 lbs $3.95 $3.50 $0.45
216927 2020-10-25 $4.84 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.43 $-0.08
216928 2020-10-26 $14.02 USPSFirstClass 2 0.20 lbs $4.44 $3.92 $0.52
216929 2020-10-25 $126.40 Priority Mail 3-Day 1 1.90 lbs $10.79 $9.32 $1.47
216930 2020-10-25 $26.79 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.40 $8.15 $0.25
216931 2020-10-25 $54.71 Priority Mail International Small Flat Rate Box 4 0.54 lbs $27.35 $26.50 $0.85
216933 2020-10-25 $45.72 Priority Mail 2-Day 2 0.66 lbs $12.44 $8.82 $3.62
216934 2020-10-25 $28.58 Priority Mail 3-Day Small Flat Rate Box 2 0.42 lbs $8.90 $8.05 $0.85
216935 2020-10-25 $207.77 Priority Mail 3-Day Large Flat Rate Box 12 16.48 lbs $51.85 $30.28 $21.57
216936 2020-10-25 $38.69 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.90 $8.05 $0.85
216937 2020-10-26 $10.28 USPSFirstClass 1 0.25 lbs $4.49 $3.92 $0.57
216944 2020-10-26 $72.47 Ground 2 1.70 lbs $18.19 $15.69 $2.50
216946 2020-10-26 $6.34 First-Class Mail Stamped Letter 1 0.04 lbs $3.35 $3.30 $0.05
216947 2020-10-26 $12.89 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $3.30 $0.20
216949 2020-10-26 $50.59 Priority Mail 2-Day Padded Flat Rate Envelope 4 1.48 lbs $9.00 $7.75 $1.25
216950 2020-10-26 $6.83 First-Class Mail Stamped Letter 2 0.05 lbs $3.35 $3.30 $0.05
216951 2020-10-26 $42.18 First-Class Package Service 12 0.46 lbs $4.70 $3.50 $1.20
216953 2020-10-26 $5.34 First-Class Mail Stamped Letter 1 0.03 lbs $3.35 $3.01 $0.34
216955 2020-10-26 $49.68 Priority Mail 3-Day Flat Rate Envelope 2 2.40 lbs $8.40 $8.15 $0.25
216956 2020-10-26 $10.33 First-Class Mail Stamped Letter 2 0.10 lbs $3.35 $3.03 $0.32
216957 2020-10-26 $13.09 USPSFirstClass 1 0.20 lbs $4.44 $3.77 $0.67
216958 2020-10-26 $83.90 Priority Mail 3-Day 2 2.80 lbs $10.32 $9.47 $0.85
216961 2020-10-26 $35.96 Priority Mail 3-Day 5 1.07 lbs $10.01 $9.16 $0.85
216962 2020-10-26 $38.69 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.90 $8.05 $0.85
216963 2020-10-26 $11.75 USPSFirstClass 1 0.39 lbs $5.04 $3.56 $1.48
216964 2020-10-26 $285.27 Priority Mail 2-Day 1 14.40 lbs $31.28 $33.86 $-2.58
216965 2020-10-26 $8.08 USPSFirstClass 1 0.03 lbs $4.37 $3.43 $0.94
216966 2020-10-26 $35.13 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.90 $8.05 $0.85
216967 2020-10-26 $8.18 First-Class Mail Stamped Letter 2 0.02 lbs $3.20 $3.09 $0.11
216968 2020-10-26 $9.01 USPSFirstClass 1 0.04 lbs $4.20 $3.18 $1.02
216969 2020-10-26 $15.21 First-Class Package Service - Retail 4 0.12 lbs $7.25 $3.77 $3.48
216970 2020-10-26 $7.66 USPSFirstClass 1 0.03 lbs $4.17 $3.18 $0.99
216971 2020-10-26 $17.61 First-Class Mail Stamped Letter 4 0.20 lbs $3.65 $3.03 $0.62
216972 2020-10-26 $16.67 USPSFirstClass 2 0.20 lbs $4.33 $3.77 $0.56
216973 2020-10-26 $28.46 Priority Mail 2-Day Small Flat Rate Box 4 1.80 lbs $8.90 $8.05 $0.85
216974 2020-07-07 $25.82 Priority Mail 1-Day 1 0.50 lbs $3.00 $5.29 $-2.29
216975 2020-10-26 $4.84 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.03 $0.32
216976 2020-10-27 $23.57 InternationalPriorityShipping 1 0.04 lbs $4.35 $3.30 $1.05
216977 2020-10-26 $4.84 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.18 $0.17
216980 2020-10-26 $58.87 First-Class Package Service 3 0.65 lbs $6.40 $5.95 $0.45
216981 2020-10-27 $20.08 USPSFirstClass 2 0.40 lbs $5.14 $5.65 $-0.51
216982 2020-10-27 $13.92 USPSFirstClass 2 0.10 lbs $4.14 $3.03 $1.11
216983 2020-10-26 $8.69 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $3.43 $0.07
216984 2020-10-26 $20.94 First-Class Package Service 2 0.38 lbs $5.16 $4.71 $0.45
216985 2020-10-27 $6.16 USPSFirstClass 1 0.03 lbs $4.00 $3.03 $0.97
216988 2020-10-26 $36.89 First-Class Package Service 1 0.50 lbs $4.70 $4.25 $0.45
216990 2020-10-26 $4.19 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $3.18 $0.02
216991 2020-10-26 $50.59 Priority Mail 2-Day 5 1.44 lbs $8.89 $8.04 $0.85
216992 2020-10-27 $7.83 USPSFirstClass 1 0.03 lbs $4.12 $3.09 $1.03
216993 2020-10-27 $46.93 Priority Mail 3-Day Medium Flat Rate Box 12 2.22 lbs $14.85 $13.60 $1.25
216995 2020-10-27 $49.43 Priority Mail 2-Day 1 1.85 lbs $14.74 $11.53 $3.21
216997 2020-10-27 $41.79 Priority Mail 3-Day 2 3.25 lbs $10.32 $8.15 $2.17
Total 21025 order(s) 59971 29292.14 lbs $193562.51 $270247.54 $-76685.03