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
220912 2021-01-24 $28.24 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.25 $8.00 $0.25
220913 2021-01-24 $16.24 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.25 $7.90 $0.35
220914 2021-01-24 $5.99 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.12 $-0.12
220915 2021-01-24 $52.70 First-Class Package Service 2 0.08 lbs $3.62 $3.12 $0.50
220916 2021-01-24 $10.96 USPSFirstClass 1 0.30 lbs $5.47 $3.85 $1.62
220917 2021-01-24 $5.97 First-Class Mail Stamped Letter 3 0.03 lbs $3.00 $3.06 $-0.06
220919 2021-01-24 $9.41 First-Class Package Service 2 0.15 lbs $3.83 $3.58 $0.25
220920 2021-01-24 $9.58 USPSFirstClass 1 0.05 lbs $4.69 $3.49 $1.20
220922 2021-01-24 $32.62 Priority Mail 2-Day Flat Rate Envelope 3 0.84 lbs $8.25 $7.90 $0.35
220923 2021-01-24 $113.22 Priority Mail 3-Day 4 0.85 lbs $11.86 $11.01 $0.85
220925 2021-01-24 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
220930 2021-01-24 $192.46 Priority Mail Express International 13 6.29 lbs $91.29 $70.11 $21.18
220935 2021-01-24 $47.68 Priority Mail 2-Day 18 3.60 lbs $10.06 $9.21 $0.85
220936 2021-01-24 $10.18 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.12 $0.08
220937 2021-01-24 $76.80 Priority Mail 2-Day 1 3.95 lbs $22.81 $21.96 $0.85
220938 2021-01-24 $8.39 USPSFirstClass 1 0.06 lbs $4.40 $3.12 $1.28
220939 2021-01-24 $32.53 Priority Mail 2-Day 1 1.10 lbs $12.54 $23.38 $-10.84
220940 2021-01-24 $38.68 First-Class Package Service 4 0.32 lbs $3.96 $3.46 $0.50
220942 2021-01-24 $49.11 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.31 lbs $8.85 $8.00 $0.85
220943 2021-01-24 $19.66 USPSFirstClass 1 0.04 lbs $5.17 $3.49 $1.68
220944 2021-01-24 $7.11 First-Class Package Service 1 0.03 lbs $3.62 $3.12 $0.50
220945 2021-01-24 $43.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.12 lbs $8.85 $8.00 $0.85
220946 2021-01-24 $15.69 First-Class Package Service 3 0.07 lbs $3.72 $3.22 $0.50
220948 2021-01-24 $67.83 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.00 lbs $8.85 $7.90 $0.95
220949 2021-01-24 $13.34 First-Class Package Service 1 0.30 lbs $4.07 $3.57 $0.50
220950 2021-01-24 $23.41 USPSFirstClass 3 0.81 lbs $9.04 $10.44 $-1.40
220951 2021-01-25 $8.39 USPSFirstClass 1 0.06 lbs $4.40 $3.12 $1.28
220952 2021-01-25 $14.30 USPSFirstClass 3 0.19 lbs $4.37 $3.12 $1.25
220953 2021-01-25 $8.39 USPSFirstClass 1 0.06 lbs $4.40 $3.12 $1.28
220954 2021-01-25 $9.75 USPSFirstClass 1 0.07 lbs $4.56 $3.35 $1.21
220956 2021-01-25 $19.60 USPSFirstClass 1 0.95 lbs $9.31 $10.44 $-1.13
220958 2021-01-25 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.12 $0.08
220959 2021-01-25 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
220960 2021-01-25 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
220963 2021-01-25 $102.92 Priority Mail 2-Day Flat Rate Envelope 3 2.30 lbs $8.25 $8.00 $0.25
220965 2021-01-25 $19.82 USPSFirstClass 2 0.60 lbs $6.04 $10.89 $-4.85
220967 2021-01-25 $10.84 First-Class Mail Stamped Letter 6 0.10 lbs $3.40 $3.12 $0.28
220969 2021-01-25 $50.64 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.75 $7.90 $0.85
220970 2021-01-25 $49.13 Priority Mail 2-Day 6 2.85 lbs $10.38 $13.75 $-3.37
220971 2021-01-25 $68.39 Priority Mail 2-Day Padded Flat Rate Envelope 2 4.86 lbs $8.85 $8.00 $0.85
220972 2021-01-25 $26.43 First-Class Package International Service 10 0.10 lbs $21.53 $13.78 $7.75
220973 2021-01-25 $20.51 Priority Mail 3-Day 1 0.75 lbs $8.52 $8.24 $0.28
220975 2021-01-25 $36.10 First-Class Package Service 1 1.15 lbs $6.31 $7.90 $-1.59
220979 2021-01-25 $28.38 Priority Mail 2-Day 1 0.74 lbs $9.09 $8.24 $0.85
220980 2021-01-26 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
220981 2021-01-25 $179.92 Priority Mail 3-Day 1 9.20 lbs $13.50 $15.59 $-2.09
220982 2021-01-26 $9.18 USPSFirstClass 2 0.38 lbs $5.20 $3.35 $1.85
220983 2021-01-25 $17.14 First-Class Package Service 1 0.20 lbs $4.35 $3.85 $0.50
220984 2021-01-26 $6.01 USPSFirstClass 1 0.03 lbs $4.52 $3.49 $1.03
220985 2021-01-25 $57.95 Ground 2 1.75 lbs $18.29 $16.39 $1.90
220986 2021-01-25 $69.36 Priority Mail 3-Day 2 3.97 lbs $10.38 $9.53 $0.85
220987 2021-01-25 $6.57 First-Class Package Service 1 0.20 lbs $4.08 $3.58 $0.50
220989 2021-01-25 $6.49 First-Class Mail Stamped Letter 1 0.04 lbs $3.00 $3.35 $-0.35
220990 2021-01-26 $7.91 USPSFirstClass 1 0.03 lbs $4.42 $3.22 $1.20
220991 2021-01-25 $14.19 First-Class Package Service 3 0.15 lbs $3.72 $3.22 $0.50
220992 2021-01-25 $54.73 Priority Mail 2-Day Flat Rate Envelope 2 1.58 lbs $8.25 $7.90 $0.35
220993 2021-01-25 $14.33 First-Class Package Service 2 0.14 lbs $4.35 $3.85 $0.50
220994 2021-01-25 $4.49 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.49 $-0.49
220995 2021-01-26 $32.75 USPSFirstClass 1 0.06 lbs $5.51 $3.06 $2.45
220996 2021-01-25 $66.54 Priority Mail 3-Day 1 3.90 lbs $12.55 $11.70 $0.85
220997 2021-01-25 $22.15 Priority Mail 3-Day 1 0.95 lbs $11.86 $11.01 $0.85
220999 2021-01-25 $54.83 Priority Mail 2-Day 1 1.50 lbs $8.64 $7.90 $0.74
221000 2021-01-25 $19.38 Priority Mail 2-Day 1 0.95 lbs $9.09 $8.24 $0.85
221001 2021-01-25 $35.56 First-Class Package Service 1 1.15 lbs $5.77 $7.90 $-2.13
221003 2021-01-25 $51.74 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.75 $7.90 $0.85
221004 2021-01-25 $60.91 Priority Mail 2-Day Medium Flat Rate Box 3 2.81 lbs $15.00 $13.75 $1.25
221005 2021-01-26 $9.97 USPSFirstClass 2 0.12 lbs $4.39 $3.22 $1.17
221007 2021-01-26 $28.87 First-Class Package Service 2 0.40 lbs $4.19 $4.53 $-0.34
221008 2021-01-26 $6.98 First-Class Mail Stamped Letter 2 0.02 lbs $3.00 $3.12 $-0.12
221010 2021-01-26 $19.36 First-Class Mail Stamped Letter 4 0.10 lbs $3.40 $3.49 $-0.09
221012 2021-01-26 $25.16 First-Class Package Service 1 0.65 lbs $5.67 $4.20 $1.47
221013 2021-01-26 $7.69 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
221014 2021-01-26 $7.18 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.49 $-0.29
221015 2021-01-26 $8.87 First-Class Package Service 1 0.27 lbs $4.08 $3.58 $0.50
221016 2021-01-26 $8.49 USPSFirstClass 1 0.10 lbs $4.50 $3.35 $1.15
221017 2021-01-26 $35.25 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221020 2021-01-26 $8.91 USPSFirstClass 1 0.25 lbs $4.52 $3.35 $1.17
221021 2021-01-26 $33.79 Priority Mail 2-Day 7 0.89 lbs $11.86 $11.63 $0.23
221022 2021-01-26 $51.52 Priority Mail 2-Day 2 1.25 lbs $12.54 $11.69 $0.85
221023 2021-01-26 $8.98 USPSFirstClass 1 0.40 lbs $5.19 $4.38 $0.81
221025 2021-01-26 $45.83 Priority Mail 2-Day 6 4.98 lbs $10.49 $9.64 $0.85
221027 2021-01-26 $54.44 Priority Mail 3-Day Small Flat Rate Box 1 1.60 lbs $8.75 $8.25 $0.50
221029 2021-01-26 $4.48 First-Class Mail Stamped Letter 2 0.08 lbs $3.00 $3.35 $-0.35
221030 2021-01-26 $9.19 First-Class Package Service 3 0.07 lbs $3.72 $3.22 $0.50
221031 2021-01-26 $4.98 First-Class Mail Stamped Letter 2 0.02 lbs $3.00 $3.22 $-0.22
221032 2021-01-26 $20.77 First-Class Package Service 1 0.35 lbs $4.07 $3.57 $0.50
221034 2021-01-26 $13.75 First-Class Package Service 1 0.19 lbs $3.76 $4.12 $-0.36
221035 2021-01-26 $43.73 Priority Mail 2-Day Small Flat Rate Box 2 1.33 lbs $8.75 $7.90 $0.85
221036 2021-01-26 $67.58 First-Class Package Service 3 0.68 lbs $6.31 $5.81 $0.50
221037 2021-01-26 $12.99 First-Class Package Service 2 0.22 lbs $4.01 $3.51 $0.50
221038 2021-01-26 $11.55 First-Class Mail Stamped Letter 5 0.17 lbs $3.60 $3.35 $0.25
221040 2021-01-26 $36.06 First-Class Package Service 1 0.31 lbs $4.07 $3.57 $0.50
221041 2021-01-26 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221043 2021-01-26 $9.73 Priority Mail 2-Day Flat Rate Envelope 2 0.07 lbs $8.25 $7.88 $0.37
221044 2021-01-26 $8.76 USPSFirstClass 1 0.22 lbs $4.37 $3.06 $1.31
221045 2021-01-26 $135.89 USPSPriority 1 3.00 lbs $25.90 $12.64 $13.26
221046 2021-01-27 $11.59 USPSFirstClass 1 0.06 lbs $4.60 $3.22 $1.38
221047 2021-01-27 $7.91 USPSFirstClass 1 0.03 lbs $4.42 $3.22 $1.20
221051 2021-01-27 $8.49 USPSFirstClass 1 0.06 lbs $4.50 $3.35 $1.15
221052 2021-01-27 $8.55 USPSFirstClass 1 0.01 lbs $4.50 $3.35 $1.15
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56