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 |
|---|---|---|---|---|---|---|---|---|
| 213204 | 2020-06-27 | $68.98 | Priority Mail 2-Day | 4 | 1.22 lbs | $8.49 | $8.14 | $0.35 |
| 213205 | 2020-06-27 | $42.31 | USPSFirstClass | 5 | 2.00 lbs | $21.27 | $8.12 | $13.15 |
| 213206 | 2020-06-27 | $24.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.41 lbs | $8.00 | $7.65 | $0.35 |
| 213207 | 2020-06-27 | $14.39 | First-Class Mail Stamped Letter | 11 | 0.12 lbs | $3.50 | $2.84 | $0.66 |
| 213208 | 2020-06-27 | $11.59 | USPSFirstClass | 3 | 0.03 lbs | $4.12 | $2.93 | $1.19 |
| 213210 | 2020-06-27 | $74.77 | Priority Mail 2-Day | 12 | 2.23 lbs | $10.39 | $9.54 | $0.85 |
| 213211 | 2020-06-27 | $40.82 | Priority Mail 2-Day | 2 | 0.69 lbs | $10.84 | $7.75 | $3.09 |
| 213212 | 2020-06-27 | $39.92 | First-Class Package Service | 7 | 0.63 lbs | $4.43 | $4.18 | $0.25 |
| 213213 | 2020-06-28 | $24.32 | USPSFirstClass | 1 | 0.15 lbs | $4.80 | $3.25 | $1.55 |
| 213214 | 2020-06-27 | $22.49 | First-Class Package Service | 4 | 0.43 lbs | $4.43 | $4.18 | $0.25 |
| 213216 | 2020-06-28 | $12.86 | USPSFirstClass | 1 | 0.07 lbs | $4.39 | $2.93 | $1.46 |
| 213218 | 2020-06-28 | $21.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.38 lbs | $8.00 | $7.65 | $0.35 |
| 213219 | 2020-06-28 | $11.87 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.50 | $3.39 | $0.11 |
| 213221 | 2020-06-28 | $28.65 | Priority Mail 2-Day | 2 | 2.23 lbs | $9.44 | $8.59 | $0.85 |
| 213222 | 2020-06-28 | $11.92 | USPSFirstClass | 1 | 0.10 lbs | $4.35 | $2.93 | $1.42 |
| 213223 | 2020-06-28 | $23.54 | First-Class Package Service | 1 | 0.60 lbs | $4.25 | $5.12 | $-0.87 |
| 213225 | 2020-06-28 | $32.29 | USPSFirstClass | 4 | 1.80 lbs | $16.36 | $8.59 | $7.77 |
| 213226 | 2020-06-28 | $173.16 | Ground | 5 | 9.07 lbs | $33.51 | $26.47 | $7.04 |
| 213227 | 2020-06-28 | $22.58 | Priority Mail 3-Day | 3 | 0.21 lbs | $8.41 | $7.56 | $0.85 |
| 213228 | 2020-06-28 | $43.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.26 lbs | $8.00 | $7.75 | $0.25 |
| 213229 | 2020-06-28 | $33.35 | First-Class Package Service | 2 | 0.55 lbs | $4.63 | $4.18 | $0.45 |
| 213230 | 2020-06-28 | $14.19 | First-Class Package Service | 4 | 0.47 lbs | $4.33 | $4.08 | $0.25 |
| 213232 | 2020-06-28 | $34.53 | Priority Mail 2-Day | 1 | 0.60 lbs | $8.65 | $8.76 | $-0.11 |
| 213239 | 2020-06-29 | $35.31 | USPSPriority | 1 | 5.30 lbs | $16.52 | $11.85 | $4.67 |
| 213240 | 2020-06-28 | $21.28 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.23 lbs | $8.50 | $7.65 | $0.85 |
| 213241 | 2020-06-28 | $34.73 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 213242 | 2020-06-28 | $19.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.30 lbs | $8.50 | $7.65 | $0.85 |
| 213244 | 2020-06-29 | $26.10 | First-Class Package Service | 5 | 0.57 lbs | $5.95 | $5.70 | $0.25 |
| 213245 | 2020-06-29 | $12.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 213246 | 2020-06-29 | $8.39 | USPSFirstClass | 1 | 0.03 lbs | $4.40 | $3.18 | $1.22 |
| 213247 | 2020-06-29 | $10.92 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 213248 | 2020-06-29 | $8.15 | First-Class Mail Stamped Letter | 5 | 0.02 lbs | $3.20 | $2.78 | $0.42 |
| 213251 | 2020-06-29 | $10.88 | First-Class Mail Stamped Letter | 2 | 0.09 lbs | $3.50 | $3.05 | $0.45 |
| 213252 | 2020-06-29 | $177.35 | Direct Link International | 7 | 4.59 lbs | $36.52 | $47.78 | $-11.26 |
| 213253 | 2020-06-29 | $7.70 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 213254 | 2020-06-29 | $7.74 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $2.84 | $0.51 |
| 213255 | 2020-06-30 | $11.98 | USPSFirstClass | 1 | 0.05 lbs | $4.39 | $3.52 | $0.87 |
| 213256 | 2020-06-29 | $5.65 | First-Class Mail Stamped Letter | 5 | 0.05 lbs | $3.20 | $2.93 | $0.27 |
| 213258 | 2020-06-30 | $191.73 | Priority Mail 3-Day | 7 | 6.85 lbs | $18.20 | $11.85 | $6.35 |
| 213259 | 2020-06-30 | $131.28 | Priority Mail 3-Day | 6 | 4.85 lbs | $15.03 | $14.18 | $0.85 |
| 213261 | 2020-06-30 | $32.68 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 213262 | 2020-06-30 | $13.88 | USPSFirstClass | 1 | 0.08 lbs | $4.44 | $2.93 | $1.51 |
| 213264 | 2020-06-30 | $7.82 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.35 | $3.05 | $0.30 |
| 213267 | 2020-06-30 | $26.26 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 213268 | 2020-06-30 | $16.41 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.50 | $2.74 | $0.76 |
| 213270 | 2020-06-30 | $24.20 | USPSFirstClass | 1 | 0.15 lbs | $4.90 | $3.39 | $1.51 |
| 213271 | 2020-06-30 | $43.30 | Priority Mail 2-Day | 1 | 1.80 lbs | $8.69 | $7.64 | $1.05 |
| 213272 | 2020-06-30 | $40.37 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.35 lbs | $8.00 | $7.75 | $0.25 |
| 213273 | 2020-06-30 | $6.98 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $3.05 | $1.14 |
| 213275 | 2020-06-30 | $33.75 | Priority Mail 2-Day | 2 | 0.82 lbs | $9.61 | $9.54 | $0.07 |
| 213276 | 2020-06-30 | $16.49 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.18 lbs | $8.00 | $7.65 | $0.35 |
| 213277 | 2020-06-30 | $122.22 | Priority Mail 2-Day | 9 | 4.16 lbs | $10.24 | $9.39 | $0.85 |
| 213278 | 2020-07-01 | $15.75 | USPSFirstClass | 2 | 0.40 lbs | $5.05 | $3.39 | $1.66 |
| 213279 | 2020-07-01 | $13.48 | USPSFirstClass | 2 | 0.30 lbs | $4.99 | $4.18 | $0.81 |
| 213281 | 2020-06-30 | $41.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.95 lbs | $8.50 | $7.65 | $0.85 |
| 213282 | 2020-06-30 | $8.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 213283 | 2020-07-01 | $6.27 | USPSFirstClass | 1 | 0.03 lbs | $4.15 | $3.18 | $0.97 |
| 213284 | 2020-07-01 | $10.32 | First-Class Mail Stamped Letter | 3 | 0.04 lbs | $3.35 | $3.18 | $0.17 |
| 213285 | 2020-07-01 | $6.19 | USPSFirstClass | 1 | 0.03 lbs | $4.00 | $2.78 | $1.22 |
| 213286 | 2020-07-01 | $16.85 | USPSFirstClass | 4 | 0.40 lbs | $8.89 | $5.27 | $3.62 |
| 213287 | 2020-07-01 | $43.13 | USPSFirstClass | 4 | 0.20 lbs | $4.35 | $5.12 | $-0.77 |
| 213288 | 2020-07-01 | $148.86 | Ground | 5 | 6.25 lbs | $25.71 | $18.99 | $6.72 |
| 213289 | 2020-07-01 | $8.35 | USPSFirstClass | 1 | 0.05 lbs | $4.10 | $2.78 | $1.32 |
| 213290 | 2020-07-01 | $62.63 | Priority Mail 2-Day | 1 | 3.55 lbs | $11.49 | $10.33 | $1.16 |
| 213291 | 2020-07-02 | $8.75 | USPSFirstClass | 1 | 0.20 lbs | $4.27 | $3.18 | $1.09 |
| 213292 | 2020-07-01 | $128.41 | Priority Mail 3-Day Large Flat Rate Box | 2 | 10.50 lbs | $19.15 | $13.20 | $5.95 |
| 213293 | 2020-07-01 | $8.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 213295 | 2020-07-02 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.78 | $0.42 |
| 213296 | 2020-07-02 | $15.33 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.35 | $2.84 | $0.51 |
| 213297 | 2020-07-02 | $51.33 | Priority Mail 2-Day | 1 | 2.35 lbs | $14.34 | $11.13 | $3.21 |
| 213298 | 2020-07-02 | $93.34 | Ground | 6 | 4.11 lbs | $21.60 | $18.87 | $2.73 |
| 213300 | 2020-07-02 | $228.40 | Ground | 1 | 14.05 lbs | $35.41 | $22.93 | $12.48 |
| 213301 | 2020-07-02 | $263.73 | Ground | 6 | 15.01 lbs | $42.49 | $29.92 | $12.57 |
| 213302 | 2020-07-02 | $22.90 | Priority Mail 2-Day Flat Rate Envelope | 10 | 0.50 lbs | $8.00 | $7.65 | $0.35 |
| 213303 | 2020-07-02 | $29.07 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.38 lbs | $8.50 | $7.65 | $0.85 |
| 213304 | 2020-07-02 | $46.93 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.31 lbs | $8.60 | $7.75 | $0.85 |
| 213305 | 2020-07-02 | $54.19 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.65 lbs | $8.50 | $7.65 | $0.85 |
| 213311 | 2020-07-02 | $15.61 | First-Class Mail Stamped Letter | 4 | 0.18 lbs | $3.65 | $2.93 | $0.72 |
| 213312 | 2020-07-03 | $25.86 | USPSFirstClass | 2 | 0.74 lbs | $10.48 | $5.54 | $4.94 |
| 213313 | 2020-07-03 | $6.92 | USPSFirstClass | 1 | 0.10 lbs | $4.12 | $2.93 | $1.19 |
| 213314 | 2020-07-03 | $12.10 | USPSFirstClass | 2 | 0.10 lbs | $4.09 | $2.78 | $1.31 |
| 213315 | 2020-07-03 | $14.59 | USPSFirstClass | 2 | 0.17 lbs | $4.21 | $3.31 | $0.90 |
| 213317 | 2020-07-03 | $49.06 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 1.80 lbs | $14.45 | $13.20 | $1.25 |
| 213318 | 2020-07-03 | $12.08 | USPSFirstClass | 2 | 0.06 lbs | $4.17 | $2.93 | $1.24 |
| 213319 | 2020-07-03 | $7.92 | USPSFirstClass | 1 | 0.03 lbs | $4.12 | $2.78 | $1.34 |
| 213320 | 2020-07-03 | $94.45 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 8.00 lbs | $14.45 | $11.13 | $3.32 |
| 213321 | 2020-07-03 | $31.29 | Priority Mail 3-Day | 10 | 2.00 lbs | $10.39 | $8.76 | $1.63 |
| 213323 | 2020-07-03 | $289.35 | Priority Mail 2-Day Medium Flat Rate Box | 10 | 12.00 lbs | $14.45 | $13.20 | $1.25 |
| 213324 | 2020-07-03 | $9.75 | USPSFirstClass | 5 | 0.10 lbs | $4.80 | $3.39 | $1.41 |
| 213325 | 2020-07-03 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $15.50 | $-7.50 |
| 213326 | 2020-07-03 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $2.93 | $0.27 |
| 213327 | 2020-07-03 | $30.32 | USPSFirstClass | 3 | 0.90 lbs | $8.34 | $7.75 | $0.59 |
| 213330 | 2020-07-03 | $26.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.42 lbs | $8.00 | $7.65 | $0.35 |
| 213332 | 2020-07-03 | $118.60 | Priority Mail 2-Day | 4 | 4.33 lbs | $10.24 | $7.75 | $2.49 |
| 213333 | 2020-07-03 | $9.20 | First-Class Package Service | 1 | 0.30 lbs | $4.25 | $2.78 | $1.47 |
| 213334 | 2020-07-03 | $11.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 213335 | 2020-07-03 | $9.52 | First-Class Package Service | 1 | 0.27 lbs | $4.53 | $4.08 | $0.45 |
| 213337 | 2020-07-03 | $47.83 | First-Class Package Service | 2 | 0.75 lbs | $5.85 | $5.40 | $0.45 |
| 213340 | 2020-07-04 | $19.84 | USPSFirstClass | 1 | 0.35 lbs | $5.55 | $3.67 | $1.88 |
| 213341 | 2020-07-03 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.50 | $7.65 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |