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
204801 2018-12-06 $80.19 Priority Mail 2-Day 23 4.79 lbs $24.92 $12.45 $12.47
204802 2018-12-06 $44.13 Priority Mail 2-Day 1 1.35 lbs $11.14 $9.98 $1.16
204804 2018-12-06 $20.37 First-Class Package Service 2 0.40 lbs $4.39 $3.66 $0.73
204805 2018-12-06 $37.39 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $7.90 $6.85 $1.05
204806 2018-12-06 $17.67 First-Class Package Service 4 0.20 lbs $3.71 $2.66 $1.05
204807 2018-12-06 $5.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
204809 2018-12-07 $82.60 Priority Mail 3-Day 4 2.70 lbs $9.54 $7.40 $2.14
204811 2018-12-07 $17.55 First-Class Package Service 5 0.35 lbs $4.10 $3.05 $1.05
204812 2018-12-07 $58.83 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.73 lbs $7.95 $6.85 $1.10
204813 2018-12-07 $18.94 First-Class Package Service 3 0.30 lbs $3.97 $2.79 $1.18
204814 2018-12-07 $24.92 Ground Home Delivery 2 0.12 lbs $13.94 $2.66 $11.28
204815 2018-12-07 $39.55 Priority Mail International 5 2.40 lbs $0.00 $49.73 $-49.73
204816 2018-12-07 $64.89 Priority Mail International 22 2.67 lbs $0.00 $53.25 $-53.25
204817 2018-12-07 $57.30 Priority Mail International 20 3.23 lbs $0.00 $60.28 $-60.28
204818 2018-12-07 $48.29 Priority Mail 2-Day Small Flat Rate Box 1 1.70 lbs $7.90 $6.85 $1.05
204819 2018-12-07 $9.94 First-Class Package Service 3 0.30 lbs $3.97 $2.66 $1.31
204822 2018-12-07 $468.79 Priority Mail 3-Day 13 19.10 lbs $33.92 $35.78 $-1.86
204823 2018-12-08 $63.57 Priority Mail 2-Day 8 1.44 lbs $11.65 $10.48 $1.17
204824 2018-12-08 $44.03 Priority Mail 2-Day 11 1.16 lbs $11.65 $10.80 $0.85
204826 2018-12-08 $48.39 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $7.90 $6.85 $1.05
204830 2018-12-08 $11.19 First-Class Package Service 2 0.11 lbs $3.71 $2.66 $1.05
204834 2018-12-08 $6.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
204835 2018-12-08 $15.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
204836 2018-12-08 $11.70 First-Class Package Service 1 0.17 lbs $3.71 $2.79 $0.92
204841 2018-12-08 $9.69 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
204845 2018-12-08 $13.46 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
204847 2018-12-09 $14.60 First-Class Package Service 11 0.12 lbs $3.71 $2.66 $1.05
204850 2018-12-09 $21.65 First-Class Package Service 6 0.17 lbs $3.71 $2.79 $0.92
204851 2018-12-09 $36.69 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
204852 2018-12-09 $69.07 Priority Mail 2-Day Flat Rate Envelope 3 1.67 lbs $7.40 $6.90 $0.50
204853 2018-12-09 $20.44 Priority Mail 3-Day 1 0.95 lbs $11.65 $10.48 $1.17
204854 2018-12-09 $65.28 Priority Mail 3-Day 3 2.40 lbs $13.01 $9.47 $3.54
204857 2018-12-10 $83.99 Priority Mail 2-Day Medium Flat Rate Box 6 1.90 lbs $13.85 $12.45 $1.40
204858 2018-12-10 $22.69 First-Class Package International Service 1 0.05 lbs $17.50 $9.50 $8.00
204860 2018-12-10 $10.48 First-Class Package Service 3 0.08 lbs $3.71 $2.66 $1.05
204862 2018-12-10 $45.04 Priority Mail 3-Day 1 1.30 lbs $8.25 $7.40 $0.85
204863 2018-12-10 $10.08 First-Class Package Service 2 0.38 lbs $4.10 $2.66 $1.44
204865 2018-12-10 $35.32 Direct Link International 1 0.60 lbs $20.33 $16.83 $3.50
204866 2018-12-10 $11.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204867 2018-12-10 $12.68 First-Class Package Service 3 0.13 lbs $3.71 $2.66 $1.05
204872 2018-12-10 $120.39 Ground 18 3.69 lbs $22.67 $20.42 $2.25
204873 2018-12-10 $6.20 First-Class Package Service 1 0.01 lbs $3.71 $2.66 $1.05
204874 2018-12-11 $388.18 Priority Mail International 13 14.15 lbs $98.58 $87.50 $11.08
204876 2018-12-11 $14.09 First-Class Package Service 2 0.12 lbs $3.71 $2.66 $1.05
204877 2018-12-11 $21.38 First-Class Package Service 1 0.40 lbs $4.10 $3.18 $0.92
204878 2018-12-11 $43.42 Priority Mail 2-Day 1 1.35 lbs $7.95 $6.89 $1.06
204880 2018-12-11 $38.87 Priority Mail 3-Day Flat Rate Envelope 3 0.57 lbs $7.40 $6.85 $0.55
204881 2018-12-11 $5.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
204882 2018-12-11 $51.00 Priority Mail 2-Day 1 2.20 lbs $13.01 $9.47 $3.54
204883 2018-12-11 $25.57 Priority Mail 2-Day 8 1.15 lbs $11.65 $6.90 $4.75
204884 2018-12-11 $9.96 First-Class Package Service 1 0.25 lbs $3.97 $3.66 $0.31
204885 2018-12-11 $44.50 Priority Mail 2-Day 2 5.04 lbs $24.92 $23.35 $1.57
204886 2018-12-11 $94.66 Priority Mail 3-Day 5 2.45 lbs $13.01 $9.47 $3.54
204891 2018-12-12 $47.80 Priority Mail 3-Day 10 3.50 lbs $8.90 $7.25 $1.65
204894 2018-12-13 $10.67 First-Class Package Service 4 0.16 lbs $3.71 $2.66 $1.05
204897 2018-12-13 $76.19 Priority Mail International 21 4.58 lbs $0.00 $48.93 $-48.93
204898 2018-12-13 $60.80 Priority Mail International 20 4.05 lbs $0.00 $60.28 $-60.28
204901 2018-12-13 $18.86 First-Class Package Service 2 0.36 lbs $3.97 $3.18 $0.79
204902 2018-12-13 $8.90 First-Class Package Service 1 0.15 lbs $3.71 $2.66 $1.05
204903 2018-12-14 $9.19 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
204904 2018-12-14 $8.70 First-Class Package Service 1 0.06 lbs $3.71 $2.66 $1.05
204905 2018-12-14 $11.69 First-Class Package Service 2 0.07 lbs $3.71 $2.66 $1.05
204906 2018-12-14 $197.80 Ground 1 14.05 lbs $27.81 $19.04 $8.77
204907 2018-12-14 $84.54 Priority Mail 2-Day 2 5.05 lbs $10.56 $9.42 $1.14
204908 2018-12-14 $8.68 First-Class Package Service 3 0.06 lbs $3.71 $2.66 $1.05
204909 2018-12-14 $31.53 Priority Mail 2-Day 2 0.60 lbs $7.95 $6.85 $1.10
204911 2018-12-14 $57.96 Priority Mail 2-Day Flat Rate Envelope 4 1.68 lbs $7.40 $6.85 $0.55
204912 2018-12-14 $160.72 Priority Mail 3-Day 4 10.12 lbs $28.66 $29.42 $-0.76
204914 2018-12-14 $31.94 First-Class Package Service 3 0.60 lbs $4.87 $3.82 $1.05
204915 2018-12-14 $37.69 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $7.90 $6.85 $1.05
204918 2018-12-15 $20.93 First-Class Package Service 4 0.31 lbs $3.97 $3.18 $0.79
204921 2018-12-15 $76.85 First-Class Package International Service 1 1.80 lbs $41.96 $22.33 $19.63
204923 2018-12-15 $25.20 First-Class Package Service 1 0.85 lbs $5.71 $4.66 $1.05
204924 2018-12-16 $22.37 Priority Mail 3-Day Flat Rate Envelope 3 0.15 lbs $7.40 $6.85 $0.55
204925 2018-12-16 $81.80 Priority Mail 2-Day Medium Flat Rate Box 5 2.47 lbs $13.85 $10.29 $3.56
204927 2018-12-16 $57.98 Priority Mail 3-Day Padded Flat Rate Envelope 3 1.62 lbs $7.95 $6.85 $1.10
204928 2018-12-16 $22.92 Priority Mail 2-Day 3 0.26 lbs $7.95 $6.89 $1.06
204932 2018-12-16 $38.15 Priority Mail 3-Day 7 2.13 lbs $9.32 $8.22 $1.10
204933 2018-12-16 $12.17 First-Class Package Service 2 0.80 lbs $5.79 $7.28 $-1.49
204934 2018-12-16 $31.72 First-Class Package Service 3 0.43 lbs $4.95 $4.10 $0.85
204936 2018-12-16 $40.50 Priority Mail 2-Day Flat Rate Envelope 10 1.42 lbs $7.40 $6.90 $0.50
204938 2018-12-17 $16.31 Priority Mail 2-Day Padded Flat Rate Envelope 4 0.76 lbs $7.95 $6.98 $0.97
204943 2018-12-17 $21.68 Priority Mail 2-Day 4 1.30 lbs $10.32 $9.19 $1.13
204945 2018-12-17 $76.86 2nd Day Air 17 1.97 lbs $36.23 $10.48 $25.75
204946 2018-12-17 $223.67 Priority Mail 2-Day 1 21.00 lbs $17.72 $16.36 $1.36
204948 2018-12-17 $35.85 Priority Mail 3-Day Flat Rate Envelope 2 1.20 lbs $7.40 $6.85 $0.55
204950 2018-12-17 $143.93 Priority Mail 3-Day Medium Flat Rate Box 6 4.47 lbs $13.85 $12.45 $1.40
204951 2018-12-17 $9.22 First-Class Package Service 1 0.45 lbs $4.23 $3.82 $0.41
204953 2018-12-17 $64.11 Priority Mail 2-Day Medium Flat Rate Box 4 1.96 lbs $13.85 $9.47 $4.38
204954 2018-12-18 $464.43 Priority Mail International 19 19.11 lbs $111.65 $103.17 $8.48
204956 2018-12-18 $55.30 Priority Mail 2-Day 4 1.45 lbs $11.14 $6.85 $4.29
204957 2018-12-18 $37.63 Priority Mail 3-Day 1 0.57 lbs $11.14 $7.28 $3.86
204959 2018-12-18 $174.80 Priority Mail 3-Day 6 7.60 lbs $12.26 $11.07 $1.19
204961 2018-12-18 $73.67 First-Class Package International Service 8 2.09 lbs $41.25 $22.33 $18.92
204962 2018-12-18 $13.88 First-Class Package Service 2 0.32 lbs $3.90 $3.34 $0.56
204966 2018-12-19 $15.83 First-Class Mail Large Envelope 2 0.52 lbs $4.45 $4.10 $0.35
204968 2018-12-19 $45.99 Priority Mail 1-Day Small Flat Rate Box 3 1.37 lbs $7.90 $6.85 $1.05
204969 2018-12-19 $25.69 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
204976 2018-12-20 $159.27 Priority Mail 2-Day 19 6.67 lbs $12.26 $9.74 $2.52
204977 2018-12-20 $38.30 Priority Mail 2-Day 12 3.37 lbs $8.26 $7.19 $1.07
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56