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
208799 2019-12-13 $147.62 Priority Mail 2-Day Flat Rate Envelope 18 6.34 lbs $7.80 $7.50 $0.30
208803 2019-12-13 $8.82 First-Class Package Service 1 0.50 lbs $4.93 $5.02 $-0.09
208805 2019-12-13 $28.33 Priority Mail 3-Day 1 1.05 lbs $8.34 $7.50 $0.84
208808 2019-12-13 $34.70 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
208809 2019-12-13 $22.83 First-Class Package Service 1 0.35 lbs $4.54 $3.49 $1.05
208811 2019-12-14 $21.64 Priority Mail 2-Day 4 1.30 lbs $11.08 $10.23 $0.85
208813 2019-12-14 $12.65 First-Class Package Service 4 0.20 lbs $3.89 $3.36 $0.53
208815 2019-12-14 $80.38 Priority Mail 2-Day 4 1.94 lbs $16.13 $15.28 $0.85
208816 2019-12-14 $30.18 Priority Mail 2-Day 6 0.69 lbs $8.84 $7.99 $0.85
208818 2019-12-14 $18.96 First-Class Package Service 3 0.95 lbs $6.29 $5.24 $1.05
208819 2019-12-14 $27.29 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.80 $7.55 $0.25
208820 2019-12-14 $36.34 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.35 $10.86 $-2.51
208824 2019-12-15 $42.79 Priority Mail 2-Day Flat Rate Envelope 1 1.17 lbs $7.80 $7.50 $0.30
208826 2019-12-15 $41.40 Direct Link International 8 0.41 lbs $20.08 $11.40 $8.68
208828 2019-12-15 $11.61 First-Class Package Service 3 0.51 lbs $5.04 $4.19 $0.85
208830 2019-12-15 $22.62 First-Class Package Service 1 0.30 lbs $4.33 $3.28 $1.05
208831 2019-12-15 $16.32 First-Class Package Service 1 0.35 lbs $4.33 $3.28 $1.05
208832 2019-12-15 $5.48 First-Class Package Service 3 0.03 lbs $4.01 $2.96 $1.05
208834 2019-12-15 $11.69 Priority Mail 3-Day Flat Rate Envelope 1 0.05 lbs $7.80 $7.50 $0.30
208835 2019-12-15 $5.73 First-Class Package Service 2 0.02 lbs $3.75 $2.70 $1.05
208837 2019-12-15 $31.26 Priority Mail 3-Day 2 1.35 lbs $9.35 $8.50 $0.85
208838 2019-12-16 $621.39 Direct Link International 20 19.72 lbs $128.23 $116.89 $11.34
208839 2019-12-16 $26.20 First-Class Package Service 6 0.37 lbs $4.23 $3.82 $0.41
208840 2019-12-16 $27.96 First-Class Package Service 1 0.15 lbs $4.01 $2.96 $1.05
208841 2019-12-16 $14.77 First-Class Package Service 4 0.27 lbs $4.41 $2.84 $1.57
208843 2019-12-16 $6.83 First-Class Package Service 6 0.06 lbs $3.89 $2.84 $1.05
208845 2019-12-16 $10.37 First-Class Package Service 2 0.11 lbs $3.89 $2.84 $1.05
208846 2019-12-16 $97.79 Priority Mail 2-Day 7 3.04 lbs $9.66 $8.81 $0.85
208847 2019-12-16 $9.33 First-Class Package Service 1 0.10 lbs $4.14 $3.09 $1.05
208848 2019-12-16 $13.55 First-Class Package Service 2 0.10 lbs $4.01 $2.96 $1.05
208849 2019-12-16 $28.09 Priority Mail 3-Day 2 1.90 lbs $10.11 $9.26 $0.85
208851 2019-12-16 $11.35 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
208852 2019-12-16 $28.82 Ground 1 0.95 lbs $19.83 $7.88 $11.95
208854 2019-12-17 $9.79 Priority Mail 2-Day Flat Rate Envelope 1 0.07 lbs $7.80 $7.50 $0.30
208856 2019-12-17 $16.11 First-Class Package Service 3 0.24 lbs $4.14 $3.09 $1.05
208858 2019-12-17 $4.34 First-Class Package Service 1 0.20 lbs $0.00 $3.28 $-3.28
208861 2019-12-17 $38.14 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
208863 2019-12-17 $15.78 Priority Mail 2-Day Flat Rate Envelope 2 0.05 lbs $7.80 $7.55 $0.25
208865 2019-12-17 $17.72 Priority Mail 2-Day 1 0.95 lbs $8.73 $8.50 $0.23
208867 2019-12-17 $98.74 Priority Mail 3-Day Medium Flat Rate Box 7 3.07 lbs $14.05 $10.00 $4.05
208868 2019-12-17 $7.00 First-Class Package Service 1 0.02 lbs $4.01 $2.96 $1.05
208869 2019-12-18 $55.08 Priority Mail 2-Day 3 2.25 lbs $9.19 $7.88 $1.31
208870 2019-12-18 $15.08 First-Class Package Service 3 0.15 lbs $3.81 $3.28 $0.53
208871 2019-12-18 $16.33 First-Class Package Service 1 0.30 lbs $4.54 $4.19 $0.35
208874 2019-12-18 $11.71 First-Class Package Service 4 0.10 lbs $3.75 $3.22 $0.53
208875 2019-12-18 $98.31 Priority Mail 2-Day 2 6.09 lbs $24.33 $25.85 $-1.52
208878 2019-12-18 $6.24 First-Class Package Service 1 0.08 lbs $3.75 $2.70 $1.05
208880 2019-12-18 $11.99 First-Class Package Service 2 0.12 lbs $4.01 $2.96 $1.05
208881 2019-12-18 $36.26 First-Class Package Service 3 0.75 lbs $6.29 $5.24 $1.05
208885 2019-12-18 $6.74 First-Class Package Service 1 0.04 lbs $3.75 $2.70 $1.05
208887 2019-12-19 $23.47 First-Class Package Service 1 0.40 lbs $4.68 $3.63 $1.05
208888 2019-12-19 $215.25 Ground Home Delivery 1 21.00 lbs $22.06 $20.62 $1.44
208892 2019-12-19 $61.02 Priority Mail 2-Day Medium Flat Rate Box 3 5.85 lbs $14.05 $10.00 $4.05
208893 2019-12-19 $27.29 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $10.11 $7.55 $2.56
208896 2019-12-19 $76.51 Priority Mail 2-Day 1 3.85 lbs $16.52 $15.67 $0.85
208897 2019-12-19 $21.19 First-Class Package Service 1 1.65 lbs $3.89 $7.50 $-3.61
208899 2019-12-19 $99.61 Priority Mail 2-Day Large Flat Rate Box 4 3.90 lbs $18.45 $17.60 $0.85
208901 2019-12-19 $124.06 Priority Mail 2-Day 2 5.85 lbs $16.28 $15.43 $0.85
208903 2019-12-20 $6.95 First-Class Package Service 6 0.06 lbs $4.01 $2.96 $1.05
208910 2019-12-20 $49.05 Priority Mail 2-Day 16 0.91 lbs $11.71 $10.86 $0.85
208911 2019-12-20 $127.79 Priority Mail 2-Day Medium Flat Rate Box 6 4.13 lbs $14.05 $10.00 $4.05
208912 2019-12-19 $148.30 Priority Mail 3-Day 5 8.20 lbs $28.48 $23.74 $4.74
208913 2019-12-20 $16.67 First-Class Package Service 1 0.35 lbs $4.68 $3.63 $1.05
208914 2019-12-20 $208.54 Priority Mail 3-Day 6 15.97 lbs $21.20 $21.26 $-0.06
208915 2019-12-21 $33.92 Priority Mail 2-Day 1 1.06 lbs $9.35 $8.50 $0.85
208916 2019-12-21 $20.70 Priority Mail 2-Day 1 0.95 lbs $11.71 $10.86 $0.85
208917 2019-12-21 $18.75 First-Class Package Service 1 0.45 lbs $4.41 $4.06 $0.35
208918 2019-12-21 $9.88 First-Class Package Service 1 0.13 lbs $3.89 $3.36 $0.53
208919 2019-12-21 $31.79 Priority Mail 2-Day Flat Rate Envelope 1 3.55 lbs $7.80 $7.55 $0.25
208924 2019-12-21 $29.73 First-Class Package Service 1 0.60 lbs $5.24 $5.38 $-0.14
208926 2019-12-22 $24.02 First-Class Package Service 1 0.60 lbs $4.73 $5.02 $-0.29
208927 2019-12-22 $35.72 First-Class Package Service 6 0.86 lbs $6.58 $5.53 $1.05
208929 2019-12-22 $24.40 First-Class Package Service 1 0.40 lbs $4.41 $4.06 $0.35
208936 2019-12-22 $17.72 Priority Mail 2-Day 1 0.95 lbs $8.73 $7.88 $0.85
208940 2019-12-23 $28.03 First-Class Package Service 1 0.45 lbs $5.04 $4.19 $0.85
208942 2019-12-23 $27.39 First-Class Package Service 2 0.60 lbs $5.01 $3.96 $1.05
208943 2019-12-23 $24.45 Priority Mail 2-Day 6 1.95 lbs $10.11 $9.26 $0.85
208944 2019-12-23 $19.96 First-Class Package Service 5 0.50 lbs $5.01 $2.76 $2.25
208945 2019-12-23 $119.51 Priority Mail 2-Day 7 3.41 lbs $8.56 $7.65 $0.91
208946 2019-12-23 $24.02 First-Class Package Service 1 0.60 lbs $4.73 $5.02 $-0.29
208949 2019-12-23 $234.74 Priority Mail 2-Day 3 21.45 lbs $24.87 $25.38 $-0.51
208950 2019-12-23 $18.67 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
208951 2019-12-24 $36.19 Priority Mail 3-Day Flat Rate Envelope 1 1.27 lbs $7.80 $7.50 $0.30
208954 2019-12-24 $7.30 First-Class Package Service 1 0.03 lbs $3.81 $2.76 $1.05
208955 2019-12-24 $36.21 First-Class Package Service 2 0.80 lbs $6.58 $5.53 $1.05
208956 2019-12-24 $10.00 First-Class Package Service 1 0.34 lbs $4.33 $3.28 $1.05
208957 2019-12-24 $19.00 First-Class Package Service 3 0.40 lbs $4.33 $3.96 $0.37
208959 2019-12-24 $13.33 First-Class Package Service 1 0.45 lbs $4.93 $3.88 $1.05
208961 2019-12-24 $8.00 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
208962 2019-12-25 $183.25 Ground Home Delivery 3 15.45 lbs $30.66 $30.97 $-0.31
208963 2019-12-25 $28.49 First-Class Package Service 5 0.24 lbs $4.54 $3.49 $1.05
208964 2019-12-25 $16.53 First-Class Package Service 1 0.40 lbs $4.54 $4.19 $0.35
208967 2019-12-25 $7.01 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
208968 2019-12-25 $12.88 First-Class Package Service 2 0.12 lbs $4.14 $3.63 $0.51
208975 2019-12-26 $58.68 Priority Mail 3-Day Flat Rate Envelope 2 1.68 lbs $7.80 $7.50 $0.30
208977 2019-12-26 $31.16 Priority Mail 3-Day 3 2.06 lbs $9.19 $8.34 $0.85
208978 2019-12-26 $16.77 First-Class Package Service 4 0.20 lbs $4.41 $3.36 $1.05
208979 2019-12-26 $60.60 Priority Mail 2-Day 1 2.40 lbs $12.65 $11.80 $0.85
208981 2019-12-26 $90.01 Priority Mail 3-Day 18 6.55 lbs $30.89 $30.04 $0.85
208983 2019-12-26 $34.70 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56