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
204236 2018-10-04 $359.88 Ground 8 28.70 lbs $29.08 $22.98 $6.10
204237 2018-10-04 $5.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
204239 2018-10-04 $5.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
204240 2018-10-05 $6.43 First-Class Package Service 1 0.19 lbs $3.84 $2.66 $1.18
204245 2018-10-06 $15.68 First-Class Package Service 3 0.15 lbs $3.71 $2.66 $1.05
204246 2018-10-06 $23.83 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
204247 2018-10-06 $40.69 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $7.90 $6.85 $1.05
204248 2018-10-07 $23.52 First-Class Package International Service 2 0.07 lbs $21.54 $13.54 $8.00
204249 2018-10-07 $47.89 Priority Mail 2-Day 16 1.29 lbs $11.65 $10.48 $1.17
204252 2018-10-07 $9.29 First-Class Package Service 2 0.12 lbs $3.71 $2.66 $1.05
204253 2018-10-07 $21.38 First-Class Package Service 1 0.00 lbs $4.10 $3.05 $1.05
204256 2018-10-07 $18.86 First-Class Package Service 3 0.44 lbs $4.39 $4.10 $0.29
204257 2018-10-08 $310.82 Direct Link International 40 17.16 lbs $94.85 $163.94 $-69.09
204260 2018-10-08 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
204262 2018-10-08 $46.97 Direct Link International 1 0.55 lbs $21.48 $26.97 $-5.49
204263 2018-10-09 $304.45 Direct Link International 15 9.10 lbs $62.79 $104.92 $-42.13
204264 2018-10-09 $197.14 Direct Link International 6 5.05 lbs $60.80 $103.38 $-42.58
204265 2018-10-09 $318.14 Pickup From Store 1 59.00 lbs $0.00 $31.79 $-31.79
204266 2018-10-09 $15.50 First-Class Package Service 1 0.20 lbs $3.71 $3.05 $0.66
204267 2018-10-09 $13.52 First-Class Package Service 4 0.39 lbs $5.15 $3.18 $1.97
204276 2018-10-09 $69.57 First-Class Package International Service 2 1.80 lbs $31.99 $15.20 $16.79
204280 2018-10-10 $19.11 Priority Mail 2-Day 1 0.95 lbs $10.32 $9.19 $1.13
204281 2018-10-10 $34.00 Priority Mail 3-Day 5 0.90 lbs $8.25 $7.18 $1.07
204283 2018-10-10 $63.02 Priority Mail 3-Day Padded Flat Rate Envelope 3 1.90 lbs $7.95 $6.90 $1.05
204285 2018-10-10 $346.42 Ground 11 20.92 lbs $37.32 $26.38 $10.94
204286 2018-10-11 $51.57 Priority Mail 2-Day 6 1.45 lbs $11.14 $9.98 $1.16
204288 2018-10-11 $19.29 First-Class Package Service 2 0.10 lbs $3.71 $3.18 $0.53
204290 2018-10-11 $8.90 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204292 2018-10-11 $11.13 First-Class Mail Large Envelope 3 0.54 lbs $4.66 $4.10 $0.56
204294 2018-10-12 $7.80 First-Class Package Service 4 0.14 lbs $3.84 $3.18 $0.66
204295 2018-10-12 $24.27 Priority Mail 2-Day Flat Rate Envelope 3 1.29 lbs $7.40 $6.90 $0.50
204296 2018-10-12 $40.23 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $7.90 $6.85 $1.05
204297 2018-10-12 $14.35 First-Class Package Service 4 0.38 lbs $4.39 $3.82 $0.57
204298 2018-10-12 $57.30 Direct Link International 20 3.23 lbs $41.68 $86.04 $-44.36
204300 2018-10-12 $39.55 Direct Link International 5 2.40 lbs $17.54 $38.96 $-21.42
204302 2018-10-12 $60.89 Direct Link International 22 2.67 lbs $20.66 $44.99 $-24.33
204303 2018-10-12 $29.29 Priority Mail 2-Day 3 1.45 lbs $10.32 $9.19 $1.13
204304 2018-10-12 $8.70 First-Class Package Service 1 0.06 lbs $3.71 $2.66 $1.05
204305 2018-10-12 $8.28 First-Class Package Service 2 0.38 lbs $4.10 $6.36 $-2.26
204306 2018-10-13 $24.08 Priority Mail 2-Day 7 0.91 lbs $11.14 $9.98 $1.16
204307 2018-10-13 $18.08 First-Class Package Service 2 0.38 lbs $4.10 $2.66 $1.44
204310 2018-10-13 $6.60 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204311 2018-10-13 $6.60 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204314 2018-10-13 $77.31 Priority Mail 2-Day Flat Rate Envelope 4 1.90 lbs $7.40 $6.85 $0.55
204317 2018-10-14 $44.96 Priority Mail 3-Day Flat Rate Envelope 4 0.94 lbs $7.40 $6.85 $0.55
204320 2018-10-14 $295.03 Direct Link International 27 12.90 lbs $77.50 $17.22 $60.28
204324 2018-10-14 $7.68 First-Class Package Service 3 0.05 lbs $3.71 $2.66 $1.05
204325 2018-10-15 $46.72 Priority Mail 2-Day 43 1.21 lbs $11.65 $7.53 $4.12
204326 2018-10-15 $75.08 Direct Link International 3 1.92 lbs $29.51 $47.12 $-17.61
204327 2018-10-15 $81.82 Priority Mail 2-Day Medium Flat Rate Box 3 2.00 lbs $13.85 $6.85 $7.00
204328 2018-10-15 $33.27 Priority Mail 2-Day 7 0.91 lbs $11.14 $9.98 $1.16
204338 2018-10-16 $37.13 First-Class Mail Large Envelope 10 0.53 lbs $11.43 $6.98 $4.45
204339 2018-10-16 $6.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
204340 2018-10-16 $19.15 First-Class Package Service 6 0.62 lbs $4.71 $4.38 $0.33
204342 2018-10-17 $37.69 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
204344 2018-10-17 $6.20 First-Class Package Service 1 0.20 lbs $3.71 $3.05 $0.66
204347 2018-10-17 $15.63 First-Class Package Service 1 0.25 lbs $3.84 $2.92 $0.92
204349 2018-10-18 $23.95 First-Class Mail Large Envelope 1 0.60 lbs $4.66 $4.10 $0.56
204350 2018-10-18 $59.12 First-Class Package International Service 1 1.30 lbs $30.33 $22.33 $8.00
204352 2018-10-18 $26.09 First-Class Package Service 1 0.40 lbs $4.10 $3.82 $0.28
204355 2018-10-18 $7.20 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
204358 2018-10-18 $7.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204360 2018-10-19 $8.60 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204361 2018-10-19 $7.19 First-Class Package Service 2 0.08 lbs $3.71 $2.66 $1.05
204363 2018-10-20 $22.26 First-Class Package Service 1 0.30 lbs $3.97 $3.18 $0.79
204367 2018-10-20 $59.28 Priority Mail 3-Day 4 2.27 lbs $9.32 $7.40 $1.92
204371 2018-10-21 $6.20 First-Class Package Service 1 0.20 lbs $3.71 $6.10 $-2.39
204372 2018-10-21 $5.69 First-Class Package Service 2 0.08 lbs $3.71 $2.66 $1.05
204373 2018-10-22 $70.90 Priority Mail 2-Day Medium Flat Rate Box 35 1.85 lbs $13.85 $10.80 $3.05
204412 2018-10-27 $64.34 Direct Link International 1 1.50 lbs $23.85 $19.36 $4.49
204413 2018-10-27 $64.34 Direct Link International 1 1.50 lbs $23.85 $20.51 $3.34
204414 2018-10-27 $64.34 Direct Link International 1 1.50 lbs $23.85 $20.00 $3.85
204415 2018-10-27 $64.14 Direct Link International 1 1.45 lbs $23.65 $20.16 $3.49
204416 2018-10-27 $68.29 Direct Link International 2 1.45 lbs $23.65 $19.82 $3.83
204417 2018-10-27 $64.34 Direct Link International 1 1.50 lbs $23.85 $20.51 $3.34
204418 2018-10-27 $64.14 Direct Link International 1 1.45 lbs $23.65 $20.85 $2.80
204430 2018-10-27 $98.89 Priority Mail 2-Day 32 6.24 lbs $31.21 $26.23 $4.98
204435 2018-10-28 $226.86 Direct Link International 6 10.74 lbs $89.97 $165.38 $-75.41
204438 2018-10-29 $95.58 Direct Link International 2 2.70 lbs $29.60 $27.05 $2.55
204439 2018-10-29 $84.91 Direct Link International 3 2.58 lbs $29.14 $27.22 $1.92
204440 2018-10-29 $84.91 Direct Link International 3 2.58 lbs $29.14 $26.88 $2.26
204442 2018-10-29 $101.36 Direct Link International 4 2.64 lbs $34.80 $27.22 $7.58
204443 2018-10-29 $105.19 Direct Link International 5 1.15 lbs $22.49 $30.42 $-7.93
204444 2018-10-29 $114.02 Direct Link International 4 2.00 lbs $28.06 $25.31 $2.75
204445 2018-10-29 $64.34 Direct Link International 1 1.50 lbs $23.85 $20.16 $3.69
204447 2018-10-29 $60.35 Priority Mail 3-Day Small Flat Rate Box 5 1.59 lbs $7.90 $6.85 $1.05
204458 2018-10-29 $28.41 First-Class Package Service 2 1.06 lbs $5.43 $4.94 $0.49
204459 2018-10-29 $20.44 Priority Mail 2-Day 1 0.95 lbs $11.65 $10.48 $1.17
204464 2018-10-30 $44.99 Priority Mail 2-Day Medium Flat Rate Box 26 2.10 lbs $13.85 $10.80 $3.05
204468 2018-10-30 $103.36 Priority Mail 2-Day 7 3.17 lbs $15.03 $9.47 $5.56
204469 2018-10-30 $29.82 Priority Mail 3-Day 2 0.99 lbs $9.00 $7.91 $1.09
204470 2018-10-31 $47.24 First-Class Package Service 10 0.79 lbs $5.15 $4.38 $0.77
204471 2018-10-31 $6.71 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204472 2018-10-26 $252.14 Priority Mail International 24 5.25 lbs $82.26 $58.38 $23.88
204474 2018-10-31 $19.59 First-Class Package Service 1 0.35 lbs $4.10 $3.18 $0.92
204475 2018-11-01 $7.20 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
204478 2018-11-01 $9.70 First-Class Package Service 1 0.27 lbs $4.71 $3.66 $1.05
204479 2018-11-01 $64.53 Direct Link International 1 1.55 lbs $24.04 $33.48 $-9.44
204483 2018-11-02 $71.63 Direct Link International 2 1.55 lbs $23.85 $32.82 $-8.97
204484 2018-11-02 $9.60 First-Class Package Service 1 0.55 lbs $5.71 $4.66 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56