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 |
|---|---|---|---|---|---|---|---|---|
| 233445 | 2024-11-02 | $9.76 | USPS Ground Advantage | 1 | 0.06 lbs | $4.91 | $4.16 | $0.75 |
| 233446 | 2024-11-02 | $5.90 | USPS Ground Advantage | 1 | 0.01 lbs | $5.01 | $4.26 | $0.75 |
| 233447 | 2024-11-04 | $65.89 | USPS Ground Advantage | 2 | 0.88 lbs | $7.41 | $9.52 | $-2.11 |
| 233450 | 2024-11-05 | $19.64 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.85 | $4.37 | $4.48 |
| 233451 | 2024-11-07 | $18.61 | USPS Ground Advantage | 1 | 0.19 lbs | $5.12 | $4.43 | $0.69 |
| 233452 | 2024-11-10 | $29.87 | USPS Ground Advantage | 1 | 0.90 lbs | $6.84 | $6.09 | $0.75 |
| 233453 | 2024-11-09 | $13.91 | USPS Ground Advantage | 1 | 0.06 lbs | $5.01 | $4.26 | $0.75 |
| 233454 | 2024-11-09 | $8.79 | USPS Ground Advantage | 1 | 0.05 lbs | $5.29 | $4.90 | $0.39 |
| 233455 | 2024-11-09 | $15.54 | USPS Ground Parcel or Priority Mail | 1 | 0.09 lbs | $7.15 | $4.54 | $2.61 |
| 233456 | 2024-11-11 | $34.42 | USPS Ground Advantage | 1 | 0.44 lbs | $5.18 | $5.09 | $0.09 |
| 233457 | 2024-11-12 | $14.10 | USPS Ground Advantage | 1 | 0.04 lbs | $5.29 | $4.54 | $0.75 |
| 233458 | 2024-11-13 | $47.62 | USPS Ground Parcel or Priority Mail | 1 | 0.17 lbs | $8.63 | $4.43 | $4.20 |
| 233459 | 2024-11-13 | $13.42 | USPS Ground Advantage | 1 | 0.06 lbs | $5.33 | $4.58 | $0.75 |
| 233460 | 2024-11-14 | $136.31 | USPS Ground Advantage | 1 | 1.40 lbs | $7.72 | $6.97 | $0.75 |
| 233462 | 2024-11-18 | $25.32 | USPS Ground Advantage | 1 | 0.15 lbs | $5.33 | $4.58 | $0.75 |
| 233463 | 2024-11-17 | $11.10 | USPS Ground Advantage | 1 | 0.06 lbs | $5.21 | $4.46 | $0.75 |
| 233464 | 2024-11-17 | $11.18 | USPS Ground Advantage | 1 | 0.06 lbs | $5.29 | $4.54 | $0.75 |
| 233465 | 2024-11-17 | $458.83 | USPS Ground Advantage | 1 | 32.42 lbs | $59.83 | $84.19 | $-24.36 |
| 233466 | 2024-11-16 | $14.70 | USPS Ground Advantage | 1 | 0.06 lbs | $4.91 | $4.16 | $0.75 |
| 233467 | 2024-11-19 | $28.52 | USPS Ground Advantage | 6 | 0.30 lbs | $5.06 | $4.31 | $0.75 |
| 233468 | 2024-11-18 | $28.89 | USPS Ground Advantage | 6 | 0.30 lbs | $5.43 | $4.68 | $0.75 |
| 233469 | 2024-11-18 | $20.00 | USPS Ground Advantage | 1 | 0.19 lbs | $5.01 | $4.26 | $0.75 |
| 233470 | 2024-11-19 | $16.65 | USPS Ground Advantage | 2 | 0.36 lbs | $4.43 | $5.09 | $-0.66 |
| 233471 | 2024-11-20 | $11.35 | USPS Ground Advantage | 1 | 0.06 lbs | $5.46 | $4.71 | $0.75 |
| 233473 | 2024-11-22 | $22.39 | USPS Ground Advantage | 1 | 0.05 lbs | $5.21 | $4.46 | $0.75 |
| 233474 | 2024-11-22 | $44.64 | Priority Mail | 5 | 0.25 lbs | $12.94 | $9.21 | $3.73 |
| 233476 | 2024-11-22 | $88.08 | USPS Ground Advantage | 3 | 1.20 lbs | $11.61 | $6.44 | $5.17 |
| 233477 | 2024-11-22 | $158.65 | USPS Ground Advantage | 1 | 3.38 lbs | $8.66 | $8.92 | $-0.26 |
| 233478 | 2024-11-24 | $11.37 | USPS Ground Advantage | 1 | 0.18 lbs | $4.58 | $4.62 | $-0.04 |
| 233479 | 2024-11-23 | $36.41 | USPS Ground Advantage | 1 | 0.75 lbs | $6.42 | $7.14 | $-0.72 |
| 233480 | 2024-11-23 | $14.51 | USPS Ground Advantage | 1 | 0.06 lbs | $5.12 | $4.37 | $0.75 |
| 233481 | 2024-11-25 | $20.28 | USPS Ground Advantage | 1 | 0.19 lbs | $5.29 | $4.54 | $0.75 |
| 233483 | 2024-11-29 | $19.65 | USPS Ground Advantage | 1 | 0.03 lbs | $5.21 | $4.46 | $0.75 |
| 233484 | 2024-11-29 | $68.13 | USPS Priority Mail | 1 | 0.50 lbs | $12.04 | $9.80 | $2.24 |
| 233485 | 2024-11-28 | $19.79 | USPS Ground Advantage | 3 | 0.54 lbs | $5.09 | $6.09 | $-1.00 |
| 233487 | 2024-11-30 | $18.86 | USPS Ground Advantage | 2 | 0.12 lbs | $5.12 | $4.37 | $0.75 |
| 233488 | 2024-11-29 | $10.31 | USPS Ground Advantage | 1 | 0.18 lbs | $4.54 | $4.54 | $0.00 |
| 233489 | 2024-11-30 | $41.14 | USPS Ground Advantage | 1 | 0.90 lbs | $7.15 | $7.91 | $-0.76 |
| 233490 | 2024-12-02 | $13.44 | USPS Ground Advantage | 1 | 0.06 lbs | $5.12 | $4.37 | $0.75 |
| 233491 | 2024-12-02 | $300.20 | USPS Ground Advantage | 1 | 21.06 lbs | $26.51 | $25.76 | $0.75 |
| 233492 | 2024-12-03 | $25.09 | USPS Ground Advantage | 1 | 0.22 lbs | $5.21 | $4.46 | $0.75 |
| 233493 | 2024-12-04 | $25.87 | USPS Ground Advantage | 1 | 7.00 lbs | $13.21 | $11.24 | $1.97 |
| 233494 | 2024-12-04 | $12.51 | USPS Ground Parcel or Priority Mail | 1 | 0.40 lbs | $8.63 | $4.94 | $3.69 |
| 233495 | 2024-12-04 | $22.58 | USPS Ground Advantage | 1 | 0.31 lbs | $5.37 | $4.62 | $0.75 |
| 233496 | 2024-12-04 | $16.83 | USPS Ground Advantage | 1 | 0.19 lbs | $5.36 | $5.03 | $0.33 |
| 233497 | 2024-12-05 | $62.45 | USPS Ground Advantage | 1 | 1.81 lbs | $7.72 | $6.97 | $0.75 |
| 233500 | 2024-12-06 | $63.10 | USPS Ground Advantage | 1 | 8.17 lbs | $15.29 | $15.12 | $0.17 |
| 233501 | 2024-12-06 | $16.83 | USPS Ground Advantage | 1 | 0.19 lbs | $5.36 | $4.71 | $0.65 |
| 233502 | 2024-12-07 | $123.01 | USPS Ground Advantage | 1 | 4.85 lbs | $8.27 | $9.70 | $-1.43 |
| 233503 | 2024-12-06 | $10.98 | USPS Ground Advantage | 1 | 0.03 lbs | $5.46 | $4.71 | $0.75 |
| 233504 | 2024-12-07 | $9.71 | USPS Ground Advantage | 1 | 0.03 lbs | $5.21 | $4.46 | $0.75 |
| 233505 | 2024-12-07 | $87.57 | USPS Ground Advantage | 3 | 1.52 lbs | $13.89 | $8.63 | $5.26 |
| 233506 | 2024-12-07 | $30.94 | USPS Ground Advantage | 1 | 0.85 lbs | $7.15 | $6.40 | $0.75 |
| 233507 | 2024-12-07 | $62.82 | USPS Ground Advantage | 1 | 3.75 lbs | $6.73 | $5.98 | $0.75 |
| 233509 | 2024-12-09 | $18.68 | USPS Ground Advantage | 1 | 0.19 lbs | $5.19 | $4.55 | $0.64 |
| 233510 | 2024-12-08 | $11.05 | USPS Ground Advantage | 1 | 0.18 lbs | $4.26 | $4.26 | $0.00 |
| 233511 | 2024-12-07 | $29.09 | USPS Ground Advantage | 4 | 0.75 lbs | $6.01 | $6.23 | $-0.22 |
| 233512 | 2024-12-09 | $13.62 | USPS Ground Parcel or Priority Mail | 1 | 0.10 lbs | $13.62 | $4.37 | $9.25 |
| 233513 | 2024-12-10 | $16.02 | USPS Ground Advantage | 1 | 0.19 lbs | $5.23 | $4.62 | $0.61 |
| 233514 | 2024-12-10 | $43.10 | USPS Ground Advantage | 1 | 1.30 lbs | $9.11 | $8.36 | $0.75 |
| 233517 | 2024-12-10 | $14.92 | USPS Ground Advantage | 1 | 0.05 lbs | $5.33 | $4.58 | $0.75 |
| 233518 | 2024-12-10 | $13.00 | USPS Ground Advantage | 1 | 0.06 lbs | $5.01 | $4.26 | $0.75 |
| 233520 | 2024-12-11 | $69.81 | USPS Ground Advantage | 2 | 7.10 lbs | $13.81 | $8.30 | $5.51 |
| 233521 | 2024-12-10 | $9.80 | USPS Ground Advantage | 1 | 0.05 lbs | $5.01 | $4.26 | $0.75 |
| 233522 | 2024-12-11 | $15.85 | USPS Ground Advantage | 1 | 0.70 lbs | $5.78 | $7.50 | $-1.72 |
| 233523 | 2024-12-12 | $9.80 | USPS Ground Advantage | 1 | 0.10 lbs | $5.01 | $4.26 | $0.75 |
| 233524 | 2024-12-11 | $31.30 | USPS Ground Advantage | 1 | 4.75 lbs | $13.71 | $12.96 | $0.75 |
| 233525 | 2024-12-12 | $43.19 | USPS Ground Advantage | 1 | 1.17 lbs | $8.00 | $7.25 | $0.75 |
| 233526 | 2024-12-12 | $21.28 | USPS Ground Advantage | 1 | 0.15 lbs | $5.29 | $4.54 | $0.75 |
| 233527 | 2024-12-12 | $44.43 | USPS Ground Advantage | 1 | 1.20 lbs | $8.44 | $7.69 | $0.75 |
| 233528 | 2024-12-13 | $13.45 | USPS Ground Advantage | 1 | 0.06 lbs | $5.46 | $4.71 | $0.75 |
| 233529 | 2024-12-12 | $20.55 | USPS Ground Advantage | 1 | 0.40 lbs | $5.37 | $5.56 | $-0.19 |
| 233530 | 2024-12-12 | $23.98 | USPS Ground Advantage | 1 | 4.75 lbs | $8.15 | $7.21 | $0.94 |
| 233531 | 2024-12-12 | $18.92 | USPS Ground Advantage | 1 | 0.20 lbs | $5.33 | $4.62 | $0.71 |
| 233532 | 2024-12-13 | $9.28 | USPS Ground Advantage | 2 | 0.04 lbs | $5.12 | $4.37 | $0.75 |
| 233533 | 2024-12-13 | $136.79 | USPS Ground Advantage | 1 | 6.50 lbs | $16.80 | $16.05 | $0.75 |
| 233534 | 2024-12-14 | $17.31 | USPS Ground Advantage | 1 | 0.40 lbs | $5.37 | $5.56 | $-0.19 |
| 233535 | 2024-12-13 | $12.08 | USPS Ground Advantage | 1 | 0.05 lbs | $5.29 | $4.54 | $0.75 |
| 233536 | 2024-12-13 | $15.60 | USPS Ground Advantage | 1 | 0.60 lbs | $6.01 | $5.26 | $0.75 |
| 233537 | 2024-12-13 | $28.21 | USPS Ground Advantage | 1 | 0.85 lbs | $8.06 | $7.31 | $0.75 |
| 233538 | 2024-12-13 | $18.09 | USPS Ground Advantage | 1 | 0.37 lbs | $5.22 | $4.47 | $0.75 |
| 233539 | 2024-12-13 | $43.19 | USPS Ground Advantage | 1 | 1.17 lbs | $8.00 | $7.25 | $0.75 |
| 233540 | 2024-12-14 | $21.48 | USPS Ground Advantage | 1 | 0.35 lbs | $5.65 | $5.80 | $-0.15 |
| 233541 | 2024-12-14 | $85.83 | USPS Ground Advantage | 1 | 1.35 lbs | $8.44 | $7.69 | $0.75 |
| 233542 | 2024-12-14 | $20.98 | USPS Ground Advantage | 1 | 1.25 lbs | $7.31 | $6.56 | $0.75 |
| 233544 | 2024-12-14 | $21.28 | USPS Ground Advantage | 1 | 0.15 lbs | $5.29 | $4.54 | $0.75 |
| 233545 | 2024-12-14 | $16.53 | USPS Ground Advantage | 1 | 0.62 lbs | $6.14 | $6.40 | $-0.26 |
| 233546 | 2024-12-14 | $12.37 | USPS Ground Advantage | 1 | 0.29 lbs | $5.18 | $4.43 | $0.75 |
| 233547 | 2024-12-16 | $124.07 | USPS Ground Advantage | 1 | 6.50 lbs | $16.08 | $15.33 | $0.75 |
| 233548 | 2024-12-16 | $278.62 | FedEx Ground or FedEx Home Delivery | 1 | 21.06 lbs | $22.63 | $21.88 | $0.75 |
| 233549 | 2024-12-15 | $10.01 | USPS Ground Advantage | 1 | 0.18 lbs | $4.58 | $4.62 | $-0.04 |
| 233550 | 2024-12-15 | $27.89 | USPS Ground Advantage | 1 | 0.40 lbs | $5.65 | $5.80 | $-0.15 |
| 233551 | 2024-12-16 | $9.52 | USPS Ground Advantage | 1 | 0.05 lbs | $5.53 | $4.58 | $0.95 |
| 233552 | 2024-12-16 | $18.59 | USPS Ground Advantage | 2 | 0.06 lbs | $10.98 | $4.54 | $6.44 |
| 233553 | 2024-12-17 | $15.98 | USPS Ground Advantage | 1 | 0.19 lbs | $5.19 | $4.54 | $0.65 |
| 233554 | 2024-12-17 | $21.52 | USPS Ground Advantage | 1 | 0.15 lbs | $5.53 | $4.58 | $0.95 |
| 233555 | 2024-12-16 | $8.68 | USPS Ground Advantage | 1 | 0.02 lbs | $5.49 | $4.54 | $0.95 |
| 233556 | 2024-12-16 | $11.50 | USPS Ground Advantage | 1 | 0.10 lbs | $5.53 | $4.58 | $0.95 |
| 233557 | 2024-12-17 | $12.84 | USPS Ground Advantage | 1 | 0.05 lbs | $5.41 | $4.46 | $0.95 |
| 233558 | 2024-12-17 | $29.08 | USPS Ground Advantage | 1 | 0.06 lbs | $5.49 | $4.54 | $0.95 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |