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
207190 2019-07-19 $13.26 First-Class Package Service 5 0.11 lbs $3.81 $3.28 $0.53
207191 2019-07-20 $10.76 First-Class Package Service 5 0.14 lbs $3.81 $3.28 $0.53
207192 2019-07-20 $9.72 First-Class Package Service 3 0.14 lbs $3.75 $3.22 $0.53
207193 2019-07-20 $11.13 First-Class Package Service 1 0.19 lbs $4.14 $3.09 $1.05
207194 2019-07-20 $6.12 First-Class Package Service 2 0.02 lbs $4.14 $3.09 $1.05
207195 2019-07-20 $11.00 First-Class Package Service 1 0.19 lbs $4.01 $2.96 $1.05
207196 2019-07-20 $34.58 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
207198 2019-07-20 $12.00 First-Class Package Service 1 0.17 lbs $4.01 $3.49 $0.52
207199 2019-07-21 $9.94 First-Class Package Service 1 0.30 lbs $4.27 $3.88 $0.39
207200 2019-07-21 $8.90 First-Class Package Service - Retail 1 0.05 lbs $4.91 $3.09 $1.82
207202 2019-07-22 $179.16 Ground 12 20.79 lbs $31.20 $18.58 $12.62
207203 2019-07-22 $34.29 Priority Mail 2-Day 6 2.40 lbs $13.95 $13.10 $0.85
207205 2019-07-22 $60.57 Priority Mail 3-Day 4 1.80 lbs $10.11 $8.76 $1.35
207206 2019-07-22 $33.18 Priority Mail 2-Day 5 1.75 lbs $8.73 $8.12 $0.61
207207 2019-07-22 $16.02 First-Class Package Service 3 0.38 lbs $4.27 $3.88 $0.39
207208 2019-07-22 $10.03 First-Class Package Service 1 0.15 lbs $4.54 $3.49 $1.05
207209 2019-07-22 $60.45 Ground 4 3.80 lbs $25.29 $22.79 $2.50
207212 2019-07-22 $34.99 Priority Mail 2-Day Medium Flat Rate Box 6 3.65 lbs $14.05 $15.67 $-1.62
207213 2019-07-22 $84.55 First-Class Package International Service 5 2.00 lbs $39.60 $20.43 $19.17
207214 2019-07-22 $69.43 Priority Mail 2-Day 2 2.40 lbs $8.46 $7.65 $0.81
207215 2019-07-22 $66.53 Priority Mail 2-Day 1 3.95 lbs $8.66 $7.81 $0.85
207217 2019-07-23 $45.44 Priority Mail 2-Day 4 1.00 lbs $11.08 $10.23 $0.85
207218 2019-07-23 $23.15 Priority Mail 2-Day 4 2.43 lbs $9.19 $8.34 $0.85
207219 2019-07-23 $48.84 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.35 $7.50 $0.85
207220 2019-07-23 $5.85 First-Class Package Service 4 0.04 lbs $3.89 $2.84 $1.05
207224 2019-07-23 $257.81 Ground 19 18.91 lbs $23.37 $21.95 $1.42
207225 2019-07-24 $155.78 Priority Mail International 18 4.48 lbs $66.96 $9.12 $57.84
207226 2019-07-24 $60.80 Priority Mail International 18 4.04 lbs $0.00 $9.12 $-9.12
207227 2019-07-24 $11.74 First-Class Package Service 1 0.17 lbs $3.75 $3.22 $0.53
207229 2019-07-24 $5.22 First-Class Package Service 3 0.03 lbs $3.75 $2.70 $1.05
207231 2019-07-24 $12.51 First-Class Package Service 4 0.20 lbs $3.75 $3.22 $0.53
207233 2019-07-24 $20.71 First-Class Package Service 2 0.40 lbs $4.93 $3.88 $1.05
207236 2019-07-25 $7.99 First-Class Package Service 2 0.02 lbs $4.01 $2.96 $1.05
207237 2019-07-25 $83.52 Priority Mail 2-Day 3 2.70 lbs $9.19 $8.12 $1.07
207240 2019-07-25 $61.73 Priority Mail 2-Day 2 1.70 lbs $13.95 $13.10 $0.85
207241 2019-07-25 $24.22 Priority Mail 2-Day 6 1.14 lbs $11.08 $10.23 $0.85
207242 2019-07-26 $12.09 First-Class Package Service 5 0.06 lbs $4.14 $3.09 $1.05
207243 2019-07-26 $35.11 Priority Mail 3-Day 2 1.60 lbs $8.73 $7.88 $0.85
207245 2019-07-26 $53.41 Priority Mail International 19 3.94 lbs $11.45 $9.12 $2.33
207246 2019-07-26 $23.48 First-Class Package Service 2 0.50 lbs $5.97 $5.12 $0.85
207247 2019-07-27 $20.50 Priority Mail 3-Day 1 0.95 lbs $11.71 $10.86 $0.85
207258 2019-07-27 $46.25 Direct Link International 5 0.65 lbs $19.76 $13.66 $6.10
207259 2019-07-27 $65.02 Priority Mail 2-Day Medium Flat Rate Box 3 3.35 lbs $14.05 $11.20 $2.85
207261 2019-07-28 $24.43 First-Class Package Service 8 0.11 lbs $4.01 $2.96 $1.05
207262 2019-07-28 $19.18 Priority Mail 3-Day 5 1.00 lbs $8.73 $7.88 $0.85
207263 2019-07-27 $12.25 First-Class Package Service 3 0.03 lbs $8.28 $3.09 $5.19
207264 2019-07-29 $21.02 First-Class Package Service 1 0.40 lbs $4.73 $3.88 $0.85
207265 2019-07-29 $9.09 First-Class Package Service 2 0.25 lbs $4.41 $3.36 $1.05
207266 2019-07-29 $8.00 First-Class Package Service 1 0.07 lbs $4.01 $2.96 $1.05
207267 2019-07-30 $29.22 First-Class Package International Service 1 0.30 lbs $18.23 $9.98 $8.25
207269 2019-07-30 $16.12 First-Class Package Service 2 0.04 lbs $4.14 $3.09 $1.05
207270 2019-07-30 $27.66 First-Class Package Service 7 0.61 lbs $4.33 $3.96 $0.37
207272 2019-07-30 $74.33 Priority Mail 2-Day Large Flat Rate Box 12 3.44 lbs $18.45 $12.80 $5.65
207273 2019-07-30 $48.89 Priority Mail 2-Day Medium Flat Rate Box 16 2.14 lbs $14.05 $12.80 $1.25
207274 2019-07-30 $51.67 Priority Mail 2-Day 4 1.40 lbs $11.71 $10.86 $0.85
207275 2019-07-30 $22.56 First-Class Package Service 1 0.30 lbs $4.27 $3.22 $1.05
207277 2019-07-30 $27.25 First-Class Package Service 2 0.68 lbs $5.97 $5.12 $0.85
207279 2019-07-30 $24.26 First-Class Package Service 1 0.40 lbs $4.27 $3.88 $0.39
207281 2019-07-31 $19.31 Direct Link International 2 0.16 lbs $12.33 $12.95 $-0.62
207282 2019-07-31 $38.14 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
207286 2019-07-31 $7.74 First-Class Package Service 1 0.06 lbs $3.75 $2.70 $1.05
207290 2019-08-01 $18.01 Priority Mail 2-Day Flat Rate Envelope 1 0.30 lbs $7.80 $7.50 $0.30
207291 2019-08-01 $19.11 First-Class Package Service 1 0.25 lbs $5.24 $3.49 $1.75
207292 2019-08-01 $19.98 First-Class Package Service 3 0.60 lbs $5.01 $5.12 $-0.11
207293 2019-08-01 $54.76 Priority Mail 3-Day 8 3.04 lbs $16.44 $15.59 $0.85
207294 2019-08-01 $13.72 First-Class Package Service 9 0.11 lbs $3.81 $2.76 $1.05
207297 2019-08-02 $16.06 First-Class Package Service 1 0.30 lbs $4.27 $3.22 $1.05
207298 2019-08-02 $42.04 Direct Link International 2 1.05 lbs $18.16 $20.22 $-2.06
207300 2019-08-02 $52.65 Priority Mail 3-Day 1 2.60 lbs $9.66 $8.34 $1.32
207302 2019-08-02 $48.84 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
207304 2019-08-03 $23.88 First-Class Package Service 5 0.21 lbs $4.33 $3.28 $1.05
207306 2019-08-03 $13.71 Priority Mail 3-Day 2 1.00 lbs $8.73 $7.88 $0.85
207309 2019-08-03 $6.79 First-Class Package Service 2 0.10 lbs $3.81 $2.76 $1.05
207310 2019-08-03 $24.79 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.50 $0.30
207311 2019-08-04 $6.83 First-Class Package Service 6 0.06 lbs $3.89 $2.84 $1.05
207312 2019-08-04 $6.89 First-Class Package Service 1 0.05 lbs $3.89 $2.84 $1.05
207315 2019-08-04 $68.51 Priority Mail 2-Day Flat Rate Envelope 9 2.11 lbs $7.80 $7.50 $0.30
207317 2019-08-04 $50.38 Direct Link International 18 0.44 lbs $16.26 $3.22 $13.04
207325 2019-08-05 $67.08 Priority Mail 1-Day 11 0.96 lbs $8.27 $7.42 $0.85
207351 2019-08-08 $36.76 Priority Mail 3-Day 3 0.68 lbs $9.19 $7.50 $1.69
207357 2019-08-08 $109.83 Priority Mail International 27 4.67 lbs $0.00 $29.03 $-29.03
207368 2019-08-10 $17.58 Priority Mail 2-Day Flat Rate Envelope 2 1.20 lbs $7.80 $7.55 $0.25
207372 2019-08-10 $50.78 Priority Mail 2-Day 5 0.94 lbs $8.27 $7.50 $0.77
207379 2019-08-11 $15.72 First-Class Package Service 3 0.15 lbs $3.75 $2.70 $1.05
207383 2019-08-11 $94.71 Direct Link International 4 2.65 lbs $29.55 $28.29 $1.26
207384 2019-08-11 $94.71 Direct Link International 4 2.65 lbs $29.55 $27.43 $2.12
207385 2019-08-11 $94.71 Direct Link International 4 2.65 lbs $29.55 $28.11 $1.44
207386 2019-08-11 $95.72 Direct Link International 2 2.70 lbs $29.74 $18.10 $11.64
207388 2019-08-11 $103.82 Direct Link International 3 3.02 lbs $30.98 $29.14 $1.84
207390 2019-08-11 $105.82 Direct Link International 2 2.75 lbs $29.94 $18.96 $10.98
207392 2019-08-11 $103.60 Direct Link International 6 2.49 lbs $28.46 $27.77 $0.69
207394 2019-08-11 $112.52 Direct Link International 4 2.00 lbs $26.56 $26.28 $0.28
207395 2019-08-11 $94.71 Direct Link International 4 2.65 lbs $29.55 $26.91 $2.64
207405 2019-08-12 $144.99 Direct Link International 38 6.62 lbs $54.40 $94.87 $-40.47
207433 2019-08-14 $217.58 Priority Mail 2-Day 1 14.05 lbs $27.59 $35.32 $-7.73
207443 2019-08-15 $58.56 Direct Link International 7 0.73 lbs $15.63 $15.20 $0.43
207454 2019-08-16 $18.54 First-Class Package Service 1 0.20 lbs $3.75 $3.22 $0.53
207456 2019-08-16 $17.99 First-Class Package Service 2 0.14 lbs $4.01 $2.96 $1.05
207457 2019-08-16 $39.36 Priority Mail 2-Day 5 1.99 lbs $10.11 $9.26 $0.85
207458 2019-08-17 $33.70 First-Class Package Service 7 0.69 lbs $5.97 $5.12 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56