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
212511 2020-05-28 $8.42 USPSFirstClass 1 0.08 lbs $4.15 $2.84 $1.31
212512 2020-05-28 $70.67 Priority Mail 2-Day Flat Rate Envelope 3 2.11 lbs $8.00 $7.65 $0.35
212513 2020-05-28 $53.31 Priority Mail 2-Day 4 1.75 lbs $11.39 $7.65 $3.74
212514 2020-05-28 $288.23 Priority Mail 2-Day 4 15.82 lbs $28.01 $33.84 $-5.83
212515 2020-05-29 $6.38 USPSFirstClass 1 0.01 lbs $4.04 $2.84 $1.20
212516 2020-05-29 $11.09 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $2.93 $0.57
212517 2020-05-29 $6.14 First-Class Mail Stamped Letter 1 0.06 lbs $3.35 $2.78 $0.57
212518 2020-05-29 $63.94 Priority Mail 2-Day 1 1.17 lbs $11.39 $10.54 $0.85
212519 2020-05-29 $17.98 Priority Mail 2-Day Flat Rate Envelope 2 0.20 lbs $8.00 $7.65 $0.35
212520 2020-05-29 $6.47 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $2.74 $0.46
212521 2020-05-29 $18.55 Priority Mail 3-Day Small Flat Rate Box 5 0.15 lbs $8.50 $7.65 $0.85
212522 2020-05-29 $142.60 Priority Mail 2-Day 2 2.06 lbs $13.00 $12.15 $0.85
212523 2020-04-20 $10.76 Pickup From Store 1 0.10 lbs $0.00 $2.74 $-2.74
212524 2020-05-29 $36.89 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
212528 2020-05-29 $18.38 Priority Mail 2-Day Flat Rate Envelope 2 0.30 lbs $8.00 $7.65 $0.35
212530 2020-05-29 $55.86 Priority Mail 3-Day 13 5.40 lbs $10.59 $16.89 $-6.30
212531 2020-05-29 $13.50 USPSFirstClass 1 0.18 lbs $4.32 $3.25 $1.07
212532 2020-05-29 $15.54 First-Class Package Service 2 0.26 lbs $3.56 $4.08 $-0.52
212533 2020-05-29 $24.89 Priority Mail 2-Day Flat Rate Envelope 1 0.25 lbs $8.00 $7.65 $0.35
212534 2020-05-29 $19.79 Priority Mail 2-Day Flat Rate Envelope 1 0.20 lbs $8.00 $7.65 $0.35
212535 2020-05-29 $13.53 USPSFirstClass 1 0.05 lbs $4.45 $4.18 $0.27
212536 2020-05-29 $6.34 First-Class Mail Stamped Letter 1 0.04 lbs $3.35 $3.05 $0.30
212537 2020-05-29 $35.00 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $8.50 $7.65 $0.85
212538 2020-05-29 $8.69 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $2.78 $0.72
212539 2020-05-29 $48.18 Priority Mail 3-Day 1 1.15 lbs $11.39 $10.54 $0.85
212540 2020-05-29 $5.34 First-Class Mail Stamped Letter 1 0.04 lbs $3.35 $2.93 $0.42
212541 2020-05-30 $24.40 USPSFirstClass 1 0.45 lbs $5.74 $4.32 $1.42
212542 2020-05-29 $26.84 Priority Mail 2-Day Flat Rate Envelope 1 0.35 lbs $8.00 $7.65 $0.35
212543 2020-05-29 $39.57 Priority Mail 2-Day 6 0.97 lbs $12.04 $11.18 $0.86
212544 2020-05-29 $10.49 Priority Mail 2-Day Small Flat Rate Box 1 0.19 lbs $8.50 $7.65 $0.85
212545 2020-05-30 $8.87 USPSFirstClass 1 0.45 lbs $5.18 $4.46 $0.72
212546 2020-05-30 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
212549 2020-05-30 $5.02 USPSFirstClass 1 0.02 lbs $3.95 $2.78 $1.17
212550 2020-05-30 $9.49 First-Class Package Service 1 0.13 lbs $3.50 $3.05 $0.45
212551 2020-05-30 $12.28 First-Class Mail Stamped Letter 2 0.15 lbs $6.70 $3.52 $3.18
212553 2020-05-26 $472.03 Ground 29 20.11 lbs $53.74 $29.57 $24.17
212554 2020-05-30 $10.32 First-Class Mail Stamped Letter 3 0.04 lbs $3.35 $2.84 $0.51
212555 2020-05-30 $14.12 USPSFirstClass 1 0.05 lbs $4.35 $2.78 $1.57
212556 2020-05-30 $82.89 Priority Mail 2-Day Padded Flat Rate Envelope 3 2.60 lbs $8.60 $7.65 $0.95
212557 2020-05-30 $281.95 Priority Mail 2-Day 6 23.38 lbs $29.73 $27.16 $2.57
212558 2020-05-31 $32.68 USPSFirstClass 1 0.95 lbs $10.60 $11.18 $-0.58
212559 2020-05-30 $8.46 First-Class Mail Stamped Letter 4 0.10 lbs $3.50 $3.05 $0.45
212560 2020-05-31 $12.43 USPSFirstClass 1 0.30 lbs $5.14 $3.39 $1.75
212561 2020-05-30 $16.97 Priority Mail 2-Day Flat Rate Envelope 3 0.13 lbs $8.00 $7.65 $0.35
212563 2020-05-30 $10.34 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $2.78 $0.57
212564 2020-05-31 $25.77 First-Class Package Service 10 0.75 lbs $5.37 $5.12 $0.25
212565 2020-05-31 $27.50 First-Class Package Service 7 0.54 lbs $5.37 $5.12 $0.25
212566 2020-05-31 $14.63 Pickup From Store 2 0.26 lbs $0.00 $3.21 $-3.21
212568 2020-05-31 $21.57 First-Class Package Service 1 0.25 lbs $4.25 $5.12 $-0.87
212569 2020-05-31 $17.55 USPSFirstClass 2 0.15 lbs $4.25 $3.31 $0.94
212570 2020-05-31 $39.77 Priority Mail 2-Day Flat Rate Envelope 3 1.11 lbs $8.00 $7.75 $0.25
212573 2020-05-31 $37.46 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.65 $0.35
212574 2020-05-31 $4.18 First-Class Mail Stamped Letter 2 0.02 lbs $3.20 $3.18 $0.02
212575 2020-06-01 $164.75 USPSFirstClass 28 7.60 lbs $82.18 $22.47 $59.71
212577 2020-05-31 $20.38 First-Class Package Service 2 0.21 lbs $3.50 $3.25 $0.25
212580 2020-06-01 $79.13 Priority Mail 2-Day 5 2.66 lbs $10.39 $8.92 $1.47
212581 2020-06-01 $14.49 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $2.93 $0.57
212582 2020-06-01 $63.58 Priority Mail 3-Day Padded Flat Rate Envelope 2 1.60 lbs $8.60 $7.65 $0.95
212584 2020-06-01 $42.63 First-Class Package Service - Retail 2 0.60 lbs $6.35 $9.98 $-3.63
212585 2020-06-01 $12.24 USPSFirstClass 1 0.19 lbs $4.40 $3.05 $1.35
212588 2020-06-01 $22.99 USPSFirstClass 5 0.15 lbs $4.87 $2.78 $2.09
212589 2020-06-01 $30.53 Priority Mail 2-Day 1 0.57 lbs $12.04 $8.42 $3.62
212590 2020-06-01 $17.98 Priority Mail 3-Day Flat Rate Envelope 2 0.88 lbs $8.00 $7.65 $0.35
212591 2020-06-01 $82.14 Priority Mail International Padded Flat Rate Envelope 1 1.65 lbs $36.45 $36.65 $-0.20
212592 2020-06-01 $9.14 First-Class Mail Stamped Letter 1 0.15 lbs $3.65 $2.78 $0.87
212593 2020-06-01 $6.39 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $2.84 $0.66
212594 2020-06-02 $8.30 USPSFirstClass 2 0.02 lbs $4.29 $3.18 $1.11
212595 2020-06-02 $42.98 USPSFirstClass 6 1.95 lbs $16.92 $9.54 $7.38
212596 2020-06-01 $34.60 Priority Mail 2-Day 1 1.05 lbs $9.61 $8.92 $0.69
212597 2020-06-02 $47.27 Priority Mail 2-Day Small Flat Rate Box 2 0.80 lbs $8.50 $7.65 $0.85
212598 2020-06-02 $8.54 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.05 $0.30
212599 2020-06-02 $47.63 Priority Mail 3-Day 1 1.15 lbs $10.84 $9.99 $0.85
212600 2020-06-02 $6.24 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.05 $0.30
212602 2020-06-02 $25.33 First-Class Mail Stamped Letter 2 0.04 lbs $3.35 $3.31 $0.04
212603 2020-06-02 $9.14 First-Class Mail Stamped Letter 1 0.15 lbs $3.65 $3.52 $0.13
212604 2020-06-02 $80.27 Priority Mail 1-Day Padded Flat Rate Envelope 2 5.40 lbs $8.60 $7.75 $0.85
212605 2020-06-02 $121.26 Ground 1 19.40 lbs $26.27 $23.77 $2.50
212606 2020-06-02 $9.28 First-Class Package Service 1 0.13 lbs $3.29 $3.31 $-0.02
212607 2020-06-02 $79.15 Priority Mail 2-Day 18 2.71 lbs $9.92 $9.07 $0.85
212609 2020-06-02 $7.34 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.78 $0.57
212610 2020-06-02 $239.18 Priority Mail 2-Day 1 13.15 lbs $29.19 $23.15 $6.04
212612 2020-06-02 $6.24 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.05 $0.30
212616 2020-06-02 $18.18 First-Class Package Service 1 0.35 lbs $4.57 $4.32 $0.25
212618 2020-06-02 $14.23 First-Class Mail Stamped Letter 2 0.15 lbs $6.85 $3.18 $3.67
212619 2020-06-03 $5.08 USPSFirstClass 1 0.01 lbs $4.00 $2.84 $1.16
212620 2020-06-02 $24.47 Priority Mail 2-Day Small Flat Rate Box 3 0.25 lbs $8.50 $7.65 $0.85
212621 2020-06-03 $6.52 USPSFirstClass 1 0.03 lbs $4.15 $3.05 $1.10
212622 2020-06-02 $51.46 Priority Mail 2-Day 2 0.88 lbs $11.39 $10.54 $0.85
212623 2020-06-03 $9.88 USPSFirstClass 1 0.02 lbs $4.17 $2.78 $1.39
212625 2020-06-03 $52.64 Priority Mail 2-Day 2 2.50 lbs $13.00 $12.15 $0.85
212626 2020-06-03 $12.97 USPSFirstClass 1 0.30 lbs $5.24 $4.32 $0.92
212627 2020-06-03 $6.26 USPSFirstClass 1 0.01 lbs $4.04 $2.84 $1.20
212628 2020-06-03 $11.94 USPSFirstClass 1 0.07 lbs $4.25 $2.78 $1.47
212629 2020-06-03 $20.49 Priority Mail 2-Day Flat Rate Envelope 1 0.45 lbs $8.00 $7.65 $0.35
212630 2020-06-03 $10.33 First-Class Mail Stamped Letter 2 0.10 lbs $3.35 $3.05 $0.30
212631 2020-06-03 $7.34 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.93 $0.42
212632 2020-06-03 $38.29 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.50 $7.65 $0.85
212634 2020-06-03 $23.86 First-Class Package Service 1 0.60 lbs $4.57 $5.54 $-0.97
212635 2020-06-03 $38.75 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
212639 2020-06-03 $41.60 Priority Mail 2-Day 1 0.75 lbs $9.61 $8.12 $1.49
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56