← Back to Import Tutorial

Standard imports — Orders

Practical guide for Excel/CSV work with UPDATE, INSERT and ARCHIVE for orders.

1) Quick decision map
Which CodOpera value should I use?
  • UPDATE: fix existing orders (by ID).
  • INSERT: create new orders (for controlled migration use cases).
  • ARCHIVE: close/archive solved orders and remove them from the active workflow (keeps history).
Operations note: in order UPDATE, focus on shipping corrections (Shipping:*) and operational fields; do not use this to “rewrite” billing/payment data.
2) Real-world use cases
  • Cancelling orders: when you need to void orders due to an operations issue (e.g., duplicates). Use CodOpera=UPDATE, identify by ID (ID), and set the cancellation date (Cancelled At) and, if needed, the reason (Cancel: Reason). Start with a small test batch.
  • Fixing shipping address: when the order exists but the shipping address is wrong and it has not shipped yet. Use CodOpera=UPDATE with ID (ID) and fill only the needed shipping fields (Shipping:*).
  • Creating new orders (migration): when moving orders between stores or creating orders in a controlled way. Use CodOpera=INSERT and define order lines (Line: Variant ID + Line: Quantity), plus any required basic fields.
  • Archiving solved orders: when you want to close orders that no longer need action and remove them from the active workflow while keeping history. Use CodOpera=ARCHIVE with the ID (ID).
3) Editable columns (visual table)
ColumnWhat it containsShopify usageApplies
Operation (CodOpera)Row actionDefines operationUPDATE/INSERT/ARCHIVE
Order ID (ID)Order IDTargets existing orderUPDATE/ARCHIVE
Note (Note)Internal noteOperational contextUPDATE/INSERT
Shipping address (Shipping:*)Shipping address fieldsLogistics correctionsUPDATE/INSERT
Cancellation (Cancelled At / Cancel: Reason)Cancellation detailsMass-cancel operationsUPDATE
Order lines (Line: Variant ID + Line: Quantity)Order linesCreates new ordersINSERT
Nextronics