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 |
|---|---|---|---|---|---|---|---|---|
| 202610 | 2018-04-09 | $65.93 | Priority Mail 2-Day | 7 | 2.33 lbs | $14.00 | $10.29 | $3.71 |
| 202611 | 2018-04-09 | $97.98 | Priority Mail 3-Day | 3 | 1.80 lbs | $13.01 | $11.80 | $1.21 |
| 202613 | 2018-04-09 | $15.40 | First-Class Mail Large Envelope | 1 | 0.30 lbs | $3.61 | $3.18 | $0.43 |
| 202615 | 2018-04-09 | $88.46 | Priority Mail 3-Day | 5 | 1.85 lbs | $10.11 | $8.15 | $1.96 |
| 202616 | 2018-04-10 | $41.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.50 lbs | $7.90 | $6.85 | $1.05 |
| 202618 | 2018-04-10 | $48.76 | Priority Mail 3-Day Small Flat Rate Box | 14 | 0.60 lbs | $7.90 | $6.85 | $1.05 |
| 202620 | 2018-04-10 | $17.70 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 202623 | 2018-04-10 | $90.85 | Priority Mail 2-Day | 6 | 2.36 lbs | $13.01 | $9.47 | $3.54 |
| 202624 | 2018-04-10 | $361.90 | Ground | 9 | 19.00 lbs | $30.07 | $25.08 | $4.99 |
| 202626 | 2018-04-11 | $8.90 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 202628 | 2018-04-11 | $73.95 | Priority Mail 2-Day | 5 | 4.00 lbs | $11.50 | $8.15 | $3.35 |
| 202629 | 2018-04-11 | $68.55 | First-Class Package International Service | 1 | 0.60 lbs | $20.20 | $15.20 | $5.00 |
| 202630 | 2018-04-11 | $5.70 | First-Class Package Service | 1 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 202632 | 2018-04-11 | $30.47 | First-Class Package Service | 2 | 0.90 lbs | $5.79 | $4.94 | $0.85 |
| 202633 | 2018-04-11 | $6.70 | First-Class Package Service | 1 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 202634 | 2018-04-11 | $7.70 | First-Class Package Service | 1 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 202635 | 2018-04-11 | $15.40 | First-Class Mail Large Envelope | 1 | 0.30 lbs | $3.61 | $3.05 | $0.56 |
| 202637 | 2018-04-11 | $21.64 | First-Class Package Service | 7 | 0.83 lbs | $5.71 | $4.66 | $1.05 |
| 202638 | 2018-04-11 | $26.92 | First-Class Package International Service | 2 | 0.10 lbs | $18.54 | $13.54 | $5.00 |
| 202639 | 2018-04-12 | $8.18 | First-Class Package Service | 3 | 0.07 lbs | $3.71 | $2.66 | $1.05 |
| 202640 | 2018-04-12 | $48.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.50 lbs | $7.40 | $6.85 | $0.55 |
| 202641 | 2018-04-12 | $10.70 | First-Class Package Service | 1 | 0.06 lbs | $3.71 | $2.66 | $1.05 |
| 202642 | 2018-04-12 | $38.28 | Priority Mail 2-Day | 2 | 0.63 lbs | $9.00 | $7.91 | $1.09 |
| 202643 | 2018-04-12 | $24.86 | First-Class Package Service | 3 | 0.39 lbs | $4.39 | $3.18 | $1.21 |
| 202644 | 2018-04-12 | $28.77 | Priority Mail 3-Day | 5 | 1.75 lbs | $9.32 | $7.40 | $1.92 |
| 202645 | 2018-04-13 | $6.50 | First-Class Package Service | 1 | 0.06 lbs | $3.71 | $2.66 | $1.05 |
| 202646 | 2018-04-13 | $32.15 | First-Class Mail Large Envelope | 2 | 0.65 lbs | $4.87 | $4.38 | $0.49 |
| 202647 | 2018-04-13 | $9.69 | First-Class Package Service | 2 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 202651 | 2018-04-13 | $9.85 | First-Class Mail Large Envelope | 2 | 0.50 lbs | $4.87 | $4.66 | $0.21 |
| 202652 | 2018-04-13 | $10.41 | First-Class Package Service | 6 | 0.25 lbs | $3.97 | $2.92 | $1.05 |
| 202653 | 2018-04-13 | $13.13 | First-Class Package Service | 8 | 0.09 lbs | $3.71 | $2.66 | $1.05 |
| 202654 | 2018-04-13 | $17.84 | First-Class Package Service | 3 | 0.13 lbs | $3.97 | $2.79 | $1.18 |
| 202655 | 2018-04-13 | $15.40 | First-Class Mail Large Envelope | 1 | 0.25 lbs | $3.61 | $3.18 | $0.43 |
| 202656 | 2018-04-14 | $25.69 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.85 lbs | $7.40 | $6.90 | $0.50 |
| 202657 | 2018-04-14 | $8.60 | First-Class Package Service | 1 | 0.07 lbs | $3.71 | $2.66 | $1.05 |
| 202658 | 2018-04-14 | $34.77 | Priority Mail 3-Day Small Flat Rate Box | 5 | 0.67 lbs | $7.90 | $6.85 | $1.05 |
| 202659 | 2018-04-14 | $8.90 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 202662 | 2018-04-14 | $8.15 | First-Class Package Service | 6 | 0.08 lbs | $3.71 | $2.66 | $1.05 |
| 202668 | 2018-04-15 | $59.28 | Priority Mail 2-Day | 1 | 3.90 lbs | $11.50 | $13.77 | $-2.27 |
| 202669 | 2018-04-15 | $58.90 | Priority Mail 2-Day | 2 | 1.95 lbs | $9.32 | $8.22 | $1.10 |
| 202671 | 2018-04-15 | $53.93 | Priority Mail 3-Day | 10 | 3.50 lbs | $15.03 | $9.47 | $5.56 |
| 202672 | 2018-04-16 | $96.51 | Priority Mail 3-Day | 2 | 1.75 lbs | $8.53 | $7.25 | $1.28 |
| 202674 | 2018-04-16 | $5.76 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 202675 | 2018-04-16 | $45.32 | First-Class Package International Service | 1 | 0.45 lbs | $27.33 | $22.33 | $5.00 |
| 202676 | 2018-04-16 | $47.93 | Priority Mail 2-Day | 1 | 1.15 lbs | $11.14 | $9.98 | $1.16 |
| 202679 | 2018-04-16 | $23.50 | First-Class Mail Large Envelope | 2 | 0.32 lbs | $3.82 | $3.34 | $0.48 |
| 202680 | 2018-04-16 | $15.46 | First-Class Package Service | 5 | 0.62 lbs | $5.51 | $4.94 | $0.57 |
| 202681 | 2018-04-16 | $19.65 | First-Class Package Service | 6 | 0.07 lbs | $3.71 | $2.66 | $1.05 |
| 202683 | 2018-04-16 | $48.12 | Priority Mail 2-Day | 10 | 1.05 lbs | $10.32 | $9.19 | $1.13 |
| 202687 | 2018-04-17 | $30.21 | First-Class Package Service | 2 | 0.29 lbs | $4.23 | $2.92 | $1.31 |
| 202690 | 2018-04-17 | $14.23 | First-Class Package Service | 1 | 0.10 lbs | $3.84 | $2.79 | $1.05 |
| 202691 | 2018-04-17 | $18.21 | First-Class Package Service | 3 | 0.16 lbs | $3.84 | $2.79 | $1.05 |
| 202693 | 2018-04-17 | $10.63 | First-Class Mail Large Envelope | 3 | 0.51 lbs | $4.66 | $4.66 | $0.00 |
| 202694 | 2018-04-17 | $57.12 | First-Class Package International Service | 21 | 0.65 lbs | $27.33 | $22.33 | $5.00 |
| 202696 | 2018-04-17 | $47.10 | Priority Mail 2-Day | 4 | 3.52 lbs | $9.54 | $7.40 | $2.14 |
| 202698 | 2018-04-17 | $16.34 | Priority Mail 3-Day | 1 | 0.65 lbs | $8.35 | $7.28 | $1.07 |
| 202700 | 2018-04-18 | $25.39 | First-Class Package Service | 4 | 0.20 lbs | $5.43 | $2.92 | $2.51 |
| 202702 | 2018-04-18 | $87.48 | Ground | 20 | 6.50 lbs | $23.68 | $22.54 | $1.14 |
| 202703 | 2018-04-18 | $37.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $7.90 | $6.85 | $1.05 |
| 202704 | 2018-04-18 | $39.97 | Priority Mail 2-Day | 15 | 2.57 lbs | $16.92 | $15.59 | $1.33 |
| 202705 | 2018-04-18 | $15.81 | First-Class Package Service | 3 | 0.21 lbs | $3.84 | $3.05 | $0.79 |
| 202707 | 2018-04-18 | $129.44 | Ground | 1 | 15.30 lbs | $21.95 | $12.92 | $9.03 |
| 202708 | 2018-04-18 | $131.82 | Priority Mail International | 1 | 5.65 lbs | $64.53 | $60.28 | $4.25 |
| 202709 | 2018-04-18 | $13.75 | First-Class Package Service | 2 | 0.20 lbs | $3.97 | $2.66 | $1.31 |
| 202713 | 2018-04-18 | $46.39 | Priority Mail 2-Day | 3 | 1.38 lbs | $10.32 | $9.19 | $1.13 |
| 202718 | 2018-04-19 | $7.20 | First-Class Package Service | 1 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 202720 | 2018-04-19 | $55.91 | First-Class Package International Service | 10 | 0.96 lbs | $20.20 | $15.20 | $5.00 |
| 202724 | 2018-04-19 | $9.02 | First-Class Mail Large Envelope | 1 | 0.44 lbs | $4.03 | $3.82 | $0.21 |
| 202725 | 2018-04-19 | $201.30 | Ground | 1 | 14.05 lbs | $31.31 | $27.34 | $3.97 |
| 202727 | 2018-04-20 | $50.61 | Ground | 2 | 1.50 lbs | $13.03 | $7.18 | $5.85 |
| 202728 | 2018-04-20 | $6.60 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 202729 | 2018-04-20 | $148.08 | Priority Mail 2-Day | 3 | 10.20 lbs | $23.91 | $24.94 | $-1.03 |
| 202731 | 2018-04-20 | $136.81 | First-Class Package International Service | 2 | 3.40 lbs | $53.93 | $56.76 | $-2.83 |
| 202732 | 2018-04-20 | $58.98 | Priority Mail 3-Day | 2 | 1.95 lbs | $14.00 | $12.76 | $1.24 |
| 202733 | 2018-04-20 | $90.83 | Priority Mail 2-Day | 9 | 1.78 lbs | $9.32 | $8.22 | $1.10 |
| 202735 | 2018-04-21 | $815.20 | Priority Mail International | 60 | 34.47 lbs | $272.00 | $184.16 | $87.84 |
| 202736 | 2018-04-21 | $31.03 | First-Class Mail Large Envelope | 8 | 0.32 lbs | $3.61 | $3.34 | $0.27 |
| 202737 | 2018-04-21 | $152.44 | Priority Mail International | 9 | 4.57 lbs | $64.53 | $60.28 | $4.25 |
| 202738 | 2018-04-21 | $36.81 | Priority Mail 2-Day | 1 | 0.57 lbs | $10.32 | $9.19 | $1.13 |
| 202739 | 2018-04-21 | $66.57 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.98 lbs | $7.40 | $6.85 | $0.55 |
| 202741 | 2018-04-21 | $6.92 | First-Class Package Service | 2 | 0.49 lbs | $5.43 | $2.79 | $2.64 |
| 202742 | 2018-04-21 | $28.33 | Priority Mail 2-Day | 7 | 1.54 lbs | $9.00 | $7.91 | $1.09 |
| 202743 | 2018-04-21 | $130.31 | Direct Link International | 4 | 4.08 lbs | $45.51 | $9.42 | $36.09 |
| 202744 | 2018-04-21 | $62.51 | Ground | 3 | 1.35 lbs | $18.94 | $16.44 | $2.50 |
| 202746 | 2018-04-22 | $52.33 | First-Class Package International Service | 1 | 0.30 lbs | $27.33 | $22.33 | $5.00 |
| 202747 | 2018-04-22 | $37.29 | First-Class Package International Service | 1 | 0.07 lbs | $18.30 | $13.30 | $5.00 |
| 202748 | 2018-04-22 | $10.19 | First-Class Package Service | 2 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 202750 | 2018-04-22 | $33.69 | Priority Mail 2-Day | 3 | 0.85 lbs | $10.32 | $9.19 | $1.13 |
| 202756 | 2018-04-24 | $153.89 | Priority Mail 3-Day | 1 | 15.30 lbs | $46.40 | $44.18 | $2.22 |
| 202757 | 2018-04-24 | $24.23 | First-Class Mail Large Envelope | 1 | 0.35 lbs | $4.24 | $3.18 | $1.06 |
| 202759 | 2018-04-24 | $11.49 | First-Class Package Service | 2 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 202761 | 2018-04-24 | $37.39 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $7.90 | $6.85 | $1.05 |
| 202762 | 2018-04-24 | $75.11 | First-Class Package International Service | 2 | 1.45 lbs | $27.33 | $22.33 | $5.00 |
| 202764 | 2018-04-24 | $16.28 | Priority Mail 2-Day Flat Rate Envelope | 12 | 0.30 lbs | $7.40 | $13.70 | $-6.30 |
| 202770 | 2018-04-25 | $14.09 | First-Class Package Service | 2 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 202772 | 2018-04-25 | $8.01 | First-Class Mail Large Envelope | 2 | 0.34 lbs | $4.03 | $3.82 | $0.21 |
| 202776 | 2018-04-25 | $5.69 | First-Class Package Service | 2 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 202777 | 2018-04-25 | $13.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.10 lbs | $7.40 | $6.85 | $0.55 |
| 202779 | 2018-04-25 | $12.61 | First-Class Package Service | 3 | 0.17 lbs | $3.84 | $2.92 | $0.92 |
| 202780 | 2018-04-25 | $89.71 | First-Class Package International Service | 18 | 3.17 lbs | $40.39 | $35.39 | $5.00 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |