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 |
|---|---|---|---|---|---|---|---|---|
| 232161 | 2023-09-04 | $48.99 | Priority Mail | 15 | 6.15 lbs | $12.51 | $9.83 | $2.68 |
| 232162 | 2023-09-04 | $43.49 | Priority Mail Small Flat Rate Box | 1 | 1.15 lbs | $9.65 | $8.10 | $1.55 |
| 232163 | 2023-09-05 | $236.39 | Priority Mail Medium Flat Rate Box | 1 | 12.88 lbs | $16.40 | $17.72 | $-1.32 |
| 232164 | 2023-09-04 | $13.64 | USPS First Class | 1 | 0.30 lbs | $5.65 | $4.20 | $1.45 |
| 232168 | 2023-09-06 | $28.74 | Priority Mail Flat Rate Envelope | 8 | 0.24 lbs | $9.15 | $8.10 | $1.05 |
| 232169 | 2023-09-06 | $24.59 | Priority Mail | 2 | 0.42 lbs | $9.57 | $8.10 | $1.47 |
| 232171 | 2023-09-05 | $15.49 | USPS Ground Advantage | 1 | 0.50 lbs | $5.50 | $5.93 | $-0.43 |
| 232172 | 2023-09-06 | $12.20 | Priority Mail Flat Rate Envelope | 1 | 0.01 lbs | $9.15 | $7.60 | $1.55 |
| 232176 | 2023-09-08 | $18.13 | Priority Mail Padded Flat Rate Envelope | 2 | 0.70 lbs | $9.90 | $8.30 | $1.60 |
| 232177 | 2023-09-09 | $32.83 | Priority Mail Flat Rate Envelope | 18 | 0.36 lbs | $9.15 | $8.10 | $1.05 |
| 232178 | 2023-09-08 | $13.14 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 232179 | 2023-09-08 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 232181 | 2023-09-09 | $39.77 | Priority Mail Small Flat Rate Box | 1 | 1.20 lbs | $9.65 | $8.10 | $1.55 |
| 232183 | 2023-09-10 | $15.25 | Priority Mail Flat Rate Envelope | 1 | 0.06 lbs | $9.15 | $7.60 | $1.55 |
| 232184 | 2023-09-10 | $31.27 | Priority Mail Flat Rate Envelope | 5 | 0.23 lbs | $9.15 | $8.10 | $1.05 |
| 232185 | 2023-09-10 | $19.35 | Priority Mail Small Flat Rate Box | 2 | 0.12 lbs | $9.65 | $7.60 | $2.05 |
| 232186 | 2023-09-10 | $14.84 | Priority Mail Flat Rate Envelope | 2 | 0.08 lbs | $9.15 | $7.60 | $1.55 |
| 232189 | 2023-09-10 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 232190 | 2023-09-11 | $29.13 | Priority Mail | 2 | 1.30 lbs | $13.07 | $8.10 | $4.97 |
| 232192 | 2023-09-12 | $8.74 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 232193 | 2023-09-13 | $33.69 | Priority Mail Flat Rate Envelope | 1 | 3.55 lbs | $9.15 | $8.30 | $0.85 |
| 232194 | 2023-09-13 | $14.18 | Priority Mail Flat Rate Envelope | 3 | 0.09 lbs | $9.15 | $7.60 | $1.55 |
| 232195 | 2023-09-13 | $29.35 | Priority Mail Small Flat Rate Box | 2 | 0.60 lbs | $9.65 | $8.10 | $1.55 |
| 232197 | 2023-09-14 | $18.63 | Priority Mail Flat Rate Envelope | 3 | 0.18 lbs | $9.15 | $7.60 | $1.55 |
| 232201 | 2023-09-15 | $43.71 | Priority Mail Small Flat Rate Box | 18 | 1.74 lbs | $9.65 | $8.10 | $1.55 |
| 232204 | 2023-09-15 | $17.40 | Priority Mail Flat Rate Envelope | 1 | 0.04 lbs | $9.15 | $7.60 | $1.55 |
| 232206 | 2023-09-15 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 232207 | 2023-09-15 | $7.09 | USPS First Class | 1 | 0.06 lbs | $5.10 | $3.90 | $1.20 |
| 232208 | 2023-09-16 | $51.37 | Priority Mail Small Flat Rate Box | 1 | 1.25 lbs | $9.65 | $8.10 | $1.55 |
| 232209 | 2023-09-16 | $17.40 | Priority Mail Flat Rate Envelope | 1 | 0.06 lbs | $9.15 | $7.60 | $1.55 |
| 232211 | 2023-09-17 | $14.15 | Priority Mail Flat Rate Envelope | 1 | 0.05 lbs | $9.15 | $7.60 | $1.55 |
| 232214 | 2023-09-17 | $17.42 | Priority Mail Flat Rate Envelope | 2 | 0.06 lbs | $9.15 | $8.10 | $1.05 |
| 232216 | 2023-09-17 | $12.79 | USPS First Class | 1 | 0.06 lbs | $4.90 | $3.66 | $1.24 |
| 232217 | 2023-09-18 | $12.64 | USPS Ground Parcel or Priority Mail | 1 | 0.03 lbs | $8.18 | $3.97 | $4.21 |
| 232220 | 2023-09-18 | $62.20 | Priority Mail International Padded Flat Rate Envelope | 2 | 0.42 lbs | $42.53 | $42.99 | $-0.46 |
| 232222 | 2023-09-19 | $12.62 | Priority Mail Flat Rate Envelope | 1 | 0.04 lbs | $9.15 | $7.60 | $1.55 |
| 232223 | 2023-09-19 | $17.74 | USPS First Class | 1 | 0.30 lbs | $5.75 | $4.31 | $1.44 |
| 232224 | 2023-09-19 | $12.94 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 232225 | 2023-09-19 | $25.54 | USPS First Class | 1 | 0.71 lbs | $6.55 | $6.60 | $-0.05 |
| 232226 | 2023-09-19 | $20.49 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 232227 | 2023-09-19 | $54.59 | USPS Priority Mail | 1 | 7.60 lbs | $41.60 | $14.00 | $27.60 |
| 232228 | 2023-09-20 | $13.56 | Priority Mail Flat Rate Envelope | 1 | 0.06 lbs | $9.15 | $7.60 | $1.55 |
| 232229 | 2023-09-21 | $13.99 | USPS First Class | 1 | 0.40 lbs | $5.60 | $4.15 | $1.45 |
| 232232 | 2023-09-23 | $32.64 | First-Class Package International Service | 1 | 0.07 lbs | $26.01 | $17.96 | $8.05 |
| 232234 | 2023-09-23 | $94.00 | Priority Mail | 3 | 2.23 lbs | $11.88 | $8.82 | $3.06 |
| 232235 | 2023-09-24 | $61.20 | Priority Mail | 3 | 1.17 lbs | $12.94 | $8.79 | $4.15 |
| 232238 | 2023-09-25 | $13.49 | USPS First Class | 1 | 0.21 lbs | $5.00 | $3.75 | $1.25 |
| 232239 | 2023-09-26 | $17.39 | Priority Mail Flat Rate Envelope | 1 | 0.06 lbs | $9.15 | $7.60 | $1.55 |
| 232242 | 2023-09-27 | $29.79 | Priority Mail Flat Rate Envelope | 4 | 0.66 lbs | $9.15 | $8.30 | $0.85 |
| 232255 | 2023-09-29 | $33.14 | USPS First Class | 1 | 0.12 lbs | $5.15 | $3.97 | $1.18 |
| 232267 | 2023-09-29 | $26.40 | Priority Mail | 3 | 1.05 lbs | $12.39 | $9.94 | $2.45 |
| 232268 | 2023-09-30 | $27.56 | Priority Mail Small Flat Rate Box | 5 | 0.14 lbs | $9.65 | $7.60 | $2.05 |
| 232269 | 2023-09-30 | $142.38 | Priority Mail Medium Flat Rate Box | 2 | 3.70 lbs | $16.40 | $10.28 | $6.12 |
| 232270 | 2023-09-30 | $58.56 | First-Class Package International Service | 2 | 0.58 lbs | $44.90 | $35.25 | $9.65 |
| 232273 | 2023-10-01 | $14.74 | Priority Mail Flat Rate Envelope | 2 | 0.08 lbs | $9.15 | $7.60 | $1.55 |
| 232277 | 2023-09-30 | $15.39 | USPS First Class | 1 | 0.07 lbs | $5.10 | $3.90 | $1.20 |
| 232278 | 2023-09-29 | $15.69 | USPS Ground Advantage | 1 | 0.30 lbs | $5.70 | $4.24 | $1.46 |
| 232282 | 2023-10-02 | $21.15 | Priority Mail Flat Rate Envelope | 4 | 0.07 lbs | $9.15 | $8.10 | $1.05 |
| 232283 | 2023-10-02 | $15.09 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 232284 | 2023-10-02 | $30.94 | USPS Ground Advantage | 1 | 0.69 lbs | $6.45 | $6.44 | $0.01 |
| 232285 | 2023-10-02 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 232286 | 2023-10-03 | $53.57 | USPS Ground Parcel or Priority Mail | 1 | 2.20 lbs | $18.58 | $17.68 | $0.90 |
| 232290 | 2023-10-03 | $15.89 | USPS First Class | 1 | 0.05 lbs | $4.90 | $3.66 | $1.24 |
| 232291 | 2023-10-04 | $12.28 | USPS Ground Parcel or Priority Mail | 1 | 0.04 lbs | $8.18 | $3.81 | $4.37 |
| 232292 | 2023-10-04 | $39.20 | Priority Mail Padded Flat Rate Envelope | 1 | 2.94 lbs | $9.90 | $8.79 | $1.11 |
| 232293 | 2023-10-04 | $15.84 | USPS Ground Advantage | 1 | 0.50 lbs | $5.85 | $6.78 | $-0.93 |
| 232295 | 2023-10-05 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 232296 | 2023-10-05 | $12.79 | USPS First Class | 1 | 0.06 lbs | $4.90 | $3.66 | $1.24 |
| 232297 | 2023-10-05 | $38.85 | Priority Mail Flat Rate Envelope | 2 | 0.70 lbs | $9.15 | $8.30 | $0.85 |
| 232300 | 2023-10-05 | $15.24 | USPS First Class | 2 | 0.14 lbs | $10.50 | $4.13 | $6.37 |
| 232301 | 2023-10-05 | $15.44 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 232306 | 2023-10-06 | $13.59 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 232307 | 2023-10-06 | $12.99 | USPS First Class | 1 | 0.04 lbs | $5.00 | $3.75 | $1.25 |
| 232308 | 2023-10-09 | $22.52 | Priority Mail | 1 | 0.68 lbs | $10.53 | $8.30 | $2.23 |
| 232309 | 2023-10-09 | $17.09 | Priority Mail Flat Rate Envelope | 6 | 0.12 lbs | $9.15 | $8.30 | $0.85 |
| 232315 | 2023-10-09 | $8.58 | USPS First Class | 1 | 0.02 lbs | $5.25 | $4.13 | $1.12 |
| 232320 | 2023-10-10 | $21.97 | Priority Mail | 2 | 0.15 lbs | $9.11 | $6.83 | $2.28 |
| 232322 | 2023-10-11 | $26.39 | Priority Mail | 6 | 1.14 lbs | $14.27 | $13.17 | $1.10 |
| 232324 | 2023-10-11 | $15.84 | USPS Ground Advantage | 1 | 0.30 lbs | $5.85 | $4.44 | $1.41 |
| 232326 | 2023-10-11 | $18.83 | USPS Ground Parcel or Priority Mail | 1 | 0.30 lbs | $8.18 | $4.15 | $4.03 |
| 232328 | 2023-10-11 | $127.53 | Priority Mail | 48 | 11.50 lbs | $15.32 | $12.34 | $2.98 |
| 232329 | 2023-10-12 | $19.46 | Priority Mail Flat Rate Envelope | 1 | 0.25 lbs | $9.15 | $8.10 | $1.05 |
| 232330 | 2023-10-12 | $40.23 | Priority Mail Small Flat Rate Box | 1 | 1.30 lbs | $9.65 | $8.10 | $1.55 |
| 232332 | 2023-10-12 | $15.59 | Priority Mail Flat Rate Envelope | 1 | 0.03 lbs | $9.15 | $7.60 | $1.55 |
| 232334 | 2023-10-14 | $24.97 | USPS Ground Parcel or Priority Mail | 2 | 0.10 lbs | $16.36 | $7.60 | $8.76 |
| 232335 | 2023-10-15 | $6.29 | USPS First Class | 1 | 0.01 lbs | $5.00 | $3.75 | $1.25 |
| 232336 | 2023-10-15 | $52.37 | USPS First Class | 3 | 0.57 lbs | $15.90 | $10.08 | $5.82 |
| 232338 | 2023-10-16 | $17.39 | Priority Mail Flat Rate Envelope | 1 | 0.07 lbs | $9.15 | $7.60 | $1.55 |
| 232340 | 2023-10-17 | $24.14 | Priority Mail Flat Rate Envelope | 1 | 0.20 lbs | $9.15 | $8.10 | $1.05 |
| 232342 | 2023-10-18 | $11.79 | USPS First Class | 1 | 0.08 lbs | $5.10 | $3.90 | $1.20 |
| 232343 | 2023-10-18 | $8.56 | USPS First Class | 1 | 0.05 lbs | $4.90 | $3.66 | $1.24 |
| 232344 | 2023-10-17 | $15.99 | USPS First Class | 1 | 0.05 lbs | $5.00 | $3.75 | $1.25 |
| 232345 | 2023-10-17 | $13.84 | USPS First Class | 1 | 0.30 lbs | $5.85 | $4.44 | $1.41 |
| 232346 | 2023-10-17 | $47.06 | USPS Ground Parcel or Priority Mail | 1 | 1.65 lbs | $15.07 | $16.17 | $-1.10 |
| 232347 | 2023-10-18 | $12.89 | Priority Mail Small Flat Rate Box | 1 | 0.01 lbs | $9.65 | $7.60 | $2.05 |
| 232351 | 2023-10-18 | $15.29 | USPS First Class | 1 | 0.20 lbs | $5.00 | $4.15 | $0.85 |
| 232352 | 2023-10-19 | $12.46 | USPS Ground Parcel or Priority Mail | 1 | 0.02 lbs | $8.18 | $3.75 | $4.43 |
| 232353 | 2023-10-20 | $9.14 | USPS First Class | 1 | 0.02 lbs | $5.15 | $3.97 | $1.18 |
| 232354 | 2023-10-19 | $13.24 | USPS First Class | 1 | 0.04 lbs | $5.25 | $4.13 | $1.12 |
| 232355 | 2023-10-20 | $17.62 | Priority Mail Flat Rate Envelope | 1 | 0.06 lbs | $9.15 | $7.60 | $1.55 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |