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
209371 2020-01-14 $50.67 Priority Mail 3-Day Flat Rate Envelope 3 1.65 lbs $7.80 $7.50 $0.30
209372 2020-01-15 $11.64 First-Class Package Service 1 0.20 lbs $3.75 $3.22 $0.53
209378 2020-01-15 $33.81 Priority Mail 2-Day Small Flat Rate Box 1 1.10 lbs $8.35 $7.50 $0.85
209379 2020-01-15 $23.78 Priority Mail 3-Day Flat Rate Envelope 2 0.35 lbs $7.80 $7.82 $-0.02
209380 2020-01-15 $21.59 First-Class Package Service 2 0.16 lbs $4.01 $3.05 $0.96
209383 2020-01-15 $37.99 Priority Mail 2-Day 1 0.75 lbs $8.50 $7.65 $0.85
209384 2020-01-15 $14.06 First-Class Package Service 1 0.35 lbs $4.27 $3.88 $0.39
209386 2020-01-15 $87.67 Priority Mail 3-Day Medium Flat Rate Box 1 10.70 lbs $14.05 $10.00 $4.05
209387 2020-01-15 $142.32 Priority Mail 2-Day 2 4.40 lbs $14.54 $9.39 $5.15
209388 2020-01-15 $12.18 First-Class Package Service 3 0.18 lbs $3.81 $3.28 $0.53
209390 2020-01-15 $6.34 First-Class Package Service 5 0.05 lbs $3.89 $2.84 $1.05
209392 2020-01-15 $190.37 Ground 6 8.15 lbs $29.34 $22.87 $6.47
209396 2020-01-15 $38.62 Priority Mail 2-Day 5 1.31 lbs $8.73 $7.50 $1.23
209398 2020-01-16 $22.76 First-Class Package Service 2 1.00 lbs $6.58 $7.55 $-0.97
209400 2020-01-16 $31.26 First-Class Package Service 3 0.42 lbs $6.29 $4.18 $2.11
209402 2020-01-16 $261.76 Priority Mail 3-Day 1 14.40 lbs $28.92 $29.44 $-0.52
209405 2020-01-16 $51.34 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.35 $7.50 $0.85
209408 2020-01-16 $12.19 Priority Mail 3-Day Flat Rate Envelope 1 0.04 lbs $7.80 $7.50 $0.30
209409 2020-01-16 $16.33 First-Class Package Service 1 0.30 lbs $4.54 $4.32 $0.22
209414 2020-01-17 $26.98 First-Class Package International Service 1 0.07 lbs $21.79 $13.54 $8.25
209415 2020-01-17 $10.25 Priority Mail 2-Day Flat Rate Envelope 5 0.05 lbs $7.80 $6.95 $0.85
209416 2020-01-17 $92.62 Priority Mail 2-Day Medium Flat Rate Box 3 3.65 lbs $14.05 $12.80 $1.25
209418 2020-01-17 $10.12 First-Class Package Service 2 0.07 lbs $4.14 $3.09 $1.05
209420 2020-01-17 $40.76 Priority Mail 3-Day Flat Rate Envelope 2 1.85 lbs $7.80 $7.55 $0.25
209421 2020-01-17 $17.72 Priority Mail 3-Day 1 0.95 lbs $8.73 $8.12 $0.61
209425 2020-01-17 $83.76 Priority Mail 2-Day 1 3.60 lbs $18.77 $17.92 $0.85
209427 2020-01-17 $15.25 First-Class Package Service 2 0.30 lbs $4.27 $5.02 $-0.75
209428 2020-01-17 $38.41 First-Class Package Service 6 0.72 lbs $5.87 $3.88 $1.99
209429 2020-01-18 $9.42 First-Class Package Service 2 0.34 lbs $5.04 $5.38 $-0.34
209432 2020-01-18 $37.84 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
209433 2020-01-18 $56.53 Priority Mail 2-Day 2 1.66 lbs $11.08 $10.23 $0.85
209434 2020-01-18 $10.29 First-Class Package Service 2 0.07 lbs $3.71 $2.66 $1.05
209435 2020-01-18 $42.74 Priority Mail 2-Day 1 1.05 lbs $9.35 $7.50 $1.85
209436 2020-01-18 $20.29 First-Class Package Service 12 0.22 lbs $4.41 $3.36 $1.05
209437 2020-01-18 $32.01 First-Class Package Service 3 0.53 lbs $5.24 $4.19 $1.05
209440 2020-01-19 $24.28 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.80 $7.55 $0.25
209441 2020-01-19 $7.50 First-Class Package Service 1 0.04 lbs $4.01 $2.96 $1.05
209442 2020-01-19 $20.99 Priority Mail 2-Day 1 1.15 lbs $8.27 $7.50 $0.77
209443 2020-01-19 $22.28 Priority Mail 2-Day 6 0.28 lbs $8.84 $7.99 $0.85
209445 2020-01-19 $323.91 Priority Mail 3-Day 5 20.00 lbs $23.55 $22.70 $0.85
209446 2020-01-19 $38.08 Priority Mail 2-Day Small Flat Rate Box 27 0.37 lbs $8.35 $7.50 $0.85
209449 2020-01-19 $155.11 Priority Mail 3-Day Medium Flat Rate Box 2 21.40 lbs $14.05 $13.20 $0.85
209450 2020-01-19 $37.14 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
209451 2020-01-19 $17.72 Priority Mail 2-Day 1 0.95 lbs $8.73 $8.12 $0.61
209452 2020-01-19 $18.09 Priority Mail 2-Day 1 0.40 lbs $9.10 $7.50 $1.60
209453 2020-01-19 $26.19 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.80 $7.55 $0.25
209459 2020-01-20 $38.67 First-Class Package Service 6 0.56 lbs $4.93 $3.88 $1.05
209462 2020-01-20 $9.13 First-Class Package Service 1 0.01 lbs $4.14 $3.18 $0.96
209463 2020-01-20 $28.97 Pickup From Store 2 0.70 lbs $0.00 $5.04 $-5.04
209464 2020-01-20 $79.04 Priority Mail 2-Day Medium Flat Rate Box 6 2.03 lbs $14.05 $10.85 $3.20
209465 2020-01-20 $20.74 Priority Mail 2-Day Flat Rate Envelope 6 0.16 lbs $7.80 $7.50 $0.30
209466 2020-01-20 $27.72 First-Class Package Service 1 0.50 lbs $6.23 $5.38 $0.85
209467 2020-01-20 $27.82 Priority Mail 1-Day 7 0.88 lbs $8.27 $7.42 $0.85
209468 2020-01-20 $7.24 First-Class Package Service 1 0.03 lbs $3.75 $2.70 $1.05
209469 2020-01-21 $10.18 First-Class Package Service 3 0.38 lbs $4.21 $4.06 $0.15
209471 2020-01-21 $56.35 Priority Mail 3-Day 2 2.21 lbs $12.65 $12.15 $0.50
209473 2020-01-21 $37.93 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.35 $7.50 $0.85
209474 2020-01-21 $40.55 First-Class Package Service 2 0.75 lbs $5.97 $8.50 $-2.53
209478 2020-01-21 $13.57 First-Class Package Service 11 0.32 lbs $4.68 $3.09 $1.59
209479 2020-01-21 $20.56 First-Class Package Service 1 0.41 lbs $4.27 $3.22 $1.05
209480 2020-01-21 $28.48 Priority Mail 2-Day 1 1.15 lbs $9.35 $8.50 $0.85
209481 2020-01-21 $29.07 Priority Mail 3-Day 7 1.75 lbs $8.84 $7.99 $0.85
209484 2020-01-21 $13.03 Priority Mail 2-Day Small Flat Rate Box 2 0.25 lbs $8.35 $7.50 $0.85
209485 2020-01-21 $6.68 First-Class Package Service 1 0.06 lbs $3.89 $2.84 $1.05
209486 2020-01-21 $84.55 First-Class Package International Service 5 2.00 lbs $39.60 $31.59 $8.01
209492 2020-01-21 $21.61 First-Class Package Service 1 0.45 lbs $4.33 $3.96 $0.37
209493 2020-01-21 $20.22 Priority Mail 2-Day 1 1.15 lbs $8.73 $7.50 $1.23
209494 2020-01-22 $54.04 Priority Mail 2-Day Small Flat Rate Box 1 1.60 lbs $8.35 $7.50 $0.85
209496 2020-01-22 $42.64 Priority Mail 2-Day 1 1.40 lbs $10.55 $7.50 $3.05
209497 2020-01-22 $8.80 First-Class Package Service 1 0.07 lbs $3.81 $2.76 $1.05
209502 2020-01-22 $60.09 Priority Mail 2-Day 2 1.95 lbs $10.11 $8.92 $1.19
209505 2020-01-22 $44.81 Priority Mail 3-Day 5 0.92 lbs $8.46 $7.65 $0.81
209507 2020-01-22 $19.83 First-Class Package Service 1 0.35 lbs $5.04 $4.32 $0.72
209508 2020-01-22 $80.77 Priority Mail 2-Day Medium Flat Rate Box 8 2.49 lbs $14.05 $12.10 $1.95
209509 2020-01-22 $9.08 First-Class Package Service 1 0.05 lbs $3.89 $2.84 $1.05
209510 2020-01-22 $5.88 First-Class Package Service 1 0.02 lbs $3.89 $2.84 $1.05
209513 2020-01-23 $18.04 Priority Mail 2-Day 6 0.84 lbs $9.10 $7.50 $1.60
209514 2020-01-23 $32.22 First-Class Package Service 1 0.18 lbs $3.73 $3.20 $0.53
209515 2020-01-23 $47.42 Priority Mail 3-Day 2 2.85 lbs $16.44 $15.12 $1.32
209516 2020-01-23 $9.00 First-Class Package Service 1 0.10 lbs $4.01 $2.96 $1.05
209518 2020-01-23 $33.25 First-Class Package Service 2 0.65 lbs $5.97 $5.12 $0.85
209519 2020-01-23 $39.46 First-Class Package Service 4 0.82 lbs $6.17 $5.27 $0.90
209522 2020-01-23 $13.94 First-Class Package Service 1 0.20 lbs $3.75 $2.70 $1.05
209523 2020-01-23 $6.34 First-Class Package Service 5 0.05 lbs $3.89 $2.84 $1.05
209526 2020-01-24 $95.48 Priority Mail 2-Day 3 2.68 lbs $19.31 $13.20 $6.11
209527 2020-01-24 $29.53 Priority Mail 3-Day 2 1.00 lbs $11.39 $10.23 $1.16
209528 2020-01-24 $76.85 Priority Mail 1-Day Large Flat Rate Box 6 1.37 lbs $32.35 $7.61 $24.74
209531 2020-01-24 $30.67 Priority Mail 3-Day 1 2.68 lbs $9.92 $8.81 $1.11
209532 2020-01-24 $37.29 Priority Mail 2-Day Small Flat Rate Box 1 1.05 lbs $8.50 $7.50 $1.00
209533 2020-01-24 $8.55 First-Class Package Service 1 0.22 lbs $4.36 $3.31 $1.05
209534 2020-01-24 $19.53 Priority Mail 2-Day 4 1.00 lbs $8.97 $8.12 $0.85
209536 2020-01-24 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.50 $1.00
209539 2020-01-24 $14.36 First-Class Package Service 3 0.09 lbs $3.89 $2.76 $1.13
209540 2020-01-24 $9.29 First-Class Package Service 1 0.06 lbs $4.10 $2.96 $1.14
209541 2020-01-24 $10.35 First-Class Package Service 4 0.08 lbs $3.89 $2.76 $1.13
209542 2020-01-24 $72.06 Standard 4 1.34 lbs $26.60 $24.54 $2.06
209546 2020-01-24 $37.61 First-Class Package Service 2 1.45 lbs $4.93 $5.27 $-0.34
209547 2020-01-25 $9.58 First-Class Package Service 2 0.08 lbs $4.10 $2.96 $1.14
209548 2020-01-25 $6.87 First-Class Package Service 1 0.10 lbs $3.98 $2.84 $1.14
209550 2020-01-25 $7.88 First-Class Package Service 1 0.06 lbs $3.89 $2.76 $1.13
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56