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
229059 2022-03-28 $10.17 First-Class Package Service 1 0.10 lbs $4.78 $3.58 $1.20
229062 2022-03-28 $12.97 First-Class Package Service 2 0.27 lbs $5.19 $3.99 $1.20
229064 2022-03-29 $19.67 First-Class Package Service 1 0.40 lbs $6.03 $4.83 $1.20
229065 2022-03-29 $18.63 First-Class Package Service 5 0.05 lbs $4.68 $3.48 $1.20
229067 2022-03-29 $56.52 Priority Mail 2-Day Flat Rate Envelope 3 1.05 lbs $8.85 $8.45 $0.40
229068 2022-03-29 $11.24 First-Class Package Service 1 0.27 lbs $5.10 $4.98 $0.12
229069 2022-03-29 $42.80 Priority Mail 2-Day 4 2.48 lbs $18.84 $13.54 $5.30
229071 2022-03-29 $16.88 First-Class Package Service 1 0.14 lbs $5.19 $3.72 $1.47
229074 2022-03-30 $26.57 FedEx Ground or FedEx Home Delivery 1 0.91 lbs $11.58 $8.40 $3.18
229078 2022-03-30 $10.62 First-Class Package Service 1 0.03 lbs $4.68 $3.48 $1.20
229082 2022-03-30 $27.21 Priority Mail 3-Day 1 0.90 lbs $10.22 $9.12 $1.10
229085 2022-03-31 $28.87 First-Class Package Service 1 0.40 lbs $6.18 $4.15 $2.03
229086 2022-03-31 $147.88 Priority Mail 3-Day 4 6.00 lbs $11.92 $8.88 $3.04
229089 2022-03-31 $30.98 First-Class Package Service 1 0.24 lbs $5.19 $3.99 $1.20
229092 2022-04-01 $18.30 First-Class Package Service 1 0.30 lbs $5.35 $4.15 $1.20
229093 2022-04-01 $13.74 USPS Priority Mail 1 0.05 lbs $9.45 $7.75 $1.70
229094 2022-04-01 $20.89 USPS Priority Mail 1 0.07 lbs $10.90 $8.25 $2.65
229095 2022-04-01 $64.20 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.45 lbs $9.55 $16.90 $-7.35
229096 2022-04-01 $49.34 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $9.35 $8.10 $1.25
229097 2022-04-02 $190.42 Priority Mail 2-Day 4 11.37 lbs $40.39 $37.17 $3.22
229098 2022-04-02 $50.53 Priority Mail 2-Day Small Flat Rate Box 2 1.53 lbs $9.35 $8.25 $1.10
229099 2022-04-02 $42.34 USPS Priority Mail 1 0.44 lbs $10.15 $8.59 $1.56
229100 2022-04-02 $19.96 USPS First-Class Mail or Priority Mail 1 0.93 lbs $8.90 $8.49 $0.41
229106 2022-04-03 $27.44 First-Class Package Service 2 0.45 lbs $5.88 $4.68 $1.20
229107 2022-04-03 $17.49 Priority Mail 2-Day Flat Rate Envelope 1 0.06 lbs $8.85 $7.75 $1.10
229108 2022-04-03 $13.22 First-Class Package Service 1 0.19 lbs $5.08 $3.58 $1.50
229110 2022-04-03 $21.59 First-Class Package Service 2 0.25 lbs $5.01 $3.42 $1.59
229111 2022-04-04 $21.89 USPS Priority Mail 1 0.50 lbs $10.90 $8.45 $2.45
229112 2022-04-04 $17.34 USPS Priority Mail 1 0.06 lbs $9.85 $7.75 $2.10
229113 2022-04-04 $8.20 First-Class Package Service 3 0.05 lbs $5.08 $3.58 $1.50
229115 2022-04-04 $26.75 Priority Mail 2-Day 1 0.70 lbs $13.76 $12.66 $1.10
229120 2022-04-04 $139.34 Priority Mail 3-Day Small Flat Rate Box 1 9.35 lbs $9.35 $9.79 $-0.44
229122 2022-04-04 $37.29 Priority Mail 3-Day Small Flat Rate Box 6 0.40 lbs $9.35 $8.25 $1.10
229123 2022-04-05 $47.83 Priority Mail 3-Day Flat Rate Envelope 2 1.60 lbs $8.85 $8.45 $0.40
229127 2022-04-05 $14.30 First-Class Package Service 3 0.48 lbs $6.18 $4.98 $1.20
229130 2022-04-06 $34.19 USPS Shipping 1 3.10 lbs $14.60 $5.08 $9.52
229132 2022-04-06 $8.23 First-Class Package Service 2 0.44 lbs $7.06 $4.83 $2.23
229135 2022-04-06 $16.53 First-Class Package Service 3 0.15 lbs $4.76 $3.81 $0.95
229140 2022-04-07 $21.09 USPS Priority Mail 1 0.06 lbs $11.60 $7.75 $3.85
229141 2022-04-07 $41.87 Selected States in United States 5 3.58 lbs $16.79 $8.45 $8.34
229144 2022-04-07 $14.89 United States 10 0.10 lbs $3.99 $3.86 $0.13
229148 2022-04-08 $23.04 First-Class Package Service 2 0.02 lbs $5.06 $3.86 $1.20
229149 2022-04-08 $15.49 USPS First Class 1 0.50 lbs $5.50 $9.03 $-3.53
229153 2022-04-08 $75.09 Priority Mail 3-Day Flat Rate Envelope 26 0.91 lbs $8.85 $8.25 $0.60
229158 2022-04-08 $35.96 Priority Mail 2-Day 5 0.86 lbs $10.22 $8.12 $2.10
229159 2022-04-08 $14.49 First-Class Package Service 4 0.52 lbs $6.03 $4.83 $1.20
229160 2022-04-08 $16.07 First-Class Package Service 2 0.47 lbs $5.29 $4.34 $0.95
229161 2022-04-09 $18.29 USPS Priority Mail 1 0.06 lbs $10.90 $7.75 $3.15
229162 2022-04-09 $32.95 First-Class Package Service 1 0.40 lbs $4.96 $5.49 $-0.53
229163 2022-04-09 $23.76 First-Class Package Service 2 0.12 lbs $4.78 $3.58 $1.20
229166 2022-04-11 $8.91 First-Class Package Service 2 0.02 lbs $4.78 $3.58 $1.20
229171 2022-04-11 $13.06 First-Class Package Service 1 0.05 lbs $4.92 $3.72 $1.20
229173 2022-04-11 $14.14 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229176 2022-04-11 $17.45 Priority Mail 2-Day Flat Rate Envelope 5 0.95 lbs $8.85 $7.75 $1.10
229177 2022-04-11 $17.62 USPS Shipping 1 0.12 lbs $4.13 $3.72 $0.41
229178 2022-04-11 $19.94 USPS First-Class Mail or Priority Mail 1 0.12 lbs $4.86 $3.86 $1.00
229180 2022-04-12 $14.29 USPS First Class 1 0.06 lbs $4.80 $3.72 $1.08
229181 2022-04-12 $13.63 USPS First Class 1 0.06 lbs $4.92 $3.72 $1.20
229183 2022-04-12 $35.17 First-Class Package Service 1 0.40 lbs $6.18 $4.98 $1.20
229184 2022-04-12 $110.24 Priority Mail 3-Day 4 2.41 lbs $10.08 $8.98 $1.10
229185 2022-04-12 $8.66 First-Class Package Service 1 0.06 lbs $4.62 $3.42 $1.20
229187 2022-04-12 $9.56 First-Class Package Service 1 0.03 lbs $4.92 $3.72 $1.20
229188 2022-04-13 $14.29 USPS First Class 1 0.06 lbs $4.80 $3.72 $1.08
229189 2022-04-13 $13.92 USPS Shipping 1 0.05 lbs $0.00 $4.15 $-4.15
229190 2022-04-13 $43.61 First-Class Package Service 1 0.60 lbs $5.62 $4.42 $1.20
229194 2022-04-14 $24.81 First-Class Package Service 2 0.26 lbs $4.83 $3.88 $0.95
229195 2022-04-14 $64.34 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $9.35 $8.10 $1.25
229199 2022-04-14 $10.92 First-Class Package Service 1 0.07 lbs $4.78 $3.58 $1.20
229201 2022-04-14 $16.10 First-Class Package Service 2 0.12 lbs $4.62 $3.42 $1.20
229203 2022-04-15 $12.91 First-Class Package Service 1 0.15 lbs $4.62 $3.42 $1.20
229215 2022-04-15 $8.69 First-Class Package Service 2 0.08 lbs $5.06 $3.86 $1.20
229216 2022-04-15 $6.82 First-Class Package Service 1 0.05 lbs $4.68 $3.48 $1.20
229218 2022-04-16 $10.29 USPS First Class 1 0.06 lbs $4.50 $3.37 $1.13
229219 2022-04-16 $43.81 USPS First-Class Mail or Priority Mail 2 2.38 lbs $15.93 $9.93 $6.00
229222 2022-04-16 $31.63 First-Class Package Service 3 0.11 lbs $5.06 $3.86 $1.20
229223 2022-04-16 $17.06 First-Class Package Service 1 0.18 lbs $5.07 $3.48 $1.59
229224 2022-04-17 $14.17 First-Class Package Service 5 0.10 lbs $4.62 $3.42 $1.20
229226 2022-04-17 $34.30 Priority Mail 2-Day Small Flat Rate Box 5 0.41 lbs $9.35 $8.25 $1.10
229227 2022-04-18 $61.59 USPS Priority Mail 1 1.17 lbs $16.10 $8.25 $7.85
229228 2022-04-18 $14.14 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229229 2022-04-18 $20.71 USPS First-Class Mail or Priority Mail 2 0.16 lbs $5.86 $4.15 $1.71
229230 2022-04-18 $51.66 USPS First Class 1 0.33 lbs $7.23 $4.15 $3.08
229231 2022-04-19 $14.49 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
229232 2022-04-19 $12.35 USPS Shipping 1 0.05 lbs $5.06 $3.58 $1.48
229234 2022-04-19 $69.02 Priority Mail 2-Day Small Flat Rate Box 3 0.38 lbs $9.35 $8.25 $1.10
229235 2022-04-19 $8.31 First-Class Package Service 2 0.08 lbs $4.68 $3.48 $1.20
229239 2022-04-20 $21.72 USPS Shipping 1 0.60 lbs $7.23 $4.83 $2.40
229240 2022-04-20 $38.83 Priority Mail 2-Day Flat Rate Envelope 2 0.44 lbs $8.85 $8.25 $0.60
229242 2022-04-21 $14.29 USPS First Class 1 0.06 lbs $4.80 $3.72 $1.08
229247 2022-04-21 $15.85 First-Class Package Service 1 0.05 lbs $5.06 $3.86 $1.20
229250 2022-04-21 $12.90 First-Class Package Service 2 0.16 lbs $4.92 $3.72 $1.20
229252 2022-04-22 $9.06 First-Class Package Service 1 0.05 lbs $4.92 $3.72 $1.20
229253 2022-04-22 $48.73 First-Class Package Service 15 0.65 lbs $5.88 $3.88 $2.00
229254 2022-04-23 $14.49 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
229255 2022-04-23 $22.81 USPS First-Class Mail or Priority Mail 1 1.19 lbs $9.02 $8.02 $1.00
229256 2022-04-23 $35.97 First-Class Package Service 5 0.34 lbs $5.62 $3.81 $1.81
229258 2022-04-23 $20.03 First-Class Package Service 4 0.18 lbs $5.07 $3.48 $1.59
229259 2022-04-23 $12.82 First-Class Package Service 3 0.57 lbs $5.70 $4.50 $1.20
229262 2022-04-24 $13.20 First-Class Package Service 1 0.05 lbs $5.06 $3.86 $1.20
229268 2022-04-25 $175.59 Priority Mail 3-Day 1 6.05 lbs $15.60 $14.50 $1.10
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56