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 |
|---|---|---|---|---|---|---|---|---|
| 213041 | 2020-06-21 | $23.62 | First-Class Package Service | 1 | 0.60 lbs | $4.33 | $5.27 | $-0.94 |
| 213042 | 2020-06-21 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 213043 | 2020-06-21 | $377.37 | Priority Mail 2-Day | 11 | 18.91 lbs | $55.78 | $55.45 | $0.33 |
| 213044 | 2020-06-21 | $6.98 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 213045 | 2020-06-21 | $8.48 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 213046 | 2020-06-21 | $17.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213048 | 2020-06-21 | $19.60 | Priority Mail 2-Day | 1 | 0.95 lbs | $9.61 | $8.76 | $0.85 |
| 213049 | 2020-06-22 | $9.15 | USPSFirstClass | 1 | 0.07 lbs | $4.27 | $3.05 | $1.22 |
| 213050 | 2020-06-22 | $24.11 | USPSFirstClass | 1 | 0.45 lbs | $5.74 | $4.32 | $1.42 |
| 213051 | 2020-06-22 | $34.78 | Priority Mail 3-Day | 11 | 0.53 lbs | $11.39 | $8.15 | $3.24 |
| 213052 | 2020-06-22 | $90.70 | InternationalPriorityShipping | 2 | 0.74 lbs | $10.66 | $7.65 | $3.01 |
| 213053 | 2020-06-22 | $70.58 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 1.14 lbs | $8.60 | $7.75 | $0.85 |
| 213055 | 2020-06-22 | $336.95 | Priority Mail 1-Day | 32 | 6.82 lbs | $9.30 | $8.39 | $0.91 |
| 213056 | 2020-06-22 | $56.58 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 213058 | 2020-06-22 | $26.92 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 213060 | 2020-06-22 | $11.29 | USPSFirstClass | 1 | 0.10 lbs | $4.30 | $2.84 | $1.46 |
| 213062 | 2020-06-22 | $17.12 | First-Class Package Service | 3 | 0.35 lbs | $4.45 | $3.25 | $1.20 |
| 213063 | 2020-06-22 | $5.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.05 | $0.15 |
| 213065 | 2020-06-22 | $41.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 213066 | 2020-06-22 | $92.00 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 8.00 lbs | $12.00 | $12.10 | $-0.10 |
| 213067 | 2020-06-22 | $10.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.00 | $7.65 | $0.35 |
| 213070 | 2020-06-22 | $25.20 | First-Class Package Service | 1 | 0.25 lbs | $4.57 | $5.54 | $-0.97 |
| 213071 | 2020-06-23 | $10.05 | USPSFirstClass | 1 | 0.05 lbs | $4.17 | $2.78 | $1.39 |
| 213072 | 2020-06-22 | $47.28 | Priority Mail International Padded Flat Rate Envelope | 2 | 0.10 lbs | $37.50 | $37.60 | $-0.10 |
| 213073 | 2020-06-23 | $42.49 | Priority Mail 2-Day | 2 | 1.12 lbs | $9.61 | $8.92 | $0.69 |
| 213075 | 2020-06-23 | $47.38 | Priority Mail 2-Day | 1 | 2.20 lbs | $10.39 | $8.92 | $1.47 |
| 213076 | 2020-06-23 | $13.94 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.06 lbs | $8.00 | $7.65 | $0.35 |
| 213079 | 2020-06-23 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.20 | $2.93 | $0.27 |
| 213081 | 2020-06-23 | $29.59 | Priority Mail 2-Day Flat Rate Envelope | 1 | 3.55 lbs | $8.00 | $7.75 | $0.25 |
| 213083 | 2020-06-23 | $79.87 | Priority Mail 3-Day Flat Rate Envelope | 3 | 2.17 lbs | $8.00 | $7.75 | $0.25 |
| 213085 | 2020-06-23 | $127.52 | Priority Mail 3-Day | 1 | 14.30 lbs | $21.63 | $20.78 | $0.85 |
| 213086 | 2020-06-23 | $349.17 | Ground | 10 | 16.95 lbs | $44.65 | $33.85 | $10.80 |
| 213087 | 2020-06-23 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 213088 | 2020-06-23 | $43.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 213091 | 2020-06-23 | $27.14 | First-Class Package Service | 1 | 0.50 lbs | $5.65 | $5.40 | $0.25 |
| 213092 | 2020-06-23 | $17.48 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $3.52 | $-0.02 |
| 213094 | 2020-06-23 | $20.27 | Priority Mail 3-Day Small Flat Rate Box | 3 | 0.19 lbs | $8.50 | $7.65 | $0.85 |
| 213095 | 2020-06-23 | $157.12 | Priority Mail 3-Day | 2 | 19.90 lbs | $53.14 | $34.40 | $18.74 |
| 213096 | 2020-06-24 | $8.64 | USPSFirstClass | 1 | 0.34 lbs | $4.87 | $4.00 | $0.87 |
| 213097 | 2020-06-24 | $40.03 | InternationalPriorityShipping | 1 | 0.05 lbs | $4.55 | $2.93 | $1.62 |
| 213098 | 2020-06-24 | $12.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.10 lbs | $8.00 | $7.15 | $0.85 |
| 213099 | 2020-06-24 | $37.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.27 lbs | $8.00 | $7.65 | $0.35 |
| 213100 | 2020-06-24 | $9.89 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $3.25 | $0.94 |
| 213103 | 2020-06-24 | $5.89 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.93 | $0.57 |
| 213106 | 2020-06-24 | $213.99 | Priority Mail 2-Day | 1 | 14.05 lbs | $21.00 | $19.53 | $1.47 |
| 213124 | 2020-06-24 | $9.75 | USPSFirstClass | 1 | 0.05 lbs | $4.29 | $3.05 | $1.24 |
| 213125 | 2020-06-24 | $60.79 | Priority Mail 3-Day | 2 | 2.29 lbs | $14.34 | $10.53 | $3.81 |
| 213126 | 2020-06-25 | $43.88 | USPSFirstClass | 10 | 2.00 lbs | $21.52 | $9.54 | $11.98 |
| 213127 | 2020-06-25 | $13.78 | USPSFirstClass | 1 | 0.18 lbs | $4.42 | $3.39 | $1.03 |
| 213129 | 2020-06-24 | $22.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $7.65 | $0.35 |
| 213130 | 2020-06-24 | $95.94 | Priority Mail 3-Day | 1 | 8.55 lbs | $11.95 | $11.10 | $0.85 |
| 213131 | 2020-06-25 | $10.07 | USPSFirstClass | 2 | 0.34 lbs | $4.82 | $4.00 | $0.82 |
| 213132 | 2020-06-25 | $108.57 | Priority Mail 3-Day | 4 | 1.80 lbs | $15.01 | $13.65 | $1.36 |
| 213133 | 2020-06-25 | $19.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213134 | 2020-06-25 | $14.93 | USPSFirstClass | 2 | 0.07 lbs | $8.24 | $3.31 | $4.93 |
| 213135 | 2020-06-25 | $6.34 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $2.84 | $0.51 |
| 213136 | 2020-06-25 | $18.96 | Priority Mail 2-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 213138 | 2020-06-25 | $48.83 | Priority Mail 2-Day | 1 | 1.20 lbs | $12.04 | $11.19 | $0.85 |
| 213140 | 2020-06-25 | $37.87 | Priority Mail 3-Day Small Flat Rate Box | 3 | 0.95 lbs | $8.50 | $7.65 | $0.85 |
| 213141 | 2020-06-25 | $42.87 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.80 lbs | $8.00 | $7.75 | $0.25 |
| 213142 | 2020-06-25 | $9.83 | First-Class Mail Stamped Letter | 2 | 0.03 lbs | $3.35 | $2.84 | $0.51 |
| 213143 | 2020-06-25 | $58.55 | Priority Mail 2-Day Medium Flat Rate Box | 10 | 3.41 lbs | $14.45 | $13.20 | $1.25 |
| 213144 | 2020-06-26 | $136.40 | USPSFirstClass | 10 | 5.00 lbs | $46.50 | $26.63 | $19.87 |
| 213145 | 2020-06-25 | $13.07 | First-Class Package Service - Retail | 1 | 0.08 lbs | $5.60 | $3.31 | $2.29 |
| 213147 | 2020-06-26 | $21.73 | InternationalPriorityShipping | 1 | 0.03 lbs | $4.17 | $2.93 | $1.24 |
| 213148 | 2020-06-25 | $94.27 | Ground | 5 | 2.80 lbs | $26.32 | $10.33 | $15.99 |
| 213150 | 2020-06-25 | $14.57 | First-Class Package Service | 4 | 0.47 lbs | $4.71 | $4.46 | $0.25 |
| 213154 | 2020-06-25 | $5.84 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $3.18 | $0.17 |
| 213156 | 2020-06-26 | $20.49 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 213157 | 2020-06-26 | $34.73 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 213158 | 2020-06-26 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.50 | $7.65 | $0.85 |
| 213163 | 2020-06-26 | $404.51 | Ground | 11 | 15.45 lbs | $27.96 | $29.23 | $-1.27 |
| 213164 | 2020-06-26 | $575.40 | Ground | 13 | 34.95 lbs | $80.00 | $56.44 | $23.56 |
| 213165 | 2020-06-26 | $248.55 | Ground | 10 | 9.68 lbs | $33.84 | $22.91 | $10.93 |
| 213166 | 2020-06-26 | $41.15 | Priority Mail 2-Day | 9 | 1.14 lbs | $10.84 | $9.98 | $0.86 |
| 213167 | 2020-06-26 | $7.51 | USPSFirstClass | 1 | 0.07 lbs | $4.14 | $2.93 | $1.21 |
| 213170 | 2020-06-26 | $9.76 | First-Class Package Service | 1 | 0.40 lbs | $4.77 | $4.32 | $0.45 |
| 213171 | 2020-06-26 | $20.40 | USPSFirstClass | 2 | 0.60 lbs | $5.74 | $5.12 | $0.62 |
| 213172 | 2020-06-26 | $40.96 | Priority Mail 2-Day | 1 | 0.75 lbs | $8.97 | $8.12 | $0.85 |
| 213173 | 2020-06-26 | $28.08 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.65 lbs | $8.50 | $7.65 | $0.85 |
| 213174 | 2020-06-26 | $52.47 | Ground | 1 | 20.00 lbs | $33.56 | $29.46 | $4.10 |
| 213177 | 2020-06-26 | $94.45 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 8.00 lbs | $14.45 | $11.13 | $3.32 |
| 213180 | 2020-06-26 | $70.56 | Priority Mail 2-Day | 4 | 1.20 lbs | $10.84 | $9.98 | $0.86 |
| 213181 | 2020-06-26 | $24.48 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 213182 | 2020-06-26 | $29.49 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 213184 | 2020-06-27 | $17.96 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.50 lbs | $8.00 | $7.75 | $0.25 |
| 213185 | 2020-06-27 | $174.45 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 16.00 lbs | $14.45 | $10.53 | $3.92 |
| 213187 | 2020-06-27 | $4.34 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $3.05 | $0.30 |
| 213188 | 2020-06-27 | $7.85 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.05 | $0.45 |
| 213189 | 2020-06-27 | $8.10 | USPSFirstClass | 1 | 0.03 lbs | $4.09 | $2.78 | $1.31 |
| 213190 | 2020-06-27 | $37.47 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.50 lbs | $8.50 | $7.65 | $0.85 |
| 213191 | 2020-06-27 | $27.51 | Direct Link International | 1 | 0.08 lbs | $18.72 | $7.58 | $11.14 |
| 213192 | 2020-06-27 | $159.22 | Priority Mail 2-Day | 5 | 6.30 lbs | $19.47 | $11.49 | $7.98 |
| 213193 | 2020-06-27 | $59.65 | Priority Mail 3-Day Padded Flat Rate Envelope | 5 | 1.45 lbs | $8.60 | $7.65 | $0.95 |
| 213194 | 2020-06-27 | $8.32 | First-Class Mail Stamped Letter | 3 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 213195 | 2020-06-27 | $14.76 | First-Class Mail Stamped Letter | 4 | 0.08 lbs | $3.35 | $3.18 | $0.17 |
| 213197 | 2020-06-27 | $21.59 | First-Class Mail Stamped Letter | 6 | 0.16 lbs | $3.65 | $3.52 | $0.13 |
| 213198 | 2020-06-27 | $9.00 | USPSFirstClass | 2 | 0.10 lbs | $4.02 | $2.78 | $1.24 |
| 213199 | 2020-06-27 | $9.83 | First-Class Mail Stamped Letter | 2 | 0.07 lbs | $3.35 | $2.84 | $0.51 |
| 213202 | 2020-06-27 | $11.18 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.20 | $2.93 | $0.27 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |