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
203680 2018-08-05 $47.60 Priority Mail 2-Day 1 0.35 lbs $9.32 $6.85 $2.47
203682 2018-08-06 $36.53 First-Class Package International Service 1 0.40 lbs $21.54 $13.54 $8.00
203683 2018-08-06 $162.97 Priority Mail International 6 3.04 lbs $66.48 $62.23 $4.25
203685 2018-08-06 $36.46 First-Class Package Service 5 0.72 lbs $5.71 $4.38 $1.33
203686 2018-08-06 $12.20 First-Class Package Service 1 0.18 lbs $3.71 $2.79 $0.92
203687 2018-08-06 $10.69 First-Class Package Service 2 0.01 lbs $3.71 $2.66 $1.05
203689 2018-08-06 $61.06 Priority Mail 2-Day 6 2.47 lbs $9.32 $7.40 $1.92
203690 2018-08-07 $39.00 Priority Mail 3-Day 1 2.40 lbs $13.01 $11.80 $1.21
203692 2018-08-07 $10.56 First-Class Package Service 5 0.09 lbs $3.71 $2.66 $1.05
203694 2018-08-07 $47.36 Priority Mail 2-Day Flat Rate Envelope 4 2.28 lbs $7.40 $6.85 $0.55
203696 2018-08-07 $22.92 First-Class Package Service 1 0.45 lbs $4.10 $3.34 $0.76
203700 2018-08-08 $173.58 Direct Link International 9 3.30 lbs $48.11 $8.43 $39.68
203701 2018-08-08 $9.00 Priority Mail 2-Day 2 1.30 lbs $9.00 $6.90 $2.10
203705 2018-08-08 $9.22 First-Class Mail Large Envelope 3 0.42 lbs $4.24 $3.82 $0.42
203706 2018-08-08 $24.16 First-Class Mail Large Envelope 1 0.65 lbs $4.87 $4.38 $0.49
203707 2018-08-08 $5.70 First-Class Package Service 1 0.01 lbs $3.71 $2.66 $1.05
203708 2018-08-09 $45.79 Priority Mail 2-Day 1 1.20 lbs $9.00 $7.91 $1.09
203709 2018-08-09 $85.85 Priority Mail 2-Day Large Flat Rate Box 6 2.42 lbs $31.35 $17.61 $13.74
203712 2018-08-09 $6.60 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
203713 2018-08-09 $57.18 Ground 2 0.89 lbs $20.98 $13.28 $7.70
203714 2018-08-09 $14.76 First-Class Package Service 1 0.30 lbs $3.97 $3.18 $0.79
203717 2018-08-10 $45.22 Priority Mail 2-Day Flat Rate Envelope 23 1.31 lbs $7.40 $6.90 $0.50
203718 2018-08-10 $51.70 Priority Mail 3-Day Medium Flat Rate Box 5 1.95 lbs $13.85 $10.29 $3.56
203720 2018-08-10 $63.08 Direct Link International 1 2.20 lbs $27.59 $42.40 $-14.81
203721 2018-08-10 $88.76 Direct Link International 4 1.80 lbs $24.95 $86.08 $-61.13
203722 2018-08-10 $6.71 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
203724 2018-08-10 $44.12 Priority Mail 2-Day 1 1.20 lbs $11.14 $9.98 $1.16
203725 2018-08-11 $14.18 First-Class Package Service 3 0.11 lbs $3.71 $2.66 $1.05
203730 2018-08-11 $25.84 First-Class Package Service 3 0.66 lbs $4.87 $3.18 $1.69
203732 2018-08-11 $208.91 Priority Mail 2-Day 14 5.70 lbs $16.45 $15.13 $1.32
203733 2018-08-11 $96.42 Priority Mail 2-Day 4 3.25 lbs $11.19 $10.03 $1.16
203735 2018-08-11 $50.59 Priority Mail 2-Day 2 1.50 lbs $13.01 $9.19 $3.82
203736 2018-08-12 $63.98 Priority Mail 3-Day 2 1.45 lbs $14.00 $9.98 $4.02
203738 2018-08-12 $7.14 First-Class Package Service 7 0.07 lbs $3.71 $2.66 $1.05
203739 2018-08-12 $22.32 First-Class Package Service 1 1.05 lbs $5.71 $6.85 $-1.14
203742 2018-08-13 $38.59 First-Class Mail Large Envelope 5 0.23 lbs $4.24 $3.82 $0.42
203743 2018-08-13 $44.31 Priority Mail 2-Day 1 2.20 lbs $9.32 $7.40 $1.92
203744 2018-08-13 $70.08 Priority Mail 2-Day 3 1.95 lbs $13.01 $9.47 $3.54
203748 2018-08-14 $128.91 Ground 1 12.90 lbs $30.92 $28.42 $2.50
203749 2018-08-14 $27.54 Priority Mail 3-Day 1 0.65 lbs $8.25 $6.89 $1.36
203752 2018-08-14 $23.22 Priority Mail 2-Day 3 0.90 lbs $8.25 $7.40 $0.85
203753 2018-08-14 $22.63 First-Class Package Service 1 0.25 lbs $3.84 $3.05 $0.79
203754 2018-08-14 $14.45 First-Class Package Service 3 0.12 lbs $3.71 $3.82 $-0.11
203757 2018-08-14 $18.08 First-Class Package Service 2 0.38 lbs $4.10 $5.32 $-1.22
203759 2018-08-15 $15.08 First-Class Package Service - Retail 2 0.25 lbs $4.60 $10.02 $-5.42
203760 2018-08-15 $354.65 Ground 9 18.55 lbs $24.29 $23.87 $0.42
203768 2018-08-16 $10.09 First-Class Package Service 2 0.15 lbs $3.71 $2.66 $1.05
203770 2018-08-16 $386.27 Priority Mail 3-Day 181 7.53 lbs $12.18 $7.40 $4.78
203772 2018-08-16 $12.48 First-Class Package Service 3 0.17 lbs $3.71 $2.66 $1.05
203777 2018-08-16 $13.88 First-Class Package Service 2 0.35 lbs $4.10 $3.18 $0.92
203785 2018-08-16 $29.41 Priority Mail 2-Day Medium Flat Rate Box 4 2.20 lbs $13.85 $10.29 $3.56
203786 2018-08-16 $6.71 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
203787 2018-08-16 $90.56 Priority Mail 2-Day 5 2.40 lbs $13.01 $9.47 $3.54
203788 2018-08-17 $119.30 Priority Mail 2-Day Medium Flat Rate Box 5 3.96 lbs $13.85 $10.29 $3.56
203790 2018-08-17 $23.96 First-Class Package Service 1 0.60 lbs $4.67 $4.38 $0.29
203794 2018-08-17 $27.38 Priority Mail 2-Day Flat Rate Envelope 2 1.14 lbs $7.40 $6.85 $0.55
203796 2018-08-18 $17.79 Priority Mail 2-Day 1 0.95 lbs $9.00 $6.98 $2.02
203797 2018-08-18 $9.69 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
203799 2018-08-18 $5.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
203802 2018-08-19 $73.95 Priority Mail 2-Day 5 4.00 lbs $11.50 $8.15 $3.35
203803 2018-08-19 $33.05 First-Class Package Service 5 0.39 lbs $4.10 $3.34 $0.76
203804 2018-08-19 $34.63 First-Class Package Service 7 0.38 lbs $4.10 $3.18 $0.92
203806 2018-08-19 $15.68 First-Class Package Service 3 0.19 lbs $3.71 $2.66 $1.05
203809 2018-08-19 $23.04 First-Class Package Service 17 0.19 lbs $3.71 $2.66 $1.05
203811 2018-08-20 $16.64 First-Class Package Service 7 0.14 lbs $3.71 $2.66 $1.05
203812 2018-08-20 $16.67 First-Class Package Service 4 0.20 lbs $3.71 $2.79 $0.92
203813 2018-08-20 $9.69 First-Class Package Service 2 0.12 lbs $3.71 $2.66 $1.05
203814 2018-08-20 $9.69 First-Class Package Service 2 0.04 lbs $3.71 $2.66 $1.05
203815 2018-08-20 $12.15 First-Class Package Service 6 0.09 lbs $3.71 $2.66 $1.05
203816 2018-08-21 $68.76 Priority Mail 2-Day Flat Rate Envelope 3 2.60 lbs $13.95 $6.90 $7.05
203817 2018-08-21 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
203818 2018-08-21 $135.13 Priority Mail 2-Day Medium Flat Rate Box 12 4.97 lbs $13.85 $10.29 $3.56
203820 2018-08-21 $6.20 First-Class Package Service 1 0.08 lbs $3.71 $2.66 $1.05
203821 2018-08-21 $28.11 First-Class Package Service 8 0.27 lbs $4.71 $2.66 $2.05
203823 2018-08-21 $58.60 Priority Mail 2-Day 2 1.95 lbs $9.32 $14.80 $-5.48
203825 2018-08-22 $93.00 Priority Mail 3-Day 5 4.37 lbs $15.05 $10.33 $4.72
203830 2018-08-22 $15.22 Priority Mail 3-Day 10 4.00 lbs $10.22 $9.09 $1.13
203831 2018-08-22 $74.30 Priority Mail 2-Day 1 1.15 lbs $9.54 $7.40 $2.14
203832 2018-08-22 $12.68 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
203835 2018-08-22 $19.59 First-Class Package Service 1 0.35 lbs $4.10 $3.18 $0.92
203836 2018-08-22 $41.08 First-Class Package Service 3 0.90 lbs $5.71 $4.94 $0.77
203838 2018-08-23 $141.48 Direct Link International 20 2.82 lbs $31.36 $22.67 $8.69
203841 2018-08-23 $13.40 Priority Mail 3-Day Flat Rate Envelope 2 0.10 lbs $7.40 $6.85 $0.55
203842 2018-08-23 $15.18 Priority Mail 2-Day Flat Rate Envelope 2 1.10 lbs $7.40 $6.90 $0.50
203843 2018-08-24 $31.94 Priority Mail 2-Day 2 1.10 lbs $11.14 $9.98 $1.16
203845 2018-08-24 $17.79 Priority Mail 2-Day 1 0.95 lbs $9.00 $6.98 $2.02
203848 2018-08-24 $21.53 First-Class Package Service 7 0.38 lbs $4.10 $3.05 $1.05
203849 2018-08-25 $37.90 Priority Mail 3-Day 3 1.08 lbs $8.25 $7.18 $1.07
203850 2018-08-25 $19.79 First-Class Mail Large Envelope 4 0.41 lbs $4.03 $3.18 $0.85
203853 2018-08-26 $67.59 Priority Mail 2-Day 7 1.13 lbs $9.00 $7.91 $1.09
203855 2018-08-26 $22.42 First-Class Package Service 1 0.85 lbs $5.43 $4.94 $0.49
203856 2018-08-26 $61.52 First-Class Package International Service 2 1.45 lbs $23.20 $15.20 $8.00
203857 2018-08-26 $30.85 Priority Mail 2-Day Flat Rate Envelope 5 0.62 lbs $7.40 $6.90 $0.50
203859 2018-08-27 $39.18 Direct Link International 1 0.35 lbs $19.19 $21.66 $-2.47
203861 2018-08-27 $5.83 First-Class Package Service 1 0.25 lbs $3.84 $3.18 $0.66
203865 2018-08-27 $92.39 Priority Mail 2-Day Small Flat Rate Box 1 2.60 lbs $7.90 $6.85 $1.05
203866 2018-08-27 $28.22 First-Class Package Service 3 0.49 lbs $4.55 $3.34 $1.21
203868 2018-08-28 $47.89 Priority Mail 2-Day 3 1.70 lbs $10.32 $9.19 $1.13
203869 2018-08-28 $30.94 First-Class Package Service 9 0.45 lbs $4.23 $3.34 $0.89
203872 2018-08-29 $13.18 Priority Mail 3-Day Flat Rate Envelope 2 0.06 lbs $7.40 $2.66 $4.74
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56