Practical guide for Excel/CSV work with UPDATE, INSERT and ARCHIVE for orders.
| Column | What it contains | Shopify usage | Applies |
|---|---|---|---|
| Operation (CodOpera) | Row action | Defines operation | UPDATE/INSERT/ARCHIVE |
| Order ID (ID) | Order ID | Targets existing order | UPDATE/ARCHIVE |
| Note (Note) | Internal note | Operational context | UPDATE/INSERT |
| Shipping address (Shipping:*) | Shipping address fields | Logistics corrections | UPDATE/INSERT |
| Cancellation (Cancelled At / Cancel: Reason) | Cancellation details | Mass-cancel operations | UPDATE |
| Order lines (Line: Variant ID + Line: Quantity) | Order lines | Creates new orders | INSERT |