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
221500 2021-02-04 $39.98 USPSFirstClass 1 0.25 lbs $5.86 $3.51 $2.35
221501 2021-02-04 $8.59 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.06 $0.34
221502 2021-02-04 $15.06 First-Class Package Service 2 0.20 lbs $4.08 $3.22 $0.86
221503 2021-02-04 $84.89 USPSPriority 1 5.30 lbs $14.90 $13.75 $1.15
221504 2021-02-04 $35.25 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221505 2021-02-04 $10.55 USPSFirstClass 1 0.06 lbs $4.45 $3.06 $1.39
221508 2021-02-05 $11.56 USPSFirstClass 1 0.05 lbs $4.79 $3.49 $1.30
221510 2021-02-04 $60.56 Priority Mail 3-Day 5 3.30 lbs $10.06 $9.21 $0.85
221511 2021-02-04 $241.81 Priority Mail 3-Day 2 14.40 lbs $37.83 $32.28 $5.55
221512 2021-02-04 $54.44 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $8.75 $8.25 $0.50
221513 2021-02-05 $61.17 USPSFirstClass 7 1.29 lbs $32.34 $9.01 $23.33
221515 2021-02-04 $22.35 Priority Mail 2-Day 2 0.09 lbs $9.37 $3.35 $6.02
221516 2021-02-04 $104.39 Priority Mail 2-Day Medium Flat Rate Box 2 19.08 lbs $15.00 $10.82 $4.18
221517 2021-02-05 $9.39 USPSFirstClass 1 0.05 lbs $4.40 $3.06 $1.34
221519 2021-02-05 $7.78 USPSFirstClass 1 0.06 lbs $4.47 $3.35 $1.12
221522 2021-02-04 $53.09 Ground 1 0.40 lbs $13.10 $9.65 $3.45
221523 2021-02-04 $111.83 Priority Mail 3-Day 4 4.53 lbs $12.55 $7.88 $4.67
221525 2021-02-04 $37.69 Ground 2 2.40 lbs $21.11 $17.89 $3.22
221526 2021-02-04 $5.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.06 $-0.06
221528 2021-02-04 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
221534 2021-02-04 $11.41 First-Class Package Service 1 0.04 lbs $3.62 $3.12 $0.50
221535 2021-02-04 $40.49 Priority Mail 2-Day 5 1.65 lbs $9.09 $8.34 $0.75
221536 2021-02-04 $18.78 First-Class Mail Stamped Letter 2 0.08 lbs $3.20 $3.12 $0.08
221539 2021-02-04 $25.16 First-Class Package Service 2 0.44 lbs $4.88 $4.38 $0.50
221541 2021-02-04 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.22 $-0.02
221542 2021-02-04 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.12 $0.08
221543 2021-02-04 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.22 $-0.02
221547 2021-02-04 $14.65 First-Class Package Service 4 0.18 lbs $4.19 $3.35 $0.84
221548 2021-02-04 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.35 $-0.15
221549 2021-02-05 $7.78 USPSFirstClass 1 0.06 lbs $4.47 $3.35 $1.12
221550 2021-02-05 $6.55 First-Class Package Service 1 0.03 lbs $3.56 $3.06 $0.50
221552 2021-02-05 $103.68 Priority Mail 2-Day Medium Flat Rate Box 12 3.46 lbs $15.00 $13.75 $1.25
221553 2021-02-05 $89.79 USPSPriority 1 5.30 lbs $19.80 $12.42 $7.38
221555 2021-02-05 $14.23 First-Class Package Service 2 0.10 lbs $3.85 $3.35 $0.50
221556 2021-02-05 $14.10 First-Class Mail Stamped Letter 1 0.06 lbs $3.20 $3.49 $-0.29
221557 2021-02-05 $45.79 Priority Mail 2-Day Flat Rate Envelope 2 0.95 lbs $8.25 $8.85 $-0.60
221559 2021-02-05 $33.19 First-Class Package Service 1 0.55 lbs $4.70 $4.20 $0.50
221560 2021-02-05 $45.83 Priority Mail 2-Day 6 4.98 lbs $10.49 $9.64 $0.85
221562 2021-02-05 $18.78 First-Class Mail Stamped Letter 2 0.08 lbs $3.20 $3.12 $0.08
221564 2021-02-05 $42.62 First-Class Package Service 11 0.54 lbs $4.93 $4.68 $0.25
221566 2021-02-05 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221567 2021-02-05 $48.66 Priority Mail 3-Day Flat Rate Envelope 9 0.81 lbs $8.25 $7.90 $0.35
221568 2021-02-05 $6.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.35 $-0.15
221570 2021-02-05 $36.34 First-Class Package Service 1 0.31 lbs $4.35 $3.85 $0.50
221571 2021-02-05 $54.91 Priority Mail 2-Day 3 1.60 lbs $12.54 $16.45 $-3.91
221575 2021-02-05 $23.09 First-Class Package Service 7 0.86 lbs $6.16 $3.58 $2.58
221577 2021-02-05 $17.05 First-Class Package Service 1 0.19 lbs $3.76 $3.51 $0.25
221579 2021-02-05 $4.68 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.01 $0.19
221580 2021-02-05 $244.67 Ground 1 20.12 lbs $31.41 $33.42 $-2.01
221583 2021-02-05 $10.17 First-Class Mail Stamped Letter 3 0.04 lbs $3.20 $3.22 $-0.02
221584 2021-02-05 $48.69 Priority Mail 2-Day 1 1.60 lbs $9.70 $8.85 $0.85
221586 2021-02-05 $11.78 First-Class Package Service 1 0.04 lbs $3.99 $3.49 $0.50
221587 2021-02-05 $25.00 First-Class Package Service 3 0.48 lbs $5.03 $5.81 $-0.78
221588 2021-02-05 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.75 $8.25 $0.50
221589 2021-02-05 $14.10 First-Class Mail Stamped Letter 1 0.06 lbs $3.20 $3.06 $0.14
221590 2021-02-05 $5.54 First-Class Package Service 2 0.02 lbs $3.56 $3.06 $0.50
221592 2021-02-05 $64.21 Priority Mail 2-Day 4 1.23 lbs $11.86 $11.63 $0.23
221593 2021-02-05 $8.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
221595 2021-02-05 $55.94 Priority Mail 2-Day 3 1.02 lbs $9.09 $8.00 $1.09
221597 2021-02-06 $9.47 USPSFirstClass 1 0.61 lbs $5.88 $5.66 $0.22
221598 2021-02-06 $11.36 USPSFirstClass 1 0.05 lbs $4.59 $3.58 $1.01
221599 2021-02-06 $13.69 USPSFirstClass 1 0.05 lbs $4.70 $3.58 $1.12
221601 2021-02-06 $8.91 USPSFirstClass 1 0.23 lbs $4.52 $3.35 $1.17
221602 2021-02-06 $15.90 USPSFirstClass 2 0.10 lbs $4.44 $3.06 $1.38
221603 2021-02-06 $7.96 USPSFirstClass 1 0.03 lbs $4.47 $3.35 $1.12
221604 2021-02-06 $58.33 USPSPriority 2 10.88 lbs $16.59 $12.90 $3.69
221605 2021-02-06 $23.61 USPSFirstClass 1 0.06 lbs $5.12 $3.12 $2.00
221606 2021-02-06 $9.69 USPSFirstClass 1 0.10 lbs $4.70 $3.49 $1.21
221607 2021-02-06 $7.91 USPSFirstClass 1 0.03 lbs $4.42 $3.22 $1.20
221608 2021-02-06 $72.43 USPSFirstClass 8 0.58 lbs $19.31 $10.44 $8.87
221609 2021-02-06 $90.25 Priority Mail 2-Day Flat Rate Envelope 2 3.62 lbs $8.25 $8.00 $0.25
221610 2021-02-06 $10.18 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.35 $-0.15
221611 2021-02-06 $9.28 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
221612 2021-02-06 $30.29 First-Class Package Service 14 0.44 lbs $6.23 $4.68 $1.55
221614 2021-02-06 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
221615 2021-02-06 $9.70 USPSFirstClass 1 0.05 lbs $4.51 $3.22 $1.29
221616 2021-02-06 $9.60 USPSFirstClass 1 0.10 lbs $4.41 $3.06 $1.35
221619 2021-02-06 $87.93 Priority Mail 3-Day Flat Rate Envelope 2 1.60 lbs $8.25 $8.00 $0.25
221620 2021-02-06 $15.86 First-Class Mail Stamped Letter 4 0.10 lbs $3.40 $3.22 $0.18
221621 2021-02-06 $35.59 First-Class Mail Stamped Letter 1 0.17 lbs $3.60 $3.85 $-0.25
221624 2021-02-06 $51.74 Priority Mail 3-Day Small Flat Rate Box 1 1.45 lbs $8.75 $8.25 $0.50
221625 2021-02-06 $7.91 USPSFirstClass 1 0.03 lbs $4.42 $3.22 $1.20
221626 2021-02-06 $23.99 Priority Mail 3-Day Small Flat Rate Box 6 1.14 lbs $8.75 $7.90 $0.85
221628 2021-02-06 $51.31 Priority Mail 2-Day Flat Rate Envelope 4 1.17 lbs $8.25 $7.90 $0.35
221629 2021-02-06 $14.10 First-Class Mail Stamped Letter 1 0.06 lbs $3.20 $3.49 $-0.29
221631 2021-02-06 $33.16 First-Class Package Service 1 0.27 lbs $4.01 $3.51 $0.50
221632 2021-02-06 $33.09 First-Class Package Service 3 0.52 lbs $4.62 $4.12 $0.50
221636 2021-02-06 $7.96 USPSFirstClass 1 0.03 lbs $4.47 $3.35 $1.12
221637 2021-02-06 $6.21 First-Class Package Service 1 0.01 lbs $3.72 $3.22 $0.50
221638 2021-02-06 $24.17 First-Class Package Service 2 0.40 lbs $4.19 $3.69 $0.50
221640 2021-02-06 $63.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 3.75 lbs $8.85 $8.00 $0.85
221648 2021-02-06 $8.98 First-Class Mail Stamped Letter 2 0.02 lbs $3.00 $3.06 $-0.06
221649 2021-02-07 $8.91 USPSFirstClass 1 0.22 lbs $4.52 $3.69 $0.83
221650 2021-02-07 $9.54 USPSFirstClass 1 0.05 lbs $4.55 $3.35 $1.20
221652 2021-02-06 $49.85 Ground 1 0.17 lbs $17.86 $14.42 $3.44
221654 2021-02-06 $51.74 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.75 $7.90 $0.85
221657 2021-02-06 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.75 $7.90 $0.85
221660 2021-02-07 $28.29 USPSFirstClass 1 0.15 lbs $5.35 $3.57 $1.78
221661 2021-02-07 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
221665 2021-02-06 $37.78 Ground 6 0.21 lbs $17.34 $14.84 $2.50
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56