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
206831 2019-05-31 $15.28 Priority Mail 3-Day Flat Rate Envelope 2 1.06 lbs $7.80 $7.55 $0.25
206832 2019-06-01 $46.68 Priority Mail 2-Day 18 2.32 lbs $9.66 $8.34 $1.32
206833 2019-06-01 $12.33 Priority Mail 2-Day Small Flat Rate Box 2 0.07 lbs $8.35 $7.50 $0.85
206834 2019-06-01 $59.33 Priority Mail 2-Day Small Flat Rate Box 2 1.65 lbs $8.35 $7.50 $0.85
206835 2019-06-01 $25.36 First-Class Package Service 2 0.70 lbs $5.38 $5.53 $-0.15
206836 2019-06-02 $9.58 First-Class Package Service 6 0.10 lbs $4.14 $3.09 $1.05
206838 2019-06-02 $15.87 First-Class Package Service 6 0.54 lbs $4.73 $5.02 $-0.29
206840 2019-06-02 $21.32 First-Class Package Service 1 0.40 lbs $4.33 $3.28 $1.05
206848 2019-06-03 $9.04 First-Class Package Service 10 0.10 lbs $4.14 $3.09 $1.05
206849 2019-06-03 $25.39 First-Class Package Service 2 0.62 lbs $5.01 $5.12 $-0.11
206851 2019-06-03 $25.40 First-Class Package Service 14 0.30 lbs $4.54 $3.49 $1.05
206852 2019-06-03 $42.33 Priority Mail 2-Day 1 1.15 lbs $9.35 $8.50 $0.85
206853 2019-06-03 $11.79 Priority Mail 2-Day Flat Rate Envelope 1 0.18 lbs $7.80 $7.50 $0.30
206855 2019-06-03 $11.79 First-Class Package Service 2 0.09 lbs $3.81 $2.76 $1.05
206856 2019-06-04 $23.76 First-Class Package Service 4 0.30 lbs $4.68 $3.63 $1.05
206857 2019-06-05 $26.79 First-Class Package Service 4 0.41 lbs $4.33 $3.96 $0.37
206858 2019-06-05 $24.79 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.50 $0.30
206859 2019-06-05 $16.90 First-Class Package Service 1 0.45 lbs $4.41 $4.06 $0.35
206861 2019-06-06 $26.15 First-Class Package Service 3 0.21 lbs $4.68 $3.63 $1.05
206862 2019-06-06 $9.67 First-Class Package Service 1 0.45 lbs $4.68 $4.33 $0.35
206866 2019-06-06 $36.38 Priority Mail 2-Day 2 1.10 lbs $9.35 $8.76 $0.59
206869 2019-06-07 $29.77 First-Class Package International Service 1 0.17 lbs $21.78 $13.78 $8.00
206871 2019-06-07 $11.32 First-Class Package Service 1 0.55 lbs $6.43 $4.19 $2.24
206872 2019-06-07 $37.84 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.35 $7.50 $0.85
206874 2019-06-07 $25.00 Priority Mail 3-Day 5 1.25 lbs $10.55 $9.70 $0.85
206875 2019-06-07 $11.13 First-Class Package Service 1 0.06 lbs $4.14 $3.09 $1.05
206877 2019-06-08 $32.23 First-Class Package Service 4 0.25 lbs $4.27 $3.22 $1.05
206879 2019-06-08 $16.06 First-Class Package Service 1 0.30 lbs $4.27 $3.22 $1.05
206880 2019-06-09 $12.09 First-Class Package Service 5 0.06 lbs $4.14 $3.09 $1.05
206881 2019-06-09 $10.80 First-Class Package Service 1 0.06 lbs $3.81 $2.76 $1.05
206882 2019-06-09 $6.05 First-Class Package Service 1 0.12 lbs $3.71 $3.18 $0.53
206883 2019-06-09 $33.36 Priority Mail 2-Day Medium Flat Rate Box 4 2.20 lbs $13.80 $11.20 $2.60
206884 2019-06-09 $6.78 First-Class Package Service 3 0.03 lbs $3.81 $2.76 $1.05
206885 2019-06-09 $15.94 First-Class Package Service 2 0.24 lbs $4.23 $3.18 $1.05
206886 2019-06-09 $8.26 First-Class Package Service 1 0.30 lbs $4.07 $3.88 $0.19
206887 2019-06-10 $17.17 First-Class Package Service 1 0.45 lbs $4.68 $4.33 $0.35
206888 2019-06-10 $64.27 First-Class Package International Service 1 1.35 lbs $31.28 $23.28 $8.00
206890 2019-06-10 $31.94 First-Class Package International Service 4 0.12 lbs $17.98 $9.98 $8.00
206891 2019-06-10 $69.78 Priority Mail 2-Day Medium Flat Rate Box 2 2.40 lbs $13.80 $10.55 $3.25
206895 2019-06-10 $161.51 Priority Mail 2-Day 3 9.96 lbs $14.54 $15.93 $-1.39
206900 2019-06-11 $12.02 First-Class Package Service 2 0.50 lbs $5.04 $4.19 $0.85
206902 2019-06-11 $60.52 First-Class Package International Service 2 0.38 lbs $21.54 $22.80 $-1.26
206903 2019-06-11 $7.88 First-Class Package Service 1 0.10 lbs $3.89 $2.84 $1.05
206904 2019-06-12 $69.78 First-Class Package International Service 2 1.85 lbs $30.80 $35.63 $-4.83
206905 2019-06-12 $32.58 First-Class Package Service 6 0.69 lbs $6.17 $5.12 $1.05
206906 2019-06-12 $49.50 First-Class Package Service 1 0.60 lbs $5.87 $5.02 $0.85
206909 2019-06-13 $190.02 Priority Mail International 49 4.93 lbs $66.71 $62.46 $4.25
206911 2019-06-13 $152.15 Priority Mail 3-Day 2 4.81 lbs $14.62 $13.77 $0.85
206913 2019-06-14 $22.27 Priority Mail 2-Day 8 1.34 lbs $10.55 $9.70 $0.85
206914 2019-06-14 $16.49 Priority Mail 2-Day 4 0.88 lbs $8.73 $7.88 $0.85
206915 2019-06-14 $97.06 Standard 1 0.90 lbs $29.94 $23.19 $6.75
206916 2019-06-14 $53.64 Priority Mail 2-Day 4 1.63 lbs $14.60 $11.80 $2.80
206917 2019-06-14 $27.96 Priority Mail 2-Day 1 0.60 lbs $8.67 $7.82 $0.85
206918 2019-06-15 $5.74 First-Class Package Service 1 0.10 lbs $3.75 $2.70 $1.05
206923 2019-06-15 $11.11 First-Class Package Service 3 0.06 lbs $4.14 $3.09 $1.05
206924 2019-06-15 $57.61 Ground 2 1.50 lbs $19.93 $18.12 $1.81
206925 2019-06-15 $5.74 First-Class Package Service 1 0.01 lbs $3.75 $2.70 $1.05
206927 2019-06-16 $45.91 Priority Mail 2-Day 3 0.75 lbs $8.34 $7.49 $0.85
206929 2019-06-16 $22.36 First-Class Package Service 7 0.79 lbs $6.43 $4.19 $2.24
206931 2019-06-16 $29.45 First-Class Package Service 2 0.50 lbs $5.87 $3.88 $1.99
206932 2019-06-16 $166.36 Priority Mail 2-Day Medium Flat Rate Box 4 21.20 lbs $13.80 $12.80 $1.00
206934 2019-06-16 $268.55 Priority Mail 3-Day 18 17.11 lbs $32.42 $31.57 $0.85
206936 2019-06-17 $73.38 Priority Mail 3-Day Medium Flat Rate Box 2 2.50 lbs $13.80 $10.55 $3.25
206938 2019-06-18 $29.76 Priority Mail 1-Day 1 0.70 lbs $8.27 $7.65 $0.62
206941 2019-06-18 $93.77 Priority Mail 2-Day 4 1.65 lbs $13.95 $13.10 $0.85
206942 2019-06-18 $25.89 First-Class Package International Service 1 0.05 lbs $21.54 $13.54 $8.00
206943 2019-06-18 $38.09 Priority Mail 3-Day 10 2.50 lbs $9.19 $8.34 $0.85
206945 2019-06-18 $19.34 Priority Mail 3-Day 1 0.95 lbs $10.55 $9.70 $0.85
206946 2019-06-19 $23.02 First-Class Package Service 2 0.38 lbs $4.54 $4.19 $0.35
206948 2019-06-19 $21.42 First-Class Package Service 9 0.20 lbs $4.01 $3.49 $0.52
206949 2019-06-19 $110.85 Priority Mail 2-Day Large Flat Rate Box 17 5.74 lbs $36.05 $17.60 $18.45
206950 2019-06-19 $95.95 Priority Mail 2-Day Large Flat Rate Box 13 8.06 lbs $36.05 $33.40 $2.65
206951 2019-06-19 $28.66 Priority Mail 2-Day Flat Rate Envelope 14 1.96 lbs $7.80 $7.50 $0.30
206952 2019-06-19 $38.14 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
206953 2019-06-20 $17.70 First-Class Package Service 4 0.13 lbs $3.71 $3.18 $0.53
206955 2019-06-20 $32.31 First-Class Package Service 3 0.47 lbs $5.24 $4.19 $1.05
206956 2019-06-20 $36.86 Priority Mail 2-Day 14 2.75 lbs $9.66 $8.81 $0.85
206959 2019-06-20 $51.78 Priority Mail 1-Day 1 1.45 lbs $8.27 $7.50 $0.77
206961 2019-06-20 $28.70 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $7.80 $7.55 $0.25
206962 2019-06-20 $25.53 Priority Mail 3-Day 5 1.25 lbs $11.08 $10.23 $0.85
206963 2019-06-21 $16.93 First-Class Package Service 6 0.44 lbs $6.29 $4.06 $2.23
206964 2019-06-21 $71.56 Priority Mail 2-Day 6 2.38 lbs $9.19 $8.12 $1.07
206965 2019-06-21 $7.38 First-Class Package Service 1 0.03 lbs $3.89 $2.84 $1.05
206967 2019-06-21 $8.24 First-Class Package Service 1 0.05 lbs $3.89 $2.84 $1.05
206968 2019-06-21 $41.85 Priority Mail 3-Day 1 1.05 lbs $8.46 $7.50 $0.96
206969 2019-06-22 $48.39 Priority Mail 2-Day 12 1.00 lbs $11.71 $10.86 $0.85
206971 2019-06-22 $17.57 First-Class Package Service 2 0.08 lbs $3.81 $2.76 $1.05
206972 2019-06-22 $20.34 First-Class Package Service 4 0.24 lbs $6.38 $5.53 $0.85
206973 2019-06-22 $40.47 First-Class Package Service 7 0.62 lbs $5.24 $5.38 $-0.14
206974 2019-06-22 $24.26 First-Class Package Service 1 0.40 lbs $4.27 $3.88 $0.39
206976 2019-06-22 $12.37 First-Class Package Service 2 0.15 lbs $3.89 $2.84 $1.05
206977 2019-06-22 $47.02 First-Class Package Service 6 0.74 lbs $6.58 $5.53 $1.05
206979 2019-06-23 $43.43 Priority Mail 2-Day 2 0.71 lbs $10.55 $9.70 $0.85
206980 2019-06-23 $25.28 First-Class Package Service 10 0.30 lbs $5.38 $3.63 $1.75
206982 2019-06-23 $51.59 Priority Mail 3-Day 9 3.82 lbs $11.18 $8.76 $2.42
206986 2019-06-23 $69.36 Priority Mail 2-Day 4 1.16 lbs $8.73 $7.88 $0.85
206988 2019-06-24 $54.09 First-Class Package International Service 4 0.55 lbs $30.33 $22.33 $8.00
206989 2019-06-24 $99.75 First-Class Package International Service 5 2.56 lbs $46.58 $36.58 $10.00
206990 2019-06-24 $99.75 First-Class Package International Service 3 2.47 lbs $46.58 $59.38 $-12.80
206991 2019-06-24 $64.81 Priority Mail 2-Day Large Flat Rate Box 14 3.14 lbs $18.45 $12.80 $5.65
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56