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
224647 2021-05-03 $25.14 USPSFirstClass 1 0.03 lbs $5.15 $3.06 $2.09
224648 2021-05-03 $24.42 USPSFirstClass 2 0.09 lbs $9.64 $3.49 $6.15
224650 2021-05-03 $7.58 First-Class Mail Stamped Letter 2 0.03 lbs $3.60 $3.35 $0.25
224651 2021-05-03 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
224653 2021-05-03 $9.48 First-Class Package Service 1 0.20 lbs $4.46 $3.51 $0.95
224654 2021-05-03 $58.08 Priority Mail 2-Day 4 2.05 lbs $9.82 $8.72 $1.10
224656 2021-05-03 $56.07 Priority Mail 2-Day 1 1.70 lbs $9.82 $8.34 $1.48
224659 2021-05-03 $9.34 First-Class Mail Stamped Letter 1 0.08 lbs $3.80 $3.01 $0.79
224660 2021-05-03 $10.29 First-Class Mail Stamped Letter 1 0.10 lbs $4.00 $3.12 $0.88
224662 2021-05-03 $77.14 Priority Mail 2-Day 1 5.65 lbs $15.42 $12.37 $3.05
224663 2021-05-03 $138.07 Priority Mail 3-Day Padded Flat Rate Envelope 3 2.70 lbs $9.10 $8.00 $1.10
224665 2021-05-03 $49.55 Priority Mail 2-Day Medium Flat Rate Box 1 2.35 lbs $15.40 $12.13 $3.27
224666 2021-05-03 $14.92 First-Class Package Service 1 0.30 lbs $4.71 $4.12 $0.59
224668 2021-05-03 $13.38 First-Class Package Service 1 0.30 lbs $4.71 $3.51 $1.20
224669 2021-05-04 $44.93 2-Day 1 0.91 lbs $29.44 $25.58 $3.86
224670 2021-05-04 $190.19 Priority Mail 3-Day 1 2.19 lbs $15.20 $9.64 $5.56
224674 2021-05-04 $95.21 First-Class Package International Service 29 1.15 lbs $32.28 $24.23 $8.05
224676 2021-05-04 $14.56 First-Class Package Service 3 0.30 lbs $4.89 $4.53 $0.36
224678 2021-05-04 $17.77 First-Class Package Service 6 0.28 lbs $5.33 $3.58 $1.75
224679 2021-05-04 $14.41 USPSFirstClass 1 0.10 lbs $4.64 $3.06 $1.58
224680 2021-05-04 $9.39 USPSFirstClass 1 0.05 lbs $4.40 $3.06 $1.34
224681 2021-05-04 $6.60 USPSFirstClass 1 0.01 lbs $4.41 $3.35 $1.06
224682 2021-05-04 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
224683 2021-05-04 $20.42 USPSFirstClass 2 0.12 lbs $4.84 $3.49 $1.35
224684 2021-05-04 $14.94 USPSFirstClass 3 0.09 lbs $4.47 $3.35 $1.12
224686 2021-05-04 $57.33 Priority Mail 2-Day 1 1.20 lbs $9.34 $8.24 $1.10
224689 2021-05-04 $18.96 First-Class Package Service 5 0.28 lbs $4.78 $3.58 $1.20
224690 2021-05-04 $14.31 First-Class Package Service 1 0.30 lbs $4.78 $3.58 $1.20
224691 2021-05-04 $19.15 Priority Mail 2-Day 2 0.10 lbs $8.77 $7.90 $0.87
224692 2021-05-04 $60.95 Priority Mail 3-Day 1 1.00 lbs $12.11 $11.01 $1.10
224697 2021-05-05 $56.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.40 lbs $9.10 $8.10 $1.00
224699 2021-05-05 $10.96 First-Class Package Service 2 0.40 lbs $5.58 $3.58 $2.00
224700 2021-05-05 $10.14 USPSFirstClass 1 0.07 lbs $4.44 $3.06 $1.38
224701 2021-05-05 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
224702 2021-05-05 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
224703 2021-05-05 $9.81 USPSFirstClass 1 0.06 lbs $4.42 $3.06 $1.36
224704 2021-05-05 $32.08 Priority Mail 2-Day 1 0.74 lbs $12.79 $11.69 $1.10
224705 2021-05-05 $17.79 First-Class Mail Stamped Letter 1 0.06 lbs $3.80 $3.12 $0.68
224706 2021-05-05 $6.86 USPSFirstClass 1 0.01 lbs $4.37 $3.22 $1.15
224709 2021-05-05 $10.09 First-Class Mail Stamped Letter 1 0.07 lbs $3.80 $3.12 $0.68
224711 2021-05-05 $28.43 Priority Mail 2-Day Small Flat Rate Box 7 0.46 lbs $9.00 $7.90 $1.10
224714 2020-11-13 $43.54 First-Class Package Service 2 1.25 lbs $4.58 $8.85 $-4.27
224715 2021-05-05 $45.48 Priority Mail 2-Day 1 1.20 lbs $9.34 $8.24 $1.10
224716 2021-05-05 $46.09 Priority Mail 3-Day 1 1.20 lbs $9.95 $8.85 $1.10
224717 2021-05-05 $24.86 First-Class Package Service 1 0.90 lbs $6.47 $5.27 $1.20
224719 2021-05-06 $14.85 First-Class Package Service 2 0.50 lbs $5.07 $4.12 $0.95
224720 2021-05-06 $31.09 USPSPriority 1 1.70 lbs $11.10 $8.24 $2.86
224721 2021-05-06 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
224723 2021-05-06 $40.50 Priority Mail 2-Day Flat Rate Envelope 3 0.90 lbs $8.50 $7.90 $0.60
224725 2021-05-06 $21.76 First-Class Package Service 1 0.25 lbs $4.77 $3.57 $1.20
224726 2021-05-06 $37.43 Priority Mail 3-Day 1 2.40 lbs $10.74 $9.64 $1.10
224728 2021-05-06 $20.13 First-Class Package Service - Retail 2 0.27 lbs $6.20 $4.53 $1.67
224729 2021-05-06 $16.26 First-Class Package Service 1 0.30 lbs $4.77 $3.57 $1.20
224730 2021-05-06 $12.18 USPSFirstClass 1 0.06 lbs $4.39 $3.01 $1.38
224731 2021-05-06 $46.09 Priority Mail 2-Day 1 1.15 lbs $9.95 $8.85 $1.10
224732 2021-05-06 $12.56 First-Class Package Service 2 0.26 lbs $4.78 $3.58 $1.20
224734 2021-05-06 $54.61 First-Class Package Service 1 0.69 lbs $6.62 $5.42 $1.20
224737 2021-05-06 $41.83 Priority Mail 2-Day 1 0.75 lbs $9.34 $8.24 $1.10
224740 2021-05-06 $39.56 Priority Mail 2-Day 2 1.43 lbs $9.34 $8.24 $1.10
224742 2021-05-06 $25.87 Priority Mail 3-Day Flat Rate Envelope 13 0.15 lbs $8.50 $7.90 $0.60
224743 2021-05-06 $34.96 First-Class Package Service 1 0.75 lbs $6.22 $5.27 $0.95
224744 2021-05-06 $10.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.35 $0.45
224745 2021-05-06 $11.80 First-Class Package Service 2 0.08 lbs $4.42 $3.22 $1.20
224746 2021-05-06 $62.39 Priority Mail 2-Day 11 2.12 lbs $15.20 $14.10 $1.10
224750 2021-05-06 $17.41 First-Class Package Service 1 0.05 lbs $4.42 $3.22 $1.20
224751 2021-05-06 $22.89 First-Class Package Service 1 0.60 lbs $5.63 $4.68 $0.95
224753 2021-05-06 $30.09 First-Class Package Service 2 0.77 lbs $6.93 $5.98 $0.95
224754 2021-05-06 $116.97 Priority Mail 2-Day Medium Flat Rate Box 4 10.20 lbs $15.40 $13.75 $1.65
224755 2021-05-06 $59.72 Priority Mail 2-Day 2 1.80 lbs $9.34 $8.00 $1.34
224760 2021-05-07 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
224761 2021-05-07 $10.30 First-Class Package Service 2 0.08 lbs $4.32 $3.12 $1.20
224763 2021-05-07 $124.89 Priority Mail 2-Day 3 3.50 lbs $20.39 $11.32 $9.07
224764 2021-05-07 $7.59 First-Class Mail Stamped Letter 1 0.03 lbs $3.60 $3.35 $0.25
224765 2021-05-07 $46.22 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $8.50 $7.90 $0.60
224770 2021-05-07 $93.08 Priority Mail 3-Day Padded Flat Rate Envelope 2 4.25 lbs $9.10 $8.00 $1.10
224772 2021-05-07 $94.31 Priority Mail 2-Day 4 4.60 lbs $17.97 $15.47 $2.50
224773 2021-05-07 $24.88 Priority Mail 3-Day Padded Flat Rate Envelope 2 0.40 lbs $9.10 $8.00 $1.10
224774 2021-05-08 $13.79 First-Class Mail Stamped Letter 1 0.08 lbs $3.80 $3.35 $0.45
224775 2021-05-08 $51.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.12 lbs $9.10 $8.00 $1.10
224776 2021-05-08 $56.99 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $9.00 $7.90 $1.10
224777 2021-05-08 $6.45 USPSFirstClass 1 0.01 lbs $4.26 $3.06 $1.20
224781 2021-05-08 $7.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.12 $0.68
224782 2021-05-08 $40.49 Priority Mail 3-Day 1 0.90 lbs $11.54 $10.44 $1.10
224787 2021-05-08 $12.03 First-Class Package Service 2 0.19 lbs $5.05 $3.85 $1.20
224788 2021-05-08 $8.27 First-Class Package Service 1 0.20 lbs $4.78 $3.58 $1.20
224789 2021-05-08 $147.84 Priority Mail 2-Day Medium Flat Rate Box 17 2.87 lbs $15.40 $24.26 $-8.86
224790 2021-05-08 $93.08 Priority Mail 2-Day Padded Flat Rate Envelope 2 4.25 lbs $9.10 $8.00 $1.10
224792 2021-05-08 $51.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.12 lbs $9.10 $8.00 $1.10
224793 2021-05-08 $12.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.12 $0.68
224795 2021-05-08 $67.20 Priority Mail 2-Day 2 1.75 lbs $13.80 $12.70 $1.10
224796 2021-05-08 $10.09 First-Class Mail Stamped Letter 1 0.06 lbs $3.80 $3.06 $0.74
224799 2021-05-09 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
224800 2021-05-09 $40.12 First-Class Package Service 6 0.60 lbs $5.07 $3.51 $1.56
224801 2021-05-09 $26.53 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.50 $8.00 $0.50
224802 2021-05-09 $15.78 First-Class Mail Stamped Letter 2 0.04 lbs $3.80 $3.22 $0.58
224803 2021-05-09 $12.33 USPSFirstClass 1 0.34 lbs $5.44 $3.69 $1.75
224806 2021-05-09 $10.11 USPSFirstClass 1 0.06 lbs $4.72 $3.49 $1.23
224807 2021-05-09 $69.10 Priority Mail 2-Day 1 1.00 lbs $12.11 $11.01 $1.10
224808 2021-05-09 $37.01 First-Class Package Service 4 0.25 lbs $5.05 $3.49 $1.56
224809 2021-05-09 $46.52 Priority Mail 2-Day Flat Rate Envelope 8 0.43 lbs $8.50 $3.85 $4.65
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56