Bulk-import orders with Excel
Load many orders at once from an .xlsx file, preview, then confirm.
When you have many orders, use Orders → Import to load an .xlsx file. The safe flow: upload → the system does a dry-run check → you confirm → it runs in the background with live progress.
Use the exact template columns to avoid errors.
Required: order_number, sku, quantity. Normal shipping: also customer_name, address_line1, city, country (plus state/postal_code when needed). Shipping that needs a label: every row needs a label; name and address can be left empty, and an empty country means US. POD items: a design_sku already in your Library is enough; a new design (new or blank design_sku) also needs mockup_url; or set hire = yes to hire a designer. Optional: order_note (a note for the whole order, identical on every row of that order) and item_note (a note for that line only). Several mockup images: put several links in the mockup_url cell, separated by a comma (,) or a semicolon (;), up to 10. Full-body positions (design_full / design_full_3d): one link per piece in the same cell, separated by , or ;, in piece order, up to 7; other positions take one file.
The system validates and reports error rows before writing anything.
Accept to create the real orders; watch the background progress.
Limits: .xlsx files only, up to 50,000 rows / 10MB per file. You can queue several files; the system processes them in turn. Cancelling is only possible before the import starts creating orders.
Import history
On the import page, click View all in the Recent imports panel to open Import history: every import job, newest first, with the file name, upload time, status (Queued, Validating…, Ready to review, Waiting to import, Importing…, Completed, Failed, Cancelled) and the result (created · skipped · failed).
- File — download the original file you uploaded.
- Open — reopen that job on the import page to review, confirm or cancel it.
Staff only see imports for the stores they are assigned to. The history has no search or filter.
Frequently Asked Questions
If I re-import the same file, will I get duplicate orders?
YES. Each import creates new orders — importing the same file again creates another set of orders. The preview warns when an order_number has been used before; read it carefully before confirming. (The system only prevents duplicates when the same import job is re-run after a failure.)
Are imported orders charged automatically?
Only if Auto-payment is on. Then each order is charged if the wallet covers it; an order the wallet cannot cover stays unpaid, and orders already paid are not reversed. With Auto-payment off, every imported order is unpaid — you pay them afterwards.
Still need help?
Reach our Support team — we usually reply quickly.