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
206992 2019-06-24 $26.68 Priority Mail 2-Day 3 1.26 lbs $11.71 $10.86 $0.85
206993 2019-06-24 $27.29 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.55 $0.25
206994 2019-06-24 $13.17 First-Class Package Service 2 0.85 lbs $6.09 $5.24 $0.85
206995 2019-06-24 $58.88 Priority Mail 2-Day Flat Rate Envelope 2 1.87 lbs $7.80 $7.55 $0.25
206996 2019-06-24 $5.30 First-Class Package Service 1 0.03 lbs $3.81 $2.76 $1.05
206997 2019-06-24 $45.76 Priority Mail 2-Day Flat Rate Envelope 4 0.73 lbs $7.80 $7.50 $0.30
206998 2019-06-24 $34.58 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.35 $7.50 $0.85
206999 2019-06-24 $24.40 First-Class Package Service 1 0.40 lbs $4.41 $4.06 $0.35
207002 2019-06-25 $16.92 First-Class Package Service 3 0.19 lbs $3.75 $3.22 $0.53
207003 2019-06-25 $153.74 Priority Mail International Medium Flat Rate Box 2 3.90 lbs $47.95 $46.08 $1.87
207005 2019-06-26 $8.10 First-Class Package Service 4 0.02 lbs $4.14 $3.09 $1.05
207009 2019-06-26 $11.32 First-Class Package Service 5 0.32 lbs $4.27 $3.22 $1.05
207010 2019-06-27 $42.75 Priority Mail 2-Day Flat Rate Envelope 5 1.57 lbs $7.80 $7.50 $0.30
207012 2019-06-27 $8.91 First-Class Package Service 10 0.10 lbs $4.01 $2.96 $1.05
207013 2019-06-27 $26.17 First-Class Package Service 4 0.48 lbs $5.01 $3.96 $1.05
207014 2019-06-27 $134.25 Priority Mail International 1 5.65 lbs $66.96 $62.46 $4.50
207018 2019-06-27 $11.74 First-Class Package Service 7 0.16 lbs $3.81 $3.28 $0.53
207020 2019-06-27 $65.68 Priority Mail International Small Flat Rate Box 7 1.04 lbs $32.75 $31.90 $0.85
207023 2019-06-27 $8.12 First-Class Package Service 2 0.12 lbs $4.14 $3.63 $0.51
207030 2019-06-28 $19.32 First-Class Package Service 1 0.24 lbs $4.33 $3.28 $1.05
207034 2019-06-28 $7.99 First-Class Package Service 2 0.21 lbs $4.01 $3.49 $0.52
207039 2019-06-30 $13.51 First-Class Package Service 4 0.35 lbs $4.54 $2.96 $1.58
207040 2019-06-30 $8.08 First-Class Package Service 1 0.07 lbs $3.73 $2.68 $1.05
207043 2019-07-01 $18.76 Priority Mail 2-Day Flat Rate Envelope 4 0.11 lbs $7.80 $6.95 $0.85
207052 2019-07-02 $104.66 Priority Mail 2-Day 8 4.45 lbs $18.78 $17.93 $0.85
207053 2019-07-03 $42.89 Priority Mail 2-Day 6 1.02 lbs $8.73 $7.88 $0.85
207054 2019-07-03 $5.48 First-Class Package Service 3 0.03 lbs $4.01 $2.96 $1.05
207055 2019-07-03 $17.36 First-Class Package Service 2 0.72 lbs $6.38 $10.86 $-4.48
207058 2019-07-03 $22.28 First-Class Package Service 1 0.90 lbs $6.07 $5.02 $1.05
207060 2019-07-04 $9.87 First-Class Package Service 2 0.06 lbs $3.89 $2.84 $1.05
207061 2019-07-04 $34.34 First-Class Package Service 9 0.81 lbs $6.43 $4.19 $2.24
207063 2019-07-04 $80.83 First-Class Package International Service 2 1.60 lbs $31.05 $22.80 $8.25
207067 2019-07-05 $7.80 First-Class Package Service 1 0.20 lbs $4.01 $3.49 $0.52
207069 2019-07-05 $31.32 First-Class Package International Service 1 0.40 lbs $21.79 $22.80 $-1.01
207070 2019-07-05 $52.38 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $7.80 $7.50 $0.30
207071 2019-07-05 $5.71 First-Class Package Service 4 0.04 lbs $3.75 $2.70 $1.05
207072 2019-07-06 $52.58 Priority Mail 2-Day Flat Rate Envelope 2 1.40 lbs $7.80 $7.50 $0.30
207075 2019-07-06 $8.49 First-Class Package Service 2 0.08 lbs $4.01 $2.96 $1.05
207078 2019-07-06 $73.53 Priority Mail 2-Day 2 2.55 lbs $13.95 $10.55 $3.40
207079 2019-07-07 $26.32 Priority Mail 2-Day Small Flat Rate Box 3 1.15 lbs $8.35 $7.50 $0.85
207080 2019-07-07 $6.90 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
207081 2019-07-07 $81.02 First-Class Package International Service 2 1.75 lbs $30.34 $22.09 $8.25
207082 2019-07-07 $26.32 Priority Mail 2-Day Small Flat Rate Box 3 0.06 lbs $8.35 $7.50 $0.85
207083 2019-07-07 $12.37 First-Class Package Service 4 0.40 lbs $4.41 $3.36 $1.05
207084 2019-07-08 $5.74 First-Class Package Service 1 0.12 lbs $3.75 $3.22 $0.53
207085 2019-07-08 $22.38 First-Class Package Service 5 0.42 lbs $4.33 $3.96 $0.37
207086 2019-07-08 $69.87 First-Class Package International Service 6 1.41 lbs $31.53 $23.28 $8.25
207097 2019-07-10 $29.22 Priority Mail 2-Day 3 1.61 lbs $13.95 $13.10 $0.85
207098 2019-07-10 $33.15 Priority Mail 2-Day Small Flat Rate Box 20 1.69 lbs $8.35 $7.50 $0.85
207099 2019-07-10 $33.37 First-Class Package Service 2 0.57 lbs $5.11 $3.36 $1.75
207100 2019-07-10 $110.85 Priority Mail 2-Day Large Flat Rate Box 20 7.60 lbs $36.05 $17.60 $18.45
207103 2019-07-10 $58.87 Priority Mail 3-Day Flat Rate Envelope 3 1.65 lbs $7.80 $7.50 $0.30
207104 2019-07-10 $8.92 First-Class Package Service 2 0.15 lbs $4.54 $3.49 $1.05
207105 2019-07-10 $14.36 First-Class Package Service 5 0.15 lbs $4.41 $3.36 $1.05
207106 2019-07-10 $81.70 Priority Mail 2-Day 2 3.73 lbs $16.52 $15.67 $0.85
207107 2019-07-10 $12.70 Priority Mail 2-Day Flat Rate Envelope 10 0.10 lbs $7.80 $6.95 $0.85
207108 2019-07-10 $10.02 First-Class Package Service 12 0.16 lbs $4.14 $3.63 $0.51
207109 2019-07-10 $9.79 First-Class Package Service 2 0.02 lbs $3.81 $2.76 $1.05
207110 2019-07-10 $8.52 First-Class Package Service 2 0.25 lbs $4.54 $3.49 $1.05
207111 2019-07-10 $24.02 First-Class Package Service 1 0.60 lbs $4.73 $5.02 $-0.29
207112 2019-07-10 $13.50 First-Class Package Service 1 0.05 lbs $4.01 $2.96 $1.05
207113 2019-07-11 $22.81 Priority Mail 2-Day 3 0.33 lbs $8.84 $7.50 $1.34
207114 2019-07-11 $26.68 Priority Mail 2-Day 3 1.26 lbs $11.71 $10.86 $0.85
207115 2019-07-11 $41.68 Priority Mail 2-Day 3 1.05 lbs $11.71 $10.86 $0.85
207116 2019-07-11 $19.15 First-Class Package Service 2 0.29 lbs $4.27 $3.22 $1.05
207117 2019-07-11 $51.71 Priority Mail 2-Day 2 1.00 lbs $8.73 $7.88 $0.85
207118 2019-07-11 $18.88 First-Class Package Service 1 0.21 lbs $3.89 $3.36 $0.53
207119 2019-07-11 $26.37 First-Class Package Service 4 0.54 lbs $5.11 $3.36 $1.75
207120 2019-07-11 $13.97 First-Class Package Service 4 0.20 lbs $4.01 $3.49 $0.52
207121 2019-07-11 $46.40 Priority Mail 2-Day Flat Rate Envelope 2 1.50 lbs $7.80 $7.50 $0.30
207122 2019-07-12 $72.39 Priority Mail 2-Day Large Flat Rate Box 6 2.90 lbs $18.45 $12.80 $5.65
207123 2019-07-12 $71.59 Priority Mail 2-Day 18 5.25 lbs $10.07 $9.22 $0.85
207124 2019-07-12 $22.05 First-Class Package Service 3 0.26 lbs $5.79 $3.82 $1.97
207125 2019-07-12 $59.17 Priority Mail 2-Day 2 2.00 lbs $9.19 $8.12 $1.07
207126 2019-07-12 $47.95 Priority Mail 3-Day 13 3.93 lbs $11.18 $10.33 $0.85
207127 2019-07-12 $54.39 Priority Mail 2-Day Large Flat Rate Box 6 3.72 lbs $18.45 $12.80 $5.65
207128 2019-07-12 $63.18 Priority Mail 2-Day 7 4.34 lbs $21.25 $20.40 $0.85
207137 2019-07-13 $5.80 First-Class Package Service 1 0.03 lbs $3.81 $2.76 $1.05
207138 2019-07-13 $39.77 First-Class Package International Service 6 0.30 lbs $22.03 $23.28 $-1.25
207139 2019-07-13 $8.94 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
207142 2019-07-14 $52.96 First-Class Package International Service 2 0.67 lbs $30.58 $22.33 $8.25
207144 2019-07-14 $10.99 First-Class Package Service 2 0.08 lbs $4.01 $2.96 $1.05
207145 2019-07-14 $8.39 First-Class Package Service 2 0.10 lbs $4.01 $2.96 $1.05
207146 2019-07-14 $14.37 Priority Mail 2-Day Flat Rate Envelope 3 0.15 lbs $7.80 $7.50 $0.30
207148 2019-07-14 $43.81 Priority Mail 2-Day 4 1.38 lbs $9.35 $8.76 $0.59
207151 2019-07-15 $5.50 First-Class Package Service 1 0.01 lbs $4.01 $2.96 $1.05
207152 2019-07-15 $50.72 First-Class Package Service 3 0.70 lbs $5.99 $4.94 $1.05
207153 2019-07-16 $9.78 First-Class Package Service 3 0.04 lbs $3.81 $2.76 $1.05
207154 2019-07-16 $9.87 First-Class Package Service 2 0.07 lbs $3.89 $2.84 $1.05
207155 2019-07-16 $40.34 Priority Mail 3-Day Medium Flat Rate Box 1 3.10 lbs $14.05 $12.80 $1.25
207157 2019-07-16 $22.89 First-Class Package Service 1 0.65 lbs $6.23 $5.38 $0.85
207161 2019-07-16 $16.42 First-Class Package Service 6 0.12 lbs $4.48 $3.63 $0.85
207163 2019-07-17 $13.28 First-Class Package Service 3 0.09 lbs $3.81 $2.76 $1.05
207169 2019-07-17 $104.10 First-Class Package International Service 3 2.58 lbs $46.83 $36.58 $10.25
207170 2019-07-17 $104.10 First-Class Package International Service 3 2.58 lbs $46.83 $36.58 $10.25
207172 2019-07-18 $16.20 Priority Mail 2-Day 3 0.36 lbs $8.73 $7.49 $1.24
207174 2019-07-18 $39.89 Priority Mail 2-Day Medium Flat Rate Box 16 1.65 lbs $14.05 $11.20 $2.85
207175 2019-07-18 $78.23 Priority Mail 2-Day Large Flat Rate Box 22 3.98 lbs $18.45 $17.61 $0.84
207180 2019-07-18 $77.24 Priority Mail 2-Day 6 2.41 lbs $10.11 $8.76 $1.35
207185 2019-07-19 $10.89 First-Class Package Service 2 0.20 lbs $4.01 $3.49 $0.52
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56