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 |
|---|---|---|---|---|---|---|---|---|
| 235179 | 2026-05-12 | $13.52 | USPS Ground Advantage | 1 | 0.19 lbs | $6.40 | $5.40 | $1.00 |
| 235180 | 2026-05-15 | $36.82 | USPS Ground Advantage | 1 | 0.27 lbs | $7.36 | $6.36 | $1.00 |
| 235181 | 2026-05-15 | $12.80 | Pickup From Store | 1 | 0.05 lbs | $0.00 | $5.17 | $-5.17 |
| 235182 | 2026-05-17 | $17.74 | USPS Ground Advantage | 1 | 0.07 lbs | $6.48 | $5.48 | $1.00 |
| 235183 | 2026-05-17 | $11.22 | USPS Ground Advantage | 2 | 0.06 lbs | $6.40 | $5.40 | $1.00 |
| 235184 | 2026-05-17 | $17.16 | USPS Ground Advantage | 1 | 0.10 lbs | $6.17 | $5.17 | $1.00 |
| 235185 | 2026-05-17 | $22.65 | USPS Ground Advantage | 2 | 0.50 lbs | $6.83 | $6.98 | $-0.15 |
| 235186 | 2026-05-16 | $10.39 | USPS Ground Advantage | 1 | 0.03 lbs | $6.97 | $5.97 | $1.00 |
| 235187 | 2026-05-16 | $10.44 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235188 | 2026-05-18 | $24.88 | USPS Ground Advantage | 1 | 1.50 lbs | $8.17 | $7.22 | $0.95 |
| 235189 | 2026-05-18 | $25.79 | USPS Ground Advantage | 1 | 1.50 lbs | $9.08 | $8.13 | $0.95 |
| 235190 | 2026-05-19 | $46.98 | USPS Ground Advantage | 1 | 0.70 lbs | $7.74 | $9.63 | $-1.89 |
| 235191 | 2026-05-20 | $11.01 | USPS Ground Advantage | 1 | 0.05 lbs | $6.97 | $5.97 | $1.00 |
| 235192 | 2026-05-20 | $10.88 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235193 | 2026-05-22 | $29.35 | USPS Ground Advantage | 6 | 1.50 lbs | $14.59 | $11.58 | $3.01 |
| 235194 | 2026-05-21 | $23.21 | USPS Ground Advantage | 1 | 1.50 lbs | $8.17 | $7.22 | $0.95 |
| 235195 | 2026-05-24 | $10.76 | USPS Ground Advantage | 1 | 0.05 lbs | $6.72 | $5.72 | $1.00 |
| 235196 | 2026-05-23 | $10.12 | USPS Ground Advantage | 1 | 0.08 lbs | $6.17 | $5.17 | $1.00 |
| 235197 | 2026-05-23 | $16.40 | USPS Ground Advantage | 4 | 0.76 lbs | $8.04 | $6.25 | $1.79 |
| 235198 | 2026-05-23 | $27.82 | USPS Ground Advantage | 2 | 1.00 lbs | $8.04 | $7.26 | $0.78 |
| 235199 | 2026-05-23 | $36.82 | USPS Ground Advantage | 5 | 0.25 lbs | $6.97 | $6.58 | $0.39 |
| 235200 | 2026-05-22 | $13.48 | USPS Ground Advantage | 2 | 0.50 lbs | $7.98 | $6.25 | $1.73 |
| 235201 | 2026-05-26 | $24.23 | USPS Ground Advantage | 6 | 1.14 lbs | $11.69 | $9.69 | $2.00 |
| 235202 | 2026-05-24 | $13.42 | USPS Ground Advantage | 1 | 0.08 lbs | $7.00 | $6.00 | $1.00 |
| 235203 | 2026-05-26 | $12.59 | USPS Ground Advantage | 2 | 0.08 lbs | $6.97 | $5.97 | $1.00 |
| 235205 | 2026-05-28 | $12.99 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235206 | 2026-05-27 | $64.02 | USPS Ground Advantage | 1 | 0.50 lbs | $6.83 | $6.25 | $0.58 |
| 235207 | 2026-05-28 | $11.36 | USPS Ground Advantage | 1 | 0.04 lbs | $6.97 | $5.97 | $1.00 |
| 235208 | 2026-05-28 | $14.44 | USPS Ground Advantage | 4 | 0.04 lbs | $7.00 | $6.00 | $1.00 |
| 235214 | 2026-06-01 | $9.91 | USPS Ground Advantage | 1 | 0.02 lbs | $6.40 | $5.40 | $1.00 |
| 235215 | 2026-06-01 | $52.76 | USPS Ground Advantage | 3 | 3.60 lbs | $7.91 | $7.07 | $0.84 |
| 235217 | 2026-06-03 | $47.19 | USPS Ground Advantage | 1 | 0.70 lbs | $7.95 | $11.67 | $-3.72 |
| 235218 | 2026-06-02 | $11.23 | USPS Ground Advantage | 1 | 0.04 lbs | $6.40 | $5.40 | $1.00 |
| 235219 | 2026-06-03 | $10.58 | USPS Ground Advantage | 1 | 0.45 lbs | $7.07 | $6.72 | $0.35 |
| 235220 | 2026-06-03 | $26.71 | USPS Ground Advantage | 1 | 3.38 lbs | $10.79 | $9.69 | $1.10 |
| 235221 | 2026-06-07 | $12.54 | USPS Ground Advantage | 2 | 0.40 lbs | $7.24 | $6.24 | $1.00 |
| 235222 | 2026-06-07 | $18.59 | USPS Ground Advantage | 2 | 0.90 lbs | $11.01 | $11.67 | $-0.66 |
| 235223 | 2026-06-08 | $65.47 | USPS Ground Advantage | 1 | 0.56 lbs | $7.52 | $6.52 | $1.00 |
| 235224 | 2026-06-09 | $22.63 | USPS Ground Advantage | 1 | 0.05 lbs | $6.72 | $5.72 | $1.00 |
| 235225 | 2026-06-08 | $13.32 | USPS Ground Advantage | 1 | 0.03 lbs | $6.83 | $5.83 | $1.00 |
| 235226 | 2026-06-09 | $13.89 | USPS Ground Advantage | 1 | 0.10 lbs | $6.97 | $5.97 | $1.00 |
| 235227 | 2026-06-12 | $65.90 | USPS Ground Advantage | 1 | 1.20 lbs | $10.64 | $9.54 | $1.10 |
| 235228 | 2026-06-12 | $40.80 | USPS Ground Advantage | 1 | 0.12 lbs | $6.97 | $5.97 | $1.00 |
| 235229 | 2026-06-11 | $10.32 | USPS Ground Advantage | 1 | 0.05 lbs | $7.00 | $6.00 | $1.00 |
| 235230 | 2026-06-13 | $26.30 | USPS Ground Advantage | 3 | 0.60 lbs | $7.37 | $6.37 | $1.00 |
| 235231 | 2026-06-13 | $24.47 | USPS Ground Advantage | 1 | 0.45 lbs | $6.97 | $5.97 | $1.00 |
| 235232 | 2026-06-14 | $56.41 | USPS Ground Advantage | 1 | 1.27 lbs | $8.02 | $7.02 | $1.00 |
| 235233 | 2026-06-15 | $11.16 | USPS Ground Advantage | 2 | 0.02 lbs | $7.00 | $6.00 | $1.00 |
| 235234 | 2026-06-17 | $29.06 | USPS Ground Advantage | 1 | 0.38 lbs | $7.24 | $6.24 | $1.00 |
| 235235 | 2026-06-16 | $11.49 | USPS Ground Advantage | 1 | 0.03 lbs | $6.83 | $5.83 | $1.00 |
| 235236 | 2026-06-16 | $34.83 | USPS Ground Advantage | 1 | 1.70 lbs | $11.43 | $9.54 | $1.89 |
| 235237 | 2026-06-17 | $14.12 | USPS Ground Advantage | 2 | 0.16 lbs | $6.62 | $5.62 | $1.00 |
| 235238 | 2026-06-19 | $56.19 | USPS Ground Advantage | 2 | 1.83 lbs | $13.97 | $15.75 | $-1.78 |
| 235239 | 2026-06-21 | $34.61 | Ground - Weight: 0.74lb | 2 | 0.74 lbs | $8.63 | $8.13 | $0.50 |
| 235241 | 2026-06-21 | $14.30 | USPS Ground Advantage | 1 | 0.08 lbs | $7.00 | $6.00 | $1.00 |
| 235242 | 2026-06-21 | $40.04 | USPS Ground Advantage | 1 | 1.20 lbs | $8.02 | $7.02 | $1.00 |
| 235243 | 2026-06-20 | $42.91 | USPS Ground Advantage | 1 | 0.75 lbs | $7.72 | $7.80 | $-0.08 |
| 235244 | 2026-06-22 | $32.47 | USPS Ground Advantage | 1 | 4.80 lbs | $15.67 | $17.29 | $-1.62 |
| 235245 | 2026-06-23 | $42.44 | USPS Ground Advantage | 1 | 0.75 lbs | $7.25 | $6.98 | $0.27 |
| 235246 | 2026-06-23 | $9.97 | USPS Ground Advantage | 3 | 0.03 lbs | $6.97 | $5.97 | $1.00 |
| 235247 | 2026-06-25 | $12.88 | USPS Ground Advantage | 3 | 0.06 lbs | $6.97 | $6.24 | $0.73 |
| 235248 | 2026-06-25 | $18.95 | USPS Ground Advantage | 2 | 0.10 lbs | $6.83 | $5.83 | $1.00 |
| 235249 | 2026-06-25 | $20.16 | USPS Ground Advantage | 1 | 0.20 lbs | $6.97 | $6.24 | $0.73 |
| 235250 | 2026-06-26 | $10.79 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235251 | 2026-06-26 | $9.99 | USPS Ground Advantage | 1 | 0.15 lbs | $6.48 | $5.89 | $0.59 |
| 235252 | 2026-06-27 | $10.70 | USPS Ground Advantage | 1 | 0.10 lbs | $6.92 | $5.97 | $0.95 |
| 235253 | 2026-06-28 | $12.68 | USPS Ground Advantage | 1 | 0.01 lbs | $6.97 | $5.97 | $1.00 |
| 235254 | 2026-06-28 | $10.35 | USPS Ground Advantage | 1 | 0.08 lbs | $6.40 | $5.40 | $1.00 |
| 235255 | 2026-06-29 | $21.83 | USPS Ground Advantage | 6 | 1.50 lbs | $7.07 | $9.94 | $-2.87 |
| 235256 | 2026-07-01 | $17.33 | USPS Ground Advantage | 1 | 0.31 lbs | $7.66 | $6.56 | $1.10 |
| 235257 | 2026-07-01 | $13.92 | USPS Ground Advantage | 1 | 0.08 lbs | $6.62 | $5.62 | $1.00 |
| 235258 | 2026-07-01 | $25.05 | USPS Ground Advantage | 1 | 0.01 lbs | $6.40 | $5.40 | $1.00 |
| 235260 | 2026-07-04 | $32.59 | USPS Ground Advantage | 1 | 5.20 lbs | $8.22 | $6.98 | $1.24 |
| 235261 | 2026-07-03 | $17.71 | USPS Ground Advantage | 1 | 0.15 lbs | $6.72 | $5.72 | $1.00 |
| 235262 | 2026-07-05 | $11.11 | USPS Ground Advantage | 1 | 0.05 lbs | $6.72 | $5.72 | $1.00 |
| 235263 | 2026-07-05 | $32.47 | USPS Ground Advantage | 1 | 4.80 lbs | $15.67 | $20.36 | $-4.69 |
| 235265 | 2026-07-06 | $12.33 | USPS Ground Advantage | 2 | 0.12 lbs | $6.97 | $5.97 | $1.00 |
| 235267 | 2026-07-08 | $13.70 | USPS Ground Advantage | 1 | 0.10 lbs | $22.44 | $3.61 | $18.83 |
| 235268 | 2026-07-08 | $29.87 | USPS Ground Advantage | 1 | 1.00 lbs | $8.02 | $3.61 | $4.41 |
| 235274 | 2026-07-12 | $19.25 | USPS Ground Advantage | 1 | 0.05 lbs | $9.40 | $8.40 | $1.00 |
| 235275 | 2026-07-11 | $28.11 | USPS Ground Advantage | 4 | 1.80 lbs | $13.87 | $25.74 | $-11.87 |
| 235276 | 2026-07-11 | $13.29 | USPS Ground Advantage | 1 | 0.04 lbs | $6.40 | $5.40 | $1.00 |
| 235277 | 2026-07-13 | $12.63 | USPS Ground Advantage | 3 | 0.03 lbs | $6.72 | $5.72 | $1.00 |
| 235278 | 2026-07-14 | $27.05 | USPS Ground Advantage | 1 | 0.25 lbs | $8.86 | $7.86 | $1.00 |
| 235279 | 2026-07-15 | $13.03 | USPS Ground Advantage | 1 | 0.05 lbs | $6.97 | $5.97 | $1.00 |
| 235281 | 2026-07-15 | $18.52 | USPS Ground Advantage | 1 | 0.20 lbs | $8.69 | $7.69 | $1.00 |
| 235282 | 2026-07-15 | $17.50 | USPS Ground Advantage | 1 | 0.07 lbs | $6.24 | $5.24 | $1.00 |
| 235283 | 2026-07-17 | $62.26 | UPS Ground | 1 | 1.27 lbs | $13.87 | $8.49 | $5.38 |
| 235284 | 2026-07-16 | $23.12 | USPS Ground Advantage | 1 | 0.48 lbs | $9.40 | $8.40 | $1.00 |
| 235285 | 2026-07-17 | $10.52 | USPS Ground Advantage | 1 | 0.05 lbs | $6.48 | $5.48 | $1.00 |
| 235286 | 2026-07-18 | $11.86 | USPS Ground Advantage | 4 | 1.00 lbs | $23.27 | $11.84 | $11.43 |
| 235287 | 2026-07-17 | $14.63 | USPS Ground Advantage | 1 | 0.04 lbs | $6.72 | $5.72 | $1.00 |
| 235288 | 2026-07-18 | $10.05 | USPS Ground Advantage | 1 | 0.45 lbs | $7.07 | $6.07 | $1.00 |
| 235289 | 2026-07-18 | $59.35 | USPS Ground Advantage | 1 | 5.15 lbs | $18.22 | $21.19 | $-2.97 |
| 235290 | 2026-07-18 | $22.90 | USPS Ground Advantage | 1 | 0.70 lbs | $7.95 | $8.13 | $-0.18 |
| 235292 | 2026-07-19 | $10.13 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235293 | 2026-07-21 | $36.82 | USPS Ground Advantage | 10 | 5.30 lbs | $13.94 | $13.99 | $-0.05 |
| 235295 | 2026-07-21 | $13.50 | USPS Ground Advantage | 1 | 0.20 lbs | $6.48 | $5.48 | $1.00 |
| 235296 | 2026-07-23 | $0.00 | USPS Ground Advantage | 0 | 0.00 lbs | $12.80 | $6.25 | $6.55 |
| 235297 | 2026-07-22 | $10.36 | USPS Ground Advantage | 1 | 0.03 lbs | $6.40 | $5.40 | $1.00 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |