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
224494 2021-04-27 $73.58 2nd Day Air 6 0.32 lbs $32.28 $27.45 $4.83
224495 2021-04-27 $12.60 First-Class Package Service 1 0.20 lbs $4.71 $3.06 $1.65
224496 2021-04-27 $66.74 Priority Mail 2-Day Flat Rate Envelope 3 2.45 lbs $8.50 $8.00 $0.50
224497 2021-04-27 $10.29 First-Class Mail Stamped Letter 1 0.10 lbs $4.00 $3.49 $0.51
224498 2021-04-27 $15.26 First-Class Package Service 1 0.30 lbs $5.05 $3.85 $1.20
224501 2021-04-28 $71.46 Priority Mail 2-Day Padded Flat Rate Envelope 2 5.35 lbs $9.10 $8.00 $1.10
224502 2021-04-28 $23.49 Priority Mail 2-Day Flat Rate Envelope 1 0.80 lbs $8.50 $8.00 $0.50
224503 2021-04-28 $12.70 First-Class Package Service 6 0.07 lbs $4.26 $3.06 $1.20
224504 2021-04-28 $8.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.01 $0.79
224505 2021-04-28 $80.30 Priority Mail 2-Day 1 2.85 lbs $10.31 $9.21 $1.10
224506 2021-04-28 $64.13 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.80 lbs $9.10 $8.00 $1.10
224508 2021-04-28 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
224509 2021-04-28 $11.81 USPSFirstClass 2 0.10 lbs $4.63 $3.85 $0.78
224510 2021-04-28 $8.01 USPSFirstClass 1 0.07 lbs $4.62 $3.49 $1.13
224511 2021-04-28 $25.83 First-Class Package Service 2 0.33 lbs $5.05 $4.68 $0.37
224512 2021-04-28 $36.61 Priority Mail 2-Day 1 0.47 lbs $9.62 $7.90 $1.72
224515 2021-04-28 $57.26 Priority Mail 2-Day 2 1.40 lbs $9.82 $8.72 $1.10
224516 2021-04-28 $7.18 USPSFirstClass 1 0.05 lbs $4.39 $3.22 $1.17
224517 2021-04-28 $22.24 First-Class Package Service 1 0.60 lbs $5.48 $4.53 $0.95
224519 2021-04-28 $16.84 First-Class Package Service 1 0.30 lbs $5.05 $4.55 $0.50
224520 2021-04-28 $17.25 First-Class Package Service 1 0.05 lbs $4.26 $3.06 $1.20
224521 2021-04-28 $7.59 First-Class Mail Stamped Letter 1 0.06 lbs $3.80 $3.01 $0.79
224522 2021-04-28 $10.78 First-Class Mail Stamped Letter 2 0.06 lbs $3.80 $3.06 $0.74
224523 2021-04-28 $38.08 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $9.00 $7.90 $1.10
224524 2021-04-28 $38.79 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $9.00 $7.90 $1.10
224526 2021-04-29 $10.79 First-Class Mail Stamped Letter 1 0.09 lbs $4.00 $3.06 $0.94
224527 2021-04-29 $23.74 USPSFirstClass 3 0.14 lbs $13.27 $5.66 $7.61
224529 2021-04-29 $20.58 First-Class Mail Stamped Letter 2 0.08 lbs $3.80 $3.01 $0.79
224530 2021-04-29 $16.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.35 $0.45
224531 2021-04-29 $9.29 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.22 $0.58
224532 2021-04-29 $15.74 First-Class Package Service 3 0.30 lbs $4.77 $3.12 $1.65
224533 2021-04-29 $30.85 Priority Mail 3-Day 10 1.09 lbs $9.95 $8.85 $1.10
224534 2021-04-29 $168.07 Priority Mail 2-Day Flat Rate Envelope 3 5.06 lbs $8.50 $8.00 $0.50
224535 2021-04-29 $21.24 First-Class Package Service 3 0.30 lbs $4.77 $3.57 $1.20
224538 2021-04-29 $24.56 First-Class Package Service 1 0.60 lbs $5.07 $4.12 $0.95
224545 2021-04-29 $24.78 First-Class Package Service 1 0.35 lbs $4.89 $7.90 $-3.01
224547 2021-04-29 $23.37 First-Class Package Service 1 0.65 lbs $6.61 $4.38 $2.23
224548 2021-04-29 $27.39 Priority Mail 2-Day 1 2.56 lbs $15.90 $13.75 $2.15
224549 2021-04-29 $31.92 Priority Mail 2-Day 4 2.08 lbs $9.10 $7.83 $1.27
224550 2021-04-30 $13.58 First-Class Mail Stamped Letter 1 0.06 lbs $3.80 $3.01 $0.79
224551 2021-04-30 $12.51 First-Class Package Service 5 0.18 lbs $4.78 $3.22 $1.56
224553 2021-04-30 $14.39 First-Class Mail Stamped Letter 1 0.14 lbs $4.00 $3.12 $0.88
224554 2021-04-30 $14.99 First-Class Package Service 1 0.30 lbs $4.78 $3.58 $1.20
224555 2021-04-30 $7.18 USPSFirstClass 1 0.06 lbs $4.39 $3.22 $1.17
224556 2021-04-30 $7.76 USPSFirstClass 1 0.07 lbs $4.37 $3.12 $1.25
224557 2021-04-30 $8.16 USPSMedia 1 0.25 lbs $3.14 $2.89 $0.25
224558 2021-04-30 $18.93 USPSFirstClass 1 0.81 lbs $7.14 $8.00 $-0.86
224559 2021-04-30 $21.06 First-Class Package Service 1 0.40 lbs $5.07 $3.51 $1.56
224562 2021-04-30 $11.53 First-Class Package Service - Retail 2 0.07 lbs $5.55 $3.49 $2.06
224564 2021-04-30 $13.56 First-Class Mail Stamped Letter 4 0.04 lbs $3.60 $3.06 $0.54
224566 2021-04-30 $35.21 Priority Mail 3-Day 2 5.30 lbs $11.23 $10.13 $1.10
224567 2021-04-30 $8.16 USPSMedia 1 0.22 lbs $3.14 $2.89 $0.25
224569 2021-04-30 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
224570 2021-04-30 $15.89 Priority Mail 2-Day 1 0.05 lbs $9.90 $7.90 $2.00
224572 2021-04-30 $7.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.49 $0.31
224573 2021-04-30 $30.67 Priority Mail 3-Day Padded Flat Rate Envelope 1 2.25 lbs $9.10 $8.00 $1.10
224577 2021-04-30 $10.29 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $6.98 $-2.98
224578 2021-04-30 $18.04 First-Class Package Service 1 0.35 lbs $5.05 $3.85 $1.20
224579 2021-04-30 $36.21 First-Class Package Service 5 0.78 lbs $6.86 $5.66 $1.20
224580 2021-04-30 $94.63 Priority Mail 3-Day 3 2.20 lbs $15.20 $16.78 $-1.58
224582 2021-05-01 $92.03 Priority Mail 2-Day 4 2.60 lbs $13.80 $10.82 $2.98
224584 2021-05-01 $20.60 First-Class Package Service 3 0.41 lbs $5.63 $4.68 $0.95
224585 2021-05-01 $7.18 USPSFirstClass 1 0.06 lbs $4.39 $3.22 $1.17
224587 2021-05-01 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
224588 2021-05-01 $35.04 Priority Mail 2-Day 7 0.99 lbs $12.11 $11.01 $1.10
224589 2021-05-01 $15.82 USPSFirstClass 2 0.06 lbs $8.84 $3.22 $5.62
224591 2021-05-01 $34.16 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.20 lbs $9.10 $7.90 $1.20
224593 2021-05-01 $14.31 First-Class Package Service 1 0.08 lbs $4.32 $3.12 $1.20
224594 2021-05-01 $14.97 Priority Mail 2-Day Small Flat Rate Box 3 0.22 lbs $9.00 $7.90 $1.10
224595 2021-05-01 $43.86 First-Class Package Service 2 0.51 lbs $5.58 $4.38 $1.20
224596 2021-05-01 $14.18 First-Class Package Service 1 0.10 lbs $4.69 $3.49 $1.20
224599 2021-05-01 $25.97 First-Class Package Service 1 0.60 lbs $5.48 $5.81 $-0.33
224603 2021-05-01 $15.36 Priority Mail 2-Day Flat Rate Envelope 14 0.14 lbs $8.50 $8.80 $-0.30
224604 2021-05-02 $18.77 USPSFirstClass 4 0.80 lbs $10.01 $5.98 $4.03
224605 2021-05-01 $54.28 Priority Mail 3-Day 1 1.20 lbs $12.79 $11.69 $1.10
224606 2021-05-01 $35.09 Priority Mail 3-Day Padded Flat Rate Envelope 1 2.56 lbs $9.10 $8.00 $1.10
224608 2021-05-01 $16.27 First-Class Package Service 2 0.35 lbs $4.89 $3.69 $1.20
224609 2021-05-01 $9.28 First-Class Mail Stamped Letter 2 0.07 lbs $3.80 $3.35 $0.45
224610 2021-05-02 $238.51 Priority Mail 2-Day 1 24.50 lbs $43.09 $31.05 $12.04
224613 2021-05-02 $50.62 Priority Mail 3-Day 1 1.20 lbs $9.34 $8.24 $1.10
224615 2021-05-02 $29.26 Priority Mail 3-Day 1 0.60 lbs $8.77 $7.67 $1.10
224616 2021-05-02 $9.87 USPSFirstClass 2 0.12 lbs $4.29 $3.06 $1.23
224617 2021-05-02 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
224619 2021-05-02 $8.58 First-Class Mail Stamped Letter 2 0.04 lbs $3.60 $3.22 $0.38
224620 2021-05-02 $15.10 First-Class Package Service 1 0.30 lbs $4.89 $3.69 $1.20
224622 2021-05-02 $26.57 Priority Mail 2-Day 4 0.61 lbs $12.11 $8.52 $3.59
224624 2021-05-02 $61.54 Priority Mail 3-Day Flat Rate Envelope 2 2.00 lbs $8.50 $7.90 $0.60
224625 2021-05-02 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.22 $0.58
224626 2021-05-02 $9.59 First-Class Mail Stamped Letter 1 0.02 lbs $3.60 $3.06 $0.54
224627 2021-05-02 $32.83 First-Class Package Service 2 0.40 lbs $5.05 $4.68 $0.37
224628 2021-05-02 $21.28 Priority Mail 2-Day 2 0.16 lbs $9.90 $8.80 $1.10
224629 2021-05-02 $11.92 USPSFirstClass 3 0.45 lbs $5.95 $5.81 $0.14
224631 2021-05-03 $7.81 USPSFirstClass 1 0.03 lbs $4.32 $3.06 $1.26
224633 2021-05-02 $20.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.15 lbs $9.10 $7.90 $1.20
224634 2021-05-02 $30.52 Priority Mail 2-Day 2 1.23 lbs $11.54 $10.44 $1.10
224637 2021-05-02 $16.99 First-Class Package Service 6 0.25 lbs $5.05 $3.85 $1.20
224639 2021-05-02 $16.20 First-Class Package Service 1 0.30 lbs $4.71 $4.12 $0.59
224640 2021-05-02 $38.79 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $9.00 $7.90 $1.10
224641 2021-05-02 $38.79 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $9.00 $7.90 $1.10
224646 2021-05-03 $142.32 Priority Mail International 3 2.85 lbs $65.84 $60.94 $4.90
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56