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.

21025 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
218715 2020-12-13 $69.77 Priority Mail 2-Day Flat Rate Envelope 3 2.02 lbs $8.40 $8.00 $0.40
218717 2020-12-13 $56.54 First-Class Package International Service 1 1.00 lbs $27.46 $19.71 $7.75
218718 2020-12-13 $42.60 Priority Mail 3-Day 6 2.40 lbs $22.26 $16.14 $6.12
218722 2020-12-13 $38.86 USPSPriority 1 2.60 lbs $13.80 $9.94 $3.86
218724 2020-12-13 $72.43 Ground 1 3.95 lbs $18.44 $20.33 $-1.89
218725 2020-12-13 $55.16 Priority Mail 2-Day 10 3.50 lbs $22.26 $18.54 $3.72
218727 2020-12-14 $138.68 USPSPriority 1 12.75 lbs $53.89 $42.58 $11.31
218728 2020-12-14 $47.16 USPSFirstClass 1 0.45 lbs $6.91 $4.57 $2.34
218729 2020-12-14 $8.77 USPSFirstClass 2 0.40 lbs $4.99 $4.57 $0.42
218730 2020-12-14 $12.18 USPSFirstClass 2 0.10 lbs $4.20 $3.18 $1.02
218731 2020-12-13 $16.01 First-Class Package Service 1 0.35 lbs $4.22 $3.77 $0.45
218732 2020-12-14 $5.61 USPSFirstClass 1 0.05 lbs $4.12 $3.30 $0.82
218734 2020-12-13 $12.39 Priority Mail 2-Day Flat Rate Envelope 1 0.11 lbs $8.40 $8.05 $0.35
218736 2020-12-13 $267.68 Ground 6 21.10 lbs $70.30 $32.83 $37.47
218738 2020-12-13 $6.62 First-Class Package Service 1 0.02 lbs $3.63 $3.18 $0.45
218739 2020-12-13 $32.82 Ground 1 0.40 lbs $16.93 $14.43 $2.50
218741 2020-12-14 $20.51 USPSFirstClass 6 0.60 lbs $5.57 $3.09 $2.48
218743 2020-12-14 $27.23 First-Class Package Service 2 0.65 lbs $5.97 $4.33 $1.64
218744 2020-12-14 $5.89 USPSFirstClass 1 0.01 lbs $3.90 $2.99 $0.91
218745 2020-12-14 $9.89 First-Class Mail Stamped Letter 1 0.04 lbs $3.10 $3.09 $0.01
218746 2020-12-14 $81.18 Priority Mail 2-Day Flat Rate Envelope 2 2.80 lbs $8.40 $8.00 $0.40
218748 2020-12-14 $34.91 Priority Mail 2-Day 3 1.15 lbs $12.44 $11.58 $0.86
218752 2020-12-14 $5.09 First-Class Mail Stamped Letter 1 0.07 lbs $3.10 $3.43 $-0.33
218753 2020-12-14 $46.15 USPSFirstClass 3 1.35 lbs $13.78 $8.52 $5.26
218754 2020-12-14 $28.48 First-Class Package Service 1 0.40 lbs $4.63 $3.46 $1.17
218755 2020-12-14 $11.96 First-Class Package Service 1 0.70 lbs $5.97 $4.08 $1.89
218756 2020-12-14 $7.53 First-Class Package Service 2 0.10 lbs $4.55 $3.35 $1.20
218757 2020-12-14 $26.79 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.40 $7.75 $0.65
218758 2020-12-14 $26.79 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.40 $8.00 $0.40
218759 2020-12-14 $12.98 First-Class Mail Stamped Letter 1 0.10 lbs $3.25 $3.03 $0.22
218760 2020-12-14 $12.88 First-Class Mail Stamped Letter 2 0.08 lbs $3.10 $3.18 $-0.08
218761 2020-12-14 $6.94 First-Class Mail Stamped Letter 1 0.02 lbs $2.95 $3.30 $-0.35
218762 2020-12-14 $36.98 USPSFirstClass 7 0.56 lbs $9.05 $3.77 $5.28
218763 2020-12-14 $34.97 Priority Mail 2-Day 2 0.70 lbs $8.81 $7.96 $0.85
218764 2020-12-14 $45.33 Priority Mail 2-Day Flat Rate Envelope 7 0.83 lbs $8.40 $8.05 $0.35
218765 2020-12-14 $74.04 Ground 1 16.00 lbs $34.01 $26.46 $7.55
218768 2020-12-14 $16.06 First-Class Mail Stamped Letter 4 0.06 lbs $3.10 $3.30 $-0.20
218769 2020-12-14 $21.27 Priority Mail 2-Day 2 0.82 lbs $11.79 $10.94 $0.85
218771 2020-12-14 $12.47 First-Class Package Service 7 0.08 lbs $3.54 $3.09 $0.45
218774 2020-12-15 $13.44 USPSFirstClass 1 0.05 lbs $4.45 $3.18 $1.27
218775 2020-12-15 $10.08 USPSFirstClass 4 0.10 lbs $4.12 $3.30 $0.82
218777 2020-12-14 $9.61 First-Class Package Service 1 0.50 lbs $5.62 $4.25 $1.37
218779 2020-12-14 $68.57 Priority Mail 3-Day 3 2.60 lbs $13.40 $10.89 $2.51
218781 2020-12-15 $15.73 First-Class Package Service 2 0.04 lbs $3.75 $3.30 $0.45
218782 2020-12-15 $11.54 First-Class Mail Stamped Letter 6 0.07 lbs $3.10 $3.30 $-0.20
218784 2020-12-15 $37.44 Priority Mail 2-Day Medium Flat Rate Box 1 3.10 lbs $14.85 $10.93 $3.92
218785 2020-12-15 $9.41 First-Class Package Service 1 0.15 lbs $4.22 $3.30 $0.92
218787 2020-12-15 $49.31 Priority Mail 2-Day 2 0.90 lbs $9.37 $8.52 $0.85
218788 2020-12-15 $36.58 Priority Mail 3-Day 1 0.95 lbs $11.79 $11.53 $0.26
218789 2020-12-15 $13.74 First-Class Package Service 1 0.13 lbs $3.75 $3.77 $-0.02
218792 2020-12-15 $12.37 First-Class Mail Stamped Letter 1 0.06 lbs $3.10 $3.09 $0.01
218793 2020-12-15 $42.87 First-Class Package Service 1 0.65 lbs $4.88 $4.43 $0.45
218794 2020-12-15 $26.79 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.40 $8.00 $0.40
218795 2020-12-15 $8.93 First-Class Mail Stamped Letter 2 0.02 lbs $2.95 $3.18 $-0.23
218796 2020-12-15 $51.36 Priority Mail 3-Day Padded Flat Rate Envelope 4 1.48 lbs $9.00 $8.00 $1.00
218797 2020-12-15 $184.82 Priority Mail 2-Day Medium Flat Rate Box 3 23.80 lbs $14.85 $13.60 $1.25
218798 2020-12-15 $41.90 USPSFirstClass 10 2.00 lbs $21.00 $8.61 $12.39
218800 2020-12-15 $27.82 First-Class Package Service 8 0.40 lbs $4.70 $3.50 $1.20
218801 2020-12-15 $208.92 Ground 2 12.75 lbs $42.74 $29.59 $13.15
218802 2020-12-15 $47.01 USPSFirstClass 1 0.45 lbs $6.76 $4.33 $2.43
218803 2020-12-15 $67.84 Priority Mail 2-Day Medium Flat Rate Box 1 16.75 lbs $14.85 $9.46 $5.39
218807 2020-12-15 $25.86 First-Class Package Service 1 0.35 lbs $4.37 $3.85 $0.52
218808 2020-12-16 $11.43 USPSFirstClass 1 0.20 lbs $4.54 $3.92 $0.62
218809 2020-12-15 $17.40 First-Class Package Service 5 0.09 lbs $3.95 $3.03 $0.92
218810 2020-12-16 $9.13 USPSFirstClass 1 0.05 lbs $4.24 $3.18 $1.06
218814 2020-12-15 $50.87 Priority Mail 3-Day Small Flat Rate Box 3 2.58 lbs $8.90 $8.05 $0.85
218815 2020-12-16 $18.06 USPSFirstClass 4 0.80 lbs $9.70 $5.95 $3.75
218817 2020-12-15 $75.08 Priority Mail 3-Day 6 4.80 lbs $10.64 $9.79 $0.85
218819 2020-12-15 $73.72 Priority Mail 3-Day 10 2.65 lbs $10.32 $8.99 $1.33
218820 2020-12-15 $3.44 First-Class Mail Stamped Letter 1 0.01 lbs $2.95 $3.09 $-0.14
218822 2020-12-16 $13.14 USPSFirstClass 1 0.31 lbs $5.15 $3.56 $1.59
218824 2020-12-16 $19.06 First-Class Package Service 3 0.27 lbs $4.09 $3.64 $0.45
218827 2020-12-16 $3.94 First-Class Mail Stamped Letter 1 0.01 lbs $2.95 $3.43 $-0.48
218828 2020-12-16 $20.00 Priority Mail 2-Day 4 0.80 lbs $12.44 $8.82 $3.62
218830 2020-12-16 $12.03 First-Class Package Service 1 0.62 lbs $6.04 $4.57 $1.47
218833 2020-12-16 $54.59 Priority Mail 2-Day Small Flat Rate Box 1 1.60 lbs $8.90 $7.90 $1.00
218834 2020-12-16 $26.86 First-Class Package Service 1 0.45 lbs $4.67 $4.09 $0.58
218835 2020-12-16 $103.38 Priority Mail 2-Day 2 2.20 lbs $13.40 $12.70 $0.70
218838 2020-12-16 $46.80 Priority Mail 2-Day 1 1.30 lbs $10.01 $9.12 $0.89
218839 2020-12-16 $156.18 Priority Mail 2-Day 2 10.00 lbs $21.20 $20.02 $1.18
218840 2020-12-16 $34.17 Priority Mail 3-Day 1 3.10 lbs $11.58 $9.93 $1.65
218841 2020-12-16 $37.29 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.90 $8.05 $0.85
218842 2020-12-16 $9.45 USPSFirstClass 1 0.05 lbs $4.26 $3.18 $1.08
218843 2020-12-16 $60.63 Priority Mail 2-Day 3 1.24 lbs $10.01 $8.85 $1.16
218844 2020-12-16 $6.81 USPSFirstClass 1 0.10 lbs $4.32 $3.43 $0.89
218845 2020-12-16 $40.23 Priority Mail 2-Day 1 0.64 lbs $11.24 $8.15 $3.09
218848 2020-12-17 $6.18 USPSFirstClass 1 0.20 lbs $4.29 $3.92 $0.37
218854 2020-12-16 $78.02 Priority Mail 3-Day Medium Flat Rate Box 3 2.80 lbs $14.85 $10.89 $3.96
218857 2020-12-16 $24.07 First-Class Package Service 1 0.35 lbs $4.09 $3.64 $0.45
218858 2020-12-16 $8.45 First-Class Mail Stamped Letter 2 0.10 lbs $3.25 $3.03 $0.22
218859 2020-12-17 $5.99 USPSFirstClass 1 0.01 lbs $4.00 $3.03 $0.97
218861 2020-12-17 $38.69 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.90 $7.90 $1.00
218871 2020-12-17 $4.99 USPSFirstClass 1 0.00 lbs $4.00 $3.56 $0.44
218872 2020-12-17 $27.20 Priority Mail 2-Day 9 1.05 lbs $11.79 $8.55 $3.24
218874 2020-12-17 $11.10 USPSFirstClass 2 0.06 lbs $4.12 $3.09 $1.03
218877 2020-12-17 $10.86 First-Class Package Service 2 0.06 lbs $3.88 $3.43 $0.45
218880 2020-12-17 $16.62 USPSFirstClass 2 0.80 lbs $9.04 $10.93 $-1.89
218881 2020-12-17 $63.18 Priority Mail 2-Day Flat Rate Envelope 2 1.50 lbs $8.40 $7.90 $0.50
218882 2020-12-17 $66.49 First-Class Package Service 2 0.29 lbs $4.01 $3.56 $0.45
218883 2020-12-17 $15.74 First-Class Package Service 1 0.30 lbs $3.95 $3.51 $0.44
Total 21025 order(s) 59971 29292.14 lbs $193562.51 $270247.54 $-76685.03