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 |
|---|---|---|---|---|---|---|---|---|
| 226548 | 2021-08-05 | $11.71 | United States | 1 | 0.05 lbs | $3.95 | $3.35 | $0.60 |
| 226549 | 2021-08-05 | $24.67 | Priority Mail 1-Day | 3 | 0.04 lbs | $8.26 | $7.16 | $1.10 |
| 226550 | 2021-08-06 | $10.85 | USPSFirstClass | 1 | 0.05 lbs | $4.56 | $3.22 | $1.34 |
| 226552 | 2021-08-05 | $7.74 | United States | 1 | 0.05 lbs | $3.95 | $3.85 | $0.10 |
| 226553 | 2021-08-05 | $72.94 | Priority Mail 2-Day | 1 | 1.00 lbs | $9.95 | $7.88 | $2.07 |
| 226554 | 2021-08-05 | $50.22 | Ground | 1 | 0.40 lbs | $20.23 | $15.53 | $4.70 |
| 226555 | 2021-08-06 | $72.94 | Priority Mail 2-Day | 1 | 1.00 lbs | $9.95 | $8.85 | $1.10 |
| 226557 | 2021-08-06 | $8.90 | Free Shipping | 2 | 0.26 lbs | $0.00 | $3.46 | $-3.46 |
| 226559 | 2021-08-06 | $11.45 | USPSFirstClass | 2 | 0.10 lbs | $4.47 | $3.35 | $1.12 |
| 226560 | 2021-08-06 | $12.43 | USPSFirstClass | 1 | 0.05 lbs | $4.64 | $3.22 | $1.42 |
| 226562 | 2021-08-06 | $45.27 | Priority Mail 2-Day Flat Rate Envelope | 3 | 2.47 lbs | $8.50 | $7.90 | $0.60 |
| 226563 | 2021-08-06 | $74.94 | USPSPriority | 1 | 1.00 lbs | $11.95 | $10.44 | $1.51 |
| 226565 | 2021-08-06 | $14.14 | Priority Mail 2-Day | 3 | 0.09 lbs | $8.77 | $7.40 | $1.37 |
| 226567 | 2021-08-06 | $3.39 | Free Shipping | 1 | 0.06 lbs | $0.00 | $3.35 | $-3.35 |
| 226568 | 2021-08-06 | $12.45 | First-Class Mail Stamped Letter | 5 | 0.05 lbs | $3.80 | $3.12 | $0.68 |
| 226570 | 2021-08-06 | $44.93 | United States | 2 | 0.30 lbs | $4.25 | $5.81 | $-1.56 |
| 226571 | 2021-08-07 | $10.94 | USPSFirstClass | 6 | 0.06 lbs | $5.00 | $3.12 | $1.88 |
| 226572 | 2021-08-07 | $44.40 | USPSPriority | 1 | 5.30 lbs | $27.97 | $13.75 | $14.22 |
| 226575 | 2021-08-06 | $113.21 | Priority Mail 3-Day | 26 | 2.52 lbs | $9.82 | $8.00 | $1.82 |
| 226577 | 2021-08-06 | $16.31 | First-Class Package Service | 2 | 0.44 lbs | $5.33 | $4.38 | $0.95 |
| 226585 | 2021-08-07 | $30.08 | First-Class Package Service | 2 | 0.61 lbs | $5.40 | $4.20 | $1.20 |
| 226591 | 2021-08-07 | $40.78 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.30 lbs | $9.00 | $7.90 | $1.10 |
| 226594 | 2021-08-07 | $10.21 | USPSFirstClass | 1 | 0.10 lbs | $4.72 | $3.49 | $1.23 |
| 226595 | 2021-08-07 | $24.47 | First-Class Package Service | 1 | 0.40 lbs | $5.48 | $3.69 | $1.79 |
| 226597 | 2021-08-07 | $64.00 | Ground | 6 | 5.94 lbs | $32.14 | $19.17 | $12.97 |
| 226599 | 2021-08-07 | $19.74 | United States | 1 | 0.95 lbs | $8.50 | $8.52 | $-0.02 |
| 226601 | 2021-08-07 | $7.93 | First-Class Package Service | 1 | 0.05 lbs | $4.55 | $3.35 | $1.20 |
| 226602 | 2021-08-08 | $6.29 | USPSFirstClass | 1 | 0.03 lbs | $4.30 | $3.12 | $1.18 |
| 226603 | 2021-08-07 | $48.54 | United States | 2 | 2.60 lbs | $9.95 | $12.64 | $-2.69 |
| 226604 | 2021-08-07 | $129.80 | United States | 3 | 5.03 lbs | $13.95 | $11.42 | $2.53 |
| 226605 | 2021-08-08 | $6.94 | United States | 1 | 0.19 lbs | $4.15 | $3.35 | $0.80 |
| 226606 | 2021-08-08 | $12.43 | USPSFirstClass | 1 | 0.20 lbs | $4.54 | $3.51 | $1.03 |
| 226607 | 2021-08-08 | $9.35 | USPSFirstClass | 2 | 0.02 lbs | $4.37 | $3.22 | $1.15 |
| 226608 | 2021-08-08 | $35.83 | Priority Mail 3-Day | 1 | 0.57 lbs | $9.34 | $8.24 | $1.10 |
| 226610 | 2021-08-08 | $316.50 | Priority Mail 3-Day | 2 | 14.40 lbs | $61.52 | $50.42 | $11.10 |
| 226612 | 2021-08-08 | $22.31 | First-Class Package Service | 1 | 0.40 lbs | $5.32 | $3.51 | $1.81 |
| 226615 | 2021-08-08 | $60.78 | United States | 7 | 1.82 lbs | $9.25 | $9.64 | $-0.39 |
| 226616 | 2021-08-08 | $20.30 | Priority Mail 3-Day | 1 | 0.95 lbs | $9.06 | $7.46 | $1.60 |
| 226618 | 2021-08-09 | $67.57 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.39 lbs | $8.50 | $7.88 | $0.62 |
| 226619 | 2021-08-09 | $21.66 | USPSPriority | 1 | 1.15 lbs | $9.17 | $7.90 | $1.27 |
| 226620 | 2021-08-09 | $12.53 | USPSFirstClass | 1 | 0.20 lbs | $4.64 | $3.58 | $1.06 |
| 226621 | 2021-08-09 | $9.38 | USPSFirstClass | 1 | 0.04 lbs | $4.49 | $3.22 | $1.27 |
| 226623 | 2021-08-09 | $100.93 | United States | 2 | 4.83 lbs | $12.95 | $8.00 | $4.95 |
| 226625 | 2021-08-09 | $41.79 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $9.00 | $7.90 | $1.10 |
| 226626 | 2021-08-09 | $58.17 | Ground | 2 | 1.70 lbs | $14.50 | $25.08 | $-10.58 |
| 226630 | 2021-08-09 | $9.88 | First-Class Mail Stamped Letter | 12 | 0.12 lbs | $4.00 | $3.22 | $0.78 |
| 226631 | 2021-08-10 | $38.58 | USPSFirstClass | 1 | 0.25 lbs | $5.79 | $4.12 | $1.67 |
| 226632 | 2021-08-10 | $12.53 | USPSFirstClass | 1 | 0.06 lbs | $4.64 | $3.22 | $1.42 |
| 226633 | 2021-08-09 | $20.99 | Selected States in United States | 1 | 0.95 lbs | $8.50 | $8.34 | $0.16 |
| 226634 | 2021-08-09 | $10.20 | First-Class Package Service | 1 | 0.10 lbs | $4.71 | $3.06 | $1.65 |
| 226636 | 2021-08-10 | $12.73 | USPSFirstClass | 1 | 0.20 lbs | $4.84 | $3.85 | $0.99 |
| 226641 | 2021-08-10 | $12.27 | First-Class Package Service | 2 | 0.10 lbs | $4.42 | $3.22 | $1.20 |
| 226644 | 2021-08-10 | $45.99 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $9.00 | $7.90 | $1.10 |
| 226646 | 2021-08-10 | $38.51 | Priority Mail 3-Day Flat Rate Envelope | 3 | 2.29 lbs | $8.50 | $8.00 | $0.50 |
| 226650 | 2021-08-11 | $13.91 | USPSFirstClass | 4 | 0.60 lbs | $5.95 | $5.81 | $0.14 |
| 226651 | 2021-08-10 | $22.20 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.23 lbs | $8.50 | $7.40 | $1.10 |
| 226652 | 2021-08-10 | $43.62 | Priority Mail 2-Day | 1 | 1.30 lbs | $11.54 | $10.44 | $1.10 |
| 226653 | 2021-08-10 | $31.01 | First-Class Package International Service | 1 | 0.09 lbs | $25.39 | $17.34 | $8.05 |
| 226654 | 2021-08-11 | $12.06 | USPSFirstClass | 2 | 0.10 lbs | $4.64 | $3.49 | $1.15 |
| 226655 | 2021-08-11 | $6.56 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.60 | $3.35 | $0.25 |
| 226656 | 2021-08-11 | $22.33 | Priority Mail 3-Day | 1 | 0.95 lbs | $9.34 | $7.67 | $1.67 |
| 226658 | 2021-08-11 | $66.67 | Priority Mail 2-Day | 2 | 1.95 lbs | $10.74 | $9.01 | $1.73 |
| 226667 | 2021-08-12 | $65.08 | Priority Mail 3-Day | 7 | 0.99 lbs | $12.11 | $11.01 | $1.10 |
| 226670 | 2021-08-12 | $116.62 | Priority Mail 3-Day | 1 | 3.00 lbs | $10.31 | $9.21 | $1.10 |
| 226671 | 2021-08-12 | $110.83 | Priority Mail 2-Day | 3 | 11.95 lbs | $38.08 | $25.99 | $12.09 |
| 226673 | 2021-08-12 | $37.32 | Priority Mail 2-Day | 1 | 1.15 lbs | $9.34 | $7.90 | $1.44 |
| 226674 | 2021-08-13 | $12.63 | USPSFirstClass | 1 | 0.04 lbs | $4.84 | $3.49 | $1.35 |
| 226675 | 2021-08-13 | $12.48 | USPSFirstClass | 1 | 0.04 lbs | $4.69 | $3.35 | $1.34 |
| 226677 | 2021-08-12 | $51.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.80 lbs | $8.50 | $8.00 | $0.50 |
| 226679 | 2021-08-12 | $10.71 | First-Class Package Service | 3 | 0.34 lbs | $4.89 | $4.53 | $0.36 |
| 226682 | 2021-08-13 | $35.19 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.85 lbs | $8.50 | $7.90 | $0.60 |
| 226683 | 2021-08-13 | $25.10 | Priority Mail 2-Day | 1 | 0.95 lbs | $12.11 | $8.52 | $3.59 |
| 226684 | 2021-08-13 | $13.03 | USPSFirstClass | 1 | 0.50 lbs | $5.57 | $4.68 | $0.89 |
| 226686 | 2021-08-13 | $16.03 | United States | 8 | 0.30 lbs | $4.75 | $3.22 | $1.53 |
| 226687 | 2021-08-13 | $16.64 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.10 lbs | $8.50 | $7.90 | $0.60 |
| 226688 | 2021-08-13 | $33.34 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $9.00 | $7.90 | $1.10 |
| 226690 | 2021-08-14 | $26.69 | USPSFirstClass | 1 | 0.63 lbs | $6.70 | $4.38 | $2.32 |
| 226691 | 2021-08-14 | $7.06 | USPSFirstClass | 1 | 0.01 lbs | $4.57 | $3.49 | $1.08 |
| 226692 | 2021-08-14 | $23.21 | USPSPriority | 1 | 1.15 lbs | $10.72 | $7.90 | $2.82 |
| 226693 | 2021-08-13 | $7.70 | First-Class Package Service | 1 | 0.19 lbs | $4.71 | $3.06 | $1.65 |
| 226699 | 2021-08-14 | $212.46 | Priority Mail 2-Day | 1 | 13.15 lbs | $15.92 | $14.82 | $1.10 |
| 226701 | 2021-08-14 | $237.61 | Ground | 2 | 13.50 lbs | $45.15 | $34.56 | $10.59 |
| 226704 | 2021-08-14 | $8.17 | USPSFirstClass | 1 | 0.02 lbs | $4.48 | $3.35 | $1.13 |
| 226705 | 2021-08-14 | $32.69 | First-Class Package Service | 7 | 0.76 lbs | $6.93 | $5.98 | $0.95 |
| 226707 | 2021-08-14 | $80.59 | Ground | 4 | 0.38 lbs | $24.57 | $18.65 | $5.92 |
| 226708 | 2021-08-14 | $48.92 | United States | 3 | 2.85 lbs | $9.95 | $9.21 | $0.74 |
| 226709 | 2021-08-14 | $14.11 | Priority Mail 3-Day | 3 | 0.06 lbs | $8.56 | $7.40 | $1.16 |
| 226711 | 2021-08-14 | $29.85 | First-Class Package Service | 2 | 0.67 lbs | $6.37 | $5.42 | $0.95 |
| 226712 | 2021-08-14 | $9.70 | First-Class Mail Stamped Letter | 10 | 0.10 lbs | $3.80 | $3.49 | $0.31 |
| 226715 | 2021-08-14 | $57.68 | Selected States in United States | 1 | 3.95 lbs | $11.95 | $16.78 | $-4.83 |
| 226717 | 2021-08-15 | $28.15 | USPSPriority | 1 | 1.10 lbs | $12.72 | $10.89 | $1.83 |
| 226718 | 2021-08-15 | $15.73 | USPSFirstClass | 1 | 0.05 lbs | $4.75 | $3.12 | $1.63 |
| 226719 | 2021-08-15 | $8.30 | USPSFirstClass | 1 | 0.06 lbs | $4.35 | $3.06 | $1.29 |
| 226720 | 2021-08-15 | $13.37 | First-Class Package Service | 3 | 0.06 lbs | $4.26 | $3.06 | $1.20 |
| 226723 | 2021-08-15 | $58.53 | Priority Mail 2-Day | 1 | 3.95 lbs | $12.80 | $11.70 | $1.10 |
| 226724 | 2021-08-15 | $24.15 | USPSFirstClass | 3 | 0.24 lbs | $5.31 | $4.38 | $0.93 |
| 226726 | 2021-08-15 | $34.27 | First-Class Package Service | 5 | 0.46 lbs | $5.32 | $3.51 | $1.81 |
| 226727 | 2021-08-16 | $12.48 | USPSFirstClass | 1 | 0.06 lbs | $4.69 | $3.35 | $1.34 |
| 226728 | 2021-08-16 | $15.68 | USPSFirstClass | 1 | 0.05 lbs | $4.70 | $3.06 | $1.64 |
| 226731 | 2021-08-15 | $9.78 | First-Class Mail Stamped Letter | 2 | 0.08 lbs | $3.80 | $3.06 | $0.74 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |