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 |
|---|---|---|---|---|---|---|---|---|
| 232362 | 2023-10-21 | $60.32 | Priority Mail | 2 | 1.70 lbs | $9.84 | $8.30 | $1.54 |
| 232368 | 2023-10-23 | $13.04 | USPS First Class | 1 | 0.04 lbs | $5.05 | $3.81 | $1.24 |
| 232369 | 2023-10-25 | $13.09 | USPS First Class | 1 | 0.04 lbs | $5.10 | $3.90 | $1.20 |
| 232370 | 2023-10-25 | $11.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 232371 | 2023-10-25 | $16.85 | USPS Ground Parcel or Priority Mail | 1 | 0.03 lbs | $8.18 | $3.81 | $4.37 |
| 232372 | 2023-10-24 | $12.87 | USPS Ground Parcel or Priority Mail | 1 | 0.15 lbs | $8.18 | $4.20 | $3.98 |
| 232373 | 2023-10-25 | $29.74 | USPS First Class | 1 | 0.80 lbs | $8.55 | $6.78 | $1.77 |
| 232376 | 2023-10-26 | $14.39 | Priority Mail Flat Rate Envelope | 1 | 0.10 lbs | $9.15 | $7.60 | $1.55 |
| 232377 | 2023-10-26 | $36.22 | Priority Mail | 5 | 0.50 lbs | $9.57 | $7.96 | $1.61 |
| 232378 | 2023-10-26 | $11.87 | USPS Ground Parcel or Priority Mail | 1 | 0.04 lbs | $8.18 | $3.75 | $4.43 |
| 232379 | 2023-10-27 | $20.39 | USPS First Class | 1 | 0.05 lbs | $5.00 | $3.75 | $1.25 |
| 232380 | 2023-10-27 | $9.69 | USPS First Class | 1 | 0.41 lbs | $5.70 | $5.04 | $0.66 |
| 232382 | 2023-10-28 | $19.32 | Priority Mail Flat Rate Envelope | 1 | 0.10 lbs | $9.15 | $8.10 | $1.05 |
| 232384 | 2023-10-28 | $15.39 | USPS First Class | 1 | 0.20 lbs | $5.10 | $4.24 | $0.86 |
| 232385 | 2023-10-28 | $21.09 | USPS First Class | 1 | 0.20 lbs | $5.10 | $4.24 | $0.86 |
| 232386 | 2023-10-30 | $13.14 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $3.97 | $4.21 |
| 232387 | 2023-10-28 | $12.87 | USPS Ground Parcel or Priority Mail | 1 | 0.15 lbs | $8.18 | $3.66 | $4.52 |
| 232388 | 2023-10-30 | $21.23 | Priority Mail Flat Rate Envelope | 4 | 0.04 lbs | $9.15 | $8.10 | $1.05 |
| 232392 | 2023-10-30 | $43.02 | Priority Mail | 2 | 1.30 lbs | $9.84 | $8.10 | $1.74 |
| 232393 | 2023-10-30 | $9.74 | USPS Ground Advantage | 1 | 0.15 lbs | $5.05 | $3.81 | $1.24 |
| 232395 | 2023-10-30 | $14.87 | USPS Ground Parcel or Priority Mail | 1 | 0.10 lbs | $8.18 | $3.97 | $4.21 |
| 232397 | 2023-10-31 | $10.94 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 232401 | 2023-10-31 | $10.54 | USPS Ground Advantage | 1 | 0.28 lbs | $5.55 | $4.74 | $0.81 |
| 232403 | 2023-11-01 | $15.14 | USPS First Class | 1 | 0.07 lbs | $5.15 | $3.97 | $1.18 |
| 232404 | 2023-11-01 | $9.84 | USPS First Class | 1 | 0.10 lbs | $5.05 | $3.81 | $1.24 |
| 232405 | 2023-11-02 | $24.29 | USPS First Class | 1 | 0.15 lbs | $5.10 | $3.90 | $1.20 |
| 232406 | 2023-11-02 | $12.99 | USPS First Class | 1 | 0.04 lbs | $5.00 | $3.75 | $1.25 |
| 232407 | 2023-11-03 | $26.35 | Priority Mail | 6 | 1.14 lbs | $14.27 | $13.17 | $1.10 |
| 232408 | 2023-11-03 | $25.04 | USPS First Class | 1 | 0.15 lbs | $5.05 | $3.81 | $1.24 |
| 232409 | 2023-11-02 | $15.34 | USPS First Class | 1 | 0.20 lbs | $5.05 | $4.20 | $0.85 |
| 232412 | 2023-11-04 | $12.99 | USPS First Class | 1 | 0.06 lbs | $5.10 | $3.90 | $1.20 |
| 232414 | 2023-11-05 | $38.64 | Priority Mail Padded Flat Rate Envelope | 1 | 7.50 lbs | $9.90 | $8.10 | $1.80 |
| 232415 | 2023-11-05 | $27.15 | Priority Mail | 6 | 2.40 lbs | $10.35 | $7.13 | $3.22 |
| 232418 | 2023-11-05 | $61.10 | Priority Mail | 2 | 0.80 lbs | $9.55 | $6.98 | $2.57 |
| 232421 | 2023-11-05 | $13.59 | USPS First Class | 1 | 0.30 lbs | $5.60 | $4.15 | $1.45 |
| 232422 | 2023-11-08 | $11.77 | USPS Ground Parcel or Priority Mail | 1 | 0.19 lbs | $8.18 | $4.13 | $4.05 |
| 232423 | 2023-11-08 | $9.69 | USPS Ground Advantage | 1 | 0.15 lbs | $5.00 | $4.15 | $0.85 |
| 232424 | 2023-11-08 | $26.53 | USPS Ground Parcel or Priority Mail | 1 | 0.12 lbs | $8.18 | $5.17 | $3.01 |
| 232426 | 2023-11-08 | $25.29 | Priority Mail Flat Rate Envelope | 8 | 6.12 lbs | $9.15 | $7.60 | $1.55 |
| 232429 | 2023-11-08 | $13.84 | USPS First Class | 1 | 0.30 lbs | $5.85 | $4.44 | $1.41 |
| 232430 | 2023-11-08 | $11.24 | USPS First Class | 1 | 0.10 lbs | $5.05 | $3.81 | $1.24 |
| 232431 | 2023-11-08 | $8.33 | USPS First Class | 1 | 0.02 lbs | $5.00 | $3.75 | $1.25 |
| 232432 | 2023-11-08 | $8.29 | USPS First Class | 1 | 0.06 lbs | $5.00 | $3.75 | $1.25 |
| 232433 | 2023-11-09 | $22.09 | USPS First Class | 1 | 0.58 lbs | $6.40 | $6.22 | $0.18 |
| 232434 | 2023-11-10 | $24.22 | USPS Ground Parcel or Priority Mail | 1 | 0.08 lbs | $8.18 | $3.90 | $4.28 |
| 232436 | 2023-11-10 | $61.64 | USPS First Class | 1 | 0.55 lbs | $6.65 | $5.33 | $1.32 |
| 232437 | 2023-11-10 | $13.14 | USPS First Class | 1 | 0.07 lbs | $5.25 | $4.13 | $1.12 |
| 232438 | 2023-11-11 | $19.14 | Priority Mail Flat Rate Envelope | 3 | 0.06 lbs | $9.15 | $8.10 | $1.05 |
| 232439 | 2023-11-11 | $23.20 | Priority Mail Flat Rate Envelope | 5 | 0.69 lbs | $9.15 | $8.10 | $1.05 |
| 232440 | 2023-11-11 | $102.32 | Priority Mail | 5 | 4.03 lbs | $26.07 | $10.07 | $16.00 |
| 232442 | 2023-11-12 | $17.31 | Priority Mail Flat Rate Envelope | 1 | 0.05 lbs | $9.15 | $8.10 | $1.05 |
| 232444 | 2023-11-12 | $26.25 | Priority Mail Flat Rate Envelope | 10 | 0.45 lbs | $9.15 | $8.10 | $1.05 |
| 232447 | 2023-11-12 | $21.34 | USPS First Class | 1 | 0.19 lbs | $5.15 | $4.31 | $0.84 |
| 232448 | 2023-11-12 | $9.04 | USPS First Class | 1 | 0.15 lbs | $5.05 | $4.20 | $0.85 |
| 232449 | 2023-11-11 | $13.14 | USPS First Class | 1 | 0.04 lbs | $5.15 | $3.97 | $1.18 |
| 232450 | 2023-11-12 | $34.67 | USPS Ground Parcel or Priority Mail | 1 | 0.57 lbs | $8.18 | $5.17 | $3.01 |
| 232453 | 2023-11-13 | $17.95 | Priority Mail Flat Rate Envelope | 1 | 3.55 lbs | $9.15 | $8.30 | $0.85 |
| 232456 | 2023-11-14 | $12.34 | USPS First Class | 1 | 0.10 lbs | $4.85 | $4.06 | $0.79 |
| 232457 | 2023-11-13 | $9.69 | USPS First Class | 1 | 0.05 lbs | $4.90 | $3.66 | $1.24 |
| 232458 | 2023-11-15 | $9.69 | USPS First Class | 1 | 0.41 lbs | $5.70 | $5.04 | $0.66 |
| 232459 | 2023-11-15 | $25.15 | Priority Mail Flat Rate Envelope | 2 | 0.18 lbs | $9.15 | $8.10 | $1.05 |
| 232460 | 2023-11-15 | $9.69 | USPS First Class | 1 | 0.41 lbs | $5.70 | $5.04 | $0.66 |
| 232468 | 2023-11-17 | $31.04 | USPS Ground Advantage | 1 | 0.69 lbs | $6.55 | $6.60 | $-0.05 |
| 232470 | 2023-11-17 | $18.92 | Priority Mail | 2 | 0.02 lbs | $9.34 | $6.95 | $2.39 |
| 232472 | 2023-11-18 | $58.83 | Priority Mail | 1 | 0.56 lbs | $9.57 | $8.05 | $1.52 |
| 232473 | 2023-11-19 | $68.05 | Priority Mail | 3 | 1.50 lbs | $9.84 | $8.80 | $1.04 |
| 232474 | 2023-11-19 | $13.14 | USPS First Class | 1 | 0.04 lbs | $5.15 | $3.97 | $1.18 |
| 232475 | 2023-11-19 | $18.97 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $3.81 | $4.37 |
| 232476 | 2023-11-20 | $17.04 | USPS First Class | 1 | 0.20 lbs | $5.05 | $4.20 | $0.85 |
| 232477 | 2023-11-20 | $38.65 | Priority Mail | 5 | 1.36 lbs | $9.84 | $6.95 | $2.89 |
| 232480 | 2023-11-21 | $13.09 | USPS First Class | 1 | 0.06 lbs | $5.10 | $3.90 | $1.20 |
| 232483 | 2023-11-24 | $28.10 | Priority Mail | 2 | 0.41 lbs | $10.12 | $7.96 | $2.16 |
| 232484 | 2023-11-23 | $16.19 | USPS First Class | 1 | 0.20 lbs | $4.90 | $4.09 | $0.81 |
| 232485 | 2023-11-23 | $9.89 | USPS First Class | 1 | 0.10 lbs | $5.10 | $3.90 | $1.20 |
| 232486 | 2023-11-24 | $80.06 | USPS Ground Parcel or Priority Mail | 1 | 1.45 lbs | $16.40 | $6.95 | $9.45 |
| 232487 | 2023-11-24 | $36.34 | USPS Ground Parcel or Priority Mail | 1 | 0.18 lbs | $8.18 | $4.15 | $4.03 |
| 232492 | 2023-11-25 | $273.02 | Priority Mail | 5 | 6.97 lbs | $18.04 | $12.56 | $5.48 |
| 232494 | 2023-11-26 | $21.14 | Priority Mail Flat Rate Envelope | 1 | 0.30 lbs | $9.15 | $8.55 | $0.60 |
| 232495 | 2023-11-26 | $34.87 | Priority Mail Medium Flat Rate Box | 1 | 7.00 lbs | $16.40 | $14.75 | $1.65 |
| 232496 | 2023-11-26 | $34.34 | Priority Mail Flat Rate Envelope | 2 | 1.08 lbs | $9.15 | $8.55 | $0.60 |
| 232500 | 2023-11-26 | $9.09 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 232501 | 2023-11-26 | $26.09 | USPS First Class | 1 | 0.22 lbs | $5.10 | $4.24 | $0.86 |
| 232502 | 2023-11-25 | $8.64 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 232503 | 2023-11-27 | $16.25 | USPS Ground Parcel or Priority Mail | 1 | 0.08 lbs | $8.18 | $3.90 | $4.28 |
| 232504 | 2023-11-25 | $19.17 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $4.13 | $4.05 |
| 232507 | 2023-11-27 | $102.90 | Priority Mail Padded Flat Rate Envelope | 2 | 4.60 lbs | $9.90 | $8.80 | $1.10 |
| 232508 | 2023-11-27 | $14.87 | USPS Ground Parcel or Priority Mail | 1 | 0.08 lbs | $8.18 | $3.97 | $4.21 |
| 232509 | 2023-11-27 | $18.97 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $3.97 | $4.21 |
| 232510 | 2023-11-28 | $16.74 | Priority Mail Flat Rate Envelope | 1 | 0.09 lbs | $9.15 | $8.55 | $0.60 |
| 232512 | 2023-11-28 | $17.24 | Priority Mail Flat Rate Envelope | 4 | 0.18 lbs | $9.15 | $8.55 | $0.60 |
| 232514 | 2023-11-29 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 232517 | 2023-11-30 | $9.24 | USPS First Class | 1 | 0.08 lbs | $5.25 | $4.13 | $1.12 |
| 232518 | 2023-11-30 | $19.17 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $4.13 | $4.05 |
| 232520 | 2023-12-02 | $12.94 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 232521 | 2023-12-01 | $13.64 | USPS Ground Advantage | 1 | 0.30 lbs | $5.85 | $5.33 | $0.52 |
| 232522 | 2023-12-02 | $11.11 | USPS Ground Parcel or Priority Mail | 1 | 0.19 lbs | $8.18 | $3.90 | $4.28 |
| 232530 | 2023-12-03 | $9.14 | USPS First Class | 1 | 0.08 lbs | $5.15 | $3.97 | $1.18 |
| 232531 | 2023-12-02 | $65.69 | USPS First Class | 1 | 0.50 lbs | $5.70 | $5.04 | $0.66 |
| 232532 | 2023-12-02 | $10.04 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 232533 | 2023-12-02 | $15.29 | USPS First Class | 1 | 0.20 lbs | $5.00 | $4.15 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |