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
205786 2019-02-15 $33.55 Priority Mail 2-Day 10 1.90 lbs $12.65 $9.70 $2.95
205790 2019-02-15 $23.42 First-Class Package Service 1 0.85 lbs $6.43 $5.38 $1.05
205795 2019-02-15 $7.53 First-Class Mail Large Envelope 2 0.34 lbs $3.55 $4.06 $-0.51
205796 2019-02-16 $19.75 First-Class Package Service 5 0.17 lbs $4.87 $3.18 $1.69
205797 2019-02-16 $5.87 First-Class Package Service 2 0.02 lbs $3.89 $2.84 $1.05
205805 2019-02-16 $32.70 First-Class Package Service 13 0.54 lbs $4.33 $3.96 $0.37
205807 2019-02-16 $449.04 Ground 11 23.36 lbs $46.94 $47.95 $-1.01
205808 2019-02-16 $6.75 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
205809 2019-02-17 $11.41 First-Class Mail Large Envelope 4 0.44 lbs $3.85 $4.06 $-0.21
205810 2019-02-17 $20.23 First-Class Package Service 1 0.42 lbs $5.24 $4.19 $1.05
205811 2019-02-17 $30.02 Priority Mail 2-Day 6 0.13 lbs $11.08 $7.99 $3.09
205812 2019-02-17 $15.40 First-Class Package Service 1 0.35 lbs $4.41 $3.36 $1.05
205814 2019-02-17 $25.40 First-Class Package Service 1 0.35 lbs $4.41 $3.36 $1.05
205815 2019-02-17 $29.76 Priority Mail 2-Day 3 1.93 lbs $9.19 $8.34 $0.85
205816 2019-02-17 $33.76 Priority Mail 3-Day Flat Rate Envelope 4 1.29 lbs $7.80 $10.23 $-2.43
205817 2019-02-17 $17.99 First-Class Package Service 2 0.12 lbs $4.01 $2.96 $1.05
205818 2019-02-17 $25.23 Priority Mail 3-Day 2 1.45 lbs $13.95 $13.10 $0.85
205819 2019-02-17 $38.14 Priority Mail 3-Day Small Flat Rate Box 1 1.35 lbs $8.35 $7.50 $0.85
205820 2019-02-17 $5.80 First-Class Package Service 1 0.10 lbs $3.81 $2.76 $1.05
205821 2019-02-17 $12.72 First-Class Package Service 3 0.08 lbs $3.75 $3.22 $0.53
205822 2019-02-17 $11.50 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
205823 2019-02-18 $18.14 Priority Mail 2-Day 1 0.95 lbs $9.35 $8.50 $0.85
205826 2019-02-18 $28.82 First-Class Package Service 2 0.50 lbs $5.24 $4.19 $1.05
205828 2019-02-18 $6.00 First-Class Package Service 1 0.10 lbs $4.01 $2.96 $1.05
205829 2019-02-18 $48.43 Priority Mail 2-Day Small Flat Rate Box 2 1.67 lbs $8.35 $7.50 $0.85
205832 2019-02-18 $76.19 Direct Link International 21 4.58 lbs $25.78 $32.01 $-6.23
205834 2019-02-18 $23.09 First-Class Package Service 4 0.44 lbs $4.33 $3.28 $1.05
205835 2019-02-18 $69.67 Priority Mail 3-Day Medium Flat Rate Box 3 2.02 lbs $13.80 $10.55 $3.25
205837 2019-02-19 $22.05 Priority Mail 2-Day Flat Rate Envelope 5 1.13 lbs $7.80 $7.50 $0.30
205838 2019-02-19 $19.88 First-Class Package Service 1 0.00 lbs $3.89 $2.84 $1.05
205839 2019-02-19 $9.00 First-Class Package Service 1 0.10 lbs $4.01 $2.96 $1.05
205840 2019-02-19 $41.57 First-Class Package Service 4 0.61 lbs $5.11 $5.24 $-0.13
205841 2019-02-19 $37.00 Priority Mail 2-Day 5 1.50 lbs $10.55 $9.70 $0.85
205843 2019-02-19 $15.82 Priority Mail 3-Day 2 0.12 lbs $8.84 $7.99 $0.85
205844 2019-02-18 $57.32 Direct Link International 18 3.75 lbs $40.72 $46.96 $-6.24
205845 2019-02-19 $30.54 Priority Mail 2-Day 1 1.10 lbs $10.55 $9.70 $0.85
205846 2019-02-19 $43.78 Priority Mail 2-Day Medium Flat Rate Box 2 2.88 lbs $13.80 $10.55 $3.25
205852 2019-02-20 $12.56 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
205853 2019-02-20 $89.78 Priority Mail 3-Day Medium Flat Rate Box 2 3.75 lbs $10.90 $12.80 $-1.90
205855 2019-02-20 $96.82 Priority Mail 2-Day 9 6.28 lbs $10.31 $11.16 $-0.85
205858 2019-02-20 $5.88 First-Class Package Service 1 0.12 lbs $3.89 $3.36 $0.53
205859 2019-02-20 $11.99 First-Class Package Service 2 0.20 lbs $4.01 $2.96 $1.05
205861 2019-02-21 $5.87 First-Class Package Service 2 0.02 lbs $3.89 $2.84 $1.05
205868 2019-02-21 $49.27 First-Class Package Service 16 0.80 lbs $6.43 $5.38 $1.05
205870 2019-02-21 $45.52 Priority Mail 3-Day 1 1.15 lbs $8.73 $7.88 $0.85
205872 2019-02-21 $180.79 Priority Mail 2-Day 8 6.95 lbs $17.69 $18.06 $-0.37
205875 2019-02-21 $9.80 First-Class Package Service 1 0.13 lbs $3.81 $2.76 $1.05
205877 2019-02-21 $95.60 Priority Mail 2-Day 6 1.09 lbs $10.11 $10.03 $0.08
205878 2019-02-22 $56.31 First-Class Package International Service 8 1.70 lbs $24.39 $16.39 $8.00
205881 2019-02-22 $41.65 Priority Mail 2-Day 6 0.53 lbs $11.71 $10.86 $0.85
205883 2019-02-22 $69.52 Priority Mail 3-Day 3 1.85 lbs $13.95 $12.80 $1.15
205887 2019-02-22 $64.99 Priority Mail 2-Day Padded Flat Rate Envelope 5 1.55 lbs $8.40 $7.50 $0.90
205888 2019-02-22 $10.80 First-Class Package Service 1 0.07 lbs $3.81 $2.76 $1.05
205890 2019-02-22 $14.39 First-Class Package Service 2 0.24 lbs $4.41 $3.36 $1.05
205892 2019-02-23 $7.46 First-Class Package Service 5 0.05 lbs $4.01 $2.96 $1.05
205893 2019-02-23 $29.88 First-Class Package Service 5 0.50 lbs $4.93 $3.22 $1.71
205895 2019-02-23 $85.35 Priority Mail 2-Day Medium Flat Rate Box 5 2.29 lbs $13.80 $12.80 $1.00
205896 2019-02-23 $65.16 Priority Mail 3-Day Medium Flat Rate Box 4 1.88 lbs $13.80 $11.20 $2.60
205899 2019-02-23 $11.29 Priority Mail 2-Day Flat Rate Envelope 1 0.03 lbs $7.80 $6.95 $0.85
205900 2019-02-23 $23.00 First-Class Package Service 1 0.35 lbs $4.41 $3.36 $1.05
205901 2019-02-23 $22.64 Priority Mail 3-Day 4 1.08 lbs $11.08 $10.23 $0.85
205902 2019-02-23 $48.84 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.35 $7.50 $0.85
205903 2019-02-23 $10.58 First-Class Package Service 3 0.13 lbs $4.01 $2.96 $1.05
205904 2019-02-23 $9.02 First-Class Package Service 2 0.34 lbs $5.04 $4.19 $0.85
205906 2019-02-23 $49.76 Priority Mail 2-Day Small Flat Rate Box 9 0.34 lbs $8.35 $7.82 $0.53
205908 2019-02-23 $37.34 First-Class Package Service 4 0.68 lbs $5.38 $5.53 $-0.15
205909 2019-02-23 $102.35 First-Class Package International Service 3 2.58 lbs $46.58 $36.58 $10.00
205914 2019-02-23 $71.77 First-Class Package International Service 1 1.50 lbs $31.28 $23.28 $8.00
205916 2019-02-23 $127.70 Priority Mail 2-Day 9 4.65 lbs $10.07 $9.22 $0.85
205917 2019-02-23 $5.80 First-Class Package Service 1 0.01 lbs $3.81 $2.76 $1.05
205918 2019-02-24 $20.77 First-Class Package Service 12 0.18 lbs $3.89 $3.36 $0.53
205921 2019-02-24 $10.86 First-Class Package Service 3 0.04 lbs $3.89 $2.84 $1.05
205922 2019-02-24 $27.69 Priority Mail 3-Day 2 1.90 lbs $10.11 $8.50 $1.61
205924 2019-02-24 $8.99 First-Class Package Service 2 0.08 lbs $4.01 $2.96 $1.05
205925 2019-02-24 $34.45 First-Class Package Service 9 0.52 lbs $5.04 $4.19 $0.85
205926 2019-02-24 $20.29 First-Class Package Service 5 0.28 lbs $4.54 $3.49 $1.05
205927 2019-02-24 $13.01 First-Class Package Service 2 0.80 lbs $6.23 $5.38 $0.85
205930 2019-02-24 $5.87 First-Class Package Service 2 0.02 lbs $3.89 $2.84 $1.05
205931 2019-02-24 $9.08 First-Class Package Service 1 0.10 lbs $3.89 $2.84 $1.05
205938 2019-02-25 $77.46 Priority Mail 2-Day Medium Flat Rate Box 4 2.50 lbs $13.80 $12.80 $1.00
205939 2019-02-25 $5.50 First-Class Package Service 1 0.19 lbs $4.01 $2.96 $1.05
205941 2019-02-25 $70.43 Priority Mail 2-Day Large Flat Rate Box 2 4.80 lbs $18.45 $17.60 $0.85
205942 2019-02-26 $8.52 First-Class Package Service 2 0.15 lbs $4.54 $3.49 $1.05
205943 2019-02-26 $109.08 Priority Mail 2-Day 41 8.12 lbs $24.59 $21.82 $2.77
205946 2019-02-26 $6.95 First-Class Package Service 6 0.06 lbs $4.01 $2.96 $1.05
205947 2019-02-26 $46.93 Priority Mail 2-Day 2 1.55 lbs $9.35 $8.50 $0.85
205948 2019-02-26 $22.49 Priority Mail 2-Day 6 1.14 lbs $9.35 $8.50 $0.85
205950 2019-02-26 $5.73 First-Class Package Service 2 0.02 lbs $3.75 $2.70 $1.05
205952 2019-02-26 $8.91 First-Class Package Service 10 0.10 lbs $4.01 $2.96 $1.05
205954 2019-02-26 $13.58 First-Class Package Service 1 0.30 lbs $4.41 $3.36 $1.05
205955 2019-02-26 $39.24 Priority Mail 2-Day 3 8.00 lbs $12.47 $11.69 $0.78
205956 2019-02-26 $89.12 Priority Mail 2-Day 12 0.85 lbs $10.55 $9.70 $0.85
205959 2019-02-26 $17.80 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
205960 2019-02-26 $34.70 Priority Mail 3-Day Medium Flat Rate Box 10 2.00 lbs $13.80 $10.55 $3.25
205961 2019-02-26 $15.78 First-Class Package Service 3 0.18 lbs $3.81 $2.76 $1.05
205962 2019-02-27 $155.83 Priority Mail International 13 3.44 lbs $59.26 $55.01 $4.25
205966 2019-02-27 $32.44 Priority Mail 2-Day Flat Rate Envelope 16 1.67 lbs $7.80 $7.50 $0.30
205967 2019-02-27 $89.05 Priority Mail 3-Day 13 4.93 lbs $18.78 $17.93 $0.85
205969 2019-02-27 $19.47 First-Class Package Service 7 0.12 lbs $4.54 $3.49 $1.05
205970 2019-02-27 $41.77 Priority Mail 3-Day Flat Rate Envelope 3 1.10 lbs $7.80 $7.50 $0.30
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56