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
200773 2017-11-06 $48.08 Priority Mail 3-Day Flat Rate Envelope 2 1.45 lbs $6.80 $6.25 $0.55
200777 2017-11-06 $58.03 Priority Mail 2-Day 3 1.85 lbs $12.66 $6.25 $6.41
200778 2017-11-06 $54.53 Priority Mail 2-Day 4 1.35 lbs $10.04 $8.91 $1.13
200780 2017-11-07 $75.17 First-Class Package International Service 1 1.70 lbs $32.68 $31.83 $0.85
200781 2017-11-07 $18.36 First-Class Package Service 3 0.42 lbs $4.59 $3.74 $0.85
200783 2017-11-07 $14.41 First-Class Package Service 1 0.37 lbs $3.82 $3.32 $0.50
200784 2017-11-07 $28.38 First-Class Mail Large Envelope 13 0.41 lbs $4.01 $2.77 $1.24
200786 2017-11-07 $23.00 First-Class Mail Large Envelope 2 0.45 lbs $4.22 $3.46 $0.76
200787 2017-11-08 $29.81 Priority Mail 3-Day 3 0.73 lbs $10.84 $6.71 $4.13
200789 2017-11-08 $91.66 First-Class Package International Service 2 2.50 lbs $32.68 $31.83 $0.85
200790 2017-11-08 $42.58 Priority Mail 3-Day 7 3.10 lbs $14.62 $13.36 $1.26
200793 2017-11-08 $64.03 Priority Mail 2-Day 3 2.21 lbs $8.71 $6.83 $1.88
200796 2017-11-09 $9.79 Priority Mail 2-Day Flat Rate Envelope 1 0.04 lbs $6.80 $6.25 $0.55
200798 2017-11-09 $37.72 First-Class Package International Service 11 0.47 lbs $22.23 $21.38 $0.85
200799 2017-11-09 $86.88 Priority Mail 3-Day 8 2.37 lbs $12.66 $9.19 $3.47
200800 2017-11-09 $30.68 First-Class Package Service 2 0.55 lbs $4.65 $3.74 $0.91
200801 2017-11-10 $36.79 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $7.30 $6.25 $1.05
200802 2017-11-10 $23.97 First-Class Package International Service 1 0.20 lbs $13.68 $12.83 $0.85
200803 2017-11-10 $75.23 Priority Mail 3-Day 3 2.05 lbs $12.66 $11.46 $1.20
200805 2017-11-10 $44.47 Priority Mail 3-Day 1 1.20 lbs $7.68 $6.63 $1.05
200807 2017-11-10 $19.75 First-Class Package Service 4 0.20 lbs $3.66 $2.61 $1.05
200810 2017-11-11 $14.64 First-Class Package Service 1 0.18 lbs $3.66 $2.77 $0.89
200811 2017-11-11 $98.75 Priority Mail 2-Day Medium Flat Rate Box 15 15.00 lbs $13.40 $12.05 $1.35
200815 2017-11-11 $9.64 First-Class Package Service 2 0.06 lbs $3.66 $2.61 $1.05
200817 2017-11-12 $135.42 Priority Mail International 12 2.83 lbs $55.50 $53.25 $2.25
200818 2017-11-12 $53.86 First-Class Package International Service 7 0.65 lbs $15.58 $14.73 $0.85
200819 2017-11-12 $100.46 Priority Mail 2-Day Medium Flat Rate Box 17 17.00 lbs $13.40 $12.05 $1.35
200821 2017-11-13 $8.76 Priority Mail 2-Day Flat Rate Envelope 4 0.04 lbs $6.80 $5.75 $1.05
200822 2017-11-13 $206.97 Ground 3 14.75 lbs $28.44 $25.13 $3.31
200823 2017-11-13 $7.05 First-Class Package Service 1 0.03 lbs $3.66 $2.61 $1.05
200824 2017-11-13 $40.45 Priority Mail 2-Day 9 1.09 lbs $10.04 $8.91 $1.13
200826 2017-11-13 $19.02 Priority Mail 3-Day Padded Flat Rate Envelope 3 1.05 lbs $7.35 $6.30 $1.05
200827 2017-11-13 $26.39 First-Class Package Service 2 0.74 lbs $5.21 $4.16 $1.05
200828 2017-11-13 $30.29 First-Class Mail Large Envelope 4 0.48 lbs $4.43 $3.32 $1.11
200829 2017-11-13 $35.57 First-Class Package International Service 1 1.10 lbs $15.58 $14.73 $0.85
200832 2017-11-14 $25.09 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $6.80 $9.97 $-3.17
200833 2017-11-15 $39.33 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $7.30 $6.25 $1.05
200834 2017-11-15 $26.00 First-Class Mail Large Envelope 1 0.40 lbs $4.01 $3.32 $0.69
200838 2017-11-15 $14.13 First-Class Package Service 3 0.09 lbs $3.66 $2.61 $1.05
200840 2017-11-15 $84.47 Priority Mail 3-Day Medium Flat Rate Box 3 2.85 lbs $13.40 $9.19 $4.21
200841 2017-11-15 $14.38 First-Class Mail Large Envelope 1 0.30 lbs $3.59 $2.77 $0.82
200843 2017-11-15 $23.68 First-Class Mail Large Envelope 4 0.34 lbs $4.22 $2.77 $1.45
200844 2017-11-15 $42.33 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.48 lbs $7.35 $6.25 $1.10
200847 2017-11-16 $73.44 Ground 30 6.00 lbs $16.74 $15.85 $0.89
200849 2017-11-17 $36.09 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $7.30 $6.25 $1.05
200853 2017-11-17 $37.39 Priority Mail 2-Day Medium Flat Rate Box 1 3.55 lbs $13.40 $24.10 $-10.70
200854 2017-11-17 $25.87 Priority Mail 2-Day Flat Rate Envelope 3 0.48 lbs $6.80 $6.25 $0.55
200855 2017-11-17 $80.91 First-Class Package International Service 27 1.44 lbs $32.68 $21.38 $11.30
200856 2017-11-17 $74.04 First-Class Package International Service 19 1.38 lbs $22.23 $21.38 $0.85
200857 2017-11-17 $24.32 Priority Mail 2-Day Flat Rate Envelope 8 1.27 lbs $6.80 $6.25 $0.55
200863 2017-11-18 $41.85 First-Class Package Service 2 0.65 lbs $4.87 $3.88 $0.99
200865 2017-11-18 $9.76 First-Class Package Service 6 0.30 lbs $3.82 $2.61 $1.21
200866 2017-11-19 $51.60 3 Day Select 1 1.25 lbs $21.81 $6.25 $15.56
200869 2017-11-19 $31.93 First-Class Package Service 2 0.57 lbs $4.59 $3.60 $0.99
200870 2017-11-19 $14.38 First-Class Mail Large Envelope 1 0.30 lbs $3.59 $2.77 $0.82
200872 2017-11-19 $5.65 First-Class Package Service 1 0.19 lbs $3.66 $2.61 $1.05
200874 2017-11-19 $52.99 Priority Mail 2-Day Small Flat Rate Box 1 1.75 lbs $7.30 $6.25 $1.05
200877 2017-11-20 $157.92 Priority Mail International 1 8.55 lbs $73.93 $71.68 $2.25
200896 2017-11-20 $11.41 First-Class Package Service 1 0.25 lbs $3.82 $2.77 $1.05
200898 2017-11-20 $98.25 Priority Mail 2-Day Flat Rate Envelope 5 4.00 lbs $6.80 $6.25 $0.55
200903 2017-11-21 $17.80 First-Class Package Service 2 0.12 lbs $3.82 $2.77 $1.05
200904 2017-11-21 $351.31 Ground 13 17.25 lbs $26.84 $24.73 $2.11
200905 2017-11-21 $59.42 Priority Mail 2-Day 2 1.46 lbs $10.04 $8.91 $1.13
200906 2017-11-22 $11.45 First-Class Package Service 1 0.10 lbs $3.66 $2.61 $1.05
200907 2017-11-22 $62.72 First-Class Package International Service 1 1.45 lbs $22.23 $21.38 $0.85
200908 2017-11-22 $16.81 First-Class Package Service 1 0.33 lbs $3.82 $2.77 $1.05
200909 2017-11-22 $6.85 First-Class Package Service 2 0.39 lbs $4.37 $3.46 $0.91
200912 2017-11-23 $15.38 First-Class Mail Large Envelope 1 0.25 lbs $3.59 $2.77 $0.82
200913 2017-11-23 $125.37 Priority Mail 2-Day Medium Flat Rate Box 3 4.05 lbs $13.40 $9.99 $3.41
200916 2017-11-23 $7.80 First-Class Package Service 2 0.38 lbs $3.62 $2.77 $0.85
200917 2017-11-23 $327.93 Priority Mail International 15 8.61 lbs $69.58 $59.57 $10.01
200918 2017-11-23 $24.58 First-Class Package Service 2 0.70 lbs $4.93 $4.16 $0.77
200919 2017-11-24 $11.89 First-Class Package Service 2 0.36 lbs $4.51 $3.74 $0.77
200920 2017-11-24 $21.60 First-Class Package Service 6 0.20 lbs $3.66 $2.61 $1.05
200921 2017-11-24 $136.48 Priority Mail 2-Day 3 13.64 lbs $17.31 $16.80 $0.51
200922 2017-11-24 $22.21 Priority Mail 2-Day Flat Rate Envelope 9 0.15 lbs $6.80 $6.25 $0.55
200923 2017-11-24 $22.39 First-Class Package Service 3 0.19 lbs $3.82 $2.61 $1.21
200925 2017-11-24 $52.84 Priority Mail 2-Day 1 1.70 lbs $10.35 $8.15 $2.20
200928 2017-11-24 $97.16 Priority Mail 3-Day Medium Flat Rate Box 4 2.05 lbs $13.40 $9.99 $3.41
200929 2017-11-24 $5.81 First-Class Package Service 1 0.19 lbs $3.82 $2.61 $1.21
200933 2017-11-26 $50.22 First-Class Package International Service 1 1.20 lbs $22.23 $21.38 $0.85
200935 2017-11-26 $29.35 First-Class Package Service 2 0.60 lbs $5.07 $4.02 $1.05
200936 2017-11-26 $19.50 First-Class Mail Large Envelope 1 0.40 lbs $4.01 $2.77 $1.24
200937 2017-11-26 $47.78 Priority Mail 2-Day Flat Rate Envelope 2 1.55 lbs $6.80 $6.25 $0.55
200940 2017-11-26 $75.48 Priority Mail 2-Day 7 1.90 lbs $10.35 $7.91 $2.44
200943 2017-11-26 $47.29 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $7.30 $6.25 $1.05
200944 2017-11-27 $8.71 First-Class Package Service 1 0.15 lbs $3.82 $2.77 $1.05
200948 2017-11-27 $68.61 Priority Mail 3-Day 3 1.55 lbs $10.04 $6.25 $3.79
200949 2017-11-27 $42.28 Priority Mail 3-Day Small Flat Rate Box 2 1.25 lbs $7.30 $6.25 $1.05
200950 2017-11-27 $19.64 First-Class Package International Service 4 0.20 lbs $13.68 $12.83 $0.85
200953 2017-11-27 $50.16 Priority Mail 3-Day 3 1.20 lbs $11.13 $9.97 $1.16
200954 2017-11-27 $15.76 First-Class Package Service 6 0.18 lbs $3.82 $2.61 $1.21
200956 2017-11-27 $40.58 Priority Mail 2-Day Small Flat Rate Box 2 1.33 lbs $7.30 $6.25 $1.05
200958 2017-11-27 $28.49 First-Class Package Service 4 0.52 lbs $4.73 $2.77 $1.96
200960 2017-11-27 $40.10 First-Class Package Service 2 0.70 lbs $3.62 $4.02 $-0.40
200963 2017-11-28 $28.17 First-Class Package Service 2 0.60 lbs $4.59 $3.74 $0.85
200964 2017-11-28 $60.97 First-Class Package International Service 2 1.00 lbs $21.99 $21.14 $0.85
200965 2017-11-28 $18.80 First-Class Mail Large Envelope 1 0.35 lbs $4.01 $3.74 $0.27
200967 2017-11-29 $54.08 Priority Mail 2-Day Flat Rate Envelope 2 1.65 lbs $6.80 $6.25 $0.55
200969 2017-11-29 $15.38 First-Class Mail Large Envelope 1 0.30 lbs $3.59 $2.77 $0.82
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56