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
205432 2019-01-18 $93.01 Priority Mail 2-Day 5 3.96 lbs $19.32 $20.42 $-1.10
205433 2019-01-18 $14.18 First-Class Package Service 1 0.30 lbs $3.97 $3.18 $0.79
205434 2019-01-18 $62.87 Priority Mail 2-Day Flat Rate Envelope 3 1.97 lbs $7.40 $7.55 $-0.15
205436 2019-01-18 $45.56 First-Class Package Service 3 0.70 lbs $5.79 $4.94 $0.85
205437 2019-01-18 $30.28 Priority Mail 2-Day Flat Rate Envelope 2 0.96 lbs $7.40 $6.90 $0.50
205438 2019-01-18 $21.58 First-Class Package Service 2 0.34 lbs $4.10 $3.18 $0.92
205447 2019-01-18 $21.29 First-Class Package Service 5 0.25 lbs $4.54 $3.49 $1.05
205451 2019-01-19 $21.35 Priority Mail 2-Day Flat Rate Envelope 5 0.30 lbs $7.40 $6.85 $0.55
205452 2019-01-19 $15.64 First-Class Package Service 4 0.14 lbs $3.71 $2.79 $0.92
205453 2019-01-19 $25.69 Priority Mail 2-Day Flat Rate Envelope 1 0.30 lbs $7.40 $6.85 $0.55
205454 2019-01-19 $47.98 Priority Mail 2-Day Flat Rate Envelope 2 1.60 lbs $7.40 $6.85 $0.55
205455 2019-01-19 $10.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
205456 2019-01-19 $28.35 Priority Mail 2-Day Small Flat Rate Box 5 0.26 lbs $7.90 $6.85 $1.05
205457 2019-01-19 $19.65 First-Class Package Service 6 0.60 lbs $4.71 $2.79 $1.92
205458 2019-01-20 $15.96 First-Class Package Service 1 0.28 lbs $3.97 $3.18 $0.79
205459 2019-01-20 $8.06 First-Class Package Service 1 0.05 lbs $3.71 $2.96 $0.75
205460 2019-01-20 $33.04 Priority Mail 2-Day 1 2.50 lbs $8.05 $6.98 $1.07
205461 2019-01-20 $16.29 First-Class Package Service 5 0.27 lbs $3.84 $2.66 $1.18
205463 2019-01-20 $37.69 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
205466 2019-01-20 $42.55 Priority Mail 3-Day 4 10.60 lbs $11.19 $9.26 $1.93
205467 2019-01-21 $7.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
205468 2019-01-21 $25.28 First-Class Package Service 1 1.00 lbs $5.99 $6.85 $-0.86
205469 2019-01-21 $20.15 First-Class Package Service 4 0.48 lbs $4.39 $2.66 $1.73
205471 2019-01-21 $9.67 First-Class Package Service 4 0.08 lbs $3.71 $2.66 $1.05
205472 2019-01-21 $61.19 Priority Mail 2-Day 2 1.90 lbs $10.11 $8.15 $1.96
205473 2019-01-14 $59.28 Priority Mail 2-Day 2 2.40 lbs $0.00 $8.22 $-8.22
205474 2019-01-21 $53.30 Priority Mail 2-Day 5 1.65 lbs $8.25 $7.18 $1.07
205475 2019-01-21 $51.15 Direct Link International 15 2.49 lbs $29.09 $27.56 $1.53
205476 2019-01-21 $51.84 Direct Link International 16 2.51 lbs $24.28 $24.28 $0.00
205480 2019-01-21 $15.59 First-Class Package Service 6 0.20 lbs $4.54 $3.63 $0.91
205481 2019-01-21 $60.31 Priority Mail 2-Day 1 1.17 lbs $10.32 $9.47 $0.85
205482 2019-01-22 $6.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
205483 2019-01-22 $135.45 Priority Mail 2-Day 3 6.50 lbs $22.90 $21.39 $1.51
205484 2019-01-22 $50.33 Priority Mail 3-Day 7 1.48 lbs $9.00 $8.15 $0.85
205486 2019-01-22 $43.98 Priority Mail 2-Day Flat Rate Envelope 2 1.75 lbs $7.40 $6.90 $0.50
205487 2019-01-22 $13.69 First-Class Package Service 2 0.20 lbs $3.71 $2.66 $1.05
205490 2019-01-23 $47.03 First-Class Package Service 6 0.80 lbs $4.54 $5.24 $-0.70
205492 2019-01-23 $68.03 Priority Mail 2-Day Medium Flat Rate Box 42 2.39 lbs $13.85 $10.80 $3.05
205493 2019-01-23 $69.96 Priority Mail 2-Day 32 3.62 lbs $21.88 $20.40 $1.48
205495 2019-01-23 $15.76 First-Class Package Service 1 0.35 lbs $3.97 $3.18 $0.79
205496 2019-01-23 $26.34 Priority Mail 2-Day 6 1.50 lbs $9.00 $7.91 $1.09
205497 2019-01-23 $57.30 Direct Link International 20 3.23 lbs $85.73 $46.96 $38.77
205498 2019-01-23 $24.77 First-Class Package Service 2 0.50 lbs $4.39 $4.19 $0.20
205499 2019-01-24 $233.29 Priority Mail International 1 14.30 lbs $124.90 $122.60 $2.30
205500 2019-01-24 $45.78 Priority Mail 3-Day Small Flat Rate Box 2 1.70 lbs $7.90 $6.85 $1.05
205501 2019-01-24 $9.03 First-Class Package Service 1 0.23 lbs $3.84 $3.34 $0.50
205503 2019-01-24 $55.18 Priority Mail 2-Day Flat Rate Envelope 2 1.60 lbs $7.40 $7.50 $-0.10
205507 2019-01-25 $81.79 Ground Home Delivery 2 2.70 lbs $12.65 $7.49 $5.16
205509 2019-01-25 $62.38 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $7.40 $6.90 $0.50
205510 2019-01-25 $27.11 First-Class Package Service 4 1.95 lbs $7.40 $6.85 $0.55
205511 2019-01-25 $14.61 First-Class Package Service 3 0.11 lbs $4.14 $2.66 $1.48
205512 2019-01-25 $18.27 First-Class Package Service 1 0.30 lbs $4.27 $3.18 $1.09
205513 2019-01-17 $9.49 Priority Mail 2-Day Flat Rate Envelope 1 0.25 lbs $4.23 $7.50 $-3.27
205514 2019-01-25 $23.29 First-Class Mail Large Envelope 1 0.95 lbs $4.00 $5.12 $-1.12
205519 2019-01-25 $15.64 First-Class Package Service 7 0.36 lbs $5.11 $3.05 $2.06
205522 2019-01-25 $17.19 First-Class Package Service 4 0.92 lbs $6.43 $4.94 $1.49
205524 2019-01-25 $36.23 Priority Mail 2-Day 12 0.47 lbs $10.55 $7.82 $2.73
205532 2019-01-26 $19.00 First-Class Package Service 4 0.38 lbs $4.54 $3.49 $1.05
205533 2019-01-26 $41.14 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
205538 2019-01-26 $9.78 First-Class Package Service 3 0.03 lbs $3.81 $2.76 $1.05
205539 2019-01-26 $10.88 First-Class Package Service 1 0.07 lbs $3.89 $2.84 $1.05
205542 2019-01-27 $5.99 First-Class Package Service 2 0.04 lbs $4.01 $3.49 $0.52
205546 2019-01-27 $7.90 First-Class Package Service 3 0.03 lbs $3.75 $2.70 $1.05
205547 2019-01-27 $17.81 First-Class Package Service 8 0.18 lbs $3.89 $2.84 $1.05
205548 2019-01-27 $38.14 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
205550 2019-01-27 $32.87 Priority Mail 2-Day Flat Rate Envelope 3 0.95 lbs $7.80 $7.50 $0.30
205551 2019-01-27 $20.10 First-Class Package Service 4 0.20 lbs $4.14 $3.09 $1.05
205553 2019-01-27 $67.01 Priority Mail 2-Day 2 1.80 lbs $8.73 $8.12 $0.61
205555 2019-01-28 $38.74 Priority Mail 2-Day 7 1.46 lbs $11.71 $10.86 $0.85
205557 2019-01-28 $43.17 Priority Mail 2-Day Flat Rate Envelope 3 1.35 lbs $7.80 $7.55 $0.25
205558 2019-01-28 $12.75 First-Class Package Service 2 0.80 lbs $5.97 $5.12 $0.85
205560 2019-01-28 $114.47 Priority Mail 3-Day 7 2.79 lbs $10.11 $8.76 $1.35
205561 2019-01-28 $5.99 First-Class Package Service 2 0.10 lbs $4.01 $3.49 $0.52
205562 2019-01-28 $19.74 First-Class Package Service 10 0.20 lbs $3.71 $2.66 $1.05
205566 2019-01-30 $24.53 First-Class Package Service 1 0.40 lbs $4.54 $4.19 $0.35
205568 2019-01-30 $20.22 Priority Mail 2-Day 3 1.05 lbs $10.55 $9.70 $0.85
205570 2019-01-30 $8.90 First-Class Package Service 1 0.05 lbs $4.01 $2.96 $1.05
205571 2019-01-30 $0.00 Priority Mail 2-Day 11 3.00 lbs $9.66 $8.81 $0.85
205572 2019-01-30 $8.87 Priority Mail 3-Day Small Flat Rate Box 5 1.12 lbs $8.35 $7.50 $0.85
205575 2019-01-31 $79.59 Priority Mail 2-Day 4 1.92 lbs $16.13 $15.28 $0.85
205576 2019-01-31 $23.80 Priority Mail 2-Day Small Flat Rate Box 4 0.16 lbs $8.35 $3.63 $4.72
205577 2019-01-31 $8.65 First-Class Package Service 10 0.10 lbs $3.75 $2.70 $1.05
205581 2019-01-31 $14.48 First-Class Package Service 1 0.25 lbs $4.27 $3.22 $1.05
205582 2019-01-31 $23.17 First-Class Package International Service 1 0.07 lbs $17.98 $9.98 $8.00
205586 2019-01-31 $24.65 First-Class Package Service 6 0.47 lbs $5.11 $4.06 $1.05
205588 2019-02-01 $51.15 Direct Link International 16 2.67 lbs $26.89 $28.45 $-1.56
205589 2019-02-01 $51.84 Direct Link International 16 2.51 lbs $27.26 $27.26 $0.00
205590 2019-01-30 $4.99 Priority Mail 2-Day 1 0.30 lbs $0.00 $7.50 $-7.50
205591 2019-02-01 $24.28 First-Class Package Service 5 0.42 lbs $4.33 $3.96 $0.37
205592 2019-01-25 $29.14 Priority Mail 2-Day 6 1.20 lbs $0.00 $12.80 $-12.80
205593 2019-02-01 $11.13 First-Class Mail Large Envelope 6 0.60 lbs $4.15 $5.53 $-1.38
205595 2019-02-01 $18.08 First-Class Package Service 1 0.68 lbs $6.09 $5.24 $0.85
205597 2019-02-01 $12.80 First-Class Package Service 1 0.05 lbs $4.01 $2.96 $1.05
205598 2019-02-01 $43.30 Priority Mail 3-Day 9 1.95 lbs $9.19 $8.34 $0.85
205599 2019-02-01 $36.79 Priority Mail 3-Day Flat Rate Envelope 1 1.10 lbs $7.80 $7.50 $0.30
205601 2019-02-01 $43.48 Priority Mail 3-Day 12 3.01 lbs $14.60 $13.75 $0.85
205602 2019-02-02 $15.00 First-Class Package Service 1 0.19 lbs $5.01 $5.12 $-0.11
205603 2019-02-02 $31.38 First-Class Mail Large Envelope 1 0.58 lbs $4.00 $4.33 $-0.33
205604 2019-02-02 $37.32 First-Class Package International Service 2 0.19 lbs $21.54 $22.80 $-1.26
205606 2019-02-02 $16.49 Priority Mail 2-Day 1 0.65 lbs $8.50 $7.65 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56