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
203313 2018-06-23 $17.79 Priority Mail 3-Day 1 0.95 lbs $9.00 $7.91 $1.09
203316 2018-06-24 $37.69 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
203319 2018-06-27 $63.36 First-Class Package International Service 2 1.60 lbs $23.18 $22.33 $0.85
203320 2018-06-27 $104.32 First-Class Package International Service 4 2.07 lbs $33.86 $33.01 $0.85
203321 2018-06-27 $73.66 First-Class Package International Service 2 1.80 lbs $23.18 $33.01 $-9.83
203322 2018-06-27 $78.16 First-Class Package International Service 2 1.70 lbs $23.18 $33.01 $-9.83
203323 2018-06-27 $84.66 First-Class Package International Service 2 1.85 lbs $23.18 $33.01 $-9.83
203324 2018-06-27 $72.34 First-Class Package International Service 4 1.65 lbs $23.18 $22.33 $0.85
203325 2018-06-27 $63.67 First-Class Package International Service 1 1.50 lbs $23.18 $22.33 $0.85
203326 2018-06-27 $63.67 First-Class Package International Service 1 1.55 lbs $23.18 $22.33 $0.85
203327 2018-06-27 $276.21 Priority Mail International 2 14.45 lbs $94.43 $48.93 $45.50
203328 2018-06-27 $89.63 First-Class Package International Service 3 2.58 lbs $33.86 $48.93 $-15.07
203329 2018-06-27 $89.63 First-Class Package International Service 3 2.58 lbs $33.86 $33.01 $0.85
203330 2018-06-27 $94.34 First-Class Package International Service 2 2.30 lbs $33.86 $48.93 $-15.07
203331 2018-06-27 $113.15 First-Class Package International Service 3 1.35 lbs $23.18 $22.33 $0.85
203332 2018-06-27 $62.84 First-Class Package International Service 4 1.73 lbs $23.18 $33.96 $-10.78
203333 2018-06-27 $7.19 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
203334 2018-06-27 $42.58 Priority Mail 2-Day Small Flat Rate Box 2 1.20 lbs $7.90 $6.85 $1.05
203335 2018-06-27 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
203336 2018-06-28 $141.33 Priority Mail 2-Day 2 10.35 lbs $16.95 $15.62 $1.33
203337 2018-06-28 $20.68 First-Class Package Service 3 0.65 lbs $5.51 $4.94 $0.57
203338 2018-06-28 $7.51 First-Class Mail Large Envelope 2 0.34 lbs $3.53 $3.82 $-0.29
203339 2018-06-28 $9.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
203340 2018-06-28 $15.54 First-Class Package Service 1 0.40 lbs $4.55 $3.66 $0.89
203341 2018-06-28 $62.98 Priority Mail 3-Day Medium Flat Rate Box 2 1.95 lbs $13.70 $10.29 $3.41
203342 2018-06-28 $41.08 First-Class Package Service 3 0.80 lbs $5.71 $4.94 $0.77
203345 2018-06-29 $30.59 Priority Mail 2-Day 2 1.90 lbs $13.01 $9.19 $3.82
203346 2018-06-29 $45.18 Priority Mail 3-Day Flat Rate Envelope 2 1.70 lbs $7.40 $6.90 $0.50
203347 2018-06-30 $11.69 First-Class Package Service 2 0.18 lbs $3.71 $2.79 $0.92
203348 2018-07-01 $8.69 First-Class Package Service 2 0.10 lbs $3.71 $2.66 $1.05
203354 2018-07-01 $73.69 Priority Mail 3-Day Medium Flat Rate Box 7 5.15 lbs $13.85 $12.45 $1.40
203356 2018-07-01 $7.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
203359 2018-07-02 $40.99 Priority Mail 2-Day 1 0.75 lbs $9.00 $7.91 $1.09
203360 2018-07-02 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
203361 2018-07-02 $10.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
203362 2018-07-02 $30.21 First-Class Package Service 2 0.42 lbs $4.23 $3.50 $0.73
203363 2018-07-02 $33.41 First-Class Package Service 6 0.28 lbs $3.97 $3.18 $0.79
203365 2018-07-02 $15.13 First-Class Package Service 2 0.68 lbs $5.15 $4.94 $0.21
203366 2018-07-02 $77.26 Priority Mail 3-Day 6 1.75 lbs $9.00 $7.91 $1.09
203368 2018-07-03 $41.43 First-Class Package Service 2 0.55 lbs $4.55 $3.82 $0.73
203369 2018-07-04 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
203371 2018-07-04 $14.67 First-Class Package Service 4 0.16 lbs $3.71 $2.66 $1.05
203372 2018-07-04 $55.68 Priority Mail 2-Day 6 1.21 lbs $11.14 $9.98 $1.16
203376 2018-07-04 $5.96 First-Class Package Service 1 0.17 lbs $3.97 $3.18 $0.79
203377 2018-07-04 $27.56 Priority Mail 2-Day 5 1.70 lbs $13.01 $9.19 $3.82
203380 2018-07-05 $35.43 Priority Mail 3-Day 2 0.96 lbs $11.65 $10.48 $1.17
203383 2018-07-05 $37.69 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $7.90 $6.85 $1.05
203386 2018-07-06 $23.14 First-Class Package Service 6 1.14 lbs $10.60 $4.94 $5.66
203388 2018-07-06 $41.81 Priority Mail 2-Day 3 3.16 lbs $9.54 $8.43 $1.11
203393 2018-07-06 $85.93 Priority Mail 2-Day 8 1.86 lbs $13.01 $11.80 $1.21
203396 2018-07-06 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
203397 2018-07-06 $10.19 First-Class Package Service 2 0.12 lbs $3.71 $2.66 $1.05
203401 2018-07-07 $23.96 First-Class Package Service 1 0.60 lbs $4.67 $4.66 $0.01
203403 2018-07-07 $3.97 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
203406 2018-07-07 $6.69 First-Class Package Service 2 0.03 lbs $3.71 $2.66 $1.05
203407 2018-07-07 $20.93 First-Class Package Service - Retail 2 0.40 lbs $4.95 $3.82 $1.13
203409 2018-07-07 $16.64 First-Class Package Service 7 0.19 lbs $3.71 $2.79 $0.92
203410 2018-07-07 $173.81 Priority Mail 3-Day 11 6.29 lbs $20.92 $12.45 $8.47
203411 2018-07-08 $60.45 Priority Mail 2-Day Flat Rate Envelope 10 1.12 lbs $7.40 $6.89 $0.51
203416 2018-07-08 $6.31 First-Class Package Service - Retail 4 0.04 lbs $4.35 $2.66 $1.69
203417 2018-07-08 $41.02 Priority Mail 3-Day 3 1.30 lbs $8.25 $7.40 $0.85
203419 2018-07-08 $7.20 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
203421 2018-07-08 $203.86 Priority Mail 3-Day 5 11.95 lbs $17.71 $17.22 $0.49
203423 2018-07-08 $31.58 Priority Mail 2-Day 2 1.90 lbs $14.00 $12.76 $1.24
203429 2018-07-09 $41.36 First-Class Package Service 3 0.85 lbs $5.99 $4.94 $1.05
203430 2018-07-09 $194.55 Priority Mail International 3 9.10 lbs $86.18 $83.03 $3.15
203431 2018-07-09 $61.04 First-Class Package International Service 9 1.14 lbs $27.33 $22.33 $5.00
203432 2018-07-09 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
203433 2018-07-10 $66.63 Priority Mail 3-Day 9 1.30 lbs $10.32 $9.19 $1.13
203439 2018-07-10 $72.18 Priority Mail 3-Day 4 2.00 lbs $9.32 $7.40 $1.92
203440 2018-07-10 $10.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
203441 2018-07-10 $6.19 First-Class Package Service 2 0.08 lbs $3.71 $2.66 $1.05
203442 2018-07-10 $29.00 First-Class Package Service 5 0.54 lbs $4.55 $3.66 $0.89
203443 2018-07-10 $44.81 Priority Mail 2-Day 1 2.20 lbs $13.01 $9.47 $3.54
203444 2018-07-10 $13.61 First-Class Package Service 10 0.04 lbs $3.71 $2.66 $1.05
203446 2018-07-10 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
203447 2018-07-11 $48.24 First-Class Package International Service 6 0.21 lbs $14.50 $9.50 $5.00
203450 2018-07-12 $7.45 First-Class Package Service 2 0.03 lbs $3.97 $2.66 $1.31
203451 2018-07-12 $25.69 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.35 $1.05
203452 2018-07-12 $33.37 Priority Mail 3-Day Flat Rate Envelope 3 0.83 lbs $7.40 $6.90 $0.50
203454 2018-07-12 $35.87 Priority Mail 3-Day 14 2.04 lbs $13.01 $9.47 $3.54
203455 2018-07-12 $63.09 Priority Mail 2-Day Flat Rate Envelope 11 1.41 lbs $7.40 $6.85 $0.55
203457 2018-07-12 $64.26 Priority Mail 3-Day 6 1.20 lbs $10.32 $9.19 $1.13
203459 2018-07-12 $29.09 First-Class Package Service 1 0.00 lbs $4.10 $3.18 $0.92
203460 2018-07-13 $64.86 First-Class Package Service 1 0.70 lbs $4.87 $4.38 $0.49
203461 2018-07-13 $33.18 First-Class Package Service 11 0.60 lbs $4.71 $3.66 $1.05
203463 2018-07-13 $19.11 Priority Mail 3-Day 1 0.95 lbs $10.32 $9.19 $1.13
203466 2018-07-13 $24.11 Priority Mail 3-Day Small Flat Rate Box 1 0.90 lbs $7.90 $6.85 $1.05
203469 2018-07-13 $215.79 Priority Mail International 25 7.03 lbs $77.54 $66.88 $10.66
203472 2018-07-13 $319.67 Priority Mail International 34 7.93 lbs $68.51 $58.81 $9.70
203478 2018-07-13 $48.88 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $7.40 $6.90 $0.50
203479 2018-07-13 $32.54 First-Class Package International Service 1 0.30 lbs $18.54 $13.54 $5.00
203485 2018-07-14 $18.42 First-Class Package Service 8 0.26 lbs $4.10 $4.10 $0.00
203486 2018-07-14 $12.28 First-Class Package Service 3 0.14 lbs $3.71 $2.79 $0.92
203490 2018-07-15 $13.35 First-Class Package Service 4 0.80 lbs $5.79 $4.94 $0.85
203492 2018-07-15 $17.69 First-Class Package Service 2 0.20 lbs $3.71 $2.92 $0.79
203494 2018-07-15 $8.90 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
203497 2018-07-16 $71.49 Priority Mail 2-Day 1 3.60 lbs $11.50 $10.33 $1.17
203501 2018-07-16 $22.94 First-Class Package International Service 6 0.07 lbs $14.50 $9.50 $5.00
203502 2018-07-16 $105.45 First-Class Package International Service 15 1.49 lbs $20.20 $15.20 $5.00
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56