Import Orders (CSV)

Import Orders (CSV)

If you have orders in a spreadsheet (Excel, Google Sheets or similar), you can bulk-import them without manual entry.

Click Import CSV in the top-right corner of the order list. A modal opens with two tabs: New Import and Import History.

Step 1 — Prepare the File

First, download the template by clicking "Download template". You get a CSV file with all available columns and one example row — the safest way to prepare your data correctly.

Required columns:

• customer_email — customer email (used to find or create the customer)
• product_sku — product SKU
• quantity — quantity (integer)

Useful optional columns:

• unit_price — override the catalog price
• payment_method — cash_on_delivery, bank_transfer, paid, credit_card, invoice
• status — initial order status
• notes — internal note
• billing_address, billing_city, billing_country, billing_postal_code
• shipping_address, shipping_city, shipping_country, shipping_postal_code
• expected_delivery_date — format YYYY-MM-DD
• location_name — warehouse/location name

Maximum rows per import: 5,000. Both comma and semicolon are accepted as delimiters, but do not mix them in the same file.

Step 2 — Column Mapping

After uploading, the system tries to automatically map your columns to system fields. You see a table with three columns: your column name, the system field it maps to, and sample data from the first few rows.

If automatic mapping is incorrect, manually select the correct field from the dropdown. Progress shows how many columns are mapped. While required columns are unmapped, the "Next" button stays locked.

Step 3 — Validation

The system checks every row:

• Whether the customer exists (or can be created)
• Whether the SKU matches a catalog product
• Whether there is enough stock
• Whether addresses are correctly formed

This may take a few seconds for larger files.

Step 4 — Preview

Before import you see a summary:

• Number of orders to be created
• Total value
• Number of errors

Rows are divided into three categories:

• Valid (green icon) — ready to import
• Warnings (yellow icon) — can be imported but have a note (e.g. partial stock)
• Errors (red icon) — cannot be imported, e.g. non-existent SKU

You can manually exclude individual rows before import, or click "Select all valid" to automatically exclude errors.

Import options:

• Allow backorders — import even when there is not enough stock
• Auto-create products — if the SKU doesn't exist, create a new product as a draft

Step 5 — Results

After import you see: how many orders were created, how many failed, and how many were skipped. If new customers or products were created, this is highlighted separately.

If some rows failed, you can download an error report as a CSV file with exact problem descriptions per row — useful for correction and re-import.