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)
table-success)
table-warning)
table-danger)
oc_order.date_added.21021 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 206682 | 2019-05-08 | $21.82 | First-Class Package Service | 1 | 0.40 lbs | $4.33 | $3.96 | $0.37 |
| 206685 | 2019-05-08 | $35.33 | Priority Mail 3-Day | 2 | 1.60 lbs | $9.35 | $8.76 | $0.59 |
| 206687 | 2019-05-08 | $6.25 | Priority Mail 2-Day | 6 | 3.65 lbs | $16.52 | $15.67 | $0.85 |
| 206688 | 2019-05-08 | $9.67 | First-Class Package Service | 1 | 0.45 lbs | $4.68 | $4.33 | $0.35 |
| 206689 | 2019-05-08 | $15.12 | First-Class Package Service | 1 | 0.30 lbs | $4.33 | $3.28 | $1.05 |
| 206690 | 2019-05-08 | $52.38 | Priority Mail 2-Day | 7 | 0.84 lbs | $9.35 | $8.50 | $0.85 |
| 206691 | 2019-05-08 | $63.58 | Priority Mail 3-Day Medium Flat Rate Box | 2 | 1.90 lbs | $13.80 | $10.55 | $3.25 |
| 206692 | 2019-05-08 | $18.32 | First-Class Package Service | 6 | 0.33 lbs | $5.38 | $3.63 | $1.75 |
| 206693 | 2019-05-10 | $31.53 | Priority Mail 2-Day | 2 | 1.90 lbs | $13.95 | $13.10 | $0.85 |
| 206694 | 2019-05-10 | $16.53 | First-Class Package Service | 1 | 0.35 lbs | $4.54 | $4.19 | $0.35 |
| 206695 | 2019-05-10 | $33.36 | Priority Mail 2-Day Padded Flat Rate Envelope | 3 | 3.00 lbs | $8.40 | $7.50 | $0.90 |
| 206697 | 2019-05-10 | $18.25 | First-Class Package Service | 2 | 0.38 lbs | $4.27 | $2.70 | $1.57 |
| 206698 | 2019-05-10 | $72.31 | Priority Mail 2-Day | 4 | 1.23 lbs | $9.35 | $8.50 | $0.85 |
| 206699 | 2019-05-10 | $8.13 | First-Class Package Service | 1 | 0.18 lbs | $4.14 | $3.63 | $0.51 |
| 206701 | 2019-05-11 | $16.06 | First-Class Package Service | 1 | 0.30 lbs | $4.27 | $3.22 | $1.05 |
| 206703 | 2019-05-11 | $88.83 | Priority Mail International Small Flat Rate Box | 2 | 2.00 lbs | $26.35 | $25.50 | $0.85 |
| 206704 | 2019-05-11 | $51.15 | Priority Mail International | 21 | 2.57 lbs | $66.71 | $62.46 | $4.25 |
| 206707 | 2019-05-11 | $26.16 | Priority Mail 2-Day | 5 | 1.27 lbs | $11.71 | $10.86 | $0.85 |
| 206709 | 2019-05-11 | $25.97 | Priority Mail 2-Day | 2 | 1.88 lbs | $9.19 | $8.81 | $0.38 |
| 206710 | 2019-05-11 | $11.84 | First-Class Package Service | 5 | 0.06 lbs | $3.89 | $2.84 | $1.05 |
| 206712 | 2019-05-12 | $11.50 | First-Class Package Service | 1 | 0.05 lbs | $3.81 | $2.76 | $1.05 |
| 206713 | 2019-05-12 | $60.29 | Priority Mail 2-Day | 2 | 5.95 lbs | $10.31 | $11.16 | $-0.85 |
| 206714 | 2019-05-13 | $93.58 | Priority Mail 3-Day Medium Flat Rate Box | 7 | 2.89 lbs | $13.80 | $10.55 | $3.25 |
| 206715 | 2019-05-13 | $24.99 | First-Class Package Service | 2 | 0.38 lbs | $4.41 | $4.06 | $0.35 |
| 206717 | 2019-05-13 | $52.31 | Priority Mail 2-Day Large Flat Rate Box | 14 | 2.92 lbs | $18.45 | $17.61 | $0.84 |
| 206718 | 2019-05-13 | $40.53 | Priority Mail 2-Day | 18 | 0.92 lbs | $11.71 | $10.86 | $0.85 |
| 206719 | 2019-05-13 | $5.80 | First-Class Package Service | 1 | 0.07 lbs | $3.81 | $2.76 | $1.05 |
| 206722 | 2019-05-13 | $8.52 | First-Class Package Service | 2 | 0.15 lbs | $4.54 | $2.96 | $1.58 |
| 206723 | 2019-05-14 | $89.46 | Priority Mail 2-Day | 4 | 2.45 lbs | $13.95 | $13.10 | $0.85 |
| 206725 | 2019-05-14 | $26.09 | First-Class Package Service | 22 | 0.50 lbs | $5.11 | $3.36 | $1.75 |
| 206726 | 2019-05-14 | $10.29 | First-Class Package Service | 2 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 206727 | 2019-05-14 | $203.21 | Priority Mail 3-Day | 10 | 6.20 lbs | $10.31 | $8.12 | $2.19 |
| 206729 | 2019-05-14 | $9.81 | First-Class Package Service | 2 | 0.10 lbs | $3.81 | $2.76 | $1.05 |
| 206730 | 2019-05-15 | $14.45 | First-Class Package Service | 4 | 0.76 lbs | $6.09 | $5.24 | $0.85 |
| 206731 | 2019-05-15 | $51.52 | Priority Mail 2-Day | 3 | 1.85 lbs | $13.95 | $10.55 | $3.40 |
| 206733 | 2019-05-15 | $10.74 | First-Class Package Service | 1 | 0.07 lbs | $3.75 | $2.70 | $1.05 |
| 206734 | 2019-05-16 | $13.14 | First-Class Package Service | 3 | 0.15 lbs | $4.14 | $3.09 | $1.05 |
| 206737 | 2019-05-16 | $27.23 | First-Class Package Service | 10 | 0.50 lbs | $4.33 | $3.28 | $1.05 |
| 206738 | 2019-05-16 | $34.27 | Priority Mail 2-Day | 12 | 2.40 lbs | $9.19 | $8.34 | $0.85 |
| 206739 | 2019-05-16 | $18.47 | First-Class Package Service | 7 | 0.36 lbs | $4.54 | $3.49 | $1.05 |
| 206743 | 2019-05-17 | $237.19 | Priority Mail International | 8 | 6.79 lbs | $88.37 | $81.37 | $7.00 |
| 206744 | 2019-05-17 | $12.93 | First-Class Package Service | 2 | 0.40 lbs | $5.04 | $5.38 | $-0.34 |
| 206745 | 2019-05-17 | $22.14 | First-Class Package Service | 3 | 0.46 lbs | $5.87 | $3.88 | $1.99 |
| 206747 | 2019-05-17 | $18.73 | First-Class Package Service | 8 | 0.08 lbs | $3.81 | $2.76 | $1.05 |
| 206748 | 2019-05-18 | $20.26 | First-Class Package Service | 2 | 0.29 lbs | $4.48 | $4.33 | $0.15 |
| 206750 | 2019-05-18 | $17.28 | First-Class Package Service | 3 | 0.10 lbs | $3.81 | $3.28 | $0.53 |
| 206751 | 2019-05-18 | $26.07 | First-Class Package Service | 1 | 0.85 lbs | $6.58 | $7.50 | $-0.92 |
| 206752 | 2019-05-18 | $37.84 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.35 | $7.50 | $0.85 |
| 206753 | 2019-05-18 | $7.47 | First-Class Package Service | 2 | 0.10 lbs | $3.89 | $2.84 | $1.05 |
| 206756 | 2019-05-19 | $37.84 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.35 | $7.50 | $0.85 |
| 206757 | 2019-05-20 | $21.22 | Priority Mail 3-Day | 3 | 1.05 lbs | $9.35 | $8.76 | $0.59 |
| 206758 | 2019-05-20 | $6.48 | First-Class Package Service | 3 | 0.03 lbs | $4.01 | $2.96 | $1.05 |
| 206763 | 2019-05-20 | $14.19 | First-Class Package Service | 2 | 0.06 lbs | $4.01 | $2.96 | $1.05 |
| 206764 | 2019-05-20 | $1.96 | First-Class Package Service | 4 | 0.04 lbs | $3.81 | $2.76 | $1.05 |
| 206766 | 2019-05-20 | $7.99 | First-Class Package Service | 2 | 0.21 lbs | $4.01 | $3.49 | $0.52 |
| 206767 | 2019-05-20 | $31.46 | Priority Mail 3-Day | 5 | 2.46 lbs | $10.11 | $8.76 | $1.35 |
| 206769 | 2019-05-21 | $35.84 | First-Class Package Service | 9 | 0.42 lbs | $4.93 | $3.88 | $1.05 |
| 206770 | 2019-05-21 | $24.25 | Priority Mail 3-Day | 6 | 0.84 lbs | $11.71 | $8.25 | $3.46 |
| 206771 | 2019-05-21 | $325.39 | Ground | 6 | 26.57 lbs | $46.75 | $41.10 | $5.65 |
| 206772 | 2019-05-21 | $16.06 | First-Class Package Service | 1 | 0.30 lbs | $4.27 | $3.22 | $1.05 |
| 206773 | 2019-05-21 | $27.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $7.80 | $7.55 | $0.25 |
| 206774 | 2019-05-21 | $37.82 | Priority Mail 3-Day | 7 | 2.15 lbs | $9.19 | $8.34 | $0.85 |
| 206775 | 2019-05-22 | $17.85 | First-Class Package Service | 3 | 0.38 lbs | $5.38 | $4.33 | $1.05 |
| 206777 | 2019-05-22 | $12.72 | First-Class Package Service | 3 | 0.09 lbs | $3.75 | $2.70 | $1.05 |
| 206779 | 2019-05-23 | $48.56 | Priority Mail 3-Day Flat Rate Envelope | 4 | 1.62 lbs | $7.80 | $7.50 | $0.30 |
| 206780 | 2019-05-23 | $18.67 | First-Class Package Service | 8 | 0.10 lbs | $3.75 | $2.70 | $1.05 |
| 206781 | 2019-05-23 | $10.74 | First-Class Package Service | 1 | 0.06 lbs | $3.75 | $2.70 | $1.05 |
| 206782 | 2019-05-23 | $27.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $7.80 | $7.55 | $0.25 |
| 206783 | 2019-05-24 | $7.24 | First-Class Package Service | 1 | 0.03 lbs | $3.75 | $2.70 | $1.05 |
| 206784 | 2019-05-24 | $6.00 | First-Class Package Service | 1 | 0.19 lbs | $4.01 | $2.96 | $1.05 |
| 206785 | 2019-05-24 | $19.13 | First-Class Package Service | 1 | 0.19 lbs | $4.14 | $3.63 | $0.51 |
| 206786 | 2019-05-24 | $84.07 | Priority Mail 3-Day | 4 | 2.53 lbs | $10.11 | $8.76 | $1.35 |
| 206787 | 2019-05-24 | $34.04 | First-Class Package Service | 4 | 0.50 lbs | $5.38 | $4.33 | $1.05 |
| 206790 | 2019-05-26 | $7.13 | First-Class Package Service | 1 | 0.03 lbs | $4.14 | $3.09 | $1.05 |
| 206792 | 2019-05-26 | $28.58 | Priority Mail 3-Day | 3 | 0.85 lbs | $11.71 | $8.25 | $3.46 |
| 206795 | 2019-05-26 | $35.81 | Priority Mail 2-Day | 3 | 0.76 lbs | $11.08 | $7.99 | $3.09 |
| 206796 | 2019-05-27 | $103.65 | First-Class Package International Service | 3 | 1.22 lbs | $46.58 | $36.58 | $10.00 |
| 206800 | 2019-05-27 | $6.88 | First-Class Package Service | 1 | 0.03 lbs | $3.89 | $2.84 | $1.05 |
| 206801 | 2019-05-27 | $6.77 | First-Class Package Service | 4 | 0.05 lbs | $3.81 | $2.76 | $1.05 |
| 206802 | 2019-05-27 | $42.78 | First-Class Package International Service | 1 | 1.00 lbs | $24.39 | $16.39 | $8.00 |
| 206803 | 2019-05-28 | $45.71 | Priority Mail 2-Day | 10 | 1.80 lbs | $10.11 | $9.26 | $0.85 |
| 206804 | 2019-05-28 | $38.66 | Priority Mail 2-Day | 5 | 0.90 lbs | $11.71 | $10.86 | $0.85 |
| 206805 | 2019-05-28 | $182.84 | Priority Mail International | 5 | 10.28 lbs | $88.13 | $81.13 | $7.00 |
| 206806 | 2019-05-28 | $175.42 | Priority Mail International | 3 | 8.85 lbs | $84.09 | $73.44 | $10.65 |
| 206807 | 2019-05-28 | $178.22 | Priority Mail International | 3 | 9.07 lbs | $84.09 | $77.09 | $7.00 |
| 206808 | 2019-05-28 | $108.85 | First-Class Package International Service | 3 | 2.00 lbs | $46.58 | $36.58 | $10.00 |
| 206809 | 2019-05-28 | $198.29 | Priority Mail International | 1 | 12.90 lbs | $100.29 | $97.33 | $2.96 |
| 206810 | 2019-05-28 | $49.63 | Priority Mail International Small Flat Rate Box | 14 | 1.02 lbs | $32.75 | $31.90 | $0.85 |
| 206811 | 2019-05-28 | $4.68 | First-Class Package Service | 1 | 0.20 lbs | $4.68 | $3.63 | $1.05 |
| 206812 | 2019-05-28 | $17.26 | First-Class Package Service | 1 | 0.30 lbs | $4.27 | $3.22 | $1.05 |
| 206815 | 2019-05-29 | $36.34 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.35 | $10.23 | $-1.88 |
| 206816 | 2019-05-29 | $77.55 | Priority Mail 2-Day Medium Flat Rate Box | 5 | 1.97 lbs | $13.80 | $10.55 | $3.25 |
| 206818 | 2019-05-29 | $18.12 | Priority Mail 2-Day | 1 | 0.95 lbs | $8.27 | $6.95 | $1.32 |
| 206819 | 2019-05-29 | $44.16 | Priority Mail 3-Day | 2 | 3.16 lbs | $10.88 | $10.03 | $0.85 |
| 206821 | 2019-05-29 | $90.07 | Priority Mail 2-Day Large Flat Rate Box | 18 | 3.63 lbs | $18.45 | $12.80 | $5.65 |
| 206823 | 2019-05-29 | $41.68 | Priority Mail 2-Day | 3 | 1.05 lbs | $11.71 | $10.86 | $0.85 |
| 206824 | 2019-05-29 | $26.68 | Priority Mail 2-Day | 3 | 1.26 lbs | $11.71 | $10.86 | $0.85 |
| 206825 | 2019-05-29 | $15.47 | First-Class Package Service | 1 | 0.35 lbs | $4.68 | $3.63 | $1.05 |
| 206826 | 2019-05-30 | $10.73 | First-Class Package Service | 2 | 0.06 lbs | $3.75 | $2.70 | $1.05 |
| 206827 | 2019-05-30 | $66.37 | First-Class Package International Service | 2 | 1.35 lbs | $24.39 | $16.39 | $8.00 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |