Stop storing the order total
It is the sum of the order's items and can drift from them. Nothing records why it is stored.
Costs: Every read of an order sums its items.
1 collection
| − | orders.total_cents | integer (required) |
Each card is one decision on its own. Answer with the ids, for example
P1 yes, P2 no — left open means nothing happens.
It is the sum of the order's items and can drift from them. Nothing records why it is stored.
Costs: Every read of an order sums its items.
1 collection
| − | orders.total_cents | integer (required) |
An address edited later must not change where an old order went.
Costs: Addresses are copied instead of referenced, and open orders need one migration.
1 collection · 1 relationship
| − | orders.shipping_address_id | uuid |
| + | orders.ship_to | jsonb (document) |
− relationship
addresses → orders removed
Nothing reads them since the old shop was switched off.
Costs: A one-way change: the old ids cannot be recovered afterwards.
2 collections
| − | customers.legacy_id | text |
| − | orders.legacy_ref | text |
Unaccounted for: added field products.weight_grams. That belongs on a card, or it would arrive unasked.