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
203873 2018-08-29 $15.09 First-Class Package Service 1 0.35 lbs $4.10 $3.18 $0.92
203876 2018-08-29 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
203878 2018-08-29 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
203879 2018-08-29 $15.38 Priority Mail 3-Day Flat Rate Envelope 2 0.10 lbs $7.40 $6.85 $0.55
203880 2018-08-29 $58.21 Priority Mail 2-Day 5 1.44 lbs $11.65 $10.48 $1.17
203882 2018-08-29 $82.01 Priority Mail 2-Day Medium Flat Rate Box 4 1.95 lbs $13.85 $10.29 $3.56
203883 2018-08-29 $36.21 First-Class Package Service 2 0.75 lbs $5.23 $4.38 $0.85
203884 2018-08-30 $6.68 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
203894 2018-08-30 $13.69 First-Class Package Service 2 0.04 lbs $3.71 $2.79 $0.92
203895 2018-08-30 $8.90 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
203896 2018-08-30 $113.18 Direct Link International 3 1.35 lbs $23.21 $34.16 $-10.95
203897 2018-08-30 $26.49 First-Class Package Service 2 0.42 lbs $5.51 $3.18 $2.33
203898 2018-08-31 $258.74 Direct Link International 19 7.93 lbs $52.90 $85.14 $-32.24
203899 2018-08-31 $6.69 First-Class Package Service 2 0.20 lbs $3.71 $2.66 $1.05
203901 2018-08-31 $13.18 First-Class Package Service 3 0.21 lbs $3.71 $2.66 $1.05
203902 2018-08-31 $10.18 First-Class Package Service 3 0.11 lbs $3.71 $2.66 $1.05
203905 2018-09-01 $11.70 First-Class Package Service 1 0.20 lbs $3.71 $2.79 $0.92
203907 2018-09-01 $7.20 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
203908 2018-09-02 $15.66 First-Class Package Service 5 0.13 lbs $3.71 $2.66 $1.05
203909 2018-09-02 $91.62 Direct Link International 1 3.60 lbs $31.63 $49.83 $-18.20
203910 2018-09-02 $78.68 First-Class Package International Service 1 0.60 lbs $30.33 $22.33 $8.00
203911 2018-09-02 $16.96 First-Class Package Service 1 0.29 lbs $3.97 $3.18 $0.79
203912 2018-09-02 $7.69 First-Class Package Service 2 0.14 lbs $3.71 $2.79 $0.92
203913 2018-09-02 $9.67 First-Class Package Service 4 0.20 lbs $3.71 $2.66 $1.05
203915 2018-09-02 $87.36 Direct Link International 2 2.40 lbs $27.78 $41.70 $-13.92
203916 2018-09-02 $52.80 Direct Link International 1 1.30 lbs $23.01 $31.78 $-8.77
203917 2018-09-03 $13.49 First-Class Package Service 2 0.20 lbs $3.71 $2.92 $0.79
203919 2018-09-03 $11.70 First-Class Package Service 1 0.17 lbs $3.71 $2.79 $0.92
203923 2018-09-04 $91.26 Priority Mail 2-Day 4 4.35 lbs $11.50 $10.33 $1.17
203924 2018-09-04 $63.05 Priority Mail 2-Day 14 2.42 lbs $16.19 $12.45 $3.74
203925 2018-09-04 $59.56 Direct Link International 1 2.60 lbs $16.57 $24.90 $-8.33
203930 2018-09-05 $14.60 First-Class Package Service 11 0.12 lbs $3.71 $2.66 $1.05
203932 2018-09-05 $6.68 First-Class Package Service 3 0.01 lbs $3.71 $2.66 $1.05
203933 2018-09-05 $55.56 Priority Mail 2-Day Medium Flat Rate Box 29 1.95 lbs $13.85 $14.88 $-1.03
203936 2018-09-05 $239.00 Ground 8 17.94 lbs $31.99 $26.79 $5.20
203937 2018-09-05 $48.39 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $7.90 $6.85 $1.05
203938 2018-09-05 $63.29 Priority Mail 2-Day 3 2.28 lbs $9.32 $7.40 $1.92
203939 2018-09-06 $186.06 Direct Link International 11 4.57 lbs $49.47 $79.02 $-29.55
203940 2018-09-06 $17.69 First-Class Package Service 2 0.12 lbs $3.71 $2.79 $0.92
203941 2018-09-06 $76.10 Direct Link International 2 1.82 lbs $25.02 $22.74 $2.28
203942 2018-09-06 $64.47 Direct Link International 1 1.55 lbs $23.98 $33.48 $-9.50
203943 2018-09-06 $64.28 Direct Link International 1 1.50 lbs $23.79 $20.16 $3.63
203944 2018-09-06 $84.84 Direct Link International 3 2.58 lbs $29.07 $46.35 $-17.28
203949 2018-09-06 $69.83 Priority Mail 2-Day Medium Flat Rate Box 2 1.80 lbs $13.85 $12.45 $1.40
203958 2018-09-06 $10.40 Priority Mail 3-Day Flat Rate Envelope 1 0.05 lbs $7.40 $6.85 $0.55
203965 2018-09-07 $21.57 Priority Mail 3-Day 3 0.97 lbs $9.00 $7.91 $1.09
203969 2018-09-07 $68.84 Direct Link International 16 2.79 lbs $26.75 $46.01 $-19.26
203970 2018-09-07 $34.15 Direct Link International 16 2.40 lbs $26.03 $44.78 $-18.75
203975 2018-09-07 $108.27 Priority Mail International 23 3.25 lbs $57.50 $53.25 $4.25
203976 2018-09-07 $7.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
203990 2018-09-07 $12.68 First-Class Package Service 3 0.14 lbs $3.71 $2.79 $0.92
203995 2018-09-08 $12.13 First-Class Package Service 2 0.44 lbs $4.35 $2.66 $1.69
203998 2018-09-08 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
204006 2018-09-08 $135.14 Priority Mail 2-Day 5 3.37 lbs $11.19 $10.33 $0.86
204007 2018-09-08 $9.69 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
204013 2018-09-09 $27.71 First-Class Package Service 6 0.20 lbs $3.97 $3.05 $0.92
204014 2018-09-10 $87.35 Priority Mail 3-Day Medium Flat Rate Box 4 3.35 lbs $13.85 $12.45 $1.40
204015 2018-09-10 $13.61 First-Class Package Service 10 0.04 lbs $3.71 $2.66 $1.05
204016 2018-09-10 $57.83 Priority Mail 2-Day 2 1.95 lbs $8.05 $7.10 $0.95
204017 2018-09-10 $16.33 Priority Mail 3-Day 2 0.20 lbs $8.35 $6.85 $1.50
204018 2018-09-10 $10.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
204019 2018-09-10 $8.99 First-Class Package Service 1 0.45 lbs $4.10 $3.50 $0.60
204020 2018-09-10 $21.77 First-Class Package Service 7 0.25 lbs $3.84 $2.92 $0.92
204021 2018-09-10 $26.28 Direct Link International 1 0.17 lbs $18.29 $11.93 $6.36
204022 2018-09-10 $12.59 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $7.40 $6.85 $0.55
204025 2018-09-11 $5.70 First-Class Package Service 1 0.07 lbs $3.71 $2.92 $0.79
204026 2018-09-11 $69.79 Priority Mail 2-Day 12 1.80 lbs $13.01 $11.80 $1.21
204028 2018-09-12 $9.70 First-Class Package Service 1 0.18 lbs $3.71 $2.92 $0.79
204029 2018-09-12 $42.88 Priority Mail 3-Day Small Flat Rate Box 2 1.33 lbs $7.90 $6.85 $1.05
204032 2018-09-12 $21.92 First-Class Package Service 1 0.40 lbs $4.10 $3.18 $0.92
204033 2018-09-12 $34.25 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
204034 2018-09-12 $23.11 First-Class Mail Large Envelope 3 0.45 lbs $4.24 $3.82 $0.42
204036 2018-09-12 $7.20 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
204037 2018-09-12 $55.55 Priority Mail International 15 3.14 lbs $0.00 $9.42 $-9.42
204038 2018-09-12 $25.90 Priority Mail International 10 1.09 lbs $0.00 $49.73 $-49.73
204039 2018-09-12 $37.95 Priority Mail International 16 1.29 lbs $0.00 $49.73 $-49.73
204040 2018-09-12 $15.71 First-Class Package Service 4 0.20 lbs $3.71 $2.66 $1.05
204041 2018-09-13 $37.34 First-Class Package Service 3 0.61 lbs $4.87 $3.82 $1.05
204042 2018-09-13 $100.02 Priority Mail 3-Day Medium Flat Rate Box 3 3.10 lbs $13.85 $9.47 $4.38
204043 2018-09-13 $8.18 First-Class Package Service 3 0.09 lbs $3.71 $2.66 $1.05
204044 2018-09-13 $26.58 First-Class Mail Large Envelope 2 0.60 lbs $4.87 $4.94 $-0.07
204046 2018-09-13 $23.95 First-Class Mail Large Envelope 1 0.60 lbs $4.66 $4.10 $0.56
204047 2018-09-14 $53.22 First-Class Mail Large Envelope 1 0.60 lbs $4.87 $4.66 $0.21
204048 2018-09-14 $27.28 First-Class Package International Service 2 0.36 lbs $21.30 $22.33 $-1.03
204052 2018-09-15 $30.68 First-Class Package Service 2 0.40 lbs $4.10 $3.34 $0.76
204053 2018-09-15 $18.69 Priority Mail 2-Day Small Flat Rate Box 1 0.30 lbs $7.90 $6.85 $1.05
204054 2018-09-15 $267.73 Ground 4 16.63 lbs $31.37 $26.51 $4.86
204055 2018-09-15 $12.76 First-Class Package Service 1 0.07 lbs $4.87 $2.66 $2.21
204057 2018-09-15 $13.51 First-Class Package Service 20 0.20 lbs $3.71 $2.66 $1.05
204058 2018-09-15 $46.38 Priority Mail 3-Day Flat Rate Envelope 2 1.80 lbs $7.40 $6.90 $0.50
204059 2018-09-15 $10.28 First-Class Package Service 2 0.07 lbs $3.71 $2.66 $1.05
204060 2018-09-15 $3.97 First-Class Package Service 1 0.30 lbs $3.97 $2.79 $1.18
204061 2018-09-15 $18.07 First-Class Package Service 3 0.28 lbs $4.10 $2.92 $1.18
204063 2018-09-16 $171.13 Direct Link International 3 6.20 lbs $67.12 $124.81 $-57.69
204064 2018-09-16 $6.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204069 2018-09-16 $32.90 First-Class Package Service 3 0.75 lbs $5.43 $4.66 $0.77
204070 2018-09-16 $92.16 Priority Mail 3-Day 5 2.52 lbs $10.11 $8.15 $1.96
204072 2018-09-16 $37.69 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
204076 2018-09-17 $51.59 Direct Link International 5 1.13 lbs $20.80 $28.24 $-7.44
204077 2018-09-17 $17.65 First-Class Package Service 6 0.08 lbs $3.71 $2.66 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56