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
206127 2019-03-13 $9.29 First-Class Package Service 2 0.40 lbs $5.11 $3.36 $1.75
206129 2019-03-13 $81.45 Priority Mail 2-Day 15 5.46 lbs $27.60 $17.60 $10.00
206130 2019-03-13 $81.45 Priority Mail 2-Day 15 5.46 lbs $27.60 $17.60 $10.00
206131 2019-03-13 $59.66 Priority Mail 2-Day Medium Flat Rate Box 54 1.87 lbs $13.80 $10.86 $2.94
206132 2019-03-13 $64.64 Priority Mail 2-Day Medium Flat Rate Box 36 1.81 lbs $13.80 $12.80 $1.00
206133 2019-03-13 $44.60 Priority Mail 2-Day Flat Rate Envelope 10 1.15 lbs $7.80 $7.55 $0.25
206138 2019-03-14 $44.38 Priority Mail 3-Day Flat Rate Envelope 2 1.75 lbs $7.80 $7.55 $0.25
206140 2019-03-14 $14.75 First-Class Package Service 1 0.30 lbs $4.54 $3.49 $1.05
206143 2019-03-14 $69.56 First-Class Package International Service 2 0.97 lbs $31.28 $36.58 $-5.30
206146 2019-03-14 $13.65 First-Class Package Service 3 0.31 lbs $4.68 $3.63 $1.05
206148 2019-03-14 $47.34 Priority Mail 3-Day 1 1.85 lbs $12.65 $10.00 $2.65
206150 2019-03-14 $8.90 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
206152 2019-03-14 $22.52 First-Class Package Service 5 0.35 lbs $4.27 $3.88 $0.39
206156 2019-03-15 $34.80 Ground 1 2.30 lbs $19.01 $18.12 $0.89
206157 2019-03-15 $121.22 Priority Mail 2-Day 5 3.95 lbs $18.77 $17.92 $0.85
206158 2019-03-15 $30.16 First-Class Package Service 8 0.53 lbs $5.24 $4.19 $1.05
206159 2019-03-15 $22.10 First-Class Package Service - Retail 2 0.35 lbs $5.42 $3.36 $2.06
206162 2019-03-15 $40.40 Priority Mail 2-Day 4 1.13 lbs $10.55 $9.70 $0.85
206163 2019-03-15 $24.72 First-Class Package Service 3 0.15 lbs $3.75 $2.70 $1.05
206165 2019-03-16 $56.57 Priority Mail 2-Day 11 2.30 lbs $8.46 $8.34 $0.12
206167 2019-03-16 $7.32 First-Class Package Service 7 0.07 lbs $3.89 $2.84 $1.05
206168 2019-03-16 $15.48 First-Class Package Service 6 0.24 lbs $4.54 $3.49 $1.05
206172 2019-03-17 $25.26 First-Class Package Service 1 0.80 lbs $5.97 $5.12 $0.85
206173 2019-03-17 $12.00 First-Class Package Service 1 0.17 lbs $4.01 $3.49 $0.52
206174 2019-03-17 $74.94 Priority Mail 2-Day 32 3.67 lbs $18.46 $17.61 $0.85
206176 2019-03-17 $91.83 Priority Mail 2-Day Medium Flat Rate Box 17 2.39 lbs $13.80 $12.80 $1.00
206177 2019-03-17 $17.07 First-Class Package Service 2 0.72 lbs $6.09 $7.82 $-1.73
206178 2019-03-17 $120.79 Priority Mail 2-Day 3 7.29 lbs $9.86 $9.01 $0.85
206179 2019-03-17 $49.08 Priority Mail 3-Day Flat Rate Envelope 2 1.35 lbs $7.80 $7.50 $0.30
206182 2019-03-17 $38.21 First-Class Package Service 3 0.61 lbs $5.24 $4.19 $1.05
206185 2019-03-17 $154.11 Priority Mail 2-Day Medium Flat Rate Box 19 5.83 lbs $13.80 $12.80 $1.00
206186 2019-03-17 $86.96 Priority Mail 3-Day Medium Flat Rate Box 4 3.07 lbs $13.80 $11.20 $2.60
206187 2019-03-17 $20.10 First-Class Package Service 4 0.16 lbs $4.14 $3.09 $1.05
206192 2019-03-18 $10.37 First-Class Package Service 2 0.07 lbs $3.89 $2.84 $1.05
206193 2019-03-18 $203.90 Priority Mail 2-Day 9 10.25 lbs $16.78 $13.69 $3.09
206194 2019-03-18 $12.30 First-Class Package Service 3 0.17 lbs $4.33 $3.96 $0.37
206195 2019-03-18 $51.17 Priority Mail 2-Day 2 1.80 lbs $9.19 $8.34 $0.85
206197 2019-03-18 $10.79 First-Class Package Service 2 0.01 lbs $3.81 $2.76 $1.05
206199 2019-03-18 $8.79 First-Class Package Service 2 0.02 lbs $3.81 $2.76 $1.05
206200 2019-03-19 $68.82 Priority Mail 3-Day 6 1.74 lbs $11.08 $10.55 $0.53
206201 2019-03-19 $24.32 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
206204 2019-03-19 $18.80 First-Class Package Service 1 0.19 lbs $3.81 $3.28 $0.53
206206 2019-02-04 $9.99 Priority Mail 2-Day 1 0.35 lbs $0.00 $4.06 $-4.06
206208 2019-03-20 $31.01 Priority Mail 2-Day 10 1.90 lbs $10.11 $9.26 $0.85
206210 2019-03-20 $7.79 First-Class Package Service 2 0.16 lbs $3.81 $3.28 $0.53
206211 2019-03-20 $30.19 First-Class Package Service 2 0.55 lbs $5.01 $3.96 $1.05
206212 2019-03-20 $16.21 First-Class Package Service 10 0.20 lbs $3.81 $3.28 $0.53
206213 2019-03-20 $43.61 Priority Mail 3-Day Flat Rate Envelope 3 1.00 lbs $7.80 $7.55 $0.25
206214 2019-03-21 $54.69 Priority Mail 2-Day 4 1.62 lbs $8.73 $7.88 $0.85
206215 2019-03-21 $26.67 First-Class Package Service 1 0.45 lbs $4.68 $4.33 $0.35
206217 2019-03-21 $20.34 First-Class Package Service 4 0.22 lbs $6.38 $4.33 $2.05
206218 2019-03-21 $6.74 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
206219 2019-03-21 $21.99 Priority Mail 2-Day 6 1.19 lbs $9.35 $8.50 $0.85
206220 2019-03-21 $55.80 Priority Mail 2-Day Small Flat Rate Box 5 1.71 lbs $8.35 $7.50 $0.85
206224 2019-03-21 $5.88 First-Class Package Service 1 0.01 lbs $3.89 $2.84 $1.05
206225 2019-03-22 $36.01 First-Class Package Service 3 0.70 lbs $6.29 $5.24 $1.05
206226 2019-03-22 $37.84 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
206227 2019-03-22 $53.92 Direct Link 12 2.96 lbs $32.08 $27.26 $4.82
206228 2019-03-22 $68.38 Direct Link 22 2.67 lbs $32.08 $27.26 $4.82
206229 2019-03-22 $57.30 Direct Link 21 3.48 lbs $32.09 $47.14 $-15.05
206231 2019-03-22 $33.89 First-Class Package Service 8 0.60 lbs $5.97 $8.50 $-2.53
206232 2019-03-22 $96.91 Direct Link 9 3.96 lbs $33.43 $44.74 $-11.31
206233 2019-03-22 $109.98 Direct Link 32 5.81 lbs $33.43 $48.74 $-15.31
206234 2019-03-22 $50.70 Direct Link 10 2.79 lbs $33.43 $28.29 $5.14
206236 2019-03-23 $132.66 Priority Mail 1-Day 4 3.45 lbs $8.56 $7.65 $0.91
206241 2019-03-24 $11.76 First-Class Package Service 5 0.06 lbs $3.81 $2.76 $1.05
206248 2019-03-25 $691.87 Priority Mail 2-Day 140 69.00 lbs $49.27 $50.72 $-1.45
206249 2019-03-25 $15.19 First-Class Package Service 2 0.32 lbs $4.81 $3.96 $0.85
206253 2019-03-25 $29.75 Priority Mail 2-Day Flat Rate Envelope 5 1.22 lbs $7.80 $7.50 $0.30
206254 2019-03-25 $11.92 First-Class Package Service 2 0.10 lbs $4.14 $3.09 $1.05
206255 2019-03-25 $19.68 First-Class Package Service 1 0.30 lbs $4.33 $3.28 $1.05
206256 2019-03-25 $25.58 First-Class Package Service 1 1.00 lbs $6.29 $7.50 $-1.21
206257 2019-03-25 $48.84 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.35 $7.50 $0.85
206259 2019-03-25 $25.02 Priority Mail 2-Day Flat Rate Envelope 8 1.17 lbs $7.80 $7.50 $0.30
206260 2019-03-25 $6.00 First-Class Package Service 1 0.02 lbs $4.01 $2.96 $1.05
206262 2019-03-26 $14.92 First-Class Package Service 1 0.35 lbs $4.93 $3.88 $1.05
206264 2019-03-26 $50.95 Priority Mail 3-Day 2 3.90 lbs $9.97 $9.46 $0.51
206266 2019-03-26 $74.16 Priority Mail 3-Day 7 1.74 lbs $8.73 $7.88 $0.85
206267 2019-03-27 $97.39 Ground 1 4.55 lbs $26.40 $23.15 $3.25
206268 2019-03-27 $26.34 First-Class Package International Service 5 0.34 lbs $21.54 $22.33 $-0.79
206271 2019-03-27 $102.35 First-Class Package International Service 3 2.58 lbs $46.58 $36.58 $10.00
206272 2019-03-27 $102.35 First-Class Package International Service 3 2.58 lbs $46.58 $55.10 $-8.52
206275 2019-03-27 $56.27 Priority Mail 2-Day 17 2.45 lbs $16.44 $15.59 $0.85
206276 2019-03-27 $27.67 First-Class Package Service 2 0.67 lbs $6.29 $5.24 $1.05
206278 2019-03-27 $6.00 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
206279 2019-03-27 $38.14 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
206285 2019-03-28 $22.05 First-Class Package Service 10 0.16 lbs $5.99 $2.66 $3.33
206286 2019-03-28 $20.84 First-Class Package Service 3 0.26 lbs $5.87 $5.02 $0.85
206287 2019-03-28 $30.57 Priority Mail 3-Day Flat Rate Envelope 23 1.00 lbs $7.80 $7.65 $0.15
206288 2019-03-28 $16.05 First-Class Package Service 6 0.54 lbs $4.91 $4.06 $0.85
206289 2019-03-28 $12.76 First-Class Package Service 1 0.05 lbs $4.01 $2.96 $1.05
206292 2019-03-28 $35.02 Priority Mail 2-Day 6 0.42 lbs $11.08 $10.23 $0.85
206295 2019-03-29 $54.63 Priority Mail 3-Day 1 2.40 lbs $8.84 $7.99 $0.85
206296 2019-03-29 $4.25 First-Class Package Service 1 0.20 lbs $4.25 $3.20 $1.05
206297 2019-03-29 $13.76 First-Class Package Service 1 0.30 lbs $4.27 $3.22 $1.05
206298 2019-03-29 $34.66 Priority Mail 2-Day 7 1.75 lbs $10.11 $8.76 $1.35
206303 2019-03-29 $8.25 First-Class Package Service 2 0.25 lbs $4.27 $3.22 $1.05
206304 2019-03-30 $42.32 Priority Mail 3-Day 2 0.70 lbs $9.35 $7.50 $1.85
206305 2019-03-30 $8.00 First-Class Package Service 1 0.16 lbs $4.01 $3.49 $0.52
206307 2019-03-30 $40.31 First-Class Package Service 2 0.70 lbs $6.23 $5.38 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56