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 |
|---|---|---|---|---|---|---|---|---|
| 214107 | 2020-08-01 | $24.38 | Priority Mail 3-Day Small Flat Rate Box | 12 | 3.19 lbs | $8.50 | $7.65 | $0.85 |
| 214110 | 2020-08-01 | $48.50 | USPSFirstClass | 1 | 0.58 lbs | $7.65 | $4.46 | $3.19 |
| 214112 | 2020-08-01 | $8.48 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.18 | $0.32 |
| 214113 | 2020-08-01 | $20.16 | Priority Mail 3-Day Small Flat Rate Box | 4 | 0.38 lbs | $8.50 | $7.65 | $0.85 |
| 214114 | 2020-08-01 | $8.96 | First-Class Mail Stamped Letter | 4 | 0.10 lbs | $3.50 | $3.18 | $0.32 |
| 214119 | 2020-08-01 | $21.74 | First-Class Package Service | 1 | 0.49 lbs | $5.95 | $3.67 | $2.28 |
| 214120 | 2020-08-01 | $12.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.00 | $7.65 | $0.35 |
| 214122 | 2020-08-01 | $10.92 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.18 | $0.32 |
| 214124 | 2020-08-01 | $9.13 | USPSFirstClass | 1 | 0.04 lbs | $4.24 | $2.93 | $1.31 |
| 214125 | 2020-08-01 | $60.93 | Priority Mail 2-Day | 8 | 1.31 lbs | $13.00 | $7.65 | $5.35 |
| 214131 | 2020-08-01 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 214135 | 2020-08-02 | $82.98 | Priority Mail 3-Day | 3 | 3.10 lbs | $15.01 | $14.16 | $0.85 |
| 214136 | 2020-08-02 | $14.47 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.13 lbs | $8.50 | $7.65 | $0.85 |
| 214138 | 2020-08-02 | $22.90 | Priority Mail 2-Day Flat Rate Envelope | 10 | 0.50 lbs | $8.00 | $7.65 | $0.35 |
| 214140 | 2020-08-02 | $157.63 | Priority Mail 2-Day | 1 | 12.25 lbs | $36.91 | $36.06 | $0.85 |
| 214141 | 2020-08-02 | $67.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.45 lbs | $8.00 | $7.75 | $0.25 |
| 214142 | 2020-08-02 | $71.17 | Priority Mail 3-Day | 1 | 3.50 lbs | $11.18 | $10.64 | $0.54 |
| 214144 | 2020-08-02 | $50.53 | Priority Mail 3-Day Medium Flat Rate Box | 2 | 3.40 lbs | $14.45 | $13.20 | $1.25 |
| 214146 | 2020-08-02 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 3.55 lbs | $8.00 | $7.75 | $0.25 |
| 214147 | 2020-08-02 | $15.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.07 lbs | $8.00 | $7.65 | $0.35 |
| 214148 | 2020-08-02 | $27.04 | USPSFirstClass | 1 | 0.40 lbs | $6.05 | $4.46 | $1.59 |
| 214149 | 2020-08-02 | $11.49 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.00 | $7.15 | $0.85 |
| 214152 | 2020-08-02 | $164.72 | Priority Mail 1-Day | 19 | 3.98 lbs | $8.89 | $8.04 | $0.85 |
| 214153 | 2020-08-02 | $7.39 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.31 | $0.19 |
| 214154 | 2020-08-02 | $43.96 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.59 lbs | $8.00 | $7.65 | $0.35 |
| 214155 | 2020-08-02 | $24.00 | First-Class Package Service | 1 | 0.60 lbs | $4.71 | $5.70 | $-0.99 |
| 214156 | 2020-08-02 | $8.25 | First-Class Mail Stamped Letter | 10 | 0.10 lbs | $3.35 | $2.93 | $0.42 |
| 214158 | 2020-08-02 | $10.61 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $7.65 | $0.35 |
| 214160 | 2020-08-02 | $9.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $3.18 | $4.82 |
| 214161 | 2020-08-02 | $9.08 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $2.84 | $1.35 |
| 214164 | 2020-08-02 | $9.14 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.65 | $3.67 | $-0.02 |
| 214165 | 2020-08-02 | $186.55 | Ground | 2 | 15.35 lbs | $33.77 | $23.72 | $10.05 |
| 214166 | 2020-08-02 | $11.30 | First-Class Mail Stamped Letter | 5 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 214168 | 2020-08-02 | $27.93 | Priority Mail 2-Day Flat Rate Envelope | 7 | 0.66 lbs | $8.00 | $7.75 | $0.25 |
| 214170 | 2020-08-02 | $58.90 | Priority Mail 2-Day | 3 | 2.60 lbs | $9.44 | $7.75 | $1.69 |
| 214171 | 2020-08-03 | $9.84 | USPSFirstClass | 1 | 0.10 lbs | $4.16 | $2.78 | $1.38 |
| 214172 | 2020-08-02 | $133.41 | Priority Mail 2-Day Medium Flat Rate Box | 4 | 9.73 lbs | $14.45 | $13.20 | $1.25 |
| 214174 | 2020-08-02 | $18.21 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 214175 | 2020-08-02 | $31.89 | Ground | 4 | 0.76 lbs | $15.93 | $13.43 | $2.50 |
| 214176 | 2020-08-03 | $10.06 | USPSFirstClass | 1 | 0.07 lbs | $4.20 | $2.84 | $1.36 |
| 214177 | 2020-08-03 | $7.16 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.20 | $2.78 | $0.42 |
| 214178 | 2020-08-03 | $7.16 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.20 | $2.78 | $0.42 |
| 214180 | 2020-08-03 | $10.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 214181 | 2020-08-03 | $69.26 | Priority Mail 2-Day | 1 | 5.80 lbs | $21.31 | $20.46 | $0.85 |
| 214182 | 2020-08-03 | $67.61 | Priority Mail 2-Day | 2 | 2.05 lbs | $14.34 | $11.13 | $3.21 |
| 214183 | 2020-08-03 | $15.98 | USPSFirstClass | 1 | 0.20 lbs | $4.71 | $3.67 | $1.04 |
| 214184 | 2020-08-03 | $15.98 | USPSFirstClass | 1 | 0.20 lbs | $4.71 | $3.67 | $1.04 |
| 214185 | 2020-08-03 | $20.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 214187 | 2020-08-03 | $61.39 | Priority Mail 2-Day Medium Flat Rate Box | 4 | 2.74 lbs | $14.45 | $12.10 | $2.35 |
| 214188 | 2020-08-03 | $48.59 | USPSFirstClass | 1 | 0.45 lbs | $6.65 | $5.12 | $1.53 |
| 214189 | 2020-08-03 | $17.63 | USPSFirstClass | 1 | 0.40 lbs | $5.45 | $4.32 | $1.13 |
| 214190 | 2020-08-03 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 214192 | 2020-08-03 | $28.32 | Priority Mail 1-Day Flat Rate Envelope | 3 | 0.48 lbs | $8.00 | $7.65 | $0.35 |
| 214193 | 2020-08-03 | $24.00 | First-Class Package Service | 1 | 0.60 lbs | $4.71 | $5.70 | $-0.99 |
| 214195 | 2020-08-03 | $89.81 | Priority Mail 3-Day | 3 | 4.30 lbs | $10.24 | $9.50 | $0.74 |
| 214196 | 2020-08-03 | $12.97 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.22 lbs | $8.00 | $7.65 | $0.35 |
| 214197 | 2020-08-03 | $7.16 | USPSFirstClass | 1 | 0.10 lbs | $4.04 | $2.78 | $1.26 |
| 214198 | 2020-08-03 | $19.43 | Priority Mail 1-Day Small Flat Rate Box | 1 | 0.29 lbs | $8.50 | $7.65 | $0.85 |
| 214199 | 2020-08-03 | $13.22 | First-Class Package Service | 1 | 0.13 lbs | $3.23 | $3.25 | $-0.02 |
| 214200 | 2020-08-03 | $11.48 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.24 lbs | $8.00 | $7.65 | $0.35 |
| 214201 | 2020-08-04 | $15.51 | USPSFirstClass | 1 | 0.20 lbs | $4.41 | $3.25 | $1.16 |
| 214202 | 2020-08-04 | $16.33 | USPSFirstClass | 1 | 0.10 lbs | $4.45 | $2.78 | $1.67 |
| 214203 | 2020-08-03 | $151.02 | Priority Mail 3-Day | 5 | 5.25 lbs | $25.37 | $27.95 | $-2.58 |
| 214206 | 2020-08-03 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 214207 | 2020-08-04 | $7.81 | USPSFirstClass | 1 | 0.05 lbs | $4.07 | $2.78 | $1.29 |
| 214209 | 2020-08-03 | $15.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.09 lbs | $8.50 | $7.65 | $0.85 |
| 214210 | 2020-08-04 | $8.92 | USPSFirstClass | 1 | 0.07 lbs | $4.12 | $2.78 | $1.34 |
| 214211 | 2020-08-03 | $12.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 214212 | 2020-08-03 | $43.80 | First-Class Package Service | 3 | 0.48 lbs | $4.43 | $4.18 | $0.25 |
| 214213 | 2020-08-03 | $8.91 | First-Class Package Service | 1 | 0.25 lbs | $4.12 | $3.67 | $0.45 |
| 214215 | 2020-08-04 | $4.67 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 214219 | 2020-08-04 | $67.84 | Priority Mail 2-Day | 1 | 3.60 lbs | $10.24 | $9.07 | $1.17 |
| 214220 | 2020-08-04 | $6.56 | USPSFirstClass | 1 | 0.01 lbs | $4.07 | $2.84 | $1.23 |
| 214221 | 2020-08-04 | $8.30 | First-Class Mail Stamped Letter | 5 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 214222 | 2020-08-04 | $51.95 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 214223 | 2020-08-04 | $435.83 | Ground | 21 | 17.21 lbs | $29.63 | $36.66 | $-7.03 |
| 214225 | 2020-08-04 | $126.46 | Priority Mail 2-Day | 1 | 10.85 lbs | $19.47 | $16.89 | $2.58 |
| 214226 | 2020-08-04 | $9.47 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.50 | $2.78 | $0.72 |
| 214228 | 2020-08-04 | $17.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.95 lbs | $8.50 | $7.65 | $0.85 |
| 214232 | 2020-08-04 | $63.51 | Priority Mail 2-Day | 3 | 1.61 lbs | $12.04 | $11.18 | $0.86 |
| 214234 | 2020-08-04 | $9.44 | USPSFirstClass | 1 | 0.05 lbs | $4.45 | $3.18 | $1.27 |
| 214235 | 2020-08-04 | $15.62 | USPSFirstClass | 1 | 0.20 lbs | $4.41 | $2.78 | $1.63 |
| 214238 | 2020-08-05 | $48.73 | USPSFirstClass | 6 | 2.40 lbs | $24.57 | $8.59 | $15.98 |
| 214239 | 2020-08-05 | $8.24 | USPSFirstClass | 1 | 0.05 lbs | $4.25 | $3.05 | $1.20 |
| 214240 | 2020-08-04 | $42.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.35 lbs | $8.00 | $7.65 | $0.35 |
| 214242 | 2020-08-04 | $49.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.60 lbs | $8.00 | $7.65 | $0.35 |
| 214244 | 2020-08-04 | $21.26 | Priority Mail 2-Day | 1 | 0.68 lbs | $9.27 | $8.42 | $0.85 |
| 214245 | 2020-08-05 | $8.34 | USPSFirstClass | 1 | 0.03 lbs | $4.22 | $3.05 | $1.17 |
| 214246 | 2020-08-05 | $17.10 | USPSFirstClass | 1 | 0.60 lbs | $6.01 | $5.40 | $0.61 |
| 214247 | 2020-08-05 | $47.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 4.00 lbs | $8.00 | $7.65 | $0.35 |
| 214248 | 2020-08-05 | $16.39 | First-Class Mail Stamped Letter | 7 | 0.11 lbs | $3.50 | $3.05 | $0.45 |
| 214249 | 2020-08-05 | $49.30 | USPSFirstClass | 1 | 0.45 lbs | $6.85 | $4.32 | $2.53 |
| 214254 | 2020-08-05 | $7.83 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 214255 | 2020-08-05 | $16.32 | First-Class Package Service | 1 | 0.55 lbs | $4.53 | $4.08 | $0.45 |
| 214256 | 2020-08-05 | $30.19 | First-Class Package Service | 5 | 0.40 lbs | $3.84 | $3.39 | $0.45 |
| 214257 | 2020-08-05 | $133.07 | Priority Mail 2-Day Padded Flat Rate Envelope | 3 | 3.78 lbs | $8.60 | $7.65 | $0.95 |
| 214258 | 2020-08-05 | $110.48 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.50 lbs | $8.00 | $7.65 | $0.35 |
| 214261 | 2020-08-05 | $75.15 | Priority Mail 3-Day Medium Flat Rate Box | 10 | 1.84 lbs | $14.45 | $13.20 | $1.25 |
| 214262 | 2020-08-05 | $24.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.65 | $0.35 |
| 214263 | 2020-08-05 | $41.29 | 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 |