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 |
|---|---|---|---|---|---|---|---|---|
| 232534 | 2023-12-04 | $35.21 | Priority Mail Medium Flat Rate Box | 1 | 7.00 lbs | $16.40 | $14.75 | $1.65 |
| 232536 | 2023-12-05 | $3.99 | Priority Mail Flat Rate Envelope | 1 | 0.03 lbs | $0.00 | $3.97 | $-3.97 |
| 232538 | 2023-12-05 | $149.37 | Priority Mail | 23 | 5.17 lbs | $11.88 | $10.48 | $1.40 |
| 232540 | 2023-12-06 | $13.82 | Priority Mail Flat Rate Envelope | 2 | 0.09 lbs | $9.15 | $8.55 | $0.60 |
| 232541 | 2023-12-07 | $25.14 | USPS First Class | 1 | 0.12 lbs | $5.25 | $4.13 | $1.12 |
| 232542 | 2023-12-07 | $16.84 | USPS Ground Advantage | 1 | 0.30 lbs | $5.85 | $4.44 | $1.41 |
| 232543 | 2023-12-07 | $28.97 | USPS Ground Parcel or Priority Mail | 1 | 3.50 lbs | $9.15 | $6.09 | $3.06 |
| 232544 | 2023-12-07 | $14.95 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $3.81 | $4.37 |
| 232547 | 2023-12-07 | $10.04 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 232548 | 2023-12-07 | $11.84 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 232549 | 2023-12-07 | $16.84 | USPS Ground Advantage | 1 | 0.70 lbs | $5.85 | $6.78 | $-0.93 |
| 232550 | 2023-12-07 | $15.39 | USPS First Class | 1 | 0.15 lbs | $5.10 | $3.90 | $1.20 |
| 232552 | 2023-12-09 | $20.87 | Priority Mail | 2 | 0.11 lbs | $9.34 | $8.05 | $1.29 |
| 232556 | 2023-12-10 | $17.62 | Priority Mail Flat Rate Envelope | 1 | 0.06 lbs | $9.15 | $8.05 | $1.10 |
| 232557 | 2023-12-10 | $10.79 | USPS First Class | 1 | 0.05 lbs | $5.00 | $3.75 | $1.25 |
| 232559 | 2023-12-12 | $11.14 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 232560 | 2023-12-12 | $32.98 | USPS First Class | 2 | 0.49 lbs | $11.10 | $4.44 | $6.66 |
| 232561 | 2023-12-11 | $13.64 | USPS Ground Advantage | 1 | 0.30 lbs | $5.85 | $5.33 | $0.52 |
| 232562 | 2023-12-12 | $39.75 | USPS Ground Parcel or Priority Mail | 2 | 0.25 lbs | $16.36 | $8.55 | $7.81 |
| 232563 | 2023-12-12 | $8.54 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 232564 | 2023-12-12 | $13.24 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 232565 | 2023-12-14 | $56.33 | USPS Ground Parcel or Priority Mail | 1 | 1.17 lbs | $9.15 | $8.55 | $0.60 |
| 232566 | 2023-12-14 | $12.04 | USPS First Class | 1 | 0.12 lbs | $5.25 | $4.13 | $1.12 |
| 232567 | 2023-12-14 | $11.74 | USPS First Class | 1 | 0.08 lbs | $5.05 | $3.81 | $1.24 |
| 232569 | 2023-12-15 | $44.26 | Priority Mail Small Flat Rate Box | 1 | 1.30 lbs | $9.65 | $8.55 | $1.10 |
| 232571 | 2023-12-16 | $33.61 | Priority Mail | 3 | 0.60 lbs | $11.08 | $9.43 | $1.65 |
| 232572 | 2023-12-16 | $13.84 | USPS First Class | 1 | 0.30 lbs | $5.85 | $4.44 | $1.41 |
| 232575 | 2023-12-18 | $12.87 | USPS Ground Parcel or Priority Mail | 1 | 0.15 lbs | $8.18 | $4.31 | $3.87 |
| 232576 | 2023-12-19 | $71.54 | USPS First Class | 1 | 0.50 lbs | $5.55 | $4.74 | $0.81 |
| 232577 | 2023-12-19 | $12.04 | USPS First Class | 1 | 0.12 lbs | $5.25 | $4.13 | $1.12 |
| 232578 | 2023-12-19 | $20.54 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 232581 | 2023-12-20 | $12.94 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 232582 | 2023-12-20 | $23.17 | USPS Ground Parcel or Priority Mail | 1 | 0.75 lbs | $8.18 | $6.09 | $2.09 |
| 232583 | 2023-12-21 | $25.04 | USPS First Class | 1 | 0.15 lbs | $5.05 | $3.81 | $1.24 |
| 232586 | 2023-12-22 | $34.54 | Priority Mail | 3 | 1.05 lbs | $10.39 | $7.05 | $3.34 |
| 232589 | 2023-12-23 | $43.48 | Priority Mail | 6 | 1.00 lbs | $11.04 | $8.82 | $2.22 |
| 232590 | 2023-12-25 | $42.14 | USPS First Class | 1 | 0.31 lbs | $5.65 | $4.88 | $0.77 |
| 232591 | 2023-12-23 | $7.29 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 232592 | 2023-12-23 | $9.24 | USPS First Class | 1 | 0.08 lbs | $5.25 | $4.13 | $1.12 |
| 232594 | 2023-12-27 | $20.44 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 232595 | 2023-12-26 | $9.94 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 232597 | 2023-12-27 | $23.75 | Priority Mail Flat Rate Envelope | 3 | 0.27 lbs | $9.15 | $8.55 | $0.60 |
| 232598 | 2023-12-28 | $41.15 | Priority Mail | 8 | 0.66 lbs | $13.07 | $11.97 | $1.10 |
| 232599 | 2023-12-28 | $9.09 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 232600 | 2023-12-28 | $7.04 | USPS First Class | 1 | 0.03 lbs | $5.05 | $3.81 | $1.24 |
| 232601 | 2023-12-28 | $54.07 | Priority Mail | 10 | 4.00 lbs | $26.07 | $24.97 | $1.10 |
| 232602 | 2023-12-28 | $12.94 | USPS First Class | 1 | 0.04 lbs | $5.05 | $3.81 | $1.24 |
| 232603 | 2023-12-28 | $8.24 | USPS First Class | 1 | 0.01 lbs | $5.15 | $3.97 | $1.18 |
| 232604 | 2023-12-29 | $24.14 | Priority Mail Flat Rate Envelope | 1 | 0.20 lbs | $9.15 | $8.05 | $1.10 |
| 232605 | 2023-12-30 | $43.26 | Priority Mail Flat Rate Envelope | 1 | 3.55 lbs | $9.15 | $8.80 | $0.35 |
| 232607 | 2023-12-30 | $22.09 | Priority Mail Flat Rate Envelope | 6 | 0.14 lbs | $9.15 | $8.55 | $0.60 |
| 232610 | 2023-12-31 | $17.09 | Priority Mail Flat Rate Envelope | 1 | 0.05 lbs | $9.15 | $8.55 | $0.60 |
| 232612 | 2023-12-31 | $13.24 | USPS First Class | 1 | 0.04 lbs | $5.25 | $4.13 | $1.12 |
| 232613 | 2023-12-30 | $13.44 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 232614 | 2023-12-30 | $12.74 | USPS First Class | 1 | 0.03 lbs | $5.25 | $4.13 | $1.12 |
| 232615 | 2023-12-29 | $30.89 | USPS Ground Advantage | 1 | 0.69 lbs | $6.40 | $6.09 | $0.31 |
| 232617 | 2024-01-02 | $9.94 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 232618 | 2024-01-02 | $14.54 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 232619 | 2024-01-01 | $13.54 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 232621 | 2024-01-03 | $25.24 | USPS First Class | 1 | 0.15 lbs | $5.25 | $4.13 | $1.12 |
| 232622 | 2024-01-02 | $11.64 | USPS First Class | 1 | 0.36 lbs | $5.65 | $3.81 | $1.84 |
| 232623 | 2024-01-03 | $30.97 | USPS Ground Parcel or Priority Mail | 2 | 1.66 lbs | $16.36 | $9.77 | $6.59 |
| 232624 | 2024-01-03 | $25.99 | USPS Ground Advantage | 1 | 0.92 lbs | $8.00 | $6.12 | $1.88 |
| 232625 | 2024-01-03 | $28.80 | Priority Mail | 4 | 1.00 lbs | $11.04 | $8.82 | $2.22 |
| 232626 | 2024-01-03 | $18.64 | USPS First Class | 1 | 0.60 lbs | $6.65 | $4.13 | $2.52 |
| 232628 | 2024-01-04 | $30.12 | USPS Ground Parcel or Priority Mail | 1 | 0.35 lbs | $8.18 | $5.04 | $3.14 |
| 232630 | 2024-01-04 | $25.04 | USPS First Class | 1 | 0.15 lbs | $5.05 | $3.81 | $1.24 |
| 232631 | 2024-01-04 | $20.04 | USPS First Class | 1 | 0.40 lbs | $5.65 | $4.20 | $1.45 |
| 232632 | 2024-01-05 | $13.89 | USPS First Class | 1 | 0.12 lbs | $5.10 | $3.90 | $1.20 |
| 232633 | 2024-01-05 | $65.81 | Priority Mail Flat Rate Envelope | 6 | 0.09 lbs | $9.15 | $8.55 | $0.60 |
| 232634 | 2024-01-07 | $13.64 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 232635 | 2024-01-06 | $9.74 | USPS First Class | 1 | 0.41 lbs | $5.75 | $5.17 | $0.58 |
| 232636 | 2024-01-06 | $26.59 | USPS Priority Mail | 1 | 1.10 lbs | $15.60 | $10.07 | $5.53 |
| 232637 | 2024-01-06 | $12.59 | USPS First Class | 1 | 0.03 lbs | $5.10 | $3.90 | $1.20 |
| 232638 | 2024-01-06 | $16.84 | USPS Ground Advantage | 1 | 0.70 lbs | $5.85 | $6.78 | $-0.93 |
| 232639 | 2024-01-05 | $15.34 | USPS First Class | 1 | 0.07 lbs | $5.05 | $3.81 | $1.24 |
| 232640 | 2024-01-05 | $10.84 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 232641 | 2024-01-08 | $79.39 | Priority Mail Medium Flat Rate Box | 1 | 5.30 lbs | $16.40 | $14.75 | $1.65 |
| 232642 | 2024-01-08 | $14.87 | USPS Ground Parcel or Priority Mail | 1 | 0.10 lbs | $8.18 | $4.13 | $4.05 |
| 232652 | 2024-01-12 | $118.62 | Priority Mail Padded Flat Rate Envelope | 1 | 1.86 lbs | $9.90 | $8.80 | $1.10 |
| 232656 | 2024-01-14 | $17.06 | Priority Mail Flat Rate Envelope | 2 | 0.04 lbs | $9.15 | $8.55 | $0.60 |
| 232658 | 2024-01-15 | $17.14 | Priority Mail Flat Rate Envelope | 1 | 0.45 lbs | $9.15 | $8.55 | $0.60 |
| 232661 | 2024-01-15 | $34.92 | USPS Ground Parcel or Priority Mail | 2 | 0.60 lbs | $16.36 | $5.33 | $11.03 |
| 232668 | 2024-01-19 | $40.58 | Priority Mail Flat Rate Envelope | 2 | 0.87 lbs | $9.60 | $8.74 | $0.86 |
| 232672 | 2024-01-20 | $17.69 | Priority Mail Flat Rate Envelope | 4 | 0.18 lbs | $9.60 | $8.74 | $0.86 |
| 232675 | 2024-01-20 | $25.17 | USPS Ground Parcel or Priority Mail | 1 | 0.22 lbs | $8.18 | $4.55 | $3.63 |
| 232677 | 2024-01-21 | $34.27 | Priority Mail | 15 | 0.81 lbs | $10.62 | $6.91 | $3.71 |
| 232688 | 2024-01-23 | $54.92 | Priority Mail | 20 | 3.80 lbs | $14.52 | $13.37 | $1.15 |
| 232695 | 2024-01-25 | $18.32 | Priority Mail | 2 | 0.07 lbs | $11.69 | $8.51 | $3.18 |
| 232696 | 2024-01-26 | $44.34 | Priority Mail | 12 | 2.28 lbs | $20.10 | $14.38 | $5.72 |
| 232704 | 2024-01-27 | $12.67 | USPS Ground Parcel or Priority Mail | 1 | 0.12 lbs | $8.18 | $4.19 | $3.99 |
| 232705 | 2024-01-29 | $29.92 | Priority Mail Flat Rate Envelope | 1 | 1.15 lbs | $9.60 | $8.74 | $0.86 |
| 232706 | 2024-01-29 | $40.84 | Priority Mail | 12 | 2.96 lbs | $13.42 | $12.01 | $1.41 |
| 232708 | 2024-01-30 | $29.68 | USPS First Class | 2 | 0.12 lbs | $10.70 | $4.02 | $6.68 |
| 232709 | 2024-01-31 | $10.24 | USPS First Class | 1 | 0.05 lbs | $5.45 | $4.19 | $1.26 |
| 232710 | 2024-01-31 | $15.81 | USPS Ground Parcel or Priority Mail | 1 | 0.10 lbs | $8.18 | $4.36 | $3.82 |
| 232711 | 2024-02-01 | $17.34 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232712 | 2024-02-01 | $15.64 | USPS First Class | 1 | 0.15 lbs | $5.35 | $4.02 | $1.33 |
| 232716 | 2024-02-02 | $15.64 | USPS First Class | 1 | 0.10 lbs | $5.35 | $4.02 | $1.33 |
| 232717 | 2024-02-04 | $15.84 | USPS First Class | 1 | 0.10 lbs | $5.55 | $4.36 | $1.19 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |